What you’ll learn
-
Using Real World PostgreSQL Database Airlines Database.
-
Use Python Pandas to Analyze and visualize Postgres Data Output.
-
SQL Test Your Self, SQL Challenges, SQL Final Exam and more
-
Use Python to visualize Postgres Data Output and get your Conclusion about Data.
-
Use SQL to create databases.
-
Use SQL to insert data into a table.
-
Use SQL to Query & retrieve data from databases.
-
Use SQL to Sort records after retrieving from databases.
-
Use SQL to Group data by specific conditions.
-
Use SQL to Filter data by using where clause.
-
How & when to use Joins types in SQL.
-
How to create and deal with Sub-queries in SQL.
-
How to create and deal with common table expression in SQL.
-
Use SQL to perform data analysis of real world databases
-
Use SQL to perform advanced techniques to retrieve data from databases.
