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
SQL for Beginners Learn SQL using MySQL and Database Design
File Size :
2.97 GB
Total length :
8h 24m



Tim Buchalka's Learn Programming Academy


Last update




SQL for Beginners Learn SQL using MySQL and Database Design

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.

SQL for Beginners Learn SQL using MySQL and Database Design


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


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 DesignData AnalysisThe 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 QueriesJoinsAggregate FunctionsSubqueriesDatabase DesignCreating 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!


Section 1: Course Introduction

Lecture 1 Welcome to the Course

Lecture 2 Syllabus Explanation

Section 2: Installation and Setup

Lecture 3 Section Introduction

Lecture 4 Databases, SQL and MySQL

Lecture 5 Relational Database Management System

Lecture 6 MySQL Installation for Windows

Lecture 7 MySQL Installation for Mac

Lecture 8 MySQL Installation for Linux

Lecture 9 MySQL Workbench Overview

Lecture 10 Create Database

Section 3: Data Definition Language

Lecture 11 Section Introduction

Lecture 12 Data Types

Lecture 13 Primary and Foreign Keys

Lecture 14 Creating the Coffee Store Database

Lecture 15 Modifying Tables: Adding and Removing Columns

Lecture 16 Deleting Tables

Lecture 17 Truncating Tables

Section 4: More On Alter Table

Lecture 18 Section Introduction

Lecture 19 Creating Our Test Database

Lecture 20 Add and Remove Primary Key

Lecture 21 Add and Remove Foreign Key

Lecture 22 Add Unique Constraint

Lecture 23 Change Column Name

Lecture 24 Change Column Data Type

Lecture 25 Exercise 4.1

Lecture 26 Solution 4.1

Section 5: Data Manipulation Language

Lecture 27 Section Introduction

Lecture 28 Inserting Data Into Tables

Lecture 29 Updating Data in Tables

Lecture 30 Deleting Data from Tables

Lecture 31 Completing the Coffee Store Database

Section 6: Selecting from a Table

Lecture 32 Section Introduction

Lecture 33 Select Statement

Lecture 34 Where Clause

Lecture 35 Using Inequality Symbols

Lecture 36 Null Values

Lecture 37 Exercise 6.1

Lecture 38 Solution 6.1

Lecture 39 In and Not In

Lecture 40 Between

Lecture 41 Like

Lecture 42 Order By

Lecture 43 Exercise 6.2

Lecture 44 Solution 6.2

Lecture 45 Distinct

Lecture 46 Limit

Lecture 47 Column Name Alias

Lecture 48 Exercise 6.3

Lecture 49 Solution 6.3

Section 7: Selecting From Multiple Tables

Lecture 50 Section Introduction

Lecture 51 What Are Joins?

Lecture 52 Inner Join

Lecture 53 Left Join

Lecture 54 Right Join

Lecture 55 Joining more than Two Tables

Lecture 56 Exercise 7.1

Lecture 57 Solution 7.1

Lecture 58 Creating Entity Relationship diagrams in Workbench

Section 8: Database Design

Lecture 59 Section Introduction

Lecture 60 Normalization – What is it?

Lecture 61 1st Normal Form (1NF)

Lecture 62 2nd Normal Form (2NF)

Lecture 63 3rd Normal Form (3NF)

Lecture 64 Relationships

Lecture 65 Relationships – One to One

Lecture 66 Relationships – One to Many

Lecture 67 Relationships – Many to Many

Lecture 68 Constraints

Section 9: Creating a Cinema Booking System Database

Lecture 69 Section Introduction

Lecture 70 Database Schema Overview

Lecture 71 Create Films Table

Lecture 72 Create Customers Table

Lecture 73 Create Rooms Table

Lecture 74 Create Screenings Table

Lecture 75 Create Seats Table

Lecture 76 Create Bookings Table

Lecture 77 Create Reserved_Seat Table

Lecture 78 Insert the Data

Section 10: Aggregate Functions

Lecture 79 Section Introduction

Lecture 80 What are Aggregate Functions

Lecture 81 Count

Lecture 82 Sum

Lecture 83 Min and Max

Lecture 84 Average

Lecture 85 Exercise 10.1

Lecture 86 Solution 10.1

Lecture 87 Grouping Data

Lecture 88 Having Clause

Lecture 89 Exercise 10.2

Lecture 90 Solution 10.2

Section 11: Subqueries

Lecture 91 Section Introduction

Lecture 92 What Are Subqueries

Lecture 93 Non-Correlated Subqueries: Part 1

Lecture 94 Non-Correlated Subqueries: Part 2

Lecture 95 Correlated Subqueries

Lecture 96 Exercise 11.1

Lecture 97 Solution 11.1

Section 12: MySQL String and Data Functions

Lecture 98 Section Introduction

Lecture 99 What Are MySQL Functions?

Lecture 100 Concatenation

Lecture 101 Substrings

Lecture 102 Upper and Lower Case

Lecture 103 Exercise 12.1

Lecture 104 Solution 12.1

Lecture 105 Date Function

Lecture 106 Month Function

Lecture 107 Year Function

Lecture 108 Exercise 12.2

Lecture 109 Solution 12.2

Section 13: Challenges

Lecture 110 Section Introduction

Lecture 111 Challenge One

Lecture 112 Solution One

Lecture 113 Challenge Two

Lecture 114 Solution Two

Lecture 115 Challenge Three

Lecture 116 Solution Three

Lecture 117 Challenge Four

Lecture 118 Solution Four

Lecture 119 Challenge Five

Lecture 120 Solution Five

Lecture 121 Challenge Six

Lecture 122 Solution Six

Lecture 123 Should I break normalisation?

Section 14: Extra Information – Source code, and other stuff

Lecture 124 Source codes

Lecture 125 Bonus Lecture and Information

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

Course Information:

Udemy | English | 8h 24m | 2.97 GB
Created by: Tim Buchalka’s Learn Programming Academy

You Can See More Courses in the Developer >> Greetings from CourseDown.com

New Courses

Scroll to Top