Section 1 : Introduction and 5 Minutes ofSQL

lecture 1 Course Introduction 1:9
lecture 2 Instructor Introduction(s) 1:26
lecture 3 About Certification Pdf
lecture 4 Note about SQL Editor Text
lecture 5 Your First 5 Minutes of SQL - Let's Get Coding! 6:13
lecture 6 CODE Your First 5 Minutes of SQL Text
lecture 7 How The Course Works 3:45

Section 2 : Getting Started Overview and Installation

lecture 8 Section Introduction 1:3
lecture 9 What Is a Database 7:16
lecture 10 SQL Vs. MySQL 5:51
lecture 11 Installation Overview - WATCH BEFORE INSTALLING 5:10
lecture 12 Cloud9 Registration IMPORTANTPLEASEREAD!!! Zip
lecture 13 Mac Installation 11:27
lecture 14 CODE Mac Installation Text
lecture 15 Windows Installation 2:46

Section 3 : Creating Databases and Tables

lecture 16 Section 3 Introduction 1:10
lecture 17 Creating Databases 5:21
lecture 18 CODE Creating Databases Text
lecture 19 Dropping Databases 5:3
lecture 20 CODE Dropping Databases Text
lecture 21 Using Databases 10:20
lecture 22 CODE Using Databases Text
lecture 23 Introduction to Tables 5:9
lecture 24 The Basic Datatypes 7:52
lecture 25 Note about INT max size Text
lecture 26 Basic Datatypes Challenge 2:36
lecture 27 Basic Data types Challenge Solution Zip
lecture 28 Creating Your Own Tables 3:7
lecture 29 CODE Creating Your Own Tables Text
lecture 30 How Do We Know It Worked 2:33
lecture 31 CODE How Do We Know It Worked Text
lecture 32 Dropping Tables 1:36
lecture 33 CODE Dropping Tables Text
lecture 34 Creating Your Own Tables Challenge 4:30
lecture 35 CODECreating Your Own TablesChallenge Text

Section 4 : Inserting Data (and a couple other things)

lecture 36 Section 4 Introduction 1:40
lecture 37 Inserting Data 5:3
lecture 38 CODE Inserting Data Text
lecture 39 Super Quick Intro To SELECT 2:8
lecture 40 CODE Super Quick Intro To SELECT Text
lecture 41 Multiple INSERT 3:1
lecture 42 CODE Multiple Insert Text
lecture 43 INSERT Challenges 1:36
lecture 44 Note about using quotes inside of inserted values Text
lecture 45 INSERT Challenges Solution 4:44
lecture 46 CODE INSERT Challenges Solution Zip
lecture 47 NOTE MySQL Warnings Text
lecture 48 MySQL Warnings 5:36
lecture 49 CODE MySQL Warnings Text
lecture 50 NULL and NOT_NULL 6:55
lecture 51 CODE NULL and NOT NULL Text
lecture 52 Setting Default Values 7:17
lecture 53 CODE Setting Default Values Text
lecture 54 A Primer On Primary Keys 12:21
lecture 55 CODE A Primer on Primary Keys Zip
lecture 56 Table Constraints Exercise 1:51
lecture 57 Table Constraints Exercise Solution
lecture 58 CODE Table ConstraintsExerciseSolution Text

Section 5 : CRUD commmands

lecture 59 Section 5 Introduction 1:31
lecture 60 Introduction to CRUD 1:45
lecture 61 CODEIntroduction to CRUD Text
lecture 62 Preparing Our Data 2:29
lecture 63 CODE Preparing Our Data Text
lecture 64 Official Introduction to SELECT 4:18
lecture 65 CODE Official Introduction to SELECT Text
lecture 66 introduction to WHERE 5:5
lecture 67 CODE Introduction to WHERE Text
lecture 68 SELECT Challenges 2:1
lecture 69 SELECT Challenges Solution 2:46
lecture 70 CODE SELECT Challenges Solution Zip
lecture 71 Introduction to Aliases 2:55
lecture 72 CODE Introduction to Aliases Text
lecture 73 The UPDATE Command 3:59
lecture 74 CODE The UPDATE Command Text
lecture 75 UPDATE Challenges 0:37
lecture 76 UPDATE Challenges Solution 3:59
lecture 77 CODE UPDATE Challenges Solution Text
lecture 78 Introduction to DELETE
lecture 79 CODE Introduction to DELETE Text
lecture 80 DELETE Challenges 1:11
lecture 81 DELETE Challenges Solution 2:45
lecture 82 CODE DELETE Challenges Solution Zip

Section 6 : CRUD Challenge Section

lecture 83 Section 6 Introduction 1:53
lecture 84 CRUD Exercise Overview 7:27
lecture 85 CRUD Exercise Create Solution 5:55
lecture 86 CODE CRUD Exercise Create Solution Text
lecture 87 CRUD Exercise Read Solution 1:48
lecture 88 CODE CRUD Exercise Read Solution Text
lecture 89 CRUD Exercise Update Solution 4:11
lecture 90 CODE CRUD Exercise Update Solution Text
lecture 91 CRUD Exercise Delete Solution 3:22
lecture 92 CODECRUD Exercise Delete Solution Text

Section 7 : The World Of String Functions

lecture 93 Section 7 Introduction 2:4
lecture 94 Important NoteaboutRunningSQLFiles Text
lecture 95 Running SQL Files 10:16
lecture 96 CODE Running SQL Files Text
lecture 97 Loading Our Book Data 5:25
lecture 98 CODE Loading Our Book Data Text
lecture 99 Working with CONCAT 11:7
lecture 100 CODE Working With CONCAT Text
lecture 101 Introducing SUBSTRING 10:5
lecture 102 CODE Introducing SUBSTRING Text
lecture 103 Introducing REPLACE 6:40
lecture 104 CODE Introducing REPLACE Text
lecture 105 Using REVERSE 3:39
lecture 106 CODE Using REVERSE Text
lecture 107 Working with CHAR LENGTH 4:55
lecture 108 CODE Working with CHARLENGTH Text
lecture 109 Changing Case with UPPER and LOWER 3:20
lecture 110 CODE ChangingCasewithUPPERandLOWER Text
lecture 111 Note about string functions Text
lecture 112 String Function Challenges 4:43
lecture 113 String Function Challenges Solution 13:8
lecture 114 CODE String FunctionChallengesSolution Text

Section 8 : Refining Our Selections

lecture 115 Section 8 Introduction 0:36
lecture 116 Seed Data- Adding A Couple New Books 2:47
lecture 117 CODE Seed Data Adding A CoupleNewBooks Text
lecture 118 Using DISTINCT 8:25
lecture 119 CODE Using DISTINCT Text
lecture 120 Sorting Data with ORDER BY 11:19
lecture 121 CODE Sorting Data with ORDER BY Text
lecture 122 Using LIMIT 9:4
lecture 123 CODE Using LIMIT Text
lecture 124 Better Searches with LIKE 7:43
lecture 125 CODE Better Searches with LIKE Text
lecture 126 LIKE Part 2- More Wildcards 6:10
lecture 127 CODE LIKE Part 2 More Wildcards Text
lecture 128 Refining Selections Exercises 4:52
lecture 129 Refining Selections Exercises Solution 12:30
lecture 130 CODE Refining Selections Exercises Solution Text

Section 9 : The Magic of Aggregate Functions

lecture 131 Section 9 Introduction 3:57
lecture 132 The Count Function 8:39
lecture 133 CODE The Count Function Text
lecture 134 The Joys of Group By 12:23
lecture 135 CODE The Joys of Group By Text
lecture 136 Min and Max Basics 12:23
lecture 137 CODE MIN and MAX Basics Text
lecture 138 SUBQUERIES - A Problem with Min and Max 7:15
lecture 139 CODE A Problem with Min and Max Text
lecture 140 Using Min and Max with Group By 6:40
lecture 141 CODE Using Min and Max with Group By Text
lecture 142 The Sum Function 4:27
lecture 143 CODE The Sum Function Text
lecture 144 The Avg Function 6:0
lecture 145 CODE The Avg Function Text
lecture 146 Aggregate Functions Challenges 4:28
lecture 147 Aggregate Functions Challenges Solution 9:10
lecture 148 CODE Aggregate Functions Challenges Solution Text

Section 10 : Revisiting Data Types

lecture 149 Section 10 Introduction 1:56
lecture 150 CHAR and VARCHAR 14:29
lecture 151 Note about CHAR and VARCHAR Text
lecture 152 CODE CHAR andVARCHAR Text
lecture 153 DECIMAL 6:8
lecture 154 CODE DECIMAL Text
lecture 155 FLOAT and DOUBLE
lecture 156 CODE FLOAT and DOUBLE Text
lecture 157 Note about settingthetimezoneinCloud9 Text
lecture 158 DATE, TIME, and DATETIME 4:31
lecture 159 Creating Our DATE data 5:49
lecture 160 CODE Creating Our DATE data Text
lecture 161 CURDATE, CURTIME, and NOW 5:16
lecture 162 Note about formattingdates Text
lecture 163 Formatting Dates 14:29
lecture 164 CODE Formatting Dates Text
lecture 165 Date Math 9:40
lecture 166 CODE Date Math Text
lecture 167 Working with TIMESTAMPS 10:54
lecture 168 CODE Working with TIMESTAMPS Text
lecture 169 Data Types Exercises 4:50
lecture 170 Data Types Exercises Solution 13:58
lecture 171 CODE Data Types Exercises Solution Text

Section 11 : The Power of Logical Operators

lecture 172 Section 11 Introduction 2:45
lecture 173 Not Equal 4:27
lecture 174 CODE Not Equal Text
lecture 175 Not Like 2:34
lecture 176 CODE Not Like Text
lecture 177 Greater Than 10:4
lecture 178 CODE Greater Than Text
lecture 179 Less Than 3:49
lecture 180 CODE Less Than Text
lecture 181 Logical AND 9:47
lecture 182 CODE Logical AND Text
lecture 183 Logical OR 6:41
lecture 184 CODE Logical OR Text
lecture 185 Between 10:58
lecture 186 CODE Between Text
lecture 187 In And Not In 11:47
lecture 188 CODE In And Not In Text
lecture 189 Case Statements 11:21
lecture 190 CODE Case Statements Text
lecture 191 Logical Operators Exercises 6:45
lecture 192 Logical Operators Exercises Solution 17:47
lecture 193 CODE Logical Operators ExercisesSolution Text

Section 12 : Section 12 One To Many

lecture 194 Section 12 Introduction 1:58
lecture 195 Real World Data Is Messy 10:28
lecture 196 Types of Data Relationships 4:37
lecture 197 One To Many- The Basics
lecture 198 Working With Foreign Keys 12:5
lecture 199 CODE Working With Foreign Keys Text
lecture 200 Cross Join 7:36
lecture 201 CODE Cross Joins Text
lecture 202 Inner Join 12:45
lecture 203 CODE Inner Joins Text
lecture 204 Left Join 15:18
lecture 205 CODE Left Joins Text
lecture 206 Right Joins Pt 1 10:37
lecture 207 CODE Right Joins Part 1 Text
lecture 208 Right Joins Pt 2 9:52
lecture 209 CODE Right Joins Part 2 Text
lecture 210 Right and Left Joins- A Common Question 3:9
lecture 211 CODE Right and Left Joins FAQ Text
lecture 212 Our First Joins Exercise 6:59
lecture 213 Our First Joins Exercise SOLUTION 9:10
lecture 214 CODE Our First Joins Exercise Text
lecture 215 Our First Joins Exercise SOLUTION PT. 2 9:21
lecture 216 CODE Our FirstJoinsExerciseSOLUTIONPT. 2 Text

Section 13 : Section 13 Many To Many

lecture 217 Section 13 Introduction 1:54
lecture 218 Many To Many Basics 10:48
lecture 219 Creating Our Tables 10:58
lecture 220 CODE Creating Our Tables Text
lecture 221 TV Joins Challenge 1 4:49
lecture 222 CODE TV Joins Challenge 1 Solution Text
lecture 223 TV Joins Challenge 2 6:23
lecture 224 CODE TV Joins Challenge 2 SOLUTION Text
lecture 225 TV Joins Challenge 3 5:0
lecture 226 CODE TV Joins Challenge 3 SOLUTION Text
lecture 227 TV Joins Challenge 4 5:59
lecture 228 CODE TV Joins Challenge 4 SOLUTION Text
lecture 229 TV Joins Challenge 5 4:56
lecture 230 CODE TV Joins Challenge 5 SOLUTION Text
lecture 231 TV Joins Challenge 6 11:58
lecture 232 CODE TV Joins Challenge 6 SOLUTION Text
lecture 233 TV Joins Challenge 7 7:9
lecture 234 CODE TV Joins Challenge 7 SOLUTION Text

Section 14 : Instagram Database Clone

lecture 235 Section 14 Introduction 1:20
lecture 236 Introduction To Instagram Clone Schema 8:32
lecture 237 Cloning Instagram's DB- Users Schema 6:8
lecture 238 CODE IG Clone Users Schema Text
lecture 239 Cloning Instagram's DB- Photos Schema 6:37
lecture 240 CODE IG Clone Photos Schema Text
lecture 241 Cloning Instagram's DB- Comments Schema 6:39
lecture 242 CODE IG Clone Comments Schema Text
lecture 243 Cloning Instagram's DB- Likes Schema
lecture 244 CODE IG Clone Likes Schema Text
lecture 245 Cloning Instagram's DB- Followers Schema 7:20
lecture 246 CODE IG Clone Followers Schema Text
lecture 247 Note about Cloning Instagram's DB Hashtags Part1 Text
lecture 248 Cloning Instagram's DB- Hashtags Part 1 10:35
lecture 249 Cloning Instagram's DB- Hashtags Part 2 5:26
lecture 250 CODE IG Clone Hashtags Schema Text
lecture 251 CODE Complete IG Clone Schema Text

