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

Instructor

Jon Avis

Category

Databases

Reviews

(1,836 reviews)

Take this course

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!

Requirements

A PC (Windows or Linux) or Mac is required
No prior knowledge of Databases, SQL or MySQL is needed.

What you will 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.

Who should attend

Anyone who wants to learn how to use SQL and MySQL.

Is available on google app?

Yes

Is available on ios?

Yes

Course Features

Lectures 122
Quizzes 0
Exercises 0
Duration 8 hours
Skill level Beginner Level
Students 8281
Last Updated October, 2019

Course Introduction 05:10
- Lecture
  
  Welcome to the Course 01:28
- Lecture
  
  Syllabus Explanation 03:42
Installation and Setup 01:01:07
- Lecture
  
  Section Introduction 00:41
- Lecture
  
  Databases, SQL and MySQL 03:08
- Lecture
  
  Relational Database Management System 02:18
- Lecture
  
  MySQL Installation for Windows 15:00
- Lecture
  
  MySQL Installation for Mac 12:17
- Lecture
  
  MySQL Installation for Linux 11:07
- Lecture
  
  MySQL Workbench Overview 13:13
- Lecture
  
  Create Database 03:23
Data Definition Language 26:08
- Lecture
  
  Section Introduction 01:32
- Lecture
  
  Data Types 06:34
- Lecture
  
  Primary and Foreign Keys 02:53
- Lecture
  
  Creating the Coffee Store Database 08:54
- Lecture
  
  Modifying Tables: Adding and Removing Columns 03:08
- Lecture
  
  Deleting Tables 01:28
- Lecture
  
  Truncating Tables 01:39
More On Alter Table 38:37
- Lecture
  
  Section Introduction 01:25
- Lecture
  
  Creating Our Test Database 05:30
- Lecture
  
  Add and Remove Primary Key 05:25
- Lecture
  
  Add and Remove Foreign Key 04:56
- Lecture
  
  Add Unique Constraint 03:25
- Lecture
  
  Change Column Name 03:15
- Lecture
  
  Change Column Data Type 04:44
- Lecture
  
  Exercise 1 01:30
- Lecture
  
  Solution 1 08:27
Data Manipulation Language 18:01
- Lecture
  
  Section Introduction 00:50
- Lecture
  
  Inserting Data Into Tables 05:37
- Lecture
  
  Updating Data in Tables 06:07
- Lecture
  
  Deleting Data from Tables 02:49
- Lecture
  
  Completing the Coffee Store Database 02:38
Selecting from a Table 58:09
- Lecture
  
  Section Introduction 01:14
- Lecture
  
  Select Statement 01:46
- Lecture
  
  Where Clause 04:53
- Lecture
  
  Using Inequality Symbols 03:03
- Lecture
  
  Null Values 03:10
- Lecture
  
  Exercise 1 01:06
- Lecture
  
  Solution 1 03:55
- Lecture
  
  In, Not In 03:44
- Lecture
  
  Between 04:04
- Lecture
  
  Like 04:52
- Lecture
  
  Order By 06:19
- Lecture
  
  Exercise 2 00:55
- Lecture
  
  Solution 2 04:23
- Lecture
  
  Distinct 05:11
- Lecture
  
  Limit 02:56
- Lecture
  
  Column Name Alias 02:03
- Lecture
  
  Exercise 3 00:50
- Lecture
  
  Solution 3 03:45
Selecting From Multiple Tables 33:23
- Lecture
  
  Section Introduction 01:08
- Lecture
  
  What Are Joins? 03:08
- Lecture
  
  Inner Join 08:55
- Lecture
  
  Left Join 05:23
- Lecture
  
  Right Join 03:15
- Lecture
  
  Joining more than Two Tables 04:33
- Lecture
  
  Exercise 1 01:06
- Lecture
  
  Solution 1 05:55
Database Design 39:41
- Lecture
  
  Section Introduction 01:23
- Lecture
  
  Normalization - What is it? 05:23
- Lecture
  
  1st Normal Form (1NF) 03:30
- Lecture
  
  2nd Normal Form (2NF) 06:27
- Lecture
  
  3rd Normal Form (3NF) 09:30
- Lecture
  
  Relationships 01:05
- Lecture
  
  Relationships - One to One 02:30
- Lecture
  
  Relationships - One to Many 02:00
- Lecture
  
  Relationships - Many to Many 04:00
- Lecture
  
  Constraints 03:53
Creating a Cinema Booking System Database 41:11
- Lecture
  
  Section Introduction 01:11
- Lecture
  
  Database Schema Overview 07:26
- Lecture
  
  Create Films Table 04:55
- Lecture
  
  Create Customers Table 02:53
- Lecture
  
  Create Rooms Table 02:19
- Lecture
  
  Create Screenings Table 04:45
- Lecture
  
  Create Seats Table 03:53
- Lecture
  
  Create Bookings Table 03:52
- Lecture
  
  Create Reserved_Seat Table 04:35
- Lecture
  
  Insert the Data 05:22
Aggregate Functions 33:39
- Lecture
  
  Section Introduction 00:41
