About Course
Master SQL step-by-step, from beginner to advanced levels, with expert guidance from Gyan on Tube. Learn PostgreSQL, joins, subqueries, aggregate functions, and much more. Build a solid foundation and enhance your data manipulation and querying skills. This course is perfect for aspiring data analysts and developers.
Course Content
1. Beginners To Advanced SQL Full Course
-
Click to Start
05:13
2. How to Install PostgreSQL
3. Install PG Admin 4 in PostgreSQL
4. Connect Database in PostgreSQL
5. Using SELECT & FROM with Challenges
6. Using DISTINCT in SQL
7. COUNT Function in SQL
8. Applying WHERE with OR & AND
9. ORDER BY in SQL
10. LIMIT Query in PostgreSQL
11. Using BETWEEN Clause in SQL
12. IN Statement in SQL
13. LIKE & ILIKE in SQL
14. Top 5 Aggregate Functions in SQL
15. AS Statement in PostgreSQL
16. Using INNER JOIN in SQL
17. FULL OUTER JOIN in SQL
18. LEFT OUTER JOIN in SQL
19. RIGHT OUTER JOIN in SQL
20. Timestamp Queries in SQL
21. EXTRACT, AGE, and TO_CHAR Functions in SQL
22. Mastering String Functions in SQL
23. Using Subqueries in SQL
24. SQL Exercise Files
25. SQL Challenge IQ Test
26. Creating Tables in SQL
27. Importing Data in SQL
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.
Student Ratings & Reviews
No Review Yet
