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
Tim Buchalka
(57,016 reviews)
Take this course
1419182_b2cf-1.jpg

Discover the Power of SQL & Databases: A Comprehensive Guide for Aspiring Tech-Savvies!

Are You a Student or Professional Eager to Master SQL?

Embarking on a journey into the realm of databases? Yearning to grasp the intricacies of SQL and databases, but unsure where to kick things off? Whether you’re a budding developer, a data enthusiast, or simply someone aiming to amplify your career horizons, understanding SQL and databases is your stepping stone.

Why This Course Stands Out

  1. Dive Deep into SQL & MySQL: Unlock the secrets of SQL and MySQL – the powerhouse among global databases.

  2. Master Database Design & Analysis: Most courses barely scratch the surface; we offer you an immersive dive into database design, a critical skill often overlooked.

  3. Real-world Applications: Engage with a hands-on project – setting up an online cinema booking database, offering you practical exposure to concepts learned.

Core Modules Include:

  • SQL Basics: The language that’s reshaping the tech landscape.

  • MySQL In-Depth: One of the world’s most renowned databases.

  • Database Design & Data Analysis: Equip yourself with these sought-after skills.

  • Hands-on Tutorials: From creating to modifying databases, we’ve got you covered.

  • Cross-Platform Installation Guides: Be it Windows, Mac, or Linux, we’ve got your back.

Exercise Your Learning:

Dive into practical exercises with step-by-step video solutions to solidify your understanding.

Why MySQL?

While we champion MySQL, the SQL prowess you gain here transcends databases. The skills are universally applicable.

Why Choose This Course?

In the vast sea of courses, ours stands tall by offering a trifecta of SQL, database design, and data analysis – all under one roof.

Tim Buchalka and Jean-Paul Roberts are your instructors. They have a combined eighty (yes 80!) years of programming experience.  Their real world and teaching experience makes them the ideal instructors for this course.

They are not just experts, they are also fantastic educators, skilled in breaking down intricate topics.

Embark on a Journey of Proficiency:

By the end of this comprehensive guide, you’ll wield SQL with finesse, boast a robust understanding of MySQL, and wear the badge of database design expertise.

Your Future in Tech Beckons:

SQL, MySQL, and Database Design are your tickets to lucrative career opportunities. Don’t let them pass you by. Enroll now and solidify your place in the tech world.

Ready to Transform Your Tech Aspirations?

Elevate your skills; elevate your prospects. Click the Enroll button and begin your journey into the heart of SQL and databases!

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 127
  • Quizzes 0
  • Exercises 0
  • Duration 8.5 total hours
  • Skill level Beginner Level
  • Students 177992
  • Last Updated November, 2024

  • Course Introduction

  • Course Introduction 07:09

    • Lecture
      Welcome to the Course 01:58
    • Lecture
      Syllabus Explanation 05:11

  • Installation and Setup 01:18:23

    • Lecture
      Syllabus Explanation 03:42
    • Lecture
      Section Introduction 01:02
    • Lecture
      Databases, SQL and MySQL 04:36
    • Lecture
      Relational Database Management System 02:44
    • Lecture
      MySQL Installation for Windows 21:47
    • Lecture
      MySQL Installation for Mac 13:30
    • Lecture
      MySQL Installation for Linux 12:10
    • Lecture
      MySQL Workbench Overview 12:32
    • Lecture
      Create Database 06:20

  • Data Definition Language 36:26

    • Lecture
      Section Introduction 02:50
    • Lecture
      Data Types 10:12
    • Lecture
      Primary and Foreign Keys 07:12
    • Lecture
      Creating the Coffee Store Database 11:35
    • Lecture
      Modifying Tables: Adding and Removing Columns 04:37

  • Installation and Setup 01:49

    • Lecture
      Truncating Tables 01:49

  • More On Alter Table 37:48

    • Lecture
      Section Introduction 01:12
    • Lecture
      Creating Our Test Database 04:35
    • Lecture
      Add and Remove Primary Key 05:36
    • Lecture
      Add and Remove Foreign Key 06:10
    • Lecture
      Add Unique Constraint 03:07
    • Lecture
      Change Column Name 03:23
    • Lecture
      Change Column Data Type 05:16
    • Lecture
      Exercise 4.1 01:30
    • Lecture
      Section Introduction 00:41
    • Lecture
      Solution 4.1 06:18

  • Data Manipulation Language 17:56

    • Lecture
      Section Introduction 00:53
    • Lecture
      Inserting Data Into Tables 07:15
    • Lecture
      Updating Data in Tables 04:45
    • Lecture
      Deleting Data from Tables 02:51
    • Lecture
      Completing the Coffee Store Database 02:12

  • Selecting from a Table 01:06:40

    • Lecture
      Section Introduction 02:17
    • Lecture
      Select Statement 01:34
    • Lecture
      Where Clause 04:24
    • Lecture
      Databases, SQL and MySQL 03:08
    • Lecture
      Using Inequality Symbols 04:59
    • Lecture
      Null Values 02:18
    • Lecture
      Exercise 6.1 00:54
    • Lecture
      Solution 6.1 03:12
    • Lecture
      In and Not In 03:10
    • Lecture
      Between 04:40
    • Lecture
      Like 05:27
    • Lecture
      Order By 06:01
    • Lecture
      Exercise 6.2 00:47
    • Lecture
      Solution 6.2 04:57
    • Lecture
      Distinct 04:29
    • Lecture
      Relational Database Management System 02:18
    • Lecture
      Limit 05:17
    • Lecture
      Column Name Alias 02:33
    • Lecture
      Exercise 6.3 00:57
    • Lecture
      Solution 6.3 03:18

  • Selecting From Multiple Tables 49:33

    • Lecture
      Section Introduction 01:08
    • Lecture
      What Are Joins? 03:39
    • Lecture
      Inner Join 08:40
    • Lecture
      Left Join 06:14
    • Lecture
      Right Join 03:12
    • Lecture
      Joining more than Two Tables 04:12
    • Lecture
      MySQL Installation for Windows 15:00
    • Lecture
      Exercise 7.1 00:58
    • Lecture
      Solution 7.1 03:18
    • Lecture
      Creating Entity Relationship diagrams in Workbench 03:12

  • Database Design 49:39

    • Lecture
      Section Introduction 01:31
    • Lecture
      Normalization - What is it? 05:43
    • Lecture
      1st Normal Form (1NF) 03:22
    • Lecture
      2nd Normal Form (2NF) 05:47
    • Lecture
      3rd Normal Form (3NF) 08:14
    • Lecture
      Relationships 00:57
    • Lecture
      Relationships - One to One 02:55
    • Lecture
      MySQL Installation for Mac 12:17
    • Lecture
      Relationships - One to Many 01:53
    • Lecture
      Relationships - Many to Many 03:55
    • Lecture
      Constraints 03:05

  • Creating a Cinema Booking System Database 50:10

    • Lecture
      Section Introduction 01:06
    • Lecture
      Database Schema Overview 07:14
    • Lecture
      Create Films Table 04:00
    • Lecture
      Create Customers Table 03:14
    • Lecture
      Create Rooms Table 02:30
    • Lecture
      Create Screenings Table 04:04
    • Lecture
      Create Seats Table 03:53
    • Lecture
      MySQL Installation for Linux 11:07
    • Lecture
      Create Bookings Table 03:39
    • Lecture
      Create Reserved_Seat Table 04:05
    • Lecture
      Insert the Data 05:18

  • Aggregate Functions 49:59

    • Lecture
      Section Introduction 00:52
    • Lecture
      What are Aggregate Functions 02:22
    • Lecture
      Count 02:30
    • Lecture
      Sum 02:29
    • Lecture
      Min and Max 02:17
    • Lecture
      Average 01:36
    • Lecture
      Exercise 10.1 00:54
    • Lecture
      MySQL Workbench Overview 13:13
    • Lecture
      Solution 10.1 04:02
    • Lecture
      Grouping Data 06:56
    • Lecture
      Having Clause 03:49
    • Lecture
      Exercise 10.2 01:17
    • Lecture
      Solution 10.2 07:42

  • Subqueries 31:08

    • Lecture
      Section Introduction 00:42
    • Lecture
      What Are Subqueries 04:04
    • Lecture
      Non-Correlated Subqueries: Part 1 05:02
    • Lecture
      Non-Correlated Subqueries: Part 2 04:52
    • Lecture
      Correlated Subqueries 04:31
    • Lecture
      Create Database 03:23
    • Lecture
      Exercise 11.1 01:18
    • Lecture
      Solution 11.1 07:16

  • MySQL String and Date Functions 31:27

    • Lecture
      Section Introduction 01:01
    • Lecture
      What Are MySQL Functions? 01:55
    • Lecture
      Concatenation 05:46
    • Lecture
      Substrings 08:25
    • Lecture
      Upper and Lower Case 03:03
    • Lecture
      Exercise 12.1 01:19
    • Lecture
      Solution 12.1 09:58

  • Data Definition Language 10:50

    • Lecture
      Month Function 04:55
    • Lecture
      Year Function 02:20
    • Lecture
      Exercise 12.2 00:45
    • Lecture
      Solution 12.2 02:50

  • Challenges 35:11

    • Lecture
      Section Introduction 00:57
    • Lecture
      Challenge One 00:28
    • Lecture
      Solution One 01:31
    • Lecture
      Challenge Two 01:30
    • Lecture
      Solution Two 06:17
    • Lecture
      Section Introduction 01:32
    • Lecture
      Challenge Three 00:25
    • Lecture
      Solution Three 04:47
    • Lecture
      Challenge Four 00:25
    • Lecture
      Solution Four 03:00
    • Lecture
      Challenge Five 00:31
    • Lecture
      Solution Five 06:18
    • Lecture
      Challenge Six 00:33
    • Lecture
      Solution Six 02:50
    • Lecture
      Should I break normalisation? 04:07

  • Extra Information - Source code, and other stuff 32:45

    • Lecture
      Source code 02:39
    • Lecture
      Old Course Information 00:36
    • Lecture
      Bonus Lecture and Information 04:49
    • Lecture
      Course Slides 00:05
    • 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 30:34

    • 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
      Solution Five 07:20
    • Lecture
      Challenge Six 00:38
    • Lecture
      Solution Six 03:55
    • Lecture
      Bonus - Please Watch! 00:48
    • Lecture
      Check out Our Other 42 Udemy Courses! 00:35
Tim Buchalka
Java Python Android and C# Expert Developer - 1.23M students Tim's been a professional software developer for close to 40 years. During his career, he has worked for major companies such as Fujitsu, Mitsubishi, and Saab. His video courses are… View Profile
Jean-Paul Roberts
Computer programmer, analyst and teacher I am a programmer with over 30 years' experience gained in a range of industries, the last 16 with IBM. I am now self employed developing apps for Android; programming… 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
57,016 Average ratings
50%
40%
9%
1%
0%

  • 1 week ago

    Divya Shrivastava

    Explanations/examples are well worded and easy to follow

  • 1 week ago

    Pradeepa .

    Good course for beginners and instructor explained the topics very well.

  • 1 week ago

    Jitendra Bisoi

    really Good Course. Beginner Friendly.

  • 1 week ago

    Ramisetti Kumar

    Excellent

  • 1 week ago

    Mylah Sanchez Angcon

    very informative and easy to understand!

  • 1 week ago

    Quint Smits

    nice

  • 1 week ago

    Rushitha Mandhalapu

    Amazing course

  • 2 weeks ago

    Suriya Prakash R

    .

  • 2 weeks ago

    Vikrant Patil3

    Very helpful

  • 2 weeks ago

    JAYAKUMAR N

    yes ,the course is very easy to understand.

Take this course
Take this course

Related Courses

    4 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

  2. mm
    graliontorile
    November 4, 2022
    Reply

    Hey There. I found your blog using msn. This is an extremely well written article. I will make sure to bookmark it and come back to read more of your useful information. Thanks for the post. I’ll certainly return.

  3. mm
    Insurance agency Dallas TX
    December 15, 2023
    Reply

    I like exactly how you do not avoid questionable subject matters.
    Your objective method is stimulating.

    Also visit my page … Insurance agency Dallas TX

Leave A Reply

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


Message modal