SQL & PostgreSQL for Beginners: Learn the SQL Fundamentals

A comprehensive course on SQL and postgreSQL: Become an SQL expert by writing queries using pgAdmin

Created by: Zaki Khurshid
DWH/BI Developer || Instructor

What Will I Learn?

• Learn the fundamentals of SQL.
• The fundamental statements/keywords like SELECT, SELECT DISTINCT, WHERE, ORDER BY, LIMIT , and more.
• Learn how to use mathematical, string, and time functions and operators.
• The use of EXTRACT function.
• Learn the key concepts regarding Data types, Primary and Foreign keys, and Constraints.
• Create new tables, insert values into the tables, and also modify the rows and columns in a table.
• Learn GROUP BY statement, and HAVING clause.
• How to join mutiple tables. UNION, INNER JOIN, OUTER JOIN, LEFT OUTER JOIN, and RIGHT OUTER JOIN will be covered.
• Learn how to write complex queries with Self-join and Subquery.
• Learn the advanced concepts like CASE, COALESCE, NULLIF, VIEWS etc.
• Learn how to Create your own functions.
• Learn how to use Window Functions.
• Learn how to import and export csv files.

Requirements

• This course is for absolute beginners, so no prior knowledge or experience is required.
• You should have a working computer. The computer can have Windows, MacOS, or Linux installed.

Target audience

• Someone who deals with data on a regular basis.
• Someone who is curious about learning a new programming language.
• Someone who wants to be a data scientist, data analyst, etc.