Section 15 : Working With Lots Of InstagramData

lecture 252 Section 15 Introduction 1:42
lecture 253 Note about Loading The JUMBOdataset Text
lecture 254 Loading The JUMBO dataset 8:31
lecture 255 The Instagram Clone DATASET Zip
lecture 256 Instagram Clone Challenge 1 4:53
lecture 257 Instagram Challenge1SolutionCODE Text
lecture 258 Instagram Clone Challenge 2 6:42
lecture 259 Instagram Challenge2SolutionCODE Text
lecture 260 Instagram Clone Challenge 3 7:22
lecture 261 Instagram Challenge3SolutionCODE Text
lecture 262 Instagram Clone Challenge 4 7:6
lecture 263 Instagram Challenge4SolutionCODE Text
lecture 264 Instagram Clone Challenge 5 3:13
lecture 265 Instagram Challenge5SolutionCODE Text
lecture 266 Instagram Clone Challenge 6 5:30
lecture 267 Instagram Challenge6SolutionCODE Text
lecture 268 Note about Instagram Clone Challenge 7 Text
lecture 269 Instagram Clone Challenge 7 5:15
lecture 270 Instagram Challenge7SolutionCODE Text

Section 16 : Section 16 Introducing Node

lecture 171 Note about Introducing Node Text
lecture 272 Section 16 Introduction 1:37
lecture 273 MySQL and Other Languages 9:0
lecture 274 BUT WHAT ABOUT PHP 7:34
lecture 275 Introduction to JOIN US app 7:34
lecture 276 Note about Setting Up Cloud9 for Node Zip
lecture 277 5 Minute NodeJS Crash Course 6:13
lecture 279 Note about Faker install Text
lecture 280 Introduction to NPM and Faker 3:22
lecture 281 CODE Introduction to NPMandFaker Text
lecture 282 Introducing the MySQL Package 4:53
lecture 283 Note about connecting Node to MySQL Text
lecture 284 Connecting Node to MySQL 7:41
lecture 285 CODE Connecting Node to MySQL Text
lecture 286 Creating Our Users Table 6:55
lecture 287 CODE Creating Our Users Table Text
lecture 288 Selecting Using Node 6:16
lecture 289 CODE Selecting Using Node Text
lecture 290 Inserting Using Node 11:32
lecture 291 CODE Inserting Using Node Text
lecture 292 Some MySQL-Node Magic 7:41
lecture 293 Bulk Inserting 500 Users - Finally 8:40
lecture 294 CODE Bulk Inserting 500 Users Text
lecture 295 500 Users Exercises 2:30
lecture 296 500 Users Exercises Solutions 6:39
lecture 297 CODE 500 Users Exercises Solutions Text

Section 17 : Section 17 Building Our WebApp

lecture 298 Section 17 Introduction 1:53
lecture 299 Join Us Completed CODE Zip
lecture 300 Introducing Express 5:41
lecture 301 NPM Init and package.json files 6:39
lecture 302 Note about Our First Simple Web App Text
lecture 303 Our First Simple Web App 16:34
lecture 304 CODE Our First Simple Web App Text
lecture 305 Adding Multiple Routes 9:57
lecture 306 CODE Adding Multiple Routes Text
lecture 307 Connecting Express and MySQL 11:9
lecture 308 CODE Connecting Express and MySQL Text
lecture 309 Adding EJS Templates 16:3
lecture 310 CODE Adding EJS Templates Text
lecture 311 Connecting The Form 18:33
lecture 312 CODEConnecting the Form Text
lecture 313 Styling Part 1 8:24
lecture 314 CODE HTML AND CSS FILES Zip
lecture 315 Styling Part 2 8:17

Section 18 : Section 18 Database Triggers

lecture 316 Introduction to Database Triggers 6:11
lecture 317 Writing Our First Trigger Part 1 7:28
lecture 318 Writing Our First Trigger Part 2 11:36
lecture 319 Remove - INTRODUCTION TO BRAINMEASURES PROCTOR SYS Pdf
lecture 320 Preventing Instagram Self-Follows With Triggers 8:17
lecture 321 Creating Logger Triggers 10:18
lecture 322 Managing Triggers And A Warning 6:12