The Learn Programming AcademyThe Learn Programming Academy
  • Home
  • Courses
  • Meet The Team
  • Blog
  • About Us
  • Contact
  • Home
  • Courses
  • Meet The Team
  • Blog
  • About Us
  • Contact

Database Design & Development

  • Home
  • All courses
  • Database Design & Development
  • SQL for Beginners: Learn SQL using MySQL and Database Design

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

mm
Jon Avis
Database Design & Development
(32,678 reviews)
Take this course
1419182_b2cf-8.jpg
  • Overview
  • Curriculum
  • Instructor
  • Reviews

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 total hours
  • Skill level Beginner Level
  • Students 109051
  • Last Updated May, 2022
  • 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 53:19

    • 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
  • Challenges 29:59

    • 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
      Bonus - Please Watch! 00:48
    • Lecture
      Solution Three 03:31
    • Lecture
      Challenge Four 00:26
    • Lecture
      Solution Four 04:08
    • Lecture
      Challenge Five 00:37
    • Lecture
      Solution Five 07:20
    • Lecture
      Challenge Six 00:38
    • Lecture
      Solution Six 03:55
  • Extra Information - Source code, and other stuff 04:49

    • 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
32,678 Average ratings
48%
41%
10%
1%
0%
  • 1 days ago

    Eugene Pan

    yes

  • 2 days ago

    Surya D

    excellent content..

  • 2 days ago

    RITAM CHARAN

    nice

  • 2 days ago

    KRISHNA KANHIYA SINGH

    Very beautifully described

  • 2 days ago

    Rahulhoushiram Roundhal

    great platform

  • 3 days ago

    George Georgiou

    A pretty good course to start learning SQL from scratch.

  • 3 days ago

    Priyankabharat Argade

    good

  • 3 days ago

    Suvvada saimanasa

    good

  • 3 days ago

    Thokala Venkata sai pooja

    good

  • 4 days ago

    Boya Useni Boya Useni

    Thanks

  • Overview
  • Curriculum
  • Instructor
  • Reviews
Take this course
  • Share:
Take this course

Related Courses

Java Programming Masterclass covering Java 11 & Java 17 Read More
mm
LPA TEAM

Java Programming Masterclass covering Java 11 & Java 17

mm
LPA TEAM
(0 review)
681367
(162096 Reviews)
Learn Python Programming Masterclass Read More
mm
LPA TEAM

Learn Python Programming Masterclass

mm
LPA TEAM
(0 review)
374503
(89841 Reviews)
Android Java Masterclass – Become an App Developer Read More
mm
LPA TEAM

Android Java Masterclass - Become an App Developer

mm
LPA TEAM
(0 review)
66184
(10080 Reviews)
Java Spring Tutorial Masterclass – Learn Spring Framework 5 Read More
mm
LPA TEAM

Java Spring Tutorial Masterclass - Learn Spring Framework 5

mm
LPA TEAM
(0 review)
36018
(5885 Reviews)
Kotlin for Java Developers Read More
mm
LPA TEAM

Kotlin for Java Developers

mm
LPA TEAM
(0 review)
19468
(3314 Reviews)
Learn Java Creating Android Games Using the LibGDX library Read More
mm
LPA TEAM

Learn Java Creating Android Games Using the LibGDX library

mm
LPA TEAM
(0 review)
3233
(479 Reviews)
Oracle Java Certification – Pass the Associate 1Z0-808 Exam. Read More
mm
LPA TEAM

Oracle Java Certification - Pass the Associate 1Z0-808 Exam.

mm
LPA TEAM
(0 review)
20638
(4293 Reviews)
What’s New in Java 9 – Modules and More! Read More
mm
LPA TEAM

What's New in Java 9 - Modules and More!

mm
LPA TEAM
(0 review)
5072
(712 Reviews)
Ruby for Beginners Read More
mm
LPA TEAM

Ruby for Beginners

mm
LPA TEAM
(0 review)
782
(75 Reviews)
Learn To Write 2D Games with C# and Unity Read More
mm
LPA TEAM

Learn To Write 2D Games with C# and Unity

mm
LPA TEAM
(0 review)
1274
(91 Reviews)
Data Structures and Algorithms:  Deep Dive Using Java Read More
mm
Tim Buchalka

Data Structures and Algorithms: Deep Dive Using Java

mm
LPA TEAM
(0 review)
75298
(12069 Reviews)
Learn Kotlin and Create Games Using the LibGdx Library Read More
mm
LPA TEAM

Learn Kotlin and Create Games Using the LibGdx Library

mm
LPA TEAM
(0 review)
1422
(179 Reviews)
Ethical Hacking Course:  Protect Yourself From Being Hacked Read More
mm
LPA TEAM

Ethical Hacking Course: Protect Yourself From Being Hacked

mm
LPA TEAM
(0 review)
4793
(388 Reviews)
The Complete Xamarin Developer Course:  iOS And Android! Read More
mm
LPA TEAM

