种子简介

种子名称： [FreeCourseSite.com] Udemy - SQL - The Complete Developer's Guide (MySQL, PostgreSQL)
文件类型： 视频
文件数目： 203个文件
文件大小： 8.1 GB
收录时间： 2021-12-4 21:03
已经下载： 3次
资源热度： 212
最近下载： 2024-12-26 04:54

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:cbefa2c6528a74bb7b1d8f0cb6d95a4132a24d1a&dn=[FreeCourseSite.com] Udemy - SQL - The Complete Developer's Guide (MySQL, PostgreSQL) 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

[FreeCourseSite.com] Udemy - SQL - The Complete Developer's Guide (MySQL, PostgreSQL).torrent

01 - Getting Started/001 Welcome To The Course_.mp453.71MB

01 - Getting Started/002 What Is SQL_.mp486.68MB

01 - Getting Started/003 A Closer Look At SQL & Databases.mp489.74MB

01 - Getting Started/005 Course Content.mp467.14MB

01 - Getting Started/006 There Are Two Ways Of Taking This Course_.mp435.6MB

01 - Getting Started/007 How To Get The Most Out Of This Course.mp455.25MB

02 - SQL Basics_ Syntax & Core Features/001 Module Introduction.mp43.21MB

02 - SQL Basics_ Syntax & Core Features/002 Understanding The Core SQL Syntax.mp433.42MB

02 - SQL Basics_ Syntax & Core Features/003 SQL in Action.mp49.32MB

02 - SQL Basics_ Syntax & Core Features/004 The Core SQL Rules.mp423.51MB

02 - SQL Basics_ Syntax & Core Features/005 Data Definition vs Data Manipulation.mp421.35MB

03 - Course Setup_ Installing MySQL & Postgresql/001 Module Introduction.mp412.03MB

03 - Course Setup_ Installing MySQL & Postgresql/002 Installing Different Database Management Systems.mp415.95MB

03 - Course Setup_ Installing MySQL & Postgresql/003 What We Need To Install.mp412.57MB

03 - Course Setup_ Installing MySQL & Postgresql/005 MySQL Setup Overview & macOS Setup.mp4104.22MB

03 - Course Setup_ Installing MySQL & Postgresql/006 MySQL Windows Setup.mp458.66MB

03 - Course Setup_ Installing MySQL & Postgresql/007 Postgresql Setup Overview & macOS Setup.mp458.68MB

03 - Course Setup_ Installing MySQL & Postgresql/008 Postgresql Windows Setup.mp428.48MB

03 - Course Setup_ Installing MySQL & Postgresql/010 Connecting To Database Servers (MySQL & Postgresql) With Various Clients.mp486.72MB

03 - Course Setup_ Installing MySQL & Postgresql/011 Setting Up Visual Studio Code With The SQLTools Extension (Course Environment).mp467.53MB

03 - Course Setup_ Installing MySQL & Postgresql/012 Configuring VS Code & Exploring SQLTools.mp456.2MB

04 - Data Definition_ Managing Tables & Working With Data Types/001 Module Introduction.mp434.61MB

04 - Data Definition_ Managing Tables & Working With Data Types/002 Key Terms When Working With Data Definition Statements & Commands.mp445.78MB

04 - Data Definition_ Managing Tables & Working With Data Types/003 Introducing The Course Section Example.mp440.47MB

04 - Data Definition_ Managing Tables & Working With Data Types/004 Introducing Key Data Definition Clauses.mp444.88MB

04 - Data Definition_ Managing Tables & Working With Data Types/005 Creating a new Database (CREATE DATABASE).mp453MB

04 - Data Definition_ Managing Tables & Working With Data Types/007 The Importance Of Data Types (Value Types).mp489.18MB

04 - Data Definition_ Managing Tables & Working With Data Types/008 Introducing Key Text Value Types.mp4106.57MB

04 - Data Definition_ Managing Tables & Working With Data Types/009 Introducing Numeric Values, Date Types & More.mp489.32MB

