Master SQL Queries From Basic to Advanced
0h 0m 0s
English
Paid
Course description
The course is designed for developers, data analysts, and anyone working with databases. It covers the entire range of SQL queries - from basics to advanced techniques. The training is structured in a text format with an integrated programming environment, allowing you to immediately apply the acquired knowledge in practice.
Read more about the course
Topics Covered in the Course
- Introduction to Databases and SQL: the concept of databases, types of queries, basics of SQL.
- SQL Basics: SELECT statements, filtering with WHERE, sorting with ORDER BY, working with NULL, and other basic operations.
- Advanced Topics: aggregations, subqueries, joins (JOIN), window functions, and query optimization.
Comments
0 commentsWant to join the conversation?
Sign in to commentSimilar courses
Mastery with SQL
Sources: masterywithsql.com
Packed with high quality videos, practical examples, and interesting and challenging exercises to practice what you've learned. The course is broad and deep, taking you from beg...
9 hours 15 minutes 2 seconds
Database DevOps from Start to Finish
Sources: iamtimcorey.com (Tim Corey)
If you have only ever built a database using SQL Server Management Studio (SSMS), you are in for a treat. SQL Server Data Tools (SSDT) is designed for building
2 hours 40 minutes 37 seconds
Ludicrous Speed Postgres
Sources: Creston Jamison
This course is dedicated to optimizing PostgreSQL performance with a focus on proper schema design and efficient database usage. It is designed for those...
12 hours 27 minutes 44 seconds
The Complete SQL Bootcamp: Go from Zero to Hero
Sources: udemy
You'll learn how to read and write complex queries to a database using one of the most in demand skills - PostgreSQL. These skills are also applicable to any ot
8 hours 45 minutes 49 seconds