The Complete Xamarin Developer Course: iOS And Android!

mm
LPA TEAM
(0 review)
22110
(4039 Reviews)
Android App Development Masterclass using Kotlin Read More
mm
LPA TEAM

Android App Development Masterclass using Kotlin

mm
LPA TEAM
(0 review)
37086
(5519 Reviews)
C Programming For Beginners – Master the C Language Read More
mm
LPA TEAM

C Programming For Beginners - Master the C Language

mm
LPA TEAM
(0 review)
111534
(25259 Reviews)
Ruby on Rails for Beginners Read More
mm
LPA TEAM

Ruby on Rails for Beginners

mm
LPA TEAM
(0 review)
778
(61 Reviews)
Beginning C++ Programming – From Beginner to Beyond Read More
mm
LPA TEAM

Beginning C++ Programming - From Beginner to Beyond

mm
LPA TEAM
(0 review)
195509
(47923 Reviews)
PHP for Beginners Read More
mm
LPA TEAM

PHP for Beginners

mm
LPA TEAM
(0 review)
12240
(2418 Reviews)
Windows Presentation Foundation Masterclass Read More
mm
LPA TEAM

Windows Presentation Foundation Masterclass

mm
LPA TEAM
(0 review)
17508
(3394 Reviews)
Master MATLAB through Guided Problem Solving Read More
mm
LPA TEAM

Master MATLAB through Guided Problem Solving

mm
LPA TEAM
(0 review)
19812
(3510 Reviews)
Machine Learning with Python from Scratch Read More
mm
LPA TEAM

Machine Learning with Python from Scratch

mm
LPA TEAM
(0 review)
4384
(303 Reviews)
Advanced Algorithms in Java Read More
mm
LPA TEAM

Advanced Algorithms in Java

mm
LPA TEAM
(0 review)
6234
(184 Reviews)
Rust Programming Language for Beginners Read More
mm
LPA TEAM

Rust Programming Language for Beginners

mm
LPA TEAM
(0 review)
3812
(370 Reviews)
Python REST APIs with Flask, Docker, MongoDB, and AWS DevOps Read More
mm
LPA TEAM

Python REST APIs with Flask, Docker, MongoDB, and AWS DevOps

mm
LPA TEAM
(0 review)
15277
(1845 Reviews)
3D Programming with JavaScript and the Three.js 3D Library Read More
mm
LPA TEAM

3D Programming with JavaScript and the Three.js 3D Library

mm
LPA TEAM
(0 review)
5990
(910 Reviews)
Java Enterprise Edition 8 for Beginners course Read More
mm
LPA TEAM

Java Enterprise Edition 8 for Beginners course

mm
LPA TEAM
(0 review)
14108
(2146 Reviews)
HTML and CSS Masterclass Read More
mm
LPA TEAM

HTML and CSS Masterclass

mm
LPA TEAM
(0 review)
1582
(188 Reviews)
ArcPy for Python Developers using ArcGIS Pro Read More
mm
LPA TEAM

ArcPy for Python Developers using ArcGIS Pro

mm
LPA TEAM
(0 review)
4865
(881 Reviews)
Azure Machine Learning using Cognitive Services Read More
mm
LPA TEAM

Azure Machine Learning using Cognitive Services

mm
LPA TEAM
(0 review)
3779
(371 Reviews)
Learning Bootstrap – From HTML to WordPress Theme Read More
mm
LPA TEAM

Learning Bootstrap - From HTML to Wordpress Theme

mm
LPA TEAM
(0 review)
1008
(80 Reviews)
Search Algorithms in Artificial Intelligence with Java Read More
mm
LPA TEAM

Search Algorithms in Artificial Intelligence with Java

mm
LPA TEAM
(0 review)
1922
(101 Reviews)
The Advanced Xamarin Developer Masterclass Read More
mm
LPA TEAM

The Advanced Xamarin Developer Masterclass

mm
LPA TEAM
(0 review)
5754
(477 Reviews)
The Complete Javascript Course for Developers Read More
mm
LPA TEAM

The Complete Javascript Course for Developers

mm
LPA TEAM
(0 review)
2157
(344 Reviews)
Learn Java Programming Crash Course Read More
mm
LPA TEAM

Learn Java Programming Crash Course

mm
LPA TEAM
(0 review)
14499
(2939 Reviews)
Learn C# for Beginners Crash Course Read More
mm
LPA TEAM

Learn C# for Beginners Crash Course

mm
LPA TEAM
(0 review)
7839
(1412 Reviews)
Python Tkinter Masterclass – Learn Python GUI Programming Read More
mm
Volkan Atış

Python Tkinter Masterclass - Learn Python GUI Programming

mm
LPA TEAM
(0 review)
4664
(595 Reviews)
The Java Design Patterns Course Read More
mm
Jason Fedin

