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

سرفصل های دوره

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

1 - Introduction Installation Resources Database Select and CRUD Updated

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

2 - Introduction to SQL

3 - Installation Introduction

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

7 - Installation RESOURCES Installation of MySQL on MacOS.html

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

9 - Installation Installation of MySQL Server and Workbench on Windows

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

11 - Database Database as a house Introduction

12 - 2-Creating-a-Database.txt

12 - Database Creating a Database

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

13 - Database Creating a Database with IF NOT EXISTS

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

14 - Database How to use a Database

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

15 - Database Finding Out the Currently Selected Database

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

16 - Database Checking If a Database Exists

17 - 7-Deleting-a-Database.txt

17 - Database Deleting a Database

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

18 - Database Deleting a Database If It Exists

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

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

24 - CRUD Understanding CRUD

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

28 - Data Types Introduction

2 - ARCHIVED SQL Select Statement

29 - SELECT Understanding Select for Absolute beginners

3 - ARCHIVED SQL Database

30 - Database vs Table In SQL Laymans Explanation Challenge Solution

31 - Creating A Database Challenge Solution 1

32 - CODE Creating A Database Challenge Solution 1.html

33 - IF NOT EXISTS with CREATE DATABASE Challenge Solution 2

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

35 - How To Check For Existing Databases Challenge Solution 3

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

37 - How To Delete A Database Challenges Solution 4

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

39 - Using A Database Challenge Solution 5

40 - CODE Using A Database Challenge Solution 5.html

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

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

44 - Integer Types INTEGER or INT SMALLINT TINYINT MEDIUMINT BIGINT

45 - Clients Integer Data Types Requirement Scenario

46 - CODE Clients Integer Data Types Requirement Scenario.html

47 - Boolean Type tinyint1

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

52 - Clients FixedPoint Data Types Requirement Scenario

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

57 - Clients FloatingPoint Data Types Requirement Scenario

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

62 - Clients Bit Data Types Requirement Scenario

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

67 - The CHAR and VARCHAR Types

68 - Clients CHAR and VARCHAR Types Requirement Scenario

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

73 - Clients BINARY and VARBINARY Types Requirement Scenario

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

78 - Clients BLOB and TEXT Types Requirement Scenario

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

83 - Clients ENUM Types Requirement Scenario

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

88 - Clients SET Types Requirement Scenario

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

93 - DATE TIME Types

94 - Clients Date and Time Types Requirement Scenario

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

99 - Spatial Data Types

100 - Clients Spatial Types Requirement Scenario

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

105 - Clients JSON Types Requirement Scenario

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

110 - MySQL Numeric Types

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

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

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

114 - REAL FLOAT DOUBLE Floating Point Data Type in MySQL

115 - CHAR vs VARCHAR String Data Types in MySQL

116 - BINARY VARBINARY String Data Types in MySQL

117 - BLOB TEXT String Data Types in MySQL

118 - ENUM String Data Types in MySQL

119 - SET String Data Types in MySQL

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

10 - MySQl AutoIncrement WHERE In Brief

121 - 1-Auto-Increment.txt

121 - MySQL Auto Increment

122 - 19-MySQL-Default.txt

122 - MySQL Default

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

123 - MySQL Null and NOT Null

124 - 2-WHERE-in-Brief.txt

124 - WHERE A brief Intro

11 - MySQL Insert Query Updated

125 - 3-Basic-Insert.txt

125 - SQL Basic Insert

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

126 - SQL Inserting Multiple Rows at Once

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

127 - SQL Inserting Data from Another Table

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

128 - SQL Inserting with a Set Clause

12 - ARCHIVED SQL Insert Query

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

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

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

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

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

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

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

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

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

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

139 - Inserting Null Value and Empty White Space Into Table

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

142 - 2-Unique-Key.txt

142 - Unique Key in SQL

143 - 3-Primary-Key.txt

143 - Primary Key in SQL

144 - Candidate and Alternate Keys in SQL

145 - Composite Compound Key in SQL

146 - Natural Key in SQL

147 - Surrogate Key in SQL

148 - Super Key in SQL

149 - 8-Foreign-Key.txt

149 - Foreign Key in SQL

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

153 - Surrogate Key In SQL

154 - Primary Key Alternative Key In SQL

155 - Foreign Key In SQL

15 - SQL Alter Table UPDATED

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