04 - Data Definition_ Managing Tables & Working With Data Types/011 How Do You Store Files_.mp419.74MB

04 - Data Definition_ Managing Tables & Working With Data Types/012 Getting Started With The CREATE TABLE Statement & Syntax.mp430.74MB

04 - Data Definition_ Managing Tables & Working With Data Types/013 Creating a First Text Column.mp417.95MB

04 - Data Definition_ Managing Tables & Working With Data Types/014 Creating a Numeric Value Column.mp458.48MB

04 - Data Definition_ Managing Tables & Working With Data Types/015 Working with Enums & Finishing Table Creation.mp447.77MB

04 - Data Definition_ Managing Tables & Working With Data Types/016 Inserting Data Into The Created Table (INSERT INTO).mp430.25MB

04 - Data Definition_ Managing Tables & Working With Data Types/017 Inserting & Querying More Data.mp431.07MB

04 - Data Definition_ Managing Tables & Working With Data Types/018 Working With Fixed Point & Floating Point Numbers.mp456.24MB

04 - Data Definition_ Managing Tables & Working With Data Types/019 Adding Boolean Value Types.mp412.61MB

04 - Data Definition_ Managing Tables & Working With Data Types/020 Creating a new Table with Text & Timestamp Data.mp428.8MB

04 - Data Definition_ Managing Tables & Working With Data Types/021 Inserting Data Into The New Tables.mp461.42MB

04 - Data Definition_ Managing Tables & Working With Data Types/023 Introducing Default Column Values.mp421.59MB

04 - Data Definition_ Managing Tables & Working With Data Types/024 Deleting (Dropping) Tables & Inserting Data With Default Values.mp444.03MB

04 - Data Definition_ Managing Tables & Working With Data Types/025 Updating Tables & Columns.mp467.62MB

04 - Data Definition_ Managing Tables & Working With Data Types/026 Dealing With _No Data_ (NULL) vs _0_.mp464.41MB

04 - Data Definition_ Managing Tables & Working With Data Types/028 Exploring the NOT NULL Constraint.mp482.83MB

04 - Data Definition_ Managing Tables & Working With Data Types/029 Exploring the CHECK Constraint.mp470.98MB

04 - Data Definition_ Managing Tables & Working With Data Types/030 We Need Unique Values & Identifiers_.mp461.99MB

04 - Data Definition_ Managing Tables & Working With Data Types/032 Working With Auto Incrementing IDs & Primary Keys.mp487.87MB

04 - Data Definition_ Managing Tables & Working With Data Types/034 Constraints - Summary.mp414.48MB

04 - Data Definition_ Managing Tables & Working With Data Types/035 Understanding Text Encoding & Collation.mp465.02MB

04 - Data Definition_ Managing Tables & Working With Data Types/036 Temporary Tables & Tables From Other Tables.mp418.52MB

04 - Data Definition_ Managing Tables & Working With Data Types/037 Creating Generated Columns.mp469.91MB

04 - Data Definition_ Managing Tables & Working With Data Types/038 Module Summary.mp421.68MB

04 - Data Definition_ Managing Tables & Working With Data Types/039 Time To Practice_ Problem.mp419.98MB

04 - Data Definition_ Managing Tables & Working With Data Types/040 Time To Practice_ Solution (1_2).mp483.56MB

