SQL–MySQL Complete Master Bootcamp | Beginner-Expert (2023)

Focused View

Donatus Obomighie | PhD, MSc, PMP

23:38:12

37 View

1 - Introduction Installation Resources Database Select and CRUD Updated

1 - Your SQL Success Starts Here Master Complete SQL Course.html

2 - Introduction to SQL.mp4

24:57

3 - Installation Introduction.mp4

03:07

4 - 8 Multiple Choice on Basic SQL MySQL Questions.html

5 - 8 Multiple Choice on Basic SQL MySQL Answers.html

6 - Installation Installation of MySQL on MacOS.mp4

05:43

7 - Installation RESOURCES Installation of MySQL on MacOS.html

8 - Installation How to fix Cannot Connect to MySQL Server MacOS.mp4

02:35

9 - Installation Installation of MySQL Server and Workbench on Windows.mp4

03:22

10 - Installation How to fix Cannot Connect to MySQL Server Windows.mp4

02:29

11 - Database Database as a house Introduction.mp4

04:51

12 - 2-Creating-a-Database.txt

12 - Database Creating a Database.mp4

02:13

13 - 3-Creating-a-Database-with-IF-NOT-EXISTS.txt

13 - Database Creating a Database with IF NOT EXISTS.mp4

03:23

14 - 4-How-to-use-a-Database.txt

14 - Database How to use a Database.mp4

01:13

15 - 5-Finding-Out-the-Currently-Selected-Database.txt

15 - Database Finding Out the Currently Selected Database.mp4

01:52

16 - 6-Checking-If-a-Database-Exists.txt

16 - Database Checking If a Database Exists.mp4

02:28

17 - 7-Deleting-a-Database.txt

17 - Database Deleting a Database.mp4

01:24

18 - 8-Deleting-a-Database-If-It-Exists.txt

18 - Database Deleting a Database If It Exists.mp4

02:35

19 - 18 Multiple Choice on Database Question.html

20 - 18 Multiple Choice on Database Answers.html

21 - 4-Select.txt

21 - Select Understanding Select Statement.mp4

15:16

22 - Resources Databases Youll Need for this Course.html

22 - camera.zip

22 - carshop.zip

22 - northwind-data-set.zip

22 - research.zip

23 - Resources How to Run the Resources.mp4

01:33

24 - CRUD Understanding CRUD.mp4

02:53

25 - 5 Multiple Choice on CRUD Questions.html

26 - 5 Multiple Choice on CRUD Answers.html

27 - Table Introduction and Creating Basic Table in MySQL.mp4

20:19

28 - Data Types Introduction.mp4

03:00

2 - ARCHIVED SQL Select Statement

29 - SELECT Understanding Select for Absolute beginners.mp4

13:09

3 - ARCHIVED SQL Database

30 - Database vs Table In SQL Laymans Explanation Challenge Solution.mp4

03:57

31 - Creating A Database Challenge Solution 1.mp4

00:27

32 - CODE Creating A Database Challenge Solution 1.html

33 - IF NOT EXISTS with CREATE DATABASE Challenge Solution 2.mp4

01:25

34 - CODE IF NOT EXISTS with CREATE DATABASE Challenge Solution 2.html

35 - How To Check For Existing Databases Challenge Solution 3.mp4

00:40

36 - CODE How To Check For Existing Databases Challenge Solution.html

37 - How To Delete A Database Challenges Solution 4.mp4

01:02

38 - CODE How To Delete A Database Challenges Solution 4.html

39 - Using A Database Challenge Solution 5.mp4

02:05

40 - CODE Using A Database Challenge Solution 5.html

41 - How To Check For The Selected Database in Use Challenge Solution 6.mp4

00:36

42 - CODE How To Check For The Selected Database in Use Challenge Solution 6.html

4 - MySQL Numeric Data Types Updated

43 - Introduction to MySQL Numeric Data Types.mp4

05:52

44 - Integer Types INTEGER or INT SMALLINT TINYINT MEDIUMINT BIGINT.mp4

05:07

45 - Clients Integer Data Types Requirement Scenario.mp4

07:50

46 - CODE Clients Integer Data Types Requirement Scenario.html

47 - Boolean Type tinyint1.mp4

04:28

48 - CODE Boolean Type tinyint1.html

49 - 20 MultipleChoice Questions on Integer Data Types.html

50 - Answers 20 MultipleChoice Questions on Integer Data Types.html

51 - FixedPoint Types DECIMAL NUMERIC.mp4

03:10

52 - Clients FixedPoint Data Types Requirement Scenario.mp4

03:37

53 - CODE Clients FixedPoint Data Types Requirement Scenario.html

54 - 10 MultipleChoice Questions on FixedPoint Data Types.html

55 - Answers 10 MultipleChoice Questions on FixedPoint Data Types.html

56 - FloatingPoint Types FLOAT DOUBLE.mp4

02:53

57 - Clients FloatingPoint Data Types Requirement Scenario.mp4

01:11

58 - CODE Clients FloatingPoint Data Types Requirement Scenario.html

59 - 10 MultipleChoice Questions on FloatingPoint Data Types.html

60 - Answers 10 MultipleChoice Questions on FloatingPoint Data Types.html

61 - BitValue Type BIT.mp4

01:18

62 - Clients Bit Data Types Requirement Scenario.mp4

02:17

63 - CODE Clients Bit Data Types Requirement Scenario.html

64 - 5 MultipleChoice Questions on Bit Data Types.html

65 - Answers 5 MultipleChoice Questions on Bit Data Types.html

5 - MySQL String Data Types Updated

66 - Introduction to MySQL String Data Types.mp4

01:49

67 - The CHAR and VARCHAR Types.mp4

03:04

68 - Clients CHAR and VARCHAR Types Requirement Scenario.mp4

02:04

69 - CODE Clients CHAR and VARCHAR Types Requirement Scenario.html

70 - 10 MultipleChoice Questions on CHAR and VARCHAR Data Types.html

71 - Answers 10 MultipleChoice Questions on CHAR and VARCHAR Data Types.html

72 - The BINARY and VARBINARY Types.mp4

02:35

73 - Clients BINARY and VARBINARY Types Requirement Scenario.mp4

01:37

74 - CODE Clients BINARY and VARBINARY Types Requirement Scenario.html

75 - 10 MultipleChoice Questions on BINARY and VARBINARY Data Types.html

76 - Answers 10 MultipleChoice Questions on BINARY and VARBINARY Data Types.html

77 - The BLOB and TEXT Types.mp4

03:46

78 - Clients BLOB and TEXT Types Requirement Scenario.mp4

03:50

79 - CODE Clients BLOB and TEXT Types Requirement Scenario.html

80 - 30 MultipleChoice Questions on BLOB and TEXT Data Types.html

81 - Answers 30 MultipleChoice Questions on BLOB and TEXT Data Types.html

82 - ENUM Type.mp4

03:08

83 - Clients ENUM Types Requirement Scenario.mp4

02:59

84 - CODE Clients ENUM Types Requirement Scenario.html

85 - 10 MultipleChoice Questions on ENUM Data Types.html

86 - Answers 10 MultipleChoice Questions on ENUM Data Types.html

87 - SET Type.mp4

03:31

88 - Clients SET Types Requirement Scenario.mp4

02:11

89 - CODE Clients SET Types Requirement Scenario.html

90 - 10 MultipleChoice Questions on SET Data Types.html

91 - Answers 10 MultipleChoice Questions on SET Data Types.html

6 - MySQL Date and Time Data Types Updated

92 - Introduction to MySQL Date Time.mp4

01:04

93 - DATE TIME Types.mp4

03:49

94 - Clients Date and Time Types Requirement Scenario.mp4

02:22

95 - CODE Clients Date and Time Types Requirement Scenario.html

96 - 20 MultipleChoice Questions on Date and Time Data Types.html

97 - Answers 20 MultipleChoice Questions on Date and Time Data Types.html

7 - MySQL Spatial Data Types Updated

98 - Introduction to MySQL Spatial Types.mp4

01:59

99 - Spatial Data Types.mp4

02:31

100 - Clients Spatial Types Requirement Scenario.mp4

03:18

101 - CODE Clients Spatial Types Requirement Scenario.html

102 - 20 MultipleChoice Questions on Spatial Data Types.html

103 - Answers 20 MultipleChoice Questions on Spatial Data Types.html

8 - MySQL JSON Data Types Updated

104 - Understanding JSON Data Type in MySQL.mp4

01:59

105 - Clients JSON Types Requirement Scenario.mp4

03:18

106 - CODE Clients JSON Types Requirement Scenario.html

107 - 10 MultipleChoice Questions on JSON Data Types.html

