Advanced SQL

This course is suitable for those who already know the basics of SQL and want to learn more about its capabilities. You will expand your data processing tools, understand replication, scaling, functions and triggers. You will have a better idea of ​​where to grow next.

To learn advanced SQL, you need to

• Understand the relational model
• Know DDL and DML< /li>
• Understand the features of working with different types of data
• Be able to connect, aggregate and group data
• Be able to work with complex queries and window functions
• Know , where the documentation is located and not be afraid to use it

In the course you will learn

1. Understand data structures, how they are normalized and denormalized
2. Design and administer databases
3. Scaling a database management system in PostgreSQL
4. Write stored procedures and triggers
5. Raise and configure clusters, shard data
6. Integrate SQL with other services and applications