04 - Data Definition_ Managing Tables & Working With Data Types/041 Time To Practice_ Solution (2_2).mp475.39MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/001 Module Introduction.mp45.52MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/002 What Are CRUD Operations_.mp411.95MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/003 Inserting Data_ Theory.mp44.23MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/004 Selecting Data_ Theory.mp47.56MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/005 Updating Data_ Theory.mp47.08MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/006 Deleting Data_ Theory.mp45.74MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/007 Introducing The Section Example.mp419.21MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/008 Setting Up An Example Database & Table.mp449.54MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/009 Example_ Inserting Data.mp447.8MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/010 Inserting More (Dummy) Data.mp411.79MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/011 Updating In Action.mp430.26MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/012 Deleting In Action.mp411.29MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/013 Selecting Data - The Basics.mp427.09MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/014 SELECT, Column Names & Data Expressions.mp426.75MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/015 Filtering with WHERE_ Available Comparison Operators & Variations.mp421.23MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/016 Filtering In Action (WHERE In Action).mp422.72MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/017 Combining Comparisons With AND & OR.mp423.88MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/018 Greater, Smaller & Ranges.mp450.32MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/019 Filtering Text Values.mp429.52MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/020 Working With Dates & Date Differences.mp440.25MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/022 Introducing ORDER BY & LIMIT.mp412.4MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/023 Ordering & Limiting Results In Action.mp451.35MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/024 Looking For DISTINCT Values.mp410.9MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/025 Subqueries & Views.mp442.77MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/026 Module Summary.mp416.24MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/001 Module Introduction.mp47.97MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/002 A First Look At Related Data.mp427.54MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/003 Data Normalization - First Steps.mp422.51MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/004 Splitting Data Into Tables.mp463.91MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/005 Forms Of Data Normalization.mp419.93MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/006 Our First Section Example.mp420.04MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/007 Creating Tables With Relations.mp476.58MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/008 Inserting Related Data.mp463.23MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/009 Joining Data & Introducing INNER JOIN.mp426.15MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/010 Using INNER JOIN.mp444.51MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/011 Combining Multiple JOINs.mp426.06MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/012 Data Joining & Filtering.mp427.43MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/013 Introducing LEFT JOIN.mp413.89MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/014 Using LEFT JOIN.mp422.7MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/015 Combining Multiple LEFT JOINs.mp416.13MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/016 What About RIGHT JOIN_.mp48.76MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/017 Example Time & INNER JOIN vs LEFT JOIN.mp476.47MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/018 Introducing CROSS JOIN.mp410.84MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/019 UNION & Why It's Different.mp450.94MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/020 What's Wrong With Our Foreign Keys_.mp444.9MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/021 Introducing Foreign Key Constraints.mp421.83MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/022 Diving Deeper Into Foreign Key Constraints.mp444.37MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/024 Foreign Key Constraints In Action.mp497.78MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/025 Data Relationship Types_ One-to-Many, Many-to-Many, One-to-ONe.mp427.01MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/026 A Bigger Example.mp430.38MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/027 Example_ Adding First Tables & Relations.mp4132.38MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/028 Example_ Adding More Tables & Data.mp4109.25MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/029 Many-to-Many Relationships & Intermediate Tables (_Linking Tables_).mp463.19MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/030 Querying The Example Data.mp456.33MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/031 Practicing JOINs With Filtering.mp472.49MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/032 Experimenting With Referential Integrity.mp449.53MB

07 - More On Primary & Foreign Keys/001 Module Introduction.mp46.43MB

07 - More On Primary & Foreign Keys/002 Remember_ Primary Keys Don't Have To Be Auto-Incrementing IDs_.mp421.38MB

07 - More On Primary & Foreign Keys/004 Introducing Composite Primary Keys.mp415.68MB

07 - More On Primary & Foreign Keys/005 Defining Composite Primary Keys (Composite Keys In Action).mp419.64MB

07 - More On Primary & Foreign Keys/006 Composite Foreign Keys.mp438.04MB

07 - More On Primary & Foreign Keys/007 Composite Keys In Action.mp422.11MB

07 - More On Primary & Foreign Keys/008 Self-Referencing Relationships (Self-Referential Relationships).mp452.36MB

07 - More On Primary & Foreign Keys/009 Self-Referencing Many To Many Relationships.mp446.66MB

08 - Grouping & Aggregate Functions/001 Module Introduction.mp46.53MB

08 - Grouping & Aggregate Functions/002 The Module Project.mp420.58MB

08 - Grouping & Aggregate Functions/003 What are Aggregate Functions - Theory.mp423.16MB

