The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert
Год выпуска: 2017
Производитель: Udemy
Сайт производителя: https://www.udemy.com
Автор: Colt Steele
Продолжительность: 20:49:20
Тип раздаваемого материала: Видеоурок
Язык: Английский
Описание: Если вы хотите узнать, как получить информацию из данных, но слишком запуганы системами управления базами данных, чтобы знать, с чего начать, этот курс для вас. Этот курс является неспешным, но всеобъемлющим введением в MySQL, один из наиболее востребованных навыков в бизнес-секторе сегодня.
Независимо от того, работаете ли вы в продажах или маркетинге, запускаете свою собственную компанию или хотите создавать собственные приложения, освоение MySQL имеет решающее значение для ответа на сложные бизнес-проблемы и вопросы, используя идеи из данных. Ultimate MySQL Bootcamp представляет вам прочную основу в базах данных информативным и привлекательным образом. Да, всё верно, курс по базам данных можно сделать привлекательным.

Содержание

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

Скриншоты


If you like the topic, please click share to help develop our site.

To download the file disable ad blocking, and reload the page.

disable adblock How to disable ad blocking?

Download by magnet link 3.1 GB Download Torrent

Login using:

Similar topics

[Udemy] The Ultimate Guide to Game Development with Unity[2017, ENG]
 3.29 GB   0 | 0   23-Feb-18 18:30   28
[Udemy] Learn 3D Animation - The Ultimate Blender Guide [2017, ENG]
 5.05 GB   0 | 0   11-Feb-18 19:45   47


   
Current time is: 17-Jun 02:40 :: All times are UTC + 3