TorBT - Torrents and Magnet Links Search Engine
Latest Searches: df11, 亚裔, trampling, amber+rayne, ejaculation, 8mm, girl, magnets, 765orecs, 11才

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

Magnet Download Download Torrent
File Name
Size
01. Introduction/external-links/05. Slides.pdf.url
87 B
01. Introduction/04. A first outlook SQL.mp4
27 MB
01. Introduction/02. About this course.mp4
9.3 MB
01. Introduction/01. Introduction.mp4
9.1 MB
01. Introduction/02. About this course.vtt
6.8 kB
01. Introduction/01. Introduction.vtt
6.1 kB
01. Introduction/04. A first outlook SQL.vtt
3.9 kB
01. Introduction/03. Link to the playground.html
589 B
01. Introduction/05. Download of the slides.html
305 B
02. Getting started/assets/05. students.sql
24 kB
02. Getting started/03. Connecting to PostgreSQL through pgAdmin 4.mp4
67 MB
02. Getting started/06. Importing the data.mp4
48 MB
02. Getting started/02. Installing PostgreSQL.mp4
43 MB
02. Getting started/04. What is a DBMS Creating a database.mp4
23 MB
02. Getting started/01. Why PostgreSQL.mp4
5.6 MB
02. Getting started/007 Section Quiz.html
22 kB
02. Getting started/04. What is a DBMS Creating a database.vtt
7.2 kB
02. Getting started/06. Importing the data.vtt
6.9 kB
02. Getting started/03. Connecting to PostgreSQL through pgAdmin 4.vtt
6.4 kB
02. Getting started/02. Installing PostgreSQL.vtt
5.3 kB
02. Getting started/01. Why PostgreSQL.vtt
2.4 kB
02. Getting started/05. Data Download.html
192 B
03. Introduction to SQL querying statements/01. Querying the data (SELECT).mp4
99 MB
03. Introduction to SQL querying statements/08. Filtering with LIKE.mp4
85 MB
03. Introduction to SQL querying statements/03. Filtering with WHERE.mp4
74 MB
03. Introduction to SQL querying statements/02. Introduction Interactive code exercises.mp4
51 MB
03. Introduction to SQL querying statements/09. The BETWEEN and IN clause.mp4
45 MB
03. Introduction to SQL querying statements/07. Getting DISTINCT entries.mp4
39 MB
03. Introduction to SQL querying statements/12. Quotes in SQL.mp4
30 MB
03. Introduction to SQL querying statements/10. The ORDER BY clause.mp4
29 MB
03. Introduction to SQL querying statements/06. Aggregate functions in SQL.mp4
27 MB
03. Introduction to SQL querying statements/11. Specifying an offset and a limit.mp4
22 MB
03. Introduction to SQL querying statements/04. Multiple SQL statements and comments.mp4
17 MB
03. Introduction to SQL querying statements/13. Bonus Quotes in MySQL and MariaDB.mp4
6.4 MB
03. Introduction to SQL querying statements/05. Renaming columns with AS.mp4
5.6 MB
03. Introduction to SQL querying statements/030 Section Quiz.html
27 kB
03. Introduction to SQL querying statements/02. Introduction Interactive code exercises.vtt
13 kB
03. Introduction to SQL querying statements/03. Filtering with WHERE.vtt
10 kB
03. Introduction to SQL querying statements/06. Aggregate functions in SQL.vtt
9.3 kB
03. Introduction to SQL querying statements/027 Limit and Offset.html
8.2 kB
03. Introduction to SQL querying statements/12. Quotes in SQL.vtt
8.1 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
03. Introduction to SQL querying statements/01. Querying the data (SELECT).vtt
7.7 kB
03. Introduction to SQL querying statements/11. Specifying an offset and a limit.vtt
7.0 kB
03. Introduction to SQL querying statements/015 Aggregate Functions 22.html
6.3 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
03. Introduction to SQL querying statements/09. The BETWEEN and IN clause.vtt
6.1 kB
03. Introduction to SQL querying statements/020 LIKE Keyword 22.html
5.9 kB
03. Introduction to SQL querying statements/019 LIKE Keyword 12.html
5.9 kB
03. Introduction to SQL querying statements/009 Multiple Statements.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
03. Introduction to SQL querying statements/022 IN Keyword.html
5.6 kB
03. Introduction to SQL querying statements/003 Let's explore Interactive code exercises!.html
5.6 kB
03. Introduction to SQL querying statements/006 WHERE Keyword 12.html
5.6 kB
03. Introduction to SQL querying statements/025 ORDER BY.html
5.4 kB
03. Introduction to SQL querying statements/007 WHERE Keyword 22.html
5.3 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
03. Introduction to SQL querying statements/04. Multiple SQL statements and comments.vtt
4.8 kB
03. Introduction to SQL querying statements/13. Bonus Quotes in MySQL and MariaDB.vtt
2.9 kB
03. Introduction to SQL querying statements/05. Renaming columns with AS.vtt
2.7 kB
04. Changing data in SQL/04. Updating data (UPDATE).mp4
116 MB
04. Changing data in SQL/03. INSERTing data.mp4
72 MB
04. Changing data in SQL/06. Removing entries (DELETE).mp4
7.7 MB
04. Changing data in SQL/05. Updating multiple columns at once (UPDATE).mp4
5.3 MB
04. Changing data in SQL/01. Overview changing data.mp4
1.9 MB
04. Changing data in SQL/013 Section Quiz.html
22 kB
04. Changing data in SQL/04. Updating data (UPDATE).vtt
8.0 kB
04. Changing data in SQL/005 INSERT Keyword 22.html
6.9 kB
04. Changing data in SQL/03. INSERTing data.vtt
6.7 kB
04. Changing data in SQL/004 INSERT Keyword 12.html
6.2 kB
04. Changing data in SQL/009 UPDATE Keyword 22.html
5.6 kB
04. Changing data in SQL/011 DELETE Keyword.html
5.6 kB
04. Changing data in SQL/007 UPDATE Keyword 12.html
5.3 kB
04. Changing data in SQL/06. Removing entries (DELETE).vtt
2.4 kB
04. Changing data in SQL/05. Updating multiple columns at once (UPDATE).vtt
1.5 kB
04. Changing data in SQL/07. Heads-up Autocommit.html
1.3 kB
04. Changing data in SQL/01. Overview changing data.vtt
1009 B
04. Changing data in SQL/02. The table students_copy.html
776 B
05. Exploring more complex SQL operations/08. Important numeric functions.mp4
80 MB
05. Exploring more complex SQL operations/02. The missing value NULL.mp4
73 MB
05. Exploring more complex SQL operations/04. String functions (part 1).mp4
48 MB
05. Exploring more complex SQL operations/03. NULL and aggregate functions (MIN, MAX, COUNT, ,...).mp4
26 MB
05. Exploring more complex SQL operations/09. The CASE WHEN block.mp4
22 MB
05. Exploring more complex SQL operations/07. Type casting with CAST.mp4
19 MB
05. Exploring more complex SQL operations/05. String functions (part 2).mp4
16 MB
05. Exploring more complex SQL operations/06. Working with NULL (COALESCE).mp4
11 MB
05. Exploring more complex SQL operations/10. WHERE and brackets (...).mp4
9.0 MB
05. Exploring more complex SQL operations/01. Overview.mp4
5.7 MB
05. Exploring more complex SQL operations/021 Section Quiz.html
30 kB
05. Exploring more complex SQL operations/08. Important numeric functions.vtt
11 kB
05. Exploring more complex SQL operations/02. The missing value NULL.vtt
10 kB
05. Exploring more complex SQL operations/019 CASE WHEN Expression.html
7.4 kB
05. Exploring more complex SQL operations/009 String Functions 23.html
7.3 kB
05. Exploring more complex SQL operations/014 CAST Function.html
6.8 kB
05. Exploring more complex SQL operations/04. String functions (part 1).vtt
6.7 kB
05. Exploring more complex SQL operations/07. Type casting with CAST.vtt
6.6 kB
05. Exploring more complex SQL operations/010 String Functions 33.html
6.5 kB
05. Exploring more complex SQL operations/03. NULL and aggregate functions (MIN, MAX, COUNT, ,...).vtt
6.5 kB
05. Exploring more complex SQL operations/017 Numeric Functions 22.html
6.4 kB
05. Exploring more complex SQL operations/008 String Functions 13.html
6.3 kB
05. Exploring more complex SQL operations/012 COALESCE Function.html
6.2 kB
05. Exploring more complex SQL operations/016 Numeric Functions 12.html
5.8 kB
05. Exploring more complex SQL operations/09. The CASE WHEN block.vtt
5.5 kB
05. Exploring more complex SQL operations/003 NULL Value 12.html
5.4 kB
05. Exploring more complex SQL operations/05. String functions (part 2).vtt
5.2 kB
05. Exploring more complex SQL operations/004 NULL Value 22.html
5.1 kB
05. Exploring more complex SQL operations/10. WHERE and brackets (...).vtt
4.5 kB
05. Exploring more complex SQL operations/06. Working with NULL (COALESCE).vtt
3.9 kB
05. Exploring more complex SQL operations/01. Overview.vtt
2.8 kB
06. Table Management/10. The PRIMARY KEY.mp4
139 MB
06. Table Management/06. Numbers with a decimal point (FLOAT, DECIMAL).mp4
113 MB
06. Table Management/11. Automatically generating a primary key.mp4
89 MB
06. Table Management/05. Numeric types (SMALLINT, INT, BIGINT).mp4
69 MB
06. Table Management/04. Text types (VARCHAR, CHAR, TEXT).mp4
60 MB
06. Table Management/12. Working with binary data (BYTEA).mp4
41 MB
06. Table Management/13. TRUNCATE and DROP.mp4
37 MB
06. Table Management/03. Changing a table (ALTER TABLE).mp4
33 MB
06. Table Management/09. DEFAULT values.mp4
29 MB
06. Table Management/14. Managing the tables through pgAdmin4.mp4
28 MB
06. Table Management/07. Disabling NULL for a column.mp4
26 MB
06. Table Management/08. Boolean columns.mp4
14 MB
06. Table Management/02. Creating a first table.mp4
13 MB
06. Table Management/01. Overview.mp4
2.7 MB
06. Table Management/029 Section Quiz.html
30 kB
06. Table Management/021 Automatically generating primary key.html
22 kB
06. Table Management/007 Text types (VARCHAR, CHAR, TEXT).html
22 kB
06. Table Management/009 Numeric types (SMALLINT, INT, BIGINT).html
22 kB
06. Table Management/011 Numbers with a decimal point (FLOAT, DECIMAL).html
21 kB
06. Table Management/018 DEFAULT Constraint.html
20 kB
06. Table Management/028 Managing the tables through pgAdmin4.html
20 kB
06. Table Management/06. Numbers with a decimal point (FLOAT, DECIMAL).vtt
14 kB
06. Table Management/04. Text types (VARCHAR, CHAR, TEXT).vtt
14 kB
06. Table Management/11. Automatically generating a primary key.vtt
12 kB
06. Table Management/12. Working with binary data (BYTEA).vtt
11 kB
06. Table Management/10. The PRIMARY KEY.vtt
10 kB
06. Table Management/025 Section Review.html
9.9 kB
06. Table Management/14. Managing the tables through pgAdmin4.vtt
9.4 kB
06. Table Management/014 NOT NULL Constraint.html
9.1 kB
06. Table Management/05. Numeric types (SMALLINT, INT, BIGINT).vtt
8.8 kB
06. Table Management/026 General Review.html
8.6 kB
06. Table Management/03. Changing a table (ALTER TABLE).vtt
8.6 kB
06. Table Management/003 Creating the businesses_contacts table.html
7.6 kB
06. Table Management/09. DEFAULT values.vtt
7.5 kB
06. Table Management/016 BOOLEAN Data Type.html
7.3 kB
06. Table Management/012 Further businesses_contacts modifications.html
6.9 kB
06. Table Management/005 The ALTER TABLE statement.html
6.6 kB
06. Table Management/07. Disabling NULL for a column.vtt
6.6 kB
06. Table Management/024 The DROP TABLE statement.html
5.5 kB
06. Table Management/13. TRUNCATE and DROP.vtt
5.4 kB
06. Table Management/02. Creating a first table.vtt
4.3 kB
06. Table Management/08. Boolean columns.vtt
3.4 kB
06. Table Management/01. Overview.vtt
1.3 kB
07. Data Modeling/assets/06. lecture-sql-code.txt
3.7 kB
07. Data Modeling/assets/02. lecture-sql-code.txt
3.2 kB
07. Data Modeling/assets/03. lecture-sql-code.txt
440 B
07. Data Modeling/10. How to develop a good schema.mp4
105 MB
07. Data Modeling/08. Many-to-many relationship.mp4
76 MB
07. Data Modeling/07. One-to-One relationship.mp4
74 MB
07. Data Modeling/09. Bonus compound primary keys.mp4
58 MB
07. Data Modeling/06. Exercise solution.mp4
50 MB
07. Data Modeling/03. Creating the albums table.mp4
39 MB
07. Data Modeling/02. Creating the artists table.mp4
30 MB
07. Data Modeling/04. Exercise creating tracks table.mp4
10 MB
07. Data Modeling/01. Overview.mp4
8.5 MB
07. Data Modeling/014 Section Quiz.html
27 kB
07. Data Modeling/10. How to develop a good schema.vtt
14 kB
07. Data Modeling/011 Example of a Many-to-many relationship.html
12 kB
07. Data Modeling/08. Many-to-many relationship.vtt
9.8 kB
07. Data Modeling/07. One-to-One relationship.vtt
9.6 kB
07. Data Modeling/009 Example of One-to-One relationship.html
9.0 kB
07. Data Modeling/09. Bonus compound primary keys.vtt
7.7 kB
07. Data Modeling/02. Creating the artists table.vtt
7.3 kB
07. Data Modeling/004 Example of a One-to-many relationship.html
7.2 kB
07. Data Modeling/03. Creating the albums table.vtt
5.3 kB
07. Data Modeling/04. Exercise creating tracks table.vtt
4.8 kB
07. Data Modeling/05. Exercise SQL code.html
3.8 kB
07. Data Modeling/01. Overview.vtt
3.7 kB
07. Data Modeling/06. Exercise solution.vtt
3.6 kB
08. Subqueries/02. Correlated subquery.mp4
57 MB
08. Subqueries/05. Subqueries in a WHERE condition.mp4
50 MB
08. Subqueries/07. Combining queries with UNION.mp4
49 MB
08. Subqueries/01. Introduction, first subselect.mp4
45 MB
08. Subqueries/06. Subquery with EXISTS.mp4
41 MB
08. Subqueries/04. Self-correlated subquery.mp4
26 MB
08. Subqueries/03. Renaming table with AS.mp4
17 MB
08. Subqueries/016 Section Quiz.html
22 kB
08. Subqueries/006 Renaming table with AS.html
21 kB
08. Subqueries/07. Combining queries with UNION.vtt
13 kB
08. Subqueries/008 Self-Correlated Subquery.html
8.1 kB
08. Subqueries/02. Correlated subquery.vtt
7.8 kB
08. Subqueries/05. Subqueries in a WHERE condition.vtt
7.4 kB
08. Subqueries/013 Subquery With EXISTS.html
6.9 kB
08. Subqueries/004 Correlated Subquery.html
6.6 kB
08. Subqueries/010 Subqueries in WHERE clauses 12.html
6.5 kB
08. Subqueries/011 Subqueries in WHERE clauses 22.html
6.4 kB
08. Subqueries/04. Self-correlated subquery.vtt
6.4 kB
08. Subqueries/01. Introduction, first subselect.vtt
6.3 kB
08. Subqueries/015 Combining Queries With UNION.html
6.0 kB
08. Subqueries/03. Renaming table with AS.vtt
5.9 kB
08. Subqueries/002 First Subselect.html
5.5 kB
08. Subqueries/06. Subquery with EXISTS.vtt
4.0 kB
09. JOINs/03. INNER JOIN.mp4
49 MB
09. JOINs/04. LEFT JOIN, RIGHT JOIN, FULL JOIN.mp4
35 MB
09. JOINs/05. Which to use (a subquery or a join).mp4
23 MB
09. JOINs/02. A first join (CROSS JOIN).mp4
21 MB
09. JOINs/01. Overview JOINs.mp4
4.7 MB
09. JOINs/011 Section Quiz.html
26 kB
09. JOINs/05. Which to use (a subquery or a join).vtt
10 kB
09. JOINs/04. LEFT JOIN, RIGHT JOIN, FULL JOIN.vtt
9.0 kB
09. JOINs/02. A first join (CROSS JOIN).vtt
8.9 kB
09. JOINs/005 INNER JOIN 12.html
8.0 kB
09. JOINs/006 INNER JOIN 22.html
7.8 kB
09. JOINs/009 FULL JOIN.html
7.6 kB
09. JOINs/003 CROSS JOIN.html
6.8 kB
09. JOINs/03. INNER JOIN.vtt
6.5 kB
09. JOINs/008 LEFT JOIN.html
6.3 kB
09. JOINs/01. Overview JOINs.vtt
2.1 kB
10. GROUP BY/01. A first GROUP BY clause.mp4
18 MB
10. GROUP BY/03. Filter after grouping (HAVING).mp4
14 MB
10. GROUP BY/04. How is a query executed.mp4
12 MB
10. GROUP BY/02. More complex grouping.mp4
12 MB
10. GROUP BY/008 Section Quiz.html
23 kB
10. GROUP BY/004 Complex GROUP BY.html
8.6 kB
10. GROUP BY/006 HAVING KEYWORD.html
7.8 kB
10. GROUP BY/002 GROUP BY Keyword.html
6.8 kB
10. GROUP BY/01. A first GROUP BY clause.vtt
5.5 kB
10. GROUP BY/03. Filter after grouping (HAVING).vtt
4.4 kB
10. GROUP BY/04. How is a query executed.vtt
4.1 kB
10. GROUP BY/02. More complex grouping.vtt
3.9 kB
11 - Exam/001 Practice exam Test your knowledge so far (12).html
20 kB
12 - Practical Project/010 Managing Ongoing Projects and Contact Information for Clients.html
11 kB
12 - Practical Project/006 Forming Elite Dev Teams.html
10 kB
12 - Practical Project/004 Updating and Reverting Project Data 12.html
9.0 kB
12 - Practical Project/001 Classifying Employees for Exclusive Flight Tickets.html
8.7 kB
12 - Practical Project/005 Updating and Reverting Project Data 22.html
8.4 kB
12 - Practical Project/009 Rewarding Employee Loyalty with Prize Money.html
8.1 kB
12 - Practical Project/002 Compiling Engineer Types and Project Overview.html
7.8 kB
12 - Practical Project/007 Creating and Managing App Feature Specifications Table 12.html
7.6 kB
12 - Practical Project/008 Creating and Managing App Feature Specifications Table 22.html
7.2 kB
12 - Practical Project/003 Strategic Pairings and Non-Development Staff Overview.html
7.2 kB
13. Views/04. Materialized views.mp4
132 MB
13. Views/03. Common use cases for VIEWs.mp4
70 MB
13. Views/02. Creating a first VIEW.mp4
24 MB
13. Views/05. Updatable VIEWs.mp4
14 MB
13. Views/01. Overview VIEWs.mp4
4.8 MB
13. Views/009 Section Quiz.html
23 kB
13. Views/007 Materialized Views.html
21 kB
13. Views/04. Materialized views.vtt
9.9 kB
13. Views/005 CREATE VIEW Clause 22.html
9.1 kB
13. Views/03. Common use cases for VIEWs.vtt
9.1 kB
13. Views/02. Creating a first VIEW.vtt
7.1 kB
13. Views/003 CREATE VIEW Clause 12.html
6.8 kB
13. Views/05. Updatable VIEWs.vtt
4.6 kB
13. Views/01. Overview VIEWs.vtt
2.3 kB
14. Transactions/02. Create a first transaction.mp4
100 MB
14. Transactions/05. How transactions work, performance implications.mp4
26 MB
14. Transactions/04. SAVEPOINT in a transaction.mp4
16 MB
14. Transactions/01. Overview (transactions).mp4
15 MB
14. Transactions/07. Transaction controls from pgAdmin 4.mp4
11 MB
14. Transactions/06. The ACID properties.mp4
11 MB
14. Transactions/03. Accessing data within a transaction.mp4
9.5 MB
14. Transactions/010 Section Quiz.html
26 kB
14. Transactions/02. Create a first transaction.vtt
14 kB
14. Transactions/003 First Transaction.html
8.4 kB
14. Transactions/006 SAVEPOINT Keyword.html
6.6 kB
14. Transactions/05. How transactions work, performance implications.vtt
6.6 kB
14. Transactions/06. The ACID properties.vtt
5.0 kB
14. Transactions/04. SAVEPOINT in a transaction.vtt
4.1 kB
14. Transactions/07. Transaction controls from pgAdmin 4.vtt
3.8 kB
14. Transactions/01. Overview (transactions).vtt
3.7 kB
14. Transactions/03. Accessing data within a transaction.vtt
3.2 kB
15. Indexes/assets/02. biking.bak.sql
12 MB
15. Indexes/07. Creating an index (CREATE INDEX).mp4
97 MB
15. Indexes/05. How to measure execution performance.mp4
64 MB
15. Indexes/08. Investigating index problems.mp4
59 MB
15. Indexes/09. Creating a UNIQUE index.mp4
36 MB
15. Indexes/03. Importing and exploring the data.mp4
36 MB
15. Indexes/04. EXPLAINing the query.mp4
35 MB
15. Indexes/06. How does an index improve performance.mp4
23 MB
15. Indexes/01. Overview Indexes.mp4
15 MB
15. Indexes/012 Chapter Quiz.html
24 kB
15. Indexes/009 Creating an index (CREATE INDEX).html
22 kB
15. Indexes/005 EXPLAINing the query.html
21 kB
15. Indexes/05. How to measure execution performance.vtt
15 kB
15. Indexes/08. Investigating index problems.vtt
14 kB
15. Indexes/07. Creating an index (CREATE INDEX).vtt
13 kB
15. Indexes/04. EXPLAINing the query.vtt
10 kB
15. Indexes/06. How does an index improve performance.vtt
9.8 kB
15. Indexes/09. Creating a UNIQUE index.vtt
8.6 kB
15. Indexes/03. Importing and exploring the data.vtt
8.6 kB
15. Indexes/01. Overview Indexes.vtt
4.0 kB
15. Indexes/02. Data Download.html
1.0 kB
16. Constraints/assets/02. biking3.sql
3.5 kB
16. Constraints/07. Foreign key constraints.mp4
115 MB
16. Constraints/03. Creating a UNIQUE constraint.mp4
108 MB
16. Constraints/08. Changing the behavior (ON UPDATE, ON DELETE).mp4
92 MB
16. Constraints/06. Creating a custom constraint (CHECK).mp4
90 MB
16. Constraints/05. Heads-up (STRPOS).mp4
75 MB
16. Constraints/04. Unique constraint vs index.mp4
55 MB
16. Constraints/01. Overview.mp4
44 MB
16. Constraints/012 Section Quiz.html
26 kB
16. Constraints/004 Creating a UNIQUE constraint.html
23 kB
16. Constraints/010 Foreign key constraints.html
23 kB
16. Constraints/008 Creating a custom constraint (CHECK).html
21 kB
16. Constraints/08. Changing the behavior (ON UPDATE, ON DELETE).vtt
21 kB
16. Constraints/07. Foreign key constraints.vtt
15 kB
16. Constraints/03. Creating a UNIQUE constraint.vtt
14 kB
16. Constraints/06. Creating a custom constraint (CHECK).vtt
12 kB
16. Constraints/04. Unique constraint vs index.vtt
7.1 kB
16. Constraints/01. Overview.vtt
5.9 kB
16. Constraints/05. Heads-up (STRPOS).vtt
5.4 kB
16. Constraints/02. Data Download.html
924 B
17. Dates/assets/04. concerts.sql
2.1 kB
17. Dates/07. Timezones.mp4
71 MB
17. Dates/08. Keeping track of creation time of an entry.mp4
61 MB
17. Dates/05. Extracting data from timestamps.mp4
59 MB
17. Dates/06. Calculating INTERVALs.mp4
50 MB
17. Dates/02. TIME, DATE, TIMESTAMP.mp4
30 MB
17. Dates/03. Creating the data.mp4
20 MB
17. Dates/01. Overview.mp4
4.4 MB
17. Dates/012 Section Quiz.html
27 kB
17. Dates/009 Calculating INTERVALs.html
21 kB
17. Dates/007 Extracting data from timestamps.html
21 kB
17. Dates/003 TIME, DATE, TIMESTAMP.html
21 kB
17. Dates/07. Timezones.vtt
17 kB
17. Dates/06. Calculating INTERVALs.vtt
12 kB
17. Dates/05. Extracting data from timestamps.vtt
7.5 kB
17. Dates/08. Keeping track of creation time of an entry.vtt
4.7 kB
17. Dates/03. Creating the data.vtt
4.6 kB
17. Dates/02. TIME, DATE, TIMESTAMP.vtt
4.0 kB
17. Dates/01. Overview.vtt
2.1 kB
17. Dates/04. Data Download.html
371 B
18. Practical Exercises with Dates, Times, Timestamps/assets/01. dates-exercises.sql
3.2 kB
18. Practical Exercises with Dates, Times, Timestamps/010 Coding Exercise Calculating INTERVALs.html
19 kB
18. Practical Exercises with Dates, Times, Timestamps/008 Coding Exercise Extracting data from timestamps 22.html
19 kB
18. Practical Exercises with Dates, Times, Timestamps/10. Coding Exercise Timezones.html
4.0 kB
18. Practical Exercises with Dates, Times, Timestamps/06. Coding Exercise Extracting data from timestamps 12.html
3.6 kB
18. Practical Exercises with Dates, Times, Timestamps/02. Coding Exercise TIME, DATE, TIMESTAMP 12.html
2.7 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
18. Practical Exercises with Dates, Times, Timestamps/07. Coding Exercise Solution Extracting data from timestamps 12.html
2.3 kB
18. Practical Exercises with Dates, Times, Timestamps/11. Coding Exercise Solution Timezones.html
2.1 kB
18. Practical Exercises with Dates, Times, Timestamps/09. Coding Exercise Solution Calculating INTERVALs.html
1.9 kB
18. Practical Exercises with Dates, Times, Timestamps/03. Coding Exercise Solution TIME, DATE, TIMESTAMP 12.html
1.4 kB
18. Practical Exercises with Dates, Times, Timestamps/05. Coding Exercise Solution TIME, DATE, TIMESTAMP 22.html
1.4 kB
18. Practical Exercises with Dates, Times, Timestamps/01. Data for the exercises dates_exercises.sql.html
561 B
19. Migration Practical Exercise/05. Sample solution (part 2).mp4
87 MB
19. Migration Practical Exercise/04. Sample solution (part 1).mp4
65 MB
19. Migration Practical Exercise/02. How to perform a migration.mp4
56 MB
19. Migration Practical Exercise/03. Exercise refactoring data.mp4
48 MB
19. Migration Practical Exercise/01. Overview.mp4
7.8 MB
19. Migration Practical Exercise/02. How to perform a migration.vtt
14 kB
19. Migration Practical Exercise/04. Sample solution (part 1).vtt
8.8 kB
19. Migration Practical Exercise/05. Sample solution (part 2).vtt
6.8 kB
19. Migration Practical Exercise/03. Exercise refactoring data.vtt
6.3 kB
19. Migration Practical Exercise/01. Overview.vtt
3.6 kB
20. Arrays/assets/03. arrays-exercises.sql
38 kB
20. Arrays/17. Bonus, optimized search with an index.mp4
112 MB
20. Arrays/14. The UNNEST function in PostgreSQL.mp4
85 MB
20. Arrays/25. When to use an array (best practices).mp4
40 MB
20. Arrays/01. Overview Arrays.mp4
26 MB
20. Arrays/09. The ANY and ALL functions.mp4
24 MB
20. Arrays/06. How to access an array.mp4
22 MB
20. Arrays/02. Creating a first array.mp4
20 MB
20. Arrays/20. Modifying an array.mp4
20 MB
20. Arrays/029 Section Quiz.html
23 kB
20. Arrays/007 How to access an array.html
21 kB
20. Arrays/023 Modifying an array.html
21 kB
20. Arrays/011 The ANY and ALL functions.html
21 kB
20. Arrays/25. When to use an array (best practices).vtt
9.8 kB
20. Arrays/01. Overview Arrays.vtt
8.5 kB
20. Arrays/14. The UNNEST function in PostgreSQL.vtt
8.5 kB
20. Arrays/09. The ANY and ALL functions.vtt
6.1 kB
20. Arrays/06. How to access an array.vtt
6.1 kB
20. Arrays/18. Coding Exercise Bonus, optimized search with an index.html
5.4 kB
20. Arrays/02. Creating a first array.vtt
5.1 kB
20. Arrays/20. Modifying an array.vtt
4.9 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
20. Arrays/04. Coding Exercise Creating a first array.html
3.6 kB
20. Arrays/19. Coding Exercise Solution Bonus, optimized search with an index.html
3.4 kB
20. Arrays/23. Coding Exercise Modifying an array 22.html
2.7 kB
20. Arrays/21. Coding Exercise Modifying an array 12.html
2.5 kB
20. Arrays/10. Coding Exercise The ANY and ALL functions 12.html
2.2 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
20. Arrays/12. Coding Exercise The ANY and ALL functions 22.html
1.9 kB
20. Arrays/08. Coding Exercise Solution How to access an array.html
1.5 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
20. Arrays/13. Coding Exercise Solution The ANY and ALL functions 22.html
1.0 kB
20. Arrays/16. Coding Exercise Solution The UNNEST function in PostgreSQL.html
939 B
20. Arrays/03. Data for the exercises arrays_exercises.sql.html
547 B
21. Complex Statistical Queries/assets/02. salaries.sql
4.6 MB
21. Complex Statistical Queries/04. GROUPING SETS and GROUPING.mp4
193 MB
21. Complex Statistical Queries/10. The LAG and LEAD functions.mp4
156 MB
21. Complex Statistical Queries/07. OVER and PARTITION BY.mp4
130 MB
21. Complex Statistical Queries/11. The STRING_AGG and ARRAY_AGG functions.mp4
75 MB
21. Complex Statistical Queries/12. Common Table Expressions (CTEs).mp4
48 MB
21. Complex Statistical Queries/13. Temporary tables.mp4
34 MB
21. Complex Statistical Queries/09. The ROW_NUMBER function.mp4
21 MB
21. Complex Statistical Queries/03. Importing and exploring the data.mp4
20 MB
21. Complex Statistical Queries/05. The ROLLUP function.mp4
18 MB
21. Complex Statistical Queries/15. When to use what.mp4
15 MB
21. Complex Statistical Queries/06. The CUBE function.mp4
12 MB
21. Complex Statistical Queries/01. Overview.mp4
10 MB
21. Complex Statistical Queries/08. GROUP BY vs OVER.mp4
4.3 MB
21. Complex Statistical Queries/020 Section Quiz.html
24 kB
21. Complex Statistical Queries/005 GROUPING SETS and GROUPING.html
22 kB
21. Complex Statistical Queries/04. GROUPING SETS and GROUPING.vtt
15 kB
21. Complex Statistical Queries/07. OVER and PARTITION BY.vtt
13 kB
21. Complex Statistical Queries/10. The LAG and LEAD functions.vtt
11 kB
21. Complex Statistical Queries/13. Temporary tables.vtt
8.8 kB
21. Complex Statistical Queries/007 ROLLUP Function.html
8.4 kB
21. Complex Statistical Queries/11. The STRING_AGG and ARRAY_AGG functions.vtt
7.6 kB
21. Complex Statistical Queries/010 OVER and PARTITION BY clauses.html
7.1 kB
21. Complex Statistical Queries/12. Common Table Expressions (CTEs).vtt
6.7 kB
21. Complex Statistical Queries/013 ROW_NUMBER Function.html
6.7 kB
21. Complex Statistical Queries/09. The ROW_NUMBER function.vtt
6.4 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
21. Complex Statistical Queries/01. Overview.vtt
4.7 kB
21. Complex Statistical Queries/05. The ROLLUP function.vtt
4.2 kB
21. Complex Statistical Queries/06. The CUBE function.vtt
3.0 kB
21. Complex Statistical Queries/08. GROUP BY vs OVER.vtt
1.8 kB
21. Complex Statistical Queries/14. Temporary tables - SQL code.html
835 B
21. Complex Statistical Queries/02. Data Download.html
423 B
22. Collations/assets/02. cities.sql
2.8 kB
22. Collations/03. Using a different collation.mp4
174 MB
22. Collations/05. Collations and Indexes.mp4
24 MB
22. Collations/04. Changing the collation of a column.mp4
22 MB
22. Collations/01. Overview.mp4
21 MB
22. Collations/06. Language-specific collations.mp4
19 MB
22. Collations/008 Section Quiz.html
22 kB
22. Collations/004 Using a different collation.html
21 kB
22. Collations/03. Using a different collation.vtt
12 kB
22. Collations/05. Collations and Indexes.vtt
6.0 kB
22. Collations/06. Language-specific collations.vtt
5.7 kB
22. Collations/04. Changing the collation of a column.vtt
5.2 kB
22. Collations/01. Overview.vtt
5.2 kB
22. Collations/02. Data Download.html
243 B
23. Permissions/assets/02. data-center.sql
5.0 kB
23. Permissions/01. Overview.mp4
75 MB
23. Permissions/04. Granting permissions to roles.mp4
69 MB
23. Permissions/07. Using a VIEW with permissions.mp4
39 MB
23. Permissions/03. Creating a user, logging in as a user.mp4
37 MB
23. Permissions/06. Managing permissions through pgAdmin 4.mp4
30 MB
23. Permissions/05. Revoking permissions from roles.mp4
7.8 MB
23. Permissions/009 Section Quiz.html
23 kB
23. Permissions/004 Creating a user, logging in as a user.html
21 kB
23. Permissions/01. Overview.vtt
10 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
23. Permissions/04. Granting permissions to roles.vtt
9.1 kB
23. Permissions/06. Managing permissions through pgAdmin 4.vtt
7.4 kB
23. Permissions/05. Revoking permissions from roles.vtt
2.7 kB
23. Permissions/02. Data Download.html
263 B
24. Stored Procedures/04. Managing permissions on stored procedures - 1.mp4
66 MB
24. Stored Procedures/05. Managing permissions on stored procedures - 2.mp4
32 MB
24. Stored Procedures/03. What does the $$ mean.mp4
27 MB
24. Stored Procedures/02. Creating a stored procedure.mp4
26 MB
24. Stored Procedures/01. Overview.mp4
14 MB
24. Stored Procedures/007 Section Quiz.html
24 kB
24. Stored Procedures/003 Creating a stored procedure.html
21 kB
24. Stored Procedures/04. Managing permissions on stored procedures - 1.vtt
8.6 kB
24. Stored Procedures/03. What does the $$ mean.vtt
6.7 kB
24. Stored Procedures/02. Creating a stored procedure.vtt
6.4 kB
24. Stored Procedures/05. Managing permissions on stored procedures - 2.vtt
4.5 kB
24. Stored Procedures/01. Overview.vtt
1.8 kB
25. Triggers/09. Refreshing data with a trigger.mp4
180 MB
25. Triggers/07. Creating a trigger.mp4
143 MB
25. Triggers/11. Intercepting an SQL command with a trigger.mp4
136 MB
25. Triggers/12. Triggers and permissions.mp4
50 MB
25. Triggers/02. Writing a PLpgSQL script.mp4
28 MB
25. Triggers/03. Variables in PLpgSQL.mp4
22 MB
25. Triggers/04. Loops in PLpgSQL.mp4
15 MB
25. Triggers/13. Triggers and the SQL standard.mp4
14 MB
25. Triggers/05. Conditionals in PLpgSQL.mp4
12 MB
25. Triggers/01. Overview.mp4
6.9 MB
25. Triggers/017 Section Quiz.html
26 kB
25. Triggers/09. Refreshing data with a trigger.vtt
24 kB
25. Triggers/010 Creating a trigger.html
21 kB
25. Triggers/004 Variables in PLpgSQL.html
21 kB
25. Triggers/007 Conditionals in PLpgSQL.html
21 kB
25. Triggers/07. Creating a trigger.vtt
13 kB
25. Triggers/11. Intercepting an SQL command with a trigger.vtt
13 kB
25. Triggers/02. Writing a PLpgSQL script.vtt
9.1 kB
25. Triggers/12. Triggers and permissions.vtt
6.7 kB
25. Triggers/03. Variables in PLpgSQL.vtt
5.6 kB
25. Triggers/05. Conditionals in PLpgSQL.vtt
3.9 kB
25. Triggers/04. Loops in PLpgSQL.vtt
3.5 kB
25. Triggers/13. Triggers and the SQL standard.vtt
3.4 kB
25. Triggers/01. Overview.vtt
3.0 kB
25. Triggers/08. Refreshing data with a trigger (SQL code).html
1.2 kB
25. Triggers/06. Creating a trigger (SQL code).html
625 B
25. Triggers/10. Intercepting an SQL command with a trigger (SQL code).html
590 B
26. Additional Topics/02. Full-text search in PostgreSQL.mp4
157 MB
26. Additional Topics/01. Exporting data with PostgreSQL.mp4
132 MB
26. Additional Topics/04. Best practices - 1.mp4
76 MB
26. Additional Topics/03. Speeding up a full-text search.mp4
51 MB
26. Additional Topics/05. Best practices - 2.mp4
41 MB
26. Additional Topics/06. Best practices - 3.mp4
16 MB
26. Additional Topics/009 Section Quiz.html
23 kB
26. Additional Topics/003 Full-text search in PostgreSQL.html
21 kB
26. Additional Topics/006 Best practices - 1.html
21 kB
26. Additional Topics/02. Full-text search in PostgreSQL.vtt
21 kB
26. Additional Topics/01. Exporting data with PostgreSQL.vtt
18 kB
26. Additional Topics/04. Best practices - 1.vtt
10 kB
26. Additional Topics/06. Best practices - 3.vtt
7.4 kB
26. Additional Topics/03. Speeding up a full-text search.vtt
6.7 kB
26. Additional Topics/05. Best practices - 2.vtt
5.8 kB
27 - Practical Project 2/008 Finalizing Revenue Report for US Branch.html
10 kB
27 - Practical Project 2/002 Optimizing Candidate Management 12.html
10 kB
27 - Practical Project 2/001 Consolidating U.S. Client Connections for Market Expansion.html
9.9 kB
27 - Practical Project 2/007 Critical Financial and Resource Analysis 22.html
9.3 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
27 - Practical Project 2/004 Fixing Syntax of Unorthodox Transaction.html
8.0 kB
27 - Practical Project 2/005 Fixing Interview Scheduling Issues.html
7.4 kB
28 - Exam/001 Practice exam Test your knowledge (22).html
18 kB
29. PostgreSQL with Python/assets/02. Archive.zip
11 kB
29. PostgreSQL with Python/07. Preventing SQL injections.mp4
254 MB
29. PostgreSQL with Python/04. Connecting to PostgreSQL.mp4
221 MB
29. PostgreSQL with Python/08. Bonus Object Relational Mappers (ORMs).mp4
132 MB
29. PostgreSQL with Python/05. Inserting data in PostgreSQL.mp4
126 MB
29. PostgreSQL with Python/03. Installing Python and VS Code.mp4
68 MB
29. PostgreSQL with Python/06. Passing parameters through dictionaries.mp4
32 MB
29. PostgreSQL with Python/01. Overview.mp4
7.8 MB
29. PostgreSQL with Python/008 Preventing SQL injections.html
20 kB
29. PostgreSQL with Python/07. Preventing SQL injections.vtt
19 kB
29. PostgreSQL with Python/08. Bonus Object Relational Mappers (ORMs).vtt
18 kB
29. PostgreSQL with Python/04. Connecting to PostgreSQL.vtt
16 kB
29. PostgreSQL with Python/05. Inserting data in PostgreSQL.vtt
9.5 kB
29. PostgreSQL with Python/03. Installing Python and VS Code.vtt
8.9 kB
29. PostgreSQL with Python/06. Passing parameters through dictionaries.vtt
4.1 kB
29. PostgreSQL with Python/01. Overview.vtt
3.5 kB
29. PostgreSQL with Python/02. The files for this chapter.html
69 B
30. MySQL Overview Similarities and Differences with PostgreSQL/assets/02. students.sql
24 kB
30. MySQL Overview Similarities and Differences with PostgreSQL/03. MySQL installation.mp4
106 MB
30. MySQL Overview Similarities and Differences with PostgreSQL/05. Differences between PostgreSQL and MySQL - 1.mp4
95 MB
30. MySQL Overview Similarities and Differences with PostgreSQL/08. Data types in MySQL.mp4
70 MB
30. MySQL Overview Similarities and Differences with PostgreSQL/07. Differences between PostgreSQL and MySQL - 2.mp4
52 MB
30. MySQL Overview Similarities and Differences with PostgreSQL/09. The utf8_general_ci collation.mp4
32 MB
30. MySQL Overview Similarities and Differences with PostgreSQL/04. Using MySQL Workbench.mp4
20 MB
30. MySQL Overview Similarities and Differences with PostgreSQL/06. Similarities between PostgreSQL and MySQL.mp4
15 MB
30. MySQL Overview Similarities and Differences with PostgreSQL/01. Overview.mp4
12 MB
30. MySQL Overview Similarities and Differences with PostgreSQL/010 Section Quiz.html
24 kB
30. MySQL Overview Similarities and Differences with PostgreSQL/08. Data types in MySQL.vtt
16 kB
30. MySQL Overview Similarities and Differences with PostgreSQL/03. MySQL installation.vtt
8.9 kB
30. MySQL Overview Similarities and Differences with PostgreSQL/09. The utf8_general_ci collation.vtt
7.5 kB
30. MySQL Overview Similarities and Differences with PostgreSQL/01. Overview.vtt
4.8 kB
30. MySQL Overview Similarities and Differences with PostgreSQL/07. Differences between PostgreSQL and MySQL - 2.vtt
4.6 kB
30. MySQL Overview Similarities and Differences with PostgreSQL/02. Data Download.html
316 B
31. SQLite Overview Similarities and Differences with PostgreSQL/06. Data types in SQLite - 2.mp4
127 MB
31. SQLite Overview Similarities and Differences with PostgreSQL/03. Differences between PostgreSQL and SQLite - 1.mp4
82 MB
31. SQLite Overview Similarities and Differences with PostgreSQL/04. Differences between PostgreSQL and SQLite - 2.mp4
62 MB
31. SQLite Overview Similarities and Differences with PostgreSQL/05. Data types in SQLite - 1.mp4
53 MB
31. SQLite Overview Similarities and Differences with PostgreSQL/02. Installing DB Browser.mp4
32 MB
31. SQLite Overview Similarities and Differences with PostgreSQL/01. Overview.mp4
16 MB
31. SQLite Overview Similarities and Differences with PostgreSQL/007 Section Quiz.html
23 kB
31. SQLite Overview Similarities and Differences with PostgreSQL/06. Data types in SQLite - 2.vtt
9.4 kB
31. SQLite Overview Similarities and Differences with PostgreSQL/04. Differences between PostgreSQL and SQLite - 2.vtt
8.2 kB
31. SQLite Overview Similarities and Differences with PostgreSQL/03. Differences between PostgreSQL and SQLite - 1.vtt
7.6 kB
31. SQLite Overview Similarities and Differences with PostgreSQL/02. Installing DB Browser.vtt
7.4 kB
31. SQLite Overview Similarities and Differences with PostgreSQL/01. Overview.vtt
6.9 kB
31. SQLite Overview Similarities and Differences with PostgreSQL/05. Data types in SQLite - 1.vtt
6.9 kB
32. Closing Words/01. Closing Words.mp4
7.8 MB
32. Closing Words/01. Closing Words.vtt
3.8 kB