08 - Grouping & Aggregate Functions/004 Understanding COUNT().mp459.34MB

08 - Grouping & Aggregate Functions/005 Working with MIN() & MAX() and Adding Aliases to Aggregate Functions.mp442.73MB

08 - Grouping & Aggregate Functions/006 Using SUM(), AVG() & ROUND().mp432.45MB

08 - Grouping & Aggregate Functions/007 Working with Filters & Joining Tables.mp471.51MB

08 - Grouping & Aggregate Functions/008 Theory Time - Understanding GROUP BY.mp425.92MB

08 - Grouping & Aggregate Functions/009 Applying GROUP BY in Practice.mp426.54MB

08 - Grouping & Aggregate Functions/010 GROUP BY & Joined Queries.mp444.89MB

08 - Grouping & Aggregate Functions/011 Understanding WHERE vs HAVING.mp453.75MB

08 - Grouping & Aggregate Functions/012 Applying HAVING in Practice.mp448.56MB

08 - Grouping & Aggregate Functions/013 Working with Nested Subqueries.mp454.44MB

08 - Grouping & Aggregate Functions/014 Introducing Window Functions.mp439.91MB

08 - Grouping & Aggregate Functions/015 Understanding ORDER BY and RANK().mp450.53MB

09 - Built-in Query Functions & Operators/001 Module Introduction.mp48.97MB

09 - Built-in Query Functions & Operators/002 The Module Project.mp414.14MB

09 - Built-in Query Functions & Operators/003 Working with Mathematical Functions & Arithmetic Operators.mp498.21MB

09 - Built-in Query Functions & Operators/004 Understanding String Functions with SELECT.mp444.94MB

09 - Built-in Query Functions & Operators/005 Using String Functions with INSERT.mp465.39MB

09 - Built-in Query Functions & Operators/006 Understanding Date _ Time Functions.mp423.99MB

09 - Built-in Query Functions & Operators/007 Working with Weekdays.mp443.38MB

09 - Built-in Query Functions & Operators/008 Calculating INTERVALS.mp447.16MB

09 - Built-in Query Functions & Operators/009 Adding INTERVALS to Dates.mp437.05MB

09 - Built-in Query Functions & Operators/010 Understanding LIKE & Pattern Matching.mp441.44MB

09 - Built-in Query Functions & Operators/011 Understanding EXISTS.mp438.06MB

09 - Built-in Query Functions & Operators/012 Working with Subquery Expressions and EXISTS.mp430.71MB

09 - Built-in Query Functions & Operators/013 Working with Subquery Expressions and IN.mp459.75MB

09 - Built-in Query Functions & Operators/014 Introducing Conditional Expressions.mp444.83MB

09 - Built-in Query Functions & Operators/015 Challenge Solution.mp437.06MB

09 - Built-in Query Functions & Operators/016 Database (SQL) vs Application Level.mp417.22MB

10 - Database Transactions/001 Module Introduction.mp43.75MB

10 - Database Transactions/002 Understanding Transactions.mp410.84MB

10 - Database Transactions/004 Applying Transactions & ROLLBACK.mp462.11MB

10 - Database Transactions/005 Committing Changes.mp463.44MB

10 - Database Transactions/006 Working with Savepoints.mp434.39MB

10 - Database Transactions/007 Transactions in PostgreSQL.mp434.34MB

11 - Using Indexes/001 Module Introduction.mp45.44MB

11 - Using Indexes/002 What Are Indexes_ And Why Would You Need Them_.mp438.52MB

11 - Using Indexes/003 Don't Use Too Many Indexes_.mp47.56MB

11 - Using Indexes/004 Index Types_ An Overview.mp432.76MB

11 - Using Indexes/005 Setting Up Some Example Data.mp433.53MB

11 - Using Indexes/006 EXPLAINing Queries & Query Planning.mp427.59MB

11 - Using Indexes/007 Creating & Using Single-Column Indexes.mp424.55MB

11 - Using Indexes/009 Unique Indexes.mp415.33MB

