Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 8 hours on-demand video
  • 29 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Development Database Design & Development SQL

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
Rating: 4.5 out of 54.5 (8,127 ratings)
37,932 students
Created by Tim Buchalka's Learn Programming Academy, Jon Avis - SQL Instructor
Last updated 12/2020
English
English [Auto], French [Auto], 
30-Day Money-Back Guarantee

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.
Curated for the Udemy for Business collection

Course content

14 sections • 122 lectures • 7h 51m total length

  • Preview01:28
  • Syllabus Explanation
    03:42

  • Section Introduction
    00:41
  • Databases, SQL and MySQL
    03:08
  • Relational Database Management System
    02:18
  • MySQL Installation for Windows
    Preview15:00
  • MySQL Installation for Mac
    12:17
  • MySQL Installation for Linux
    11:07
  • MySQL Workbench Overview
    13:13
  • Preview03:23

  • Section Introduction
    01:32
  • Preview06:34
  • Primary and Foreign Keys
    02:53
  • Creating the Coffee Store Database
    08:54
  • Modifying Tables: Adding and Removing Columns
    03:08
  • Deleting Tables
    01:28
  • Truncating Tables
    01:39

  • 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

  • Section Introduction
    00:50
  • Preview05:37
  • Updating Data in Tables
    06:07
  • Deleting Data from Tables
    02:49
  • Completing the Coffee Store Database
    02:38

  • Section Introduction
    01:14
  • Select Statement
    01:46
  • Preview04:53
  • Using Inequality Symbols
    03:03
  • Null Values
    03:10
  • Exercise 1
    01:06
  • Solution 1
    03:55
  • In, Not In
    03:44
  • Between
    04:04
  • Like
    04:52
  • Order By
    06:19
  • Exercise 2
    00:55
  • Solution 2
    04:23
  • Preview05:11
  • Limit
    02:56
  • Column Name Alias
    02:03
  • Exercise 3
    00:50
  • Solution 3
    03:45

  • Section Introduction
    01:08
  • What Are Joins?
    03:08
  • Inner Join
    08:55
  • Left Join
    05:23
  • Right Join
    03:15
  • Joining more than Two Tables
    04:33
  • Exercise 1
    01:06
  • Solution 1
    05:55

  • Section Introduction
    01:23
  • Preview05:23
  • 1st Normal Form (1NF)
    03:30
  • 2nd Normal Form (2NF)
    06:27
  • 3rd Normal Form (3NF)
    09:30
  • Relationships
    01:05
  • Relationships - One to One
    02:30
  • Relationships - One to Many
    02:00
  • Relationships - Many to Many
    04:00
  • Constraints
    03:53

  • Section Introduction
    01:11
  • Database Schema Overview
    07:26
  • Create Films Table
    04:55
  • Create Customers Table
    02:53
  • Create Rooms Table
    02:19
  • Create Screenings Table
    04:45
  • Preview03:53
  • Create Bookings Table
    03:52
  • Create Reserved_Seat Table
    04:35
  • Insert the Data
    05:22

  • Section Introduction
    00:41
  • What are Aggregate Functions
    02:30
  • Count
    02:38
  • Sum
    02:36
  • Min and Max
    02:39
  • Preview02:09
  • Exercise 1
    00:46
  • Solution 1
    04:09
  • Grouping Data
    08:52
  • Having Clause
    01:44
  • Exercise 2
    00:44
  • 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.

Featured review

Daniel Council
Daniel Council
58 courses
16 reviews
Rating: 5.0 out of 5a year ago
Great basics course, tim's team is stellar, using him for python at the moment as well, and took some of his java course in the past when i did work with it. Highly reccomend this if you are new to databases

Instructors

Tim Buchalka's Learn Programming Academy
Professional Programmers and Teachers - 1M+ students
Tim Buchalka's Learn Programming Academy
  • 4.5 Instructor Rating
  • 312,880 Reviews
  • 1,077,933 Students
  • 52 Courses

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 1M+ students in his courses on Java, Python, Android, C#  and the Spring framework. 

The Academy’s goal in the next three years, is to teach one million people to learn how to program.

Apart from Tim’s own courses, which are all available here, we are working with the very best teachers, creating courses to teach the essential skills required by developers, at all levels.

One other important philosophy is that our courses are taught by real professionals; software developers with real and substantial experience in the industry, who are also great teachers.  All our instructors are experienced, software developers!

Our team is busy creating new courses right now.

Whether you are a beginner, looking to learn how to program for the very first time, or to brush up on your existing skills, or to learn new languages and frameworks, the Academy has you covered.

Jon Avis - SQL Instructor
IT Systems Engineer and SQL Instructor
Jon Avis - SQL Instructor
  • 4.5 Instructor Rating
  • 10,933 Reviews
  • 51,029 Students
  • 2 Courses

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 to become an expert in SQL, Databases, Unix, Shell Scripting and coding in multiple languages.

Part of my role as a Systems Engineer is to teach complex, technical subjects to colleagues. Through Udemy I hope to do the same to many more students around the globe.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.