UdemyCourseDownloader SQL Bootcamp SQL and PostgreSQL Database for Beginners

/09. Build Complex Queries/

1. How to construct complex queries.mp4

1. How to construct complex queries.vtt

1.1 9_1_sql.txt.txt

/

udemycoursedownloader.com.url

Udemy Course downloader.txt

/01. Introduction/

1. Introduction to PostgreSQL.mp4

1. Introduction to PostgreSQL.vtt

2. Understand the NorthWind Data Model.mp4

2. Understand the NorthWind Data Model.vtt

2.1 Northwind_data_Model.png.png

3. Install PostgreSQL.mp4

3. Install PostgreSQL.vtt

4. pgAdmin and psql.mp4

4. pgAdmin and psql.vtt

5. Setting Up NorthWind Database.mp4

5. Setting Up NorthWind Database.vtt

5.1 Northwind_schema_Postgres.sql.sql

5.2 Northwind_data_Postgres.sql.sql

5.3 Northwind_check_data.sql.sql

/02. Retrieve data using SELECT statement/

1. What is SELECT .mp4

1. What is SELECT .vtt

2. Alias in SELECT.mp4

2. Alias in SELECT.vtt

3. Literals in SELECT.mp4

3. Literals in SELECT.vtt

3.1 2_3_sql.txt.txt

4. Operations among Columns.mp4

4. Operations among Columns.vtt

4.1 2_4_sql.txt.txt

5. Concatenation Operator.mp4

5. Concatenation Operator.vtt

/03. Data Filter in SELECT/

1. Usage of Where Clause.mp4

1. Usage of Where Clause.vtt

2. Logical Operator (AND, OR, NOT).mp4

2. Logical Operator (AND, OR, NOT).vtt

3. LIKE Operator.mp4

3. LIKE Operator.vtt

4. BETWEEN Operator.mp4

4. BETWEEN Operator.vtt

5. IN , NOT IN Operators.mp4

5. IN , NOT IN Operators.vtt

6. Comparison Operators.mp4

6. Comparison Operators.vtt

7. LIMIT and FETCH Operators.mp4

7. LIMIT and FETCH Operators.vtt

/04. Data Exploration using SELECT/

1. DISTINCT CLause.mp4

1. DISTINCT CLause.vtt

1.1 4_1_sql.txt.txt

2. Ordering the data.mp4

2. Ordering the data.vtt

2.1 4_2_sql.txt.txt

3. Handling NULL data.mp4

3. Handling NULL data.vtt

3.1 4_3_sql.txt.txt

/05. Joins/

1. What is JOIN.mp4

1. What is JOIN.vtt

2. INNER Join.mp4

2. INNER Join.vtt

2.1 5_2_sql.txt.txt

3. LEFT OUTER Join.mp4

3. LEFT OUTER Join.vtt

3.1 5_3_sql.txt.txt

4. RIGHT OUTER Join.mp4

4. RIGHT OUTER Join.vtt

4.1 5_4_sql.txt.txt

5. FULL OUTER Join.mp4

5. FULL OUTER Join.vtt

5.1 5_5_sql.txt.txt

5.2 Data_Creation_script.sql.sql

6. SELF Join.mp4

6. SELF Join.vtt

6.1 Data_Creation_script_1.sql.sql

6.2 5_6_sql.txt.txt

7. CROSS Join.mp4

7. CROSS Join.vtt

7.1 5_7_sql.txt.txt

/06. SET Operators/

1. Basics of SET Operators.mp4

1. Basics of SET Operators.vtt

2. UNION Operator.mp4

2. UNION Operator.vtt

2.1 6_2_sql.txt.txt

3. INTERSECT Operator.mp4

3. INTERSECT Operator.vtt

3.1 6_3_sql.txt.txt

3.2 Data_Creation_script_2.sql.sql

4. EXCEPT Operator.mp4

4. EXCEPT Operator.vtt

4.1 6_4_sql.txt.txt

/07. Aggregate Function/

