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

File Type video

Size 9.10GB

UpdateDate 2025-3-16

hash *****9468073A43E4038C5975F4267767DA9452

Hot 1

Files 01. Introduction/external-links/05. Slides.pdf.url | 87B 01. Introduction/04. A first outlook SQL.mp4 | 26.97MB 01. Introduction/02. About this course.mp4 | 9.32MB 01. Introduction/01. Introduction.mp4 | 9.09MB 01. Introduction/02. About this course.vtt | 6.79KB 01. Introduction/01. Introduction.vtt | 6.13KB 01. Introduction/04. A first outlook SQL.vtt | 3.94KB 01. Introduction/03. Link to the playground.html | 589B 01. Introduction/05. Download of the slides.html | 305B 02. Getting started/assets/05. students.sql | 23.79KB 02. Getting started/03. Connecting to PostgreSQL through pgAdmin 4.mp4 | 67.25MB 02. Getting started/06. Importing the data.mp4 | 48.55MB 02. Getting started/02. Installing PostgreSQL.mp4 | 42.62MB 02. Getting started/04. What is a DBMS Creating a database.mp4 | 23.24MB 02. Getting started/01. Why PostgreSQL.mp4 | 5.61MB 02. Getting started/007 Section Quiz.html | 21.84KB 02. Getting started/04. What is a DBMS Creating a database.vtt | 7.16KB 02. Getting started/06. Importing the data.vtt | 6.90KB 02. Getting started/03. Connecting to PostgreSQL through pgAdmin 4.vtt | 6.35KB 02. Getting started/02. Installing PostgreSQL.vtt | 5.33KB 02. Getting started/01. Why PostgreSQL.vtt | 2.44KB 02. Getting started/05. Data Download.html | 192B 03. Introduction to SQL querying statements/01. Querying the data (SELECT).mp4 | 99.34MB 03. Introduction to SQL querying statements/08. Filtering with LIKE.mp4 | 85.36MB 03. Introduction to SQL querying statements/03. Filtering with WHERE.mp4 | 73.56MB 03. Introduction to SQL querying statements/02. Introduction Interactive code exercises.mp4 | 50.64MB 03. Introduction to SQL querying statements/09. The BETWEEN and IN clause.mp4 | 45.14MB 03. Introduction to SQL querying statements/07. Getting DISTINCT entries.mp4 | 38.69MB 03. Introduction to SQL querying statements/12. Quotes in SQL.mp4 | 29.58MB 03. Introduction to SQL querying statements/10. The ORDER BY clause.mp4 | 28.88MB 03. Introduction to SQL querying statements/06. Aggregate functions in SQL.mp4 | 26.85MB 03. Introduction to SQL querying statements/11. Specifying an offset and a limit.mp4 | 21.78MB 03. Introduction to SQL querying statements/04. Multiple SQL statements and comments.mp4 | 16.58MB 03. Introduction to SQL querying statements/13. Bonus Quotes in MySQL and MariaDB.mp4 | 6.40MB 03. Introduction to SQL querying statements/05. Renaming columns with AS.mp4 | 5.60MB 03. Introduction to SQL querying statements/030 Section Quiz.html | 26.78KB 03. Introduction to SQL querying statements/02. Introduction Interactive code exercises.vtt | 13.11KB 03. Introduction to SQL querying statements/03. Filtering with WHERE.vtt | 10.54KB 03. Introduction to SQL querying statements/06. Aggregate functions in SQL.vtt | 9.30KB 03. Introduction to SQL querying statements/027 Limit and Offset.html | 8.22KB 03. Introduction to SQL querying statements/12. Quotes in SQL.vtt | 8.14KB 03. Introduction to SQL querying statements/08. Filtering with LIKE.vtt | 7.95KB 03. Introduction to SQL querying statements/10. The ORDER BY clause.vtt | 7.89KB 03. Introduction to SQL querying statements/01. Querying the data (SELECT).vtt | 7.73KB 03. Introduction to SQL querying statements/11. Specifying an offset and a limit.vtt | 7.00KB 03. Introduction to SQL querying statements/015 Aggregate Functions 22.html | 6.28KB 03. Introduction to SQL querying statements/023 BETWEEN Keyword.html | 6.20KB 03. Introduction to SQL querying statements/010 Comments.html | 6.18KB 03. Introduction to SQL querying statements/09. The BETWEEN and IN clause.vtt | 6.13KB 03. Introduction to SQL querying statements/020 LIKE Keyword 22.html | 5.90KB 03. Introduction to SQL querying statements/019 LIKE Keyword 12.html | 5.88KB 03. Introduction to SQL querying statements/009 Multiple Statements.html | 5.79KB 03. Introduction to SQL querying statements/004 Your first coding exercise SELECTing data.html | 5.74KB 03. Introduction to SQL querying statements/012 AS Keyword.html | 5.74KB 03. Introduction to SQL querying statements/014 Aggregate Functions 12.html | 5.71KB 03. Introduction to SQL querying statements/022 IN Keyword.html | 5.65KB 03. Introduction to SQL querying statements/003 Let's explore Interactive code exercises!.html | 5.62KB 03. Introduction to SQL querying statements/006 WHERE Keyword 12.html | 5.56KB 03. Introduction to SQL querying statements/025 ORDER BY.html | 5.37KB 03. Introduction to SQL querying statements/007 WHERE Keyword 22.html | 5.30KB 03. Introduction to SQL querying statements/017 DISTINCT Keyword.html | 5.17KB 03. Introduction to SQL querying statements/07. Getting DISTINCT entries.vtt | 5.14KB 03. Introduction to SQL querying statements/04. Multiple SQL statements and comments.vtt | 4.77KB 03. Introduction to SQL querying statements/13. Bonus Quotes in MySQL and MariaDB.vtt | 2.88KB 03. Introduction to SQL querying statements/05. Renaming columns with AS.vtt | 2.69KB 04. Changing data in SQL/04. Updating data (UPDATE).mp4 | 116.06MB 04. Changing data in SQL/03. INSERTing data.mp4 | 71.99MB 04. Changing data in SQL/06. Removing entries (DELETE).mp4 | 7.65MB 04. Changing data in SQL/05. Updating multiple columns at once (UPDATE).mp4 | 5.33MB 04. Changing data in SQL/01. Overview changing data.mp4 | 1.87MB 04. Changing data in SQL/013 Section Quiz.html | 22.28KB 04. Changing data in SQL/04. Updating data (UPDATE).vtt | 7.98KB 04. Changing data in SQL/005 INSERT Keyword 22.html | 6.92KB 04. Changing data in SQL/03. INSERTing data.vtt | 6.71KB 04. Changing data in SQL/004 INSERT Keyword 12.html | 6.18KB 04. Changing data in SQL/009 UPDATE Keyword 22.html | 5.64KB 04. Changing data in SQL/011 DELETE Keyword.html | 5.61KB 04. Changing data in SQL/007 UPDATE Keyword 12.html | 5.31KB 04. Changing data in SQL/06. Removing entries (DELETE).vtt | 2.37KB 04. Changing data in SQL/05. Updating multiple columns at once (UPDATE).vtt | 1.50KB 04. Changing data in SQL/07. Heads-up Autocommit.html | 1.28KB 04. Changing data in SQL/01. Overview changing data.vtt | 1009B 04. Changing data in SQL/02. The table students_copy.html | 776B 05. Exploring more complex SQL operations/08. Important numeric functions.mp4 | 80.10MB 05. Exploring more complex SQL operations/02. The missing value NULL.mp4 | 72.74MB 05. Exploring more complex SQL operations/04. String functions (part 1).mp4 | 48.35MB 05. Exploring more complex SQL operations/03. NULL and aggregate functions (MIN, MAX, COUNT, ,...).mp4 | 25.82MB 05. Exploring more complex SQL operations/09. The CASE WHEN block.mp4 | 21.91MB 05. Exploring more complex SQL operations/07. Type casting with CAST.mp4 | 19.02MB 05. Exploring more complex SQL operations/05. String functions (part 2).mp4 | 16.26MB 05. Exploring more complex SQL operations/06. Working with NULL (COALESCE).mp4 | 11.44MB 05. Exploring more complex SQL operations/10. WHERE and brackets (...).mp4 | 9.03MB 05. Exploring more complex SQL operations/01. Overview.mp4 | 5.73MB 05. Exploring more complex SQL operations/021 Section Quiz.html | 29.51KB 05. Exploring more complex SQL operations/08. Important numeric functions.vtt | 10.81KB 05. Exploring more complex SQL operations/02. The missing value NULL.vtt | 10.13KB 05. Exploring more complex SQL operations/019 CASE WHEN Expression.html | 7.41KB 05. Exploring more complex SQL operations/009 String Functions 23.html | 7.28KB 05. Exploring more complex SQL operations/014 CAST Function.html | 6.82KB 05. Exploring more complex SQL operations/04. String functions (part 1).vtt | 6.75KB 05. Exploring more complex SQL operations/07. Type casting with CAST.vtt | 6.57KB 05. Exploring more complex SQL operations/010 String Functions 33.html | 6.53KB 05. Exploring more complex SQL operations/03. NULL and aggregate functions (MIN, MAX, COUNT, ,...).vtt | 6.46KB 05. Exploring more complex SQL operations/017 Numeric Functions 22.html | 6.40KB 05. Exploring more complex SQL operations/008 String Functions 13.html | 6.31KB 05. Exploring more complex SQL operations/012 COALESCE Function.html | 6.23KB 05. Exploring more complex SQL operations/016 Numeric Functions 12.html | 5.79KB 05. Exploring more complex SQL operations/09. The CASE WHEN block.vtt | 5.51KB 05. Exploring more complex SQL operations/003 NULL Value 12.html | 5.35KB 05. Exploring more complex SQL operations/05. String functions (part 2).vtt | 5.21KB 05. Exploring more complex SQL operations/004 NULL Value 22.html | 5.11KB 05. Exploring more complex SQL operations/10. WHERE and brackets (...).vtt | 4.48KB 05. Exploring more complex SQL operations/06. Working with NULL (COALESCE).vtt | 3.90KB 05. Exploring more complex SQL operations/01. Overview.vtt | 2.76KB 06. Table Management/10. The PRIMARY KEY.mp4 | 138.91MB 06. Table Management/06. Numbers with a decimal point (FLOAT, DECIMAL).mp4 | 112.95MB 06. Table Management/11. Automatically generating a primary key.mp4 | 88.88MB 06. Table Management/05. Numeric types (SMALLINT, INT, BIGINT).mp4 | 68.75MB 06. Table Management/04. Text types (VARCHAR, CHAR, TEXT).mp4 | 59.96MB 06. Table Management/12. Working with binary data (BYTEA).mp4 | 41.37MB 06. Table Management/13. TRUNCATE and DROP.mp4 | 37.26MB 06. Table Management/03. Changing a table (ALTER TABLE).mp4 | 33.26MB 06. Table Management/09. DEFAULT values.mp4 | 29.41MB 06. Table Management/14. Managing the tables through pgAdmin4.mp4 | 27.72MB 06. Table Management/07. Disabling NULL for a column.mp4 | 26.41MB 06. Table Management/08. Boolean columns.mp4 | 13.50MB 06. Table Management/02. Creating a first table.mp4 | 13.42MB 06. Table Management/01. Overview.mp4 | 2.71MB 06. Table Management/029 Section Quiz.html | 30.45KB 06. Table Management/021 Automatically generating primary key.html | 22.52KB 06. Table Management/007 Text types (VARCHAR, CHAR, TEXT).html | 21.95KB 06. Table Management/009 Numeric types (SMALLINT, INT, BIGINT).html | 21.69KB 06. Table Management/011 Numbers with a decimal point (FLOAT, DECIMAL).html | 20.60KB 06. Table Management/018 DEFAULT Constraint.html | 20.48KB 06. Table Management/028 Managing the tables through pgAdmin4.html | 20.08KB 06. Table Management/06. Numbers with a decimal point (FLOAT, DECIMAL).vtt | 14.38KB 06. Table Management/04. Text types (VARCHAR, CHAR, TEXT).vtt | 14.27KB 06. Table Management/11. Automatically generating a primary key.vtt | 11.75KB 06. Table Management/12. Working with binary data (BYTEA).vtt | 10.93KB 06. Table Management/10. The PRIMARY KEY.vtt | 10.07KB 06. Table Management/025 Section Review.html | 9.92KB 06. Table Management/14. Managing the tables through pgAdmin4.vtt | 9.41KB 06. Table Management/014 NOT NULL Constraint.html | 9.10KB 06. Table Management/05. Numeric types (SMALLINT, INT, BIGINT).vtt | 8.80KB 06. Table Management/026 General Review.html | 8.58KB 06. Table Management/03. Changing a table (ALTER TABLE).vtt | 8.55KB 06. Table Management/003 Creating the businesses_contacts table.html | 7.61KB 06. Table Management/09. DEFAULT values.vtt | 7.55KB 06. Table Management/016 BOOLEAN Data Type.html | 7.30KB 06. Table Management/012 Further businesses_contacts modifications.html | 6.95KB 06. Table Management/005 The ALTER TABLE statement.html | 6.62KB 06. Table Management/07. Disabling NULL for a column.vtt | 6.60KB 06. Table Management/024 The DROP TABLE statement.html | 5.50KB 06. Table Management/13. TRUNCATE and DROP.vtt | 5.38KB 06. Table Management/02. Creating a first table.vtt | 4.29KB 06. Table Management/08. Boolean columns.vtt | 3.38KB 06. Table Management/01. Overview.vtt | 1.28KB 07. Data Modeling/assets/06. lecture-sql-code.txt | 3.74KB 07. Data Modeling/assets/02. lecture-sql-code.txt | 3.17KB 07. Data Modeling/assets/03. lecture-sql-code.txt | 440B 07. Data Modeling/10. How to develop a good schema.mp4 | 104.97MB 07. Data Modeling/08. Many-to-many relationship.mp4 | 76.41MB 07. Data Modeling/07. One-to-One relationship.mp4 | 73.74MB 07. Data Modeling/09. Bonus compound primary keys.mp4 | 58.54MB 07. Data Modeling/06. Exercise solution.mp4 | 49.74MB 07. Data Modeling/03. Creating the albums table.mp4 | 39.04MB 07. Data Modeling/02. Creating the artists table.mp4 | 30.27MB 07. Data Modeling/04. Exercise creating tracks table.mp4 | 10.01MB 07. Data Modeling/01. Overview.mp4 | 8.48MB 07. Data Modeling/014 Section Quiz.html | 26.97KB 07. Data Modeling/10. How to develop a good schema.vtt | 14.02KB 07. Data Modeling/011 Example of a Many-to-many relationship.html | 11.92KB 07. Data Modeling/08. Many-to-many relationship.vtt | 9.83KB 07. Data Modeling/07. One-to-One relationship.vtt | 9.65KB 07. Data Modeling/009 Example of One-to-One relationship.html | 8.96KB 07. Data Modeling/09. Bonus compound primary keys.vtt | 7.75KB 07. Data Modeling/02. Creating the artists table.vtt | 7.33KB 07. Data Modeling/004 Example of a One-to-many relationship.html | 7.20KB 07. Data Modeling/03. Creating the albums table.vtt | 5.29KB 07. Data Modeling/04. Exercise creating tracks table.vtt | 4.79KB 07. Data Modeling/05. Exercise SQL code.html | 3.84KB 07. Data Modeling/01. Overview.vtt | 3.65KB 07. Data Modeling/06. Exercise solution.vtt | 3.58KB 08. Subqueries/02. Correlated subquery.mp4 | 56.64MB 08. Subqueries/05. Subqueries in a WHERE condition.mp4 | 49.46MB 08. Subqueries/07. Combining queries with UNION.mp4 | 48.70MB 08. Subqueries/01. Introduction, first subselect.mp4 | 44.72MB 08. Subqueries/06. Subquery with EXISTS.mp4 | 41.28MB 08. Subqueries/04. Self-correlated subquery.mp4 | 26.24MB 08. Subqueries/03. Renaming table with AS.mp4 | 17.35MB 08. Subqueries/016 Section Quiz.html | 22.27KB 08. Subqueries/006 Renaming table with AS.html | 20.63KB 08. Subqueries/07. Combining queries with UNION.vtt | 13.36KB 08. Subqueries/008 Self-Correlated Subquery.html | 8.08KB 08. Subqueries/02. Correlated subquery.vtt | 7.80KB 08. Subqueries/05. Subqueries in a WHERE condition.vtt | 7.37KB 08. Subqueries/013 Subquery With EXISTS.html | 6.94KB 08. Subqueries/004 Correlated Subquery.html | 6.58KB 08. Subqueries/010 Subqueries in WHERE clauses 12.html | 6.52KB 08. Subqueries/011 Subqueries in WHERE clauses 22.html | 6.38KB 08. Subqueries/04. Self-correlated subquery.vtt | 6.37KB 08. Subqueries/01. Introduction, first subselect.vtt | 6.25KB 08. Subqueries/015 Combining Queries With UNION.html | 5.95KB 08. Subqueries/03. Renaming table with AS.vtt | 5.88KB 08. Subqueries/002 First Subselect.html | 5.47KB 08. Subqueries/06. Subquery with EXISTS.vtt | 3.96KB 09. JOINs/03. INNER JOIN.mp4 | 48.71MB 09. JOINs/04. LEFT JOIN, RIGHT JOIN, FULL JOIN.mp4 | 35.01MB 09. JOINs/05. Which to use (a subquery or a join).mp4 | 23.25MB 09. JOINs/02. A first join (CROSS JOIN).mp4 | 20.81MB 09. JOINs/01. Overview JOINs.mp4 | 4.72MB 09. JOINs/011 Section Quiz.html | 25.82KB 09. JOINs/05. Which to use (a subquery or a join).vtt | 10.33KB 09. JOINs/04. LEFT JOIN, RIGHT JOIN, FULL JOIN.vtt | 9.02KB 09. JOINs/02. A first join (CROSS JOIN).vtt | 8.95KB 09. JOINs/005 INNER JOIN 12.html | 8.03KB 09. JOINs/006 INNER JOIN 22.html | 7.76KB 09. JOINs/009 FULL JOIN.html | 7.55KB 09. JOINs/003 CROSS JOIN.html | 6.81KB 09. JOINs/03. INNER JOIN.vtt | 6.54KB 09. JOINs/008 LEFT JOIN.html | 6.29KB 09. JOINs/01. Overview JOINs.vtt | 2.11KB 10. GROUP BY/01. A first GROUP BY clause.mp4 | 17.47MB 10. GROUP BY/03. Filter after grouping (HAVING).mp4 | 13.80MB 10. GROUP BY/04. How is a query executed.mp4 | 12.33MB 10. GROUP BY/02. More complex grouping.mp4 | 12.27MB 10. GROUP BY/008 Section Quiz.html | 23.17KB 10. GROUP BY/004 Complex GROUP BY.html | 8.62KB 10. GROUP BY/006 HAVING KEYWORD.html | 7.80KB 10. GROUP BY/002 GROUP BY Keyword.html | 6.80KB 10. GROUP BY/01. A first GROUP BY clause.vtt | 5.46KB 10. GROUP BY/03. Filter after grouping (HAVING).vtt | 4.40KB 10. GROUP BY/04. How is a query executed.vtt | 4.13KB 10. GROUP BY/02. More complex grouping.vtt | 3.92KB 11 - Exam/001 Practice exam Test your knowledge so far (12).html | 20.30KB 12 - Practical Project/010 Managing Ongoing Projects and Contact Information for Clients.html | 11.13KB 12 - Practical Project/006 Forming Elite Dev Teams.html | 10.28KB 12 - Practical Project/004 Updating and Reverting Project Data 12.html | 8.97KB 12 - Practical Project/001 Classifying Employees for Exclusive Flight Tickets.html | 8.67KB 12 - Practical Project/005 Updating and Reverting Project Data 22.html | 8.36KB 12 - Practical Project/009 Rewarding Employee Loyalty with Prize Money.html | 8.13KB 12 - Practical Project/002 Compiling Engineer Types and Project Overview.html | 7.84KB 12 - Practical Project/007 Creating and Managing App Feature Specifications Table 12.html | 7.61KB 12 - Practical Project/008 Creating and Managing App Feature Specifications Table 22.html | 7.21KB 12 - Practical Project/003 Strategic Pairings and Non-Development Staff Overview.html | 7.15KB 13. Views/04. Materialized views.mp4 | 131.73MB 13. Views/03. Common use cases for VIEWs.mp4 | 69.57MB 13. Views/02. Creating a first VIEW.mp4 | 23.67MB 13. Views/05. Updatable VIEWs.mp4 | 14.01MB 13. Views/01. Overview VIEWs.mp4 | 4.85MB 13. Views/009 Section Quiz.html | 22.88KB 13. Views/007 Materialized Views.html | 21.04KB 13. Views/04. Materialized views.vtt | 9.87KB 13. Views/005 CREATE VIEW Clause 22.html | 9.14KB 13. Views/03. Common use cases for VIEWs.vtt | 9.09KB 13. Views/02. Creating a first VIEW.vtt | 7.14KB 13. Views/003 CREATE VIEW Clause 12.html | 6.82KB 13. Views/05. Updatable VIEWs.vtt | 4.64KB 13. Views/01. Overview VIEWs.vtt | 2.25KB 14. Transactions/02. Create a first transaction.mp4 | 99.95MB 14. Transactions/05. How transactions work, performance implications.mp4 | 25.90MB 14. Transactions/04. SAVEPOINT in a transaction.mp4 | 15.81MB 14. Transactions/01. Overview (transactions).mp4 | 15.06MB 14. Transactions/07. Transaction controls from pgAdmin 4.mp4 | 11.26MB 14. Transactions/06. The ACID properties.mp4 | 10.96MB 14. Transactions/03. Accessing data within a transaction.mp4 | 9.49MB 14. Transactions/010 Section Quiz.html | 25.88KB 14. Transactions/02. Create a first transaction.vtt | 13.79KB 14. Transactions/003 First Transaction.html | 8.44KB 14. Transactions/006 SAVEPOINT Keyword.html | 6.64KB 14. Transactions/05. How transactions work, performance implications.vtt | 6.60KB 14. Transactions/06. The ACID properties.vtt | 4.99KB 14. Transactions/04. SAVEPOINT in a transaction.vtt | 4.12KB 14. Transactions/07. Transaction controls from pgAdmin 4.vtt | 3.82KB 14. Transactions/01. Overview (transactions).vtt | 3.67KB 14. Transactions/03. Accessing data within a transaction.vtt | 3.20KB 15. Indexes/assets/02. biking.bak.sql | 11.96MB 15. Indexes/07. Creating an index (CREATE INDEX).mp4 | 96.87MB 15. Indexes/05. How to measure execution performance.mp4 | 64.11MB 15. Indexes/08. Investigating index problems.mp4 | 58.87MB 15. Indexes/09. Creating a UNIQUE index.mp4 | 36.10MB 15. Indexes/03. Importing and exploring the data.mp4 | 35.68MB 15. Indexes/04. EXPLAINing the query.mp4 | 34.71MB 15. Indexes/06. How does an index improve performance.mp4 | 23.09MB 15. Indexes/01. Overview Indexes.mp4 | 14.64MB 15. Indexes/012 Chapter Quiz.html | 23.84KB 15. Indexes/009 Creating an index (CREATE INDEX).html | 22.05KB 15. Indexes/005 EXPLAINing the query.html | 21.37KB 15. Indexes/05. How to measure execution performance.vtt | 15.05KB 15. Indexes/08. Investigating index problems.vtt | 13.61KB 15. Indexes/07. Creating an index (CREATE INDEX).vtt | 13.00KB 15. Indexes/04. EXPLAINing the query.vtt | 10.26KB 15. Indexes/06. How does an index improve performance.vtt | 9.77KB 15. Indexes/09. Creating a UNIQUE index.vtt | 8.60KB 15. Indexes/03. Importing and exploring the data.vtt | 8.60KB 15. Indexes/01. Overview Indexes.vtt | 3.98KB 15. Indexes/02. Data Download.html | 1.05KB 16. Constraints/assets/02. biking3.sql | 3.53KB 16. Constraints/07. Foreign key constraints.mp4 | 114.88MB 16. Constraints/03. Creating a UNIQUE constraint.mp4 | 108.29MB 16. Constraints/08. Changing the behavior (ON UPDATE, ON DELETE).mp4 | 92.11MB 16. Constraints/06. Creating a custom constraint (CHECK).mp4 | 89.83MB 16. Constraints/05. Heads-up (STRPOS).mp4 | 74.71MB 16. Constraints/04. Unique constraint vs index.mp4 | 54.93MB 16. Constraints/01. Overview.mp4 | 44.52MB 16. Constraints/012 Section Quiz.html | 26.51KB 16. Constraints/004 Creating a UNIQUE constraint.html | 22.67KB 16. Constraints/010 Foreign key constraints.html | 22.61KB 16. Constraints/008 Creating a custom constraint (CHECK).html | 21.34KB 16. Constraints/08. Changing the behavior (ON UPDATE, ON DELETE).vtt | 21.30KB 16. Constraints/07. Foreign key constraints.vtt | 14.98KB 16. Constraints/03. Creating a UNIQUE constraint.vtt | 14.40KB 16. Constraints/06. Creating a custom constraint (CHECK).vtt | 11.95KB 16. Constraints/04. Unique constraint vs index.vtt | 7.07KB 16. Constraints/01. Overview.vtt | 5.91KB 16. Constraints/05. Heads-up (STRPOS).vtt | 5.40KB 16. Constraints/02. Data Download.html | 924B 17. Dates/assets/04. concerts.sql | 2.10KB 17. Dates/07. Timezones.mp4 | 71.33MB 17. Dates/08. Keeping track of creation time of an entry.mp4 | 61.01MB 17. Dates/05. Extracting data from timestamps.mp4 | 59.20MB 17. Dates/06. Calculating INTERVALs.mp4 | 50.16MB 17. Dates/02. TIME, DATE, TIMESTAMP.mp4 | 30.13MB 17. Dates/03. Creating the data.mp4 | 19.76MB 17. Dates/01. Overview.mp4 | 4.39MB 17. Dates/012 Section Quiz.html | 27.03KB 17. Dates/009 Calculating INTERVALs.html | 21.13KB 17. Dates/007 Extracting data from timestamps.html | 20.81KB 17. Dates/003 TIME, DATE, TIMESTAMP.html | 20.73KB 17. Dates/07. Timezones.vtt | 16.73KB 17. Dates/06. Calculating INTERVALs.vtt | 12.26KB 17. Dates/05. Extracting data from timestamps.vtt | 7.50KB 17. Dates/08. Keeping track of creation time of an entry.vtt | 4.68KB 17. Dates/03. Creating the data.vtt | 4.57KB 17. Dates/02. TIME, DATE, TIMESTAMP.vtt | 4.04KB 17. Dates/01. Overview.vtt | 2.11KB 17. Dates/04. Data Download.html | 371B 18. Practical Exercises with Dates, Times, Timestamps/assets/01. dates-exercises.sql | 3.18KB 18. Practical Exercises with Dates, Times, Timestamps/010 Coding Exercise Calculating INTERVALs.html | 19.44KB 18. Practical Exercises with Dates, Times, Timestamps/008 Coding Exercise Extracting data from timestamps 22.html | 19.43KB 18. Practical Exercises with Dates, Times, Timestamps/10. Coding Exercise Timezones.html | 4.03KB 18. Practical Exercises with Dates, Times, Timestamps/06. Coding Exercise Extracting data from timestamps 12.html | 3.64KB 18. Practical Exercises with Dates, Times, Timestamps/02. Coding Exercise TIME, DATE, TIMESTAMP 12.html | 2.67KB 18. Practical Exercises with Dates, Times, Timestamps/04. Coding Exercise TIME, DATE, TIMESTAMP 22.html | 2.42KB 18. Practical Exercises with Dates, Times, Timestamps/08. Coding Exercise Solution Extracting data from timestamps 22.html | 2.39KB 18. Practical Exercises with Dates, Times, Timestamps/07. Coding Exercise Solution Extracting data from timestamps 12.html | 2.26KB 18. Practical Exercises with Dates, Times, Timestamps/11. Coding Exercise Solution Timezones.html | 2.10KB 18. Practical Exercises with Dates, Times, Timestamps/09. Coding Exercise Solution Calculating INTERVALs.html | 1.94KB 18. Practical Exercises with Dates, Times, Timestamps/03. Coding Exercise Solution TIME, DATE, TIMESTAMP 12.html | 1.44KB 18. Practical Exercises with Dates, Times, Timestamps/05. Coding Exercise Solution TIME, DATE, TIMESTAMP 22.html | 1.37KB 18. Practical Exercises with Dates, Times, Timestamps/01. Data for the exercises dates_exercises.sql.html | 561B 19. Migration Practical Exercise/05. Sample solution (part 2).mp4 | 86.87MB 19. Migration Practical Exercise/04. Sample solution (part 1).mp4 | 65.09MB 19. Migration Practical Exercise/02. How to perform a migration.mp4 | 56.21MB 19. Migration Practical Exercise/03. Exercise refactoring data.mp4 | 48.33MB 19. Migration Practical Exercise/01. Overview.mp4 | 7.84MB 19. Migration Practical Exercise/02. How to perform a migration.vtt | 13.89KB 19. Migration Practical Exercise/04. Sample solution (part 1).vtt | 8.82KB 19. Migration Practical Exercise/05. Sample solution (part 2).vtt | 6.82KB 19. Migration Practical Exercise/03. Exercise refactoring data.vtt | 6.28KB 19. Migration Practical Exercise/01. Overview.vtt | 3.57KB 20. Arrays/assets/03. arrays-exercises.sql | 37.50KB 20. Arrays/17. Bonus, optimized search with an index.mp4 | 112.27MB 20. Arrays/14. The UNNEST function in PostgreSQL.mp4 | 84.58MB 20. Arrays/25. When to use an array (best practices).mp4 | 40.15MB 20. Arrays/01. Overview Arrays.mp4 | 25.72MB 20. Arrays/09. The ANY and ALL functions.mp4 | 23.89MB 20. Arrays/06. How to access an array.mp4 | 21.76MB 20. Arrays/02. Creating a first array.mp4 | 20.31MB 20. Arrays/20. Modifying an array.mp4 | 20.17MB 20. Arrays/029 Section Quiz.html | 22.98KB 20. Arrays/007 How to access an array.html | 21.13KB 20. Arrays/023 Modifying an array.html | 21.12KB 20. Arrays/011 The ANY and ALL functions.html | 20.95KB 20. Arrays/25. When to use an array (best practices).vtt | 9.79KB 20. Arrays/01. Overview Arrays.vtt | 8.47KB 20. Arrays/14. The UNNEST function in PostgreSQL.vtt | 8.45KB 20. Arrays/09. The ANY and ALL functions.vtt | 6.13KB 20. Arrays/06. How to access an array.vtt | 6.11KB 20. Arrays/18. Coding Exercise Bonus, optimized search with an index.html | 5.44KB 20. Arrays/02. Creating a first array.vtt | 5.14KB 20. Arrays/20. Modifying an array.vtt | 4.87KB 20. Arrays/24. Coding Exercise Solution Modifying an array 22.html | 4.10KB 20. Arrays/05. Coding Exercise Solution Creating a first array.html | 4.08KB 20. Arrays/04. Coding Exercise Creating a first array.html | 3.63KB 20. Arrays/19. Coding Exercise Solution Bonus, optimized search with an index.html | 3.45KB 20. Arrays/23. Coding Exercise Modifying an array 22.html | 2.68KB 20. Arrays/21. Coding Exercise Modifying an array 12.html | 2.51KB 20. Arrays/10. Coding Exercise The ANY and ALL functions 12.html | 2.19KB 20. Arrays/15. Coding Exercise The UNNEST function in PostgreSQL.html | 2.06KB 20. Arrays/07. Coding Exercise How to access an array.html | 2.02KB 20. Arrays/12. Coding Exercise The ANY and ALL functions 22.html | 1.94KB 20. Arrays/08. Coding Exercise Solution How to access an array.html | 1.47KB 20. Arrays/22. Coding Exercise Solution Modifying an array 12.html | 1.39KB 20. Arrays/11. Coding Exercise Solution The ANY and ALL functions 12.html | 1.38KB 20. Arrays/13. Coding Exercise Solution The ANY and ALL functions 22.html | 1.01KB 20. Arrays/16. Coding Exercise Solution The UNNEST function in PostgreSQL.html | 939B 20. Arrays/03. Data for the exercises arrays_exercises.sql.html | 547B 21. Complex Statistical Queries/assets/02. salaries.sql | 4.63MB 21. Complex Statistical Queries/04. GROUPING SETS and GROUPING.mp4 | 192.66MB 21. Complex Statistical Queries/10. The LAG and LEAD functions.mp4 | 156.42MB 21. Complex Statistical Queries/07. OVER and PARTITION BY.mp4 | 129.51MB 21. Complex Statistical Queries/11. The STRING_AGG and ARRAY_AGG functions.mp4 | 75.35MB 21. Complex Statistical Queries/12. Common Table Expressions (CTEs).mp4 | 47.46MB 21. Complex Statistical Queries/13. Temporary tables.mp4 | 34.08MB 21. Complex Statistical Queries/09. The ROW_NUMBER function.mp4 | 20.72MB 21. Complex Statistical Queries/03. Importing and exploring the data.mp4 | 19.84MB 21. Complex Statistical Queries/05. The ROLLUP function.mp4 | 17.77MB 21. Complex Statistical Queries/15. When to use what.mp4 | 14.73MB 21. Complex Statistical Queries/06. The CUBE function.mp4 | 11.89MB 21. Complex Statistical Queries/01. Overview.mp4 | 10.16MB 21. Complex Statistical Queries/08. GROUP BY vs OVER.mp4 | 4.32MB 21. Complex Statistical Queries/020 Section Quiz.html | 24.03KB 21. Complex Statistical Queries/005 GROUPING SETS and GROUPING.html | 21.73KB 21. Complex Statistical Queries/04. GROUPING SETS and GROUPING.vtt | 14.55KB 21. Complex Statistical Queries/07. OVER and PARTITION BY.vtt | 12.75KB 21. Complex Statistical Queries/10. The LAG and LEAD functions.vtt | 11.01KB 21. Complex Statistical Queries/13. Temporary tables.vtt | 8.78KB 21. Complex Statistical Queries/007 ROLLUP Function.html | 8.43KB 21. Complex Statistical Queries/11. The STRING_AGG and ARRAY_AGG functions.vtt | 7.62KB 21. Complex Statistical Queries/010 OVER and PARTITION BY clauses.html | 7.06KB 21. Complex Statistical Queries/12. Common Table Expressions (CTEs).vtt | 6.73KB 21. Complex Statistical Queries/013 ROW_NUMBER Function.html | 6.69KB 21. Complex Statistical Queries/09. The ROW_NUMBER function.vtt | 6.44KB 21. Complex Statistical Queries/15. When to use what.vtt | 4.95KB 21. Complex Statistical Queries/03. Importing and exploring the data.vtt | 4.92KB 21. Complex Statistical Queries/01. Overview.vtt | 4.66KB 21. Complex Statistical Queries/05. The ROLLUP function.vtt | 4.22KB 21. Complex Statistical Queries/06. The CUBE function.vtt | 3.03KB 21. Complex Statistical Queries/08. GROUP BY vs OVER.vtt | 1.76KB 21. Complex Statistical Queries/14. Temporary tables - SQL code.html | 835B 21. Complex Statistical Queries/02. Data Download.html | 423B 22. Collations/assets/02. cities.sql | 2.76KB 22. Collations/03. Using a different collation.mp4 | 174.42MB 22. Collations/05. Collations and Indexes.mp4 | 23.84MB 22. Collations/04. Changing the collation of a column.mp4 | 22.30MB 22. Collations/01. Overview.mp4 | 20.91MB 22. Collations/06. Language-specific collations.mp4 | 19.16MB 22. Collations/008 Section Quiz.html | 21.97KB 22. Collations/004 Using a different collation.html | 21.01KB 22. Collations/03. Using a different collation.vtt | 11.67KB 22. Collations/05. Collations and Indexes.vtt | 5.97KB 22. Collations/06. Language-specific collations.vtt | 5.67KB 22. Collations/04. Changing the collation of a column.vtt | 5.24KB 22. Collations/01. Overview.vtt | 5.20KB 22. Collations/02. Data Download.html | 243B 23. Permissions/assets/02. data-center.sql | 5.02KB 23. Permissions/01. Overview.mp4 | 75.05MB 23. Permissions/04. Granting permissions to roles.mp4 | 68.78MB 23. Permissions/07. Using a VIEW with permissions.mp4 | 39.25MB 23. Permissions/03. Creating a user, logging in as a user.mp4 | 37.23MB 23. Permissions/06. Managing permissions through pgAdmin 4.mp4 | 29.98MB 23. Permissions/05. Revoking permissions from roles.mp4 | 7.80MB 23. Permissions/009 Section Quiz.html | 23.05KB 23. Permissions/004 Creating a user, logging in as a user.html | 21.17KB 23. Permissions/01. Overview.vtt | 9.98KB 23. Permissions/03. Creating a user, logging in as a user.vtt | 9.37KB 23. Permissions/07. Using a VIEW with permissions.vtt | 9.31KB 23. Permissions/04. Granting permissions to roles.vtt | 9.07KB 23. Permissions/06. Managing permissions through pgAdmin 4.vtt | 7.41KB 23. Permissions/05. Revoking permissions from roles.vtt | 2.74KB 23. Permissions/02. Data Download.html | 263B 24. Stored Procedures/04. Managing permissions on stored procedures - 1.mp4 | 65.76MB 24. Stored Procedures/05. Managing permissions on stored procedures - 2.mp4 | 32.54MB 24. Stored Procedures/03. What does the $$ mean.mp4 | 26.76MB 24. Stored Procedures/02. Creating a stored procedure.mp4 | 26.20MB 24. Stored Procedures/01. Overview.mp4 | 14.02MB 24. Stored Procedures/007 Section Quiz.html | 23.51KB 24. Stored Procedures/003 Creating a stored procedure.html | 21.14KB 24. Stored Procedures/04. Managing permissions on stored procedures - 1.vtt | 8.57KB 24. Stored Procedures/03. What does the $$ mean.vtt | 6.72KB 24. Stored Procedures/02. Creating a stored procedure.vtt | 6.45KB 24. Stored Procedures/05. Managing permissions on stored procedures - 2.vtt | 4.50KB 24. Stored Procedures/01. Overview.vtt | 1.81KB 25. Triggers/09. Refreshing data with a trigger.mp4 | 179.65MB 25. Triggers/07. Creating a trigger.mp4 | 142.92MB 25. Triggers/11. Intercepting an SQL command with a trigger.mp4 | 136.27MB 25. Triggers/12. Triggers and permissions.mp4 | 50.13MB 25. Triggers/02. Writing a PLpgSQL script.mp4 | 27.98MB 25. Triggers/03. Variables in PLpgSQL.mp4 | 21.97MB 25. Triggers/04. Loops in PLpgSQL.mp4 | 14.82MB 25. Triggers/13. Triggers and the SQL standard.mp4 | 13.95MB 25. Triggers/05. Conditionals in PLpgSQL.mp4 | 12.30MB 25. Triggers/01. Overview.mp4 | 6.86MB 25. Triggers/017 Section Quiz.html | 25.54KB 25. Triggers/09. Refreshing data with a trigger.vtt | 24.53KB 25. Triggers/010 Creating a trigger.html | 21.10KB 25. Triggers/004 Variables in PLpgSQL.html | 20.97KB 25. Triggers/007 Conditionals in PLpgSQL.html | 20.63KB 25. Triggers/07. Creating a trigger.vtt | 13.09KB 25. Triggers/11. Intercepting an SQL command with a trigger.vtt | 12.83KB 25. Triggers/02. Writing a PLpgSQL script.vtt | 9.14KB 25. Triggers/12. Triggers and permissions.vtt | 6.69KB 25. Triggers/03. Variables in PLpgSQL.vtt | 5.64KB 25. Triggers/05. Conditionals in PLpgSQL.vtt | 3.87KB 25. Triggers/04. Loops in PLpgSQL.vtt | 3.52KB 25. Triggers/13. Triggers and the SQL standard.vtt | 3.41KB 25. Triggers/01. Overview.vtt | 3.00KB 25. Triggers/08. Refreshing data with a trigger (SQL code).html | 1.21KB 25. Triggers/06. Creating a trigger (SQL code).html | 625B 25. Triggers/10. Intercepting an SQL command with a trigger (SQL code).html | 590B 26. Additional Topics/02. Full-text search in PostgreSQL.mp4 | 156.96MB 26. Additional Topics/01. Exporting data with PostgreSQL.mp4 | 131.80MB 26. Additional Topics/04. Best practices - 1.mp4 | 75.62MB 26. Additional Topics/03. Speeding up a full-text search.mp4 | 51.22MB 26. Additional Topics/05. Best practices - 2.mp4 | 40.64MB 26. Additional Topics/06. Best practices - 3.mp4 | 16.24MB 26. Additional Topics/009 Section Quiz.html | 22.74KB 26. Additional Topics/003 Full-text search in PostgreSQL.html | 21.21KB 26. Additional Topics/006 Best practices - 1.html | 21.05KB 26. Additional Topics/02. Full-text search in PostgreSQL.vtt | 20.68KB 26. Additional Topics/01. Exporting data with PostgreSQL.vtt | 18.49KB 26. Additional Topics/04. Best practices - 1.vtt | 10.24KB 26. Additional Topics/06. Best practices - 3.vtt | 7.44KB 26. Additional Topics/03. Speeding up a full-text search.vtt | 6.72KB 26. Additional Topics/05. Best practices - 2.vtt | 5.84KB 27 - Practical Project 2/008 Finalizing Revenue Report for US Branch.html | 10.53KB 27 - Practical Project 2/002 Optimizing Candidate Management 12.html | 10.31KB 27 - Practical Project 2/001 Consolidating U.S. Client Connections for Market Expansion.html | 9.88KB 27 - Practical Project 2/007 Critical Financial and Resource Analysis 22.html | 9.28KB 27 - Practical Project 2/006 Critical Financial and Resource Analysis 12.html | 8.76KB 27 - Practical Project 2/003 Optimizing Candidate Management 22.html | 8.74KB 27 - Practical Project 2/004 Fixing Syntax of Unorthodox Transaction.html | 7.95KB 27 - Practical Project 2/005 Fixing Interview Scheduling Issues.html | 7.36KB 28 - Exam/001 Practice exam Test your knowledge (22).html | 18.25KB 29. PostgreSQL with Python/assets/02. Archive.zip | 11.11KB 29. PostgreSQL with Python/07. Preventing SQL injections.mp4 | 253.66MB 29. PostgreSQL with Python/04. Connecting to PostgreSQL.mp4 | 220.93MB 29. PostgreSQL with Python/08. Bonus Object Relational Mappers (ORMs).mp4 | 132.42MB 29. PostgreSQL with Python/05. Inserting data in PostgreSQL.mp4 | 125.78MB 29. PostgreSQL with Python/03. Installing Python and VS Code.mp4 | 67.82MB 29. PostgreSQL with Python/06. Passing parameters through dictionaries.mp4 | 32.20MB 29. PostgreSQL with Python/01. Overview.mp4 | 7.76MB 29. PostgreSQL with Python/008 Preventing SQL injections.html | 20.25KB 29. PostgreSQL with Python/07. Preventing SQL injections.vtt | 18.88KB 29. PostgreSQL with Python/08. Bonus Object Relational Mappers (ORMs).vtt | 18.06KB 29. PostgreSQL with Python/04. Connecting to PostgreSQL.vtt | 15.68KB 29. PostgreSQL with Python/05. Inserting data in PostgreSQL.vtt | 9.48KB 29. PostgreSQL with Python/03. Installing Python and VS Code.vtt | 8.94KB 29. PostgreSQL with Python/06. Passing parameters through dictionaries.vtt | 4.13KB 29. PostgreSQL with Python/01. Overview.vtt | 3.50KB 29. PostgreSQL with Python/02. The files for this chapter.html | 69B 30. MySQL Overview Similarities and Differences with PostgreSQL/assets/02. students.sql | 23.79KB 30. MySQL Overview Similarities and Differences with PostgreSQL/03. MySQL installation.mp4 | 105.98MB 30. MySQL Overview Similarities and Differences with PostgreSQL/05. Differences between PostgreSQL and MySQL - 1.mp4 | 95.33MB 30. MySQL Overview Similarities and Differences with PostgreSQL/08. Data types in MySQL.mp4 | 70.03MB 30. MySQL Overview Similarities and Differences with PostgreSQL/07. Differences between PostgreSQL and MySQL - 2.mp4 | 52.43MB 30. MySQL Overview Similarities and Differences with PostgreSQL/09. The utf8_general_ci collation.mp4 | 31.65MB 30. MySQL Overview Similarities and Differences with PostgreSQL/04. Using MySQL Workbench.mp4 | 20.31MB 30. MySQL Overview Similarities and Differences with PostgreSQL/06. Similarities between PostgreSQL and MySQL.mp4 | 15.10MB 30. MySQL Overview Similarities and Differences with PostgreSQL/01. Overview.mp4 | 11.93MB 30. MySQL Overview Similarities and Differences with PostgreSQL/010 Section Quiz.html | 24.42KB 30. MySQL Overview Similarities and Differences with PostgreSQL/08. Data types in MySQL.vtt | 15.50KB 30. MySQL Overview Similarities and Differences with PostgreSQL/03. MySQL installation.vtt | 8.90KB 30. MySQL Overview Similarities and Differences with PostgreSQL/09. The utf8_general_ci collation.vtt | 7.55KB 30. MySQL Overview Similarities and Differences with PostgreSQL/01. Overview.vtt | 4.84KB 30. MySQL Overview Similarities and Differences with PostgreSQL/07. Differences between PostgreSQL and MySQL - 2.vtt | 4.64KB 30. MySQL Overview Similarities and Differences with PostgreSQL/02. Data Download.html | 316B 31. SQLite Overview Similarities and Differences with PostgreSQL/06. Data types in SQLite - 2.mp4 | 127.31MB 31. SQLite Overview Similarities and Differences with PostgreSQL/03. Differences between PostgreSQL and SQLite - 1.mp4 | 82.30MB 31. SQLite Overview Similarities and Differences with PostgreSQL/04. Differences between PostgreSQL and SQLite - 2.mp4 | 61.50MB 31. SQLite Overview Similarities and Differences with PostgreSQL/05. Data types in SQLite - 1.mp4 | 52.62MB 31. SQLite Overview Similarities and Differences with PostgreSQL/02. Installing DB Browser.mp4 | 32.17MB 31. SQLite Overview Similarities and Differences with PostgreSQL/01. Overview.mp4 | 15.64MB 31. SQLite Overview Similarities and Differences with PostgreSQL/007 Section Quiz.html | 22.57KB 31. SQLite Overview Similarities and Differences with PostgreSQL/06. Data types in SQLite - 2.vtt | 9.40KB 31. SQLite Overview Similarities and Differences with PostgreSQL/04. Differences between PostgreSQL and SQLite - 2.vtt | 8.16KB 31. SQLite Overview Similarities and Differences with PostgreSQL/03. Differences between PostgreSQL and SQLite - 1.vtt | 7.63KB 31. SQLite Overview Similarities and Differences with PostgreSQL/02. Installing DB Browser.vtt | 7.41KB 31. SQLite Overview Similarities and Differences with PostgreSQL/01. Overview.vtt | 6.91KB 31. SQLite Overview Similarities and Differences with PostgreSQL/05. Data types in SQLite - 1.vtt | 6.87KB 32. Closing Words/01. Closing Words.mp4 | 7.77MB 32. Closing Words/01. Closing Words.vtt | 3.82KB