Description
You will learn many tips and tricks in PostgreSQL to query data through the following Topics covered in this course:
Using Real World PostgreSQL Database Airlines Database.
- What is a Database
- SQL database for beginners.
- Installing PostgreSQL database.
- Creating Tables in database using SQL.
- Drop table from SQL database
- SELECT Statement use with SQL database data querying
- WHERE Clause use with SQL database data querying
- Operators used with Where clause in SQL database data querying .
- AND & OR use with SQL database data querying
- like use with SQL database data querying .
- Filtering Operators use with SQL database data querying .
- ORDER BY use with SQL database data querying .
- LIMIT use with SQL database data querying .
- DISTINCT use with SQL database data querying .
- Renaming Column in SQL database.
- Functions use with SQL database data querying .
- GROUP BY & HAVING Clauses use with database data querying .
- Aggregation Queries in SQL database.
- CASE Clause use with database data querying .
- Time & date data in SQL in database.
- Table Joins in SQL database.
- INNER and OUTER Joins in SQL database.
- UNION, UNION ALL, INTERSECT and EXCEPT Clauses use with SQL database data querying.
- Sub-queries use with SQL database data querying .
- Correlated Sub queries use with SQL database data querying.
- Window Functions for Analytics in SQL database.
- Challenges for more SQL practice in this course.
- Final Exam in SQL database data querying.