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

Focused View

Edu Nation

1:21:02

49 View

1. SQL Free Tools and Mock Data

1. SQL Free Tools (psql, pgAdmin, DBeaver, VS Code).mp4

01:52

2.1 SQL full presentation.pdf

2. SQL Tools - Connecting to DB, generation and inserting mock data.mp4

02:56

3. PSQL (terminal) - main commands for working with database.mp4

03:21

2. Deployment of database with AWS (Amazon) (optional)

1. Deployment of a free tier relational database with AWS (Amazon) (optional).mp4

06:20

3. Visualization of data from Database Tableau Power BI (optional)

1. Connecting Tableau to Database and visualizing data.mp4

03:27

2. Connecting Power BI to Database and visualizing data.mp4

02:40

4. SQL Basic queries

1. Table creation.mp4

02:43

2.1 storedumped.zip

2. Creating and importing a dump file.mp4

03:42

3. Sorting Data - ORDER BY.mp4

00:48

4. Searching Data - LIKE, iLIKE.mp4

01:10

5. Finding and deleting duplicates.mp4

03:02

6. Aggregation functions - SUM, AVG, COUNT.mp4

01:04

7. UNION or UNION ALL.mp4

00:34

8. WHERE or HAVING.mp4

00:52

9. COALESCE.mp4

00:35

10. Working with DATE.mp4

01:16

11. AGE().mp4

00:31

12. Check Constraints.mp4

01:10

13. ON CONFLICT - DO UPDATE or DO NOTHING .mp4

01:45

14. Subqueries.mp4

00:25

15. INDEX.mp4

00:45

16.1 client.zip

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

03:56

5. SQL advanced queries

1. Views.mp4

00:58

2. Stored Procedures.mp4

00:56

3. Transactions.mp4

02:47

4. Transactions Rollback.mp4

00:24

5. Window Functions.mp4

00:49

6. Window Functions - PARTITION BY.mp4

01:46

7. CTEs (Common Table Expressions).mp4

00:45

8. Full-text search.mp4

01:30

9. Case Expressions.mp4

01:16

10. Triggers.mp4

00:38

6. Joining Tables

1. Inner Join.mp4

01:32

2. Left Join.mp4

00:41

3. Right Join.mp4

00:43

4. Full Outer Join.mp4

00:34

5. Cross Join.mp4

01:25

7. Proper relationships between tables

1. One to one.mp4

04:11

2. One to Many.mp4

00:58

3. Many to Many & Double Join.mp4

03:18

8. From Non-normal to Normal forms

1. First Normal Form.mp4

01:22

2. Second Normal Form.mp4

01:26

3. Third Normal Form.mp4

01:20

9. Case study SQL Injection cause fetching data bypassing authorization

1. SQL Injection. Rest API vulnarability and its prevention (Java example).mp4

03:24

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

03:25

10. Practice interview questions (case based)

1. Sample interview questions (case based) - Part I.html

2. Sample interview questions (case based) - Part II.html

Description

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

What You'll 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 is this for?

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

What You Need to Know?

No programming experience needed

More details

Description
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.
Who this course is for:
Data analysts, Database administrators, Software developers and anyone interested in SQL

User Reviews

Rating

average 0

Total votes0

Focused display

Has big4 experience, software engineering degree, used to work for U.S startup. Strongly believe in continuous education. When delivering information, it is important to stick to the main points and avoid going into unnecessary details. The primary objective should be to provide practical guidance and prepare students for real work. Enjoy :)

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.