Home

All courses

SQL for Beginners: Learn SQL using MySQL and Database Design

SQL

Development

Database Design & Development

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

4.6

(62066)

191154 enrolled on this course

Last updated 11/2021

None

₹ 4099.0

₹ 5599.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

Description

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
Dive Deep into SQL & MySQL
: Unlock the secrets of SQL and MySQL - the powerhouse among global databases.
Master Database Design & Analysis
: Most courses barely scratch the surface; we offer you an immersive dive into database design, a critical skill often overlooked.
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!
Who this course is for:
Anyone who wants to learn how to use SQL and MySQL.

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.

Requirements

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Course Introduction

1.1-Welcome to the Course

1.2-Syllabus Explanation

2-Installation and Setup

2.1-Section Introduction

2.2-Databases, SQL and MySQL

2.3-Relational Database Management System

2.4-MySQL Installation for Windows

2.5-MySQL Installation for Mac

2.6-MySQL Installation for Linux

2.7-MySQL Workbench Overview

2.8-Create Database

3-Data Definition Language

3.1-Section Introduction

3.2-Data Types

3.3-Primary and Foreign Keys

3.4-Creating the Coffee Store Database

3.5-Modifying Tables: Adding and Removing Columns

3.6-Deleting Tables

3.7-Truncating Tables

4-More On Alter Table

4.1-Section Introduction

4.2-Creating Our Test Database

4.3-Add and Remove Primary Key

4.4-Add and Remove Foreign Key

4.5-Add Unique Constraint

4.6-Change Column Name

4.7-Change Column Data Type

4.8-Exercise 4.1

4.9-Solution 4.1

5-Data Manipulation Language

5.1-Section Introduction

5.2-Inserting Data Into Tables

5.3-Updating Data in Tables

5.4-Deleting Data from Tables

5.5-Completing the Coffee Store Database

6-Selecting from a Table

6.1-Section Introduction

6.2-Select Statement

6.3-Where Clause

6.4-Using Inequality Symbols

6.5-Null Values

6.6-Exercise 6.1

6.7-Solution 6.1

6.8-In and Not In

6.9-Between

6.10-Like

6.11-Order By

6.12-Exercise 6.2

6.13-Solution 6.2

6.14-Distinct

6.15-Limit

6.16-Column Name Alias

6.17-Exercise 6.3

6.18-Solution 6.3

7-Selecting From Multiple Tables

7.1-Section Introduction

7.2-What Are Joins?

7.3-Inner Join

7.4-Left Join

7.5-Right Join

7.6-Joining more than Two Tables

7.7-Exercise 7.1

7.8-Solution 7.1

7.9-Creating Entity Relationship diagrams in Workbench

8-Database Design

8.1-Section Introduction

8.2-Normalization - What is it?

8.3-1st Normal Form (1NF)

8.4-2nd Normal Form (2NF)

8.5-3rd Normal Form (3NF)

8.6-Relationships

8.7-Relationships - One to One

8.8-Relationships - One to Many

8.9-Relationships - Many to Many

8.10-Constraints

9-Creating a Cinema Booking System Database

9.1-Section Introduction

9.2-Database Schema Overview

9.3-Create Films Table

9.4-Create Customers Table

9.5-Create Rooms Table

9.6-Create Screenings Table

9.7-Create Seats Table

9.8-Create Bookings Table

9.9-Create Reserved_Seat Table

9.10-Insert the Data

10-Aggregate Functions

10.1-Section Introduction

10.2-What are Aggregate Functions

10.3-Count

10.4-Sum

10.5-Min and Max

10.6-Average

10.7-Exercise 10.1

10.8-Solution 10.1

10.9-Grouping Data

10.10-Having Clause

10.11-Exercise 10.2

10.12-Solution 10.2

11-Subqueries

11.1-Section Introduction

11.2-What Are Subqueries

11.3-Non-Correlated Subqueries: Part 1

11.4-Non-Correlated Subqueries: Part 2

11.5-Correlated Subqueries

11.6-Exercise 11.1

11.7-Solution 11.1

12-MySQL String and Date Functions

12.1-Section Introduction

12.2-What Are MySQL Functions?

12.3-Concatenation

12.4-Substrings

12.5-Upper and Lower Case

12.6-Exercise 12.1

12.7-Solution 12.1

12.8-Date Function

12.9-Month Function

12.10-Year Function

12.11-Exercise 12.2

12.12-Solution 12.2

13-Challenges

13.1-Section Introduction

13.2-Challenge One

13.3-Solution One

13.4-Challenge Two

13.5-Solution Two

13.6-Challenge Three

13.7-Solution Three

13.8-Challenge Four

13.9-Solution Four

13.10-Challenge Five

13.11-Solution Five

13.12-Challenge Six

13.13-Solution Six

13.14-Should I break normalisation?

14-Extra Information - Source code, and other stuff

14.1-Source code

14.2-Old Course Information

14.3-Bonus Lecture and Information

14.4-Course Slides

Course Categories

Popular Courses

SQL for Beginners: Learn SQL using MySQL and Database Design

Description

What you'll learn

Requirements

Course Content

You May Like