SQL - Introduction to SQL with MySQL from Udemy

LEARN SQL WITH MySQL

In order to make intelligent business decisions you need the proper data. In order to get the proper data you will need to communicate with and query data within a database. This is where SQL comes into play. SQL stands for Structured Query Language. It's the language used to communicate with a database and more importantly the data needed to make intelligent decisions that will save time and money.

WHY THIS COURSE

This SQL course starts with the absolute basic building blocks necessary to communicate effectively with any database. You'll learn how to query and manage a database using MySQL. MySQL is a free open-source relational database management system (RDBMS), used by many of the world's largest organizations.

Each section of the course will focus on a key topic of working with SQL. The video lectures have been created so you can follow along as the instructor demonstrates each concept. At the end of each section you can test your understanding through a section quiz and exercise. Once you complete a section the next section will build on the topics of the previous section. This encourages your learning as you build upon the knowledge you learn as you move from one section to the next.

This course is not just a sit back and watch the instructor type on the screen kind of course. The lectures and course flow has been designed to help you engage in the topic and participate by writing your own SQL. The TRUE LEARNING happens when you apply what you're learning and try it yourself.

The course also contains downloadable resources you can use away from the course as you continue to learn SQL. The QA board found within the course offers you the opportunity to ask questions and get answers from the instructor and interact with the other students enrolled in the course.

Learn Proper SQL Syntax Using the MySQL Workbench
Learn Relational Database Design Concepts
Use the SQL SELECT Statement in Order to Query Data from a Database
Use Column Alias to Give additional Context and Meaning to the Data
Learn How to Filtering Database Query Results Using the SQL Where Clause
Create Advanced Queries by Using the Proper Filter Operators
Use the SQL ORDER BY Keyword to Sort the Results of a Query
Learn How to Properly Group Data and Create Calculations for Reporting
Use the SQL HAVING Clause to Filter within Data Groups
Create a MySQL Database from Scratch
Learn How to Create Tables and Manage Records within the Tables
And Much More...

WHAT ARE YOU WAITING FOR

Start your SQL journey by enrolling now. See you in the course.

What's inside

Learning objectives

Manage and interact with large datasets with sql
Provide data in order to answer top questions for meetings
Create and manage a mysql database

Write complex sql queries using table joins
Retrieve proper data from a database using a sql where clause with criteria

Manage and interact with large datasets with sql
Provide data in order to answer top questions for meetings
Create and manage a mysql database
Write complex sql queries using table joins
Retrieve proper data from a database using a sql where clause with criteria

Syllabus

MySQL Course Introduction

Welcome to the "Introduction to MySQL" Course

Downloadable MySQL Course Resources

Visit the Course QA Board

Introduction to MySQL

What is SQL?

Introduction to Relational Database Design

Why MySQL

Quiz #1 - Introduction to MySQL Quiz

Getting Up and Running with MySQL

Installing MySQL on Windows

Installing MySQL on Windows Continued

Introduction to MySQL Interface

Setting Up the MySQL Course Database

Introduction to Course Database

Working with SQL SELECT Statement

Identify which Database by the USE statement

SQL SELECT Statement Syntax

Using the SELECT Statement to Retrieve Columns from a Table

QUICK TIP - Query All Columns from a Table

Using a Column Name Alias

Removing Duplicate Values by Using the DISTINCT Statement

Exercise #1 - SQL Select

Quiz #2 - SQL SELECT Statement Quiz

Filtering SQL Data

SQL WHERE Clause Syntax

Filter Records based on Single Criteria using the WHERE Clause

Filtering Text vs. Numeric Data

CHEAT SHEET - Filter Operators used in the WHERE Clause (DOWNLOAD)

Filtering with SQL AND Operator

QUICK TIP - MySQL Comments

Filtering Date Values with the Between Operator

Filtering with SQL OR Operator

Exercise #2 - SQL WHERE Clause

Quiz #3 - SQL Where Clause Quiz

Sorting SQL Data

SQL ORDER BY Keyword Syntax

Sort SQL Data Ascending/Descending using the ORDER BY Keyword

Sort SQL Data by Multiple Columns

Exercise #3 - SQL ORDER BY Keyword

Quiz #4 - SQL ORDER BY Quiz

Grouping SQL Data

SQL GROUP BY Syntax

Grouping SQL Data by a Column Value

QUICK TIP - DISTINCT VS. GROUP BY

Performing Calculations within the Grouped Data

CHEAT SHEET - MySQL Aggregate Functions when Grouping

Filtering Grouped Data with the SQL Having Clause

Exercise #4 - SQL GROUP BY Quiz

Quiz #5 - SQL GROUP BY Quiz

Creating a MySQL Database

Create a New Database in MySQL

Using the DROP Statement to Delete a Database

Adding Tables to the Database using the CREATE TABLE Statement

Using the DROP Statement to Delete a Table

SQL NOT NULL Constraint

SQL AUTO_INCREMENT Column

SQL PRIMARY KEY Constraint

RECAP - Table Relationships

SQL FOREIGN KEY Constraint

Exercise #5 - Creating a MySQL Table

Quiz #6 - Creating a SQL Database

Inserting Records into SQL Database Tables

SQL INSERT INTO Statement Syntax

Inserting Data into Specific Columns of a Table

Inserting Data into Every Column of a Table

Exercise #6 - Inserting Records

Quiz #7 - Inserting Records

Querying Multiple Tables with a Relationship

SQL Table JOIN Syntax

SQL INNER JOIN

SQL LEFT and RIGHT JOIN

SQL IS NULL Value

Exercise #7 - SQL Table JOIN

Quiz #8 - SQL Table JOINS

Congratulations

Congratulations on Completing the Introduction to SQL Course

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Develops advanced proficiency in data management and querying using SQL and MySQL Workbench, catering to the needs of professionals seeking to enhance their data analysis skills

Enhances data comprehension and utilization by teaching how to filter, sort, and group data for informed decision-making

Provides hands-on practice through exercises and quizzes, reinforcing concepts and ensuring learners' understanding

Suitable for beginners seeking to establish a solid foundation in SQL and data management

Delivered by Kyle Pew and Office Newb, recognized experts in SQL and data management, offering learners access to industry insights

Recommended for individuals seeking to advance their careers in data analysis, business intelligence, or related fields

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in SQL - Introduction to SQL with MySQL with these activities:

Join a study group

Show steps

Engage with fellow learners to discuss concepts, solve problems, and enhance your understanding.

Show steps

Find a study group or create your own
Set regular meeting times
Prepare and participate in discussions

Review SQL syntax

Show steps

Practice writing and executing basic SQL queries to strengthen your understanding of the language.

Browse courses on SQL Syntax

Show steps

Follow tutorials on advanced SQL concepts

Show steps

Supplement your learning with video tutorials or online courses to delve deeper into advanced SQL concepts.

Browse courses on Advanced SQL

Show steps

One other activity

Expand to see all activities and additional details

Show all four activities

Build a small database application

Show steps

Apply your SQL skills by designing and developing a simple database application that solves a real-world problem.

Browse courses on Database Design

Show steps

Define the problem and gather requirements
Design the database schema
Create the database and implement the application
Test and refine the application

Career center

Learners who complete SQL - Introduction to SQL with MySQL will develop knowledge and skills that may be useful to these careers:

Reading list

We haven't picked any books for this reading list yet.

SQL - Introduction to SQL with MySQL

Here's a deal for you

What's inside

Learning objectives

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses