SQL for Beginners: Learn SQL using MySQL and Database Design
4.5 (4,347 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.
22,237 students enrolled

SQL for Beginners: Learn SQL using MySQL and Database Design

Understand SQL using the MySQL database. Learn Database Design and Data Analysis with Normalization and Relationships
4.5 (4,347 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.
22,237 students enrolled
Last updated 2/2020
English
English [Auto-generated], French [Auto-generated], 5 more
  • German [Auto-generated]
  • Indonesian [Auto-generated]
  • Italian [Auto-generated]
  • Portuguese [Auto-generated]
  • Spanish [Auto-generated]
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 8 hours on-demand video
  • 29 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
  • Have a detailed knowledge and understanding of using MySQL, one of the most widely used databases in the world.
  • Obtained a knowledge of SQL, and MySQL, allows students to apply for jobs in the IT sector.
  • In-depth knowledge of database design will give students an edge over other applicants.
Course content
Expand all 122 lectures 07:51:05
+ Course Introduction
2 lectures 05:10

Welcome to the Course.

Preview 01:28

Syllabus Explanation .

Syllabus Explanation
03:42
+ Installation and Setup
8 lectures 01:01:07

Section Introduction.

Section Introduction
00:41

Databases, SQL and MySQL.

Databases, SQL and MySQL
03:08

Relational Database Management System.

Relational Database Management System
02:18

MySQL Installation for Windows.

Preview 15:00

MySQL Installation for Mac.

MySQL Installation for Mac
12:17

MySQL Installation for Linux.

MySQL Installation for Linux
11:07
MySQL Workbench Overview
13:13

Create Database.

Preview 03:23
+ Data Definition Language
7 lectures 26:08

Section Introduction.

Section Introduction
01:32

Data Types.

Preview 06:34

Primary and Foreign Keys.

Primary and Foreign Keys
02:53

Creating the Coffee Store Database.

Creating the Coffee Store Database
08:54

Modifying Tables: Adding and Removing Columns.

Modifying Tables: Adding and Removing Columns
03:08

Deleting Tables.

Deleting Tables
01:28

Truncating Tables.

Truncating Tables
01:39
+ More On Alter Table
9 lectures 38:37
Section Introduction
01:25
Creating Our Test Database
05:30
Add and Remove Primary Key
05:25
Add and Remove Foreign Key
04:56
Add Unique Constraint
03:25
Change Column Name
03:15
Change Column Data Type
04:44
Exercise 1
01:30
Solution 1
08:27
+ Data Manipulation Language
5 lectures 18:01

Section Introduction.

Section Introduction
00:50

Inserting Data Into Tables.

Preview 05:37

Updating Data in Tables.

Updating Data in Tables
06:07

Deleting Data from Tables.

Deleting Data from Tables
02:49

Completing the Coffee Store Database.

Completing the Coffee Store Database
02:38
+ Selecting from a Table
18 lectures 58:09

Section Introduction.

Section Introduction
01:14

Select Statement.

Select Statement
01:46

Where Clause.

Preview 04:53

Using Inequality Symbols.

Using Inequality Symbols
03:03

Null Values.

Null Values
03:10

Exercise 1.

Exercise 1
01:06

Solution 1.

Solution 1
03:55

In, Not In.

In, Not In
03:44

Between.

Between
04:04

Like.

Like
04:52

Order By.

Order By
06:19

Exercise 2.

Exercise 2
00:55

Solution 2.

Solution 2
04:23

Distinct.

Preview 05:11

Limit.

Limit
02:56

Column Name Alias.

Column Name Alias
02:03

Exercise 3.

Exercise 3
00:50

Solution 3.

Solution 3
03:45
+ Selecting From Multiple Tables
8 lectures 33:23

Section Introduction.

Section Introduction
01:08

What Are Joins?

What Are Joins?
03:08

Inner Join

Inner Join
08:55

Left Join.

Left Join
05:23

Right Join.

Right Join
03:15

Joining more than Two Tables.

Joining more than Two Tables
04:33

Exercise 1.

Exercise 1
01:06

Solution 1.

Solution 1
05:55
+ Database Design
10 lectures 39:41

Section Introduction.

Section Introduction
01:23

Normalization - What is it?

Preview 05:23

1st Normal Form (1NF)

1st Normal Form (1NF)
03:30

2nd Normal Form (2NF)

2nd Normal Form (2NF)
06:27

3rd Normal Form (3NF)

3rd Normal Form (3NF)
09:30

Relationships.

Relationships
01:05

Relationships - One to One

Relationships - One to One
02:30

Relationships - One to Many

Relationships - One to Many
02:00

Relationships - Many to Many

Relationships - Many to Many
04:00

Constraints.

Constraints
03:53
+ Creating a Cinema Booking System Database
10 lectures 41:11

Section Introduction

Section Introduction
01:11

Database Schema Overview

Database Schema Overview
07:26

Create Films Table 

Create Films Table
04:55

Create Customers Table 

Create Customers Table
02:53

Create Rooms Table 

Create Rooms Table
02:19

Create Screenings Table 

Create Screenings Table
04:45

Create Seats Table 

Preview 03:53

Create Bookings Table 

Create Bookings Table
03:52
Create Reserved_Seat Table
04:35

Insert the Data

Insert the Data
05:22
+ Aggregate Functions
12 lectures 33:39

Section Introduction

Section Introduction
00:41

What are Aggregate Functions

What are Aggregate Functions
02:30

Count

Count
02:38

Sum

Sum
02:36

Min and Max

Min and Max
02:39

Exercise 1

Exercise 1
00:46

Solution 1

Solution 1
04:09

Grouping Data 

Grouping Data
08:52

Having Clause

Having Clause
01:44

Exercise 2

Exercise 2
00:44

Solution 2

Solution 2
04:11
Requirements
  • A PC (Windows or Linux) or Mac is required
  • No prior knowledge of Databases, SQL or MySQL is needed.
Description

Have you heard that database skills are essential for developers to be skilled in and understand?

Are you wanting to understand SQL and databases in general, but don't know where to start?

Maybe you have a pressing need to learn about Database Design and/or Data Analysis but have not found a good place to learn.

Or perhaps you are a developer who wants to improve your career options by having skills in SQL and MySQL, one of the worlds most popular databases.

Whatever the reason you have arrived here, this course will...

Help you understand and apply SQL with MySQL, including Database Design and Data Analysis.

Having database skills is absolutely vital for developers to avoid getting left behind and to maximise job and consulting opportunities.

Key concepts you will learn and work with in this course.

SQL (Structured Query Language - very much an in-demand technology).
MySQL (one of the worlds most popular and widely used databases).
Database Design
Data Analysis

The database design section (normalization and relationships) isn't covered in the majority of SQL courses on Udemy.  You will struggle to find another MySQL course that has a section on this.   This section alone, will give you a huge edge over other applicants for jobs.

Through the course you will go through creating an example database for a cinema online booking system using concepts taught in the database design section.

Creating, Modifying and Deleting Tables in a Database (DDL)
Inserting, Updating and Deleting Data from Tables (DML)
Select Queries
Joins
Aggregate Functions
Subqueries
Database Design
Creating Databases.

In addition there are installation videos covering MySQL on Windows, Mac or Linux.

Not only does the course teach you SQL, but there are multiple exercises for you to try with video solutions to further help you understand the material.

Also note that while MySQL is the database of choice in this course, the SQL skills you acquire will work largely with any database.

Why enrolling in this course is the best decision you can make.

Become skilled as a database developer generally needs you to learn SQL, a database, and then database design.  Often this will require multiple courses.  However you learn all those topics, and data analysis in this one course.

Jon Avis, the instructor, has 4 years experience working as an IT Systems Engineer, and works with SQL and Databases everyday.  Part of his role as a Systems Engineer is to teach complex, technical subjects to colleagues which makes him the ideal instructor for this course.

Essentially, you are learning from someone who has all the professional training, skills, and experience needed to  teach you how to become proficient with SQL, MySQL and Database design as quickly as possible.

If you are ready to get that first paid programming job, or to move up to a more senior programming position, then this course is for you!

After completing this course, you will have the necessary skills to be able to use SQL confidently, have a solid understanding of MySQL and be skilled in database design.

The sooner you sign up for this course, the sooner you will have the skills and knowledge you need to increase your job or consulting opportunities.  

SQL and MySQL skills are in high demand, as is Database Design, and you will understand and be able to use both after going through this course.

Your new job or consulting opportunity awaits!  

Why not get started today?

Click the Signup button to sign up for the course!


Who this course is for:
  • Anyone who wants to learn how to use SQL and MySQL.