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
.webp){kind=small}
.webp){kind=small}
.webp){kind=small}