1. What is Aggregate Function.mp4

1. What is Aggregate Function.vtt

2. SUM, AVG, COUNT, MAX, MIN.mp4

2. SUM, AVG, COUNT, MAX, MIN.vtt

2.1 7_2_sql.txt.txt

/08. Group Data/

1. Basics of Grouping data.mp4

1. Basics of Grouping data.vtt

2. Group By and Having.mp4

2. Group By and Having.vtt

2.1 8_2_sql.txt.txt

/10. String and Number Built in Functions/

1. Length, Lower , Upper Functions.mp4

1. Length, Lower , Upper Functions.vtt

1.1 10_1_sql.txt.txt

2. Ltrim, Rtrim, Btrim, Trim Functions.mp4

2. Ltrim, Rtrim, Btrim, Trim Functions.vtt

2.1 10_2_sql.txt.txt

3. InitCap, Left , Right Functions.mp4

3. InitCap, Left , Right Functions.vtt

3.1 10_3_sql.txt.txt

4. Ascii, Chr, Concat, Concat_ws Functions.mp4

4. Ascii, Chr, Concat, Concat_ws Functions.vtt

4.1 10_4_sql.txt.txt

5. Strpos, Position Functions.mp4

5. Strpos, Position Functions.vtt

5.1 10_5_sql.txt.txt

6. Substring Function.mp4

6. Substring Function.vtt

6.1 10_6_sql.txt.txt

7. Lpad, Rpad, Split_Part Functions.mp4

7. Lpad, Rpad, Split_Part Functions.vtt

7.1 10_7_sql.txt.txt

8. Repeat, Reverse Functions.mp4

8. Repeat, Reverse Functions.vtt

8.1 10_8_sql.txt.txt

9. Translate, Replace Functions.mp4

9. Translate, Replace Functions.vtt

9.1 10_9_sql.txt.txt

10. Numeric Functions.mp4

10. Numeric Functions.vtt

10.1 10_10_sql.txt.txt

/11. Date Time Built In Functions/

1. Current DateTime Functions.mp4

1. Current DateTime Functions.vtt

1.1 11_1_sql.txt.txt

2. Age, Timeofday Functions.mp4

2. Age, Timeofday Functions.vtt

2.1 11_2_sql.txt.txt

3. Date_part, Extract, Date_Trunc Functions.mp4

3. Date_part, Extract, Date_Trunc Functions.vtt

3.1 11_3_sql.txt.txt

/12. Data Type Conversion Built In Functions/

1. Cast Function.mp4

1. Cast Function.vtt

1.1 12_1_Sql.txt.txt

2. To_date Function.mp4

2. To_date Function.vtt

2.1 12_2_sql.txt.txt

3. To_Char Function.mp4

3. To_Char Function.vtt

3.1 12_3_sql.txt.txt

4. To_Number Function.mp4

4. To_Number Function.vtt

4.1 12_4_sql.txt.txt

5. To_Timestamp Function.mp4

5. To_Timestamp Function.vtt

5.1 12_5_sql.txt.txt

/13. Sub Query/

1. Sub Query, Exists, In Operators.mp4

1. Sub Query, Exists, In Operators.vtt

1.1 13_1_sql.txt.txt

2. ANY, ALL Operators.mp4

2. ANY, ALL Operators.vtt

2.1 13_2_sql.txt.txt

/14. DML Operations/

1. Insert Statement.mp4

1. Insert Statement.vtt

1.1 14_1_sql.txt.txt

2. Update Statement.mp4

2. Update Statement.vtt

2.1 14_2_sql.txt.txt

3. Delete Statement.mp4

3. Delete Statement.vtt

3.1 14_3_sql.txt.txt

4. Commit and Rollback Statements.mp4

4. Commit and Rollback Statements.vtt

4.1 14_4_sql.txt.txt

/15. BONUS Lecture My other courses at Minimal price/

1. BONUS Lecture Mastering Oracle Performance Tuning.html

Total files 171