108 - Answers 10 MultipleChoice Questions on JSON Data Types.html

9 - ARCHIVED SQL Data Types

109 - Type of Data in MySQL.mp4

01:38

110 - MySQL Numeric Types.mp4

02:47

111 - TINYINT SMALLINT MEDIUMINT INTEGER BIGINT Exact Numeric Data Types in MySQL.mp4

14:50

112 - DECIMAL NUMERIC Fixed Point Data Types in MySQL Approximate Numeric I.mp4

08:46

113 - DECIMAL NUMERIC Fixed Point Data Types in MySQL Approximate Numeric II.mp4

11:10

114 - REAL FLOAT DOUBLE Floating Point Data Type in MySQL.mp4

07:26

115 - CHAR vs VARCHAR String Data Types in MySQL.mp4

05:23

116 - BINARY VARBINARY String Data Types in MySQL.mp4

03:45

117 - BLOB TEXT String Data Types in MySQL.mp4

01:07

118 - ENUM String Data Types in MySQL.mp4

03:44

119 - SET String Data Types in MySQL.mp4

03:00

120 - DATE TIME DATETIME TIMESTAMP YEAR Date and Time Data Types in MySQL.mp4

03:48

10 - MySQl AutoIncrement WHERE In Brief

121 - 1-Auto-Increment.txt

121 - MySQL Auto Increment.mp4

04:19

122 - 19-MySQL-Default.txt

122 - MySQL Default.mp4

06:38

123 - 20-Null-and-NOT-Null.txt

123 - MySQL Null and NOT Null.mp4

09:03

124 - 2-WHERE-in-Brief.txt

124 - WHERE A brief Intro.mp4

05:02

11 - MySQL Insert Query Updated

125 - 3-Basic-Insert.txt

125 - SQL Basic Insert.mp4

01:37

126 - 4-Inserting-Multiple-Rows-at-Once.txt

126 - SQL Inserting Multiple Rows at Once.mp4

00:38

127 - 5-Inserting-Data-from-Another-Table.txt

127 - SQL Inserting Data from Another Table.mp4

02:56

128 - 6-Inserting-with-a-Set-Clause.txt

128 - SQL Inserting with a Set Clause.mp4

01:02

12 - ARCHIVED SQL Insert Query

129 - Inserting A Single Line of Data Into Table 1st Method.mp4

01:25

130 - CODE Inserting A Single Line of Data Into Table 1st Method.html

131 - Inserting A Single Line of Data Into Table 2nd Method.mp4

00:42

132 - CODE Inserting A Single Line of Data Into Table 2nd Method.html

133 - Inserting Multiple Lines of Data Into Table 1st Method.mp4

00:46

134 - CODE Inserting Multiple Lines of Data Into Table 1st Method.html

135 - Inserting Multiple Lines of Data Into Table 2nd Method.mp4

01:42

136 - CODE Inserting Multiple Lines of Data Into Table 2nd Method.html

137 - Inserting Multiple Lines of Data Into Table 3rd Method.mp4

00:53

138 - CODE Inserting Multiple Lines of Data Into Table 3rd Method.html

139 - Inserting Null Value and Empty White Space Into Table.mp4

03:49

140 - CODE Inserting Null Value and Empty White Space Into Table.html

13 - SQL Candidate Surrogate Primary Unique Natural Foreign Key Updated

141 - Introductions to Keys in SQL.mp4

06:30

142 - 2-Unique-Key.txt

142 - Unique Key in SQL.mp4

11:17

143 - 3-Primary-Key.txt

143 - Primary Key in SQL.mp4

06:37

144 - Candidate and Alternate Keys in SQL.mp4

05:54

145 - Composite Compound Key in SQL.mp4

01:11

146 - Natural Key in SQL.mp4

02:02

147 - Surrogate Key in SQL.mp4

03:44

148 - Super Key in SQL.mp4

01:55

149 - 8-Foreign-Key.txt

149 - Foreign Key in SQL.mp4

07:57

150 - 41 MultipleChoice Questions on different types of SQL Keys.html

151 - Answers 41 MultipleChoice Questions on different types of SQL Keys.html

14 - ARCHIVED SQL Candidate Surrogate Primary Alternative Foreign Keys

152 - Candidate Key In SQL.mp4

03:08

153 - Surrogate Key In SQL.mp4

01:51

154 - Primary Key Alternative Key In SQL.mp4

03:58

155 - Foreign Key In SQL.mp4

04:29

15 - SQL Alter Table UPDATED

156 - 7-Alter-Table-Intro-Adding-a-New-Column.txt

156 - Alter Table Intro Adding a New Column.mp4

04:03

157 - 8-Alter-Table-Droping-an-Existing-Column.txt

157 - Alter Table Dropping an Existing Column.mp4

01:11

158 - 9-Alter-Table-Modify-Column-Type-and-Size.txt

158 - Alter Table Modify Column Type and Size.mp4

01:21

159 - 10-Alter-Table-Drop-Primary-Key.txt

159 - Alter Table Drop Primary Key.mp4

00:48

160 - 11-Alter-Table-Add-Primary-Key.txt

160 - Alter Table Add Primary Key.mp4

00:30

161 - 12-Alter-Table-Add-Unique-Constraint.txt

161 - Alter Table Add Unique Constraint.mp4

00:51

162 - 13-Alter-Table-Rename-Column.txt

162 - Alter Table Rename Column.mp4

00:58

163 - 14-Alter-Table-Add-Foreign-Key.txt

163 - Alter Table Add Foreign Key.mp4

03:50

164 - 15-Alter-Table-Rename-Table.txt

164 - Alter Table Rename Table.mp4

00:53

165 - 16-Alter-Table-Add-Default-to-Column.txt

165 - Alter Table Add Default to Column.mp4

01:59

166 - 17-Alter-Table-Drop-Default-from-a-Column.txt

166 - Alter Table Drop Default from a Column.mp4

00:50

167 - 18-Alter-Table-Drop-Foreign-Key.txt

167 - Alter Table Drop Foreign Key.mp4

05:49

16 - SQL Deleting Records

168 - 1-Introduction-to-delete-Deleting-Specific-Records.txt

168 - Introduction to delete Deleting Specific Records.mp4

02:46

169 - 2-Delete-multiple-records.txt

169 - Delete multiple records.mp4

01:14

170 - 3-Delete-all-records.txt

170 - Delete all records.mp4

00:39

171 - 4-Truncate-Table.txt

171 - Truncate Table.mp4

00:37

172 - 5-deleting-a-table.zip

172 - Deleting a Table.mp4

00:44

173 - 6-Delete-Cascade.txt

173 - Delete Cascade.mp4

07:40

17 - ARCHIVED SQL Primary and Foreign Key Constraints Alter Table

174 - Assigning A PRIMARY KEY Three Methods Challenge Solution 1.mp4

03:39

175 - CODE Assigning A PRIMARY KEY Three Methods Challenge Solution.html

176 - Deleting A PRIMARY KEY Challenge Solution 2.mp4

02:18

177 - CODE Deleting A PRIMARY KEY Challenge Solution 2.html

178 - Adding A PRIMARY KEY To Existing Column Challenge Solution 3.mp4

01:44

179 - CODE Adding A PRIMARY KEY To Existing Column Challenge Solution 3.html

180 - Assigning A FOREIGN KEY Challenge Solution 4.mp4

06:42

181 - CODE Assigning A FOREIGN KEY Challenge Solution 4.html

182 - Assigning A CONSTRAINT NAME To A FOREIGN KEY Challenge Solution 5.mp4

02:49

183 - CODE Assigning A CONSTRAINT NAME To A FOREIGN KEY Challenge Solution 5.html

184 - Adding A FOREIGN KEY To Existing Table Challenge Solution 6.mp4

02:46

185 - CODE Challenge Solution 6 Adding A FOREIGN KEY To Existing Table.html

186 - Challenge Solution 7 CONSTRAINT NAME FOREIGN KEY To Existing Table.mp4

02:34

187 - CODECONSTRAINT NAME FOREIGN KEY To Existing Table Challenge Solution 7.html

188 - Deleting A REFERENCED Parent Table Challenge Solution 8.mp4

02:19

189 - CODE Deleting A REFERENCED Parent Table Challenge Solution 8.html

190 - Deleting A Column From A Table Challenge Solution 9.mp4

01:07

191 - CODE Deleting A Column From A Table Challenge Solution 9.html

192 - Deleting A REFERENCED or CONSTRAINT Column Challenge Solution 10.mp4

03:02

193 - CODE Deleting A REFERENCED or CONSTRAINT Column Challenge Solution 10.html

18 - SQL Revisiting Select Statement