The Java Design Patterns Course

mm
LPA TEAM
(0 review)
9428
(816 Reviews)
Mastering Intellij IDEA and Android Studio Read More
mm
LPA TEAM

Mastering Intellij IDEA and Android Studio

mm
LPA TEAM
(0 review)
1152
(88 Reviews)
Git & GitHub Masterclass Read More
mm
LPA TEAM

Git & GitHub Masterclass

mm
LPA TEAM
(0 review)
9362
(1177 Reviews)
Python GUI Programming Using PyQt5 Read More
mm
LPA TEAM

Python GUI Programming Using PyQt5

mm
LPA TEAM
(0 review)
4501
(685 Reviews)
Android Firebase Masterclass – Master Google Firebase Read More
mm
LPA TEAM

Android Firebase Masterclass - Master Google Firebase

mm
LPA TEAM
(0 review)
2370
(216 Reviews)
Master CI/CD for Xamarin Read More
mm
LPA TEAM

Master CI/CD for Xamarin

mm
LPA TEAM
(0 review)
435
(46 Reviews)
Master CI/CD for Android Developers Read More
mm
LPA TEAM

Master CI/CD for Android Developers

mm
LPA TEAM
(0 review)
853
(111 Reviews)
Master CI/CD for iOS Developers Read More
mm
LPA TEAM

Master CI/CD for iOS Developers

mm
LPA TEAM
(0 review)
1231
(141 Reviews)
Master CI/CD for React Native Read More
mm
LPA TEAM

Master CI/CD for React Native

mm
LPA TEAM
(0 review)
1904
(190 Reviews)
Java SE 11 Developer 1Z0-819 OCP Course – Part 1 Read More
mm
LPA TEAM

Java SE 11 Developer 1Z0-819 OCP Course - Part 1

mm
LPA TEAM
(0 review)
18323
(2711 Reviews)
Advanced C Programming Course Read More
mm
LPA TEAM

Advanced C Programming Course

mm
LPA TEAM
(0 review)
20055
(2414 Reviews)
iOS Firebase Masterclass – Real time Database and Firestore Read More
mm
LPA TEAM

iOS Firebase Masterclass - Real time Database and Firestore

mm
LPA TEAM
(0 review)
321
(31 Reviews)
Introduction to Continuous Integration & Continuous Delivery Read More
mm
LPA TEAM

Introduction to Continuous Integration & Continuous Delivery

mm
LPA TEAM
(0 review)
5702
(2511 Reviews)
Java SE 11 Developer 1Z0-819 OCP Course – Part 2 Read More
mm
LPA TEAM

Java SE 11 Developer 1Z0-819 OCP Course - Part 2

mm
LPA TEAM
(0 review)
9362
(677 Reviews)
Learn Go for Beginners Crash Course (Golang) Read More
mm
LPA TEAM

Learn Go for Beginners Crash Course (Golang)

mm
LPA TEAM
(0 review)
6377
(1066 Reviews)

    2 Comments

  1. mm
    Jurgen
    September 16, 2019
    Reply

    Hi this is somewhat of off topic but I was wondering if blogs use WYSIWYG editors or if
    you have to manually code with HTML. I’m starting a blog soon but have
    no coding expertise so I wanted to get guidance from someone with experience.
    Any help would be enormously appreciated!

    • mm
      LPA TEAM
      December 2, 2019
      Reply

      Yes, blogs do use WYSIWIG editors – WordPress has a pretty good one, you can view the blog post once logged into WordPress in code view (HTML) or presentation view where it operates like a word processor.

      WordPress is what most bloggers use and it’s free to use so that would be a good place to start.

      Regards
      Tim

Leave A Reply Cancel reply

Your email address will not be published. Required fields are marked *

Latest Courses

Learn Go for Beginners Crash Course (Golang)

Learn Go for Beginners Crash Course (Golang)

Java SE 11 Developer 1Z0-819 OCP Course – Part 2

Java SE 11 Developer 1Z0-819 OCP Course - Part 2

Introduction to Continuous Integration & Continuous Delivery

Introduction to Continuous Integration & Continuous Delivery

iOS Firebase Masterclass – Real time Database and Firestore

iOS Firebase Masterclass - Real time Database and Firestore

Advanced C Programming Course

Advanced C Programming Course

Java SE 11 Developer 1Z0-819 OCP Course – Part 1

Java SE 11 Developer 1Z0-819 OCP Course - Part 1

logo-eduma-the-best-lms-wordpress-theme

+61 422 512 549

[email protected]

Company

  • About Us
  • Blog
  • Contact
  • Become A Co-Instructor

Links

  • Courses
  • FAQs
  • Contact Us

  • Privacy Policy
  • Terms & Conditions

Would you like to become a Udemy Course Co-Instructor?

Struggling to find students? Let us publish and promote your course to our students.

FIND OUT MORE NOW
Modal title

Message modal