FreeTutorials us the ultimate mysql bootcamp go from sql beginner to expert

FreeTutorials us the ultimate mysql bootcamp go from sql beginner to expert

Name	[FreeTutorials.us] the-ultimate-mysql-bootcamp-go-from-sql-beginner-to-expert	DOWNLOAD Copy Link
Total Size	3.3 GB
Total Files	316
Hash	591BBC3CA06587650A0D06F930F43CA5E8E80404

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