The Complete MySQL Bootcamp

The Complete MySQL Bootcamp

3 Reviews
1411 Enrolled
8 Hours
Deal Price$8.99
Suggested Price
$36.00
75% Off
🔥 1,000+ Sold! Selling Fast
The Complete MySQL Bootcamp
3 Reviews
$8.99$36.0075% OFF
The Complete MySQL Bootcamp: Become an Expert in SQL & MySQL

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
The Complete MySQL Bootcamp
3 Reviews
$8.99$36.0075% OFF
View similar items
DescriptionInstructorImportant DetailsReviewsRelated Products

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

JP
Joe ParysJoe Parys | Best-Selling Instructor Proudly Serving 500,000+ Students
4.3/5 Instructor Rating: ★ ★ ★ ★ ★ ★
Joe Parys is a best-selling instructor, certified life coach, professional motivational speaker, entrepreneur, licensed psychology teacher and head basketball coach! His main areas of expertise are teaching, coaching, public speaking, personal development, personal transformation, the human mind, maximizing human potential, motivation and goal setting.

Joe Parys is an entrepreneur running his own life coaching and motivational speaking business. Joe has spoken and taught his courses in numerous high schools in the United States and continues to travel around the country inspiring students of all ages.

603,361 Total Students
41,524 Reviews

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
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Any device with basic specifications

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
3 Reviews
4.7/ 5
All reviews are from verified purchasers collected after purchase.
SS

Sridharan Srinivasan

Verified Buyer

For one, it was a great deal as usual. Product code and access was very easy and straightforward.

Apr 27, 2023
Charles Beam profile picture

Charles Beam

Verified Buyer

Perfect for beginners! If you’re someone looking to start learning what SQL is all about, then this is the training/product for you.

May 17, 2020
ES

Emilio Santos Yerga

Verified Buyer

Mar 28, 2019
Your Cart
Your cart is empty. Continue Shopping!
Processing order...