Quick start in SQL

Master one of the essential data tools every IT professional needs. SQL helps to structure data and extract the necessary information. This tool is required by almost any IT specialist: data engineers, analysts, developers. The ability to work with data is also valued in the labor market in related fields: marketing, finance, management.

What you will learn:

• 1. Concepts and syntax of SQL queries
• 2. Combining data from different sources
• 3. Aggregation
• 4. Data storage patterns
• 5. Development of database architecture
• 6. Data cleaning and sanitization
• 7. Solving analytical problems using SQL
• 8. Fundamental commands for working with NoSQL

Contents:

• Module 1 - Fundamentals and basic fetch syntax
• Module 2 - Creating a table and filling it with data, restrictions on fields, Changing and deleting data
• Module 3 - join
• Module 4 - Aggregation and grouping
• Module 5 - Practice