194 - Select All Rows and Columns Challenge Solution 1.mp4

02:25

195 - CODE Select All Rows and Columns Challenge Solution 1.html

196 - Select Specific Columns Challenge Solution 2.mp4

01:28

197 - CODE Select Specific Columns Challenge Solution 2.html

198 - Manager Demands for All Customers Detail Challenge Solution 3.mp4

00:43

199 - CODE Manager Demands for All Customers Detail Challenge Solution 3.html

200 - Specific Customers Details Challenge Solution 4.mp4

00:31

201 - CODE Specific Customers Details Challenge Solution 4.html

19 - SQL Alias AS

202 - ALIAS AS Introduction.mp4

04:23

203 - CODE ALIAS AS Introduction.html

204 - Alias Challenge Solution.mp4

02:13

205 - CODE Alias Challenge Solution.html

20 - SQL Concat Function

206 - CONCAT Introduction.mp4

01:10

207 - CODE CONCAT Introduction.html

208 - CONCAT Challenge Solution 1.mp4

00:33

209 - CODE Challenge Solution 1 CONCAT.html

210 - CONCAT Challenge Solution 2.mp4

02:28

211 - CODE Challenge Solution 2 CONCAT.html

21 - SQL Order By Keyword

212 - ORDER BY Introduction.mp4

03:47

213 - ORDER BY ASC Challenge Solution 1.mp4

02:02

214 - CODE ORDER BY ASC Challenge Solution 1.html

215 - ORDER BY DESC Challenge Solution 2.mp4

01:50

216 - CODE ORDER BY DESC Challenge Solution 2.html

217 - ORDER BY DESC CONCAT Challenge Solution 3.mp4

02:57

218 - CODE ORDER BY DESC CONCAT Challenge Solution 3.html

219 - ORDER BY ASC Challenge Solution 4.mp4

01:18

220 - CODE ORDER BY ASC Challenge Solution 4.html

22 - SQL Limit Clause

221 - LIMIT Challenge Solution 1.mp4

01:03

222 - CODE LIMIT Challenge Solution 1.html

223 - LIMIT Challenge Solution 2.mp4

01:20

224 - CODE LIMIT Challenge Solution 2.html

225 - LIMIT Challenge Solution 3.mp4

00:53

226 - CODE LIMIT Challenge Solution 3.html

23 - SQL Order By Rand Function

227 - ORDER BY with RAND Challenge Solution.mp4

01:16

228 - CODE ORDER BY with RAND Challenge Solution.html

24 - SQL Comments

229 - SINGLE MULTILINE COMMENTS in SQLMySQL.mp4

03:24

25 - SQL Where Clause

230 - Introduction to WHERE.mp4

03:19

231 - Northwind Data Set Should run to work along.html

231 - northwind-data-set.zip

232 - UK Customers filter Challenge Solution 1.mp4

02:58

233 - CODE UK Customers filter Challenge Solution 1.html

234 - Specific Customer filter Challenge Solution 2.mp4

00:30

235 - CODE Specific Customer filter Challenge Solution 2.html

236 - Specific Employee filter Challenge Solution 3.mp4

00:34

237 - CODE Specific Employee filter Challenge Solution 3.html

238 - Product with specific Price filter Challenge Solution 4.mp4

00:48

239 - CODE Product with specific Price filter Challenge Solution 4.html

240 - Getting a list of Sales Representatives Challenge Solution 5.mp4

00:52

241 - CODE Getting a list of Sales Representatives Challenge Solution 5.html

242 - None Spanish Customers using Challenge Solution 6.mp4

02:38

243 - CODE None Spanish Customers using Challenge Solution 6.html

244 - Products Supplied by a Specific Customer Challenge Solution 7.mp4

00:38

245 - CODE Products Supplied by a Specific Customer Challenge Solution 7.html

246 - All Suppliers Except using NOT Challenge Solution 8.mp4

01:42

247 - CODE All Suppliers Except using NOT Challenge Solution 8.html

248 - Products above certain Price Greater Than Challenge Solution 9.mp4

00:52

249 - CODE Products above certain Price Greater Than Challenge Solution 9.html

250 - Products Below Certain Price Less Than Challenge Solution 10.mp4

00:39

251 - CODE Products Below Certain Price Less Than Challenge Solution 10.html

252 - Unit In Stock Less Than Challenge Solution 11.mp4

01:00

253 - CODEUnit In Stock Less Than Challenge Solution 11.html

254 - Minimum Wages Less Than Challenge Solution 12.mp4

00:40

255 - CODE Minimum Wages Less Than Challenge Solution 12.html

256 - Gifts for Customers Greater Than Challenge Solution 13.mp4

02:10

257 - CODE Gifts for Customers Greater Than Challenge Solution 13.html

258 - Units In Stock Less Than Challenge Solution 14.mp4

01:26

259 - CODE Units In Stock Less Than Challenge Solution 14.html

260 - San Francisco Customers AND Challenge Solution 15.mp4

02:25

261 - CODE San Francisco Customers AND Challenge Solution 15.html

262 - Specific Mexico Customers AND Challenge Solution 16.mp4

01:37

263 - CODE Specific Mexico Customers AND Challenge Solution 16.html

264 - None USA and UK Customers NOT Challenge Solution 17.mp4

02:33

265 - CODE None USA and UK Customers NOT Challenge Solution 17.html

266 - Brazil and Venezuela Customers OR Challenge Solution 18.mp4

01:52

267 - CODE Brazil and Venezuela Customers OR Challenge Solution 18.html

268 - Range of Suppliers BETWEEN Challenges Solution 19.mp4

01:09

269 - CODE Range of Suppliers BETWEEN Challenges Solution 19.html

270 - Suppliers Combining OR Challenge Solution 20.mp4

00:32

271 - CODE Suppliers Combining OR Challenge Solution 20.html

272 - Range of Suppliers using BETWEEN Challenge Solution 21.mp4

01:14

273 - CODE Range of Suppliers using BETWEEN Challenge Solution 21.html

274 - NOT BETWEEN Challenge Solution 22.mp4

00:35

275 - CODE NOT BETWEEN Challenge Solution 22.html

276 - Customers in Paris Nantes France Challenge Solution 23.mp4

02:27

277 - CODE Customers in Paris Nantes France Challenge Solution 23.html

278 - Product List BETWEEN CONCAT FORMAT ORDER BY Challenge Solution 24.mp4

01:28

279 - CODE Product List BETWEEN CONCAT FORMAT ORDER BY Challenge Solution 24.html

280 - NULL values IS NULL IS NOT NULL Challenge Solution 25.mp4

01:09

281 - CODE NULL values IS NULL IS NOT NULL Challenge Solution 25.html

282 - Employees Report to 2 IS NOT NULL Challenge Solution 26.mp4

02:24

283 - CODE Employees Report to 2 IS NOT NULL Challenge Solution 26.html

284 - IN and WHERE Challenge Solution 27.mp4

01:47

285 - CODE IN and WHERE Challenge Solution 27.html

286 - NOT IN UK Germany France Customers Challenge Solution 28.mp4

01:55

287 - CODE NOT IN UK Germany France Customers Challenge Solution 28.html

26 - SQL Index

288 - Introduction to MySQL Index.mp4

03:26

289 - Creating Index Along a Table.mp4

01:22

290 - Code Creating Index Along a Table.html

291 - Creating Index on Existing Column.mp4

01:03

292 - CODE Creating Index on Existing Column.html

293 - Understanding Primary or Clustered Index.mp4

04:36

294 - Unique Key vs Index.mp4

02:09

295 - Key vs Index.mp4

02:49

296 - Verifying Index.mp4

02:02

297 - CODE Verifying Index.html

298 - Confirming the Power of Index.mp4

04:10

299 - CODE Confirming the Power of Index.html

300 - Deleting Index.mp4

01:18

301 - CODE Deleting Index.html

27 - SQL Wildcards

302 - Introduction to MySQL Wildcards.mp4

06:38

303 - MySQL Wildcard Customers Start With P Challenges Solution 1.mp4

01:44

304 - CODE MySQL Wildcard Customers Start With P Challenges Solution 1.html

305 - MySQL Wildcard Employees In Sales Challenges Solution 2.mp4

01:44

306 - CODE MySQL Wildcard Employees In Sales Challenges Solution 2.html

307 - MySQL Wildcard Phone Number Pattern Challenges Solution 3.mp4

02:48

308 - CODE MySQL Wildcard Phone Number Pattern Challenges Solution 3.html

309 - MySQL Wildcard Customers In Restaurant Business Challenges Solution 4.mp4

00:43

310 - CODE MySQL Wildcard Customers In Restaurant Business Challenges Solution.html

311 - MySQL Wildcard NOT LIKE Challenges Solution 5.mp4

01:04

312 - CODE MySQL Wildcard NOT LIKE Challenges Solution 5.html

28 - SQL Update Statement Replace Function

313 - Updating a Single Value in a Table.mp4

04:37

314 - CODE Updating a Single Value in a Table.html

315 - Updating Multiple Values in a Table.mp4

01:39

316 - CODE Updating Multiple Values in a Table.html

317 - Using UPDATE with REPLACE.mp4

04:04

318 - CODE Using UPDATE with REPLACE.html

319 - What is Storage Engine Lets Digress a little.mp4

02:58

29 - SQL Select Distinct Statement

320 - DISTINCT How it works.mp4

02:51

321 - CODE DISTINCT How it works.html

322 - DISTINCT ORDER BY DESC WHERE IS NOT Challenge Solution.mp4

02:22

323 - CODE DISTINCT ORDER BY DESC WHERE IS NOT Challenge Solution.html

30 - SQL Format Function

324 - How Format Function Works.mp4

01:29

325 - CODE How Format Function Works.html

326 - Data Cleaning Format Challenge Solution.mp4

00:58

327 - CODE Data Cleaning Format Challenge Solution.html

31 - SQL Group By Statement Aggregate

328 - GROUP BY True Meaning.mp4

10:02

329 - MIN MAX AVG SUM GROUP BY Challenge Solution 1.mp4

03:24

330 - CODE MIN MAX AVG SUM GROUP BY Challenge Solution 1.html

331 - GROUP BY SUMMINAVG CONCAT FORMAT Challenge Solution 2.mp4

02:03

332 - CODE GROUP BY SUMMINAVG CONCAT FORMAT Challenge Solution 2.html

333 - Region Count GROUP BY COUNT Challenge Solution 3.mp4

01:54

334 - CODE Region Count GROUP BY COUNT Challenge Solution 3.html

335 - Row Unique Value Count GROUP BY COUNT Challenge Solution 4.mp4

02:39

336 - CODE Row Unique Value Count GROUP BY COUNT Challenge Solution 4.html

337 - Product Count COUNT GROUP BY ORDER BY Challenge Solution 5.mp4

05:02

338 - CODE Product Count COUNT GROUP BY ORDER BY Challenge Solution 5.html

339 - Product Sold SUM GROUP BY Challenge Solution 6.mp4

02:27

340 - CODE Product Sold SUM GROUP BY Challenge Solution 6.html

341 - Most Hardworking Employee Challenge Solution 7.mp4

03:10

342 - CODE Most Hardworking Employee Challenge Solution 7.html

32 - SQL Joins Made Easy

343 - Resource for JOIN.html

343 - joins.zip

344 - Purpose of JOIN in SQL.mp4

03:11

345 - Type of JOIN in SQL.mp4

01:02

346 - Understanding INNER JOIN.mp4

04:34

347 - Understanding LEFT JOIN.mp4

04:42

348 - Understanding RIGHT JOIN.mp4

03:53

349 - Understanding FULL JOIN.mp4

03:11

33 - SQL Joins Deep Dive

350 - Overview of Tables Code for JOIN Demonstration.mp4

01:43

351 - CODE Overview of Tables Code for JOIN Demonstration.html

352 - INNER JOIN DEEP DIVE.mp4

21:03

353 - CODE INNER JOIN DEEP DIVE.html

354 - LEFT JOIN DEEP DIVE.mp4

15:07

355 - CODE LEFT JOIN DEEP DIVE.html

356 - RIGHT JOIN DEEP DIVE.mp4

06:02

357 - CODE RIGHT JOIN DEEP DIVE.html

358 - More On RIGHT JOIN and LEFT JOIN with Shipper Orders tables.mp4

07:45

359 - CODEMore On RIGHT JOIN and LEFT JOIN with Shipper Orders tables.html

360 - TableColumn vs Column only.mp4

14:16

34 - SQL Joins On vs Where On vs Using

361 - ON vs WHERE in INNER LEFT RIGHT JOIN.mp4

06:42

362 - ON vs USING in SQL JOIN Statement.mp4

03:37

35 - SQL Joins Challenges Solutions

363 - JOIN for Orders HandledManaged By Employee Challenge Solution 1.mp4

04:30

364 - CODE JOIN for Orders HandledManaged By Employee Challenge Solution 1.html

365 - Using JOIN for Products Their Suppliers Challenge Solution 2.mp4

03:22

366 - CODE Using JOIN for Products Their Suppliers Challenge Solution 2.html

367 - JOIN for Customers and Shippers Challenge Solution 3.mp4

01:56

368 - CODE JOIN for Customers and Shippers Challenge Solution 3.html

369 - JOIN Many Tables Customers and Names of Shipper Challenge Solution 4.mp4

04:54

370 - CODE JOIN Many Tables Customers and Names of Shipper Challenge Solution 4.html

36 - SQL Joining 1 2 3 4 5 6 7 8 9 10 Tables

371 - Please Read Me.html

371 - northwind-data-set.zip

372 - Schema.html

372 - Schema.pdf

373 - Simplifying the Schema used for JOIN in the following sections.mp4

05:26

37 - SQL One Table Join Self Join

374 - SelfJoin One Table Join Challenge and Solution 1.mp4

06:25

375 - CODE SelfJoin One Table Join Challenge and Solution 1.html

38 - SQL Two Tables Join

376 - Two Tables Join Challenge and Solution 2.mp4

01:20

377 - CODE Two Tables Join Challenge and Solution 2.html

378 - Two Tables Join Challenge and Solution 3.mp4

02:04

379 - CODE Two Tables Join Challenge and Solution 3.html

380 - Two Tables Join Challenge and Solution 4.mp4

01:05

381 - CODE Two Tables Join Challenge and Solution 4.html

382 - Two Tables Join Challenge and Solution 5.mp4

02:39

383 - CODE Two Tables Join Challenge and Solution 5.html

39 - SQL Three Tables Join

384 - Three Table Joins Challenge and Solution 6.mp4

02:16

385 - CODE Three Tables Join Challenge and Solution 6.html

386 - Three Tables Join Challenge and Solution 7.mp4

01:20

387 - CODE Three Tables Join Challenge and Solution 7.html

40 - SQL Four Tables Joins

388 - Four Tables Join Challenge and Solution 8.mp4

03:41

389 - CODE Four Tables Join Challenge and Solution 8.html

41 - SQL Five Tables Join

390 - Five Tables Join Challenge and Solution 9.mp4

05:34

391 - CODE Five Tables Join Challenge and Solution 9.html

392 - Five Tables Join Challenge and Solution 10.mp4

02:46

393 - CODE Five Tables Join Challenge and Solution 10.html

42 - SQL Six Tables Join

394 - Six Tables Join Challenge and Solution 11.mp4

01:29

395 - CODE Six Tables Join Challenge and Solution 11.html

43 - SQL Seven Tables Join

396 - Seven Tables Join Challenge and Solution 12.mp4

01:40

397 - CODE Seven Tables Join Challenge and Solution 12.html

44 - SQL Eight Tables Join

398 - Eight Tables Join Challenge and Solution 13.mp4

01:30

399 - CODE Eight Tables Join Challenge and Solution 13.html

45 - SQL Nine Tables Join

400 - Nine Tables Join Challenge and Solution 14.mp4

03:02

401 - CODE Nine Tables Join Challenge and Solution 14.html

46 - SQL Ten Tables Join

402 - Ten Tables Join Challenge and Solution For Demonstration Purpose.mp4

01:11

403 - CODE Ten Tables Join Challenge and Solution 15.html

47 - SQL Offset Limit

404 - Offset Limit Challenge Solution 1.mp4

06:21

405 - CODE Offset Limit Challenge Solution 1.html

406 - Offset Limit Third Highest Purchase Challenge Solution 2.mp4

02:38

407 - CODE Offset Limit Third Highest Purchase Challenge Solution 2.html

408 - Offset Limit First Three Highest Salary Challenge Solution 3.mp4

01:00

409 - CODE Offset Limit First Three Highest Salary Challenge Solution 3.html

410 - Offset Limit Fourth to the Lowest Salary Challenge Solution 4.mp4

01:14

411 - CODE Offset Limit Fourth to the Lowest Salary Challenge Solution 4.html

412 - OFFSET LIMIT First and Third Bestselling Products Challenge Solution 5.mp4

02:20

413 - CODE OFFSET LIMIT First and Third Bestselling Products Challenge Soluti.html

48 - SQL Case Function

414 - Understanding MySQL CASE.mp4

06:31

415 - CODE Understanding MySQL CASE.html

416 - CASE with IS NULL.mp4

02:23

417 - CODE CASE with IS NULL.html

418 - CASE FOR TYPE OF CUSTOMERS.mp4

06:52

419 - CODE CASE FOR TYPE OF CUSTOMERS.html

49 - SQL Cast Function

420 - CAST FROM STRING to DATE.mp4

01:02

421 - CODE CAST FROM STRING to DATE.html

422 - CAST FROM INTEGER to CHAR Challenge Solution 2.mp4

00:21

423 - CODE CAST FROM INTEGER to CHAR Challenge Solution 2.html

424 - CAST FROM STRING to DATE TIME Challenge Solution 3.mp4

00:56

425 - CODE CAST FROM STRING to DATE TIME Challenge Solution 3.html

426 - CAST FROM STRING to TIME Challenge Solution 4.mp4

00:31

427 - CODE CAST FROM STRING to TIME Challenge Solution 4.html

428 - CAST Order Date Without time Challenge Solution 5.mp4

01:07

429 - CODE CAST Order Date Without time Challenge Solution 5.html

430 - CAST FROM DATE to DATETIME Challenge Solution 6.mp4

01:44

431 - CODE CAST FROM DATE to DATETIME Challenge Solution 6.html

50 - SQL Nested Correlated Subqueries

432 - Introduction to subqueries.mp4

04:08

433 - Aggregate Function with Subqueries.mp4

04:18

434 - Nested Subquery Challenge Solution 1.mp4

04:05

435 - Many Subqueries Challenges Solution 2.mp4

06:00

51 - SQL Subqueries Exists Operator

436 - Exists Operator.mp4

01:10

437 - Subquery Exists Challenge Solution 1.mp4

04:34

438 - CODE Subquery Exists Challenge Solution 1.html

439 - Subquery Exists Challenge Solution 2.mp4

05:44

440 - CODE Subquery Exists Challenge Solution 2.html

52 - Difference Between Nested and Correlated Subqueries

441 - Difference Between Nested and Correlated Subqueries.mp4

09:41

53 - SQL String Functions

442 - SPACE FUNCTION Challenge Solution 1.mp4

00:56

443 - SPACE FUNCTION Challenge Solution 2.mp4

01:01

444 - REPEAT FUNCTION Challenge Solution 3.mp4

00:36

445 - REPEAT FUNCTION Challenge Solution 4.mp4

02:09

446 - REPLACE FUNCTION Challenge Solution 5.mp4

01:05

447 - REPLACE FUNCTION Challenge Solution 6.mp4

00:52

448 - REPLACE FUNCTION Challenge Solution 7.mp4

02:22

449 - REVERSE FUNCTION Challenge Solution 8.mp4

00:55

450 - REVERSE FUNCTION Challenge Solution 9.mp4

02:18

451 - LEFT FUNCTION Challenge Solution 10.mp4

01:53

452 - LEFT FUNCTION Challenge Solution 11.mp4

01:43

453 - RIGHT FUNCTION Challenge Solution 12.mp4

00:51

454 - RIGHT FUNCTION Challenge Solution 13.mp4

02:04

455 - RPAD FUNCTION Challenge Solution 14.mp4

01:31

456 - RPAD FUNCTION Challenge Solution 15.mp4

03:34

457 - LPAD FUNCTION Challenge Solution 16.mp4

02:34

458 - LPAD FUNCTION Challenge Solution 17.mp4

01:51

459 - LPAD FUNCTION Challenge Solution 18.mp4

04:58

460 - POSITION LOCATION FUNCTIONS Challenge Solution 19.mp4

01:55

461 - POSITION LOCATION FUNCTIONS Challenge Solution 20.mp4

01:23

462 - SUBSTRINGSUBSTR FUNCTION Challenge Solution 21.mp4

03:18

463 - SUBSTRINGSUBSTR FUNCTION Challenge Solution 22.mp4

02:53

464 - SUBSTRINGSUBSTR FUNCTION Challenge Solution 23.mp4

04:17

465 - SUBSTRINGSUBSTR FUNCTION Challenge Solution 24.mp4

01:30

466 - SUBSTRINGINDEX FUNCTION Challenge Solution 25.mp4

01:43

467 - SUBSTRINGINDEX FUNCTION Challenge Solution 26.mp4

01:02

468 - SUBSTRINGINDEX FUNCTION Challenge Solution 27.mp4

01:22

469 - SUBSTRINGINDEX FUNCTION Challenge Solution 28.mp4

01:11

470 - SUBSTRINGINDEX FUNCTION Challenge Solution 29.mp4

03:07

471 - MID FUNCTION Challenge Solution 30.mp4

01:09

472 - MID FUNCTION Challenge Solution 31.mp4

01:14

473 - INSERT FUNCTION Challenge Solution 32.mp4

03:25

474 - INSERT FUNCTION Challenge Solution 33.mp4

01:32

475 - INSTR FUNCTION Challenge Solution 34.mp4

01:31

476 - INSTR FUNCTION Challenge Solution 35.mp4

01:11

477 - LCASE LOWER FUNCTION Challenge Solution 35.mp4

00:55

478 - LCASE LOWER FUNCTION Challenge Solution 36.mp4

00:35

479 - UCASE UPPER FUNCTION Challenge Solution 37.mp4

00:36

480 - UCASE UPPER FUNCTION Challenge Solution 38.mp4

00:56

481 - UCASE UPPER FUNCTION Challenge Solution 39.mp4

00:55

482 - LENGTH FUNCTION Challenge Solution 40.mp4

01:02

483 - LENGTH FUNCTION Challenge Solution 41.mp4

01:01

484 - LTRIM FUNCTION Challenge Solution 42.mp4

02:04

485 - LTRIM FUNCTION Challenge Solution 43.mp4

01:34

486 - RTRIM FUNCTION Challenge Solution 44.mp4

01:08

487 - RTRIM FUNCTION Challenge Solution 45.mp4

01:17

488 - TRIM FUNCTION Challenge Solution 45.mp4

01:46

489 - TRIM FUNCTION Challenge Solution 46.mp4

00:49

54 - SQL Session

490 - Understanding MySQL Session.mp4

03:24

491 - CODE Understanding MySQL Session.html

55 - SQL Table Locking

492 - Table Locking Intro.mp4

01:51

493 - Table Locking Demonstration.mp4

04:40

494 - CODE Table Locking Demonstration.html

56 - SQL Transaction

495 - Brief Introduction to SQL Transaction.mp4

03:03

496 - TRANSACTION components START BEGIN BEGIN WORK COMMIT ROLLBACK SET.mp4

01:53

497 - CODE TRANSACTION components START BEGIN BEGIN WORK COMMIT ROLLBACK SET.html

498 - TRANSACTION By Example.mp4

06:10

499 - CODE TRANSACTION By Example.html

500 - NOT USING TRANSACTION.mp4

01:26

501 - CODE NOT USING TRANSACTION.html

502 - ROLLBACK.mp4

05:15

503 - CODE ROLLBACK.html

57 - SQL View

504 - Meaning of VIEW.mp4

04:34

505 - CODE Meaning of VIEW.html

506 - VIEW for Sales Manager Challenge Solution 1.mp4

02:03

507 - CODE VIEW for Sales Manager Challenge Solution 1.html

508 - VIEW for Employees hired in 1994 Challenge Solution 2.mp4

02:26

509 - CODE VIEW for Employees hired in 1994 Challenge Solution 2.html

510 - Updating VIEW Challenge Solution 3.mp4

02:48

511 - CODE Updating VIEW Challenge Solution 3.html

512 - A Mistake In VIEW Challenge Solution 4.mp4

02:21

513 - CODE A Mistake In VIEW Challenge Solution 4.html

514 - Deleting a VIEW Challenge Solution 5.mp4

01:31

515 - CODE Deleting a VIEW Challenge Solution 5.html

516 - VIEW for Japan Suppliers Challenge Solution 6.mp4

01:14

517 - CODE VIEW for Japan Suppliers Challenge Solution 6.html

518 - WHERE with Normal Table VIEW Table Challenge Solution 7.mp4

05:03

519 - CODE WHERE with Normal Table VIEW Table Challenge Solution 7.html

520 - INNER JOIN with Normal Table VIEW Table Challenge Solution 8.mp4

01:40

521 - CODE INNER JOIN with Normal Table VIEW Table Challenge Solution 8.html

58 - SQL Stored Procedures Stored Routines

522 - What is the meaning and purpose of Stored Procedure.mp4

06:59

523 - CODE What is the meaning and purpose of Stored Procedure.html

524 - How to create STORED PROCEDURE for cars table Challenge Solution 2.mp4

10:52

525 - CODE How to create STORED PROCEDURE for cars table Challenge Solution 2.html

526 - How to Modify STORED PROCEDURE Tesla Vehicles Challenge Solution 3.mp4

07:12

527 - CODE How to Modify STORED PROCEDURE Tesla Vehicles Challenge Solution 3.html

528 - How to check for STORED PROCEDURE across databases Challenge Soln 4.mp4

00:46

529 - CODE How to check for STORED PROCEDURE across databases Challenge Soln 4.html

530 - Check for STORED PROCEDURE in the current database Challenge Solution 5.mp4

01:25

531 - CODE Check for STORED PROCEDURE in the current database Challenge Soln 5.html

532 - Check for STORED PROCEDURE in a specified database Challenge Soln 6.mp4

01:53

533 - CODE Check for STORED PROCEDURE in a specified database Challenge Soln 6.html

534 - Deleting a STORED PROCEDURE Challenge Solution 7.mp4

01:28

535 - CODE Deleting a STORED PROCEDURE Challenge Solution 7.html

536 - STORED PROCEDURE Helping Purchasing Manager Challenge Solution 8.mp4

13:08

537 - CODE STORED PROCEDURE Helping Purchasing Manager Challenge Solution 8.html

538 - STORED PROCEDURE for Most Expensive Car Challenge Solution 9.mp4

08:39

539 - CODE STORED PROCEDURE for Most Expensive Car Challenge Solution 9.html

540 - STORED PROCEDURE for DATA INSERT to a table Challenge Solution 10.mp4

06:12

541 - CODE STORED PROCEDURE for DATA INSERT to a table Challenge Solution 10.html

59 - SQL Userdefined Functions Stored Routine

542 - What is FUNCTION in SQL.mp4

02:01

543 - CODE What is FUNCTION in SQL.html

544 - Creating Addition FUNCTION Challenge Solution 2.mp4

06:56

545 - CODE Creating Addition FUNCTION Challenge Solution 2.html

546 - How to check for FUNCTION Challenge Solution 3.mp4

01:33

547 - CODE How to check for FUNCTION Challenge Solution 3.html

548 - Creating Pythagoras Theorem FUNCTION Challenge Solution 4.mp4

03:18

549 - CODE Creating Pythagoras Theorem FUNCTION Challenge Solution 4.html

550 - Altering or Updating FUNCTION Challenge Solution 5.mp4

04:36

551 - CODE Altering or Updating FUNCTION Challenge Solution 5.html

552 - Creating FUNCTION for Order details Line Total Challenge Solution 6.mp4

05:33

553 - CODE Creating FUNCTION for Order details Line Total Challenge Solution 6.html

554 - Deleting a FUNCTION Challenge Solution 7.mp4

01:41

555 - CODE Deleting a FUNCTION Challenge Solution 7.html

60 - SQL Triggers

556 - The Purpose The How and Types of TRIGGER.mp4

05:31

557 - TRIGGER More Explanation With Diagram.mp4

03:31

558 - Steps to Creating a TRIGGER Challenge Solution 1a.mp4

08:15

559 - Creating After Update TRIGGER Challenge Solution 1b.mp4

09:28

560 - CODE Creating After Update TRIGGER Challenge Solution 1b.html

561 - How to Check and Delete a TRIGGER Challenge Solution 1c.mp4

00:36

562 - CODE How to Check and Delete a TRIGGER Challenge Solution 1c.html

563 - Creating After Update TRIGGER Another Method Challenge Solution 1d.mp4

06:31

564 - CODE Creating After Update TRIGGER Another Method Challenge Solution 1d.html

565 - Creating Conditional Update TRIGGER Different Names Challenge Solution 2.mp4

09:10

566 - CODE Creating Conditional Update TRIGGER Different Names Challenge Soln 2.html

567 - Creating AfterUpdate MySQL TRIGGER Above USD5k Challenge Solution 3.mp4

07:23

568 - CODE Creating AfterUpdate MySQL TRIGGER Above USD5k Challenge Solution 3.html

569 - After Insert Error Message MySQL TRIGGER Challenge Solution 4.mp4

04:08

570 - CODE After Insert Error Message MySQL TRIGGER Challenge Solution 4.html

571 - TRIGGER with SIGNAL SQLSTATE for Null Value Challenge Solution 5.mp4

07:14

572 - CODE TRIGGER with SIGNAL SQLSTATE for Null Value Challenge Solution 5.html

573 - Multiple lines of TRIGGER Many in One Challenge Solution 6.mp4

06:50

574 - CODE Multiple lines of triggers Many in One Challenge Solution 6.html

575 - SQL SIGNAL SQLSTATE ERROR MESSAGE TRIGGER Challenge Solution 7.mp4

03:05

576 - CODE SQL SIGNAL SQLSTATE ERROR MESSAGE TRIGGER Challenge Solution 7.html

577 - Fraud Detection After Delete TRIGGER Challenge Solution 8.mp4

04:03

578 - CODE Fraud Detection After Delete TRIGGER Challenge Solution 8.html

61 - RESEARCH DATA SET A Complete Example Lots Of Challenges Solutions

579 - Setting up database for challenges with attached downloadable resource.mp4

01:14

579 - research.zip

580 - Nested Subquery JOIN methods 1million Challenge Solution 1.mp4

03:57

581 - CODENested Subquery JOIN methods 1million Challenge Solution 1.html

582 - Nested Subquery Budget above average Challenge Solution 2.mp4

01:46

583 - CODE Nested Subquery Budget above average Challenge Solution 2.html

584 - Nested Subquery More Query Tweaking Challenge Solution 3.mp4

13:12

585 - CODE Nested Subquery More Query Tweaking Challenge Solution 3.html

586 - Nested Subquery INNER JOIN GROUP BY HAVING Challenge Solution 4.mp4

09:27

587 - CODE Nested Subquery INNER JOIN GROUP BY HAVING Challenge Solution 4.html

62 - CAR SHOP DATA SET A Complete Example Lots Of Challenges Solutions

588 - Intro.mp4

00:17

589 - CarShop Resource Details.mp4

03:02

589 - carshop.zip

590 - Fetching Names of Cars Challenge Solution 1.mp4

00:33

591 - Names Price of Cars Challenge Solution 2.mp4

00:20

592 - Cars at a specific price Challenge Solution 3.mp4

00:31

593 - Between two prices of cars Challenge Solution 4.mp4

01:31

594 - Counting Cars Challenge Solution 5.mp4

00:41

595 - Price List of Cars Challenge Solution 6.mp4

01:13

596 - Price List For Cambodia Customers Challenge Solution 7.mp4

08:26

597 - Car Average Price Challenge Solution 8.mp4

00:31

598 - The most expensive car Challenge Solution 9.mp4

01:01

599 - Most Expensive Cars Challenge Solution 10.mp4

06:17

600 - Honda Toyota Challenge Solution 11.mp4

02:07

601 - All details from two tables Challenge Solution 12.mp4

01:18

602 - Specific fields from two tables Challenge Solution 13.mp4

01:31

603 - Counting Cars Per Manufacturer Challenge Solution 14.mp4

04:34

604 - Average Price Per Manufacturer Challenge Solution 15.mp4

01:37

605 - Manufacturer Average Car Price Above 35000 Challenge Solution 16.mp4

01:07

606 - The Cheapest Car Challenge Solution 17.mp4

01:58

607 - The Most Expensive Car Challenge Solution 18.mp4

05:21

608 - Data Insert Challenge Solution 19.mp4

02:00

609 - Correcting Wrong Data Challenge Solution 20.mp4

00:49

610 - Discounted Prices I Challenge Solution 21.mp4

02:33

611 - Discounted Price II Challenge Solution 22.mp4

01:07

612 - VIEW for price list Challenge Solution 23.mp4

04:50

63 - CAMERA SUPPLIERS DATA SET A Complete Example Lots Of Challenges Solutions

613 - Read Me First.html

613 - camera.zip

614 - What is the current database selected Assignment 1.mp4

00:04

615 - What is the current database selected Assignment 1 Solution.mp4

00:40

616 - What are the available tables in the database Assignment 2.mp4

00:04

617 - What are the available tables in the database Assignment 2 Solution.mp4

00:17

618 - Display the details of each of the table in the database Assignment 3.mp4

00:08

619 - Display the details of each of the table in the database Assignment 3 Solution.mp4

01:50

620 - SQL Query to retrieve data from one table Assignment 4.mp4

00:05

621 - SQL Query to retrieve data from one table Solution to Assignment 4.mp4

00:24

622 - Using Alias Assignment 5.mp4

00:07

623 - Using Alias Solution to Assignment 5.mp4

00:58

