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

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	AA4D59883576E09044A51EC41C29D04E281F7304

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