- Lecture
  
  What are Aggregate Functions 02:30
- Lecture
  
  Count 02:38
- Lecture
  
  Sum 02:36
- Lecture
  
  Min and Max 02:39
- Lecture
  
  Average 02:09
- Lecture
  
  Exercise 1 00:46
- Lecture
  
  Solution 1 04:09
- Lecture
  
  Grouping Data 08:52
- Lecture
  
  Having Clause 01:44
- Lecture
  
  Exercise 2 00:44
- Lecture
  
  Solution 2 04:11
Subqueries 28:40
- Lecture
  
  Section Introduction 00:32
- Lecture
  
  What Are Subqueries 04:11
- Lecture
  
  Non-Correlated Subqueries: Part 1 05:11
- Lecture
  
  Non-Correlated Subqueries: Part 2 05:47
- Lecture
  
  Correlated Subqueries 04:41
- Lecture
  
  Exercise 1 01:19
- Lecture
  
  Solution 1 06:59
MySQL Functions - String Functions and Date Functions 54:42
- Lecture
  
  Section Introduction 01:08
- Lecture
  
  What Are MySQL Functions? 01:46
- Lecture
  
  Concatenation 06:49
- Lecture
  
  Substrings 08:09
- Lecture
  
  Upper and Lower Case 03:50
- Lecture
  
  Exercise 1 01:12
- Lecture
  
  Solution 1 09:52
- Lecture
  
  Date Function 07:30
- Lecture
  
  Month Function 04:37
- Lecture
  
  Year Function 03:11
- Lecture
  
  Exercise 2 01:07
- Lecture
  
  Solution 2 04:08
- Lecture
  
  Bonus - Please Watch! 00:48
- Lecture
  
  Check out Our Other 42 Udemy Courses! 00:35
Challenges
Extra Information - Source code, and other stuff 35:23
- Lecture
  
  Section Introduction 00:56
- Lecture
  
  Challenge One 00:27
- Lecture
  
  Solution One 01:51
- Lecture
  
  Challenge Two 00:22
- Lecture
  
  Solution Two 04:34
- Lecture
  
  Challenge Three 00:26
- Lecture
  
  Solution Three 03:31
- Lecture
  
  Challenge Four 00:26
- Lecture
  
  Solution Four 04:08
- Lecture
  
  Challenge Five 00:37
- Lecture
  
  Bonus - Please Watch! 00:48
- Lecture
  
  Solution Five 07:20
- Lecture
  
  Challenge Six 00:38
- Lecture
  
  Solution Six 03:55
- Lecture
  
  Check out Our Other 42 Udemy Courses! 00:35
- Lecture
  
  Bonus Lecture and Information 04:49

Jon Avis

IT Systems Engineer and Teacher Hi, my name is Jon. I am from the UK and currently work in Hong Kong. I work in the financial industry as an IT Systems Engineer. This has allowed me… View Profile

Tim Buchalka's Learn Programming Academy

Professional Programmers and Teachers - 323,000+ students The Learn Programming Academy was created by Tim Buchalka, a software developer with 35 years experience, who is also an instructor on Udemy, with over 335,000 students in his courses… View Profile

Student Feedback

4.5

1,836 Average ratings

47%

40%

11%

2 weeks ago
Ivan Mamaev
I want to see examples of data types on the presented screens.
3 weeks ago
Ivan antonio Vicario ocampo
Great course. Learn some new stuff in a very easy way.
3 weeks ago
Dennis Appel
The topics covered are a good starting point. However I wish the instructor were a little more enthusiastic and not so monotone. Except that, it was a pretty good experience.
3 weeks ago
Bill Hoffman
Really enjoyed the theory discussed in the database design section
3 weeks ago
Dan Collin
Calm and clear voice. Very clear examples.
4 weeks ago
Chava bhuja Lingarao
Thank you
4 weeks ago
Cezary Treda
Clear and easy to understand. I posted some questions during the course but I did not get any answer. Those questions are important to me, surely I will monitor the course and hope/looking forward to get those answers. Please don't forget about my troubles. Thanks again.
4 weeks ago
Hari Vijaya
He was going a little faster. For beginners like me, it is a bit difficult to manage his speed.
4 weeks ago
Berry Jatnika
Clear explanations and straightforward.
1 month ago
James Declerus
the course is just on fire!! it's wonderfull.exactly what i needed.

Databases

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

Requirements

What you will learn

Who should attend

Is available on google app?

Is available on ios?

Course Features

Course Introduction 05:10

Installation and Setup 01:01:07

Data Definition Language 26:08

More On Alter Table 38:37

Data Manipulation Language 18:01

Selecting from a Table 58:09

Selecting From Multiple Tables 33:23

Database Design 39:41

Creating a Cinema Booking System Database 41:11

Aggregate Functions 33:39

Subqueries 28:40

MySQL Functions - String Functions and Date Functions 54:42

Challenges

Extra Information - Source code, and other stuff 35:23

Student Feedback

Related Courses

2 Comments

Leave A Reply Cancel reply