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

SQL & PostgreSQL in 1.5 h: Complete SQL Course from Scratch, available at $29.99, has an average rating of 4.33, with 51 lectures, 2 quizzes, based on 6 reviews, and has 17 subscribers.

You will learn about 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 This course is ideal for individuals who are Data analysts, Database administrators, Software developers and anyone interested in SQL It is particularly useful for Data analysts, Database administrators, Software developers and anyone interested in SQL.

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

Summary

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

Price: $29.99

Average Rating: 4.33

Number of Lectures: 51

Number of Quizzes: 2

Number of Published Lectures: 51

Number of Published Quizzes: 2

Number of Curriculum Items: 53

Number of Published Curriculum Objects: 53

Number of Practice Tests: 1

Number of Published Practice Tests: 1

Original Price: $34.99

Quality Status: approved

Status: Live

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

Who Should Attend

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

Target Audiences

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

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.

Course Curriculum

Chapter 1: PostgeSQL Free Tools, Docker and Mock Data

Lecture 1: PostgresSQL & SQL Free Tools (psql, pgAdmin, DBeaver, VS Code)

Lecture 2: SQL Tools – Connecting to Database, Generation and Inserting Mock Data

Lecture 3: PostgreSQL – psql (terminal) – main commands for working with database

Lecture 4: PostgreSQL database server from a Docker image using Volume

Chapter 2: SQL Basic select queries

Lecture 1: CREATE TABLE

Lecture 2: Creating and Importing a Dump File

Lecture 3: Sorting Data – ORDER BY

Lecture 4: Searching Data – LIKE, iLIKE

Lecture 5: Finding and Deleting Duplicates

Lecture 6: Aggregation Functions – SUM, AVG, COUNT

Lecture 7: UNION or UNION ALL?

Lecture 8: WHERE or HAVING?

Lecture 9: COALESCE

Lecture 10: Working with DATE

Lecture 11: AGE()

Lecture 12: Check Constraints

Lecture 13: ON CONFLICT – DO UPDATE or DO NOTHING ?

Lecture 14: Subqueries

Lecture 15: INDEX

Lecture 16: Improve performance and speed up your queries. Cost of query execution

Chapter 3: SQL advanced queries

Lecture 1: Views

Lecture 2: Stored Procedures

Lecture 3: Transactions

Lecture 4: Transactions Rollback

Lecture 5: Transactions (2) – Example with Bank Account Transactions

Lecture 6: Transactions (3) – Concurrent Transactions

Lecture 7: Transactions – Read Committed Isolation Level

Lecture 8: Transactions – Repeatable Read Isolation Level

Lecture 9: Transactions – Serializable Isolation Level

Lecture 10: Window Functions

Lecture 11: Window Functions – PARTITION BY

Lecture 12: CTEs (Common Table Expressions)

Lecture 13: Full-text search

Lecture 14: Case Expressions

Lecture 15: Triggers

Chapter 4: Joining Tables

Lecture 1: Inner Join

Lecture 2: Left Join

Lecture 3: Right Join

Lecture 4: Full Outer Join

Lecture 5: Cross Join

Chapter 5: Proper relationships between tables

Lecture 1: One to one

Lecture 2: One to Many

Lecture 3: Many to Many & Double Join

Chapter 6: From Non-normal to Normal forms

Lecture 1: First Normal Form

Lecture 2: Second Normal Form

Lecture 3: Third Normal Form

Chapter 7: Visualization of data from Database Tableau / Power BI (optional)

Lecture 1: Connecting Tableau to Database and visualizing data

Lecture 2: Connecting Power BI to Database and visualizing data

Chapter 8: Deployment of database with AWS (Amazon) (optional)

Lecture 1: Deployment of a free tier relational database with AWS (Amazon) (optional)

Chapter 9: Case study: SQL Injection cause fetching data / bypassing authorization

Lecture 1: SQL Injection. Rest API vulnarability and its prevention (Java JDBC example)

Lecture 2: SQL Injection. Bypass authorization vulnarability, its prevention (PHP example)

Chapter 10: Practice interview questions (case based)

Instructors

Edu Nation
Life Long Education

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 0 votes
5 stars: 5 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu