SQL Course 2024: SQL for Data Analysis and Data Science.

Master the Art of SQL Querying and PostgreSQL for Data Analysis and Data Science An using Real World SQL Database.

Created by: Temotec Learning Academy
Professional Developer & Programmer love teaching.

Created by: Tamer Ahmed
Passionate Developer, Data Scientist and Data Engineer.

What Will I 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 Python bs4 & Pandas to Scrape a webpage, Analyze and visualize The Scraped Data.
• 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.
• Use Python with SQL Postgres database.
• Use Python to load Postgres Data Output file.
• Apply what you will learn in Python & SQL through exercises.

Requirements

• Computer and internet.
• No prior knowledge required for this course.

Target audience

• Are you want to learn more about SQL, PostgreSQL, or data analysis using SQL?
• Are you want to learn SQL for data science?
• Are you welling to learn Python Pandas & Data Visualization?
• Are you ready for upcoming SQL interview questions?
• Use Python bs4 & Pandas to Scrape a webpage, Analyze and visualize The Scraped Data.