SQL for Beginners- Learn SQL using MySQL and Database Design

SQL for Beginners: Learn SQL using MySQL and Database Design, available at $84.99, has an average rating of 4.55, with 247 lectures, based on 55688 reviews, and has 173970 subscribers.

You will learn about 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. This course is ideal for individuals who are Anyone who wants to learn how to use SQL and MySQL. It is particularly useful for Anyone who wants to learn how to use SQL and MySQL.

Enroll now: SQL for Beginners: Learn SQL using MySQL and Database Design

Summary

Title: SQL for Beginners: Learn SQL using MySQL and Database Design

Price: $84.99

Average Rating: 4.55

Number of Lectures: 247

Number of Published Lectures: 126

Number of Curriculum Items: 247

Number of Published Curriculum Objects: 126

Original Price: $89.99

Quality Status: approved

Status: Live

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.

Target Audiences

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

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!

Course Curriculum

Chapter 1: Course Introduction

Lecture 1: Welcome to the Course

Lecture 2: Syllabus Explanation

Chapter 2: Installation and Setup

Lecture 1: Section Introduction

Lecture 2: Databases, SQL and MySQL

Lecture 3: Relational Database Management System

Lecture 4: MySQL Installation for Windows

Lecture 5: MySQL Installation for Mac

Lecture 6: MySQL Installation for Linux

Lecture 7: MySQL Workbench Overview

Lecture 8: Create Database

Chapter 3: Data Definition Language

Lecture 1: Section Introduction

Lecture 2: Data Types

Lecture 3: Primary and Foreign Keys

Lecture 4: Creating the Coffee Store Database

Lecture 5: Modifying Tables: Adding and Removing Columns

Lecture 6: Deleting Tables

Lecture 7: Truncating Tables

Chapter 4: More On Alter Table

Lecture 1: Section Introduction

Lecture 2: Creating Our Test Database

Lecture 3: Add and Remove Primary Key

Lecture 4: Add and Remove Foreign Key

Lecture 5: Add Unique Constraint

Lecture 6: Change Column Name

Lecture 7: Change Column Data Type

Lecture 8: Exercise 4.1

Lecture 9: Solution 4.1

Chapter 5: Data Manipulation Language

Lecture 1: Section Introduction

Lecture 2: Inserting Data Into Tables

Lecture 3: Updating Data in Tables

Lecture 4: Deleting Data from Tables

Lecture 5: Completing the Coffee Store Database

Chapter 6: Selecting from a Table

Lecture 1: Section Introduction

Lecture 2: Select Statement

Lecture 3: Where Clause

Lecture 4: Using Inequality Symbols

Lecture 5: Null Values

Lecture 6: Exercise 6.1

Lecture 7: Solution 6.1

Lecture 8: In and Not In

Lecture 9: Between

Lecture 10: Like

Lecture 11: Order By

Lecture 12: Exercise 6.2

Lecture 13: Solution 6.2

Lecture 14: Distinct

Lecture 15: Limit

Lecture 16: Column Name Alias

Lecture 17: Exercise 6.3

Lecture 18: Solution 6.3

Chapter 7: Selecting From Multiple Tables

Lecture 1: Section Introduction

Lecture 2: What Are Joins?

Lecture 3: Inner Join

Lecture 4: Left Join

Lecture 5: Right Join

Lecture 6: Joining more than Two Tables

Lecture 7: Exercise 7.1

Lecture 8: Solution 7.1

Lecture 9: Creating Entity Relationship diagrams in Workbench

Chapter 8: Database Design

Lecture 1: Section Introduction

Lecture 2: Normalization – What is it?

Lecture 3: 1st Normal Form (1NF)

Lecture 4: 2nd Normal Form (2NF)

Lecture 5: 3rd Normal Form (3NF)

Lecture 6: Relationships

Lecture 7: Relationships – One to One

Lecture 8: Relationships – One to Many

Lecture 9: Relationships – Many to Many

Lecture 10: Constraints

Chapter 9: Creating a Cinema Booking System Database

Lecture 1: Section Introduction

Lecture 2: Database Schema Overview

Lecture 3: Create Films Table

Lecture 4: Create Customers Table

Lecture 5: Create Rooms Table

Lecture 6: Create Screenings Table

Lecture 7: Create Seats Table

Lecture 8: Create Bookings Table

Lecture 9: Create Reserved_Seat Table

Lecture 10: Insert the Data

Chapter 10: Aggregate Functions

Lecture 1: Section Introduction

Lecture 2: What are Aggregate Functions

Lecture 3: Count

Lecture 4: Sum

Lecture 5: Min and Max

Lecture 6: Average

Lecture 7: Exercise 10.1

Lecture 8: Solution 10.1

Lecture 9: Grouping Data

Lecture 10: Having Clause

Lecture 11: Exercise 10.2

Lecture 12: Solution 10.2

Instructors

Tim Buchalkas Learn Programming Academy
Professional Programmers and Teachers – 2M students

Tim Buchalka
Java Python Android and C# Expert Developer – 1.58M students

Jean-Paul Roberts
Computer programmer, analyst and teacher

Rating Distribution

1 stars: 260 votes

2 stars: 498 votes

3 stars: 5122 votes

4 stars: 22191 votes

5 stars: 27615 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!