The Complete MySQL Bootcamp

3 Reviews

1335 Enrolled

8 Hours

$8.99$36.00

Save 75%

159 Lessons (8h)

INTRODUCTION TO MYSQL
Would You Like To Learn MySQL From Scratch?!2:10
0.5) Welcome to the Complete MySQL Course!2:33
1 Introductin to Intro3:29
2 How to Use MySQL3:40
3 Tooling and isntalling mysql2:44
4 Tooling and Hello world4:38
DATABASES AND QUERIES
1 Creating Database4:38
1 Creating Databases
2 Dropping Databases
2 Dropping Databases3:19
3 Data Types3:52
3 Data Types
4 Creating Table7:57
5 Dropping Table4:09
5 Dropping Table
6 Alter Table
6 Alter Table8:10
7 Inserting Data into Database8:05
7 Inserting Data into Database
8 Inserting Multiple Records3:22
8 Inserting Multiple Data
9 Deleting A Row3:01
9 Deleting A Row
10 Deleting Multiple Rows2:18
10 Deleting Multiple Rows
11 Truncate2:03
11 Truncate
12 Inserting Fake Data5:50
SQL Statements Fundamentals
1 Statements Basics0:47
1 Generate Fake Data
2 The Select Statement9:00
2 SELECT Statement
3 SELECT DISTINTC4:14
3 SELECT DISTINCT
4 WHERE9:52
4 WHERE
5 Alises AS
5 Alias AS2:56
6 LIMIT and Offset2:58
6 LIMIT and Offset
7 SELECT COUNT4:09
7 SELECT COUNT
8 Between2:07
8 Between
9 IN2:49
9 IN
10 Order By5:44
10 Order By
11 Aggregate Function4:27
11 Aggregate Functions
12 Group By14:42
12 Group by
13 HAVING5:44
13 HAVING
Create, Read, Update, Delete (CRUD)
1 Intro2:33
1 intro
2 Create3:20
2 Create
3 Read2:39
3 Read
4 Update
4 Update5:35
5 Delete
5 Delete5:43
Data Types and Operators
1 Intro0:42
2 CHAR11:09
2 CHAR
3 Decimal7:29
3 Date and Time
3 Decimal
4 Date and Time8:26
4 Date and Time
5 Current Time and Date
5 Current Time and Date4:12
6 Date and Time Functions
6 Date and Time Funcations7:48
7 DATEDIFF6:41
8 DATEADD4:35
8 DateADD
9 TIMEstamps and CURRENTTIME STAMP10:43
9 Timestamps and CURRENT TIME STAMP
10 SDate Format4:02
10 Date Format
Links
String and Mathematical Functions
1 Intro2:16
1 Substr
2 Substr2:25
3 Concat3:05
3 Concat
4 ASCII2:27
4 ASCII
5 BIN2:05
5 BIN
6 TRIM
6 TRIM2:22
7 String Length
7 String Length2:21
8 Upper and Lower Case3:09
8 Upper and Lower Case
9 Reverse2:13
9 Reverse
10 String Replace4:47
10 String Replace
11 String Compare2:59
11 String Compare
12 Intro to Maths Functions0:44
13 Rand1:28
13 Rand
14 Round1:54
14 Rand
Joins and Relationships
1 Introduction to Relationships4:58
1 Inner Join
2 Types Of Relation6:17
2 Cross Join
3 One to Many Relation - Free Preview7:30
3 Left Join
4 Querying Table5:58
5 Cross Join2:14
5 Querying Table
6 Inner Join15:54
7 Left Join9:00
8 Right Join4:26
PROJECT I : Twitter Clone Design & Development
1 Intro0:49
2 Our Entities Basics3:27
3 Working with Users Schema8:43
4 Tweets Schema10:15
5 Inserting Tweets6:56
6 Tweet Replies14:39
7 Relation Between Users and Replies4:42
8 Tweet Has Reply6:10
9 Likes and Its relation20:43
Porject Codes
Project II : Contact Diary Web Application
1 Intro3:44
2 Building UI8:10
3 Table Schema3:45
4 Connecting to Database6:24
5 Adding Contacts to Database7:27
6 Contact Lists4:42
7 Deleting From Table6:03
8 Details of Contact7:40
9 Update Contacts8:15
10 Checks3:40
contacts
edit
DB_SCHEMA
contacts
index
update
conn
details
delete
BONUS: Git and Github
1 Intro2:02
2 Git Installation3:41
3 Cloning From Github5:46
4 Repositories5:35
5 Pushing on github7:41
6 Pull from Github3:13
7 Branches Basics7:22
Course Summary, and Conclusion
MYSQL CONCLUSION1:37

Use The World's Most Popular Open-Source SQL Database to Solve Your Data Problems

Joe Parys

Instructor

Joe Parys is a certified life coach, professional motivational speaker, entrepreneur, licensed psychology teacher and head basketball coach for USA Basketball. His main areas of expertise are teaching, coaching, public speaking, personal development, personal transformation, the human mind, maximizing human potential, motivation and goal setting.

Description

Whether you work in marketing, sales, or app development, chances are you'll have questions that only data can solve, which is why virtually everyone can benefit from learning MySQL. Based on SQL (Structured Query Language), MySQL is the world's most popular open-source SQL database and is used by the likes of Amazon, Apple, Twitter, many other top companies. This course serves as your SQL and MySQL primer, walking you through the basic syntax, queries, and more so you can add this data-driven tool to your workflow.

Access 159 lectures & 8 hours of training 24/7
Learn how to fluently use SQL & MySQL
Explore the basic syntax of MySQL
Discover how to join two or more tables
Learn how to design and develop schemes
Explore building web applications with PHP
Learn how to build the data structure of a social networking website

Specs

Important Details

Length of time users can access this course: lifetime
Access options: web and mobile streaming
Certification of completion included
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: beginner

Terms

Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.

Your cart is empty. Continue Shopping!

Processing order...