Overview

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.

Skills

Reviews