zhongziso种子搜
首页
功能
磁力转BT
BT转磁力
使用教程
免责声明
关于
zhongziso
搜索
[Udemy] SQL - The Complete Developer's Guide (MySQL, PostgreSQL) (2021) [En]
magnet:?xt=urn:btih:e984db9b54d316ccc944e6c784eae34e5bec3bc9&dn=[Udemy] SQL - The Complete Developer's Guide (MySQL, PostgreSQL) (2021) [En]
磁力链接详情
Hash值:
e984db9b54d316ccc944e6c784eae34e5bec3bc9
点击数:
204
文件大小:
8.1 GB
文件数量:
203
创建日期:
2023-3-5 06:35
最后访问:
2024-5-22 04:31
访问标签:
Udemy
SQL
-
The
Complete
Developer's
Guide
MySQL
PostgreSQL
2021
En
文件列表详情
06 - Data Normalization & Relationships_ Splitting & JOINing Data/027 Example_ Adding First Tables & Relations.mp4 132.38 MB
01 - Getting Started/002 What Is SQL_.mp4 86.68 MB
01 - Getting Started/003 A Closer Look At SQL & Databases.mp4 89.74 MB
01 - Getting Started/005 Course Content.mp4 67.14 MB
01 - Getting Started/006 There Are Two Ways Of Taking This Course_.mp4 35.6 MB
01 - Getting Started/007 How To Get The Most Out Of This Course.mp4 55.25 MB
02 - SQL Basics_ Syntax & Core Features/001 Module Introduction.mp4 3.21 MB
02 - SQL Basics_ Syntax & Core Features/002 Understanding The Core SQL Syntax.mp4 33.42 MB
02 - SQL Basics_ Syntax & Core Features/003 SQL in Action.mp4 9.32 MB
02 - SQL Basics_ Syntax & Core Features/004 The Core SQL Rules.mp4 23.51 MB
02 - SQL Basics_ Syntax & Core Features/005 Data Definition vs Data Manipulation.mp4 21.35 MB
03 - Course Setup_ Installing MySQL & Postgresql/001 Module Introduction.mp4 12.03 MB
03 - Course Setup_ Installing MySQL & Postgresql/002 Installing Different Database Management Systems.mp4 15.95 MB
03 - Course Setup_ Installing MySQL & Postgresql/003 What We Need To Install.mp4 12.57 MB
03 - Course Setup_ Installing MySQL & Postgresql/005 MySQL Setup Overview & macOS Setup.mp4 104.22 MB
03 - Course Setup_ Installing MySQL & Postgresql/006 MySQL Windows Setup.mp4 58.66 MB
03 - Course Setup_ Installing MySQL & Postgresql/007 Postgresql Setup Overview & macOS Setup.mp4 58.68 MB
03 - Course Setup_ Installing MySQL & Postgresql/008 Postgresql Windows Setup.mp4 28.48 MB
03 - Course Setup_ Installing MySQL & Postgresql/010 Connecting To Database Servers (MySQL & Postgresql) With Various Clients.mp4 86.72 MB
03 - Course Setup_ Installing MySQL & Postgresql/011 Setting Up Visual Studio Code With The SQLTools Extension (Course Environment).mp4 67.53 MB
03 - Course Setup_ Installing MySQL & Postgresql/012 Configuring VS Code & Exploring SQLTools.mp4 56.2 MB
04 - Data Definition_ Managing Tables & Working With Data Types/001 Module Introduction.mp4 34.61 MB
04 - Data Definition_ Managing Tables & Working With Data Types/002 Key Terms When Working With Data Definition Statements & Commands.mp4 45.78 MB
04 - Data Definition_ Managing Tables & Working With Data Types/003 Introducing The Course Section Example.mp4 40.47 MB
04 - Data Definition_ Managing Tables & Working With Data Types/004 Introducing Key Data Definition Clauses.mp4 44.88 MB
04 - Data Definition_ Managing Tables & Working With Data Types/005 Creating a new Database (CREATE DATABASE).mp4 53 MB
04 - Data Definition_ Managing Tables & Working With Data Types/007 The Importance Of Data Types (Value Types).mp4 89.18 MB
04 - Data Definition_ Managing Tables & Working With Data Types/008 Introducing Key Text Value Types.mp4 106.57 MB
04 - Data Definition_ Managing Tables & Working With Data Types/009 Introducing Numeric Values, Date Types & More.mp4 89.32 MB
04 - Data Definition_ Managing Tables & Working With Data Types/011 How Do You Store Files_.mp4 19.74 MB
04 - Data Definition_ Managing Tables & Working With Data Types/012 Getting Started With The CREATE TABLE Statement & Syntax.mp4 30.74 MB
04 - Data Definition_ Managing Tables & Working With Data Types/013 Creating a First Text Column.mp4 17.95 MB
04 - Data Definition_ Managing Tables & Working With Data Types/014 Creating a Numeric Value Column.mp4 58.48 MB
04 - Data Definition_ Managing Tables & Working With Data Types/015 Working with Enums & Finishing Table Creation.mp4 47.77 MB
04 - Data Definition_ Managing Tables & Working With Data Types/016 Inserting Data Into The Created Table (INSERT INTO).mp4 30.25 MB
04 - Data Definition_ Managing Tables & Working With Data Types/017 Inserting & Querying More Data.mp4 31.07 MB
04 - Data Definition_ Managing Tables & Working With Data Types/018 Working With Fixed Point & Floating Point Numbers.mp4 56.24 MB
04 - Data Definition_ Managing Tables & Working With Data Types/019 Adding Boolean Value Types.mp4 12.61 MB
04 - Data Definition_ Managing Tables & Working With Data Types/020 Creating a new Table with Text & Timestamp Data.mp4 28.8 MB
04 - Data Definition_ Managing Tables & Working With Data Types/021 Inserting Data Into The New Tables.mp4 61.42 MB
04 - Data Definition_ Managing Tables & Working With Data Types/023 Introducing Default Column Values.mp4 21.59 MB
04 - Data Definition_ Managing Tables & Working With Data Types/024 Deleting (Dropping) Tables & Inserting Data With Default Values.mp4 44.03 MB
04 - Data Definition_ Managing Tables & Working With Data Types/025 Updating Tables & Columns.mp4 67.62 MB
04 - Data Definition_ Managing Tables & Working With Data Types/026 Dealing With _No Data_ (NULL) vs _0_.mp4 64.41 MB
04 - Data Definition_ Managing Tables & Working With Data Types/028 Exploring the NOT NULL Constraint.mp4 82.83 MB
04 - Data Definition_ Managing Tables & Working With Data Types/029 Exploring the CHECK Constraint.mp4 70.98 MB
04 - Data Definition_ Managing Tables & Working With Data Types/030 We Need Unique Values & Identifiers_.mp4 61.99 MB
04 - Data Definition_ Managing Tables & Working With Data Types/032 Working With Auto Incrementing IDs & Primary Keys.mp4 87.87 MB
04 - Data Definition_ Managing Tables & Working With Data Types/034 Constraints - Summary.mp4 14.48 MB
04 - Data Definition_ Managing Tables & Working With Data Types/035 Understanding Text Encoding & Collation.mp4 65.02 MB
04 - Data Definition_ Managing Tables & Working With Data Types/036 Temporary Tables & Tables From Other Tables.mp4 18.52 MB
04 - Data Definition_ Managing Tables & Working With Data Types/037 Creating Generated Columns.mp4 69.91 MB
04 - Data Definition_ Managing Tables & Working With Data Types/038 Module Summary.mp4 21.68 MB
04 - Data Definition_ Managing Tables & Working With Data Types/039 Time To Practice_ Problem.mp4 19.98 MB
04 - Data Definition_ Managing Tables & Working With Data Types/040 Time To Practice_ Solution (1_2).mp4 83.56 MB
04 - Data Definition_ Managing Tables & Working With Data Types/041 Time To Practice_ Solution (2_2).mp4 75.39 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/001 Module Introduction.mp4 5.52 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/002 What Are CRUD Operations_.mp4 11.95 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/003 Inserting Data_ Theory.mp4 4.23 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/004 Selecting Data_ Theory.mp4 7.56 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/005 Updating Data_ Theory.mp4 7.08 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/006 Deleting Data_ Theory.mp4 5.74 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/007 Introducing The Section Example.mp4 19.21 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/008 Setting Up An Example Database & Table.mp4 49.54 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/009 Example_ Inserting Data.mp4 47.8 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/010 Inserting More (Dummy) Data.mp4 11.79 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/011 Updating In Action.mp4 30.26 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/012 Deleting In Action.mp4 11.29 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/013 Selecting Data - The Basics.mp4 27.09 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/014 SELECT, Column Names & Data Expressions.mp4 26.75 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/015 Filtering with WHERE_ Available Comparison Operators & Variations.mp4 21.23 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/016 Filtering In Action (WHERE In Action).mp4 22.72 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/017 Combining Comparisons With AND & OR.mp4 23.88 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/018 Greater, Smaller & Ranges.mp4 50.32 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/019 Filtering Text Values.mp4 29.52 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/020 Working With Dates & Date Differences.mp4 40.25 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/022 Introducing ORDER BY & LIMIT.mp4 12.4 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/023 Ordering & Limiting Results In Action.mp4 51.35 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/024 Looking For DISTINCT Values.mp4 10.9 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/025 Subqueries & Views.mp4 42.77 MB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/026 Module Summary.mp4 16.24 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/001 Module Introduction.mp4 7.97 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/002 A First Look At Related Data.mp4 27.54 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/003 Data Normalization - First Steps.mp4 22.51 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/004 Splitting Data Into Tables.mp4 63.91 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/005 Forms Of Data Normalization.mp4 19.93 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/006 Our First Section Example.mp4 20.04 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/007 Creating Tables With Relations.mp4 76.58 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/008 Inserting Related Data.mp4 63.23 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/009 Joining Data & Introducing INNER JOIN.mp4 26.15 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/010 Using INNER JOIN.mp4 44.51 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/011 Combining Multiple JOINs.mp4 26.06 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/012 Data Joining & Filtering.mp4 27.43 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/013 Introducing LEFT JOIN.mp4 13.89 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/014 Using LEFT JOIN.mp4 22.7 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/015 Combining Multiple LEFT JOINs.mp4 16.13 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/016 What About RIGHT JOIN_.mp4 8.76 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/017 Example Time & INNER JOIN vs LEFT JOIN.mp4 76.47 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/018 Introducing CROSS JOIN.mp4 10.84 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/019 UNION & Why It's Different.mp4 50.94 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/020 What's Wrong With Our Foreign Keys_.mp4 44.9 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/021 Introducing Foreign Key Constraints.mp4 21.83 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/022 Diving Deeper Into Foreign Key Constraints.mp4 44.37 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/024 Foreign Key Constraints In Action.mp4 97.78 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/025 Data Relationship Types_ One-to-Many, Many-to-Many, One-to-ONe.mp4 27.01 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/026 A Bigger Example.mp4 30.38 MB
01 - Getting Started/001 Welcome To The Course_.mp4 53.71 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/028 Example_ Adding More Tables & Data.mp4 109.25 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/029 Many-to-Many Relationships & Intermediate Tables (_Linking Tables_).mp4 63.19 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/030 Querying The Example Data.mp4 56.33 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/031 Practicing JOINs With Filtering.mp4 72.49 MB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/032 Experimenting With Referential Integrity.mp4 49.53 MB
07 - More On Primary & Foreign Keys/001 Module Introduction.mp4 6.43 MB
07 - More On Primary & Foreign Keys/002 Remember_ Primary Keys Don't Have To Be Auto-Incrementing IDs_.mp4 21.38 MB
07 - More On Primary & Foreign Keys/004 Introducing Composite Primary Keys.mp4 15.68 MB
07 - More On Primary & Foreign Keys/005 Defining Composite Primary Keys (Composite Keys In Action).mp4 19.64 MB
07 - More On Primary & Foreign Keys/006 Composite Foreign Keys.mp4 38.04 MB
07 - More On Primary & Foreign Keys/007 Composite Keys In Action.mp4 22.11 MB
07 - More On Primary & Foreign Keys/008 Self-Referencing Relationships (Self-Referential Relationships).mp4 52.36 MB
07 - More On Primary & Foreign Keys/009 Self-Referencing Many To Many Relationships.mp4 46.66 MB
08 - Grouping & Aggregate Functions/001 Module Introduction.mp4 6.53 MB
08 - Grouping & Aggregate Functions/002 The Module Project.mp4 20.58 MB
08 - Grouping & Aggregate Functions/003 What are Aggregate Functions - Theory.mp4 23.16 MB
08 - Grouping & Aggregate Functions/004 Understanding COUNT().mp4 59.34 MB
08 - Grouping & Aggregate Functions/005 Working with MIN() & MAX() and Adding Aliases to Aggregate Functions.mp4 42.73 MB
08 - Grouping & Aggregate Functions/006 Using SUM(), AVG() & ROUND().mp4 32.45 MB
08 - Grouping & Aggregate Functions/007 Working with Filters & Joining Tables.mp4 71.51 MB
08 - Grouping & Aggregate Functions/008 Theory Time - Understanding GROUP BY.mp4 25.92 MB
08 - Grouping & Aggregate Functions/009 Applying GROUP BY in Practice.mp4 26.54 MB
08 - Grouping & Aggregate Functions/010 GROUP BY & Joined Queries.mp4 44.89 MB
08 - Grouping & Aggregate Functions/011 Understanding WHERE vs HAVING.mp4 53.75 MB
08 - Grouping & Aggregate Functions/012 Applying HAVING in Practice.mp4 48.56 MB
08 - Grouping & Aggregate Functions/013 Working with Nested Subqueries.mp4 54.44 MB
08 - Grouping & Aggregate Functions/014 Introducing Window Functions.mp4 39.91 MB
08 - Grouping & Aggregate Functions/015 Understanding ORDER BY and RANK().mp4 50.53 MB
09 - Built-in Query Functions & Operators/001 Module Introduction.mp4 8.97 MB
09 - Built-in Query Functions & Operators/002 The Module Project.mp4 14.14 MB
09 - Built-in Query Functions & Operators/003 Working with Mathematical Functions & Arithmetic Operators.mp4 98.21 MB
09 - Built-in Query Functions & Operators/004 Understanding String Functions with SELECT.mp4 44.94 MB
09 - Built-in Query Functions & Operators/005 Using String Functions with INSERT.mp4 65.39 MB
09 - Built-in Query Functions & Operators/006 Understanding Date _ Time Functions.mp4 23.99 MB
09 - Built-in Query Functions & Operators/007 Working with Weekdays.mp4 43.38 MB
09 - Built-in Query Functions & Operators/008 Calculating INTERVALS.mp4 47.16 MB
09 - Built-in Query Functions & Operators/009 Adding INTERVALS to Dates.mp4 37.05 MB
09 - Built-in Query Functions & Operators/010 Understanding LIKE & Pattern Matching.mp4 41.44 MB
09 - Built-in Query Functions & Operators/011 Understanding EXISTS.mp4 38.06 MB
09 - Built-in Query Functions & Operators/012 Working with Subquery Expressions and EXISTS.mp4 30.71 MB
09 - Built-in Query Functions & Operators/013 Working with Subquery Expressions and IN.mp4 59.75 MB
09 - Built-in Query Functions & Operators/014 Introducing Conditional Expressions.mp4 44.83 MB
09 - Built-in Query Functions & Operators/015 Challenge Solution.mp4 37.06 MB
09 - Built-in Query Functions & Operators/016 Database (SQL) vs Application Level.mp4 17.22 MB
10 - Database Transactions/001 Module Introduction.mp4 3.75 MB
10 - Database Transactions/002 Understanding Transactions.mp4 10.84 MB
10 - Database Transactions/004 Applying Transactions & ROLLBACK.mp4 62.11 MB
10 - Database Transactions/005 Committing Changes.mp4 63.44 MB
10 - Database Transactions/006 Working with Savepoints.mp4 34.39 MB
10 - Database Transactions/007 Transactions in PostgreSQL.mp4 34.34 MB
11 - Using Indexes/001 Module Introduction.mp4 5.44 MB
11 - Using Indexes/002 What Are Indexes_ And Why Would You Need Them_.mp4 38.52 MB
11 - Using Indexes/003 Don't Use Too Many Indexes_.mp4 7.56 MB
11 - Using Indexes/004 Index Types_ An Overview.mp4 32.76 MB
11 - Using Indexes/005 Setting Up Some Example Data.mp4 33.53 MB
11 - Using Indexes/006 EXPLAINing Queries & Query Planning.mp4 27.59 MB
11 - Using Indexes/007 Creating & Using Single-Column Indexes.mp4 24.55 MB
11 - Using Indexes/009 Unique Indexes.mp4 15.33 MB
11 - Using Indexes/010 Working With Multi-Column Indexes (Composite Indexes).mp4 47.97 MB
11 - Using Indexes/011 Partial Indexes.mp4 15.89 MB
12 - Summary & Practice_ A Complete Example/001 Module Introduction.mp4 25.36 MB
12 - Summary & Practice_ A Complete Example/002 What Is SQL_.mp4 86.72 MB
12 - Summary & Practice_ A Complete Example/003 A Closer Look At Databases In General.mp4 89.72 MB
12 - Summary & Practice_ A Complete Example/004 The Core SQL Syntax.mp4 95.91 MB
12 - Summary & Practice_ A Complete Example/005 Course Setup (For Following Along).mp4 71.35 MB
12 - Summary & Practice_ A Complete Example/006 Analyzing The Section Example Project.mp4 37.29 MB
12 - Summary & Practice_ A Complete Example/007 Introducing _Data Normalization_.mp4 21.02 MB
12 - Summary & Practice_ A Complete Example/008 Planning Tables & Relationships.mp4 56.24 MB
12 - Summary & Practice_ A Complete Example/009 Creating A New Database.mp4 19.55 MB
12 - Summary & Practice_ A Complete Example/010 Choosing Identifier Names.mp4 11.17 MB
12 - Summary & Practice_ A Complete Example/011 Defining Columns.mp4 13.58 MB
12 - Summary & Practice_ A Complete Example/012 Exploring Important Data Types.mp4 37.14 MB
12 - Summary & Practice_ A Complete Example/013 How To Store Files & Adding More Data Types.mp4 23.22 MB
12 - Summary & Practice_ A Complete Example/014 Constraints_ An Introduction.mp4 36.46 MB
12 - Summary & Practice_ A Complete Example/015 Introducing Database Functions.mp4 22.5 MB
12 - Summary & Practice_ A Complete Example/016 Understanding Primary Keys & Unique IDs.mp4 48.23 MB
12 - Summary & Practice_ A Complete Example/017 INSERTing Data.mp4 55.35 MB
12 - Summary & Practice_ A Complete Example/018 Basic Data Querying (via SELECT).mp4 11.68 MB
12 - Summary & Practice_ A Complete Example/019 UPDATE & DELETE In Action.mp4 35.87 MB
12 - Summary & Practice_ A Complete Example/020 Filtering (WHERE) & Sorting (ORDER BY).mp4 22.69 MB
12 - Summary & Practice_ A Complete Example/021 Adding More Tables.mp4 51.52 MB
12 - Summary & Practice_ A Complete Example/022 Relations & Foreign Keys.mp4 83.06 MB
12 - Summary & Practice_ A Complete Example/023 Understanding ON DELETE & ON UPDATE.mp4 33.01 MB
12 - Summary & Practice_ A Complete Example/024 Adding More Tables & Relationships.mp4 67.75 MB
12 - Summary & Practice_ A Complete Example/025 Many To Many Relationships & Linking (Intermediate) Tables.mp4 76.58 MB
12 - Summary & Practice_ A Complete Example/026 Inserting Related Data.mp4 132.14 MB
12 - Summary & Practice_ A Complete Example/027 Connecting Data With INNER JOIN.mp4 61.07 MB
12 - Summary & Practice_ A Complete Example/028 Combining Multiple Joins.mp4 41.62 MB
12 - Summary & Practice_ A Complete Example/029 Introducing LEFT JOIN.mp4 84.55 MB
12 - Summary & Practice_ A Complete Example/030 Joining Data & Filtering.mp4 30.06 MB
12 - Summary & Practice_ A Complete Example/031 Filtering Text With LIKE.mp4 33.78 MB
12 - Summary & Practice_ A Complete Example/032 Introducing Aggregate Functions.mp4 20.45 MB
12 - Summary & Practice_ A Complete Example/033 Grouping Aggregate Results (GROUP BY).mp4 37.52 MB
12 - Summary & Practice_ A Complete Example/034 The HAVING Clause (vs WHERE).mp4 32.64 MB
12 - Summary & Practice_ A Complete Example/035 Module Summary.mp4 19.19 MB
13 - Course Roundup/001 Congratulations + Bonus Content.mp4 19.92 MB
其他位置