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.
4.33 (6 reviews)
18
students
1.5 hours
content
Jun 2023
last update
$29.99
regular price
What you will 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
Course Gallery
Charts
Students
Price
Rating & Reviews
Enrollment Distribution
Related Topics
5294892
udemy ID
26/04/2023
course created date
29/05/2023
course indexed date
Bot
course submited by