01 Introduction and 5 Minutes of SQL/external_links.txt 93 B 02 Getting Started_ Overview and Installation/016 CODE_ Installing MySQL on Cloud9.html 1.2 KB 02 Getting Started_ Overview and Installation/018 CODE_ Your First MySQL Activity.html 1.2 KB 02 Getting Started_ Overview and Installation/external_links.txt 390 B 03 Creating Databases and Tables/024 CODE_ Creating Databases.html 1.5 KB 03 Creating Databases and Tables/026 CODE_ Dropping Databases.html 1.4 KB 03 Creating Databases and Tables/028 CODE_ Using Databases.html 1.2 KB 03 Creating Databases and Tables/031 Note about INT max size.html 1.5 KB 03 Creating Databases and Tables/033 Basic Datatypes Challenge - Solution.html 1.3 KB 03 Creating Databases and Tables/035 CODE_ Creating Your Own Tables.html 1.3 KB 03 Creating Databases and Tables/037 CODE_ How Do We Know It Worked_.html 1.2 KB 03 Creating Databases and Tables/039 CODE_ Dropping Tables.html 1.3 KB 03 Creating Databases and Tables/041 CODE_ Creating Your Own Tables Challenge.html 1.3 KB 03 Creating Databases and Tables/external_links.txt 173 B 04 Inserting Data (and a couple other things)/044 CODE_ Inserting Data.html 1.4 KB 04 Inserting Data (and a couple other things)/046 CODE_ Super Quick Intro To SELECT.html 1.2 KB 04 Inserting Data (and a couple other things)/048 CODE_ Multiple Insert.html 1.3 KB 04 Inserting Data (and a couple other things)/external_links.txt 168 B 05 CRUD commmands/065 CODE_ Introduction to CRUD.html 1.2 KB 05 CRUD commmands/071 CODE_ Introduction to WHERE.html 1.4 KB 05 CRUD commmands/074 CODE_ SELECT Challenges Solution.html 1.5 KB 05 CRUD commmands/076 CODE_ Introduction to Aliases.html 1.3 KB 05 CRUD commmands/078 CODE_ The UPDATE Command.html 1.4 KB 05 CRUD commmands/079 UPDATE Challenges-subtitle-en.srt 875 B 05 CRUD commmands/079 UPDATE Challenges-subtitle-en.vtt 745 B 05 CRUD commmands/083 CODE_ Introduction to DELETE.html 1.4 KB 05 CRUD commmands/086 CODE_ DELETE Challenges Solution.html 1.4 KB 05 CRUD commmands/external_links.txt 171 B 06 CRUD Challenge Section/092 CODE_ CRUD Exercise Read Solution.html 1.3 KB 06 CRUD Challenge Section/096 CODE_ CRUD Exercise Delete Solution.html 1.5 KB 06 CRUD Challenge Section/external_links.txt 87 B 07 The World Of String Functions/099 CODE_ Running SQL Files.html 1.5 KB 07 The World Of String Functions/100 book-data.sql 1.3 KB 07 The World Of String Functions/109 CODE_ Using REVERSE.html 1.4 KB 07 The World Of String Functions/111 CODE_ Working with CHAR LENGTH.html 1.4 KB 07 The World Of String Functions/113 CODE_ Changing Case with UPPER and LOWER.html 1.4 KB 07 The World Of String Functions/external_links.txt 174 B 08 Refining Our Selections/117 Section 8 Introduction-subtitle-en.srt 1.1 KB 08 Refining Our Selections/117 Section 8 Introduction-subtitle-en.vtt 937 B 08 Refining Our Selections/119 CODE_ Seed Data_ Adding A Couple New Books.html 1.5 KB 08 Refining Our Selections/121 CODE_ Using DISTINCT.html 1.4 KB 08 Refining Our Selections/127 CODE_ Better Searches with LIKE.html 1.5 KB 08 Refining Our Selections/129 CODE_ LIKE Part 2_ More Wildcards.html 1.5 KB 08 Refining Our Selections/external_links.txt 176 B 09 The Magic of Aggregate Functions/135 CODE_ The Count Function.html 1.5 KB 09 The Magic of Aggregate Functions/139 CODE_ MIN and MAX Basics.html 1.4 KB 09 The Magic of Aggregate Functions/143 CODE_ Using Min and Max with Group By.html 1.6 KB 09 The Magic of Aggregate Functions/145 CODE_ The Sum Function.html 1.5 KB 09 The Magic of Aggregate Functions/147 CODE_ The Avg Function.html 1.5 KB 09 The Magic of Aggregate Functions/external_links.txt 177 B 10 Revisiting Data Types/153 Note about CHAR and VARCHAR.html 1.4 KB 10 Revisiting Data Types/154 CODE_ CHAR and VARCHAR.html 1.5 KB 10 Revisiting Data Types/156 CODE_ DECIMAL.html 1.4 KB 10 Revisiting Data Types/158 CODE_ FLOAT and DOUBLE.html 1.4 KB 10 Revisiting Data Types/159 Note about setting the timezone in Cloud9.html 1.5 KB 10 Revisiting Data Types/162 CODE_ Creating Our DATE data.html 1.5 KB 10 Revisiting Data Types/164 Note about formatting dates.html 1.4 KB 10 Revisiting Data Types/external_links.txt 174 B 11 The Power of Logical Operators/176 CODE_ Not Equal.html 1.4 KB 11 The Power of Logical Operators/178 CODE_ Not Like.html 1.4 KB 11 The Power of Logical Operators/182 CODE_ Less Than.html 1.5 KB 11 The Power of Logical Operators/external_links.txt 174 B 12 Section 12_ One To Many/external_links.txt 159 B 13 Section 13_ Many To Many/224 CODE_ TV Joins Challenge 1 Solution.html 1.3 KB 13 Section 13_ Many To Many/226 CODE_ TV Joins Challenge 2 SOLUTION.html 1.4 KB 13 Section 13_ Many To Many/228 CODE_ TV Joins Challenge 3 SOLUTION.html 1.5 KB 13 Section 13_ Many To Many/230 CODE_ TV Joins Challenge 4 SOLUTION.html 1.4 KB 13 Section 13_ Many To Many/232 CODE_ TV Joins Challenge 5 SOLUTION.html 1.4 KB 13 Section 13_ Many To Many/236 CODE_ TV Joins Challenge 7 SOLUTION.html 1.4 KB 13 Section 13_ Many To Many/external_links.txt 72 B 14 Instagram Database Clone/240 CODE_ IG Clone Users Schema.html 1.3 KB 14 Instagram Database Clone/242 CODE_ IG Clone Photos Schema.html 1.4 KB 14 Instagram Database Clone/244 CODE_ IG Clone Comments Schema.html 1.5 KB 14 Instagram Database Clone/246 CODE_ IG Clone Likes Schema.html 1.4 KB 14 Instagram Database Clone/248 CODE_ IG Clone Followers Schema.html 1.4 KB 14 Instagram Database Clone/251 CODE_ IG Clone Hashtags Schema.html 1.5 KB 14 Instagram Database Clone/external_links.txt 84 B 15 Working With Lots Of Instagram Data/255 The Instagram Clone DATASET.html 1.5 KB 15 Working With Lots Of Instagram Data/257 Instagram Challenge 1 Solution CODE.html 1.3 KB 15 Working With Lots Of Instagram Data/259 Instagram Challenge 2 Solution CODE.html 1.3 KB 15 Working With Lots Of Instagram Data/261 Instagram Challenge 3 Solution CODE.html 1.3 KB 15 Working With Lots Of Instagram Data/263 Instagram Challenge 4 Solution CODE.html 1.5 KB 15 Working With Lots Of Instagram Data/265 Instagram Challenge 5 Solution CODE.html 1.4 KB 15 Working With Lots Of Instagram Data/267 Instagram Challenge 6 Solution CODE.html 1.4 KB 15 Working With Lots Of Instagram Data/269 Instagram Challenge 7 Solution CODE.html 1.5 KB 15 Working With Lots Of Instagram Data/external_links.txt 69 B 16 Section 16 - Introducing Node/276 CODE_ 5 Minute Node Crash Course.html 1.4 KB 16 Section 16 - Introducing Node/283 CODE_ Creating Our Users Table.html 1.3 KB 16 Section 16 - Introducing Node/external_links.txt 296 B 17 Section 17 - Building Our Web App/295 Join Us Completed CODE.html 1.4 KB 17 Section 17 - Building Our Web App/299 CODE_ Our First Simple Web App.html 1.5 KB 17 Section 17 - Building Our Web App/301 CODE_ Adding Multiple Routes.html 1.6 KB 17 Section 17 - Building Our Web App/303 CODE_ Connecting Express and MySQL.html 1.5 KB 17 Section 17 - Building Our Web App/305 CODE_ Adding EJS Templates.html 1.5 KB 17 Section 17 - Building Our Web App/307 CODE_ Connecting the Form.html 1.5 KB 17 Section 17 - Building Our Web App/309 CODE_ HTML AND CSS FILES.html 1.2 KB 17 Section 17 - Building Our Web App/external_links.txt 57 B 18 Section 18 - Database Triggers/external_links.txt 92 B