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.

1. SQL Free Tools and Mock Data

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

2.1 SQL full presentation.pdf

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

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

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

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

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

1. Connecting Tableau to Database and visualizing data

2. Connecting Power BI to Database and visualizing data

4. SQL Basic queries

1. Table creation

2.1 storedumped.zip

2. Creating and importing a dump file

3. Sorting Data - ORDER BY

4. Searching Data - LIKE, iLIKE

5. Finding and deleting duplicates

6. Aggregation functions - SUM, AVG, COUNT

7. UNION or UNION ALL

8. WHERE or HAVING

9. COALESCE

10. Working with DATE

11. AGE()

12. Check Constraints

13. ON CONFLICT - DO UPDATE or DO NOTHING

14. Subqueries

15. INDEX

16.1 client.zip

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

5. SQL advanced queries

1. Views

2. Stored Procedures

3. Transactions

4. Transactions Rollback

5. Window Functions

6. Window Functions - PARTITION BY

7. CTEs (Common Table Expressions)

8. Full-text search

9. Case Expressions

10. Triggers

6. Joining Tables

1. Inner Join

2. Left Join

3. Right Join

4. Full Outer Join

5. Cross Join

7. Proper relationships between tables

1. One to one

2. One to Many

3. Many to Many & Double Join

8. From Non-normal to Normal forms

1. First Normal Form

2. Second Normal Form

3. Third Normal Form

9. Case study SQL Injection cause fetching data bypassing authorization

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

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

10. Practice interview questions (case based)

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

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

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training