SQL & PostgreSQL in 1.5 h: Complete SQL Course from Scratch

From SQL query syntax to advanced concepts: indexes, query optimization, normal forms, SQL Injections. Interview prep.

Created by: Edu Nation
Life Long Education

What Will I Learn?

• Exploring free tools to work with SQL (e.g., pgAdmin, VS Code, DBeaver, psql)
• Deploy a free tier database with Amazon.
• Learn basic SQL commands (ORDER BY ASC / DESC, OFFSET / LIMIT, LIKE, iLIKE, UNION (ALL), COALESCE, DATE, NOW(), INTERVAL, AGE)
• Connecting Database to Tableau / Power BI and data visualization
• Deploy a free tier database with AWS
• Aggregate functions (SUM, ROUND, AVG, MAX, MIN, COUNT)
• Searching and deleting duplicates, writing double joins, etc.
• Joining multiple tables together (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN)
• How to use WHERE and HAVING clauses / DO UPDATE / DO NOTHING
• Query optimization 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

Requirements

• No programming experience needed

Target audience

• Data analysts, Database administrators, Software developers and anyone interested in SQL