❗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 taking this course, you will acquire the skills and knowledge necessary to read and write complex queries to a database using PostgreSQL. You will learn the basics of SQL syntax, how to analyze data using aggregate functions with GROUPBY commands, how to run advanced queries with string operations and comparison operations, how to use logical operators to add logic flow to your SQL queries, how to use common SQL JOIN commands, how to create tables and databases with constraints on data entries, and how to use Python to further advance your SQL skills. Additionally, you will gain experience setting up and restoring databases, dealing with timestamp data and variable character information, and working with advanced commands.


Contribution to Professional Growth:
This course provides a comprehensive introduction to SQL, one of the most in demand tech skills. It covers the basics of SQL syntax, as well as more advanced topics such as string operations, comparison operations, logical operators, and SQLJOIN commands. It also provides an introduction to PostgreSQL and PgAdmin, two of the world's most popular SQL tools. Through challenges and tests, learners will gain the skills and confidence to use SQL quickly and effectively. By completing this course, learners will be able to add SQL to their resume and improve their career prospects.


Suitability for Further Education:
This course is suitable for preparing further education as it provides comprehensive instruction on SQL, one of the most in demand tech skills. It covers the basics of SQL syntax, as well as more advanced topics such as string operations, comparison operations, logical operators, and SQLJOIN commands. Additionally, the course provides challenges and tests to help students improve their understanding and provides instruction on using Python to further advance their SQL skills. With this course, students will be able to gain the skills necessary to become a SQL Pro and upgrade their skill set quickly.

Course Syllabus

Course Introduction

SQL Statement Fundamentals

GROUP BY Statements

Assessment Test 1

JOINS

Advanced SQL Commands

Assessment Test 2

Creating Databases and Tables

Assessment Test 3

Conditional Expressions and Procedures

Extra: PostGreSQL with Python

BONUS SECTION: THANK YOU!