624 - Retrieving data across two tables using JOIN Assignment 6.mp4

00:56

625 - Retrieving data across two tables using JOIN Solution to Assignment 6.mp4

03:08

626 - Retrieving data across three tables using JOIN Assignment 7.mp4

00:33

627 - Retrieving data across three tables using JOIN Solution to Assignment 7.mp4

02:39

628 - Aggregate sum average minimum maximum Assignment 8.mp4

00:11

629 - Aggregate sum average minimum maximum Solution to Assignment 8.mp4

02:07

630 - GROUP BY Average Assignment 9.mp4

00:13

631 - GROUP BY Average Solution to Assignment 9.mp4

03:56

632 - GROUP BY RIGHT LEFT INNER NO JOIN Assignment 10.mp4

00:52

633 - GROUP BY RIGHT LEFT INNER NO JOIN Solution to Assignment 10.mp4

08:12

634 - VIEW for three tables JOIN Assignment 11.mp4

00:20

635 - VIEW for three tables JOIN Solution to Assignment 11.mp4

02:54

636 - INNER JOIN Subquery EXISTS Assignment 12.mp4

00:06

637 - INNER JOIN Subquery EXISTS Solution to Assignment 12.mp4

02:54

638 - Updating Table with 5 Increase in Salary Assignment 13.mp4

00:13

639 - Updating Table with 5 Increase in Salary Solution Assignment 13.mp4

00:52

640 - INNER JOIN and SubQuery Assignment 14.mp4

02:33

641 - INNER JOIN and SubQuery Solution Assignment 14.mp4

05:08

642 - INNER JOIN AND Assignment 15.mp4

00:11

643 - INNER JOIN AND Solution Assignment 15.mp4

02:52

644 - INNER JOIN SubQuery Assignment 16.mp4

00:10

645 - INNER JOIN SubQuery Solution to Assignment 16.mp4

02:17

646 - SUBQUERY LIMIT Assignment 17.mp4

00:11

647 - SUBQUERY LIMIT Solution to Assignment 17.mp4

02:54

648 - UCASE Assignment 18.mp4

00:10

649 - UCASE Solution to Assignment 18.mp4

00:17

64 - MORE TASKS The More You Do The More You Learn

650 - More Tasks.html

65 - SQL More Task 1

651 - Employees With Same Salary Task 1.mp4

00:09

652 - Solution Employees With Same Salary Task 1.mp4

07:07

653 - CODE Employees With Same Salary Task 1.html

66 - SQL More Task 2

654 - Duplicate Title Task 2.mp4

00:09

655 - Solution Duplicate Title Task 2.mp4

01:08

656 - CODE Duplicate Title Task 2.html

67 - SQL More Task 3

657 - Excluding Titles Task 3.mp4

00:10

658 - Solution Excluding Titles Task 3.mp4

00:29

659 - CODE Excluding Titles Task 3.html

68 - SQL More Task 4

660 - Eight Last Alphabet n Task 4.mp4

00:12

661 - Solution Eight Last Alphabet n Task 4.mp4

00:35

662 - CODE Eight Last Alphabet n Task 4.html

69 - SQL More Task 5

663 - Even Rows Task 5.mp4

00:06

664 - Solution Even Rows Task 5.mp4

00:55

665 - CODE Even Rows Task 5.html

70 - SQL More Task 6

666 - Odd Rows Task 6.mp4

00:06

667 - Solution Odd Rows Task 6.mp4

00:46

668 - CODE Odd Rows Task 6.html

71 - SQL More Task 7

669 - Second to Fourth Task 7.mp4

00:10

670 - Solution Second to Fourth Task 7.mp4

00:32

671 - CODE Second to Fourth Task 7.html

72 - SQL More Task 8

672 - Counting Employee with SALES Task 8.mp4

00:07

673 - Solution Counting Employee with SALES Task 8.mp4

00:17

674 - CODE Counting Employee with SALES Task 8.html

73 - SQL More Task 9

675 - Using Sub Query Second to the Highest Salary Task 9.mp4

00:10

676 - Solution Using Sub Query Second to the Highest Salary Task 9.mp4

01:59

677 - CODE Using Sub Query Second to the Highest Salary Task 9.html

74 - SQL More Task 10

678 - Tricky Exercise Task 10.mp4

00:10

679 - Solution Tricky Exercise Task 10.mp4

01:01

680 - CODE Tricky Exercise Task 10.html

75 - SQL More Task 11

681 - Tricky Exercise Task 11.mp4

00:37

682 - Solution Tricky Exercise Task 11.mp4

02:59

683 - CODE Tricky Exercise Task 11.html

76 - SQL More Task 12

684 - Tricky Exercise Task 12.mp4

00:15

685 - Solution Tricky Exercise Task 12.mp4

08:39

686 - CODE Tricky Exercise Task 12.html

687 - Tricky Exercise Task 12b.mp4

00:19

688 - Solution Tricky Exercise Task 12b.mp4

00:35

689 - CODE Tricky Exercise Task 12b.html

77 - SQL More Task 13

690 - Tricky Exercise Task 13.mp4

00:15

691 - Solution Tricky Exercise Task 13.mp4

06:23

692 - CODE Tricky Exercise Task 13.html

78 - SQL More Task 14

693 - Tricky Exercise Task 14.mp4

00:15

694 - Solution Tricky Exercise Task 14.mp4

02:56

695 - CODE Tricky Exercise Task 14.html

79 - SQL PAUSE and LEARN Using Fewer Columns Subquery in JOINS

696 - Using Fewer Columns From SUBQUERY With JOIN.mp4

05:39

697 - CODE Using Fewer Columns From SUBQUERY With JOIN.html

698 - Using WITH SUBQUERY INNER JOIN.mp4

02:36

699 - CODE Using WITH SUBQUERY INNER JOIN.html

80 - SQL More Task 15

700 - Tricky Exercise Task 15.mp4

00:35

701 - Solution Tricky Exercise Task 15.mp4

06:49

702 - CODE Tricky Exercise Task 15.html

81 - SQL More Task 16

703 - Tricky Exercise task 16.mp4

00:09

704 - Solution Tricky Exercise task 16.mp4

00:28

705 - CODE Tricky Exercise task 16.html

82 - SQL More Task 17

706 - Tricky Exercise Task 17.mp4

00:16

707 - Solution Tricky Exercise Task 17.mp4

07:09

708 - CODE Tricky Exercise Task 17.html

83 - SQL DATEFORMAT Understanding Me First Before Task 18

709 - Introduction.mp4

01:16

710 - Day of the Week.mp4

02:16

711 - Day of the Month.mp4

01:30

712 - Day of the Year.mp4

00:59

713 - Week of the Year.mp4

01:58

714 - Month of the Year.mp4

01:07

715 - Year from given DateTime.mp4

00:18

716 - Second Minute Hour AM and PM from DateTime.mp4

02:17

84 - SQL More Task 18

717 - Tricky Exercise Task 18.mp4

00:45

718 - Solution Tricky Exercise Task 18.mp4

05:44

719 - CODE Tricky Exercise Task 18.html

85 - EXTRA SECTION Combining SQL MySQL and Python

720 - Introduction to Combining SQL and Python.mp4

01:38

86 - Combining SQL and Python Installation of MySQL Connector

721 - Installation of MySQL Connector for Python.mp4

02:34

722 - CODE Installation of MySQL Connector for Python.html

87 - Combining SQL and Python Create Database Table Show Describe Table

723 - Creating Database Show Databases From Python.mp4

06:01

724 - CODE Creating Database Show Databases From Python.html

724 - CreateDatatabase.html

725 - Creating a Table Show Table Describe Table.mp4

01:24

726 - CODE Creating a Table Show Table Describe Table.html

726 - CreateTable.html

88 - Combining SQL and Python Insert a Row Insert Multiple Rows Select

727 - Insert A Row of Data Into A Table Select.mp4

02:30

728 - CODE Insert A Row of Data Into A Table Select.html

729 - Insert Multiple Rows of Data Into A Table.mp4

03:27

730 - CODE Insert Multiple Rows of Data Into A Table.html

730 - Insert-Multipl-Rows.html

89 - Combining SQL and Python Row Counting FetchOne FetchAll

731 - Counting the numbers of rows.mp4

00:40

732 - CODE Counting the numbers of rows.html

733 - FetchOne vs FetchAll.mp4

01:17

734 - CODE FetchOne vs FetchAll.html

90 - Combining SQL and Python Filter Wildcard

735 - Select Filter with Python.mp4

01:06

736 - CODE Select Filter with Python.html

737 - SQL Wildcard with Python.mp4

03:08

738 - CODE SQL Wildcard with Python.html