156 - Alter Table Intro Adding a New Column

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

157 - Alter Table Dropping an Existing Column

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

158 - Alter Table Modify Column Type and Size

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

159 - Alter Table Drop Primary Key

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

160 - Alter Table Add Primary Key

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

161 - Alter Table Add Unique Constraint

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

162 - Alter Table Rename Column

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

163 - Alter Table Add Foreign Key

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

164 - Alter Table Rename Table

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

165 - Alter Table Add Default to Column

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

166 - Alter Table Drop Default from a Column

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

167 - Alter Table Drop Foreign Key

16 - SQL Deleting Records

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

168 - Introduction to delete Deleting Specific Records

169 - 2-Delete-multiple-records.txt

169 - Delete multiple records

170 - 3-Delete-all-records.txt

170 - Delete all records

171 - 4-Truncate-Table.txt

171 - Truncate Table

172 - 5-deleting-a-table.zip

172 - Deleting a Table

173 - 6-Delete-Cascade.txt

173 - Delete Cascade

17 - ARCHIVED SQL Primary and Foreign Key Constraints Alter Table

174 - Assigning A PRIMARY KEY Three Methods Challenge Solution 1

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

176 - Deleting A PRIMARY KEY Challenge Solution 2

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

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

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

180 - Assigning A FOREIGN KEY Challenge Solution 4

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

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

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

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

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

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

188 - Deleting A REFERENCED Parent Table Challenge Solution 8

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

190 - Deleting A Column From A Table Challenge Solution 9

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

192 - Deleting A REFERENCED or CONSTRAINT Column Challenge Solution 10

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

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

196 - Select Specific Columns Challenge Solution 2

197 - CODE Select Specific Columns Challenge Solution 2.html

198 - Manager Demands for All Customers Detail Challenge Solution 3

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

200 - Specific Customers Details Challenge Solution 4

201 - CODE Specific Customers Details Challenge Solution 4.html

19 - SQL Alias AS

202 - ALIAS AS Introduction

203 - CODE ALIAS AS Introduction.html

204 - Alias Challenge Solution

205 - CODE Alias Challenge Solution.html

20 - SQL Concat Function

206 - CONCAT Introduction

207 - CODE CONCAT Introduction.html

208 - CONCAT Challenge Solution 1

209 - CODE Challenge Solution 1 CONCAT.html

210 - CONCAT Challenge Solution 2

211 - CODE Challenge Solution 2 CONCAT.html

21 - SQL Order By Keyword

212 - ORDER BY Introduction

213 - ORDER BY ASC Challenge Solution 1

214 - CODE ORDER BY ASC Challenge Solution 1.html

215 - ORDER BY DESC Challenge Solution 2

216 - CODE ORDER BY DESC Challenge Solution 2.html

217 - ORDER BY DESC CONCAT Challenge Solution 3

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

219 - ORDER BY ASC Challenge Solution 4

220 - CODE ORDER BY ASC Challenge Solution 4.html

22 - SQL Limit Clause

221 - LIMIT Challenge Solution 1

222 - CODE LIMIT Challenge Solution 1.html

223 - LIMIT Challenge Solution 2

224 - CODE LIMIT Challenge Solution 2.html

225 - LIMIT Challenge Solution 3

226 - CODE LIMIT Challenge Solution 3.html

23 - SQL Order By Rand Function

227 - ORDER BY with RAND Challenge Solution

228 - CODE ORDER BY with RAND Challenge Solution.html

24 - SQL Comments

229 - SINGLE MULTILINE COMMENTS in SQLMySQL

25 - SQL Where Clause

230 - Introduction to WHERE

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

231 - northwind-data-set.zip

232 - UK Customers filter Challenge Solution 1

233 - CODE UK Customers filter Challenge Solution 1.html

234 - Specific Customer filter Challenge Solution 2

235 - CODE Specific Customer filter Challenge Solution 2.html

236 - Specific Employee filter Challenge Solution 3

237 - CODE Specific Employee filter Challenge Solution 3.html

238 - Product with specific Price filter Challenge Solution 4

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

240 - Getting a list of Sales Representatives Challenge Solution 5

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

242 - None Spanish Customers using Challenge Solution 6

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

244 - Products Supplied by a Specific Customer Challenge Solution 7

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

246 - All Suppliers Except using NOT Challenge Solution 8

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

248 - Products above certain Price Greater Than Challenge Solution 9

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

250 - Products Below Certain Price Less Than Challenge Solution 10

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

252 - Unit In Stock Less Than Challenge Solution 11

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

254 - Minimum Wages Less Than Challenge Solution 12

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

256 - Gifts for Customers Greater Than Challenge Solution 13

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

258 - Units In Stock Less Than Challenge Solution 14

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

260 - San Francisco Customers AND Challenge Solution 15

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

262 - Specific Mexico Customers AND Challenge Solution 16

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

264 - None USA and UK Customers NOT Challenge Solution 17

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

266 - Brazil and Venezuela Customers OR Challenge Solution 18

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

268 - Range of Suppliers BETWEEN Challenges Solution 19

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

270 - Suppliers Combining OR Challenge Solution 20

271 - CODE Suppliers Combining OR Challenge Solution 20.html

272 - Range of Suppliers using BETWEEN Challenge Solution 21

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

274 - NOT BETWEEN Challenge Solution 22

275 - CODE NOT BETWEEN Challenge Solution 22.html

276 - Customers in Paris Nantes France Challenge Solution 23

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

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

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

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

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

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

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

284 - IN and WHERE Challenge Solution 27

285 - CODE IN and WHERE Challenge Solution 27.html

286 - NOT IN UK Germany France Customers Challenge Solution 28

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

26 - SQL Index

288 - Introduction to MySQL Index

289 - Creating Index Along a Table

290 - Code Creating Index Along a Table.html

291 - Creating Index on Existing Column

292 - CODE Creating Index on Existing Column.html

293 - Understanding Primary or Clustered Index

294 - Unique Key vs Index

295 - Key vs Index

296 - Verifying Index

297 - CODE Verifying Index.html

298 - Confirming the Power of Index

299 - CODE Confirming the Power of Index.html

300 - Deleting Index

301 - CODE Deleting Index.html

27 - SQL Wildcards

302 - Introduction to MySQL Wildcards

303 - MySQL Wildcard Customers Start With P Challenges Solution 1

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

305 - MySQL Wildcard Employees In Sales Challenges Solution 2

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

307 - MySQL Wildcard Phone Number Pattern Challenges Solution 3

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

309 - MySQL Wildcard Customers In Restaurant Business Challenges Solution 4

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

311 - MySQL Wildcard NOT LIKE Challenges Solution 5

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

28 - SQL Update Statement Replace Function

313 - Updating a Single Value in a Table

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

315 - Updating Multiple Values in a Table

316 - CODE Updating Multiple Values in a Table.html

317 - Using UPDATE with REPLACE

318 - CODE Using UPDATE with REPLACE.html

319 - What is Storage Engine Lets Digress a little

29 - SQL Select Distinct Statement

320 - DISTINCT How it works

321 - CODE DISTINCT How it works.html

322 - DISTINCT ORDER BY DESC WHERE IS NOT Challenge Solution

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

30 - SQL Format Function

324 - How Format Function Works

325 - CODE How Format Function Works.html

326 - Data Cleaning Format Challenge Solution

327 - CODE Data Cleaning Format Challenge Solution.html

31 - SQL Group By Statement Aggregate

328 - GROUP BY True Meaning

329 - MIN MAX AVG SUM GROUP BY Challenge Solution 1

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

331 - GROUP BY SUMMINAVG CONCAT FORMAT Challenge Solution 2

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

333 - Region Count GROUP BY COUNT Challenge Solution 3

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

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

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

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

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

339 - Product Sold SUM GROUP BY Challenge Solution 6

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

341 - Most Hardworking Employee Challenge Solution 7

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

345 - Type of JOIN in SQL

346 - Understanding INNER JOIN

347 - Understanding LEFT JOIN

348 - Understanding RIGHT JOIN

349 - Understanding FULL JOIN

33 - SQL Joins Deep Dive

350 - Overview of Tables Code for JOIN Demonstration

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

352 - INNER JOIN DEEP DIVE

353 - CODE INNER JOIN DEEP DIVE.html

354 - LEFT JOIN DEEP DIVE

355 - CODE LEFT JOIN DEEP DIVE.html

356 - RIGHT JOIN DEEP DIVE

357 - CODE RIGHT JOIN DEEP DIVE.html

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

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

360 - TableColumn vs Column only

34 - SQL Joins On vs Where On vs Using

361 - ON vs WHERE in INNER LEFT RIGHT JOIN

362 - ON vs USING in SQL JOIN Statement

35 - SQL Joins Challenges Solutions

363 - JOIN for Orders HandledManaged By Employee Challenge Solution 1

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

365 - Using JOIN for Products Their Suppliers Challenge Solution 2

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

367 - JOIN for Customers and Shippers Challenge Solution 3

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

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

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

37 - SQL One Table Join Self Join

374 - SelfJoin One Table Join Challenge and Solution 1

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

38 - SQL Two Tables Join

376 - Two Tables Join Challenge and Solution 2

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

378 - Two Tables Join Challenge and Solution 3

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

380 - Two Tables Join Challenge and Solution 4

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

382 - Two Tables Join Challenge and Solution 5

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

39 - SQL Three Tables Join

384 - Three Table Joins Challenge and Solution 6

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

386 - Three Tables Join Challenge and Solution 7

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

40 - SQL Four Tables Joins

388 - Four Tables Join Challenge and Solution 8

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

41 - SQL Five Tables Join

390 - Five Tables Join Challenge and Solution 9

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

392 - Five Tables Join Challenge and Solution 10

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

42 - SQL Six Tables Join

394 - Six Tables Join Challenge and Solution 11

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

43 - SQL Seven Tables Join

396 - Seven Tables Join Challenge and Solution 12

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

44 - SQL Eight Tables Join

398 - Eight Tables Join Challenge and Solution 13

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

45 - SQL Nine Tables Join

400 - Nine Tables Join Challenge and Solution 14

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

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

47 - SQL Offset Limit

404 - Offset Limit Challenge Solution 1

405 - CODE Offset Limit Challenge Solution 1.html

406 - Offset Limit Third Highest Purchase Challenge Solution 2

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

408 - Offset Limit First Three Highest Salary Challenge Solution 3

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

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

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

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

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

48 - SQL Case Function

414 - Understanding MySQL CASE

415 - CODE Understanding MySQL CASE.html

416 - CASE with IS NULL

417 - CODE CASE with IS NULL.html

418 - CASE FOR TYPE OF CUSTOMERS

419 - CODE CASE FOR TYPE OF CUSTOMERS.html

49 - SQL Cast Function

420 - CAST FROM STRING to DATE

421 - CODE CAST FROM STRING to DATE.html

422 - CAST FROM INTEGER to CHAR Challenge Solution 2

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

424 - CAST FROM STRING to DATE TIME Challenge Solution 3

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

426 - CAST FROM STRING to TIME Challenge Solution 4

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

428 - CAST Order Date Without time Challenge Solution 5

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

430 - CAST FROM DATE to DATETIME Challenge Solution 6

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

50 - SQL Nested Correlated Subqueries

432 - Introduction to subqueries

433 - Aggregate Function with Subqueries

434 - Nested Subquery Challenge Solution 1

435 - Many Subqueries Challenges Solution 2

51 - SQL Subqueries Exists Operator

436 - Exists Operator

437 - Subquery Exists Challenge Solution 1

438 - CODE Subquery Exists Challenge Solution 1.html

439 - Subquery Exists Challenge Solution 2

440 - CODE Subquery Exists Challenge Solution 2.html

52 - Difference Between Nested and Correlated Subqueries

441 - Difference Between Nested and Correlated Subqueries

53 - SQL String Functions

442 - SPACE FUNCTION Challenge Solution 1

443 - SPACE FUNCTION Challenge Solution 2

444 - REPEAT FUNCTION Challenge Solution 3

445 - REPEAT FUNCTION Challenge Solution 4

446 - REPLACE FUNCTION Challenge Solution 5

447 - REPLACE FUNCTION Challenge Solution 6

448 - REPLACE FUNCTION Challenge Solution 7

449 - REVERSE FUNCTION Challenge Solution 8

450 - REVERSE FUNCTION Challenge Solution 9

451 - LEFT FUNCTION Challenge Solution 10

452 - LEFT FUNCTION Challenge Solution 11

453 - RIGHT FUNCTION Challenge Solution 12

454 - RIGHT FUNCTION Challenge Solution 13

455 - RPAD FUNCTION Challenge Solution 14

456 - RPAD FUNCTION Challenge Solution 15

457 - LPAD FUNCTION Challenge Solution 16

458 - LPAD FUNCTION Challenge Solution 17

459 - LPAD FUNCTION Challenge Solution 18

460 - POSITION LOCATION FUNCTIONS Challenge Solution 19

461 - POSITION LOCATION FUNCTIONS Challenge Solution 20

462 - SUBSTRINGSUBSTR FUNCTION Challenge Solution 21

463 - SUBSTRINGSUBSTR FUNCTION Challenge Solution 22

464 - SUBSTRINGSUBSTR FUNCTION Challenge Solution 23

465 - SUBSTRINGSUBSTR FUNCTION Challenge Solution 24

466 - SUBSTRINGINDEX FUNCTION Challenge Solution 25

467 - SUBSTRINGINDEX FUNCTION Challenge Solution 26

468 - SUBSTRINGINDEX FUNCTION Challenge Solution 27

469 - SUBSTRINGINDEX FUNCTION Challenge Solution 28

470 - SUBSTRINGINDEX FUNCTION Challenge Solution 29

471 - MID FUNCTION Challenge Solution 30

472 - MID FUNCTION Challenge Solution 31

473 - INSERT FUNCTION Challenge Solution 32

474 - INSERT FUNCTION Challenge Solution 33

475 - INSTR FUNCTION Challenge Solution 34

476 - INSTR FUNCTION Challenge Solution 35

477 - LCASE LOWER FUNCTION Challenge Solution 35

478 - LCASE LOWER FUNCTION Challenge Solution 36

479 - UCASE UPPER FUNCTION Challenge Solution 37

480 - UCASE UPPER FUNCTION Challenge Solution 38

481 - UCASE UPPER FUNCTION Challenge Solution 39

482 - LENGTH FUNCTION Challenge Solution 40

483 - LENGTH FUNCTION Challenge Solution 41

484 - LTRIM FUNCTION Challenge Solution 42

485 - LTRIM FUNCTION Challenge Solution 43

486 - RTRIM FUNCTION Challenge Solution 44

487 - RTRIM FUNCTION Challenge Solution 45

488 - TRIM FUNCTION Challenge Solution 45

489 - TRIM FUNCTION Challenge Solution 46

54 - SQL Session

490 - Understanding MySQL Session

491 - CODE Understanding MySQL Session.html

55 - SQL Table Locking

492 - Table Locking Intro

493 - Table Locking Demonstration

494 - CODE Table Locking Demonstration.html

56 - SQL Transaction

495 - Brief Introduction to SQL Transaction

496 - TRANSACTION components START BEGIN BEGIN WORK COMMIT ROLLBACK SET

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

498 - TRANSACTION By Example

499 - CODE TRANSACTION By Example.html

500 - NOT USING TRANSACTION

501 - CODE NOT USING TRANSACTION.html

502 - ROLLBACK

503 - CODE ROLLBACK.html

57 - SQL View

504 - Meaning of VIEW

505 - CODE Meaning of VIEW.html

506 - VIEW for Sales Manager Challenge Solution 1

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

508 - VIEW for Employees hired in 1994 Challenge Solution 2

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

510 - Updating VIEW Challenge Solution 3

511 - CODE Updating VIEW Challenge Solution 3.html

512 - A Mistake In VIEW Challenge Solution 4

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

514 - Deleting a VIEW Challenge Solution 5

515 - CODE Deleting a VIEW Challenge Solution 5.html

516 - VIEW for Japan Suppliers Challenge Solution 6

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

518 - WHERE with Normal Table VIEW Table Challenge Solution 7

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

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

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

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

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

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

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

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

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

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

534 - Deleting a STORED PROCEDURE Challenge Solution 7

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

536 - STORED PROCEDURE Helping Purchasing Manager Challenge Solution 8

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

538 - STORED PROCEDURE for Most Expensive Car Challenge Solution 9

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

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

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

543 - CODE What is FUNCTION in SQL.html

544 - Creating Addition FUNCTION Challenge Solution 2

545 - CODE Creating Addition FUNCTION Challenge Solution 2.html

546 - How to check for FUNCTION Challenge Solution 3

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

548 - Creating Pythagoras Theorem FUNCTION Challenge Solution 4

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

550 - Altering or Updating FUNCTION Challenge Solution 5

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

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

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

554 - Deleting a FUNCTION Challenge Solution 7

555 - CODE Deleting a FUNCTION Challenge Solution 7.html

60 - SQL Triggers

556 - The Purpose The How and Types of TRIGGER

557 - TRIGGER More Explanation With Diagram

558 - Steps to Creating a TRIGGER Challenge Solution 1a

559 - Creating After Update TRIGGER Challenge Solution 1b

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

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

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

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

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

565 - Creating Conditional Update TRIGGER Different Names Challenge Solution 2

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

567 - Creating AfterUpdate MySQL TRIGGER Above USD5k Challenge Solution 3

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

569 - After Insert Error Message MySQL TRIGGER Challenge Solution 4

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

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

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

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

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

575 - SQL SIGNAL SQLSTATE ERROR MESSAGE TRIGGER Challenge Solution 7

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

577 - Fraud Detection After Delete TRIGGER Challenge Solution 8

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

579 - research.zip

580 - Nested Subquery JOIN methods 1million Challenge Solution 1

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

582 - Nested Subquery Budget above average Challenge Solution 2

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

584 - Nested Subquery More Query Tweaking Challenge Solution 3

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

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

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

589 - CarShop Resource Details

589 - carshop.zip

590 - Fetching Names of Cars Challenge Solution 1

591 - Names Price of Cars Challenge Solution 2

592 - Cars at a specific price Challenge Solution 3

593 - Between two prices of cars Challenge Solution 4

594 - Counting Cars Challenge Solution 5

595 - Price List of Cars Challenge Solution 6

596 - Price List For Cambodia Customers Challenge Solution 7

597 - Car Average Price Challenge Solution 8

598 - The most expensive car Challenge Solution 9

599 - Most Expensive Cars Challenge Solution 10

600 - Honda Toyota Challenge Solution 11

601 - All details from two tables Challenge Solution 12

602 - Specific fields from two tables Challenge Solution 13

603 - Counting Cars Per Manufacturer Challenge Solution 14

604 - Average Price Per Manufacturer Challenge Solution 15

605 - Manufacturer Average Car Price Above 35000 Challenge Solution 16

606 - The Cheapest Car Challenge Solution 17

607 - The Most Expensive Car Challenge Solution 18

608 - Data Insert Challenge Solution 19

609 - Correcting Wrong Data Challenge Solution 20

610 - Discounted Prices I Challenge Solution 21

611 - Discounted Price II Challenge Solution 22

612 - VIEW for price list Challenge Solution 23

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

615 - What is the current database selected Assignment 1 Solution

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

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

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

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

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

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

622 - Using Alias Assignment 5

623 - Using Alias Solution to Assignment 5

624 - Retrieving data across two tables using JOIN Assignment 6

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

626 - Retrieving data across three tables using JOIN Assignment 7

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

628 - Aggregate sum average minimum maximum Assignment 8

629 - Aggregate sum average minimum maximum Solution to Assignment 8

630 - GROUP BY Average Assignment 9

631 - GROUP BY Average Solution to Assignment 9

632 - GROUP BY RIGHT LEFT INNER NO JOIN Assignment 10

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

634 - VIEW for three tables JOIN Assignment 11

635 - VIEW for three tables JOIN Solution to Assignment 11

636 - INNER JOIN Subquery EXISTS Assignment 12

637 - INNER JOIN Subquery EXISTS Solution to Assignment 12

638 - Updating Table with 5 Increase in Salary Assignment 13

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

640 - INNER JOIN and SubQuery Assignment 14

641 - INNER JOIN and SubQuery Solution Assignment 14

642 - INNER JOIN AND Assignment 15

643 - INNER JOIN AND Solution Assignment 15

644 - INNER JOIN SubQuery Assignment 16

645 - INNER JOIN SubQuery Solution to Assignment 16

646 - SUBQUERY LIMIT Assignment 17

647 - SUBQUERY LIMIT Solution to Assignment 17

648 - UCASE Assignment 18

649 - UCASE Solution to Assignment 18

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

652 - Solution Employees With Same Salary Task 1

653 - CODE Employees With Same Salary Task 1.html

66 - SQL More Task 2

654 - Duplicate Title Task 2

655 - Solution Duplicate Title Task 2

656 - CODE Duplicate Title Task 2.html

67 - SQL More Task 3

657 - Excluding Titles Task 3

658 - Solution Excluding Titles Task 3

659 - CODE Excluding Titles Task 3.html

68 - SQL More Task 4

660 - Eight Last Alphabet n Task 4

661 - Solution Eight Last Alphabet n Task 4

