The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert | FEAA4F22357397E9D53315576B75778AE6B63945

The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert

Name	The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert/	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	3.3 GB
Total Files	316
Hash	FEAA4F22357397E9D53315576B75778AE6B63945

/16 Section 16 - Introducing Node/
278 CODE Connecting Node to MySQL.html	1.9 KB
288 500 Users Exercises.mp4	4.8 MB
273 CODE 5 Minute Node Crash Course.html	0.6 KB
274 Introduction to NPM and Faker.mp4	21.4 MB
280 CODE Creating Our Users Table.html	0.5 KB
282 CODE Selecting Using Node.html	0.9 KB
270 Introduction to JOIN US app.mp4	16.0 MB
275 CODE Introduction to NPM and Faker.html	1.7 KB
271 Setting Up Cloud9 for Node.mp4	14.2 MB
281 Selecting Using Node.mp4	15.0 MB
267 Section 16 Introduction.mp4	13.9 MB
276 Introducing the MySQL Package.mp4	9.3 MB
279 Creating Our Users Table.mp4	20.7 MB
269 BUT WHAT ABOUT PHP.mp4	21.4 MB
287 CODE Bulk Inserting 500 Users.html	0.9 KB
277 Connecting Node to MySQL.mp4	30.2 MB
286 Bulk Inserting 500 Users - Finally.mp4	29.8 MB
268 MySQL and Other Languages.mp4	15.4 MB
289 500 Users Exercises Solutions.mp4	28.9 MB
285 Some MySQLNode Magic.mp4	23.7 MB
283 Inserting Using Node.mp4	28.9 MB
284 CODE Inserting Using Node.html	1.1 KB
272 5 Minute NodeJS Crash Course.mp4	12.5 MB
290 CODE 500 Users Exercises Solutions.html	1.7 KB
/08 Refining Our Selections/
131 CODE Refining Selections Exercises Solution.html	1.1 KB
118 CODE Seed Data Adding A Couple New Books.html	0.7 KB
124 CODE Using LIMIT.html	1.2 KB
128 CODE LIKE Part 2 More Wildcards.html	0.7 KB
125 Better Searches with LIKE.mp4	14.4 MB
130 Refining Selections Exercises Solution.mp4	34.6 MB
122 CODE Sorting Data with ORDER BY.html	1.4 KB
123 Using LIMIT.mp4	23.2 MB
120 CODE Using DISTINCT.html	0.6 KB
121 Sorting Data with ORDER BY.mp4	28.3 MB
116 Section 8 Introduction.mp4	5.0 MB
129 Refining Selections Exercises.mp4	10.7 MB
117 Seed Data Adding A Couple New Books.mp4	5.4 MB
119 Using DISTINCT.mp4	18.0 MB
126 CODE Better Searches with LIKE.html	0.7 KB
127 LIKE Part 2 More Wildcards.mp4	13.6 MB
/06 CRUD Challenge Section/
092 CRUD Exercise Update Solution.mp4	8.5 MB
089 CODE CRUD Exercise Create Solution.html	1.2 KB
086 Section 6 Introduction.mp4	15.8 MB
095 CODE CRUD Exercise Delete Solution.html	0.7 KB
090 CRUD Exercise Read Solution.mp4	4.0 MB
094 CRUD Exercise Delete Solution.mp4	6.7 MB
093 CODE CRUD Exercise Update Solution.html	1.0 KB
088 CRUD Exercise Create Solution.mp4	12.2 MB
091 CODE CRUD Exercise Read Solution.html	0.5 KB
087 CRUD Exercise Overview.mp4	14.6 MB
/12 Section 12 One To Many/
210 CODE Right and Left Joins FAQ.html	0.9 KB
214 Our First Joins Exercise SOLUTION PT. 2.mp4	22.7 MB
194 Real World Data Is Messy.mp4	19.1 MB
197 Working With Foreign Keys.mp4	30.3 MB
193 Section 12 Introduction.mp4	14.1 MB
205 Right Joins Pt 1.mp4	26.9 MB
213 CODE Our First Joins Exercise.html	1.2 KB
199 Cross Join.mp4	18.6 MB
200 CODE Cross Joins.html	0.9 KB
206 CODE Right Joins Part 1.html	1.7 KB
215 CODE Our First Joins Exercise SOLUTION PT. 2.html	2.1 KB
207 Right Joins Pt 2.mp4	29.6 MB
196 One To Many The Basics.mp4	25.7 MB
209 Right and Left Joins A Common Question.mp4	10.5 MB
208 CODE Right Joins Part 2.html	1.7 KB
202 CODE Inner Joins.html	1.4 KB
203 Left Join.mp4	37.4 MB
201 Inner Join.mp4	35.6 MB
211 Our First Joins Exercise.mp4	15.6 MB
204 CODE Left Joins.html	1.5 KB
212 Our First Joins Exercise SOLUTION.mp4	24.6 MB
198 CODE Working With Foreign Keys.html	1.7 KB
195 Types of Data Relationships.mp4	8.5 MB
/02 Getting Started Overview and Installation/
011 Setting Up Cloud9.mp4	12.2 MB
008 What Is a Database.mp4	14.5 MB
017 Your First MySQL Activity.mp4	9.4 MB
020 CODE Mac Installation.html	1.8 KB
009 SQL Vs. MySQL.mp4	11.0 MB
016 CODE Installing MySQL on Cloud9.html	0.4 KB
018 CODE Your First MySQL Activity.html	0.4 KB
019 Mac Installation.mp4	31.0 MB
010 Installation Overview - WATCH BEFORE INSTALLING.mp4	9.4 MB
007 Section Introduction.mp4	10.9 MB
021 Windows Installation.mp4	8.4 MB
014 Cloud9 Interface Challenge.mp4	6.4 MB
013 Exploring The Cloud9 Interface.mp4	13.0 MB
012 Cloud9 What If I Dont Have a Credit Card.html	1.7 KB
015 Installing MySQL on Cloud9.mp4	19.4 MB
/10 Revisiting Data Types/
170 CODE Data Types Exercises Solution.html	1.6 KB
151 CHAR and VARCHAR.mp4	29.0 MB
164 Date Math.mp4	26.5 MB
158 DATE TIME and DATETIME.mp4	7.7 MB
167 CODE Working with TIMESTAMPS.html	1.3 KB
153 CODE CHAR and VARCHAR.html	0.7 KB
152 Note about CHAR and VARCHAR.html	0.6 KB
163 CODE Formatting Dates.html	1.3 KB
156 FLOAT and DOUBLE.mp4	15.9 MB
155 CODE DECIMAL.html	0.6 KB
166 Working with TIMESTAMPS.mp4	25.7 MB
165 CODE Date Math.html	0.9 KB
150 Section 10 Introduction.mp4	11.8 MB
159 Creating Our DATE data.mp4	11.5 MB
162 Formatting Dates.mp4	46.7 MB
157 CODE FLOAT and DOUBLE.html	0.6 KB
161 CURDATE CURTIME and NOW.mp4	11.2 MB
160 CODE Creating Our DATE data.html	0.7 KB
169 Data Types Exercises Solution.mp4	37.7 MB
168 Data Types Exercises.mp4	10.2 MB
154 DECIMAL.mp4	16.2 MB
/11 The Power of Logical Operators/
179 CODE Less Than.html	0.7 KB
183 CODE Logical OR.html	0.8 KB
191 Logical Operators Exercises Solution.mp4	46.4 MB
184 Between.mp4	25.5 MB
171 Section 11 Introduction.mp4	16.7 MB
175 CODE Not Like.html	0.6 KB
174 Not Like.mp4	5.4 MB
186 In And Not In.mp4	32.6 MB
190 Logical Operators Exercises.mp4	15.3 MB
172 Not Equal.mp4	11.2 MB
182 Logical OR.mp4	15.0 MB
173 CODE Not Equal.html	0.6 KB
178 Less Than.mp4	8.5 MB
189 CODE Case Statements.html	1.4 KB
177 CODE Greater Than.html	1.2 KB
192 CODE Logical Operators Exercises Solution.html	1.8 KB
176 Greater Than.mp4	23.3 MB
188 Case Statements.mp4	30.6 MB
185 CODE Between.html	0.9 KB
187 CODE In And Not In.html	1.5 KB
181 CODE Logical AND.html	1.0 KB
180 Logical AND.mp4	21.8 MB
/09 The Magic of Aggregate Functions/
146 CODE The Avg Function.html	0.7 KB
135 The Joys of Group By.mp4	25.4 MB
144 CODE The Sum Function.html	0.7 KB
148 Aggregate Functions Challenges Solution.mp4	20.0 MB
136 CODE The Joys of Group By.html	1.1 KB
142 CODE Using Min and Max with Group By.html	0.8 KB
134 CODE The Count Function.html	0.7 KB
149 CODE Aggregate Functions Challenges Solution.html	1.2 KB
143 The Sum Function.mp4	8.7 MB
137 Min and Max Basics.mp4	8.9 MB
139 SUBQUERIES - A Problem with Min and Max.mp4	14.5 MB
145 The Avg Function.mp4	11.6 MB
133 The Count Function.mp4	17.7 MB
132 Section 9 Introduction.mp4	19.9 MB
141 Using Min and Max with Group By.mp4	14.1 MB
138 CODE MIN and MAX Basics.html	0.6 KB
147 Aggregate Functions Challenges.mp4	8.0 MB
140 CODE A Problem with Min and Max.html	0.8 KB
/17 Section 17 - Building Our Web App/
297 Adding Multiple Routes.mp4	23.8 MB
298 CODE Adding Multiple Routes.html	0.8 KB
291 Section 17 Introduction.mp4	12.5 MB
293 Introducing Express.mp4	13.4 MB
307 Styling Part 2.mp4	23.7 MB
292 Join Us Completed CODE.html	0.6 KB
302 CODE Adding EJS Templates.html	0.8 KB
301 Adding EJS Templates.mp4	39.9 MB
300 CODE Connecting Express and MySQL.html	0.7 KB
294 NPM Init and package.json files.mp4	15.6 MB
296 CODE Our First Simple Web App.html	0.8 KB
299 Connecting Express and MySQL.mp4	27.2 MB
303 Connecting The Form.mp4	47.7 MB
306 CODE HTML AND CSS FILES.html	0.4 KB
304 CODE Connecting the Form.html	0.7 KB
305 Styling Part 1.mp4	23.0 MB
295 Our First Simple Web App.mp4	37.1 MB
/.../306 CODE HTML AND CSS FILES/
JOIN-US-HTML-AND-CSS.zip	2.4 KB
/.../292 Join Us Completed CODE/
JoinUsCompleteCode.zip	3.9 MB
/05 CRUD commmands/
065 Preparing Our Data.mp4	4.9 MB
069 Introduction to WHERE.mp4	9.4 MB
077 CODE The UPDATE Command.html	0.6 KB
081 Introduction to DELETE.mp4	8.4 MB
063 Introduction to CRUD.mp4	3.1 MB
085 CODE DELETE Challenges Solution.html	0.7 KB
072 SELECT Challenges Solution.mp4	5.5 MB
076 The UPDATE Command.mp4	7.5 MB
084 DELETE Challenges Solution.mp4	5.7 MB
074 Introduction to Aliases.mp4	5.3 MB
083 DELETE Challenges.mp4	2.3 MB
082 CODE Introduction to DELETE.html	0.6 KB
067 Official Introduction to SELECT.mp4	8.3 MB
073 CODE SELECT Challenges Solution.html	0.8 KB
079 UPDATE Challenges Solution.mp4	7.5 MB
062 Section 5 Introduction.mp4	13.5 MB
080 CODE UPDATE Challenges Solution.html	0.9 KB
071 SELECT Challenges.mp4	4.5 MB
068 CODE Official Introduction to SELECT.html	1.0 KB
075 CODE Introduction to Aliases.html	0.5 KB
066 CODE Preparing Our Data.html	1.2 KB
070 CODE Introduction to WHERE.html	0.6 KB
064 CODE Introduction to CRUD.html	0.4 KB
078 UPDATE Challenges.mp4	1.2 MB
/04 Inserting Data and a couple other things/
060 Table Constraints Exercise Solution.mp4	12.9 MB
052 CODE MySQL Warnings.html	1.0 KB
056 CODE Setting Default Values.html	1.7 KB
061 CODE Table Constraints Exercise Solution.html	1.3 KB
042 Inserting Data.mp4	9.4 MB
053 NULL and NOT_NULL.mp4	14.4 MB
041 Section 4 Introduction.mp4	11.4 MB
048 INSERT Challenges.mp4	3.2 MB
055 Setting Default Values.mp4	14.7 MB
057 A Primer On Primary Keys.mp4	25.8 MB
049 INSERT Challenges Solution.mp4	10.0 MB
050 CODE INSERT Challenges Solution.html	1.3 KB
059 Table Constraints Exercise.mp4	3.5 MB
043 CODE Inserting Data.html	0.6 KB
045 CODE Super Quick Intro To SELECT.html	0.4 KB
051 MySQL Warnings.mp4	12.3 MB
047 CODE Multiple Insert.html	0.5 KB
044 Super Quick Intro To SELECT.mp4	4.2 MB
058 CODE A Primer on Primary Keys.html	2.0 KB
046 Multiple INSERT.mp4	5.6 MB
054 CODE NULL and NOT NULL.html	1.7 KB
/14 Instagram Database Clone/
235 Introduction To Instagram Clone Schema.mp4	72.7 MB
236 Cloning Instagrams DB Users Schema.mp4	12.6 MB
243 CODE IG Clone Likes Schema.html	0.6 KB
237 CODE IG Clone Users Schema.html	0.5 KB
242 Cloning Instagrams DB Likes Schema.mp4	54.4 MB
246 Cloning Instagrams DB Hashtags Part 1.mp4	31.8 MB
240 Cloning Instagrams DB Comments Schema.mp4	16.7 MB
238 Cloning Instagrams DB Photos Schema.mp4	15.5 MB
249 CODE Complete IG Clone Schema.html	2.0 KB
241 CODE IG Clone Comments Schema.html	0.7 KB
248 CODE IG Clone Hashtags Schema.html	0.7 KB
239 CODE IG Clone Photos Schema.html	0.6 KB
247 Cloning Instagrams DB Hashtags Part 2.mp4	15.4 MB
234 Section 14 Introduction.mp4	9.8 MB
245 CODE IG Clone Followers Schema.html	0.6 KB
244 Cloning Instagrams DB Followers Schema.mp4	16.7 MB
/15 Working With Lots Of Instagram Data/
266 Instagram Challenge 7 Solution CODE.html	0.7 KB
263 Instagram Clone Challenge 6.mp4	15.2 MB
261 Instagram Clone Challenge 5.mp4	7.0 MB
262 Instagram Challenge 5 Solution CODE.html	0.6 KB
254 Instagram Challenge 1 Solution CODE.html	0.5 KB
251 Loading The JUMBO dataset.mp4	154.0 MB
252 The Instagram Clone DATASET.html	0.7 KB
259 Instagram Clone Challenge 4.mp4	21.0 MB
265 Instagram Clone Challenge 7.mp4	14.3 MB
255 Instagram Clone Challenge 2.mp4	15.4 MB
258 Instagram Challenge 3 Solution CODE.html	0.5 KB
253 Instagram Clone Challenge 1.mp4	11.6 MB
250 Section 15 Introduction.mp4	11.9 MB
257 Instagram Clone Challenge 3.mp4	22.6 MB
256 Instagram Challenge 2 Solution CODE.html	0.5 KB
260 Instagram Challenge 4 Solution CODE.html	0.7 KB
264 Instagram Challenge 6 Solution CODE.html	0.7 KB
/.../252 The Instagram Clone DATASET/
ig-clone-data.sql.zip	109.8 KB
/13 Section 13 Many To Many/
225 CODE TV Joins Challenge 3 SOLUTION.html	0.7 KB
233 CODE TV Joins Challenge 7 SOLUTION.html	0.7 KB
219 CODE Creating Our Tables.html	2.9 KB
221 CODE TV Joins Challenge 1 Solution.html	0.5 KB
229 CODE TV Joins Challenge 5 SOLUTION.html	0.6 KB
222 TV Joins Challenge 2.mp4	17.3 MB
216 Section 13 Introduction.mp4	13.7 MB
224 TV Joins Challenge 3.mp4	15.1 MB
223 CODE TV Joins Challenge 2 SOLUTION.html	0.6 KB
227 CODE TV Joins Challenge 4 SOLUTION.html	0.5 KB
228 TV Joins Challenge 5.mp4	12.7 MB
232 TV Joins Challenge 7.mp4	20.4 MB
226 TV Joins Challenge 4.mp4	16.1 MB
231 CODE TV Joins Challenge 6 SOLUTION.html	1.6 KB
230 TV Joins Challenge 6.mp4	30.6 MB
220 TV Joins Challenge 1.mp4	15.2 MB
218 Creating Our Tables.mp4	28.7 MB
217 Many To Many Basics.mp4	19.3 MB
/03 Creating Databases and Tables/
040 CODE Creating Your Own Tables Challenge.html	0.5 KB
038 CODE Dropping Tables.html	0.5 KB
030 The Basic Datatypes.mp4	15.4 MB
032 Basic Datatypes Challenge - Solution.html	0.5 KB
034 CODE Creating Your Own Tables.html	0.6 KB
023 Creating Databases.mp4	10.5 MB
039 Creating Your Own Tables Challenge.mp4	8.3 MB
022 Section 3 Introduction.mp4	9.9 MB
033 Creating Your Own Tables.mp4	5.6 MB
027 Using Databases.mp4	6.4 MB
037 Dropping Tables.mp4	2.9 MB
031 Basic Datatypes Challenge.mp4	4.9 MB
028 CODE Using Databases.html	0.4 KB
025 Dropping Databases.mp4	3.4 MB
036 CODE How Do We Know It Worked.html	0.4 KB
024 CODE Creating Databases.html	0.7 KB
026 CODE Dropping Databases.html	0.6 KB
029 Introduction to Tables.mp4	10.1 MB
035 How Do We Know It Worked.mp4	5.1 MB
/18 Section 18 - Database Triggers/
308 Introduction to Database Triggers.mp4	11.4 MB
313 Managing Triggers And A Warning.mp4	17.8 MB
309 Writing Our First Trigger Part 1.mp4	15.6 MB
310 Writing Our First Trigger Part 2.mp4	32.5 MB
312 Creating Logger Triggers.mp4	25.8 MB
311 Preventing Instagram Self-Follows With Triggers.mp4	19.4 MB
/07 The World Of String Functions/
112 CODE Changing Case with UPPER and LOWER.html	0.6 KB
113 String Function Challenges.mp4	9.6 MB
101 Working with CONCAT.mp4	30.3 MB
108 CODE Using REVERSE.html	0.6 KB
106 CODE Introducing REPLACE.html	1.0 KB
111 Changing Case with UPPER and LOWER.mp4	8.0 MB
097 Running SQL Files.mp4	21.6 MB
110 CODE Working with CHAR LENGTH.html	0.6 KB
096 Section 7 Introduction.mp4	12.2 MB
109 Working with CHAR LENGTH.mp4	11.1 MB
103 Introducing SUBSTRING.mp4	21.1 MB
099 Loading Our Book Data.mp4	17.3 MB
100 CODE Loading Our Book Data.html	1.9 KB
102 CODE Working With CONCAT.html	1.3 KB
115 CODE String Function Challenges Solution.html	1.9 KB
105 Introducing REPLACE.mp4	14.8 MB
107 Using REVERSE.mp4	7.2 MB
104 CODE Introducing SUBSTRING.html	1.2 KB
098 CODE Running SQL Files.html	0.7 KB
114 String Function Challenges Solution.mp4	32.7 MB
/01 Introduction and 5 Minutes of SQL/
006 How The Course Works.mp4	32.5 MB
004 Your First 5 Minutes of SQL - Lets Get Coding.mp4	32.9 MB
002 Instructor Introductions.mp4	11.7 MB
005 CODE Your First 5 Minutes of SQL.html	1.3 KB
001 Course Introduction.mp4	8.2 MB
003 Syllabus Walkthrough and Prerequisites.mp4	21.7 MB
Total files 316