❗The content presented here is sourced directly from Udemy platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.

Updated in [August 13th, 2023]

Skills and Knowledge Acquired:
By completing this course, you will acquire the skills and knowledge necessary to query data from a database using SQL and PostgreSQL. You will learn how to install and create tables in a database, use the SELECT statement, WHERE clause, AND/OR operators, filtering operators, ORDER BY, LIMIT, DISTINCT, renaming columns, functions, GROUP BY/HAVING clauses, aggregation queries, CASE clause, time/date data, table joins, INNER/OUTER joins, UNION/UNION ALL/INTERSECT/EXCEPT clauses, sub-queries, correlated sub-queries, window functions, and Python with SQL Postgres database. Additionally, you will gain practice with test your self quizzes, challenges, and a final exam.


Contribution to Professional Growth:
This course provides a comprehensive introduction to SQL and PostgreSQL for data analysis and data science. Through the course, learners will gain the skills needed to retrieve insightful data from a database, as well as tips and tricks to query data. The course also includes quizzes, challenges, and a final exam to help learners practice and test their knowledge. Upon completion of the course, learners will be comfortable using SQL and PostgreSQL in data analysis and data science. This course will help learners grow professionally by providing them with the necessary skills to work with databases and data.


Suitability for Further Education:
This SQL Course 2023: SQL for Data Analysis and Data Science is suitable for preparing further education. It covers a wide range of topics related to SQL and PostgreSQL, such as creating tables, using the SELECT statement, filtering operators, and window functions for analytics. Additionally, the course includes test your self quizzes, challenges, and a final exam to help students practice and gain a better understanding of the material. Furthermore, the course also covers how to use Python with SQL Postgres database and how to use Python Pandas to analyze and visualize Postgres data output. All of these topics are essential for further education in data analysis and data science.

Course Syllabus

Introduction

Beginner: PostgreSQL Downloading & Installing + Preparing Airlines Database

Test You Self (1)

Beginner: Database Airlines Overview

Beginner: SQL Basics Part1

Beginner: SQL Basics Part 2

Beginner: SQL Basics Part 3

Test You Self (2)

SQL Basics Challenge!

Intermediate: SQL Aggregations.

Test You Self (3)

SQL Aggregation Challenge!

Intermediate: SQL Conditional

Test You Self (4)

SQL Conditional Challenge

Intermediate: SQL Time Data management

Intermediate: SQL Joins

Test You Self (5)

SQL JOINS Challenge

Intermediate: Sub-queries & Common Table Expression in SQL

Test You Self (6)

SQL Sub-query Challenge

Advanced: PostgreSQL Functions

Advanced: Other SQL Functions

Test You Self (7)

PostgreSQL String Functions.

Test You Self (8)

Final Exam

Python + PostgreSQL introduction

Using Python Pandas in Data Analysis of PostgreSQL Data output.

Extra1: Scrape the Web & Saving Data to a Database

Bonus Section -Thank You