The Complete MySQL Bootcamp

2 Reviews
1269 Enrolled
8 Hours
$8.99$10.99$199.99
Price Drop - Extra 18% off
Save 95% -

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

JP
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.