The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert

The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert
The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert

English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 20.5 Hours | 2.32 GB
eLearning | Skill level: All Levels


Become an In-demand SQL Master by creating complex databases and building reports through real-world projects

If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but comprehensive introduction to MySQL, one of the most highly in-demand skills in the business sector today.

Whether you work in sales or marketing, you run your own company, or you want to build your own apps, mastering MySQL is crucial to answering complex business problems and questions using insights from data. The Ultimate MySQL Bootcamp introduces you to a solid foundation in databases in a way that’s both informative and engaging. Yes, that’s right, it’s possible to make an engaging course on databases.

In this course, you will:

  • Learn the ins and outs of SQL syntax
  • Generate reports using sales and user data
  • Analyze data using Aggregate Functions
  • Run complex queries using MySQL logical operators and string functions
  • Write all the common SQL joins
  • Work with large datasets containing thousands of entries
  • Build a web app using MySQL and NodeJS
  • Design and implement complex database schemas
  • Learn to navigate the treacherous world of storing dates and times
  • Clone the database structure of a photo sharing social network
  • Write Javascript code to generate fake data sets
  • And more!

This course is also chock full of exercises, challenges, projects, and opportunities for you to practice what you’re learning. Apply what you’re learning to real-world challenges such as finding a website’s power users, calculating your top students, identifying bots on a site, or determining which hashtags generate the most traction on a site. Along the way, you’ll also get to meet my pet cat, Blue! (She’s really cute.)

What you’ll learn

  • Create your own database or interact with existing databases
  • Write complex SQL queries across multiple tables
  • Build a web app using NodeJS and MySQL
  • Model real-world data and generate reports using SQL
  • Answer company performance or sales questions using data
+ Table of Contents

Introduction and 5 Minutes of SQL
1 Course Introduction
2 Instructor Introduction(s)
3 Syllabus Walkthrough and Prerequisites
4 Note about SQL Editor
5 Your First 5 Minutes of SQL – Let’s Get Coding!
6 CODE Your First 5 Minutes of SQL
7 How The Course Works

Getting Started Overview and Installation
8 Section Introduction
9 CODE Installing MySQL on Cloud9
10 Your First MySQL Activity
11 CODE Your First MySQL Activity
12 Mac Installation
13 CODE Mac Installation
14 Windows Installation
15 What Is a Database
16 SQL Vs. MySQL
17 Installation Overview – WATCH BEFORE INSTALLING
18 Cloud9 Registration IMPORTANT – PLEASE READ!!!
19 Setting Up Cloud9
20 Exploring The Cloud9 Interface
21 Cloud9 Interface Challenge
22 Installing MySQL on Cloud9

Creating Databases and Tables
23 Section 3 Introduction
24 Note about INT max size
25 Basic Datatypes Challenge
26 Basic Datatypes Challenge – Solution
27 Creating Your Own Tables
28 CODE Creating Your Own Tables
29 How Do We Know It Worked
30 CODE How Do We Know It Worked
31 Dropping Tables
32 CODE Dropping Tables
33 Creating Your Own Tables Challenge
34 Creating Databases
35 CODE Creating Your Own Tables Challenge
36 CODE Creating Databases
37 Dropping Databases
38 CODE Dropping Databases
39 Using Databases
40 CODE Using Databases
41 Introduction to Tables
42 The Basic Datatypes

Inserting Data (and a couple other things)
43 Section 4 Introduction
44 INSERT Challenges Solution
45 CODE INSERT Challenges Solution
46 NOTE MySQL Warnings
47 MySQL Warnings
48 CODE MySQL Warnings
49 NULL and NOT NULL
50 CODE NULL and NOT NULL
51 Setting Default Values
52 CODE Setting Default Values
53 A Primer On Primary Keys
54 Inserting Data
55 CODE A Primer on Primary Keys
56 Table Constraints Exercise
57 Table Constraints Exercise Solution
58 CODE Table Constraints Exercise Solution
59 CODE Inserting Data
60 Super Quick Intro To SELECT
61 CODE Super Quick Intro To SELECT
62 Multiple INSERT
63 CODE Multiple Insert
64 INSERT Challenges
65 Note about using quotes inside of inserted values

CRUD commmands
66 Section 5 Introduction
67 SELECT Challenges
68 SELECT Challenges Solution
69 CODE SELECT Challenges Solution
70 Introduction to Aliases
71 CODE Introduction to Aliases
72 The UPDATE Command
73 CODE The UPDATE Command
74 UPDATE Challenges
75 UPDATE Challenges Solution
76 CODE UPDATE Challenges Solution
77 Introduction to CRUD
78 Introduction to DELETE
79 CODE Introduction to DELETE
80 DELETE Challenges
81 DELETE Challenges Solution
82 CODE DELETE Challenges Solution
83 CODE Introduction to CRUD
84 Preparing Our Data
85 CODE Preparing Our Data
86 Official Introduction to SELECT
87 CODE Official Introduction to SELECT
88 Introduction to WHERE
89 CODE Introduction to WHERE

CRUD Challenge Section
90 Section 6 Introduction
91 CODE CRUD Exercise Delete Solution
92 CRUD Exercise Overview
93 CRUD Exercise Create Solution
94 CODE CRUD Exercise Create Solution
95 CRUD Exercise Read Solution
96 CODE CRUD Exercise Read Solution
97 CRUD Exercise Update Solution
98 CODE CRUD Exercise Update Solution
99 CRUD Exercise Delete Solution

The World Of String Functions
100 Section 7 Introduction
101 Introducing REPLACE
102 CODE Introducing REPLACE
103 Using REVERSE
104 CODE Using REVERSE
105 Working with CHAR LENGTH
106 CODE Working with CHAR LENGTH
107 Changing Case with UPPER and LOWER
108 CODE Changing Case with UPPER and LOWER
109 Note about string functions
110 String Function Challenges
111 Running SQL Files
112 String Function Challenges Solution
113 CODE String Function Challenges Solution
114 CODE Running SQL Files
115 Loading Our Book Data
116 CODE Loading Our Book Data
117 Working with CONCAT
118 CODE Working With CONCAT
119 Introducing SUBSTRING
120 CODE Introducing SUBSTRING

Refining Our Selections
121 Section 8 Introduction
122 Better Searches with LIKE
123 CODE Better Searches with LIKE
124 LIKE Part 2 More Wildcards
125 CODE LIKE Part 2 More Wildcards
126 Refining Selections Exercises
127 Refining Selections Exercises Solution
128 CODE Refining Selections Exercises Solution
129 Seed Data Adding A Couple New Books
130 CODE Seed Data Adding A Couple New Books
131 Using DISTINCT
132 CODE Using DISTINCT
133 Sorting Data with ORDER BY
134 CODE Sorting Data with ORDER BY
135 Using LIMIT
136 CODE Using LIMIT

The Magic of Aggregate Functions
137 Section 9 Introduction
138 Using Min and Max with Group By
139 CODE Using Min and Max with Group By
140 The Sum Function
141 CODE The Sum Function
142 The Avg Function
143 CODE The Avg Function
144 Aggregate Functions Challenges
145 Aggregate Functions Challenges Solution
146 CODE Aggregate Functions Challenges Solution
147 The Count Function
148 CODE The Count Function
149 The Joys of Group By
150 CODE The Joys of Group By
151 Min and Max Basics
152 CODE MIN and MAX Basics
153 SUBQUERIES – A Problem with Min and Max
154 CODE A Problem with Min and Max

Revisiting Data Types
155 Section 10 Introduction
156 DATE, TIME, and DATETIME
157 Creating Our DATE data
158 CODE Creating Our DATE data
159 CURDATE, CURTIME, and NOW
160 Note about formatting dates
161 Formatting Dates
162 CODE Formatting Dates
163 Date Math
164 CODE Date Math
165 Working with TIMESTAMPS
166 CHAR and VARCHAR
167 CODE Working with TIMESTAMPS
168 Data Types Exercises
169 Data Types Exercises Solution
170 CODE Data Types Exercises Solution
171 Note about CHAR and VARCHAR
172 CODE CHAR and VARCHAR
173 DECIMAL
174 CODE DECIMAL
175 FLOAT and DOUBLE
176 CODE FLOAT and DOUBLE
177 Note about setting the timezone in Cloud9

The Power of Logical Operators
178 Section 11 Introduction
179 Logical AND
180 CODE Logical AND
181 Logical OR
182 CODE Logical OR
183 Between
184 CODE Between
185 In And Not In
186 CODE In And Not In
187 Case Statements
188 CODE Case Statements
189 Not Equal
190 Logical Operators Exercises
191 Logical Operators Exercises Solution
192 CODE Logical Operators Exercises Solution
193 CODE Not Equal
194 Not Like
195 CODE Not Like
196 Greater Than
197 CODE Greater Than
198 Less Than
199 CODE Less Than

Section 12 One To Many
200 Section 12 Introduction
201 CODE Inner Joins
202 Left Join
203 CODE Left Joins
204 Right Joins Pt 1
205 CODE Right Joins Part 1
206 Right Joins Pt 2
207 CODE Right Joins Part 2
208 Right and Left Joins A Common Question
209 CODE Right and Left Joins FAQ
210 Our First Joins Exercise
211 Real World Data Is Messy
212 Our First Joins Exercise SOLUTION
213 CODE Our First Joins Exercise
214 Our First Joins Exercise SOLUTION PT. 2
215 CODE Our First Joins Exercise SOLUTION PT. 2
216 Types of Data Relationships
217 One To Many The Basics
218 Working With Foreign Keys
219 CODE Working With Foreign Keys
220 Cross Join
221 CODE Cross Joins
222 Inner Join

Section 13 Many To Many
223 Section 13 Introduction
224 CODE TV Joins Challenge 3 SOLUTION
225 TV Joins Challenge 4
226 CODE TV Joins Challenge 4 SOLUTION
227 TV Joins Challenge 5
228 CODE TV Joins Challenge 5 SOLUTION
229 TV Joins Challenge 6
230 CODE TV Joins Challenge 6 SOLUTION
231 TV Joins Challenge 7
232 CODE TV Joins Challenge 7 SOLUTION
233 Many To Many Basics
234 Creating Our Tables
235 CODE Creating Our Tables
236 TV Joins Challenge 1
237 CODE TV Joins Challenge 1 Solution
238 TV Joins Challenge 2
239 CODE TV Joins Challenge 2 SOLUTION
240 TV Joins Challenge 3

Instagram Database Clone
241 Section 14 Introduction
242 CODE IG Clone Likes Schema
243 Cloning Instagram’s DB Followers Schema
244 CODE IG Clone Followers Schema
245 Cloning Instagram’s DB Hashtags Part 1
246 Cloning Instagram’s DB Hashtags Part 2
247 CODE IG Clone Hashtags Schema
248 CODE Complete IG Clone Schema
249 Introduction To Instagram Clone Schema
250 Cloning Instagram’s DB Users Schema
251 CODE IG Clone Users Schema
252 Cloning Instagram’s DB Photos Schema
253 CODE IG Clone Photos Schema
254 Cloning Instagram’s DB Comments Schema
255 CODE IG Clone Comments Schema
256 Cloning Instagram’s DB Likes Schema

Working With Lots Of Instagram Data
257 Section 15 Introduction
258 Instagram Clone Challenge 4
259 Instagram Challenge 4 Solution CODE
260 Instagram Clone Challenge 5
261 Instagram Challenge 5 Solution CODE
262 Instagram Clone Challenge 6
263 Instagram Challenge 6 Solution CODE
264 Note about Instagram Clone Challenge 7
265 Instagram Clone Challenge 7
266 Instagram Challenge 7 Solution CODE
267 Loading The JUMBO dataset
268 The Instagram Clone DATASET
269 Instagram Clone Challenge 1
270 Instagram Challenge 1 Solution CODE
271 Instagram Clone Challenge 2
272 Instagram Challenge 2 Solution CODE
273 Instagram Clone Challenge 3
274 Instagram Challenge 3 Solution CODE

Section 16 – Introducing Node
275 Section 16 Introduction
276 CODE Introduction to NPM and Faker
277 Introducing the MySQL Package
278 Note about connecting Node to MySQL
279 Connecting Node to MySQL
280 CODE Connecting Node to MySQL
281 Creating Our Users Table
282 CODE Creating Our Users Table
283 Selecting Using Node
284 CODE Selecting Using Node
285 Inserting Using Node
286 MySQL and Other Languages
287 CODE Inserting Using Node
288 Some MySQLNode Magic
289 Bulk Inserting 500 Users – Finally!
290 CODE Bulk Inserting 500 Users
291 Users Exercises
292 Users Exercises Solutions
293 CODE 500 Users Exercises Solutions
294 BUT WHAT ABOUT PHP
295 Introduction to JOIN US app
296 Setting Up Cloud9 for Node
297 Minute NodeJS Crash Course
298 CODE 5 Minute Node Crash Course
299 Note about Faker install
300 Introduction to NPM and Faker

Section 17 – Building Our Web App
301 Section 17 Introduction
302 CODE Connecting Express and MySQL
303 Adding EJS Templates
304 CODE Adding EJS Templates
305 Connecting The Form
306 CODE Connecting the Form
307 Styling Part 1
308 CODE HTML AND CSS FILES
309 Styling Part 2
310 Join Us Completed CODE
311 Introducing Express
312 NPM Init and package.json files
313 Our First Simple Web App
314 CODE Our First Simple Web App
315 Adding Multiple Routes
316 CODE Adding Multiple Routes
317 Connecting Express and MySQL

Section 18 – Database Triggers
318 Introduction to Database Triggers
319 Writing Our First Trigger Part 1
320 Writing Our First Trigger Part 2
321 Preventing Instagram Self-Follows With Triggers
322 Creating Logger Triggers
323 Managing Triggers And A Warning