91 - EXTRA SECTION Business Intelligence and Analytics with Tableau SQL

739 - Introduction to this section.html

92 - Combining SQL and Tableau Business Intelligence Introduction

740 - Business Intelligence Introduction Definition.mp4

01:51

741 - Business Intelligence Process.mp4

03:14

93 - Combining SQL and Tableau Tableau Installation

742 - How to Download and Install Tableau.mp4

01:04

94 - Combining SQL and Tableau WhatIsWhat In Tableau

743 - Tableau WhatIsWhat In Tableau I.mp4

02:21

744 - Tableau WhatIsWhat In Tableau II.mp4

08:12

745 - Tableau WhatIsWhat In Tableau III.mp4

01:24

95 - Combining SQL and Tableau Connecting MySQL to Tableau

746 - Connecting MySQL to Tableau.mp4

04:29

96 - Combining SQL and Tableau Database Querying Visualisation

747 - Tableau MySQL Querying SQL Database from Tableau.mp4

01:24

748 - Tableau MySQL Visualising CarShop Dataset.mp4

03:50

97 - Combining SQL and Tableau Challenge Solution

749 - Tableau SQL Challenge Gross Sales and Net Sales Report.mp4

06:13

98 - Congratulation

750 - Check out my other courses.html

Description

MySQL for Data Analytics, Database Management, Business Intelligence & Analysis. Master SQL & Tableau. Create Reports!

What You'll Learn?

Write complex queries with View, Stored Procedure, Trigger, Transaction, User-defined Function, Session, Table Locking and many more
Start from beginner level to expert level and build real-world report with SQL
Use Python to create databases, tables and write queries. Use tableau to report your data
Write complex queries to retrieve information from single and across multiple tables by using Nested & Correlated Subqueries
Write complex queries to retrieve data across multiple tables by using Left, Right, Inner and Full Outer joins queries
Learn by doing tons of real-world SQL projects, challenges & assignment with solutions
Learn to use complex sorting, filtering, extracting and aggregating queries to analyse data
Pass your next BI , Data Analysts and Data Science Interviews and Vivas
This SQL MySQL tutorial cover SQL Foundations, SQL beginners, SQL intermediate and SQL expert levels training
Join and retrieve data from One, Two, Three, Four, Five, Six, Seven, Eight, Nine and Ten tables

Who is this for?

All Levels - Beginners, Intermediate & Experts

What You Need to Know?

No programming experience is needed - I'll teach you everything you need to know

No paid software required - everything will be done with MySQL Workbench (which is free)

A Mac laptop/iMac or a Windows PC

I'll walk you through, step-by-step on how to get MySQL Workbence installed and set up

This SQL MySQL tutorial will move you from zero to hero

I'll walk you through on how to get MySQL Connector to run with Python

More details

Description
Hello and welcome to SQL â€“ MySQL: Complete Master Bootcamp | Beginner-Expert!
Learn and understand the skills you need to become a master of SQL & MySQL using real-world projects. Learn to build real-life data analytic reports with complex queries. Start learning from scratch to advanced topics in SQL with Instructor support: Ask questions and get quick responses.
This course is updated frequently with new lessons, projects, and resources!

Start Learning SQL TODAY!

#Reviews about this course
"This course was very in-depth, it does take a lot of time and focus but was certainly worth it. I would highly recommend it to anyone that is looking to further advance or start a SQL career."
"Thanks for sharing such valuable information."
"It's an interesting well explained course for beginners with enough practice material to get a hold on concepts. I am building more & more knowledge & interest at each micro-step"
"Such a great match! So far he explains it in lamen's terms that are incredibly easy to understand. I am looking forward to more!"
"It is a great opportunity to learn valuable things which can boost you for a perfect job. The Instructor has the talent to transfer knowledge. Watch the videos, and Practice more and more. One of my best courses. Probably the best!"
"I learned a lot of stuff. This course contains a lot of information and is well organized. Really good teacher!"

WHOÂ ISÂ THISÂ COURSEÂ FOR?Â
For Beginner, Intermediate & ExpertÂ Level (such as SQL fundamentals, SQL essential, intermediary SQL & advanced SQL).
This course is for you if you are tired of SQL courses that are too brief, too simple, or too complicated.
This course is for you if you want to build a real-world database, reports, and projects with SQL & connect to Python.
This course is for you if you want to master the in-and-out of SQL queries including complex and advanced queries.
This course is for you if you want to learn MySQL by doing exciting real-life challenges that will distinguish you from the crowd.
This course is for you if you want to learn Advanced SQL for Business Analysis, Marketing, and Data Management.
This course is for you if you've discovered without SQL you can't do much with data analytics, data science, machine learning, AI, or become a better developer.
This course is for you if you want to master SQL which you can also use for Oracle SQL, Microsoft SQL Server, SQL Lite, and PostgreSQL.
This MySQL tutorial course is for you if you plan to pass SQL Interview for Data, Business, and Financial Analytics, DataÂ Science, Data Modeller, &Â Database administration.
This course will teach you in detail such as stored procedures, view, transactions, functions, nested and correlated subquery, and several other tips you don't in other MySQL courses.

This course covers all the following (and many more) both the theory, practical with hands-on exercises with the solutions:
Introduction to SQL
Installation MySQL
Select Statement
Database
Table
Data Types
Insert Query
Candidate, Surrogate, Primary, Alternative & Foreign Key
Primary and Foreign Key Constraints | Alter Table
Alias (AS)
Concat Function
Order By Keyword
Limit Clause
Order By & Rand Function
Comments
Where Clause
Index
Wildcards
Update Statement & Replace Function
Select Distinct Statement
Format Function
Group By Statement | Aggregate
Inner Join
Left Join
Right Join
Self Join
Two Tables Join
Three Tables Join
Four Tables Join
Five Tables Join
Six Tables Join
Seven Tables Join
Eight Tables Join
Nine Tables Join
Ten Tables Join
Offset & Limit
Case Function
Cast Function
Nested & Correlated Subqueries
Subqueries & Exits Operator
String Function
Session
Table Locking
Transaction
View
Stored Procedures (Stored Routines)
User-Defined Functions (Stored Routine)
Triggers
Combining SQL and Python
Combining SQL and Tableau
Research Data Set - Real-World Datasets
CAR SHOP DATA SET - Real-World Datasets
CAMERA SUPPLIERS - Real-World Datasets
With all of the above and many more plus the support, assistance, and guidance of the instructor throughout this complete high-quality guide you will gain numerous skills that will boost your career.
Your understanding of SQL through MySQL is highly valuable.
Whether you are a beginner or a professional desiring to gain more knowledge in SQL, this course is for you. You will be learning from experts with over two decades of experience.
What are you waiting for? Enroll now and let's get started!
Who this course is for:
All Levels - Beginners, Intermediate & Experts

User Reviews

Rating

average 0

Total votes0

Focused display

Donatus holds a first degree in Electrical Engineering with first class, MSc in Computer Science, Ph.D. in Management, and more than fifteen (15) industrial certificates. For over two decades, Don has worked as Process Engineer, Network Architect, Project Manager, and Data Scientist in Banking, Oil & Gas, and IT industries.With several years of experience in teaching, Donatus has empowered many IT professionals in the area of Network Engineering, Programming, Data Science, and Machine learning both offline and online. He provides training on data science and related courses to individual and corporate clients. Many students who graduated from his classes end up gaining full-time employment. He had also taught in India, Singapore, and Malaysia. He understands what makes students enjoy lectures and what makes them assimilate with ease.His recent focus is to bring you the best training in Database, Data Science, Machine Learning, and related courses.Do you have an interest in learning with a lot of practice?Join him right away!Industrial Certificates:1 - Project Management Professional (PMP) – Above Target2 - Neo4j Certified Professional3 - Check Point Certified Security Expert (CCSE)4 - Check Point Certified Security Administrator (CCSA)5 - Cisco Certified Network Professional (CCNP)6 - Cisco Certified Network Associate (CCNA)7 - Cisco Certified Design Professional (CCDP)8 - Cisco Certified Design Associate (CCDA)9 - Cisco Certified Network Professional Voice (CCNPv)10 - Cisco Certified Network Associate Voice (CCNAv)11 - Cisco Advanced Wireless Field Specialist12 - Certified Wireless Security Professional (CWSP)13 - Certified Wireless Network Administrator (CWNA)14 - Juniper Networks Certified Internet Specialist (JNCIS) 15 - CompTia Security+ Certified Professional16 - NEBOSH International General Certificate (NEBOSH)17 - BS OHSAS Internal Auditor Certificate (OHSAS 18001:2007)18 - IOSH Managing Safely (IOSH)19 - IOSH Working Safely (IOSH)

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.