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

728x90 AdSpace

Trending

The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert


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
Table of Contents
Introduction and 5 Minutes of SQL
1 Course Introduction
2 Instructor Introduction(s)
3 Syllabus Walkthrough and Prerequisites
4 Your First 5 Minutes of SQL - Let's Get Coding!
5 CODE_ Your First 5 Minutes of SQL
6 How The Course Works
Getting Started_ Overview and Installation
7 Section Introduction
8 What Is a Database_
9 SQL Vs_ MySQL
10 Installation Overview - WATCH BEFORE INSTALLING
11 Cloud9 Registration
12 Setting Up Cloud9
13 Exploring The Cloud9 Interface
14 Cloud9 Interface Challenge
15 Installing MySQL on Cloud9
16 CODE_ Installing MySQL on Cloud9
17 Your First MySQL Activity
18 CODE_ Your First MySQL Activity
19 Mac Installation
20 CODE_ Mac Installation
21 Windows Installation
Creating Databases and Tables
22 Section 3 Introduction
23 Creating Databases
24 CODE_ Creating Databases
25 Dropping Databases
26 CODE_ Dropping Databases
27 Using Databases
28 CODE_ Using Databases
29 Introduction to Tables
30 The Basic Datatypes
31 Note about INT max size
32 Basic Datatypes Challenge
33 Basic Datatypes Challenge - Solution
34 Creating Your Own Tables
35 CODE_ Creating Your Own Tables
36 How Do We Know It Worked_
37 CODE_ How Do We Know It Worked_
38 Dropping Tables
39 CODE_ Dropping Tables
40 Creating Your Own Tables Challenge
41 CODE_ Creating Your Own Tables Challenge
Inserting Data (and a couple other things)
42 Section 4 Introduction
43 Inserting Data
44 CODE_ Inserting Data
45 Super Quick Intro To SELECT
46 CODE_ Super Quick Intro To SELECT
47 Multiple INSERT
48 CODE_ Multiple Insert
49 INSERT Challenges
50 INSERT Challenges Solution
51 CODE_ INSERT Challenges Solution
52 MySQL Warnings
53 CODE_ MySQL Warnings
54 NULL and NOT_NULL
55 CODE_ NULL and NOT NULL
56 Setting Default Values
57 CODE_ Setting Default Values
58 A Primer On Primary Keys
59 CODE_ A Primer on Primary Keys
60 Table Constraints Exercise
61 Table Constraints Exercise Solution
62 CODE_ Table Constraints Exercise Solution
CRUD commmands
63 Section 5 Introduction
64 Introduction to CRUD
65 CODE_ Introduction to CRUD
66 Preparing Our Data
67 CODE_ Preparing Our Data
68 Official Introduction to SELECT
69 CODE_ Official Introduction to SELECT
70 Introduction to WHERE
71 CODE_ Introduction to WHERE
72 SELECT Challenges
73 SELECT Challenges Solution
74 CODE_ SELECT Challenges Solution
75 Introduction to Aliases
76 CODE_ Introduction to Aliases
77 The UPDATE Command
78 CODE_ The UPDATE Command
79 UPDATE Challenges
80 UPDATE Challenges Solution
81 CODE_ UPDATE Challenges Solution
82 Introduction to DELETE
83 CODE_ Introduction to DELETE
84 DELETE Challenges
85 DELETE Challenges Solution
86 CODE_ DELETE Challenges Solution
CRUD Challenge Section
87 Section 6 Introduction
88 CRUD Exercise Overview
89 CRUD Exercise Create Solution
90 CODE_ CRUD Exercise Create Solution
91 CRUD Exercise Read Solution
92 CODE_ CRUD Exercise Read Solution
93 CRUD Exercise Update Solution
94 CODE_ CRUD Exercise Update Solution
95 CRUD Exercise Delete Solution
96 CODE_ CRUD Exercise Delete Solution
The World Of String Functions
97 Section 7 Introduction
98 Running SQL Files
99 CODE_ Running SQL Files
100 Loading Our Book Data
101 CODE_ Loading Our Book Data
102 Working with CONCAT
103 CODE_ Working With CONCAT
104 Introducing SUBSTRING
105 CODE_ Introducing SUBSTRING
106 Introducing REPLACE
107 CODE_ Introducing REPLACE
108 Using REVERSE
109 CODE_ Using REVERSE
110 Working with CHAR LENGTH
111 CODE_ Working with CHAR LENGTH
112 Changing Case with UPPER and LOWER
113 CODE_ Changing Case with UPPER and LOWER
114 String Function Challenges
115 String Function Challenges Solution
116 CODE_ String Function Challenges Solution
Refining Our Selections
117 Section 8 Introduction
118 Seed Data_ Adding A Couple New Books
119 CODE_ Seed Data_ Adding A Couple New Books
120 Using DISTINCT
121 CODE_ Using DISTINCT
122 Sorting Data with ORDER BY
123 CODE_ Sorting Data with ORDER BY
124 Using LIMIT
125 CODE_ Using LIMIT
126 Better Searches with LIKE
127 CODE_ Better Searches with LIKE
128 LIKE Part 2_ More Wildcards
129 CODE_ LIKE Part 2_ More Wildcards
130 Refining Selections Exercises
131 Refining Selections Exercises Solution
132 CODE_ Refining Selections Exercises Solution
The Magic of Aggregate Functions
133 Section 9 Introduction
134 The Count Function
135 CODE_ The Count Function
136 The Joys of Group By
137 CODE_ The Joys of Group By
138 Min and Max Basics
139 CODE_ MIN and MAX Basics
140 SUBQUERIES - A Problem with Min and Max
141 CODE_ A Problem with Min and Max
142 Using Min and Max with Group By
143 CODE_ Using Min and Max with Group By
144 The Sum Function
145 CODE_ The Sum Function
146 The Avg Function
147 CODE_ The Avg Function
148 Aggregate Functions Challenges
149 Aggregate Functions Challenges Solution
150 CODE_ Aggregate Functions Challenges Solution
Revisiting Data Types
151 Section 10 Introduction
152 CHAR and VARCHAR
153 Note about CHAR and VARCHAR
154 CODE_ CHAR and VARCHAR
155 DECIMAL
156 CODE_ DECIMAL
157 FLOAT and DOUBLE
158 CODE_ FLOAT and DOUBLE
159 Note about setting the timezone in Cloud9
160 DATE_ TIME_ and DATETIME
161 Creating Our DATE data
162 CODE_ Creating Our DATE data
163 CURDATE_ CURTIME_ and NOW
164 Note about formatting dates
165 Formatting Dates
166 CODE_ Formatting Dates
167 Date Math
168 CODE_ Date Math
169 Working with TIMESTAMPS
170 CODE_ Working with TIMESTAMPS
171 Data Types Exercises
172 Data Types Exercises Solution
173 CODE_ Data Types Exercises Solution
The Power of Logical Operators
174 Section 11 Introduction
175 Not Equal
176 CODE_ Not Equal
177 Not Like
178 CODE_ Not Like
179 Greater Than
180 CODE_ Greater Than
181 Less Than
182 CODE_ Less Than
183 Logical AND
184 CODE_ Logical AND
185 Logical OR
186 CODE_ Logical OR
187 Between
188 CODE_ Between
189 In And Not In
190 CODE_ In And Not In
191 Case Statements
192 CODE_ Case Statements
193 Logical Operators Exercises
194 Logical Operators Exercises Solution
195 CODE_ Logical Operators Exercises Solution
Section 12_ One To Many
196 Section 12 Introduction
197 Real World Data Is Messy
198 Types of Data Relationships
199 One To Many_ The Basics
200 Working With Foreign Keys
201 CODE_ Working With Foreign Keys
202 Cross Join
203 CODE_ Cross Joins
204 Inner Join
205 CODE_ Inner Joins
206 Left Join
207 CODE_ Left Joins
208 Right Joins Pt 1
209 CODE_ Right Joins Part 1
210 Right Joins Pt 2
211 CODE_ Right Joins Part 2
212 Right and Left Joins_ A Common Question
213 CODE_ Right and Left Joins FAQ
214 Our First Joins Exercise
215 Our First Joins Exercise SOLUTION
216 CODE_ Our First Joins Exercise
217 Our First Joins Exercise SOLUTION PT_ 2
218 CODE_ Our First Joins Exercise SOLUTION PT_ 2
Section 13_ Many To Many
219 Section 13 Introduction
220 Many To Many Basics
221 Creating Our Tables
222 CODE_ Creating Our Tables
223 TV Joins Challenge 1
224 CODE_ TV Joins Challenge 1 Solution
225 TV Joins Challenge 2
226 CODE_ TV Joins Challenge 2 SOLUTION
227 TV Joins Challenge 3
228 CODE_ TV Joins Challenge 3 SOLUTION
229 TV Joins Challenge 4
230 CODE_ TV Joins Challenge 4 SOLUTION
231 TV Joins Challenge 5
232 CODE_ TV Joins Challenge 5 SOLUTION
233 TV Joins Challenge 6
234 CODE_ TV Joins Challenge 6 SOLUTION
235 TV Joins Challenge 7
236 CODE_ TV Joins Challenge 7 SOLUTION
Instagram Database Clone
237 Section 14 Introduction
238 Introduction To Instagram Clone Schema
239 Cloning Instagram's DB_ Users Schema
240 CODE_ IG Clone Users Schema
241 Cloning Instagram's DB_ Photos Schema
242 CODE_ IG Clone Photos Schema
243 Cloning Instagram's DB_ Comments Schema
244 CODE_ IG Clone Comments Schema
245 Cloning Instagram's DB_ Likes Schema
246 CODE_ IG Clone Likes Schema
247 Cloning Instagram's DB_ Followers Schema
248 CODE_ IG Clone Followers Schema
249 Cloning Instagram's DB_ Hashtags Part 1
250 Cloning Instagram's DB_ Hashtags Part 2
251 CODE_ IG Clone Hashtags Schema
252 CODE_ Complete IG Clone Schema
Working With Lots Of Instagram Data
253 Section 15 Introduction
254 Loading The JUMBO dataset
255 The Instagram Clone DATASET
256 Instagram Clone Challenge 1
257 Instagram Challenge 1 Solution CODE
258 Instagram Clone Challenge 2
259 Instagram Challenge 2 Solution CODE
260 Instagram Clone Challenge 3
261 Instagram Challenge 3 Solution CODE
262 Instagram Clone Challenge 4
263 Instagram Challenge 4 Solution CODE
264 Instagram Clone Challenge 5
265 Instagram Challenge 5 Solution CODE
266 Instagram Clone Challenge 6
267 Instagram Challenge 6 Solution CODE
268 Instagram Clone Challenge 7
269 Instagram Challenge 7 Solution CODE
Section 16 - Introducing Node
270 Section 16 Introduction
271 MySQL and Other Languages
272 BUT WHAT ABOUT PHP
273 Introduction to JOIN US app
274 Setting Up Cloud9 for Node
275 Minute NodeJS Crash Course
276 CODE_ 5 Minute Node Crash Course
277 Introduction to NPM and Faker
278 CODE_ Introduction to NPM and Faker
279 Introducing the MySQL Package
280 Connecting Node to MySQL
281 CODE_ Connecting Node to MySQL
282 Creating Our Users Table
283 CODE_ Creating Our Users Table
284 Selecting Using Node
285 CODE_ Selecting Using Node
286 Inserting Using Node
287 CODE_ Inserting Using Node
288 Some MySQL_Node 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
Section 17 - Building Our Web App
294 Section 17 Introduction
295 Join Us Completed CODE
296 Introducing Express
297 NPM Init and package_json files
298 Our First Simple Web App
299 CODE_ Our First Simple Web App
300 Adding Multiple Routes
301 CODE_ Adding Multiple Routes
302 Connecting Express and MySQL
303 CODE_ Connecting Express and MySQL
304 Adding EJS Templates
305 CODE_ Adding EJS Templates
306 Connecting The Form
307 CODE_ Connecting the Form
308 Styling Part 1
309 CODE_ HTML AND CSS FILES
310 Styling Part 2
Section 18 - Database Triggers
311 Introduction to Database Triggers
312 Writing Our First Trigger Part 1
313 Writing Our First Trigger Part 2
314 Preventing Instagram Self-Follows With Triggers
315 Creating Logger Triggers
316 Managing Triggers And A Warning


The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert 
English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 20.5 Hours | 2.70 GB


Download from Turbobit


Download from DepositFiles


Download from Rapidgator

The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert Reviewed by Rom on 6/09/2018 Rating: 5 Become an In-demand SQL Master by creating complex databases and building reports through real-world projects If you want to learn h...

No comments: