Sql-Mysql Complete Master Bootcamp – Beginner-Expert (2023)

Free Download Sql-Mysql Complete Master Bootcamp – Beginner-Expert (2023)
Last updated 8/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 13.55 GB | Duration: 25h 36m
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
Requirements
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
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 SQLInstallation MySQLSelect StatementDatabaseTableData TypesInsert QueryCandidate, Surrogate, Primary, Alternative & Foreign KeyPrimary and Foreign Key Constraints | Alter TableAlias (AS)Concat FunctionOrder By KeywordLimit ClauseOrder By & Rand FunctionCommentsWhere ClauseIndexWildcardsUpdate Statement & Replace FunctionSelect Distinct StatementFormat FunctionGroup By Statement | AggregateInner JoinLeft JoinRight JoinSelf JoinTwo Tables JoinThree Tables JoinFour Tables JoinFive Tables JoinSix Tables JoinSeven Tables JoinEight Tables JoinNine Tables JoinTen Tables JoinOffset & LimitCase FunctionCast FunctionNested & Correlated SubqueriesSubqueries & Exits OperatorString FunctionSessionTable LockingTransactionViewStored Procedures (Stored Routines)User-Defined Functions (Stored Routine)TriggersCombining SQL and PythonCombining SQL and TableauResearch Data Set – Real-World DatasetsCAR SHOP DATA SET – Real-World DatasetsCAMERA SUPPLIERS – Real-World DatasetsWith 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!
Overview
Section 1: Introduction, Installation, Resources, Database, Select and CRUD (Updated)
Lecture 1 Your SQL Success Starts Here: Master Complete SQL Course
Lecture 2 Introduction to SQL
Lecture 3 Installation – Introduction
Lecture 4 8 Multiple Choice on Basic SQL – MySQL – Questions
Lecture 5 8 Multiple Choice on Basic SQL – MySQL – Answers
Lecture 6 Installation – Installation of MySQL on MacOS
Lecture 7 Installation – RESOURCES: Installation of MySQL on MacOS
Lecture 8 Installation – How to fix Cannot Connect to MySQL Server – MacOS
Lecture 9 Installation – Installation of MySQL Server and Workbench on Windows
Lecture 10 Installation – How to fix Cannot Connect to MySQL Server – Windows
Lecture 11 Database – Database as a house – Introduction
Lecture 12 Database – Creating a Database
Lecture 13 Database – Creating a Database with IF NOT EXISTS
Lecture 14 Database – How to use a Database
Lecture 15 Database – Finding Out the Currently Selected Database
Lecture 16 Database – Checking If a Database Exists
Lecture 17 Database – Deleting a Database
Lecture 18 Database – Deleting a Database If It Exists
Lecture 19 18 Multiple Choice on Database – Question
Lecture 20 18 Multiple Choice on Database – Answers
Lecture 21 Select – Understanding Select Statement
Lecture 22 Resources – Databases You’ll Need for this Course
Lecture 23 Resources – How to Run the Resources
Lecture 24 CRUD – Understanding CRUD
Lecture 25 5 Multiple Choice on CRUD – Questions
Lecture 26 5 Multiple Choice on CRUD – Answers
Lecture 27 Table – Introduction and Creating Basic Table in MySQL
Lecture 28 Data Types – Introduction
Section 2: ARCHIVED – SQL – Select Statement
Lecture 29 SELECT (Understanding Select for Absolute beginners)
Section 3: ARCHIVED – SQL – Database
Lecture 30 Database vs Table In SQL- Layman’s Explanation – (Challenge & Solution)
Lecture 31 Creating A Database – Challenge & Solution 1
Lecture 32 CODE: Creating A Database – Challenge & Solution 1
Lecture 33 "IF NOT EXISTS" with CREATE DATABASE – Challenge & Solution 2
Lecture 34 CODE: "IF NOT EXISTS" with CREATE DATABASE – Challenge & Solution 2
Lecture 35 How To Check For Existing Databases – Challenge & Solution 3
Lecture 36 CODE: How To Check For Existing Databases – Challenge & Solution
Lecture 37 How To Delete A Database – Challenges & Solution 4
Lecture 38 CODE: How To Delete A Database – Challenges & Solution 4
Lecture 39 Using A Database – Challenge & Solution 5
Lecture 40 CODE: Using A Database – Challenge & Solution 5
Lecture 41 How To Check For The Selected Database in Use – Challenge & Solution 6
Lecture 42 CODE: How To Check For The Selected Database in Use – Challenge & Solution 6
Section 4: MySQL – Numeric Data Types (Updated)
Lecture 43 Introduction to MySQL Numeric Data Types
Lecture 44 Integer Types – INTEGER or INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT
Lecture 45 Client’s Integer Data Types Requirement Scenario
Lecture 46 CODE: Client’s Integer Data Types Requirement Scenario
Lecture 47 Boolean Type (tinyint(1))
Lecture 48 CODE: Boolean Type (tinyint(1))
Lecture 49 20 Multiple-Choice Questions on Integer Data Types
Lecture 50 Answers – 20 Multiple-Choice Questions on Integer Data Types
Lecture 51 Fixed-Point Types – DECIMAL & NUMERIC
Lecture 52 Client’s Fixed-Point Data Types Requirement Scenario
Lecture 53 CODE: Client’s Fixed-Point Data Types Requirement Scenario
Lecture 54 10 Multiple-Choice Questions on Fixed-Point Data Types
Lecture 55 Answers – 10 Multiple-Choice Questions on Fixed-Point Data Types
Lecture 56 Floating-Point Types – FLOAT, DOUBLE
Lecture 57 Client’s Floating-Point Data Types Requirement Scenario
Lecture 58 CODE: Client’s Floating-Point Data Types Requirement Scenario
Lecture 59 10 Multiple-Choice Questions on Floating-Point Data Types
Lecture 60 Answers – 10 Multiple-Choice Questions on Floating-Point Data Types
Lecture 61 Bit-Value Type – BIT
Lecture 62 Client’s Bit Data Types Requirement Scenario
Lecture 63 CODE: Client’s Bit Data Types Requirement Scenario
Lecture 64 5 Multiple-Choice Questions on Bit Data Types
Lecture 65 Answers – 5 Multiple-Choice Questions on Bit Data Types
Section 5: MySQL – String Data Types (Updated)
Lecture 66 Introduction to MySQL String Data Types
Lecture 67 The CHAR and VARCHAR Types
Lecture 68 Client’s CHAR and VARCHAR Types Requirement Scenario
Lecture 69 CODE: Client’s CHAR and VARCHAR Types Requirement Scenario
Lecture 70 10 Multiple-Choice Questions on CHAR and VARCHAR Data Types
Lecture 71 Answers – 10 Multiple-Choice Questions on CHAR and VARCHAR Data Types
Lecture 72 The BINARY and VARBINARY Types
Lecture 73 Client’s BINARY and VARBINARY Types Requirement Scenario
Lecture 74 CODE: Client’s BINARY and VARBINARY Types Requirement Scenario
Lecture 75 10 Multiple-Choice Questions on BINARY and VARBINARY Data Types
Lecture 76 Answers – 10 Multiple-Choice Questions on BINARY and VARBINARY Data Types
Lecture 77 The BLOB and TEXT Types
Lecture 78 Client’s BLOB and TEXT Types Requirement Scenario
Lecture 79 CODE: Client’s BLOB and TEXT Types Requirement Scenario
Lecture 80 30 Multiple-Choice Questions on BLOB and TEXT Data Types
Lecture 81 Answers – 30 Multiple-Choice Questions on BLOB and TEXT Data Types
Lecture 82 ENUM Type
Lecture 83 Client’s ENUM Types Requirement Scenario
Lecture 84 CODE: Client’s ENUM Types Requirement Scenario
Lecture 85 10 Multiple-Choice Questions on ENUM Data Types
Lecture 86 Answers – 10 Multiple-Choice Questions on ENUM Data Types
Lecture 87 SET Type
Lecture 88 Client’s SET Types Requirement Scenario
Lecture 89 CODE: Client’s SET Types Requirement Scenario
Lecture 90 10 Multiple-Choice Questions on SET Data Types
Lecture 91 Answers – 10 Multiple-Choice Questions on SET Data Types
Section 6: MySQL – Date and Time Data Types (Updated)
Lecture 92 Introduction to MySQL Date & Time
Lecture 93 DATE & TIME Types
Lecture 94 Client’s Date and Time Types Requirement Scenario
Lecture 95 CODE: Client’s Date and Time Types Requirement Scenario
Lecture 96 20 Multiple-Choice Questions on Date and Time Data Types
Lecture 97 Answers -20 Multiple-Choice Questions on Date and Time Data Types
Section 7: MySQL – Spatial Data Types (Updated)
Lecture 98 Introduction to MySQL Spatial Types
Lecture 99 Spatial Data Types
Lecture 100 Client’s Spatial Types Requirement Scenario
Lecture 101 CODE: Client’s Spatial Types Requirement Scenario
Lecture 102 20 Multiple-Choice Questions on Spatial Data Types
Lecture 103 Answers – 20 Multiple-Choice Questions on Spatial Data Types
Section 8: MySQL – JSON Data Types (Updated)
Lecture 104 Understanding JSON Data Type in MySQL
Lecture 105 Client’s JSON Types Requirement Scenario
Lecture 106 CODE: Client’s JSON Types Requirement Scenario
Lecture 107 10 Multiple-Choice Questions on JSON Data Types
Lecture 108 Answers – 10 Multiple-Choice Questions on JSON Data Types
Section 9: ARCHIVED – SQL – Data Types
Lecture 109 Type of Data in MySQL
Lecture 110 MySQL Numeric Types
Lecture 111 TINYINT, SMALLINT, MEDIUMINT, INTEGER, BIGINT -Exact Numeric Data Types in MySQL
Lecture 112 DECIMAL & NUMERIC – Fixed Point Data Types in MySQL | Approximate Numeric I
Lecture 113 DECIMAL & NUMERIC – Fixed Point Data Types in MySQL | Approximate Numeric II
Lecture 114 REAL, FLOAT, DOUBLE – Floating Point Data Type in MySQL
Lecture 115 CHAR vs VARCHAR – String Data Types in MySQL
Lecture 116 BINARY & VARBINARY – String Data Types in MySQL
Lecture 117 BLOB & TEXT – String Data Types in MySQL
Lecture 118 ENUM – String Data Types in MySQL
Lecture 119 SET – String Data Types in MySQL
Lecture 120 DATE, TIME, DATETIME, TIMESTAMP & YEAR – Date and Time Data Types in MySQL
Section 10: MySQl – Auto_Increment & WHERE (In Brief)
Lecture 121 MySQL Auto Increment
Lecture 122 MySQL Default
Lecture 123 MySQL Null and NOT Null
Lecture 124 WHERE – A brief Intro
Section 11: MySQL – Insert Query (Updated)
Lecture 125 SQL Basic Insert
Lecture 126 SQL Inserting Multiple Rows at Once
Lecture 127 SQL Inserting Data from Another Table
Lecture 128 SQL Inserting with a Set Clause
Section 12: ARCHIVED – SQL – Insert Query
Lecture 129 Inserting A Single Line of Data Into Table – 1st Method
Lecture 130 CODE: Inserting A Single Line of Data Into Table – 1st Method
Lecture 131 Inserting A Single Line of Data Into Table – 2nd Method
Lecture 132 CODE: Inserting A Single Line of Data Into Table – 2nd Method
Lecture 133 Inserting Multiple Lines of Data Into Table – 1st Method
Lecture 134 CODE: Inserting Multiple Lines of Data Into Table – 1st Method
Lecture 135 Inserting Multiple Lines of Data Into Table – 2nd Method
Lecture 136 CODE: Inserting Multiple Lines of Data Into Table – 2nd Method
Lecture 137 Inserting Multiple Lines of Data Into Table – 3rd Method
Lecture 138 CODE: Inserting Multiple Lines of Data Into Table – 3rd Method
Lecture 139 Inserting Null Value and Empty White Space Into Table
Lecture 140 CODE: Inserting Null Value and Empty White Space Into Table
Section 13: SQL – Candidate, Surrogate, Primary, Unique, Natural & Foreign Key (Updated)
Lecture 141 Introductions to Keys in SQL
Lecture 142 Unique Key in SQL
Lecture 143 Primary Key in SQL
Lecture 144 Candidate and Alternate Keys in SQL
Lecture 145 Composite – Compound – Key in SQL
Lecture 146 Natural Key in SQL
Lecture 147 Surrogate Key in SQL
Lecture 148 Super Key in SQL
Lecture 149 Foreign Key in SQL
Lecture 150 41 Multiple-Choice Questions on different types of SQL Keys
Lecture 151 Answers – 41 Multiple-Choice Questions on different types of SQL Keys
Section 14: ARCHIVED – SQL – Candidate, Surrogate, Primary, Alternative & Foreign Keys
Lecture 152 Candidate Key In SQL
Lecture 153 Surrogate Key In SQL
Lecture 154 Primary Key & Alternative Key In SQL
Lecture 155 Foreign Key In SQL
Section 15: SQL – Alter Table (UPDATED)
Lecture 156 Alter Table – Intro & Adding a New Column
Lecture 157 Alter Table – Dropping an Existing Column
Lecture 158 Alter Table – Modify Column Type and Size
Lecture 159 Alter Table – Drop Primary Key
Lecture 160 Alter Table – Add Primary Key
Lecture 161 Alter Table – Add Unique Constraint
Lecture 162 Alter Table – Rename Column
Lecture 163 Alter Table – Add Foreign Key
Lecture 164 Alter Table – Rename Table
Lecture 165 Alter Table – Add Default to Column
Lecture 166 Alter Table – Drop Default from a Column
Lecture 167 Alter Table – Drop Foreign Key
Section 16: SQL – Deleting Records
Lecture 168 Introduction to delete & Deleting Specific Records
Lecture 169 Delete multiple records
Lecture 170 Delete all records
Lecture 171 Truncate Table
Lecture 172 Deleting a Table
Lecture 173 Delete Cascade
Section 17: ARCHIVED – SQL – Primary and Foreign Key Constraints | Alter Table
Lecture 174 Assigning A PRIMARY KEY (Three Methods) – Challenge & Solution 1
Lecture 175 CODE: Assigning A PRIMARY KEY (Three Methods) – Challenge & Solution
Lecture 176 Deleting A PRIMARY KEY – Challenge & Solution 2
Lecture 177 CODE: Deleting A PRIMARY KEY – Challenge & Solution 2
Lecture 178 Adding A PRIMARY KEY To Existing Column – Challenge & Solution 3
Lecture 179 CODE: Adding A PRIMARY KEY To Existing Column – Challenge & Solution 3
Lecture 180 Assigning A FOREIGN KEY – Challenge & Solution 4
Lecture 181 CODE: Assigning A FOREIGN KEY – Challenge & Solution 4
Lecture 182 Assigning A CONSTRAINT NAME To A FOREIGN KEY – Challenge & Solution 5
Lecture 183 CODE: Assigning A CONSTRAINT NAME To A FOREIGN KEY – Challenge & Solution 5
Lecture 184 Adding A FOREIGN KEY To Existing Table – Challenge & Solution 6
Lecture 185 CODE: Challenge & Solution 6 | Adding A FOREIGN KEY To Existing Table
Lecture 186 Challenge & Solution 7 | CONSTRAINT NAME & FOREIGN KEY To Existing Table
Lecture 187 CODE:CONSTRAINT NAME & FOREIGN KEY To Existing Table – Challenge & Solution 7
Lecture 188 Deleting A REFERENCED Parent Table – Challenge & Solution 8
Lecture 189 CODE: Deleting A REFERENCED Parent Table – Challenge & Solution 8
Lecture 190 Deleting A Column From A Table – Challenge & Solution 9
Lecture 191 CODE: Deleting A Column From A Table – Challenge & Solution 9
Lecture 192 Deleting A REFERENCED or CONSTRAINT Column – Challenge & Solution 10
Lecture 193 CODE: Deleting A REFERENCED or CONSTRAINT Column – Challenge & Solution 10
Section 18: SQL – Revisiting Select Statement
Lecture 194 Select All Rows and Columns – Challenge & Solution 1
Lecture 195 CODE: Select All Rows and Columns – Challenge & Solution 1
Lecture 196 Select Specific Columns – Challenge & Solution 2
Lecture 197 CODE: Select Specific Columns – Challenge & Solution 2
Lecture 198 Manager Demands for All Customers’ Detail – Challenge & Solution 3
Lecture 199 CODE: Manager Demands for All Customers’ Detail – Challenge & Solution 3
Lecture 200 Specific Customer’s Details – Challenge & Solution 4
Lecture 201 CODE: Specific Customer’s Details – Challenge & Solution 4
Section 19: SQL – Alias – AS
Lecture 202 ALIAS (AS) Introduction
Lecture 203 CODE: ALIAS (AS) Introduction
Lecture 204 Alias – Challenge & Solution
Lecture 205 CODE: Alias – Challenge & Solution
Section 20: SQL – Concat Function
Lecture 206 CONCAT() Introduction
Lecture 207 CODE: CONCAT() Introduction
Lecture 208 CONCAT() – Challenge & Solution 1
Lecture 209 CODE: Challenge & Solution 1 | CONCAT()
Lecture 210 CONCAT() – Challenge & Solution 2
Lecture 211 CODE: Challenge & Solution 2 | CONCAT()
Section 21: SQL – Order By Keyword
Lecture 212 ORDER BY Introduction
Lecture 213 ORDER BY ASC – Challenge & Solution 1
Lecture 214 CODE: ORDER BY ASC – Challenge & Solution 1
Lecture 215 ORDER BY DESC – Challenge & Solution 2
Lecture 216 CODE: ORDER BY DESC – Challenge & Solution 2
Lecture 217 ORDER BY DESC & CONCAT – Challenge & Solution 3
Lecture 218 CODE: ORDER BY DESC & CONCAT – Challenge & Solution 3
Lecture 219 ORDER BY ASC – Challenge & Solution 4
Lecture 220 CODE: ORDER BY ASC – Challenge & Solution 4
Section 22: SQL – Limit Clause
Lecture 221 LIMIT – Challenge & Solution 1
Lecture 222 CODE: LIMIT – Challenge & Solution 1
Lecture 223 LIMIT – Challenge & Solution 2
Lecture 224 CODE: LIMIT – Challenge & Solution 2
Lecture 225 LIMIT – Challenge & Solution 3
Lecture 226 CODE: LIMIT – Challenge & Solution 3
Section 23: SQL – Order By & Rand Function
Lecture 227 ORDER BY with RAND – Challenge & Solution
Lecture 228 CODE: ORDER BY with RAND – Challenge & Solution
Section 24: SQL – Comments
Lecture 229 SINGLE & MULTILINE COMMENTS in SQL-MySQL
Section 25: SQL – Where Clause
Lecture 230 Introduction to WHERE
Lecture 231 Northwind Data Set | Should run to work along
Lecture 232 UK Customers filter – Challenge & Solution 1
Lecture 233 CODE: UK Customers filter – Challenge & Solution 1
Lecture 234 Specific Customer filter – Challenge & Solution 2
Lecture 235 CODE: Specific Customer filter – Challenge & Solution 2
Lecture 236 Specific Employee filter – Challenge & Solution 3
Lecture 237 CODE: Specific Employee filter – Challenge & Solution 3
Lecture 238 Product with specific Price filter – Challenge & Solution 4
Lecture 239 CODE: Product with specific Price filter – Challenge & Solution 4
Lecture 240 Getting a list of Sales Representatives – Challenge & Solution 5
Lecture 241 CODE: Getting a list of Sales Representatives – Challenge & Solution 5
Lecture 242 None Spanish Customers using != , <> – Challenge & Solution 6
Lecture 243 CODE: None Spanish Customers using != , <> – Challenge & Solution 6
Lecture 244 Products Supplied by a Specific Customer – Challenge & Solution 7
Lecture 245 CODE: Products Supplied by a Specific Customer – Challenge & Solution 7
Lecture 246 All Suppliers Except… using NOT, <>, ! – Challenge & Solution 8
Lecture 247 CODE: All Suppliers Except… using NOT, <>, ! – Challenge & Solution 8
Lecture 248 Products above certain Price | Greater Than > – Challenge & Solution 9
Lecture 249 CODE: Products above certain Price | Greater Than > – Challenge & Solution 9
Lecture 250 Products Below Certain Price| Less Than < – Challenge & Solution 10
Lecture 251 CODE: Products Below Certain Price| Less Than < – Challenge & Solution 10
Lecture 252 Unit In Stock | Less Than < – Challenge & Solution 11
Lecture 253 CODE:Unit In Stock | Less Than < – Challenge & Solution 11
Lecture 254 Minimum Wages | Less Than < – Challenge & Solution 12
Lecture 255 CODE: Minimum Wages | Less Than < – Challenge & Solution 12
Lecture 256 Gifts for Customers | Greater Than – Challenge & Solution 13
Lecture 257 CODE: Gifts for Customers | Greater Than – Challenge & Solution 13
Lecture 258 Units In Stock | Less Than – Challenge & Solution 14
Lecture 259 CODE: Units In Stock | Less Than – Challenge & Solution 14
Lecture 260 San Francisco Customers | AND – Challenge & Solution 15
Lecture 261 CODE: San Francisco Customers | AND – Challenge & Solution 15
Lecture 262 Specific Mexico Customers | AND – Challenge & Solution 16
Lecture 263 CODE: Specific Mexico Customers | AND – Challenge & Solution 16
Lecture 264 None USA and UK Customers | NOT, !=, <> – Challenge & Solution 17
Lecture 265 CODE: None USA and UK Customers | NOT, !=, <> – Challenge & Solution 17
Lecture 266 Brazil and Venezuela Customers | OR – Challenge & Solution 18
Lecture 267 CODE: Brazil and Venezuela Customers | OR – Challenge & Solution 18
Lecture 268 Range of Suppliers | BETWEEN – Challenges & Solution 19
Lecture 269 CODE: Range of Suppliers | BETWEEN – Challenges & Solution 19
Lecture 270 Suppliers | Combining <, > & OR – Challenge & Solution 20
Lecture 271 CODE: Suppliers | Combining <, > & OR – Challenge & Solution 20
Lecture 272 Range of Suppliers using BETWEEN – Challenge & Solution 21
Lecture 273 CODE: Range of Suppliers using BETWEEN – Challenge & Solution 21
Lecture 274 NOT BETWEEN – Challenge & Solution 22
Lecture 275 CODE: NOT BETWEEN – Challenge & Solution 22
Lecture 276 Customers in Paris & Nantes, France – Challenge & Solution 23
Lecture 277 CODE: Customers in Paris & Nantes, France – Challenge & Solution 23
Lecture 278 Product List | BETWEEN, CONCAT, FORMAT, ORDER BY – Challenge & Solution 24
Lecture 279 CODE: Product List | BETWEEN, CONCAT, FORMAT, ORDER BY – Challenge & Solution 24
Lecture 280 NULL values | IS NULL, IS NOT NULL – Challenge & Solution 25
Lecture 281 CODE: NULL values | IS NULL, IS NOT NULL – Challenge & Solution 25
Lecture 282 Employees Report to #2 | IS NOT NULL – Challenge & Solution 26
Lecture 283 CODE: Employees Report to #2 | IS NOT NULL – Challenge & Solution 26
Lecture 284 IN and WHERE – Challenge & Solution 27
Lecture 285 CODE: IN and WHERE – Challenge & Solution 27
Lecture 286 NOT IN – UK, Germany & France Customers – Challenge & Solution 28
Lecture 287 CODE: NOT IN – UK, Germany & France Customers – Challenge & Solution 28
Section 26: SQL – Index
Lecture 288 Introduction to MySQL Index
Lecture 289 Creating Index Along a Table
Lecture 290 Code: Creating Index Along a Table
Lecture 291 Creating Index on Existing Column
Lecture 292 CODE: Creating Index on Existing Column
Lecture 293 Understanding Primary or Clustered Index
Lecture 294 Unique Key vs Index
Lecture 295 Key vs Index
Lecture 296 Verifying Index
Lecture 297 CODE: Verifying Index
Lecture 298 Confirming the "Power" of Index
Lecture 299 CODE: Confirming the "Power" of Index
Lecture 300 Deleting Index
Lecture 301 CODE: Deleting Index
Section 27: SQL – Wildcards
Lecture 302 Introduction to MySQL Wildcards
Lecture 303 MySQL Wildcard – Customers Start With P – Challenges & Solution 1
Lecture 304 CODE: MySQL Wildcard – Customers Start With P – Challenges & Solution 1
Lecture 305 MySQL Wildcard | Employees In Sales – Challenges & Solution 2
Lecture 306 CODE: MySQL Wildcard | Employees In Sales – Challenges & Solution 2
Lecture 307 MySQL Wildcard | Phone Number Pattern – Challenges & Solution 3
Lecture 308 CODE: MySQL Wildcard | Phone Number Pattern – Challenges & Solution 3
Lecture 309 MySQL Wildcard – Customers In Restaurant Business – Challenges & Solution 4
Lecture 310 CODE: MySQL Wildcard – Customers In Restaurant Business – Challenges & Solution
Lecture 311 MySQL Wildcard – NOT LIKE – -Challenges & Solution 5
Lecture 312 CODE: MySQL Wildcard – NOT LIKE – -Challenges & Solution 5
Section 28: SQL – Update Statement & Replace Function
Lecture 313 Updating a Single Value in a Table
Lecture 314 CODE: Updating a Single Value in a Table
Lecture 315 Updating Multiple Values in a Table
Lecture 316 CODE: Updating Multiple Values in a Table
Lecture 317 Using UPDATE with REPLACE
Lecture 318 CODE: Using UPDATE with REPLACE
Lecture 319 What is Storage Engine – Let’s Digress a little 🙂
Section 29: SQL – Select Distinct Statement
Lecture 320 DISTINCT – How it works
Lecture 321 CODE: DISTINCT – How it works
Lecture 322 DISTINCT, ORDER BY DESC, WHERE, IS NOT – Challenge & Solution
Lecture 323 CODE: DISTINCT, ORDER BY DESC, WHERE, IS NOT – Challenge & Solution
Section 30: SQL – Format Function
Lecture 324 How Format() Function Works
Lecture 325 CODE: How Format() Function Works
Lecture 326 Data Cleaning | Format – Challenge & Solution
Lecture 327 CODE: Data Cleaning | Format – Challenge & Solution
Section 31: SQL – Group By Statement | Aggregate
Lecture 328 GROUP BY – True Meaning
Lecture 329 MIN(), MAX(), AVG(), SUM() & GROUP BY – Challenge & Solution 1
Lecture 330 CODE: MIN(), MAX(), AVG(), SUM() & GROUP BY – Challenge & Solution 1
Lecture 331 GROUP BY / SUM,MIN,AVG / CONCAT / FORMAT – Challenge & Solution 2
Lecture 332 CODE: GROUP BY / SUM,MIN,AVG / CONCAT / FORMAT – Challenge & Solution 2
Lecture 333 Region Count | GROUP BY, COUNT – Challenge & Solution 3
Lecture 334 CODE: Region Count | GROUP BY, COUNT – Challenge & Solution 3
Lecture 335 Row / Unique Value Count | GROUP BY, COUNT – Challenge & Solution 4
Lecture 336 CODE: Row / Unique Value Count | GROUP BY, COUNT – Challenge & Solution 4
Lecture 337 Product Count | COUNT, GROUP BY, ORDER BY – Challenge & Solution 5
Lecture 338 CODE: Product Count | COUNT, GROUP BY, ORDER BY – Challenge & Solution 5
Lecture 339 Product Sold | SUM, GROUP BY – Challenge & Solution 6
Lecture 340 CODE: Product Sold | SUM, GROUP BY – Challenge & Solution 6
Lecture 341 Most Hardworking Employee – Challenge & Solution 7
Lecture 342 CODE: Most Hardworking Employee – Challenge & Solution 7
Section 32: SQL – Joins (Made Easy)
Lecture 343 Resource for JOIN
Lecture 344 Purpose of JOIN in SQL
Lecture 345 Type of JOIN in SQL
Lecture 346 Understanding INNER JOIN
Lecture 347 Understanding LEFT JOIN
Lecture 348 Understanding RIGHT JOIN
Lecture 349 Understanding FULL JOIN
Section 33: SQL – Joins (Deep Dive)
Lecture 350 Overview of Tables & Code for JOIN Demonstration
Lecture 351 CODE: Overview of Tables & Code for JOIN Demonstration
Lecture 352 INNER JOIN – DEEP DIVE
Lecture 353 CODE: INNER JOIN – DEEP DIVE
Lecture 354 LEFT JOIN – DEEP DIVE
Lecture 355 CODE: LEFT JOIN – DEEP DIVE
Lecture 356 RIGHT JOIN – DEEP DIVE
Lecture 357 CODE: RIGHT JOIN – DEEP DIVE
Lecture 358 More On RIGHT JOIN and LEFT JOIN | with Shipper & Orders tables
Lecture 359 CODE:More On RIGHT JOIN and LEFT JOIN | with Shipper & Orders tables
Lecture 360 Table.Column vs Column only?
Section 34: SQL – Joins "On" vs "Where" | "On" vs "Using"
Lecture 361 ON vs WHERE in INNER, LEFT & RIGHT JOIN
Lecture 362 "ON" vs "USING" in SQL JOIN Statement
Section 35: SQL – Joins Challenges & Solutions
Lecture 363 JOIN for Orders Handled/Managed By Employee – Challenge & Solution 1
Lecture 364 CODE: JOIN for Orders Handled/Managed By Employee – Challenge & Solution 1
Lecture 365 Using JOIN for Products & Their Suppliers – Challenge & Solution 2
Lecture 366 CODE: Using JOIN for Products & Their Suppliers – Challenge & Solution 2
Lecture 367 JOIN for Customers and Shippers – Challenge & Solution 3
Lecture 368 CODE: JOIN for Customers and Shippers – Challenge & Solution 3
Lecture 369 JOIN Many Tables – Customers and Names of Shipper – Challenge & Solution 4
Lecture 370 CODE: JOIN Many Tables – Customers and Names of Shipper -Challenge & Solution 4
Section 36: SQL – Joining 1, 2, 3, 4, 5, 6, 7, 8, 9 & 10 Tables
Lecture 371 Please Read Me!
Lecture 372 Schema
Lecture 373 Simplifying the Schema used for JOIN in the following sections.
Section 37: SQL – One Table Join (Self Join)
Lecture 374 Self-Join | One Table Join – Challenge and Solution 1
Lecture 375 CODE: Self-Join | One Table Join – Challenge and Solution 1
Section 38: SQL – Two Tables Join
Lecture 376 Two Tables Join – Challenge and Solution 2
Lecture 377 CODE: Two Tables Join – Challenge and Solution 2
Lecture 378 Two Tables Join – Challenge and Solution 3
Lecture 379 CODE: Two Tables Join – Challenge and Solution 3
Lecture 380 Two Tables Join – Challenge and Solution 4
Lecture 381 CODE: Two Tables Join – Challenge and Solution 4
Lecture 382 Two Tables Join – Challenge and Solution 5
Lecture 383 CODE: Two Tables Join – Challenge and Solution 5
Section 39: SQL – Three Tables Join
Lecture 384 Three Table Joins – Challenge and Solution 6
Lecture 385 CODE: Three Tables Join – Challenge and Solution 6
Lecture 386 Three Tables Join – Challenge and Solution 7
Lecture 387 CODE: Three Tables Join – Challenge and Solution 7
Section 40: SQL – Four Tables Joins
Lecture 388 Four Tables Join – Challenge and Solution 8
Lecture 389 CODE: Four Tables Join – Challenge and Solution 8
Section 41: SQL – Five Tables Join
Lecture 390 Five Tables Join – Challenge and Solution 9
Lecture 391 CODE: Five Tables Join – Challenge and Solution 9
Lecture 392 Five Tables Join – Challenge and Solution 10
Lecture 393 CODE: Five Tables Join – Challenge and Solution 10
Section 42: SQL – Six Tables Join
Lecture 394 Six Tables Join – Challenge and Solution 11
Lecture 395 CODE: Six Tables Join – Challenge and Solution 11
Section 43: SQL – Seven Tables Join
Lecture 396 Seven Tables Join – Challenge and Solution 12
Lecture 397 CODE: Seven Tables Join – Challenge and Solution 12
Section 44: SQL – Eight Tables Join
Lecture 398 Eight Tables Join – Challenge and Solution 13
Lecture 399 CODE: Eight Tables Join – Challenge and Solution 13
Section 45: SQL – Nine Tables Join
Lecture 400 Nine Tables Join – Challenge and Solution 14
Lecture 401 CODE: Nine Tables Join – Challenge and Solution 14
Section 46: SQL – Ten Tables Join
Lecture 402 Ten Tables Join – Challenge and Solution | For Demonstration Purpose
Lecture 403 CODE: Ten Tables Join – Challenge and Solution 15
Section 47: SQL – Offset & Limit
Lecture 404 Offset & Limit – Challenge & Solution 1
Lecture 405 CODE: Offset & Limit – Challenge & Solution 1
Lecture 406 Offset & Limit | Third Highest Purchase – Challenge & Solution 2
Lecture 407 CODE: Offset & Limit | Third Highest Purchase – Challenge & Solution 2
Lecture 408 Offset & Limit | First Three Highest Salary – Challenge & Solution 3
Lecture 409 CODE: Offset & Limit | First Three Highest Salary – Challenge & Solution 3
Lecture 410 Offset & Limit – Fourth to the Lowest Salary – Challenge & Solution 4
Lecture 411 CODE: Offset & Limit – Fourth to the Lowest Salary – Challenge & Solution 4
Lecture 412 OFFSET & LIMIT | First and Third Bestselling Products – Challenge & Solution 5
Lecture 413 CODE: OFFSET & LIMIT | First and Third Bestselling Products – Challenge & Soluti
Section 48: SQL – Case Function
Lecture 414 Understanding MySQL CASE
Lecture 415 CODE: Understanding MySQL CASE
Lecture 416 CASE with IS NULL
Lecture 417 CODE: CASE with IS NULL
Lecture 418 CASE FOR TYPE OF CUSTOMERS
Lecture 419 CODE: CASE FOR TYPE OF CUSTOMERS
Section 49: SQL – Cast Function
Lecture 420 CAST – FROM STRING to DATE
Lecture 421 CODE: CAST – FROM STRING to DATE
Lecture 422 CAST – FROM INTEGER to CHAR – Challenge & Solution 2
Lecture 423 CODE: CAST – FROM INTEGER to CHAR – Challenge & Solution 2
Lecture 424 CAST | FROM STRING to DATE & TIME – Challenge & Solution 3
Lecture 425 CODE: CAST | FROM STRING to DATE & TIME – Challenge & Solution 3
Lecture 426 CAST | FROM STRING to TIME – Challenge & Solution 4
Lecture 427 CODE: CAST | FROM STRING to TIME – Challenge & Solution 4
Lecture 428 CAST | Order Date Without time – Challenge & Solution 5
Lecture 429 CODE: CAST | Order Date Without time – Challenge & Solution 5
Lecture 430 CAST | FROM DATE to DATETIME – Challenge & Solution 6
Lecture 431 CODE: CAST | FROM DATE to DATETIME – Challenge & Solution 6
Section 50: SQL – Nested & Correlated Subqueries
Lecture 432 Introduction to subqueries
Lecture 433 Aggregate Function with Subqueries
Lecture 434 Nested Subquery – Challenge & Solution 1
Lecture 435 Many Subqueries – Challenges & Solution 2
Section 51: SQL – Subqueries & Exists Operator
Lecture 436 Exists Operator
Lecture 437 Subquery & Exists – Challenge & Solution 1
Lecture 438 CODE: Subquery & Exists – Challenge & Solution 1
Lecture 439 Subquery & Exists – Challenge & Solution 2
Lecture 440 CODE: Subquery & Exists – Challenge & Solution 2
Section 52: Difference Between Nested and Correlated Subqueries
Lecture 441 Difference Between Nested and Correlated Subqueries
Section 53: SQL – String Functions
Lecture 442 SPACE FUNCTION | Challenge & Solution 1
Lecture 443 SPACE FUNCTION | Challenge & Solution 2
Lecture 444 REPEAT FUNCTION | Challenge & Solution 3
Lecture 445 REPEAT FUNCTION | Challenge & Solution 4
Lecture 446 REPLACE FUNCTION | Challenge & Solution 5
Lecture 447 REPLACE FUNCTION | Challenge & Solution 6
Lecture 448 REPLACE FUNCTION | Challenge & Solution 7
Lecture 449 REVERSE FUNCTION | Challenge & Solution 8
Lecture 450 REVERSE FUNCTION | Challenge & Solution 9
Lecture 451 LEFT FUNCTION | Challenge & Solution 10
Lecture 452 LEFT FUNCTION | Challenge & Solution 11
Lecture 453 RIGHT FUNCTION | Challenge & Solution 12
Lecture 454 RIGHT FUNCTION | Challenge & Solution 13
Lecture 455 RPAD FUNCTION | Challenge & Solution 14
Lecture 456 RPAD FUNCTION | Challenge & Solution 15
Lecture 457 LPAD FUNCTION | Challenge & Solution 16
Lecture 458 LPAD FUNCTION | Challenge & Solution 17
Lecture 459 LPAD FUNCTION | Challenge & Solution 18
Lecture 460 POSITION & LOCATION FUNCTIONS | Challenge & Solution 19
Lecture 461 POSITION & LOCATION FUNCTIONS | Challenge & Solution 20
Lecture 462 SUBSTRING_SUBSTR FUNCTION | Challenge & Solution 21
Lecture 463 SUBSTRING_SUBSTR FUNCTION | Challenge & Solution 22
Lecture 464 SUBSTRING_SUBSTR FUNCTION | Challenge & Solution 23
Lecture 465 SUBSTRING_SUBSTR FUNCTION | Challenge & Solution 24
Lecture 466 SUBSTRING_INDEX FUNCTION | Challenge & Solution 25
Lecture 467 SUBSTRING_INDEX FUNCTION | Challenge & Solution 26
Lecture 468 SUBSTRING_INDEX FUNCTION | Challenge & Solution 27
Lecture 469 SUBSTRING_INDEX FUNCTION | Challenge & Solution 28
Lecture 470 SUBSTRING_INDEX FUNCTION | Challenge & Solution 29
Lecture 471 MID FUNCTION | Challenge & Solution 30
Lecture 472 MID FUNCTION | Challenge & Solution 31
Lecture 473 INSERT FUNCTION | Challenge & Solution 32
Lecture 474 INSERT FUNCTION | Challenge & Solution 33
Lecture 475 INSTR FUNCTION | Challenge & Solution 34
Lecture 476 INSTR FUNCTION | Challenge & Solution 35
Lecture 477 LCASE & LOWER FUNCTION | Challenge & Solution 35
Lecture 478 LCASE & LOWER FUNCTION | Challenge & Solution 36
Lecture 479 UCASE & UPPER FUNCTION | Challenge & Solution 37
Lecture 480 UCASE & UPPER FUNCTION | Challenge & Solution 38
Lecture 481 UCASE & UPPER FUNCTION | Challenge & Solution 39
Lecture 482 LENGTH FUNCTION | Challenge & Solution 40
Lecture 483 LENGTH FUNCTION | Challenge & Solution 41
Lecture 484 LTRIM FUNCTION | Challenge & Solution 42
Lecture 485 LTRIM FUNCTION | Challenge & Solution 43
Lecture 486 RTRIM FUNCTION | Challenge & Solution 44
Lecture 487 RTRIM FUNCTION | Challenge & Solution 45
Lecture 488 TRIM FUNCTION | Challenge & Solution 45
Lecture 489 TRIM FUNCTION | Challenge & Solution 46
Section 54: SQL – Session
Lecture 490 Understanding MySQL Session
Lecture 491 CODE: Understanding MySQL Session
Section 55: SQL – Table Locking
Lecture 492 Table Locking Intro
Lecture 493 Table Locking Demonstration
Lecture 494 CODE: Table Locking Demonstration
Section 56: SQL – Transaction
Lecture 495 Brief Introduction to SQL Transaction
Lecture 496 TRANSACTION components – START, BEGIN, BEGIN WORK, COMMIT, ROLLBACK, SET
Lecture 497 CODE: TRANSACTION components – START, BEGIN, BEGIN WORK, COMMIT, ROLLBACK, SET
Lecture 498 TRANSACTION By Example
Lecture 499 CODE: TRANSACTION By Example
Lecture 500 NOT USING TRANSACTION
Lecture 501 CODE: NOT USING TRANSACTION
Lecture 502 ROLLBACK
Lecture 503 CODE: ROLLBACK
Section 57: SQL – View
Lecture 504 Meaning of VIEW
Lecture 505 CODE: Meaning of VIEW
Lecture 506 VIEW for Sales Manager | Challenge & Solution 1
Lecture 507 CODE: VIEW for Sales Manager | Challenge & Solution 1
Lecture 508 VIEW for Employees hired in 1994 | Challenge & Solution 2
Lecture 509 CODE: VIEW for Employees hired in 1994 | Challenge & Solution 2
Lecture 510 Updating VIEW | Challenge & Solution 3
Lecture 511 CODE: Updating VIEW | Challenge & Solution 3
Lecture 512 A Mistake In VIEW | Challenge & Solution 4
Lecture 513 CODE: A Mistake In VIEW | Challenge & Solution 4
Lecture 514 Deleting a VIEW – Challenge & Solution 5
Lecture 515 CODE: Deleting a VIEW – Challenge & Solution 5
Lecture 516 VIEW for Japan Suppliers – Challenge & Solution 6
Lecture 517 CODE: VIEW for Japan Suppliers – Challenge & Solution 6
Lecture 518 WHERE with Normal Table & VIEW Table – Challenge & Solution 7
Lecture 519 CODE: WHERE with Normal Table & VIEW Table – Challenge & Solution 7
Lecture 520 INNER JOIN with Normal Table & VIEW Table – Challenge & Solution 8
Lecture 521 CODE: INNER JOIN with Normal Table & VIEW Table – Challenge & Solution 8
Section 58: SQL – Stored Procedures (Stored Routines)
Lecture 522 What is the meaning and purpose of Stored Procedure
Lecture 523 CODE: What is the meaning and purpose of Stored Procedure
Lecture 524 How to create STORED PROCEDURE for cars table – Challenge & Solution 2
Lecture 525 CODE: How to create STORED PROCEDURE for cars table – Challenge & Solution 2
Lecture 526 How to Modify STORED PROCEDURE | Tesla Vehicles – Challenge & Solution 3
Lecture 527 CODE: How to Modify STORED PROCEDURE | Tesla Vehicles – Challenge & Solution 3
Lecture 528 How to check for STORED PROCEDURE across databases – Challenge & Soln 4
Lecture 529 CODE: How to check for STORED PROCEDURE across databases – Challenge & Soln 4
Lecture 530 Check for STORED PROCEDURE in the current database – Challenge & Solution 5
Lecture 531 CODE: Check for STORED PROCEDURE in the current database – Challenge & Soln 5
Lecture 532 Check for STORED PROCEDURE in a specified database – Challenge & Soln 6
Lecture 533 CODE: Check for STORED PROCEDURE in a specified database – Challenge & Soln 6
Lecture 534 Deleting a STORED PROCEDURE – Challenge & Solution 7
Lecture 535 CODE: Deleting a STORED PROCEDURE – Challenge & Solution 7
Lecture 536 STORED PROCEDURE – Helping Purchasing Manager – Challenge & Solution 8
Lecture 537 CODE: STORED PROCEDURE – Helping Purchasing Manager – Challenge & Solution 8
Lecture 538 STORED PROCEDURE for Most Expensive Car – Challenge & Solution 9
Lecture 539 CODE: STORED PROCEDURE for Most Expensive Car – Challenge & Solution 9
Lecture 540 STORED PROCEDURE for DATA INSERT to a table – Challenge & Solution 10
Lecture 541 CODE: STORED PROCEDURE for DATA INSERT to a table – Challenge & Solution 10
Section 59: SQL – User-defined Functions (Stored Routine)
Lecture 542 What is FUNCTION in SQL
Lecture 543 CODE: What is FUNCTION in SQL
Lecture 544 Creating Addition FUNCTION – Challenge & Solution 2
Lecture 545 CODE: Creating Addition FUNCTION – Challenge & Solution 2
Lecture 546 How to check for FUNCTION – Challenge & Solution 3
Lecture 547 CODE: How to check for FUNCTION – Challenge & Solution 3
Lecture 548 Creating Pythagoras Theorem FUNCTION – Challenge & Solution 4
Lecture 549 CODE: Creating Pythagoras Theorem FUNCTION – Challenge & Solution 4
Lecture 550 Altering or Updating FUNCTION – Challenge & Solution 5
Lecture 551 CODE: Altering or Updating FUNCTION – Challenge & Solution 5
Lecture 552 Creating FUNCTION for Order details Line Total – Challenge & Solution 6
Lecture 553 CODE: Creating FUNCTION for Order details Line Total – Challenge & Solution 6
Lecture 554 Deleting a FUNCTION – Challenge & Solution 7
Lecture 555 CODE: Deleting a FUNCTION – Challenge & Solution 7
Section 60: SQL – Triggers
Lecture 556 The Purpose, The How and Types of TRIGGER
Lecture 557 TRIGGER – More Explanation With Diagram
Lecture 558 Steps to Creating a TRIGGER – Challenge & Solution 1a
Lecture 559 Creating After Update TRIGGER – Challenge & Solution 1b
Lecture 560 CODE: Creating After Update TRIGGER – Challenge & Solution 1b
Lecture 561 How to Check and Delete a TRIGGER – Challenge & Solution 1c
Lecture 562 CODE: How to Check and Delete a TRIGGER – Challenge & Solution 1c
Lecture 563 Creating After Update TRIGGER – Another Method – Challenge & Solution 1d
Lecture 564 CODE: Creating After Update TRIGGER – Another Method – Challenge & Solution 1d
Lecture 565 Creating Conditional Update TRIGGER | Different Names – Challenge & Solution 2
Lecture 566 CODE: Creating Conditional Update TRIGGER | Different Names – Challenge & Soln 2
Lecture 567 Creating AfterUpdate MySQL TRIGGER | Above USD$5k – Challenge & Solution 3
Lecture 568 CODE: Creating AfterUpdate MySQL TRIGGER | Above USD$5k – Challenge & Solution 3
Lecture 569 After Insert Error Message MySQL TRIGGER – Challenge & Solution 4
Lecture 570 CODE: After Insert Error Message MySQL TRIGGER – Challenge & Solution 4
Lecture 571 TRIGGER with SIGNAL SQLSTATE for Null Value – Challenge & Solution 5
Lecture 572 CODE: TRIGGER with SIGNAL SQLSTATE for Null Value – Challenge & Solution 5
Lecture 573 Multiple lines of TRIGGER – Many in One – Challenge & Solution 6
Lecture 574 CODE: Multiple lines of triggers – Many in One – Challenge & Solution 6
Lecture 575 SQL SIGNAL SQLSTATE ERROR MESSAGE TRIGGER – Challenge & Solution 7
Lecture 576 CODE: SQL SIGNAL SQLSTATE ERROR MESSAGE TRIGGER – Challenge & Solution 7
Lecture 577 Fraud Detection – After Delete TRIGGER – Challenge & Solution 8
Lecture 578 CODE: Fraud Detection – After Delete TRIGGER – Challenge & Solution 8
Section 61: RESEARCH DATA SET – A Complete Example – Lots Of Challenges & Solutions
Lecture 579 Setting up database for challenges with attached downloadable resource
Lecture 580 Nested Subquery & JOIN methods | < 1million – Challenge & Solution 1
Lecture 581 CODE:Nested Subquery & JOIN methods | < 1million – Challenge & Solution 1
Lecture 582 Nested Subquery | Budget above average – Challenge & Solution 2
Lecture 583 CODE: Nested Subquery | Budget above average – Challenge & Solution 2
Lecture 584 Nested Subquery & More Query Tweaking – Challenge & Solution 3
Lecture 585 CODE: Nested Subquery & More Query Tweaking – Challenge & Solution 3
Lecture 586 Nested Subquery, INNER JOIN, GROUP BY, HAVING – Challenge & Solution 4
Lecture 587 CODE: Nested Subquery, INNER JOIN, GROUP BY, HAVING – Challenge & Solution 4
Section 62: CAR SHOP DATA SET – A Complete Example – Lots Of Challenges & Solutions
Lecture 588 Intro
Lecture 589 CarShop Resource Details
Lecture 590 Fetching Names of Cars – Challenge & Solution 1
Lecture 591 Names & Price of Cars – Challenge & Solution 2
Lecture 592 Cars at a specific price – Challenge & Solution 3
Lecture 593 Between two prices of cars – Challenge & Solution 4
Lecture 594 Counting Cars – Challenge & Solution 5
Lecture 595 Price List of Cars – Challenge & Solution 6
Lecture 596 Price List For Cambodia Customers – Challenge & Solution 7
Lecture 597 Car Average Price – Challenge & Solution 8
Lecture 598 The most expensive car – Challenge & Solution 9
Lecture 599 Most Expensive Cars – Challenge & Solution 10
Lecture 600 Honda & Toyota – Challenge & Solution 11
Lecture 601 All details from two tables – Challenge & Solution 12
Lecture 602 Specific fields from two tables – Challenge & Solution 13
Lecture 603 Counting Cars Per Manufacturer – Challenge & Solution 14
Lecture 604 Average Price Per Manufacturer – Challenge & Solution 15
Lecture 605 Manufacturer Average Car Price Above $35,000 – Challenge & Solution 16
Lecture 606 The Cheapest Car – Challenge & Solution 17
Lecture 607 The Most Expensive Car – Challenge & Solution 18
Lecture 608 Data Insert – Challenge & Solution 19
Lecture 609 Correcting Wrong Data – Challenge & Solution 20
Lecture 610 Discounted Prices I – Challenge & Solution 21
Lecture 611 Discounted Price II – Challenge & Solution 22
Lecture 612 VIEW for price list – Challenge & Solution 23
Section 63: CAMERA SUPPLIERS DATA SET – A Complete Example – Lots Of Challenges & Solutions
Lecture 613 Read Me First!
Lecture 614 What is the current database selected? – Assignment 1
Lecture 615 What is the current database selected? – Assignment 1 Solution
Lecture 616 What are the available tables in the database? – Assignment 2
Lecture 617 What are the available tables in the database? – Assignment 2 Solution
Lecture 618 Display the details of each of the table in the database – Assignment 3
Lecture 619 Display the details of each of the table in the database -Assignment 3 Solution
Lecture 620 SQL Query to retrieve data from one table – Assignment 4
Lecture 621 SQL Query to retrieve data from one table – Solution to Assignment 4
Lecture 622 Using Alias – Assignment 5
Lecture 623 Using Alias – Solution to Assignment 5
Lecture 624 Retrieving data across two tables using JOIN – Assignment 6
Lecture 625 Retrieving data across two tables using JOIN – Solution to Assignment 6
Lecture 626 Retrieving data across three tables using JOIN – Assignment 7
Lecture 627 Retrieving data across three tables using JOIN – Solution to Assignment 7
Lecture 628 Aggregate – sum, average, minimum, maximum – Assignment 8
Lecture 629 Aggregate – sum, average, minimum, maximum – Solution to Assignment 8
Lecture 630 GROUP BY & Average – Assignment 9
Lecture 631 GROUP BY & Average – Solution to Assignment 9
Lecture 632 GROUP BY; RIGHT, LEFT, INNER & NO JOIN – Assignment 10
Lecture 633 GROUP BY; RIGHT, LEFT, INNER & NO JOIN – Solution to Assignment 10
Lecture 634 VIEW for three tables JOIN – Assignment 11
Lecture 635 VIEW for three tables JOIN – Solution to Assignment 11
Lecture 636 INNER JOIN, Subquery & EXISTS – Assignment 12
Lecture 637 INNER JOIN, Subquery & EXISTS – Solution to Assignment 12
Lecture 638 Updating Table with 5% Increase in Salary – Assignment 13
Lecture 639 Updating Table with 5% Increase in Salary – Solution Assignment 13
Lecture 640 INNER JOIN and SubQuery – Assignment 14
Lecture 641 INNER JOIN and SubQuery – Solution Assignment 14
Lecture 642 INNER JOIN & AND – Assignment 15
Lecture 643 INNER JOIN & AND – Solution Assignment 15
Lecture 644 INNER JOIN & SubQuery – Assignment 16
Lecture 645 INNER JOIN & SubQuery – Solution to Assignment 16
Lecture 646 SUBQUERY & LIMIT – Assignment 17
Lecture 647 SUBQUERY & LIMIT – Solution to Assignment 17
Lecture 648 UCASE – Assignment 18
Lecture 649 UCASE – Solution to Assignment 18
Section 64: ==>>MORE TASKS (The More You Do, The More You Learn)
Lecture 650 More Tasks
Section 65: SQL – More Task 1
Lecture 651 Employees With Same Salary – Task 1
Lecture 652 Solution: Employees With Same Salary – Task 1
Lecture 653 CODE: Employees With Same Salary – Task 1
Section 66: SQL – More Task 2
Lecture 654 Duplicate Title – Task 2
Lecture 655 Solution: Duplicate Title – Task 2
Lecture 656 CODE: Duplicate Title – Task 2
Section 67: SQL – More Task 3
Lecture 657 Excluding Titles – Task 3
Lecture 658 Solution – Excluding Titles – Task 3
Lecture 659 CODE: Excluding Titles – Task 3
Section 68: SQL – More Task 4
Lecture 660 Eight & Last Alphabet ‘n’ – Task 4
Lecture 661 Solution: Eight & Last Alphabet ‘n’ – Task 4
Lecture 662 CODE: Eight & Last Alphabet ‘n’ – Task 4
Section 69: SQL – More Task 5
Lecture 663 Even Rows – Task 5
Lecture 664 Solution: Even Rows – Task 5
Lecture 665 CODE: Even Rows – Task 5
Section 70: SQL – More Task 6
Lecture 666 Odd Rows – Task 6
Lecture 667 Solution: Odd Rows – Task 6
Lecture 668 CODE: Odd Rows – Task 6
Section 71: SQL – More Task 7
Lecture 669 Second to Fourth – Task 7
Lecture 670 Solution: Second to Fourth – Task 7
Lecture 671 CODE: Second to Fourth – Task 7
Section 72: SQL – More Task 8
Lecture 672 Counting Employee with "SALES" – Task 8
Lecture 673 Solution: Counting Employee with "SALES" – Task 8
Lecture 674 CODE: Counting Employee with "SALES" – Task 8
Section 73: SQL – More Task 9
Lecture 675 Using Sub Query – Second to the Highest Salary – Task 9
Lecture 676 Solution: Using Sub Query – Second to the Highest Salary – Task 9
Lecture 677 CODE: Using Sub Query – Second to the Highest Salary – Task 9
Section 74: SQL – More Task 10
Lecture 678 Tricky Exercise – Task 10
Lecture 679 Solution: Tricky Exercise – Task 10
Lecture 680 CODE: Tricky Exercise – Task 10
Section 75: SQL – More Task 11
Lecture 681 Tricky Exercise – Task 11
Lecture 682 Solution: Tricky Exercise – Task 11
Lecture 683 CODE: Tricky Exercise – Task 11
Section 76: SQL – More Task 12
Lecture 684 Tricky Exercise – Task 12
Lecture 685 Solution: Tricky Exercise – Task 12
Lecture 686 CODE: Tricky Exercise – Task 12
Lecture 687 Tricky Exercise – Task 12b
Lecture 688 Solution: Tricky Exercise – Task 12b
Lecture 689 CODE: Tricky Exercise – Task 12b
Section 77: SQL – More Task 13
Lecture 690 Tricky Exercise – Task 13
Lecture 691 Solution: Tricky Exercise – Task 13
Lecture 692 CODE: Tricky Exercise – Task 13
Section 78: SQL – More Task 14
Lecture 693 Tricky Exercise – Task 14
Lecture 694 Solution: Tricky Exercise – Task 14
Lecture 695 CODE: Tricky Exercise – Task 14
Section 79: SQL – PAUSE and LEARN: Using Fewer Columns & Subquery in JOINS
Lecture 696 Using Fewer Columns From SUBQUERY With JOIN
Lecture 697 CODE: Using Fewer Columns From SUBQUERY With JOIN
Lecture 698 Using WITH, SUBQUERY & INNER JOIN
Lecture 699 CODE: Using WITH, SUBQUERY & INNER JOIN
Section 80: SQL – More Task 15
Lecture 700 Tricky Exercise – Task 15
Lecture 701 Solution: Tricky Exercise – Task 15
Lecture 702 CODE: Tricky Exercise – Task 15
Section 81: SQL – More Task 16
Lecture 703 Tricky Exercise – task 16
Lecture 704 Solution: Tricky Exercise – task 16
Lecture 705 CODE: Tricky Exercise – task 16
Section 82: SQL – More Task 17
Lecture 706 Tricky Exercise – Task 17
Lecture 707 Solution: Tricky Exercise – Task 17
Lecture 708 CODE: Tricky Exercise – Task 17
Section 83: SQL – DATE_FORMAT() <<== Understanding Me First Before Task 18)
Lecture 709 Introduction
Lecture 710 Day of the Week
Lecture 711 Day of the Month
Lecture 712 Day of the Year
Lecture 713 Week of the Year
Lecture 714 Month of the Year
Lecture 715 Year from given DateTime
Lecture 716 Second, Minute, Hour. AM and PM from DateTime
Section 84: SQL – More Task 18
Lecture 717 Tricky Exercise – Task 18
Lecture 718 Solution: Tricky Exercise – Task 18
Lecture 719 CODE: Tricky Exercise – Task 18
Section 85: ==>EXTRA SECTION! Combining SQL: MySQL and Python
Lecture 720 Introduction to Combining SQL and Python
Section 86: Combining SQL and Python – Installation of MySQL Connector
Lecture 721 Installation of MySQL Connector for Python
Lecture 722 CODE: Installation of MySQL Connector for Python
Section 87: Combining SQL and Python -Create Database & Table, Show & Describe Table
Lecture 723 Creating Database & Show Databases From Python
Lecture 724 CODE: Creating Database & Show Databases From Python
Lecture 725 Creating a Table, Show Table & Describe Table
Lecture 726 CODE: Creating a Table, Show Table & Describe Table
Section 88: Combining SQL and Python – Insert a Row, Insert Multiple Rows & Select
Lecture 727 Insert A Row of Data Into A Table & Select
Lecture 728 CODE: Insert A Row of Data Into A Table & Select
Lecture 729 Insert Multiple Rows of Data Into A Table
Lecture 730 CODE: Insert Multiple Rows of Data Into A Table
Section 89: Combining SQL and Python – Row Counting, FetchOne, FetchAll
Lecture 731 Counting the numbers of rows
Lecture 732 CODE: Counting the numbers of rows
Lecture 733 FetchOne vs FetchAll
Lecture 734 CODE: FetchOne vs FetchAll
Section 90: Combining SQL and Python – Filter, Wildcard
Lecture 735 Select Filter with Python
Lecture 736 CODE: Select Filter with Python
Lecture 737 SQL Wildcard with Python
Lecture 738 CODE: SQL Wildcard with Python
Section 91: ==>>EXTRA SECTION! Business Intelligence and Analytics with Tableau & SQL
Lecture 739 Introduction to this section
Section 92: Combining SQL and Tableau – Business Intelligence Introduction
Lecture 740 Business Intelligence – Introduction & Definition
Lecture 741 Business Intelligence Process
Section 93: Combining SQL and Tableau – Tableau Installation
Lecture 742 How to Download and Install Tableau
Section 94: Combining SQL and Tableau – What-Is-What In Tableau
Lecture 743 Tableau – What-Is-What In Tableau – I
Lecture 744 Tableau – What-Is-What In Tableau – II
Lecture 745 Tableau – What-Is-What In Tableau – III
Section 95: Combining SQL and Tableau – Connecting MySQL to Tableau
Lecture 746 Connecting MySQL to Tableau
Section 96: Combining SQL and Tableau – Database Querying & Visualisation
Lecture 747 Tableau & MySQL: Querying SQL Database from Tableau
Lecture 748 Tableau & MySQL: Visualising CarShop Dataset
Section 97: Combining SQL and Tableau – Challenge & Solution
Lecture 749 Tableau & SQL Challenge – Gross Sales and Net Sales Report
Section 98: Congratulation !
Lecture 750 Check out my other courses
All Levels – Beginners, Intermediate & Experts
Homepage

www.udemy.com/course/the-complete-sql-master-bootcamp-sql-database-beginner-to-mysql-expert/