11 - Using Indexes/010 Working With Multi-Column Indexes (Composite Indexes).mp447.97MB

11 - Using Indexes/011 Partial Indexes.mp415.89MB

12 - Summary & Practice_ A Complete Example/001 Module Introduction.mp425.36MB

12 - Summary & Practice_ A Complete Example/002 What Is SQL_.mp486.72MB

12 - Summary & Practice_ A Complete Example/003 A Closer Look At Databases In General.mp489.72MB

12 - Summary & Practice_ A Complete Example/004 The Core SQL Syntax.mp495.91MB

12 - Summary & Practice_ A Complete Example/005 Course Setup (For Following Along).mp471.35MB

12 - Summary & Practice_ A Complete Example/006 Analyzing The Section Example Project.mp437.29MB

12 - Summary & Practice_ A Complete Example/007 Introducing _Data Normalization_.mp421.02MB

12 - Summary & Practice_ A Complete Example/008 Planning Tables & Relationships.mp456.24MB

12 - Summary & Practice_ A Complete Example/009 Creating A New Database.mp419.55MB

12 - Summary & Practice_ A Complete Example/010 Choosing Identifier Names.mp411.17MB

12 - Summary & Practice_ A Complete Example/011 Defining Columns.mp413.58MB

12 - Summary & Practice_ A Complete Example/012 Exploring Important Data Types.mp437.14MB

12 - Summary & Practice_ A Complete Example/013 How To Store Files & Adding More Data Types.mp423.22MB

12 - Summary & Practice_ A Complete Example/014 Constraints_ An Introduction.mp436.46MB

12 - Summary & Practice_ A Complete Example/015 Introducing Database Functions.mp422.5MB

12 - Summary & Practice_ A Complete Example/016 Understanding Primary Keys & Unique IDs.mp448.23MB

12 - Summary & Practice_ A Complete Example/017 INSERTing Data.mp455.35MB

12 - Summary & Practice_ A Complete Example/018 Basic Data Querying (via SELECT).mp411.68MB

12 - Summary & Practice_ A Complete Example/019 UPDATE & DELETE In Action.mp435.87MB

12 - Summary & Practice_ A Complete Example/020 Filtering (WHERE) & Sorting (ORDER BY).mp422.69MB

12 - Summary & Practice_ A Complete Example/021 Adding More Tables.mp451.52MB

12 - Summary & Practice_ A Complete Example/022 Relations & Foreign Keys.mp483.06MB

12 - Summary & Practice_ A Complete Example/023 Understanding ON DELETE & ON UPDATE.mp433.01MB

12 - Summary & Practice_ A Complete Example/024 Adding More Tables & Relationships.mp467.75MB

12 - Summary & Practice_ A Complete Example/025 Many To Many Relationships & Linking (Intermediate) Tables.mp476.58MB

12 - Summary & Practice_ A Complete Example/026 Inserting Related Data.mp4132.14MB

12 - Summary & Practice_ A Complete Example/027 Connecting Data With INNER JOIN.mp461.07MB

12 - Summary & Practice_ A Complete Example/028 Combining Multiple Joins.mp441.62MB

12 - Summary & Practice_ A Complete Example/029 Introducing LEFT JOIN.mp484.55MB

12 - Summary & Practice_ A Complete Example/030 Joining Data & Filtering.mp430.06MB

12 - Summary & Practice_ A Complete Example/031 Filtering Text With LIKE.mp433.78MB

12 - Summary & Practice_ A Complete Example/032 Introducing Aggregate Functions.mp420.45MB

12 - Summary & Practice_ A Complete Example/033 Grouping Aggregate Results (GROUP BY).mp437.52MB

12 - Summary & Practice_ A Complete Example/034 The HAVING Clause (vs WHERE).mp432.64MB

12 - Summary & Practice_ A Complete Example/035 Module Summary.mp419.19MB

13 - Course Roundup/001 Congratulations + Bonus Content.mp419.92MB