The Complete MySQL Bootcamp: Become an Expert in SQL & MySQL
3.7 (219 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
12,969 students enrolled

The Complete MySQL Bootcamp: Become an Expert in SQL & MySQL

In our complete MySQL Bootcamp you will learn how to write complete queries, build real web applications, & so much more
3.7 (219 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
12,969 students enrolled
Last updated 11/2018
English
English [Auto]
Current price: $129.99 Original price: $199.99 Discount: 35% off
13 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 8.5 hours on-demand video
  • 3 articles
  • 56 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Students will be able to build web applications using PHP and MySQL
  • Students will be able to create small and big databases using SQL and MySQL
  • Students will be able to write simple and complex queries
  • Students will be able to write complex queries on tables.
  • Students will be able to fluently understand and apply SQL and MySQL for future jobs and freelancing positions
Course content
Expand all 98 lectures 08:14:53
+ Databases and Queries
12 lectures 56:44
Creating Databases
04:38
Dropping Databases
03:19
Data Types
03:52
Creating Table
07:57
Dropping Table
04:09
Alter Table
08:10
Inserting Data Into Database
08:05
Inserting Multiple Data Records
03:22
Deleting Single Record
03:01
Deleting Multiple Records
02:18
Truncate
02:03
Inserting Fake Data
05:50
+ SQL Statements Fundamentals
13 lectures 01:09:29
Statement Basics
00:47
The Select Statement
09:00
SELECT DISTINCT
04:14
WHERE
09:52
AS
02:56
LIMIT and Offset
02:58
SELECT COUNT
04:09
Between
02:07
IN
02:49
Order By
05:44
Aggregate Function
04:27
Group By
14:42
Having
05:44
+ 4 Create, Read, Update, Delete (CRUD)
5 lectures 19:50
Introduction to CRUD
02:33
Create
03:20
Read
02:39
Update
05:35
Delete
05:43
+ Data Types and Operators
10 lectures 01:05:47
Introduction
00:42
Char
11:09
Decimal
07:29
Date and Time
08:26
Current Time and Date
04:12
Date and Time Functions
07:48
Date Diff
06:41
DATEADD
04:35
TIMESTAMP and CURRENTTIMESTAMP
10:43
Date Format
04:02
+ String and Mathematical Functions
14 lectures 34:15
Introduction to String and Mathematical Functions
02:16
Sub String
02:25
Concatenation
03:05
ASCII
02:27
BIN
02:05
TRIM
02:22
String Length
02:21
Upper and Lower Case
03:09
Reverse
02:13
String Replace
04:47
String Compare
02:59
Introduction to Mathematical Functions
00:44
Rand
01:28
Round
01:54
+ Joins and Relationships
8 lectures 56:17
Introduction to Relationships
04:58
Types Of Relation
06:17
One to Many Relation
07:30
Querying Table
05:58
Cross Join
02:14
Inner Join
15:54
Left Join
09:00
Right Join
04:26
+ PROJECT I : Twitter Clone Design & Development
10 lectures 01:16:25
Our Entities
03:27
Working with Users Schema
08:43
Tweets Schema
10:15
Tweet Replies
14:39
Relation Between Users and Replies
04:42
Tweet Has Reply
06:10
Like and its Relation
20:43

All Project Codes are Included in this file.

Project Codes
00:01
+ Project II : Contact Diary Web Application
11 lectures 59:53
Building User Interface (UI)
08:11
Connecting to Database
06:24
Adding Contacts to Database
07:27
Contact Lists
04:42
Deleting From Table
06:03
Details of Contacts
07:40
Update Contacts
08:15
Checks
03:40

Contains Project DB Schema design and its php files.


Project & DB Schema
00:02
+ BONUS: Git and Github
7 lectures 35:20
Introduction to Git and Github
02:02
Git Installation
03:41
Cloning From GitHub
05:46
Repositories
05:35
Pushing on GitHub
07:41
Pull From GitHub
03:13
Branches Basics
07:22
Requirements
  • You do not need any SQL, MySQL or Database experience! We start from scratch!
  • Students will need a working computer like PC, MAC, or Linux for this course - All are welcome!
  • No prior knowledge is needed! This class is for beginners, intermediates, and experts!
Description
  • Want To Learn MySQL From Scratch?

  • Have you always wanted to Learn MySQL and SQL, but you just don't know where to start? 

  • Or maybe you have started, but you would like to learn more in depth! 

Then The Complete MySQL Bootcamp: Become an Expert in SQL & MySQL IS FOR YOU! 

_________________________________________________________________________

Who Should Learn MySQL and SQL

Learning SQL and MySQL is an easy way to increase your income from the comfort of your own home!

The reason for this is because it is in very high demand! 

In fact, many of the biggest companies in the world use MySQL, like Amazon, Apple, Twitter, Uber, Airbnb, and many others. 

For this reason, and many others, we highly recommend you think about learning MySQL and SQL! 

_________________________________________________________________________

What is  SQL and MySQL? 

MySQL is the most popular open source SQL database in the world. This is why it is so important to begin learning about today! 

In this class we will discuss in more depth about SQL and MySQL, the differences, and much more! 

Why This Course Is Different  

Our course gives you step by step hands on real world application in more than 8.5+ hours of high quality video! Not only that, but Javed is an expert and has an ease when teaching his students about MySQL and SQL!

SQL and MySQL are some of the most highly sought after in-demand skills in the industry today.

Whether you are a beginner or an experienced programmer, you can find MySQL training that meets your needs.

This course is a comprehensive introduction to SQL and MySQL.

Whether you work in sales, marketing, or you want to build your own apps, learning SQL and MySQL is vital to solving business questions and problem with data! 

In our complete MySQL Bootcamp you will learn a solid foundation in databases that is both fun and engaging!

You will also get help from our instructor team if you ever run into any problems with MySQL and SQL! 

In our complete MySQL and SQL Bootcamp course you will learn:

  • MySQL configurations from scratch.

  • The basic syntax of MySQL

  • How Relation works.

  • How Joins works and how to join two or more tables.

  • How to Design and Develop Schemes

  • How to Write complex queries.

  • How to build Real World Projects.

  • How to Build Web Applications with PHP.

  • How to build data structure of Social networking website.

  • All of this and so much more! 

By the time you finish our course you will be able to:

  • Fluently use SQL and MySQL

  • Write complex queries

  • Build real web applications with PHP 

  • Design and Develop Schemes

  • Job skills and so much more! 

This course also includes exercises, projects, and step by step tutorials.

Learning SQL and MySQL is a great way to increase your income and boost your professional development and career.

But thats not all... 

The benefits to our course an absolutely unlimited! 

Check out some of the recent review from our students

So let’s do this! Enroll today and start learning MySQL and SQL today!

_________________________________________________________________________

With the right mindset, understanding, and application, you will instantly begin learning how to use MySQL today! 

When I learn something new I add it to the course -at no additional cost to you! This is a course that will continue to add more and more to every aspect of your life.

In addition to the Udemy 30-day money back guarantee, you have my personal guarantee that you will love what you learn in this course.

_________________________________________________________________________

What I can't do in this Course..

I can't guarantee your success – this course does take work on your part. But it can be done!

I am also not responsible for your actions. You are responsible for 100% of the decisions and actions you make while using this course.

_________________________________________________________________________

It's time to take action! This course will not remain this price forever! 

Click the "Buy Now" button, top right, Today!

Every hour you delay is costing you money...

See you in the course!

Sincerely,

Joe Parys and Muhammad Javed

Who this course is for:
  • This course is designed especially for Web developers, database developers, and programmers!
  • This course takes you from beginner to advanced! All students are welcome to join!