https://i125.fastpic.org/big/2025/0726/c8/22f8fc2fac86c4f4f83cfff89d8721c8.jpg
Sql-Mysql Complete Master Bootcamp | Beginner-Expert (2023)
Last updated 12/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 8.01 GB | Duration: 20h 27m
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: Course Walkthrough, Case Study Demos & Introduction
Lecture 1 Course Syllabus Walkthrough
Lecture 2 For Absolute Beginner: SQL vs MySQL vs DBMS and Database vs Data
Lecture 3 For Absolute Beginner: Why Choosing MySQL?
Section 2: SQL - Installation & Fixing "Cannot Connect to MySQL Server"
Lecture 4 Installation of MySQL on MacOS
Lecture 5 RESOURCES: Installation of MySQL on MacOS
Lecture 6 How to fix Cannot Connect to MySQL Server - MacOS
Lecture 7 Installation of MySQL Server and Workbench on Windows
Lecture 8 How to fix Cannot Connect to MySQL Server - Windows
Section 3: SQL - Course Resources
Lecture 9 Database Resources for this Course
Lecture 10 How to use/run the resources
Section 4: SQL - Select Statement
Lecture 11 SELECT (Understanding Select for Absolute beginners)
Section 5: SQL - Database
Lecture 12 Database vs Table In SQL- Layman's Explanation - (Challenge & Solution)
Lecture 13 Creating A Database - Challenge & Solution 1
Lecture 14 CODE: Creating A Database - Challenge & Solution 1
Lecture 15 "IF NOT EXISTS" with CREATE DATABASE - Challenge & Solution 2
Lecture 16 CODE: "IF NOT EXISTS" with CREATE DATABASE - Challenge & Solution 2
Lecture 17 How To Check For Existing Databases - Challenge & Solution 3
Lecture 18 CODE: How To Check For Existing Databases - Challenge & Solution
Lecture 19 How To Delete A Database - Challenges & Solution 4
Lecture 20 CODE: How To Delete A Database - Challenges & Solution 4
Lecture 21 Using A Database - Challenge & Solution 5
Lecture 22 CODE: Using A Database - Challenge & Solution 5
Lecture 23 How To Check For The Selected Database in Use - Challenge & Solution 6
Lecture 24 CODE: How To Check For The Selected Database in Use - Challenge & Solution 6
Section 6: SQL - Create Table - Understanding the Syntax
Lecture 25 First Things First - TABLES
Lecture 26 IF NOT EXISTS with CREATE TABLE in SQL - MySQL
Lecture 27 CODE: IF NOT EXIST with CREATE TABLE in SQL-MySQL
Lecture 28 Purpose of ( ); In CREATE TABLE In SQL-MySQL
Lecture 29 Backticks In CREATE TABLE In SQL-MySQL
Lecture 30 CREATE TABLE In SQL-MySQl - First Time
Lecture 31 CODE: CREATE TABLE In SQL-MySQl - First Time
Section 7: SQL - Data Types
Lecture 32 Type of Data in MySQL
Lecture 33 MySQL Numeric Types
Lecture 34 TINYINT, SMALLINT, MEDIUMINT, INTEGER, BIGINT -Exact Numeric Data Types in MySQL
Lecture 35 DECIMAL & NUMERIC - Fixed Point Data Types in MySQL | Approximate Numeric I
Lecture 36 DECIMAL & NUMERIC - Fixed Point Data Types in MySQL | Approximate Numeric II
Lecture 37 REAL, FLOAT, DOUBLE - Floating Point Data Type in MySQL
Lecture 38 CHAR vs VARCHAR - String Data Types in MySQL
Lecture 39 BINARY & VARBINARY - String Data Types in MySQL
Lecture 40 BLOB & TEXT - String Data Types in MySQL
Lecture 41 ENUM - String Data Types in MySQL
Lecture 42 SET - String Data Types in MySQL
Lecture 43 DATE, TIME, DATETIME, TIMESTAMP & YEAR - Date and Time Data Types in MySQL
Section 8: SQL - Insert Query
Lecture 44 Inserting A Single Line of Data Into Table - 1st Method
Lecture 45 CODE: Inserting A Single Line of Data Into Table - 1st Method
Lecture 46 Inserting A Single Line of Data Into Table - 2nd Method
Lecture 47 CODE: Inserting A Single Line of Data Into Table - 2nd Method
Lecture 48 Inserting Multiple Lines of Data Into Table - 1st Method
Lecture 49 CODE: Inserting Multiple Lines of Data Into Table - 1st Method
Lecture 50 Inserting Multiple Lines of Data Into Table - 2nd Method
Lecture 51 CODE: Inserting Multiple Lines of Data Into Table - 2nd Method
Lecture 52 Inserting Multiple Lines of Data Into Table - 3rd Method
Lecture 53 CODE: Inserting Multiple Lines of Data Into Table - 3rd Method
Lecture 54 Inserting Null Value and Empty White Space Into Table
Lecture 55 CODE: Inserting Null Value and Empty White Space Into Table
Section 9: SQL - Candidate, Surrogate, Primary, Alternative & Foreign Key
Lecture 56 Candidate Key In SQL
Lecture 57 Surrogate Key In SQL
Lecture 58 Primary Key & Alternative Key In SQL
Lecture 59 Foreign Key In SQL
Section 10: SQL - Primary and Foreign Key Constraints | Alter Table
Lecture 60 Assigning A PRIMARY KEY (Three Methods) - Challenge & Solution 1
Lecture 61 CODE: Assigning A PRIMARY KEY (Three Methods) - Challenge & Solution
Lecture 62 Deleting A PRIMARY KEY - Challenge & Solution 2
Lecture 63 CODE: Deleting A PRIMARY KEY - Challenge & Solution 2
Lecture 64 Adding A PRIMARY KEY To Existing Column - Challenge & Solution 3
Lecture 65 CODE: Adding A PRIMARY KEY To Existing Column - Challenge & Solution 3
Lecture 66 Assigning A FOREIGN KEY - Challenge & Solution 4
Lecture 67 CODE: Assigning A FOREIGN KEY - Challenge & Solution 4
Lecture 68 Assigning A CONSTRAINT NAME To A FOREIGN KEY - Challenge & Solution 5
Lecture 69 CODE: Assigning A CONSTRAINT NAME To A FOREIGN KEY - Challenge & Solution 5
Lecture 70 Adding A FOREIGN KEY To Existing Table - Challenge & Solution 6
Lecture 71 CODE: Challenge & Solution 6 | Adding A FOREIGN KEY To Existing Table
Lecture 72 Challenge & Solution 7 | CONSTRAINT NAME & FOREIGN KEY To Existing Table
Lecture 73 CODE:CONSTRAINT NAME & FOREIGN KEY To Existing Table - Challenge & Solution 7
Lecture 74 Deleting A REFERENCED Parent Table - Challenge & Solution 8
Lecture 75 CODE: Deleting A REFERENCED Parent Table - Challenge & Solution 8
Lecture 76 Deleting A Column From A Table - Challenge & Solution 9
Lecture 77 CODE: Deleting A Column From A Table - Challenge & Solution 9
Lecture 78 Deleting A REFERENCED or CONSTRAINT Column - Challenge & Solution 10
Lecture 79 CODE: Deleting A REFERENCED or CONSTRAINT Column - Challenge & Solution 10
Section 11: SQL - Revisiting Select Statement
Lecture 80 Select All Rows and Columns - Challenge & Solution 1
Lecture 81 CODE: Select All Rows and Columns - Challenge & Solution 1
Lecture 82 Select Specific Columns - Challenge & Solution 2
Lecture 83 CODE: Select Specific Columns - Challenge & Solution 2
Lecture 84 Manager Demands for All Customers' Detail - Challenge & Solution 3
Lecture 85 CODE: Manager Demands for All Customers' Detail - Challenge & Solution 3
Lecture 86 Specific Customer's Details - Challenge & Solution 4
Lecture 87 CODE: Specific Customer's Details - Challenge & Solution 4
Section 12: SQL - Alias - AS
Lecture 88 ALIAS (AS) Introduction
Lecture 89 CODE: ALIAS (AS) Introduction
Lecture 90 Alias - Challenge & Solution
Lecture 91 CODE: Alias - Challenge & Solution
Section 13: SQL - Concat Function
Lecture 92 CONCAT() Introduction
Lecture 93 CODE: CONCAT() Introduction
Lecture 94 CONCAT() - Challenge & Solution 1
Lecture 95 CODE: Challenge & Solution 1 | CONCAT()
Lecture 96 CONCAT() - Challenge & Solution 2
Lecture 97 CODE: Challenge & Solution 2 | CONCAT()
Section 14: SQL - Order By Keyword
Lecture 98 ORDER BY Introduction
Lecture 99 ORDER BY ASC - Challenge & Solution 1
Lecture 100 CODE: ORDER BY ASC - Challenge & Solution 1
Lecture 101 ORDER BY DESC - Challenge & Solution 2
Lecture 102 CODE: ORDER BY DESC - Challenge & Solution 2
Lecture 103 ORDER BY DESC & CONCAT - Challenge & Solution 3
Lecture 104 CODE: ORDER BY DESC & CONCAT - Challenge & Solution 3
Lecture 105 ORDER BY ASC - Challenge & Solution 4
Lecture 106 CODE: ORDER BY ASC - Challenge & Solution 4
Section 15: SQL - Limit Clause
Lecture 107 LIMIT - Challenge & Solution 1
Lecture 108 CODE: LIMIT - Challenge & Solution 1
Lecture 109 LIMIT - Challenge & Solution 2
Lecture 110 CODE: LIMIT - Challenge & Solution 2
Lecture 111 LIMIT - Challenge & Solution 3
Lecture 112 CODE: LIMIT - Challenge & Solution 3
Section 16: SQL - Order By & Rand Function
Lecture 113 ORDER BY with RAND - Challenge & Solution
Lecture 114 CODE: ORDER BY with RAND - Challenge & Solution
Section 17: SQL - Comments
Lecture 115 SINGLE & MULTILINE COMMENTS in SQL-MySQL
Section 18: SQL - Where Clause
Lecture 116 Introduction to WHERE
Lecture 117 Northwind Data Set | Should run to work along
Lecture 118 UK Customers filter - Challenge & Solution 1
Lecture 119 CODE: UK Customers filter - Challenge & Solution 1
Lecture 120 Specific Customer filter - Challenge & Solution 2
Lecture 121 CODE: Specific Customer filter - Challenge & Solution 2
Lecture 122 Specific Employee filter - Challenge & Solution 3
Lecture 123 CODE: Specific Employee filter - Challenge & Solution 3
Lecture 124 Product with specific Price filter - Challenge & Solution 4
Lecture 125 CODE: Product with specific Price filter - Challenge & Solution 4
Lecture 126 Getting a list of Sales Representatives - Challenge & Solution 5
Lecture 127 CODE: Getting a list of Sales Representatives - Challenge & Solution 5
Lecture 128 None Spanish Customers using != , <> - Challenge & Solution 6
Lecture 129 CODE: None Spanish Customers using != , <> - Challenge & Solution 6
Lecture 130 Products Supplied by a Specific Customer - Challenge & Solution 7
Lecture 131 CODE: Products Supplied by a Specific Customer - Challenge & Solution 7
Lecture 132 All Suppliers Except. using NOT, <>, ! - Challenge & Solution 8
Lecture 133 CODE: All Suppliers Except. using NOT, <>, ! - Challenge & Solution 8
Lecture 134 Products above certain Price | Greater Than > - Challenge & Solution 9
Lecture 135 CODE: Products above certain Price | Greater Than > - Challenge & Solution 9
Lecture 136 Products Below Certain Price| Less Than < - Challenge & Solution 10
Lecture 137 CODE: Products Below Certain Price| Less Than < - Challenge & Solution 10
Lecture 138 Unit In Stock | Less Than < - Challenge & Solution 11
Lecture 139 CODE:Unit In Stock | Less Than < - Challenge & Solution 11
Lecture 140 Minimum Wages | Less Than < - Challenge & Solution 12
Lecture 141 CODE: Minimum Wages | Less Than < - Challenge & Solution 12
Lecture 142 Gifts for Customers | Greater Than - Challenge & Solution 13
Lecture 143 CODE: Gifts for Customers | Greater Than - Challenge
Видео