662 - CODE Eight Last Alphabet n Task 4.html

69 - SQL More Task 5

663 - Even Rows Task 5

664 - Solution Even Rows Task 5

665 - CODE Even Rows Task 5.html

70 - SQL More Task 6

666 - Odd Rows Task 6

667 - Solution Odd Rows Task 6

668 - CODE Odd Rows Task 6.html

71 - SQL More Task 7

669 - Second to Fourth Task 7

670 - Solution Second to Fourth Task 7

671 - CODE Second to Fourth Task 7.html

72 - SQL More Task 8

672 - Counting Employee with SALES Task 8

673 - Solution Counting Employee with SALES Task 8

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

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

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

74 - SQL More Task 10

678 - Tricky Exercise Task 10

679 - Solution Tricky Exercise Task 10

680 - CODE Tricky Exercise Task 10.html

75 - SQL More Task 11

681 - Tricky Exercise Task 11

682 - Solution Tricky Exercise Task 11

683 - CODE Tricky Exercise Task 11.html

76 - SQL More Task 12

684 - Tricky Exercise Task 12

685 - Solution Tricky Exercise Task 12

686 - CODE Tricky Exercise Task 12.html

687 - Tricky Exercise Task 12b

688 - Solution Tricky Exercise Task 12b

689 - CODE Tricky Exercise Task 12b.html

77 - SQL More Task 13

690 - Tricky Exercise Task 13

691 - Solution Tricky Exercise Task 13

692 - CODE Tricky Exercise Task 13.html

78 - SQL More Task 14

693 - Tricky Exercise Task 14

694 - Solution Tricky Exercise Task 14

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

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

698 - Using WITH SUBQUERY INNER JOIN

699 - CODE Using WITH SUBQUERY INNER JOIN.html

80 - SQL More Task 15

700 - Tricky Exercise Task 15

701 - Solution Tricky Exercise Task 15

702 - CODE Tricky Exercise Task 15.html

81 - SQL More Task 16

703 - Tricky Exercise task 16

704 - Solution Tricky Exercise task 16

705 - CODE Tricky Exercise task 16.html

82 - SQL More Task 17

706 - Tricky Exercise Task 17

707 - Solution Tricky Exercise Task 17

708 - CODE Tricky Exercise Task 17.html

83 - SQL DATEFORMAT Understanding Me First Before Task 18

709 - Introduction

710 - Day of the Week

711 - Day of the Month

712 - Day of the Year

713 - Week of the Year

714 - Month of the Year

715 - Year from given DateTime

716 - Second Minute Hour AM and PM from DateTime

84 - SQL More Task 18

717 - Tricky Exercise Task 18

718 - Solution Tricky Exercise Task 18

719 - CODE Tricky Exercise Task 18.html

85 - EXTRA SECTION Combining SQL MySQL and Python

720 - Introduction to Combining SQL and Python

86 - Combining SQL and Python Installation of MySQL Connector

721 - Installation of MySQL Connector for Python

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

724 - CODE Creating Database Show Databases From Python.html

724 - CreateDatatabase.html

725 - Creating a Table Show Table Describe Table

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

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

729 - Insert Multiple Rows of Data Into A Table

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

732 - CODE Counting the numbers of rows.html

733 - FetchOne vs FetchAll

734 - CODE FetchOne vs FetchAll.html

90 - Combining SQL and Python Filter Wildcard

735 - Select Filter with Python

736 - CODE Select Filter with Python.html

737 - SQL Wildcard with Python

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

741 - Business Intelligence Process

93 - Combining SQL and Tableau Tableau Installation

742 - How to Download and Install Tableau

94 - Combining SQL and Tableau WhatIsWhat In Tableau

743 - Tableau WhatIsWhat In Tableau I

744 - Tableau WhatIsWhat In Tableau II

745 - Tableau WhatIsWhat In Tableau III

95 - Combining SQL and Tableau Connecting MySQL to Tableau

746 - Connecting MySQL to Tableau

96 - Combining SQL and Tableau Database Querying Visualisation

747 - Tableau MySQL Querying SQL Database from Tableau

748 - Tableau MySQL Visualising CarShop Dataset

97 - Combining SQL and Tableau Challenge Solution

749 - Tableau SQL Challenge Gross Sales and Net Sales Report

98 - Congratulation

750 - Check out my other courses.html

53,700 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy