Udemy - Learn SQL with 80 Interactive Exercises The Hands-on Guide (12.2024)

Creation Time	March 3, 2025, 7:08 p.m.
Last Access Time	May 6, 2025, 7:05 p.m.
File Size	9.1 GB
Keywords	12 Guide Hands-on Learn - Udemy 2024 SQL Exercises 80 with The Interactive
Total Requests	158
Total Files	573
Magnet Link	Please wait ...
	Download (Magnet Link) Play (Watch Online)

29. PostgreSQL with Python/07. Preventing SQL injections.mp4 253.7 MB
29. PostgreSQL with Python/04. Connecting to PostgreSQL.mp4 220.9 MB
21. Complex Statistical Queries/04. GROUPING SETS and GROUPING.mp4 192.7 MB
25. Triggers/09. Refreshing data with a trigger.mp4 179.7 MB
22. Collations/03. Using a different collation.mp4 174.4 MB
26. Additional Topics/02. Full-text search in PostgreSQL.mp4 157.0 MB
21. Complex Statistical Queries/10. The LAG and LEAD functions.mp4 156.4 MB
25. Triggers/07. Creating a trigger.mp4 142.9 MB
06. Table Management/10. The PRIMARY KEY.mp4 138.9 MB
25. Triggers/11. Intercepting an SQL command with a trigger.mp4 136.3 MB
29. PostgreSQL with Python/08. Bonus Object Relational Mappers (ORMs).mp4 132.4 MB
26. Additional Topics/01. Exporting data with PostgreSQL.mp4 131.8 MB
13. Views/04. Materialized views.mp4 131.7 MB
21. Complex Statistical Queries/07. OVER and PARTITION BY.mp4 129.5 MB
31. SQLite Overview Similarities and Differences with PostgreSQL/06. Data types in SQLite - 2.mp4 127.3 MB
29. PostgreSQL with Python/05. Inserting data in PostgreSQL.mp4 125.8 MB
04. Changing data in SQL/04. Updating data (UPDATE).mp4 116.1 MB
16. Constraints/07. Foreign key constraints.mp4 114.9 MB
06. Table Management/06. Numbers with a decimal point (FLOAT, DECIMAL).mp4 112.9 MB
20. Arrays/17. Bonus, optimized search with an index.mp4 112.3 MB
16. Constraints/03. Creating a UNIQUE constraint.mp4 108.3 MB
30. MySQL Overview Similarities and Differences with PostgreSQL/03. MySQL installation.mp4 106.0 MB
07. Data Modeling/10. How to develop a good schema.mp4 105.0 MB
14. Transactions/02. Create a first transaction.mp4 99.9 MB
03. Introduction to SQL querying statements/01. Querying the data (SELECT).mp4 99.3 MB
15. Indexes/07. Creating an index (CREATE INDEX).mp4 96.9 MB
30. MySQL Overview Similarities and Differences with PostgreSQL/05. Differences between PostgreSQL and MySQL - 1.mp4 95.3 MB
16. Constraints/08. Changing the behavior (ON UPDATE, ON DELETE).mp4 92.1 MB
16. Constraints/06. Creating a custom constraint (CHECK).mp4 89.8 MB
06. Table Management/11. Automatically generating a primary key.mp4 88.9 MB
19. Migration Practical Exercise/05. Sample solution (part 2).mp4 86.9 MB
03. Introduction to SQL querying statements/08. Filtering with LIKE.mp4 85.4 MB
20. Arrays/14. The UNNEST function in PostgreSQL.mp4 84.6 MB
31. SQLite Overview Similarities and Differences with PostgreSQL/03. Differences between PostgreSQL and SQLite - 1.mp4 82.3 MB
05. Exploring more complex SQL operations/08. Important numeric functions.mp4 80.1 MB
07. Data Modeling/08. Many-to-many relationship.mp4 76.4 MB
26. Additional Topics/04. Best practices - 1.mp4 75.6 MB
21. Complex Statistical Queries/11. The STRING_AGG and ARRAY_AGG functions.mp4 75.3 MB
23. Permissions/01. Overview.mp4 75.0 MB
16. Constraints/05. Heads-up (STRPOS).mp4 74.7 MB
07. Data Modeling/07. One-to-One relationship.mp4 73.7 MB
03. Introduction to SQL querying statements/03. Filtering with WHERE.mp4 73.6 MB
05. Exploring more complex SQL operations/02. The missing value NULL.mp4 72.7 MB
04. Changing data in SQL/03. INSERTing data.mp4 72.0 MB
17. Dates/07. Timezones.mp4 71.3 MB
30. MySQL Overview Similarities and Differences with PostgreSQL/08. Data types in MySQL.mp4 70.0 MB
13. Views/03. Common use cases for VIEWs.mp4 69.6 MB
23. Permissions/04. Granting permissions to roles.mp4 68.8 MB
06. Table Management/05. Numeric types (SMALLINT, INT, BIGINT).mp4 68.7 MB
29. PostgreSQL with Python/03. Installing Python and VS Code.mp4 67.8 MB
02. Getting started/03. Connecting to PostgreSQL through pgAdmin 4.mp4 67.3 MB
24. Stored Procedures/04. Managing permissions on stored procedures - 1.mp4 65.8 MB
19. Migration Practical Exercise/04. Sample solution (part 1).mp4 65.1 MB
15. Indexes/05. How to measure execution performance.mp4 64.1 MB
31. SQLite Overview Similarities and Differences with PostgreSQL/04. Differences between PostgreSQL and SQLite - 2.mp4 61.5 MB
17. Dates/08. Keeping track of creation time of an entry.mp4 61.0 MB
06. Table Management/04. Text types (VARCHAR, CHAR, TEXT).mp4 60.0 MB
17. Dates/05. Extracting data from timestamps.mp4 59.2 MB
15. Indexes/08. Investigating index problems.mp4 58.9 MB
07. Data Modeling/09. Bonus compound primary keys.mp4 58.5 MB
08. Subqueries/02. Correlated subquery.mp4 56.6 MB
19. Migration Practical Exercise/02. How to perform a migration.mp4 56.2 MB
16. Constraints/04. Unique constraint vs index.mp4 54.9 MB
31. SQLite Overview Similarities and Differences with PostgreSQL/05. Data types in SQLite - 1.mp4 52.6 MB
30. MySQL Overview Similarities and Differences with PostgreSQL/07. Differences between PostgreSQL and MySQL - 2.mp4 52.4 MB
26. Additional Topics/03. Speeding up a full-text search.mp4 51.2 MB
03. Introduction to SQL querying statements/02. Introduction Interactive code exercises.mp4 50.6 MB
17. Dates/06. Calculating INTERVALs.mp4 50.2 MB
25. Triggers/12. Triggers and permissions.mp4 50.1 MB
07. Data Modeling/06. Exercise solution.mp4 49.7 MB
08. Subqueries/05. Subqueries in a WHERE condition.mp4 49.5 MB
09. JOINs/03. INNER JOIN.mp4 48.7 MB
08. Subqueries/07. Combining queries with UNION.mp4 48.7 MB
02. Getting started/06. Importing the data.mp4 48.5 MB
05. Exploring more complex SQL operations/04. String functions (part 1).mp4 48.4 MB
19. Migration Practical Exercise/03. Exercise refactoring data.mp4 48.3 MB
21. Complex Statistical Queries/12. Common Table Expressions (CTEs).mp4 47.5 MB
03. Introduction to SQL querying statements/09. The BETWEEN and IN clause.mp4 45.1 MB
08. Subqueries/01. Introduction, first subselect.mp4 44.7 MB
16. Constraints/01. Overview.mp4 44.5 MB
02. Getting started/02. Installing PostgreSQL.mp4 42.6 MB
06. Table Management/12. Working with binary data (BYTEA).mp4 41.4 MB
08. Subqueries/06. Subquery with EXISTS.mp4 41.3 MB
26. Additional Topics/05. Best practices - 2.mp4 40.6 MB
20. Arrays/25. When to use an array (best practices).mp4 40.2 MB
23. Permissions/07. Using a VIEW with permissions.mp4 39.3 MB
07. Data Modeling/03. Creating the albums table.mp4 39.0 MB
03. Introduction to SQL querying statements/07. Getting DISTINCT entries.mp4 38.7 MB
06. Table Management/13. TRUNCATE and DROP.mp4 37.3 MB
23. Permissions/03. Creating a user, logging in as a user.mp4 37.2 MB
15. Indexes/09. Creating a UNIQUE index.mp4 36.1 MB
15. Indexes/03. Importing and exploring the data.mp4 35.7 MB
09. JOINs/04. LEFT JOIN, RIGHT JOIN, FULL JOIN.mp4 35.0 MB
15. Indexes/04. EXPLAINing the query.mp4 34.7 MB
21. Complex Statistical Queries/13. Temporary tables.mp4 34.1 MB
06. Table Management/03. Changing a table (ALTER TABLE).mp4 33.3 MB
24. Stored Procedures/05. Managing permissions on stored procedures - 2.mp4 32.5 MB
29. PostgreSQL with Python/06. Passing parameters through dictionaries.mp4 32.2 MB
31. SQLite Overview Similarities and Differences with PostgreSQL/02. Installing DB Browser.mp4 32.2 MB
30. MySQL Overview Similarities and Differences with PostgreSQL/09. The utf8_general_ci collation.mp4 31.6 MB
07. Data Modeling/02. Creating the artists table.mp4 30.3 MB
17. Dates/02. TIME, DATE, TIMESTAMP.mp4 30.1 MB
23. Permissions/06. Managing permissions through pgAdmin 4.mp4 30.0 MB
03. Introduction to SQL querying statements/12. Quotes in SQL.mp4 29.6 MB
06. Table Management/09. DEFAULT values.mp4 29.4 MB
03. Introduction to SQL querying statements/10. The ORDER BY clause.mp4 28.9 MB
25. Triggers/02. Writing a PLpgSQL script.mp4 28.0 MB
06. Table Management/14. Managing the tables through pgAdmin4.mp4 27.7 MB
01. Introduction/04. A first outlook SQL.mp4 27.0 MB
03. Introduction to SQL querying statements/06. Aggregate functions in SQL.mp4 26.9 MB
24. Stored Procedures/03. What does the $$ mean.mp4 26.8 MB
06. Table Management/07. Disabling NULL for a column.mp4 26.4 MB
08. Subqueries/04. Self-correlated subquery.mp4 26.2 MB
24. Stored Procedures/02. Creating a stored procedure.mp4 26.2 MB
14. Transactions/05. How transactions work, performance implications.mp4 25.9 MB
05. Exploring more complex SQL operations/03. NULL and aggregate functions (MIN, MAX, COUNT, ,...).mp4 25.8 MB
20. Arrays/01. Overview Arrays.mp4 25.7 MB
20. Arrays/09. The ANY and ALL functions.mp4 23.9 MB
22. Collations/05. Collations and Indexes.mp4 23.8 MB
13. Views/02. Creating a first VIEW.mp4 23.7 MB
09. JOINs/05. Which to use (a subquery or a join).mp4 23.3 MB
02. Getting started/04. What is a DBMS Creating a database.mp4 23.2 MB
15. Indexes/06. How does an index improve performance.mp4 23.1 MB
22. Collations/04. Changing the collation of a column.mp4 22.3 MB
25. Triggers/03. Variables in PLpgSQL.mp4 22.0 MB
05. Exploring more complex SQL operations/09. The CASE WHEN block.mp4 21.9 MB
03. Introduction to SQL querying statements/11. Specifying an offset and a limit.mp4 21.8 MB
20. Arrays/06. How to access an array.mp4 21.8 MB
22. Collations/01. Overview.mp4 20.9 MB
09. JOINs/02. A first join (CROSS JOIN).mp4 20.8 MB
21. Complex Statistical Queries/09. The ROW_NUMBER function.mp4 20.7 MB
30. MySQL Overview Similarities and Differences with PostgreSQL/04. Using MySQL Workbench.mp4 20.3 MB
20. Arrays/02. Creating a first array.mp4 20.3 MB
20. Arrays/20. Modifying an array.mp4 20.2 MB
21. Complex Statistical Queries/03. Importing and exploring the data.mp4 19.8 MB
17. Dates/03. Creating the data.mp4 19.8 MB
22. Collations/06. Language-specific collations.mp4 19.2 MB
05. Exploring more complex SQL operations/07. Type casting with CAST.mp4 19.0 MB
21. Complex Statistical Queries/05. The ROLLUP function.mp4 17.8 MB
10. GROUP BY/01. A first GROUP BY clause.mp4 17.5 MB
08. Subqueries/03. Renaming table with AS.mp4 17.4 MB
03. Introduction to SQL querying statements/04. Multiple SQL statements and comments.mp4 16.6 MB
05. Exploring more complex SQL operations/05. String functions (part 2).mp4 16.3 MB
26. Additional Topics/06. Best practices - 3.mp4 16.2 MB
14. Transactions/04. SAVEPOINT in a transaction.mp4 15.8 MB
31. SQLite Overview Similarities and Differences with PostgreSQL/01. Overview.mp4 15.6 MB
30. MySQL Overview Similarities and Differences with PostgreSQL/06. Similarities between PostgreSQL and MySQL.mp4 15.1 MB
14. Transactions/01. Overview (transactions).mp4 15.1 MB
25. Triggers/04. Loops in PLpgSQL.mp4 14.8 MB
21. Complex Statistical Queries/15. When to use what.mp4 14.7 MB
15. Indexes/01. Overview Indexes.mp4 14.6 MB
24. Stored Procedures/01. Overview.mp4 14.0 MB
13. Views/05. Updatable VIEWs.mp4 14.0 MB
25. Triggers/13. Triggers and the SQL standard.mp4 14.0 MB
10. GROUP BY/03. Filter after grouping (HAVING).mp4 13.8 MB
06. Table Management/08. Boolean columns.mp4 13.5 MB
06. Table Management/02. Creating a first table.mp4 13.4 MB
10. GROUP BY/04. How is a query executed.mp4 12.3 MB
25. Triggers/05. Conditionals in PLpgSQL.mp4 12.3 MB
10. GROUP BY/02. More complex grouping.mp4 12.3 MB
15. Indexes/assets/02. biking.bak.sql 12.0 MB
30. MySQL Overview Similarities and Differences with PostgreSQL/01. Overview.mp4 11.9 MB
21. Complex Statistical Queries/06. The CUBE function.mp4 11.9 MB
05. Exploring more complex SQL operations/06. Working with NULL (COALESCE).mp4 11.4 MB
14. Transactions/07. Transaction controls from pgAdmin 4.mp4 11.3 MB
14. Transactions/06. The ACID properties.mp4 11.0 MB
21. Complex Statistical Queries/01. Overview.mp4 10.2 MB
07. Data Modeling/04. Exercise creating tracks table.mp4 10.0 MB
14. Transactions/03. Accessing data within a transaction.mp4 9.5 MB
01. Introduction/02. About this course.mp4 9.3 MB
01. Introduction/01. Introduction.mp4 9.1 MB
05. Exploring more complex SQL operations/10. WHERE and brackets (...).mp4 9.0 MB
07. Data Modeling/01. Overview.mp4 8.5 MB
19. Migration Practical Exercise/01. Overview.mp4 7.8 MB
23. Permissions/05. Revoking permissions from roles.mp4 7.8 MB
32. Closing Words/01. Closing Words.mp4 7.8 MB
29. PostgreSQL with Python/01. Overview.mp4 7.8 MB
04. Changing data in SQL/06. Removing entries (DELETE).mp4 7.7 MB
25. Triggers/01. Overview.mp4 6.9 MB
03. Introduction to SQL querying statements/13. Bonus Quotes in MySQL and MariaDB.mp4 6.4 MB
05. Exploring more complex SQL operations/01. Overview.mp4 5.7 MB
02. Getting started/01. Why PostgreSQL.mp4 5.6 MB
03. Introduction to SQL querying statements/05. Renaming columns with AS.mp4 5.6 MB
04. Changing data in SQL/05. Updating multiple columns at once (UPDATE).mp4 5.3 MB
13. Views/01. Overview VIEWs.mp4 4.8 MB
09. JOINs/01. Overview JOINs.mp4 4.7 MB
21. Complex Statistical Queries/assets/02. salaries.sql 4.6 MB
17. Dates/01. Overview.mp4 4.4 MB
21. Complex Statistical Queries/08. GROUP BY vs OVER.mp4 4.3 MB
06. Table Management/01. Overview.mp4 2.7 MB
04. Changing data in SQL/01. Overview changing data.mp4 1.9 MB
20. Arrays/assets/03. arrays-exercises.sql 37.5 KB
06. Table Management/029 Section Quiz.html 30.4 KB
05. Exploring more complex SQL operations/021 Section Quiz.html 29.5 KB
17. Dates/012 Section Quiz.html 27.0 KB
07. Data Modeling/014 Section Quiz.html 27.0 KB
03. Introduction to SQL querying statements/030 Section Quiz.html 26.8 KB
16. Constraints/012 Section Quiz.html 26.5 KB
14. Transactions/010 Section Quiz.html 25.9 KB
09. JOINs/011 Section Quiz.html 25.8 KB
25. Triggers/017 Section Quiz.html 25.5 KB
25. Triggers/09. Refreshing data with a trigger.vtt 24.5 KB
30. MySQL Overview Similarities and Differences with PostgreSQL/010 Section Quiz.html 24.4 KB
21. Complex Statistical Queries/020 Section Quiz.html 24.0 KB
15. Indexes/012 Chapter Quiz.html 23.8 KB
02. Getting started/assets/05. students.sql 23.8 KB
30. MySQL Overview Similarities and Differences with PostgreSQL/assets/02. students.sql 23.8 KB
24. Stored Procedures/007 Section Quiz.html 23.5 KB
10. GROUP BY/008 Section Quiz.html 23.2 KB
23. Permissions/009 Section Quiz.html 23.0 KB
20. Arrays/029 Section Quiz.html 23.0 KB
13. Views/009 Section Quiz.html 22.9 KB
26. Additional Topics/009 Section Quiz.html 22.7 KB
16. Constraints/004 Creating a UNIQUE constraint.html 22.7 KB
16. Constraints/010 Foreign key constraints.html 22.6 KB
31. SQLite Overview Similarities and Differences with PostgreSQL/007 Section Quiz.html 22.6 KB
06. Table Management/021 Automatically generating primary key.html 22.5 KB
04. Changing data in SQL/013 Section Quiz.html 22.3 KB
08. Subqueries/016 Section Quiz.html 22.3 KB
15. Indexes/009 Creating an index (CREATE INDEX).html 22.0 KB
22. Collations/008 Section Quiz.html 22.0 KB
06. Table Management/007 Text types (VARCHAR, CHAR, TEXT).html 22.0 KB
02. Getting started/007 Section Quiz.html 21.8 KB
21. Complex Statistical Queries/005 GROUPING SETS and GROUPING.html 21.7 KB
06. Table Management/009 Numeric types (SMALLINT, INT, BIGINT).html 21.7 KB
15. Indexes/005 EXPLAINing the query.html 21.4 KB
16. Constraints/008 Creating a custom constraint (CHECK).html 21.3 KB
16. Constraints/08. Changing the behavior (ON UPDATE, ON DELETE).vtt 21.3 KB
26. Additional Topics/003 Full-text search in PostgreSQL.html 21.2 KB
23. Permissions/004 Creating a user, logging in as a user.html 21.2 KB
24. Stored Procedures/003 Creating a stored procedure.html 21.1 KB
20. Arrays/007 How to access an array.html 21.1 KB
17. Dates/009 Calculating INTERVALs.html 21.1 KB
20. Arrays/023 Modifying an array.html 21.1 KB
25. Triggers/010 Creating a trigger.html 21.1 KB
26. Additional Topics/006 Best practices - 1.html 21.0 KB
13. Views/007 Materialized Views.html 21.0 KB
22. Collations/004 Using a different collation.html 21.0 KB
25. Triggers/004 Variables in PLpgSQL.html 21.0 KB
20. Arrays/011 The ANY and ALL functions.html 20.9 KB
17. Dates/007 Extracting data from timestamps.html 20.8 KB
17. Dates/003 TIME, DATE, TIMESTAMP.html 20.7 KB
26. Additional Topics/02. Full-text search in PostgreSQL.vtt 20.7 KB
25. Triggers/007 Conditionals in PLpgSQL.html 20.6 KB
08. Subqueries/006 Renaming table with AS.html 20.6 KB
06. Table Management/011 Numbers with a decimal point (FLOAT, DECIMAL).html 20.6 KB
06. Table Management/018 DEFAULT Constraint.html 20.5 KB
11 - Exam/001 Practice exam Test your knowledge so far (12).html 20.3 KB
29. PostgreSQL with Python/008 Preventing SQL injections.html 20.2 KB
06. Table Management/028 Managing the tables through pgAdmin4.html 20.1 KB
18. Practical Exercises with Dates, Times, Timestamps/010 Coding Exercise Calculating INTERVALs.html 19.4 KB
18. Practical Exercises with Dates, Times, Timestamps/008 Coding Exercise Extracting data from timestamps 22.html 19.4 KB
29. PostgreSQL with Python/07. Preventing SQL injections.vtt 18.9 KB
26. Additional Topics/01. Exporting data with PostgreSQL.vtt 18.5 KB
28 - Exam/001 Practice exam Test your knowledge (22).html 18.2 KB
29. PostgreSQL with Python/08. Bonus Object Relational Mappers (ORMs).vtt 18.1 KB
17. Dates/07. Timezones.vtt 16.7 KB
29. PostgreSQL with Python/04. Connecting to PostgreSQL.vtt 15.7 KB
30. MySQL Overview Similarities and Differences with PostgreSQL/08. Data types in MySQL.vtt 15.5 KB
15. Indexes/05. How to measure execution performance.vtt 15.0 KB
16. Constraints/07. Foreign key constraints.vtt 15.0 KB
21. Complex Statistical Queries/04. GROUPING SETS and GROUPING.vtt 14.6 KB
16. Constraints/03. Creating a UNIQUE constraint.vtt 14.4 KB
06. Table Management/06. Numbers with a decimal point (FLOAT, DECIMAL).vtt 14.4 KB
06. Table Management/04. Text types (VARCHAR, CHAR, TEXT).vtt 14.3 KB
07. Data Modeling/10. How to develop a good schema.vtt 14.0 KB
19. Migration Practical Exercise/02. How to perform a migration.vtt 13.9 KB
14. Transactions/02. Create a first transaction.vtt 13.8 KB
15. Indexes/08. Investigating index problems.vtt 13.6 KB
08. Subqueries/07. Combining queries with UNION.vtt 13.4 KB
03. Introduction to SQL querying statements/02. Introduction Interactive code exercises.vtt 13.1 KB
25. Triggers/07. Creating a trigger.vtt 13.1 KB
15. Indexes/07. Creating an index (CREATE INDEX).vtt 13.0 KB
25. Triggers/11. Intercepting an SQL command with a trigger.vtt 12.8 KB
21. Complex Statistical Queries/07. OVER and PARTITION BY.vtt 12.7 KB
17. Dates/06. Calculating INTERVALs.vtt 12.3 KB
16. Constraints/06. Creating a custom constraint (CHECK).vtt 12.0 KB
07. Data Modeling/011 Example of a Many-to-many relationship.html 11.9 KB
06. Table Management/11. Automatically generating a primary key.vtt 11.8 KB
22. Collations/03. Using a different collation.vtt 11.7 KB
12 - Practical Project/010 Managing Ongoing Projects and Contact Information for Clients.html 11.1 KB
29. PostgreSQL with Python/assets/02. Archive.zip 11.1 KB
21. Complex Statistical Queries/10. The LAG and LEAD functions.vtt 11.0 KB
06. Table Management/12. Working with binary data (BYTEA).vtt 10.9 KB
05. Exploring more complex SQL operations/08. Important numeric functions.vtt 10.8 KB
03. Introduction to SQL querying statements/03. Filtering with WHERE.vtt 10.5 KB
27 - Practical Project 2/008 Finalizing Revenue Report for US Branch.html 10.5 KB
09. JOINs/05. Which to use (a subquery or a join).vtt 10.3 KB
27 - Practical Project 2/002 Optimizing Candidate Management 12.html 10.3 KB
12 - Practical Project/006 Forming Elite Dev Teams.html 10.3 KB
15. Indexes/04. EXPLAINing the query.vtt 10.3 KB
26. Additional Topics/04. Best practices - 1.vtt 10.2 KB
05. Exploring more complex SQL operations/02. The missing value NULL.vtt 10.1 KB
06. Table Management/10. The PRIMARY KEY.vtt 10.1 KB
23. Permissions/01. Overview.vtt 10.0 KB
06. Table Management/025 Section Review.html 9.9 KB
27 - Practical Project 2/001 Consolidating U.S. Client Connections for Market Expansion.html 9.9 KB
13. Views/04. Materialized views.vtt 9.9 KB
07. Data Modeling/08. Many-to-many relationship.vtt 9.8 KB
20. Arrays/25. When to use an array (best practices).vtt 9.8 KB
15. Indexes/06. How does an index improve performance.vtt 9.8 KB
07. Data Modeling/07. One-to-One relationship.vtt 9.6 KB
29. PostgreSQL with Python/05. Inserting data in PostgreSQL.vtt 9.5 KB
06. Table Management/14. Managing the tables through pgAdmin4.vtt 9.4 KB
31. SQLite Overview Similarities and Differences with PostgreSQL/06. Data types in SQLite - 2.vtt 9.4 KB
23. Permissions/03. Creating a user, logging in as a user.vtt 9.4 KB
23. Permissions/07. Using a VIEW with permissions.vtt 9.3 KB
03. Introduction to SQL querying statements/06. Aggregate functions in SQL.vtt 9.3 KB
27 - Practical Project 2/007 Critical Financial and Resource Analysis 22.html 9.3 KB
13. Views/005 CREATE VIEW Clause 22.html 9.1 KB
25. Triggers/02. Writing a PLpgSQL script.vtt 9.1 KB
06. Table Management/014 NOT NULL Constraint.html 9.1 KB
13. Views/03. Common use cases for VIEWs.vtt 9.1 KB
23. Permissions/04. Granting permissions to roles.vtt 9.1 KB
09. JOINs/04. LEFT JOIN, RIGHT JOIN, FULL JOIN.vtt 9.0 KB
12 - Practical Project/004 Updating and Reverting Project Data 12.html 9.0 KB
07. Data Modeling/009 Example of One-to-One relationship.html 9.0 KB
09. JOINs/02. A first join (CROSS JOIN).vtt 8.9 KB
29. PostgreSQL with Python/03. Installing Python and VS Code.vtt 8.9 KB
30. MySQL Overview Similarities and Differences with PostgreSQL/03. MySQL installation.vtt 8.9 KB
19. Migration Practical Exercise/04. Sample solution (part 1).vtt 8.8 KB
06. Table Management/05. Numeric types (SMALLINT, INT, BIGINT).vtt 8.8 KB
21. Complex Statistical Queries/13. Temporary tables.vtt 8.8 KB
27 - Practical Project 2/006 Critical Financial and Resource Analysis 12.html 8.8 KB
27 - Practical Project 2/003 Optimizing Candidate Management 22.html 8.7 KB
12 - Practical Project/001 Classifying Employees for Exclusive Flight Tickets.html 8.7 KB
10. GROUP BY/004 Complex GROUP BY.html 8.6 KB
15. Indexes/09. Creating a UNIQUE index.vtt 8.6 KB
15. Indexes/03. Importing and exploring the data.vtt 8.6 KB
06. Table Management/026 General Review.html 8.6 KB
24. Stored Procedures/04. Managing permissions on stored procedures - 1.vtt 8.6 KB
06. Table Management/03. Changing a table (ALTER TABLE).vtt 8.6 KB
20. Arrays/01. Overview Arrays.vtt 8.5 KB
20. Arrays/14. The UNNEST function in PostgreSQL.vtt 8.5 KB
14. Transactions/003 First Transaction.html 8.4 KB
21. Complex Statistical Queries/007 ROLLUP Function.html 8.4 KB
12 - Practical Project/005 Updating and Reverting Project Data 22.html 8.4 KB
03. Introduction to SQL querying statements/027 Limit and Offset.html 8.2 KB
31. SQLite Overview Similarities and Differences with PostgreSQL/04. Differences between PostgreSQL and SQLite - 2.vtt 8.2 KB
03. Introduction to SQL querying statements/12. Quotes in SQL.vtt 8.1 KB
12 - Practical Project/009 Rewarding Employee Loyalty with Prize Money.html 8.1 KB
08. Subqueries/008 Self-Correlated Subquery.html 8.1 KB
09. JOINs/005 INNER JOIN 12.html 8.0 KB
04. Changing data in SQL/04. Updating data (UPDATE).vtt 8.0 KB
27 - Practical Project 2/004 Fixing Syntax of Unorthodox Transaction.html 8.0 KB
03. Introduction to SQL querying statements/08. Filtering with LIKE.vtt 8.0 KB
03. Introduction to SQL querying statements/10. The ORDER BY clause.vtt 7.9 KB
12 - Practical Project/002 Compiling Engineer Types and Project Overview.html 7.8 KB
08. Subqueries/02. Correlated subquery.vtt 7.8 KB
10. GROUP BY/006 HAVING KEYWORD.html 7.8 KB
09. JOINs/006 INNER JOIN 22.html 7.8 KB
07. Data Modeling/09. Bonus compound primary keys.vtt 7.7 KB
03. Introduction to SQL querying statements/01. Querying the data (SELECT).vtt 7.7 KB
31. SQLite Overview Similarities and Differences with PostgreSQL/03. Differences between PostgreSQL and SQLite - 1.vtt 7.6 KB
21. Complex Statistical Queries/11. The STRING_AGG and ARRAY_AGG functions.vtt 7.6 KB
06. Table Management/003 Creating the businesses_contacts table.html 7.6 KB
12 - Practical Project/007 Creating and Managing App Feature Specifications Table 12.html 7.6 KB
09. JOINs/009 FULL JOIN.html 7.6 KB
06. Table Management/09. DEFAULT values.vtt 7.5 KB
30. MySQL Overview Similarities and Differences with PostgreSQL/09. The utf8_general_ci collation.vtt 7.5 KB
17. Dates/05. Extracting data from timestamps.vtt 7.5 KB
26. Additional Topics/06. Best practices - 3.vtt 7.4 KB
05. Exploring more complex SQL operations/019 CASE WHEN Expression.html 7.4 KB
31. SQLite Overview Similarities and Differences with PostgreSQL/02. Installing DB Browser.vtt 7.4 KB
23. Permissions/06. Managing permissions through pgAdmin 4.vtt 7.4 KB
08. Subqueries/05. Subqueries in a WHERE condition.vtt 7.4 KB
27 - Practical Project 2/005 Fixing Interview Scheduling Issues.html 7.4 KB
07. Data Modeling/02. Creating the artists table.vtt 7.3 KB
06. Table Management/016 BOOLEAN Data Type.html 7.3 KB
05. Exploring more complex SQL operations/009 String Functions 23.html 7.3 KB
12 - Practical Project/008 Creating and Managing App Feature Specifications Table 22.html 7.2 KB
07. Data Modeling/004 Example of a One-to-many relationship.html 7.2 KB
02. Getting started/04. What is a DBMS Creating a database.vtt 7.2 KB
12 - Practical Project/003 Strategic Pairings and Non-Development Staff Overview.html 7.2 KB
13. Views/02. Creating a first VIEW.vtt 7.1 KB
16. Constraints/04. Unique constraint vs index.vtt 7.1 KB
21. Complex Statistical Queries/010 OVER and PARTITION BY clauses.html 7.1 KB
03. Introduction to SQL querying statements/11. Specifying an offset and a limit.vtt 7.0 KB
06. Table Management/012 Further businesses_contacts modifications.html 6.9 KB
08. Subqueries/013 Subquery With EXISTS.html 6.9 KB
04. Changing data in SQL/005 INSERT Keyword 22.html 6.9 KB
31. SQLite Overview Similarities and Differences with PostgreSQL/01. Overview.vtt 6.9 KB
02. Getting started/06. Importing the data.vtt 6.9 KB
31. SQLite Overview Similarities and Differences with PostgreSQL/05. Data types in SQLite - 1.vtt 6.9 KB
13. Views/003 CREATE VIEW Clause 12.html 6.8 KB
05. Exploring more complex SQL operations/014 CAST Function.html 6.8 KB
19. Migration Practical Exercise/05. Sample solution (part 2).vtt 6.8 KB
09. JOINs/003 CROSS JOIN.html 6.8 KB
10. GROUP BY/002 GROUP BY Keyword.html 6.8 KB
01. Introduction/02. About this course.vtt 6.8 KB
05. Exploring more complex SQL operations/04. String functions (part 1).vtt 6.7 KB
21. Complex Statistical Queries/12. Common Table Expressions (CTEs).vtt 6.7 KB
24. Stored Procedures/03. What does the $$ mean.vtt 6.7 KB
26. Additional Topics/03. Speeding up a full-text search.vtt 6.7 KB
04. Changing data in SQL/03. INSERTing data.vtt 6.7 KB
21. Complex Statistical Queries/013 ROW_NUMBER Function.html 6.7 KB
25. Triggers/12. Triggers and permissions.vtt 6.7 KB
14. Transactions/006 SAVEPOINT Keyword.html 6.6 KB
06. Table Management/005 The ALTER TABLE statement.html 6.6 KB
14. Transactions/05. How transactions work, performance implications.vtt 6.6 KB
06. Table Management/07. Disabling NULL for a column.vtt 6.6 KB
08. Subqueries/004 Correlated Subquery.html 6.6 KB
05. Exploring more complex SQL operations/07. Type casting with CAST.vtt 6.6 KB
09. JOINs/03. INNER JOIN.vtt 6.5 KB
05. Exploring more complex SQL operations/010 String Functions 33.html 6.5 KB
08. Subqueries/010 Subqueries in WHERE clauses 12.html 6.5 KB
05. Exploring more complex SQL operations/03. NULL and aggregate functions (MIN, MAX, COUNT, ,...).vtt 6.5 KB
24. Stored Procedures/02. Creating a stored procedure.vtt 6.4 KB
21. Complex Statistical Queries/09. The ROW_NUMBER function.vtt 6.4 KB
05. Exploring more complex SQL operations/017 Numeric Functions 22.html 6.4 KB
08. Subqueries/011 Subqueries in WHERE clauses 22.html 6.4 KB
08. Subqueries/04. Self-correlated subquery.vtt 6.4 KB
02. Getting started/03. Connecting to PostgreSQL through pgAdmin 4.vtt 6.4 KB
05. Exploring more complex SQL operations/008 String Functions 13.html 6.3 KB
09. JOINs/008 LEFT JOIN.html 6.3 KB
19. Migration Practical Exercise/03. Exercise refactoring data.vtt 6.3 KB
03. Introduction to SQL querying statements/015 Aggregate Functions 22.html 6.3 KB
08. Subqueries/01. Introduction, first subselect.vtt 6.3 KB
05. Exploring more complex SQL operations/012 COALESCE Function.html 6.2 KB
03. Introduction to SQL querying statements/023 BETWEEN Keyword.html 6.2 KB
03. Introduction to SQL querying statements/010 Comments.html 6.2 KB
04. Changing data in SQL/004 INSERT Keyword 12.html 6.2 KB
01. Introduction/01. Introduction.vtt 6.1 KB
20. Arrays/09. The ANY and ALL functions.vtt 6.1 KB
03. Introduction to SQL querying statements/09. The BETWEEN and IN clause.vtt 6.1 KB
20. Arrays/06. How to access an array.vtt 6.1 KB
22. Collations/05. Collations and Indexes.vtt 6.0 KB
08. Subqueries/015 Combining Queries With UNION.html 6.0 KB
16. Constraints/01. Overview.vtt 5.9 KB
03. Introduction to SQL querying statements/020 LIKE Keyword 22.html 5.9 KB
08. Subqueries/03. Renaming table with AS.vtt 5.9 KB
03. Introduction to SQL querying statements/019 LIKE Keyword 12.html 5.9 KB
26. Additional Topics/05. Best practices - 2.vtt 5.8 KB
03. Introduction to SQL querying statements/009 Multiple Statements.html 5.8 KB
05. Exploring more complex SQL operations/016 Numeric Functions 12.html 5.8 KB
03. Introduction to SQL querying statements/004 Your first coding exercise SELECTing data.html 5.7 KB
03. Introduction to SQL querying statements/012 AS Keyword.html 5.7 KB
03. Introduction to SQL querying statements/014 Aggregate Functions 12.html 5.7 KB
22. Collations/06. Language-specific collations.vtt 5.7 KB
03. Introduction to SQL querying statements/022 IN Keyword.html 5.6 KB
04. Changing data in SQL/009 UPDATE Keyword 22.html 5.6 KB
25. Triggers/03. Variables in PLpgSQL.vtt 5.6 KB
03. Introduction to SQL querying statements/003 Let's explore Interactive code exercises!.html 5.6 KB
04. Changing data in SQL/011 DELETE Keyword.html 5.6 KB
03. Introduction to SQL querying statements/006 WHERE Keyword 12.html 5.6 KB
05. Exploring more complex SQL operations/09. The CASE WHEN block.vtt 5.5 KB
06. Table Management/024 The DROP TABLE statement.html 5.5 KB
08. Subqueries/002 First Subselect.html 5.5 KB
10. GROUP BY/01. A first GROUP BY clause.vtt 5.5 KB
20. Arrays/18. Coding Exercise Bonus, optimized search with an index.html 5.4 KB
16. Constraints/05. Heads-up (STRPOS).vtt 5.4 KB
06. Table Management/13. TRUNCATE and DROP.vtt 5.4 KB
03. Introduction to SQL querying statements/025 ORDER BY.html 5.4 KB
05. Exploring more complex SQL operations/003 NULL Value 12.html 5.4 KB
02. Getting started/02. Installing PostgreSQL.vtt 5.3 KB
04. Changing data in SQL/007 UPDATE Keyword 12.html 5.3 KB
03. Introduction to SQL querying statements/007 WHERE Keyword 22.html 5.3 KB
07. Data Modeling/03. Creating the albums table.vtt 5.3 KB
22. Collations/04. Changing the collation of a column.vtt 5.2 KB
05. Exploring more complex SQL operations/05. String functions (part 2).vtt 5.2 KB
22. Collations/01. Overview.vtt 5.2 KB
03. Introduction to SQL querying statements/017 DISTINCT Keyword.html 5.2 KB
03. Introduction to SQL querying statements/07. Getting DISTINCT entries.vtt 5.1 KB
20. Arrays/02. Creating a first array.vtt 5.1 KB
05. Exploring more complex SQL operations/004 NULL Value 22.html 5.1 KB
23. Permissions/assets/02. data-center.sql 5.0 KB
14. Transactions/06. The ACID properties.vtt 5.0 KB
21. Complex Statistical Queries/15. When to use what.vtt 5.0 KB
21. Complex Statistical Queries/03. Importing and exploring the data.vtt 4.9 KB
20. Arrays/20. Modifying an array.vtt 4.9 KB
30. MySQL Overview Similarities and Differences with PostgreSQL/01. Overview.vtt 4.8 KB
07. Data Modeling/04. Exercise creating tracks table.vtt 4.8 KB
03. Introduction to SQL querying statements/04. Multiple SQL statements and comments.vtt 4.8 KB
17. Dates/08. Keeping track of creation time of an entry.vtt 4.7 KB
21. Complex Statistical Queries/01. Overview.vtt 4.7 KB
13. Views/05. Updatable VIEWs.vtt 4.6 KB
30. MySQL Overview Similarities and Differences with PostgreSQL/07. Differences between PostgreSQL and MySQL - 2.vtt 4.6 KB
17. Dates/03. Creating the data.vtt 4.6 KB
24. Stored Procedures/05. Managing permissions on stored procedures - 2.vtt 4.5 KB
05. Exploring more complex SQL operations/10. WHERE and brackets (...).vtt 4.5 KB
10. GROUP BY/03. Filter after grouping (HAVING).vtt 4.4 KB
06. Table Management/02. Creating a first table.vtt 4.3 KB
21. Complex Statistical Queries/05. The ROLLUP function.vtt 4.2 KB
10. GROUP BY/04. How is a query executed.vtt 4.1 KB
29. PostgreSQL with Python/06. Passing parameters through dictionaries.vtt 4.1 KB
14. Transactions/04. SAVEPOINT in a transaction.vtt 4.1 KB
20. Arrays/24. Coding Exercise Solution Modifying an array 22.html 4.1 KB
20. Arrays/05. Coding Exercise Solution Creating a first array.html 4.1 KB
17. Dates/02. TIME, DATE, TIMESTAMP.vtt 4.0 KB
18. Practical Exercises with Dates, Times, Timestamps/10. Coding Exercise Timezones.html 4.0 KB
15. Indexes/01. Overview Indexes.vtt 4.0 KB
08. Subqueries/06. Subquery with EXISTS.vtt 4.0 KB
01. Introduction/04. A first outlook SQL.vtt 3.9 KB
10. GROUP BY/02. More complex grouping.vtt 3.9 KB
05. Exploring more complex SQL operations/06. Working with NULL (COALESCE).vtt 3.9 KB
25. Triggers/05. Conditionals in PLpgSQL.vtt 3.9 KB
07. Data Modeling/05. Exercise SQL code.html 3.8 KB
32. Closing Words/01. Closing Words.vtt 3.8 KB
14. Transactions/07. Transaction controls from pgAdmin 4.vtt 3.8 KB
07. Data Modeling/assets/06. lecture-sql-code.txt 3.7 KB
14. Transactions/01. Overview (transactions).vtt 3.7 KB
07. Data Modeling/01. Overview.vtt 3.7 KB
18. Practical Exercises with Dates, Times, Timestamps/06. Coding Exercise Extracting data from timestamps 12.html 3.6 KB
20. Arrays/04. Coding Exercise Creating a first array.html 3.6 KB
07. Data Modeling/06. Exercise solution.vtt 3.6 KB
19. Migration Practical Exercise/01. Overview.vtt 3.6 KB
16. Constraints/assets/02. biking3.sql 3.5 KB
25. Triggers/04. Loops in PLpgSQL.vtt 3.5 KB
29. PostgreSQL with Python/01. Overview.vtt 3.5 KB
20. Arrays/19. Coding Exercise Solution Bonus, optimized search with an index.html 3.4 KB
25. Triggers/13. Triggers and the SQL standard.vtt 3.4 KB
06. Table Management/08. Boolean columns.vtt 3.4 KB
14. Transactions/03. Accessing data within a transaction.vtt 3.2 KB
18. Practical Exercises with Dates, Times, Timestamps/assets/01. dates-exercises.sql 3.2 KB
07. Data Modeling/assets/02. lecture-sql-code.txt 3.2 KB
21. Complex Statistical Queries/06. The CUBE function.vtt 3.0 KB
25. Triggers/01. Overview.vtt 3.0 KB
03. Introduction to SQL querying statements/13. Bonus Quotes in MySQL and MariaDB.vtt 2.9 KB
05. Exploring more complex SQL operations/01. Overview.vtt 2.8 KB
22. Collations/assets/02. cities.sql 2.8 KB
23. Permissions/05. Revoking permissions from roles.vtt 2.7 KB
03. Introduction to SQL querying statements/05. Renaming columns with AS.vtt 2.7 KB
20. Arrays/23. Coding Exercise Modifying an array 22.html 2.7 KB
18. Practical Exercises with Dates, Times, Timestamps/02. Coding Exercise TIME, DATE, TIMESTAMP 12.html 2.7 KB
20. Arrays/21. Coding Exercise Modifying an array 12.html 2.5 KB
02. Getting started/01. Why PostgreSQL.vtt 2.4 KB
18. Practical Exercises with Dates, Times, Timestamps/04. Coding Exercise TIME, DATE, TIMESTAMP 22.html 2.4 KB
18. Practical Exercises with Dates, Times, Timestamps/08. Coding Exercise Solution Extracting data from timestamps 22.html 2.4 KB
04. Changing data in SQL/06. Removing entries (DELETE).vtt 2.4 KB
18. Practical Exercises with Dates, Times, Timestamps/07. Coding Exercise Solution Extracting data from timestamps 12.html 2.3 KB
13. Views/01. Overview VIEWs.vtt 2.3 KB
20. Arrays/10. Coding Exercise The ANY and ALL functions 12.html 2.2 KB
09. JOINs/01. Overview JOINs.vtt 2.1 KB
17. Dates/01. Overview.vtt 2.1 KB
18. Practical Exercises with Dates, Times, Timestamps/11. Coding Exercise Solution Timezones.html 2.1 KB
17. Dates/assets/04. concerts.sql 2.1 KB
20. Arrays/15. Coding Exercise The UNNEST function in PostgreSQL.html 2.1 KB
20. Arrays/07. Coding Exercise How to access an array.html 2.0 KB
18. Practical Exercises with Dates, Times, Timestamps/09. Coding Exercise Solution Calculating INTERVALs.html 1.9 KB
20. Arrays/12. Coding Exercise The ANY and ALL functions 22.html 1.9 KB
24. Stored Procedures/01. Overview.vtt 1.8 KB
21. Complex Statistical Queries/08. GROUP BY vs OVER.vtt 1.8 KB
04. Changing data in SQL/05. Updating multiple columns at once (UPDATE).vtt 1.5 KB
20. Arrays/08. Coding Exercise Solution How to access an array.html 1.5 KB
18. Practical Exercises with Dates, Times, Timestamps/03. Coding Exercise Solution TIME, DATE, TIMESTAMP 12.html 1.4 KB
20. Arrays/22. Coding Exercise Solution Modifying an array 12.html 1.4 KB
20. Arrays/11. Coding Exercise Solution The ANY and ALL functions 12.html 1.4 KB
18. Practical Exercises with Dates, Times, Timestamps/05. Coding Exercise Solution TIME, DATE, TIMESTAMP 22.html 1.4 KB
04. Changing data in SQL/07. Heads-up Autocommit.html 1.3 KB
06. Table Management/01. Overview.vtt 1.3 KB
25. Triggers/08. Refreshing data with a trigger (SQL code).html 1.2 KB
15. Indexes/02. Data Download.html 1.0 KB
20. Arrays/13. Coding Exercise Solution The ANY and ALL functions 22.html 1.0 KB
04. Changing data in SQL/01. Overview changing data.vtt 1009 bytes
20. Arrays/16. Coding Exercise Solution The UNNEST function in PostgreSQL.html 939 bytes
16. Constraints/02. Data Download.html 924 bytes
21. Complex Statistical Queries/14. Temporary tables - SQL code.html 835 bytes
04. Changing data in SQL/02. The table students_copy.html 776 bytes
25. Triggers/06. Creating a trigger (SQL code).html 625 bytes
25. Triggers/10. Intercepting an SQL command with a trigger (SQL code).html 590 bytes
01. Introduction/03. Link to the playground.html 589 bytes
18. Practical Exercises with Dates, Times, Timestamps/01. Data for the exercises dates_exercises.sql.html 561 bytes
20. Arrays/03. Data for the exercises arrays_exercises.sql.html 547 bytes
07. Data Modeling/assets/03. lecture-sql-code.txt 440 bytes
21. Complex Statistical Queries/02. Data Download.html 423 bytes
17. Dates/04. Data Download.html 371 bytes
30. MySQL Overview Similarities and Differences with PostgreSQL/02. Data Download.html 316 bytes
01. Introduction/05. Download of the slides.html 305 bytes
23. Permissions/02. Data Download.html 263 bytes
22. Collations/02. Data Download.html 243 bytes
02. Getting started/05. Data Download.html 192 bytes
01. Introduction/external-links/05. Slides.pdf.url 87 bytes
29. PostgreSQL with Python/02. The files for this chapter.html 69 bytes

Udemy - Learn SQL with 80 Interactive Exercises The Hands-on Guide (12.2024)

File List

Download Torrent

Related Resources

Copyright Infringement