[] Udemy - The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert 收录时间:2018-03-17 03:05:41 文件大小:3GB 下载次数:232 最近下载:2021-01-22 23:54:39 磁力链接: magnet:?xt=urn:btih:a33a6ac8a623f2fba59c6999b32b1a32fe5e0714 立即下载 复制链接 文件列表 14 Instagram Database Clone/238 Introduction To Instagram Clone Schema.mp4 69MB 15 Working With Lots Of Instagram Data/254 Loading The JUMBO dataset.mp4 59MB 14 Instagram Database Clone/245 Cloning Instagram's DB_ Likes Schema.mp4 52MB 17 Section 17 - Building Our Web App/304 Adding EJS Templates.mp4 38MB 17 Section 17 - Building Our Web App/306 Connecting The Form.mp4 36MB 17 Section 17 - Building Our Web App/298 Our First Simple Web App.mp4 35MB 12 Section 12_ One To Many/204 Inner Join.mp4 34MB 11 The Power of Logical Operators/194 Logical Operators Exercises Solution.mp4 33MB 08 Refining Our Selections/131 Refining Selections Exercises Solution.mp4 33MB 10 Revisiting Data Types/165 Formatting Dates.mp4 32MB 01 Introduction and 5 Minutes of SQL/004 Your First 5 Minutes of SQL - Let's Get Coding!.mp4 31MB 01 Introduction and 5 Minutes of SQL/006 How The Course Works.mp4 31MB 14 Instagram Database Clone/249 Cloning Instagram's DB_ Hashtags Part 1.mp4 30MB 02 Getting Started_ Overview and Installation/019 Mac Installation.mp4 30MB 13 Section 13_ Many To Many/233 TV Joins Challenge 6.mp4 29MB 07 The World Of String Functions/102 Working with CONCAT.mp4 29MB 12 Section 12_ One To Many/200 Working With Foreign Keys.mp4 29MB 16 Section 16 - Introducing Node/289 Bulk Inserting 500 Users - Finally!.mp4 28MB 12 Section 12_ One To Many/206 Left Join.mp4 28MB 16 Section 16 - Introducing Node/286 Inserting Using Node.mp4 28MB 16 Section 16 - Introducing Node/292 500 Users Exercises Solutions.mp4 28MB 10 Revisiting Data Types/172 Data Types Exercises Solution.mp4 26MB 12 Section 12_ One To Many/208 Right Joins Pt 1.mp4 26MB 10 Revisiting Data Types/167 Date Math.mp4 25MB 07 The World Of String Functions/115 String Function Challenges Solution.mp4 25MB 18 Section 18 - Database Triggers/315 Creating Logger Triggers.mp4 25MB 11 The Power of Logical Operators/187 Between.mp4 24MB 09 The Magic of Aggregate Functions/136 The Joys of Group By.mp4 24MB 16 Section 16 - Introducing Node/280 Connecting Node to MySQL.mp4 23MB 18 Section 18 - Database Triggers/313 Writing Our First Trigger Part 2.mp4 23MB 17 Section 17 - Building Our Web App/300 Adding Multiple Routes.mp4 23MB 17 Section 17 - Building Our Web App/308 Styling Part 1.mp4 22MB 11 The Power of Logical Operators/189 In And Not In.mp4 22MB 13 Section 13_ Many To Many/221 Creating Our Tables.mp4 22MB 12 Section 12_ One To Many/217 Our First Joins Exercise SOLUTION PT_ 2.mp4 22MB 11 The Power of Logical Operators/191 Case Statements.mp4 21MB 17 Section 17 - Building Our Web App/302 Connecting Express and MySQL.mp4 21MB 10 Revisiting Data Types/152 CHAR and VARCHAR.mp4 21MB 07 The World Of String Functions/098 Running SQL Files.mp4 21MB 12 Section 12_ One To Many/210 Right Joins Pt 2.mp4 21MB 16 Section 16 - Introducing Node/277 Introduction to NPM and Faker.mp4 20MB 08 Refining Our Selections/122 Sorting Data with ORDER BY.mp4 20MB 10 Revisiting Data Types/169 Working with TIMESTAMPS.mp4 19MB 12 Section 12_ One To Many/199 One To Many_ The Basics.mp4 19MB 12 Section 12_ One To Many/215 Our First Joins Exercise SOLUTION.mp4 19MB 02 Getting Started_ Overview and Installation/015 Installing MySQL on Cloud9.mp4 19MB 18 Section 18 - Database Triggers/314 Preventing Instagram Self-Follows With Triggers.mp4 18MB 17 Section 17 - Building Our Web App/310 Styling Part 2.mp4 18MB 04 Inserting Data (and a couple other things)/058 A Primer On Primary Keys.mp4 18MB 12 Section 12_ One To Many/197 Real World Data Is Messy.mp4 18MB 16 Section 16 - Introducing Node/288 Some MySQL_Node Magic.mp4 18MB 09 The Magic of Aggregate Functions/133 Section 9 Introduction.mp4 18MB 15 Working With Lots Of Instagram Data/260 Instagram Clone Challenge 3.mp4 17MB 08 Refining Our Selections/120 Using DISTINCT.mp4 17MB 07 The World Of String Functions/100 Loading Our Book Data.mp4 16MB 11 The Power of Logical Operators/179 Greater Than.mp4 16MB 08 Refining Our Selections/124 Using LIMIT.mp4 16MB 14 Instagram Database Clone/247 Cloning Instagram's DB_ Followers Schema.mp4 16MB 15 Working With Lots Of Instagram Data/262 Instagram Clone Challenge 4.mp4 16MB 07 The World Of String Functions/104 Introducing SUBSTRING.mp4 16MB 11 The Power of Logical Operators/174 Section 11 Introduction.mp4 16MB 13 Section 13_ Many To Many/235 TV Joins Challenge 7.mp4 15MB 11 The Power of Logical Operators/183 Logical AND.mp4 15MB 10 Revisiting Data Types/155 DECIMAL.mp4 15MB 13 Section 13_ Many To Many/229 TV Joins Challenge 4.mp4 15MB 16 Section 16 - Introducing Node/273 Introduction to JOIN US app.mp4 15MB 16 Section 16 - Introducing Node/272 BUT WHAT ABOUT PHP.mp4 15MB 06 CRUD Challenge Section/087 Section 6 Introduction.mp4 15MB 17 Section 17 - Building Our Web App/297 NPM Init and package_json files.mp4 15MB 18 Section 18 - Database Triggers/312 Writing Our First Trigger Part 1.mp4 15MB 12 Section 12_ One To Many/214 Our First Joins Exercise.mp4 15MB 09 The Magic of Aggregate Functions/149 Aggregate Functions Challenges Solution.mp4 15MB 14 Instagram Database Clone/241 Cloning Instagram's DB_ Photos Schema.mp4 15MB 16 Section 16 - Introducing Node/271 MySQL and Other Languages.mp4 15MB 14 Instagram Database Clone/250 Cloning Instagram's DB_ Hashtags Part 2.mp4 15MB 13 Section 13_ Many To Many/223 TV Joins Challenge 1.mp4 15MB 12 Section 12_ One To Many/202 Cross Join.mp4 14MB 15 Working With Lots Of Instagram Data/266 Instagram Clone Challenge 6.mp4 14MB 13 Section 13_ Many To Many/227 TV Joins Challenge 3.mp4 14MB 11 The Power of Logical Operators/185 Logical OR.mp4 14MB 16 Section 16 - Introducing Node/284 Selecting Using Node.mp4 14MB 13 Section 13_ Many To Many/220 Many To Many Basics.mp4 14MB 07 The World Of String Functions/106 Introducing REPLACE.mp4 14MB 16 Section 16 - Introducing Node/282 Creating Our Users Table.mp4 14MB 09 The Magic of Aggregate Functions/140 SUBQUERIES - A Problem with Min and Max.mp4 14MB 02 Getting Started_ Overview and Installation/008 What Is a Database_.mp4 14MB 08 Refining Our Selections/126 Better Searches with LIKE.mp4 14MB 09 The Magic of Aggregate Functions/142 Using Min and Max with Group By.mp4 13MB 05 CRUD commmands/063 Section 5 Introduction.mp4 13MB 12 Section 12_ One To Many/196 Section 12 Introduction.mp4 13MB 13 Section 13_ Many To Many/225 TV Joins Challenge 2.mp4 13MB 16 Section 16 - Introducing Node/270 Section 16 Introduction.mp4 13MB 13 Section 13_ Many To Many/219 Section 13 Introduction.mp4 13MB 14 Instagram Database Clone/243 Cloning Instagram's DB_ Comments Schema.mp4 13MB 09 The Magic of Aggregate Functions/134 The Count Function.mp4 13MB 18 Section 18 - Database Triggers/316 Managing Triggers And A Warning.mp4 13MB 02 Getting Started_ Overview and Installation/013 Exploring The Cloud9 Interface.mp4 12MB 01 Introduction and 5 Minutes of SQL/003 Syllabus Walkthrough and Prerequisites.mp4 12MB 13 Section 13_ Many To Many/231 TV Joins Challenge 5.mp4 12MB 14 Instagram Database Clone/239 Cloning Instagram's DB_ Users Schema.mp4 12MB 16 Section 16 - Introducing Node/275 5 Minute NodeJS Crash Course.mp4 12MB 17 Section 17 - Building Our Web App/294 Section 17 Introduction.mp4 12MB 15 Working With Lots Of Instagram Data/258 Instagram Clone Challenge 2.mp4 12MB 07 The World Of String Functions/097 Section 7 Introduction.mp4 12MB 10 Revisiting Data Types/157 FLOAT and DOUBLE.mp4 12MB 15 Working With Lots Of Instagram Data/253 Section 15 Introduction.mp4 11MB 10 Revisiting Data Types/151 Section 10 Introduction.mp4 11MB 15 Working With Lots Of Instagram Data/256 Instagram Clone Challenge 1.mp4 11MB 15 Working With Lots Of Instagram Data/268 Instagram Clone Challenge 7.mp4 11MB 11 The Power of Logical Operators/193 Logical Operators Exercises.mp4 11MB 04 Inserting Data (and a couple other things)/042 Section 4 Introduction.mp4 11MB 03 Creating Databases and Tables/030 The Basic Datatypes.mp4 11MB 10 Revisiting Data Types/163 CURDATE_ CURTIME_ and NOW.mp4 11MB 11 The Power of Logical Operators/175 Not Equal.mp4 11MB 06 CRUD Challenge Section/088 CRUD Exercise Overview.mp4 11MB 16 Section 16 - Introducing Node/274 Setting Up Cloud9 for Node.mp4 11MB 02 Getting Started_ Overview and Installation/009 SQL Vs_ MySQL.mp4 10MB 04 Inserting Data (and a couple other things)/056 Setting Default Values.mp4 10MB 04 Inserting Data (and a couple other things)/054 NULL and NOT_NULL.mp4 10MB 12 Section 12_ One To Many/212 Right and Left Joins_ A Common Question.mp4 10MB 03 Creating Databases and Tables/023 Creating Databases.mp4 10MB 03 Creating Databases and Tables/029 Introduction to Tables.mp4 10MB 17 Section 17 - Building Our Web App/296 Introducing Express.mp4 10MB 04 Inserting Data (and a couple other things)/050 INSERT Challenges Solution.mp4 10MB 08 Refining Our Selections/128 LIKE Part 2_ More Wildcards.mp4 9MB 03 Creating Databases and Tables/022 Section 3 Introduction.mp4 9MB 14 Instagram Database Clone/237 Section 14 Introduction.mp4 9MB 02 Getting Started_ Overview and Installation/010 Installation Overview - WATCH BEFORE INSTALLING.mp4 9MB 04 Inserting Data (and a couple other things)/043 Inserting Data.mp4 9MB 06 CRUD Challenge Section/089 CRUD Exercise Create Solution.mp4 9MB 04 Inserting Data (and a couple other things)/052 MySQL Warnings.mp4 9MB 09 The Magic of Aggregate Functions/146 The Avg Function.mp4 9MB 09 The Magic of Aggregate Functions/138 Min and Max Basics.mp4 8MB 01 Introduction and 5 Minutes of SQL/002 Instructor Introduction(s).mp4 8MB 10 Revisiting Data Types/161 Creating Our DATE data.mp4 8MB 07 The World Of String Functions/110 Working with CHAR LENGTH.mp4 8MB 09 The Magic of Aggregate Functions/144 The Sum Function.mp4 8MB 12 Section 12_ One To Many/198 Types of Data Relationships.mp4 8MB 11 The Power of Logical Operators/181 Less Than.mp4 8MB 18 Section 18 - Database Triggers/311 Introduction to Database Triggers.mp4 8MB 02 Getting Started_ Overview and Installation/012 Setting Up Cloud9.mp4 8MB 04 Inserting Data (and a couple other things)/061 Table Constraints Exercise Solution.mp4 8MB 02 Getting Started_ Overview and Installation/007 Section Introduction.mp4 8MB 03 Creating Databases and Tables/040 Creating Your Own Tables Challenge.mp4 8MB 09 The Magic of Aggregate Functions/148 Aggregate Functions Challenges.mp4 8MB 08 Refining Our Selections/130 Refining Selections Exercises.mp4 7MB 07 The World Of String Functions/114 String Function Challenges.mp4 7MB 05 CRUD commmands/077 The UPDATE Command.mp4 7MB 10 Revisiting Data Types/171 Data Types Exercises.mp4 7MB 16 Section 16 - Introducing Node/279 Introducing the MySQL Package.mp4 7MB 07 The World Of String Functions/108 Using REVERSE.mp4 7MB 05 CRUD commmands/070 Introduction to WHERE.mp4 7MB 15 Working With Lots Of Instagram Data/264 Instagram Clone Challenge 5.mp4 7MB 02 Getting Started_ Overview and Installation/017 Your First MySQL Activity.mp4 6MB 06 CRUD Challenge Section/093 CRUD Exercise Update Solution.mp4 6MB 06 CRUD Challenge Section/095 CRUD Exercise Delete Solution.mp4 6MB 05 CRUD commmands/082 Introduction to DELETE.mp4 6MB 07 The World Of String Functions/112 Changing Case with UPPER and LOWER.mp4 6MB 05 CRUD commmands/068 Official Introduction to SELECT.mp4 6MB 02 Getting Started_ Overview and Installation/014 Cloud9 Interface Challenge.mp4 6MB 01 Introduction and 5 Minutes of SQL/001 Course Introduction.mp4 6MB 02 Getting Started_ Overview and Installation/021 Windows Installation.mp4 6MB 05 CRUD commmands/080 UPDATE Challenges Solution.mp4 6MB 10 Revisiting Data Types/160 DATE_ TIME_ and DATETIME.mp4 5MB 04 Inserting Data (and a couple other things)/047 Multiple INSERT.mp4 5MB 03 Creating Databases and Tables/032 Basic Datatypes Challenge.mp4 5MB 05 CRUD commmands/066 Preparing Our Data.mp4 5MB 08 Refining Our Selections/117 Section 8 Introduction.mp4 5MB 16 Section 16 - Introducing Node/291 500 Users Exercises.mp4 5MB 03 Creating Databases and Tables/027 Using Databases.mp4 4MB 05 CRUD commmands/072 SELECT Challenges.mp4 4MB 05 CRUD commmands/085 DELETE Challenges Solution.mp4 4MB 05 CRUD commmands/073 SELECT Challenges Solution.mp4 4MB 05 CRUD commmands/075 Introduction to Aliases.mp4 4MB 03 Creating Databases and Tables/034 Creating Your Own Tables.mp4 4MB 08 Refining Our Selections/118 Seed Data_ Adding A Couple New Books.mp4 4MB 11 The Power of Logical Operators/177 Not Like.mp4 4MB 17 Section 17 - Building Our Web App/295 JoinUsCompleteCode.zip 4MB 03 Creating Databases and Tables/036 How Do We Know It Worked_.mp4 4MB 04 Inserting Data (and a couple other things)/049 INSERT Challenges.mp4 3MB 05 CRUD commmands/064 Introduction to CRUD.mp4 3MB 04 Inserting Data (and a couple other things)/045 Super Quick Intro To SELECT.mp4 3MB 06 CRUD Challenge Section/091 CRUD Exercise Read Solution.mp4 3MB 04 Inserting Data (and a couple other things)/060 Table Constraints Exercise.mp4 3MB 03 Creating Databases and Tables/025 Dropping Databases.mp4 2MB 03 Creating Databases and Tables/038 Dropping Tables.mp4 2MB 05 CRUD commmands/084 DELETE Challenges.mp4 2MB 05 CRUD commmands/079 UPDATE Challenges.mp4 1MB 15 Working With Lots Of Instagram Data/255 ig-clone-data.sql 429KB 17 Section 17 - Building Our Web App/306 Connecting The Form-subtitle-en.srt 27KB 17 Section 17 - Building Our Web App/298 Our First Simple Web App-subtitle-en.srt 25KB 17 Section 17 - Building Our Web App/304 Adding EJS Templates-subtitle-en.srt 24KB 17 Section 17 - Building Our Web App/306 Connecting The Form-subtitle-en.vtt 23KB 11 The Power of Logical Operators/194 Logical Operators Exercises Solution-subtitle-en.srt 22KB 12 Section 12_ One To Many/206 Left Join-subtitle-en.srt 22KB 17 Section 17 - Building Our Web App/298 Our First Simple Web App-subtitle-en.vtt 21KB 17 Section 17 - Building Our Web App/304 Adding EJS Templates-subtitle-en.vtt 21KB 10 Revisiting Data Types/152 CHAR and VARCHAR-subtitle-en.srt 20KB 11 The Power of Logical Operators/194 Logical Operators Exercises Solution-subtitle-en.vtt 19KB 12 Section 12_ One To Many/206 Left Join-subtitle-en.vtt 19KB 12 Section 12_ One To Many/199 One To Many_ The Basics-subtitle-en.srt 18KB 16 Section 16 - Introducing Node/280 Connecting Node to MySQL-subtitle-en.srt 18KB 10 Revisiting Data Types/165 Formatting Dates-subtitle-en.srt 18KB 02 Getting Started_ Overview and Installation/019 Mac Installation-subtitle-en.srt 18KB 10 Revisiting Data Types/172 Data Types Exercises Solution-subtitle-en.srt 18KB 18 Section 18 - Database Triggers/313 Writing Our First Trigger Part 2-subtitle-en.srt 17KB 09 The Magic of Aggregate Functions/136 The Joys of Group By-subtitle-en.srt 17KB 10 Revisiting Data Types/152 CHAR and VARCHAR-subtitle-en.vtt 17KB 12 Section 12_ One To Many/200 Working With Foreign Keys-subtitle-en.srt 17KB 08 Refining Our Selections/131 Refining Selections Exercises Solution-subtitle-en.srt 16KB 16 Section 16 - Introducing Node/286 Inserting Using Node-subtitle-en.srt 16KB 12 Section 12_ One To Many/197 Real World Data Is Messy-subtitle-en.srt 16KB 12 Section 12_ One To Many/204 Inner Join-subtitle-en.srt 16KB 12 Section 12_ One To Many/199 One To Many_ The Basics-subtitle-en.vtt 16KB 04 Inserting Data (and a couple other things)/058 A Primer On Primary Keys-subtitle-en.srt 16KB 11 The Power of Logical Operators/191 Case Statements-subtitle-en.srt 16KB 07 The World Of String Functions/102 Working with CONCAT-subtitle-en.srt 16KB 16 Section 16 - Introducing Node/280 Connecting Node to MySQL-subtitle-en.vtt 16KB 07 The World Of String Functions/115 String Function Challenges Solution-subtitle-en.srt 16KB 13 Section 13_ Many To Many/233 TV Joins Challenge 6-subtitle-en.srt 16KB 10 Revisiting Data Types/165 Formatting Dates-subtitle-en.vtt 15KB 17 Section 17 - Building Our Web App/302 Connecting Express and MySQL-subtitle-en.srt 15KB 13 Section 13_ Many To Many/220 Many To Many Basics-subtitle-en.srt 15KB 02 Getting Started_ Overview and Installation/019 Mac Installation-subtitle-en.vtt 15KB 11 The Power of Logical Operators/189 In And Not In-subtitle-en.srt 15KB 10 Revisiting Data Types/169 Working with TIMESTAMPS-subtitle-en.srt 15KB 10 Revisiting Data Types/172 Data Types Exercises Solution-subtitle-en.vtt 15KB 16 Section 16 - Introducing Node/292 500 Users Exercises Solutions-subtitle-en.srt 15KB 14 Instagram Database Clone/249 Cloning Instagram's DB_ Hashtags Part 1-subtitle-en.srt 15KB 18 Section 18 - Database Triggers/313 Writing Our First Trigger Part 2-subtitle-en.vtt 15KB 09 The Magic of Aggregate Functions/136 The Joys of Group By-subtitle-en.vtt 15KB 16 Section 16 - Introducing Node/271 MySQL and Other Languages-subtitle-en.srt 15KB 17 Section 17 - Building Our Web App/300 Adding Multiple Routes-subtitle-en.srt 15KB 12 Section 12_ One To Many/200 Working With Foreign Keys-subtitle-en.vtt 15KB 13 Section 13_ Many To Many/221 Creating Our Tables-subtitle-en.srt 14KB 11 The Power of Logical Operators/187 Between-subtitle-en.srt 14KB 12 Section 12_ One To Many/208 Right Joins Pt 1-subtitle-en.srt 14KB 12 Section 12_ One To Many/197 Real World Data Is Messy-subtitle-en.vtt 14KB 11 The Power of Logical Operators/179 Greater Than-subtitle-en.srt 14KB 16 Section 16 - Introducing Node/286 Inserting Using Node-subtitle-en.vtt 14KB 08 Refining Our Selections/131 Refining Selections Exercises Solution-subtitle-en.vtt 14KB 12 Section 12_ One To Many/204 Inner Join-subtitle-en.vtt 14KB 07 The World Of String Functions/098 Running SQL Files-subtitle-en.srt 14KB 18 Section 18 - Database Triggers/315 Creating Logger Triggers-subtitle-en.srt 14KB 11 The Power of Logical Operators/191 Case Statements-subtitle-en.vtt 14KB 04 Inserting Data (and a couple other things)/058 A Primer On Primary Keys-subtitle-en.vtt 14KB 07 The World Of String Functions/104 Introducing SUBSTRING-subtitle-en.srt 14KB 07 The World Of String Functions/102 Working with CONCAT-subtitle-en.vtt 13KB 14 Instagram Database Clone/238 Introduction To Instagram Clone Schema-subtitle-en.srt 13KB 11 The Power of Logical Operators/183 Logical AND-subtitle-en.srt 13KB 17 Section 17 - Building Our Web App/302 Connecting Express and MySQL-subtitle-en.vtt 13KB 13 Section 13_ Many To Many/220 Many To Many Basics-subtitle-en.vtt 13KB 13 Section 13_ Many To Many/233 TV Joins Challenge 6-subtitle-en.vtt 13KB 07 The World Of String Functions/115 String Function Challenges Solution-subtitle-en.vtt 13KB 14 Instagram Database Clone/249 Cloning Instagram's DB_ Hashtags Part 1-subtitle-en.vtt 13KB 11 The Power of Logical Operators/189 In And Not In-subtitle-en.vtt 13KB 08 Refining Our Selections/124 Using LIMIT-subtitle-en.srt 13KB 10 Revisiting Data Types/169 Working with TIMESTAMPS-subtitle-en.vtt 13KB 16 Section 16 - Introducing Node/289 Bulk Inserting 500 Users - Finally!-subtitle-en.srt 13KB 12 Section 12_ One To Many/210 Right Joins Pt 2-subtitle-en.srt 13KB 16 Section 16 - Introducing Node/292 500 Users Exercises Solutions-subtitle-en.vtt 13KB 16 Section 16 - Introducing Node/271 MySQL and Other Languages-subtitle-en.vtt 13KB 16 Section 16 - Introducing Node/273 Introduction to JOIN US app-subtitle-en.srt 13KB 17 Section 17 - Building Our Web App/300 Adding Multiple Routes-subtitle-en.vtt 13KB 16 Section 16 - Introducing Node/277 Introduction to NPM and Faker-subtitle-en.srt 13KB 12 Section 12_ One To Many/217 Our First Joins Exercise SOLUTION PT_ 2-subtitle-en.srt 13KB 15 Working With Lots Of Instagram Data/254 Loading The JUMBO dataset-subtitle-en.srt 12KB 13 Section 13_ Many To Many/221 Creating Our Tables-subtitle-en.vtt 12KB 11 The Power of Logical Operators/187 Between-subtitle-en.vtt 12KB 12 Section 12_ One To Many/208 Right Joins Pt 1-subtitle-en.vtt 12KB 17 Section 17 - Building Our Web App/308 Styling Part 1-subtitle-en.srt 12KB 11 The Power of Logical Operators/179 Greater Than-subtitle-en.vtt 12KB 02 Getting Started_ Overview and Installation/015 Installing MySQL on Cloud9-subtitle-en.srt 12KB 18 Section 18 - Database Triggers/315 Creating Logger Triggers-subtitle-en.vtt 12KB 07 The World Of String Functions/098 Running SQL Files-subtitle-en.vtt 12KB 12 Section 12_ One To Many/215 Our First Joins Exercise SOLUTION-subtitle-en.srt 12KB 17 Section 17 - Building Our Web App/310 Styling Part 2-subtitle-en.srt 12KB 10 Revisiting Data Types/167 Date Math-subtitle-en.srt 12KB 09 The Magic of Aggregate Functions/134 The Count Function-subtitle-en.srt 12KB 14 Instagram Database Clone/238 Introduction To Instagram Clone Schema-subtitle-en.vtt 12KB 18 Section 18 - Database Triggers/314 Preventing Instagram Self-Follows With Triggers-subtitle-en.srt 12KB 16 Section 16 - Introducing Node/272 BUT WHAT ABOUT PHP-subtitle-en.srt 12KB 07 The World Of String Functions/104 Introducing SUBSTRING-subtitle-en.vtt 12KB 11 The Power of Logical Operators/183 Logical AND-subtitle-en.vtt 11KB 06 CRUD Challenge Section/088 CRUD Exercise Overview-subtitle-en.srt 11KB 03 Creating Databases and Tables/030 The Basic Datatypes-subtitle-en.srt 11KB 08 Refining Our Selections/124 Using LIMIT-subtitle-en.vtt 11KB 08 Refining Our Selections/120 Using DISTINCT-subtitle-en.srt 11KB 12 Section 12_ One To Many/210 Right Joins Pt 2-subtitle-en.vtt 11KB 16 Section 16 - Introducing Node/273 Introduction to JOIN US app-subtitle-en.vtt 11KB 16 Section 16 - Introducing Node/289 Bulk Inserting 500 Users - Finally!-subtitle-en.vtt 11KB 15 Working With Lots Of Instagram Data/254 Loading The JUMBO dataset-subtitle-en.vtt 11KB 16 Section 16 - Introducing Node/277 Introduction to NPM and Faker-subtitle-en.vtt 11KB 15 Working With Lots Of Instagram Data/260 Instagram Clone Challenge 3-subtitle-en.srt 11KB 18 Section 18 - Database Triggers/312 Writing Our First Trigger Part 1-subtitle-en.srt 11KB 16 Section 16 - Introducing Node/288 Some MySQL_Node Magic-subtitle-en.srt 11KB 16 Section 16 - Introducing Node/282 Creating Our Users Table-subtitle-en.srt 11KB 12 Section 12_ One To Many/217 Our First Joins Exercise SOLUTION PT_ 2-subtitle-en.vtt 11KB 01 Introduction and 5 Minutes of SQL/004 Your First 5 Minutes of SQL - Let's Get Coding!-subtitle-en.srt 11KB 12 Section 12_ One To Many/202 Cross Join-subtitle-en.srt 10KB 02 Getting Started_ Overview and Installation/008 What Is a Database_-subtitle-en.srt 10KB 17 Section 17 - Building Our Web App/308 Styling Part 1-subtitle-en.vtt 10KB 08 Refining Our Selections/126 Better Searches with LIKE-subtitle-en.srt 10KB 02 Getting Started_ Overview and Installation/015 Installing MySQL on Cloud9-subtitle-en.vtt 10KB 14 Instagram Database Clone/245 Cloning Instagram's DB_ Likes Schema-subtitle-en.srt 10KB 17 Section 17 - Building Our Web App/310 Styling Part 2-subtitle-en.vtt 10KB 09 The Magic of Aggregate Functions/149 Aggregate Functions Challenges Solution-subtitle-en.srt 10KB 09 The Magic of Aggregate Functions/134 The Count Function-subtitle-en.vtt 10KB 12 Section 12_ One To Many/214 Our First Joins Exercise-subtitle-en.srt 10KB 16 Section 16 - Introducing Node/274 Setting Up Cloud9 for Node-subtitle-en.srt 10KB 10 Revisiting Data Types/167 Date Math-subtitle-en.vtt 10KB 18 Section 18 - Database Triggers/314 Preventing Instagram Self-Follows With Triggers-subtitle-en.vtt 10KB 12 Section 12_ One To Many/215 Our First Joins Exercise SOLUTION-subtitle-en.vtt 10KB 15 Working With Lots Of Instagram Data/258 Instagram Clone Challenge 2-subtitle-en.srt 10KB 16 Section 16 - Introducing Node/272 BUT WHAT ABOUT PHP-subtitle-en.vtt 10KB 14 Instagram Database Clone/247 Cloning Instagram's DB_ Followers Schema-subtitle-en.srt 10KB 17 Section 17 - Building Our Web App/297 NPM Init and package_json files-subtitle-en.srt 10KB 10 Revisiting Data Types/157 FLOAT and DOUBLE-subtitle-en.srt 10KB 18 Section 18 - Database Triggers/311 Introduction to Database Triggers-subtitle-en.srt 10KB 11 The Power of Logical Operators/193 Logical Operators Exercises-subtitle-en.srt 10KB 03 Creating Databases and Tables/030 The Basic Datatypes-subtitle-en.vtt 10KB 06 CRUD Challenge Section/088 CRUD Exercise Overview-subtitle-en.vtt 10KB 08 Refining Our Selections/120 Using DISTINCT-subtitle-en.vtt 10KB 17 Section 17 - Building Our Web App/296 Introducing Express-subtitle-en.srt 10KB 15 Working With Lots Of Instagram Data/260 Instagram Clone Challenge 3-subtitle-en.vtt 9KB 18 Section 18 - Database Triggers/316 Managing Triggers And A Warning-subtitle-en.srt 9KB 15 Working With Lots Of Instagram Data/262 Instagram Clone Challenge 4-subtitle-en.srt 9KB 16 Section 16 - Introducing Node/288 Some MySQL_Node Magic-subtitle-en.vtt 9KB 02 Getting Started_ Overview and Installation/008 What Is a Database_-subtitle-en.vtt 9KB 01 Introduction and 5 Minutes of SQL/004 Your First 5 Minutes of SQL - Let's Get Coding!-subtitle-en.vtt 9KB 18 Section 18 - Database Triggers/312 Writing Our First Trigger Part 1-subtitle-en.vtt 9KB 16 Section 16 - Introducing Node/282 Creating Our Users Table-subtitle-en.vtt 9KB 16 Section 16 - Introducing Node/275 5 Minute NodeJS Crash Course-subtitle-en.srt 9KB 09 The Magic of Aggregate Functions/140 SUBQUERIES - A Problem with Min and Max-subtitle-en.srt 9KB 13 Section 13_ Many To Many/235 TV Joins Challenge 7-subtitle-en.srt 9KB 11 The Power of Logical Operators/185 Logical OR-subtitle-en.srt 9KB 08 Refining Our Selections/126 Better Searches with LIKE-subtitle-en.vtt 9KB 12 Section 12_ One To Many/202 Cross Join-subtitle-en.vtt 9KB 08 Refining Our Selections/128 LIKE Part 2_ More Wildcards-subtitle-en.srt 9KB 16 Section 16 - Introducing Node/284 Selecting Using Node-subtitle-en.srt 9KB 13 Section 13_ Many To Many/225 TV Joins Challenge 2-subtitle-en.srt 9KB 14 Instagram Database Clone/245 Cloning Instagram's DB_ Likes Schema-subtitle-en.vtt 9KB 12 Section 12_ One To Many/214 Our First Joins Exercise-subtitle-en.vtt 9KB 09 The Magic of Aggregate Functions/149 Aggregate Functions Challenges Solution-subtitle-en.vtt 9KB 15 Working With Lots Of Instagram Data/258 Instagram Clone Challenge 2-subtitle-en.vtt 9KB 14 Instagram Database Clone/239 Cloning Instagram's DB_ Users Schema-subtitle-en.srt 9KB 16 Section 16 - Introducing Node/274 Setting Up Cloud9 for Node-subtitle-en.vtt 9KB 17 Section 17 - Building Our Web App/297 NPM Init and package_json files-subtitle-en.vtt 9KB 10 Revisiting Data Types/157 FLOAT and DOUBLE-subtitle-en.vtt 9KB 18 Section 18 - Database Triggers/311 Introduction to Database Triggers-subtitle-en.vtt 9KB 14 Instagram Database Clone/243 Cloning Instagram's DB_ Comments Schema-subtitle-en.srt 9KB 09 The Magic of Aggregate Functions/142 Using Min and Max with Group By-subtitle-en.srt 9KB 14 Instagram Database Clone/247 Cloning Instagram's DB_ Followers Schema-subtitle-en.vtt 9KB 11 The Power of Logical Operators/193 Logical Operators Exercises-subtitle-en.vtt 8KB 09 The Magic of Aggregate Functions/146 The Avg Function-subtitle-en.srt 8KB 04 Inserting Data (and a couple other things)/056 Setting Default Values-subtitle-en.srt 8KB 07 The World Of String Functions/106 Introducing REPLACE-subtitle-en.srt 8KB 14 Instagram Database Clone/241 Cloning Instagram's DB_ Photos Schema-subtitle-en.srt 8KB 04 Inserting Data (and a couple other things)/054 NULL and NOT_NULL-subtitle-en.srt 8KB 02 Getting Started_ Overview and Installation/013 Exploring The Cloud9 Interface-subtitle-en.srt 8KB 17 Section 17 - Building Our Web App/296 Introducing Express-subtitle-en.vtt 8KB 02 Getting Started_ Overview and Installation/010 Installation Overview - WATCH BEFORE INSTALLING-subtitle-en.srt 8KB 10 Revisiting Data Types/155 DECIMAL-subtitle-en.srt 8KB 02 Getting Started_ Overview and Installation/009 SQL Vs_ MySQL-subtitle-en.srt 8KB 18 Section 18 - Database Triggers/316 Managing Triggers And A Warning-subtitle-en.vtt 8KB 15 Working With Lots Of Instagram Data/262 Instagram Clone Challenge 4-subtitle-en.vtt 8KB 09 The Magic of Aggregate Functions/140 SUBQUERIES - A Problem with Min and Max-subtitle-en.vtt 8KB 13 Section 13_ Many To Many/235 TV Joins Challenge 7-subtitle-en.vtt 8KB 11 The Power of Logical Operators/185 Logical OR-subtitle-en.vtt 8KB 16 Section 16 - Introducing Node/275 5 Minute NodeJS Crash Course-subtitle-en.vtt 8KB 07 The World Of String Functions/100 Loading Our Book Data-subtitle-en.srt 8KB 13 Section 13_ Many To Many/229 TV Joins Challenge 4-subtitle-en.srt 8KB 08 Refining Our Selections/128 LIKE Part 2_ More Wildcards-subtitle-en.vtt 8KB 16 Section 16 - Introducing Node/279 Introducing the MySQL Package-subtitle-en.srt 8KB 03 Creating Databases and Tables/029 Introduction to Tables-subtitle-en.srt 8KB 13 Section 13_ Many To Many/225 TV Joins Challenge 2-subtitle-en.vtt 8KB 16 Section 16 - Introducing Node/284 Selecting Using Node-subtitle-en.vtt 8KB 10 Revisiting Data Types/163 CURDATE_ CURTIME_ and NOW-subtitle-en.srt 8KB 14 Instagram Database Clone/239 Cloning Instagram's DB_ Users Schema-subtitle-en.vtt 8KB 03 Creating Databases and Tables/023 Creating Databases-subtitle-en.srt 7KB 14 Instagram Database Clone/243 Cloning Instagram's DB_ Comments Schema-subtitle-en.vtt 7KB 09 The Magic of Aggregate Functions/142 Using Min and Max with Group By-subtitle-en.vtt 7KB 01 Introduction and 5 Minutes of SQL/003 Syllabus Walkthrough and Prerequisites-subtitle-en.srt 7KB 07 The World Of String Functions/106 Introducing REPLACE-subtitle-en.vtt 7KB 02 Getting Started_ Overview and Installation/013 Exploring The Cloud9 Interface-subtitle-en.vtt 7KB 09 The Magic of Aggregate Functions/146 The Avg Function-subtitle-en.vtt 7KB 14 Instagram Database Clone/241 Cloning Instagram's DB_ Photos Schema-subtitle-en.vtt 7KB 02 Getting Started_ Overview and Installation/012 Setting Up Cloud9-subtitle-en.srt 7KB 02 Getting Started_ Overview and Installation/010 Installation Overview - WATCH BEFORE INSTALLING-subtitle-en.vtt 7KB 06 CRUD Challenge Section/089 CRUD Exercise Create Solution-subtitle-en.srt 7KB 04 Inserting Data (and a couple other things)/056 Setting Default Values-subtitle-en.vtt 7KB 04 Inserting Data (and a couple other things)/054 NULL and NOT_NULL-subtitle-en.vtt 7KB 08 Refining Our Selections/130 Refining Selections Exercises-subtitle-en.srt 7KB 02 Getting Started_ Overview and Installation/009 SQL Vs_ MySQL-subtitle-en.vtt 7KB 15 Working With Lots Of Instagram Data/268 Instagram Clone Challenge 7-subtitle-en.srt 7KB 05 CRUD commmands/070 Introduction to WHERE-subtitle-en.srt 7KB 10 Revisiting Data Types/155 DECIMAL-subtitle-en.vtt 7KB 04 Inserting Data (and a couple other things)/043 Inserting Data-subtitle-en.srt 7KB 14 Instagram Database Clone/250 Cloning Instagram's DB_ Hashtags Part 2-subtitle-en.srt 7KB 15 Working With Lots Of Instagram Data/256 Instagram Clone Challenge 1-subtitle-en.srt 7KB 07 The World Of String Functions/100 Loading Our Book Data-subtitle-en.vtt 7KB 13 Section 13_ Many To Many/229 TV Joins Challenge 4-subtitle-en.vtt 7KB 05 CRUD commmands/082 Introduction to DELETE-subtitle-en.srt 7KB 12 Section 12_ One To Many/198 Types of Data Relationships-subtitle-en.srt 7KB 10 Revisiting Data Types/163 CURDATE_ CURTIME_ and NOW-subtitle-en.vtt 7KB 03 Creating Databases and Tables/029 Introduction to Tables-subtitle-en.vtt 7KB 13 Section 13_ Many To Many/231 TV Joins Challenge 5-subtitle-en.srt 7KB 16 Section 16 - Introducing Node/279 Introducing the MySQL Package-subtitle-en.vtt 7KB 10 Revisiting Data Types/161 Creating Our DATE data-subtitle-en.srt 7KB 07 The World Of String Functions/114 String Function Challenges-subtitle-en.srt 7KB 13 Section 13_ Many To Many/227 TV Joins Challenge 3-subtitle-en.srt 7KB 15 Working With Lots Of Instagram Data/266 Instagram Clone Challenge 6-subtitle-en.srt 7KB 07 The World Of String Functions/110 Working with CHAR LENGTH-subtitle-en.srt 7KB 01 Introduction and 5 Minutes of SQL/006 How The Course Works-subtitle-en.srt 6KB 03 Creating Databases and Tables/023 Creating Databases-subtitle-en.vtt 6KB 10 Revisiting Data Types/171 Data Types Exercises-subtitle-en.srt 6KB 09 The Magic of Aggregate Functions/133 Section 9 Introduction-subtitle-en.srt 6KB 02 Getting Started_ Overview and Installation/021 Windows Installation-subtitle-en.srt 6KB 01 Introduction and 5 Minutes of SQL/003 Syllabus Walkthrough and Prerequisites-subtitle-en.vtt 6KB 03 Creating Databases and Tables/040 Creating Your Own Tables Challenge-subtitle-en.srt 6KB 02 Getting Started_ Overview and Installation/012 Setting Up Cloud9-subtitle-en.vtt 6KB 13 Section 13_ Many To Many/223 TV Joins Challenge 1-subtitle-en.srt 6KB 06 CRUD Challenge Section/089 CRUD Exercise Create Solution-subtitle-en.vtt 6KB 10 Revisiting Data Types/160 DATE_ TIME_ and DATETIME-subtitle-en.srt 6KB 05 CRUD commmands/070 Introduction to WHERE-subtitle-en.vtt 6KB 08 Refining Our Selections/130 Refining Selections Exercises-subtitle-en.vtt 6KB 15 Working With Lots Of Instagram Data/268 Instagram Clone Challenge 7-subtitle-en.vtt 6KB 04 Inserting Data (and a couple other things)/043 Inserting Data-subtitle-en.vtt 6KB 15 Working With Lots Of Instagram Data/256 Instagram Clone Challenge 1-subtitle-en.vtt 6KB 14 Instagram Database Clone/250 Cloning Instagram's DB_ Hashtags Part 2-subtitle-en.vtt 6KB 12 Section 12_ One To Many/198 Types of Data Relationships-subtitle-en.vtt 6KB 09 The Magic of Aggregate Functions/148 Aggregate Functions Challenges-subtitle-en.srt 6KB 05 CRUD commmands/082 Introduction to DELETE-subtitle-en.vtt 6KB 15 Working With Lots Of Instagram Data/266 Instagram Clone Challenge 6-subtitle-en.vtt 6KB 09 The Magic of Aggregate Functions/144 The Sum Function-subtitle-en.srt 6KB 13 Section 13_ Many To Many/231 TV Joins Challenge 5-subtitle-en.vtt 6KB 11 The Power of Logical Operators/175 Not Equal-subtitle-en.srt 6KB 13 Section 13_ Many To Many/227 TV Joins Challenge 3-subtitle-en.vtt 6KB 01 Introduction and 5 Minutes of SQL/006 How The Course Works-subtitle-en.vtt 6KB 10 Revisiting Data Types/161 Creating Our DATE data-subtitle-en.vtt 6KB 07 The World Of String Functions/114 String Function Challenges-subtitle-en.vtt 6KB 10 Revisiting Data Types/171 Data Types Exercises-subtitle-en.vtt 6KB 07 The World Of String Functions/110 Working with CHAR LENGTH-subtitle-en.vtt 6KB 09 The Magic of Aggregate Functions/133 Section 9 Introduction-subtitle-en.vtt 6KB 02 Getting Started_ Overview and Installation/021 Windows Installation-subtitle-en.vtt 6KB 03 Creating Databases and Tables/040 Creating Your Own Tables Challenge-subtitle-en.vtt 5KB 02 Getting Started_ Overview and Installation/017 Your First MySQL Activity-subtitle-en.srt 5KB 13 Section 13_ Many To Many/223 TV Joins Challenge 1-subtitle-en.vtt 5KB 10 Revisiting Data Types/160 DATE_ TIME_ and DATETIME-subtitle-en.vtt 5KB 05 CRUD commmands/068 Official Introduction to SELECT-subtitle-en.srt 5KB 11 The Power of Logical Operators/181 Less Than-subtitle-en.srt 5KB 05 CRUD commmands/077 The UPDATE Command-subtitle-en.srt 5KB 09 The Magic of Aggregate Functions/138 Min and Max Basics-subtitle-en.srt 5KB 06 CRUD Challenge Section/093 CRUD Exercise Update Solution-subtitle-en.srt 5KB 09 The Magic of Aggregate Functions/148 Aggregate Functions Challenges-subtitle-en.vtt 5KB 11 The Power of Logical Operators/175 Not Equal-subtitle-en.vtt 5KB 04 Inserting Data (and a couple other things)/050 INSERT Challenges Solution-subtitle-en.srt 5KB 09 The Magic of Aggregate Functions/144 The Sum Function-subtitle-en.vtt 5KB 04 Inserting Data (and a couple other things)/052 MySQL Warnings-subtitle-en.srt 5KB 02 Getting Started_ Overview and Installation/017 Your First MySQL Activity-subtitle-en.vtt 5KB 05 CRUD commmands/080 UPDATE Challenges Solution-subtitle-en.srt 5KB 08 Refining Our Selections/118 Seed Data_ Adding A Couple New Books-subtitle-en.srt 5KB 05 CRUD commmands/068 Official Introduction to SELECT-subtitle-en.vtt 5KB 07 The World Of String Functions/112 Changing Case with UPPER and LOWER-subtitle-en.srt 5KB 07 The World Of String Functions/108 Using REVERSE-subtitle-en.srt 5KB 05 CRUD commmands/077 The UPDATE Command-subtitle-en.vtt 5KB 15 Working With Lots Of Instagram Data/264 Instagram Clone Challenge 5-subtitle-en.srt 5KB 04 Inserting Data (and a couple other things)/061 Table Constraints Exercise Solution-subtitle-en.srt 5KB 09 The Magic of Aggregate Functions/138 Min and Max Basics-subtitle-en.vtt 5KB 11 The Power of Logical Operators/181 Less Than-subtitle-en.vtt 4KB 06 CRUD Challenge Section/093 CRUD Exercise Update Solution-subtitle-en.vtt 4KB 04 Inserting Data (and a couple other things)/052 MySQL Warnings-subtitle-en.vtt 4KB 11 The Power of Logical Operators/174 Section 11 Introduction-subtitle-en.srt 4KB 06 CRUD Challenge Section/095 CRUD Exercise Delete Solution-subtitle-en.srt 4KB 04 Inserting Data (and a couple other things)/050 INSERT Challenges Solution-subtitle-en.vtt 4KB 12 Section 12_ One To Many/212 Right and Left Joins_ A Common Question-subtitle-en.srt 4KB 05 CRUD commmands/080 UPDATE Challenges Solution-subtitle-en.vtt 4KB 03 Creating Databases and Tables/034 Creating Your Own Tables-subtitle-en.srt 4KB 04 Inserting Data (and a couple other things)/047 Multiple INSERT-subtitle-en.srt 4KB 08 Refining Our Selections/118 Seed Data_ Adding A Couple New Books-subtitle-en.vtt 4KB 07 The World Of String Functions/108 Using REVERSE-subtitle-en.vtt 4KB 07 The World Of String Functions/112 Changing Case with UPPER and LOWER-subtitle-en.vtt 4KB 05 CRUD commmands/075 Introduction to Aliases-subtitle-en.srt 4KB 16 Section 16 - Introducing Node/291 500 Users Exercises-subtitle-en.srt 4KB 03 Creating Databases and Tables/027 Using Databases-subtitle-en.srt 4KB 15 Working With Lots Of Instagram Data/264 Instagram Clone Challenge 5-subtitle-en.vtt 4KB 04 Inserting Data (and a couple other things)/061 Table Constraints Exercise Solution-subtitle-en.vtt 4KB 02 Getting Started_ Overview and Installation/014 Cloud9 Interface Challenge-subtitle-en.srt 4KB 03 Creating Databases and Tables/036 How Do We Know It Worked_-subtitle-en.srt 4KB 03 Creating Databases and Tables/032 Basic Datatypes Challenge-subtitle-en.srt 4KB 11 The Power of Logical Operators/174 Section 11 Introduction-subtitle-en.vtt 4KB 06 CRUD Challenge Section/095 CRUD Exercise Delete Solution-subtitle-en.vtt 4KB 05 CRUD commmands/073 SELECT Challenges Solution-subtitle-en.srt 4KB 11 The Power of Logical Operators/177 Not Like-subtitle-en.srt 4KB 12 Section 12_ One To Many/212 Right and Left Joins_ A Common Question-subtitle-en.vtt 4KB 03 Creating Databases and Tables/034 Creating Your Own Tables-subtitle-en.vtt 4KB 05 CRUD commmands/066 Preparing Our Data-subtitle-en.srt 4KB 04 Inserting Data (and a couple other things)/047 Multiple INSERT-subtitle-en.vtt 4KB 13 Section 13_ Many To Many/222 CODE_ Creating Our Tables.html 3KB 05 CRUD commmands/075 Introduction to Aliases-subtitle-en.vtt 3KB 16 Section 16 - Introducing Node/291 500 Users Exercises-subtitle-en.vtt 3KB 03 Creating Databases and Tables/027 Using Databases-subtitle-en.vtt 3KB 05 CRUD commmands/085 DELETE Challenges Solution-subtitle-en.srt 3KB 07 The World Of String Functions/097 Section 7 Introduction-subtitle-en.srt 3KB 02 Getting Started_ Overview and Installation/014 Cloud9 Interface Challenge-subtitle-en.vtt 3KB 03 Creating Databases and Tables/036 How Do We Know It Worked_-subtitle-en.vtt 3KB 03 Creating Databases and Tables/032 Basic Datatypes Challenge-subtitle-en.vtt 3KB 04 Inserting Data (and a couple other things)/045 Super Quick Intro To SELECT-subtitle-en.srt 3KB 06 CRUD Challenge Section/087 Section 6 Introduction-subtitle-en.srt 3KB 10 Revisiting Data Types/151 Section 10 Introduction-subtitle-en.srt 3KB 04 Inserting Data (and a couple other things)/060 Table Constraints Exercise-subtitle-en.srt 3KB 05 CRUD commmands/073 SELECT Challenges Solution-subtitle-en.vtt 3KB 17 Section 17 - Building Our Web App/294 Section 17 Introduction-subtitle-en.srt 3KB 11 The Power of Logical Operators/177 Not Like-subtitle-en.vtt 3KB 05 CRUD commmands/066 Preparing Our Data-subtitle-en.vtt 3KB 13 Section 13_ Many To Many/219 Section 13 Introduction-subtitle-en.srt 3KB 12 Section 12_ One To Many/196 Section 12 Introduction-subtitle-en.srt 3KB 05 CRUD commmands/085 DELETE Challenges Solution-subtitle-en.vtt 3KB 07 The World Of String Functions/097 Section 7 Introduction-subtitle-en.vtt 3KB 05 CRUD commmands/072 SELECT Challenges-subtitle-en.srt 3KB 04 Inserting Data (and a couple other things)/045 Super Quick Intro To SELECT-subtitle-en.vtt 3KB 06 CRUD Challenge Section/087 Section 6 Introduction-subtitle-en.vtt 3KB 12 Section 12_ One To Many/218 CODE_ Our First Joins Exercise SOLUTION PT_ 2.html 3KB 10 Revisiting Data Types/151 Section 10 Introduction-subtitle-en.vtt 3KB 17 Section 17 - Building Our Web App/294 Section 17 Introduction-subtitle-en.vtt 3KB 14 Instagram Database Clone/252 CODE_ Complete IG Clone Schema.html 3KB 04 Inserting Data (and a couple other things)/060 Table Constraints Exercise-subtitle-en.vtt 3KB 15 Working With Lots Of Instagram Data/253 Section 15 Introduction-subtitle-en.srt 3KB 07 The World Of String Functions/101 CODE_ Loading Our Book Data.html 3KB 03 Creating Databases and Tables/025 Dropping Databases-subtitle-en.srt 3KB 16 Section 16 - Introducing Node/270 Section 16 Introduction-subtitle-en.srt 3KB 04 Inserting Data (and a couple other things)/042 Section 4 Introduction-subtitle-en.srt 3KB 01 Introduction and 5 Minutes of SQL/002 Instructor Introduction(s)-subtitle-en.srt 3KB 05 CRUD commmands/064 Introduction to CRUD-subtitle-en.srt 3KB 03 Creating Databases and Tables/038 Dropping Tables-subtitle-en.srt 3KB 05 CRUD commmands/063 Section 5 Introduction-subtitle-en.srt 3KB 11 The Power of Logical Operators/195 CODE_ Logical Operators Exercises Solution.html 3KB 12 Section 12_ One To Many/196 Section 12 Introduction-subtitle-en.vtt 3KB 13 Section 13_ Many To Many/219 Section 13 Introduction-subtitle-en.vtt 3KB 04 Inserting Data (and a couple other things)/059 CODE_ A Primer on Primary Keys.html 3KB 16 Section 16 - Introducing Node/281 CODE_ Connecting Node to MySQL.html 3KB 05 CRUD commmands/072 SELECT Challenges-subtitle-en.vtt 3KB 07 The World Of String Functions/116 CODE_ String Function Challenges Solution.html 2KB 01 Introduction and 5 Minutes of SQL/005 CODE_ Your First 5 Minutes of SQL.html 2KB 12 Section 12_ One To Many/209 CODE_ Right Joins Part 1.html 2KB 12 Section 12_ One To Many/211 CODE_ Right Joins Part 2.html 2KB 12 Section 12_ One To Many/201 CODE_ Working With Foreign Keys.html 2KB 02 Getting Started_ Overview and Installation/011 Cloud9 Registration.html 2KB 02 Getting Started_ Overview and Installation/020 CODE_ Mac Installation.html 2KB 17 Section 17 - Building Our Web App/309 JOIN-US-HTML-AND-CSS.zip 2KB 13 Section 13_ Many To Many/234 CODE_ TV Joins Challenge 6 SOLUTION.html 2KB 16 Section 16 - Introducing Node/293 CODE_ 500 Users Exercises Solutions.html 2KB 16 Section 16 - Introducing Node/278 CODE_ Introduction to NPM and Faker.html 2KB 15 Working With Lots Of Instagram Data/253 Section 15 Introduction-subtitle-en.vtt 2KB 16 Section 16 - Introducing Node/270 Section 16 Introduction-subtitle-en.vtt 2KB 10 Revisiting Data Types/173 CODE_ Data Types Exercises Solution.html 2KB 11 The Power of Logical Operators/190 CODE_ In And Not In.html 2KB 01 Introduction and 5 Minutes of SQL/002 Instructor Introduction(s)-subtitle-en.vtt 2KB 04 Inserting Data (and a couple other things)/042 Section 4 Introduction-subtitle-en.vtt 2KB 03 Creating Databases and Tables/025 Dropping Databases-subtitle-en.vtt 2KB 05 CRUD commmands/064 Introduction to CRUD-subtitle-en.vtt 2KB 04 Inserting Data (and a couple other things)/057 CODE_ Setting Default Values.html 2KB 04 Inserting Data (and a couple other things)/049 INSERT Challenges-subtitle-en.srt 2KB 08 Refining Our Selections/122 Sorting Data with ORDER BY-subtitle-en.srt 2KB 05 CRUD commmands/063 Section 5 Introduction-subtitle-en.vtt 2KB 04 Inserting Data (and a couple other things)/055 CODE_ NULL and NOT NULL.html 2KB 01 Introduction and 5 Minutes of SQL/001 Course Introduction-subtitle-en.srt 2KB 12 Section 12_ One To Many/207 CODE_ Left Joins.html 2KB 03 Creating Databases and Tables/038 Dropping Tables-subtitle-en.vtt 2KB 11 The Power of Logical Operators/192 CODE_ Case Statements.html 2KB 08 Refining Our Selections/123 CODE_ Sorting Data with ORDER BY.html 2KB 06 CRUD Challenge Section/091 CRUD Exercise Read Solution-subtitle-en.srt 2KB 12 Section 12_ One To Many/205 CODE_ Inner Joins.html 2KB 14 Instagram Database Clone/237 Section 14 Introduction-subtitle-en.srt 2KB 04 Inserting Data (and a couple other things)/062 CODE_ Table Constraints Exercise Solution.html 2KB 07 The World Of String Functions/103 CODE_ Working With CONCAT.html 2KB 10 Revisiting Data Types/166 CODE_ Formatting Dates.html 2KB 10 Revisiting Data Types/170 CODE_ Working with TIMESTAMPS.html 2KB 08 Refining Our Selections/125 CODE_ Using LIMIT.html 2KB 04 Inserting Data (and a couple other things)/049 INSERT Challenges-subtitle-en.vtt 2KB 16 Section 16 - Introducing Node/285 CODE_ Selecting Using Node.html 2KB 03 Creating Databases and Tables/022 Section 3 Introduction-subtitle-en.srt 2KB 02 Getting Started_ Overview and Installation/007 Section Introduction-subtitle-en.srt 2KB 04 Inserting Data (and a couple other things)/051 CODE_ INSERT Challenges Solution.html 2KB 08 Refining Our Selections/122 Sorting Data with ORDER BY-subtitle-en.vtt 2KB 09 The Magic of Aggregate Functions/150 CODE_ Aggregate Functions Challenges Solution.html 2KB 06 CRUD Challenge Section/090 CODE_ CRUD Exercise Create Solution.html 2KB 05 CRUD commmands/067 CODE_ Preparing Our Data.html 2KB 12 Section 12_ One To Many/216 CODE_ Our First Joins Exercise.html 2KB 11 The Power of Logical Operators/180 CODE_ Greater Than.html 2KB 01 Introduction and 5 Minutes of SQL/001 Course Introduction-subtitle-en.vtt 2KB 08 Refining Our Selections/132 CODE_ Refining Selections Exercises Solution.html 2KB 05 CRUD commmands/084 DELETE Challenges-subtitle-en.srt 2KB 06 CRUD Challenge Section/091 CRUD Exercise Read Solution-subtitle-en.vtt 2KB 09 The Magic of Aggregate Functions/137 CODE_ The Joys of Group By.html 2KB 16 Section 16 - Introducing Node/287 CODE_ Inserting Using Node.html 2KB 07 The World Of String Functions/105 CODE_ Introducing SUBSTRING.html 2KB 07 The World Of String Functions/107 CODE_ Introducing REPLACE.html 2KB 14 Instagram Database Clone/237 Section 14 Introduction-subtitle-en.vtt 2KB 06 CRUD Challenge Section/094 CODE_ CRUD Exercise Update Solution.html 2KB 11 The Power of Logical Operators/184 CODE_ Logical AND.html 2KB 04 Inserting Data (and a couple other things)/053 CODE_ MySQL Warnings.html 2KB 11 The Power of Logical Operators/188 CODE_ Between.html 2KB 03 Creating Databases and Tables/022 Section 3 Introduction-subtitle-en.vtt 2KB 16 Section 16 - Introducing Node/290 CODE_ Bulk Inserting 500 Users.html 2KB 10 Revisiting Data Types/168 CODE_ Date Math.html 2KB 05 CRUD commmands/081 CODE_ UPDATE Challenges Solution.html 2KB 12 Section 12_ One To Many/203 CODE_ Cross Joins.html 2KB 05 CRUD commmands/069 CODE_ Official Introduction to SELECT.html 2KB 02 Getting Started_ Overview and Installation/007 Section Introduction-subtitle-en.vtt 2KB 12 Section 12_ One To Many/213 CODE_ Right and Left Joins FAQ.html 2KB 09 The Magic of Aggregate Functions/141 CODE_ A Problem with Min and Max.html 2KB 11 The Power of Logical Operators/186 CODE_ Logical OR.html 2KB 05 CRUD commmands/084 DELETE Challenges-subtitle-en.vtt 2KB 17 Section 17 - Building Our Web App/301 CODE_ Adding Multiple Routes.html 2KB 09 The Magic of Aggregate Functions/143 CODE_ Using Min and Max with Group By.html 2KB 17 Section 17 - Building Our Web App/305 CODE_ Adding EJS Templates.html 2KB 17 Section 17 - Building Our Web App/299 CODE_ Our First Simple Web App.html 2KB 06 CRUD Challenge Section/096 CODE_ CRUD Exercise Delete Solution.html 2KB 10 Revisiting Data Types/154 CODE_ CHAR and VARCHAR.html 2KB 10 Revisiting Data Types/162 CODE_ Creating Our DATE data.html 2KB 07 The World Of String Functions/099 CODE_ Running SQL Files.html 2KB 13 Section 13_ Many To Many/228 CODE_ TV Joins Challenge 3 SOLUTION.html 2KB 08 Refining Our Selections/129 CODE_ LIKE Part 2_ More Wildcards.html 2KB 14 Instagram Database Clone/251 CODE_ IG Clone Hashtags Schema.html 2KB 03 Creating Databases and Tables/031 Note about INT max size.html 2KB 10 Revisiting Data Types/159 Note about setting the timezone in Cloud9.html 2KB 15 Working With Lots Of Instagram Data/263 Instagram Challenge 4 Solution CODE.html 1KB 05 CRUD commmands/074 CODE_ SELECT Challenges Solution.html 1KB 17 Section 17 - Building Our Web App/303 CODE_ Connecting Express and MySQL.html 1KB 08 Refining Our Selections/119 CODE_ Seed Data_ Adding A Couple New Books.html 1KB 03 Creating Databases and Tables/024 CODE_ Creating Databases.html 1KB 15 Working With Lots Of Instagram Data/255 The Instagram Clone DATASET.html 1KB 09 The Magic of Aggregate Functions/135 CODE_ The Count Function.html 1KB 15 Working With Lots Of Instagram Data/269 Instagram Challenge 7 Solution CODE.html 1KB 11 The Power of Logical Operators/182 CODE_ Less Than.html 1KB 14 Instagram Database Clone/244 CODE_ IG Clone Comments Schema.html 1KB