Udemy - Master SQL and Databases in 30 Days A Practical Guide (10.2024)
大小
3.33 GB
文件数
160
Info Hash:
7034B9FC6D58A77A3841DA09B7478E190CE90584
收录时间
2026-01-02 08:35:02
更新时间
2026-01-02 08:35:02
文件列表 (160)
1 - DAY 01 Introduction to SQL/1 -Understanding SQL and its Importance.mp4
44.95 MB
1 - DAY 01 Introduction to SQL/1 -Understanding SQL and its Importance.vtt
6.71 KB
1 - DAY 01 Introduction to SQL/2 -Setting Up Your Local SQL Environment and Running Your First Database.mp4
85.19 MB
1 - DAY 01 Introduction to SQL/2 -Setting Up Your Local SQL Environment and Running Your First Database.vtt
16.07 KB
1 - DAY 01 Introduction to SQL/3 - Resources.html
1.34 KB
1 - DAY 01 Introduction to SQL/3 - SQL Code Running Your First Database.html
3.42 KB
1 - DAY 01 Introduction to SQL/3 -Hands-on Project Exporting and Importing SQL files.mp4
25.8 MB
1 - DAY 01 Introduction to SQL/3 -Hands-on Project Exporting and Importing SQL files.vtt
3.66 KB
10 - DAY 10 JOINs/1 -Introduction to SQL JOINs.mp4
50.26 MB
10 - DAY 10 JOINs/1 -Introduction to SQL JOINs.vtt
8.14 KB
10 - DAY 10 JOINs/2 -Day 10 - cityfitgym.sql
2.99 KB
10 - DAY 10 JOINs/2 -Hands-on Project Joining Multiple Tables.mp4
70.21 MB
10 - DAY 10 JOINs/2 -Hands-on Project Joining Multiple Tables.vtt
8.65 KB
10 - DAY 10 JOINs/3 - SQL CODE Code Examples for JOINs.html
2.62 KB
11 - DAY 11 Subqueries/1 -Understanding Subqueries.mp4
52.53 MB
11 - DAY 11 Subqueries/1 -Understanding Subqueries.vtt
7.92 KB
11 - DAY 11 Subqueries/2 -Day 11 - bookverse.sql
3.25 KB
11 - DAY 11 Subqueries/2 -Hands-on Project Writing Subqueries in SQL.mp4
98.54 MB
11 - DAY 11 Subqueries/2 -Hands-on Project Writing Subqueries in SQL.vtt
12.8 KB
11 - DAY 11 Subqueries/3 - SQL CODE Writing Subqueries.html
2.32 KB
12 - DAY 12 Working with CASE Statements/1 -Understanding CASE Statements.mp4
53.44 MB
12 - DAY 12 Working with CASE Statements/1 -Understanding CASE Statements.vtt
7.29 KB
12 - DAY 12 Working with CASE Statements/2 -Day 12 - bookstore.sql
2.79 KB
12 - DAY 12 Working with CASE Statements/2 -Hands-on Project Writing Conditional SQL Queries.mp4
98.69 MB
12 - DAY 12 Working with CASE Statements/2 -Hands-on Project Writing Conditional SQL Queries.vtt
11.1 KB
12 - DAY 12 Working with CASE Statements/3 - SQL CODE Writing CASE Expressions.html
4.25 KB
13 - DAY 13 Self-Joins/1 -Understanding Self-Joins.mp4
49.94 MB
13 - DAY 13 Self-Joins/1 -Understanding Self-Joins.vtt
6.23 KB
13 - DAY 13 Self-Joins/2 -Day 13 - employee.sql
1.49 KB
13 - DAY 13 Self-Joins/2 -Hands-on Project Writing Queries with Self-Joins.mp4
66.75 MB
13 - DAY 13 Self-Joins/2 -Hands-on Project Writing Queries with Self-Joins.vtt
8.14 KB
13 - DAY 13 Self-Joins/3 - SQL CODE Self-Joins in Action.html
1.15 KB
14 - DAY 14 UNION & UNION ALL/1 -Combining Result Sets with UNION.mp4
45.41 MB
14 - DAY 14 UNION & UNION ALL/1 -Combining Result Sets with UNION.vtt
6.81 KB
14 - DAY 14 UNION & UNION ALL/2 -Day 14 - book_music.sql
1.94 KB
14 - DAY 14 UNION & UNION ALL/2 -Hands-on Project Merging Results from Multiple Queries.mp4
66.34 MB
14 - DAY 14 UNION & UNION ALL/2 -Hands-on Project Merging Results from Multiple Queries.vtt
8.47 KB
14 - DAY 14 UNION & UNION ALL/3 - SQL CODE Using UNION in SQL Queries.html
2.56 KB
15 - DAY 15 Understanding Indexes/1 -Introduction to Indexing in Databases.mp4
37.22 MB
15 - DAY 15 Understanding Indexes/1 -Introduction to Indexing in Databases.vtt
5.87 KB
15 - DAY 15 Understanding Indexes/2 -Day 15 - indexdemo.sql
1.9 KB
15 - DAY 15 Understanding Indexes/2 -Hands-on Project Creating and Managing Indexes.mp4
70.38 MB
15 - DAY 15 Understanding Indexes/2 -Hands-on Project Creating and Managing Indexes.vtt
8.53 KB
15 - DAY 15 Understanding Indexes/3 - SQL CODE Creating and Managing Indexes.html
2.94 KB
16 - DAY 16 Working with Views/1 -Overview of SQL Views.mp4
60.86 MB
16 - DAY 16 Working with Views/1 -Overview of SQL Views.vtt
9.46 KB
16 - DAY 16 Working with Views/2 -Day 16 - shopdb.sql
5.24 KB
16 - DAY 16 Working with Views/2 -Hands-on Project Creating and Using Views in SQL.mp4
85 MB
16 - DAY 16 Working with Views/2 -Hands-on Project Creating and Using Views in SQL.vtt
10.56 KB
16 - DAY 16 Working with Views/3 - SQL CODE Writing Queries Using Views.html
3.41 KB
17 - DAY 17 Transaction Management/1 -Understanding Transactions in SQL.mp4
53.74 MB
17 - DAY 17 Transaction Management/1 -Understanding Transactions in SQL.vtt
8.63 KB
17 - DAY 17 Transaction Management/2 -Day 17 - ecommerce.sql
2.24 KB
17 - DAY 17 Transaction Management/2 -Hands-on Project Implementing Transactions in SQL.mp4
80.59 MB
17 - DAY 17 Transaction Management/2 -Hands-on Project Implementing Transactions in SQL.vtt
10.93 KB
17 - DAY 17 Transaction Management/3 - SQL CODE Writing Transactional Queries.html
3.14 KB
18 - DAY 18 Creating Stored Procedures/1 -Introduction to Stored Procedures.mp4
54.4 MB
18 - DAY 18 Creating Stored Procedures/1 -Introduction to Stored Procedures.vtt
8.64 KB
19 - DAY 19 Implementing Triggers/1 -Understanding SQL Triggers.mp4
28.58 MB
19 - DAY 19 Implementing Triggers/1 -Understanding SQL Triggers.vtt
4.2 KB
2 - DAY 02 Understanding Databases and Tables/1 -Database Structure and Table Relationships.mp4
69.63 MB
2 - DAY 02 Understanding Databases and Tables/1 -Database Structure and Table Relationships.vtt
10.77 KB
2 - DAY 02 Understanding Databases and Tables/2 -Hands-on Project Creating Databases and Tables in SQL.mp4
84.31 MB
2 - DAY 02 Understanding Databases and Tables/2 -Hands-on Project Creating Databases and Tables in SQL.vtt
14.07 KB
2 - DAY 02 Understanding Databases and Tables/3 -Day 2 - onlinestore.sql
3.62 KB
2 - DAY 02 Understanding Databases and Tables/3 -Hands-on Project Verifying Structure and Relationships.mp4
58.8 MB
2 - DAY 02 Understanding Databases and Tables/3 -Hands-on Project Verifying Structure and Relationships.vtt
8.41 KB
2 - DAY 02 Understanding Databases and Tables/4 - Data Types in SQL.html
6.75 KB
2 - DAY 02 Understanding Databases and Tables/4 - SQL CODE Database Structure and Table Relationships.html
2.55 KB
20 - DAY 20 Database Normalization/1 -Importance of Database Normalization.mp4
37.78 MB
20 - DAY 20 Database Normalization/1 -Importance of Database Normalization.vtt
6.1 KB
20 - DAY 20 Database Normalization/2 -Hands-on Project Applying Normalization Techniques.mp4
74.52 MB
20 - DAY 20 Database Normalization/2 -Hands-on Project Applying Normalization Techniques.vtt
10.91 KB
20 - DAY 20 Database Normalization/3 - SQL CODE Writing Queries in a Normalized Database.html
3.11 KB
21 - DAY 21 Exploring ACID Properties/1 -Understanding ACID Transactions.mp4
43.44 MB
21 - DAY 21 Exploring ACID Properties/1 -Understanding ACID Transactions.vtt
7.35 KB
22 - DAY 22 Date Functions/1 -Overview of SQL Date Functions.mp4
30.77 MB
22 - DAY 22 Date Functions/1 -Overview of SQL Date Functions.vtt
4.57 KB
22 - DAY 22 Date Functions/2 -Day 22 - datefunction.sql
1.43 KB
22 - DAY 22 Date Functions/2 -Hands-on Project Manipulating Dates in SQL Queries.mp4
48.32 MB
22 - DAY 22 Date Functions/2 -Hands-on Project Manipulating Dates in SQL Queries.vtt
6.62 KB
22 - DAY 22 Date Functions/3 - SQL CODE Writing Date Function Queries.html
1.77 KB
23 - DAY 23 String Functions/1 -Overview of SQL String Functions.mp4
55.48 MB
23 - DAY 23 String Functions/1 -Overview of SQL String Functions.vtt
8.26 KB
23 - DAY 23 String Functions/2 -Day 23 - stringdb.sql
1.98 KB
23 - DAY 23 String Functions/2 -Hands-on Project Manipulating Strings in SQL Queries.mp4
77.93 MB
23 - DAY 23 String Functions/2 -Hands-on Project Manipulating Strings in SQL Queries.vtt
10.31 KB
23 - DAY 23 String Functions/3 - SQL CODE Writing String Function Queries.html
2.3 KB
24 - DAY 24 Math Functions/1 -Introduction to SQL Math Functions.mp4
44.15 MB
24 - DAY 24 Math Functions/1 -Introduction to SQL Math Functions.vtt
6.07 KB
24 - DAY 24 Math Functions/2 -Day 24 - salesanalysis.sql
1.79 KB
24 - DAY 24 Math Functions/2 -Hands-on Project Using Math Functions in Queries.mp4
39.26 MB
24 - DAY 24 Math Functions/2 -Hands-on Project Using Math Functions in Queries.vtt
4.88 KB
24 - DAY 24 Math Functions/3 - SQL CODE Math Functions.html
3.08 KB
25 - DAY 25 Window Functions/1 -Overview of Window Functions.mp4
45.56 MB
25 - DAY 25 Window Functions/1 -Overview of Window Functions.vtt
7.03 KB
25 - DAY 25 Window Functions/2 -Day 25 - windowfunction.sql
1.84 KB
25 - DAY 25 Window Functions/2 -Hands-on Project Writing Queries Using Window Functions.mp4
74.77 MB
25 - DAY 25 Window Functions/2 -Hands-on Project Writing Queries Using Window Functions.vtt
9.81 KB
25 - DAY 25 Window Functions/3 - SQL CODE Queries with Window Functions.html
2.89 KB
26 - DAY 26 Common Table Expressions (CTE)/1 -Introduction to CTE in SQL.mp4
58.77 MB
26 - DAY 26 Common Table Expressions (CTE)/1 -Introduction to CTE in SQL.vtt
8.1 KB
26 - DAY 26 Common Table Expressions (CTE)/2 -Day 26 - cte.sql
2.63 KB
26 - DAY 26 Common Table Expressions (CTE)/2 -Hands-on Project Writing Queries with CTEs.mp4
50.43 MB
26 - DAY 26 Common Table Expressions (CTE)/2 -Hands-on Project Writing Queries with CTEs.vtt
6.55 KB
26 - DAY 26 Common Table Expressions (CTE)/3 - SQL CODE Examples for CTEs.html
3.46 KB
27 - DAY 27 Analytic Functions/1 -Overview of Analytic Functions.mp4
47.98 MB
27 - DAY 27 Analytic Functions/1 -Overview of Analytic Functions.vtt
7.59 KB
28 - DAY 28 Pivot & Unpivot/1 -Understanding Pivot & Unpivot in SQL.mp4
44.01 MB
28 - DAY 28 Pivot & Unpivot/1 -Understanding Pivot & Unpivot in SQL.vtt
6.29 KB
29 - DAY 29 Index Optimization/1 -Index Optimization Techniques.mp4
43.24 MB
29 - DAY 29 Index Optimization/1 -Index Optimization Techniques.vtt
7.35 KB
29 - DAY 29 Index Optimization/2 - SQL CODE Code Examples for Index Optimization.html
3.33 KB
3 - DAY 03 Using the SELECT Statement/1 -Purpose and Syntax of SELECT.mp4
42.99 MB
3 - DAY 03 Using the SELECT Statement/1 -Purpose and Syntax of SELECT.vtt
6.45 KB
3 - DAY 03 Using the SELECT Statement/2 -Hands-on Project Querying Data from Tables in SQL.mp4
83.71 MB
3 - DAY 03 Using the SELECT Statement/2 -Hands-on Project Querying Data from Tables in SQL.vtt
13.27 KB
3 - DAY 03 Using the SELECT Statement/3 -Day 3 - storedb.sql
2.77 KB
3 - DAY 03 Using the SELECT Statement/3 -Hands-on Project Use SELECT with Aggregate Functions.mp4
52.38 MB
3 - DAY 03 Using the SELECT Statement/3 -Hands-on Project Use SELECT with Aggregate Functions.vtt
9.07 KB
3 - DAY 03 Using the SELECT Statement/4 - SQL CODE Querying Data from Tables in SQL.html
3.62 KB
30 - DAY 30 Query Performance Tuning/1 -Understanding Query Performance Tuning.mp4
50.83 MB
30 - DAY 30 Query Performance Tuning/1 -Understanding Query Performance Tuning.vtt
7.86 KB
30 - DAY 30 Query Performance Tuning/2 - Job Opportunities with SQL skills.html
6.58 KB
4 - DAY 04 WHERE Clause and Logical Operators/1 -Filtering Data with WHERE Clause.mp4
56.65 MB
4 - DAY 04 WHERE Clause and Logical Operators/1 -Filtering Data with WHERE Clause.vtt
8.25 KB
4 - DAY 04 WHERE Clause and Logical Operators/2 -Day 4 - companydb.sql
2.19 KB
4 - DAY 04 WHERE Clause and Logical Operators/2 -Hands-on Project Applying Logical Operators in SQL Queries.mp4
97.47 MB
4 - DAY 04 WHERE Clause and Logical Operators/2 -Hands-on Project Applying Logical Operators in SQL Queries.vtt
13.9 KB
4 - DAY 04 WHERE Clause and Logical Operators/3 - SQL CODE Applying Logical Operators in SQL Queries.html
2.65 KB
5 - DAY 05 Sorting Data with ORDER BY/1 -Sorting Data Using ORDER BY.mp4
54.37 MB
5 - DAY 05 Sorting Data with ORDER BY/1 -Sorting Data Using ORDER BY.vtt
7.92 KB
5 - DAY 05 Sorting Data with ORDER BY/2 -Day 5 - companydb.sql
2.19 KB
5 - DAY 05 Sorting Data with ORDER BY/2 -Hands-on Project Writing Queries with ORDER BY.mp4
79.98 MB
5 - DAY 05 Sorting Data with ORDER BY/2 -Hands-on Project Writing Queries with ORDER BY.vtt
9.8 KB
5 - DAY 05 Sorting Data with ORDER BY/3 - SQL CODE Code Examples for Sorting Data.html
1.13 KB
6 - DAY 06 Using LIMIT & OFFSET/1 -Understanding LIMIT & OFFSET.mp4
47.68 MB
6 - DAY 06 Using LIMIT & OFFSET/1 -Understanding LIMIT & OFFSET.vtt
7.27 KB
6 - DAY 06 Using LIMIT & OFFSET/2 -Day 6 - mystore.sql
2.93 KB
6 - DAY 06 Using LIMIT & OFFSET/2 -Hands-on Project Limiting Query Results.mp4
93.68 MB
6 - DAY 06 Using LIMIT & OFFSET/2 -Hands-on Project Limiting Query Results.vtt
12.71 KB
6 - DAY 06 Using LIMIT & OFFSET/3 - SQL CODE Limiting and Offsetting Rows.html
2.9 KB
7 - DAY 07 Using Aggregate Functions/1 -Overview of Aggregate Functions.mp4
67.66 MB
7 - DAY 07 Using Aggregate Functions/1 -Overview of Aggregate Functions.vtt
9.02 KB
7 - DAY 07 Using Aggregate Functions/2 -Day 7 -retailstore.sql
1.77 KB
7 - DAY 07 Using Aggregate Functions/2 -Hands-on Project Applying Aggregate Functions to Data.mp4
89.28 MB
7 - DAY 07 Using Aggregate Functions/2 -Hands-on Project Applying Aggregate Functions to Data.vtt
11.2 KB
7 - DAY 07 Using Aggregate Functions/3 - SQL CODE Aggregate Functions in Action.html
2.02 KB
8 - DAY 8 GROUP BY Clause/1 -Grouping Data with GROUP BY.mp4
58.23 MB
8 - DAY 8 GROUP BY Clause/1 -Grouping Data with GROUP BY.vtt
8.98 KB
8 - DAY 8 GROUP BY Clause/2 -Day 08 - salesdb.sql
2.08 KB
8 - DAY 8 GROUP BY Clause/2 -Hands-on Project Applying Aggregate Functions to Groups.mp4
94.02 MB
8 - DAY 8 GROUP BY Clause/2 -Hands-on Project Applying Aggregate Functions to Groups.vtt
11.75 KB
8 - DAY 8 GROUP BY Clause/3 - SQL CODE Writing GROUP BY Queries.html
2.82 KB
9 - DAY 9 HAVING Clause/1 -Filtering Groups with HAVING.mp4
47.57 MB
9 - DAY 9 HAVING Clause/1 -Filtering Groups with HAVING.vtt
6.79 KB
9 - DAY 9 HAVING Clause/2 -Day 9 - brightmart.sql
1.88 KB
9 - DAY 9 HAVING Clause/2 -Hands-on Project Applying Filters to Grouped Data.mp4
85.09 MB
9 - DAY 9 HAVING Clause/2 -Hands-on Project Applying Filters to Grouped Data.vtt
10.33 KB
9 - DAY 9 HAVING Clause/3 - SQL CODE Filtering Grouped Results.html
2.83 KB