Throughout this course, we will delve into a variety of essential topics to equip you with the necessary skills to work with SQL:
-
Connecting Database to Tableau / Power BI and data visualization;
-
Deploy a free tier database with Amazon;
-
Exploring the free tools to work with SQL (e.g., pgAdmin, VS Code, DBeaver, psql);
-
Learn basic SQL commands (ORDER BY ASC / DESC, OFFSET / LIMIT, LIKE, iLIKE, UNION (ALL), COALESCE, DATE, NOW(), INTERVAL, AGE);
-
Writing subqueries;
-
Aggregate functions (SUM, ROUND, AVG, MAX, MIN, COUNT);
-
Understand when to use WHERE and HAVING clauses / DO UPDATE / DO NOTHING;
-
How to optimize queries and increase performance of queries when working with big tables;
-
How to use (CHECK) CONSTRAINTS, VIEWS, STORED PROCEDURES, TRANSACTIONS, WINDOW FUNCTIONS, COMMON TABLE EXPRESSIONS, FULL-TEXT SEARCH, CASE EXPRESSIONS, TRIGGERS;
-
Exploring relations between tables (ONE TO ONE, ONE TO MANY, MANY TO MANY);
-
Writing JOINS (JOINS: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, CROSS JOIN);
-
SQL (NON) NORMAL FORMS (first normal form, second normal form and third normal form);
-
SQL INJECTIONS on practical examples: Rest API web / Authorization application injection with consequences of exploiting such injection.
-
Pass practical tests to be prepared for an interview.
Throughout the course, you will receive a detailed presentation with all the queries we discuss. This will help you consolidate your learning and provide you with a reference resource you can use later.
I’m excited to guide you through this journey of SQL learning, and I hope that by the end of the course, you will feel confident in your ability to use SQL to solve a variety of problems.
