资源详情

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

免责声明

本网站仅提供DHT网络资源索引服务，不存储任何资源文件。所有资源均来自DHT网络，本站无法控制其内容。请遵守当地法律法规，合理使用网络资源。如涉及版权问题，请联系 fuckatgfw@protonmail.com。

© 2025 鹿鹿堂