SQL – Introduction to SQL with MySQL

SQL – Introduction to SQL with MySQL, available at $79.99, has an average rating of 4.57, with 58 lectures, 8 quizzes, based on 7756 reviews, and has 25583 subscribers.

You will learn about 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 This course is ideal for individuals who are Any Data User that wants to learn how to communicate with a database using SQL It is particularly useful for Any Data User that wants to learn how to communicate with a database using SQL.

Enroll now: SQL – Introduction to SQL with MySQL

Summary

Title: SQL – Introduction to SQL with MySQL

Price: $79.99

Average Rating: 4.57

Number of Lectures: 58

Number of Quizzes: 8

Number of Published Lectures: 58

Number of Published Quizzes: 8

Number of Curriculum Items: 66

Number of Published Curriculum Objects: 66

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will Learn

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

Who Should Attend

Any Data User that wants to learn how to communicate with a database using SQL

Target Audiences

Any Data User that wants to learn how to communicate with a database using SQL

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.

COURSE OBJECTIVES

In this SQL course you will learn the fundamental building blocks of creating, querying and working with databases using MySQL.

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!

Course Curriculum

Chapter 1: MySQL Course Introduction

Lecture 1: Welcome to the "Introduction to MySQL" Course

Lecture 2: Downloadable MySQL Course Resources

Lecture 3: Visit the Course QA Board

Chapter 2: Introduction to MySQL

Lecture 1: What is SQL?

Lecture 2: Introduction to Relational Database Design

Lecture 3: Why MySQL

Chapter 3: Getting Up and Running with MySQL

Lecture 1: Installing MySQL on Windows

Lecture 2: Installing MySQL on Windows Continued

Lecture 3: Introduction to MySQL Interface

Lecture 4: Setting Up the MySQL Course Database

Lecture 5: Introduction to Course Database

Chapter 4: Working with SQL SELECT Statement

Lecture 1: Identify which Database by the USE statement

Lecture 2: SQL SELECT Statement Syntax

Lecture 3: Using the SELECT Statement to Retrieve Columns from a Table

Lecture 4: QUICK TIP – Query All Columns from a Table

Lecture 5: Using a Column Name Alias

Lecture 6: Removing Duplicate Values by Using the DISTINCT Statement

Lecture 7: Exercise #1 – SQL Select

Chapter 5: Filtering SQL Data

Lecture 1: SQL WHERE Clause Syntax

Lecture 2: Filter Records based on Single Criteria using the WHERE Clause

Lecture 3: Filtering Text vs. Numeric Data

Lecture 4: CHEAT SHEET – Filter Operators used in the WHERE Clause (DOWNLOAD)

Lecture 5: Filtering with SQL AND Operator

Lecture 6: QUICK TIP – MySQL Comments

Lecture 7: Filtering Date Values with the Between Operator

Lecture 8: Filtering with SQL OR Operator

Lecture 9: Exercise #2 – SQL WHERE Clause

Chapter 6: Sorting SQL Data

Lecture 1: SQL ORDER BY Keyword Syntax

Lecture 2: Sort SQL Data Ascending/Descending using the ORDER BY Keyword

Lecture 3: Sort SQL Data by Multiple Columns

Lecture 4: Exercise #3 – SQL ORDER BY Keyword

Chapter 7: Grouping SQL Data

Lecture 1: SQL GROUP BY Syntax

Lecture 2: Grouping SQL Data by a Column Value

Lecture 3: QUICK TIP – DISTINCT VS. GROUP BY

Lecture 4: Performing Calculations within the Grouped Data

Lecture 5: CHEAT SHEET – MySQL Aggregate Functions when Grouping

Lecture 6: Filtering Grouped Data with the SQL Having Clause

Lecture 7: Exercise #4 – SQL GROUP BY Quiz

Chapter 8: Creating a MySQL Database

Lecture 1: Create a New Database in MySQL

Lecture 2: Using the DROP Statement to Delete a Database

Lecture 3: Adding Tables to the Database using the CREATE TABLE Statement

Lecture 4: Using the DROP Statement to Delete a Table

Lecture 5: SQL NOT NULL Constraint

Lecture 6: SQL AUTO_INCREMENT Column

Lecture 7: SQL PRIMARY KEY Constraint

Lecture 8: RECAP – Table Relationships

Lecture 9: SQL FOREIGN KEY Constraint

Lecture 10: Exercise #5 – Creating a MySQL Table

Chapter 9: Inserting Records into SQL Database Tables

Lecture 1: SQL INSERT INTO Statement Syntax

Lecture 2: Inserting Data into Specific Columns of a Table

Lecture 3: Inserting Data into Every Column of a Table

Lecture 4: Exercise #6 – Inserting Records

Chapter 10: Querying Multiple Tables with a Relationship

Lecture 1: SQL Table JOIN Syntax

Lecture 2: SQL INNER JOIN

Lecture 3: SQL LEFT and RIGHT JOIN

Lecture 4: SQL IS NULL Value

Lecture 5: Exercise #7 – SQL Table JOIN

Chapter 11: Congratulations

Lecture 1: Congratulations on Completing the Introduction to SQL Course

Instructors

Kyle Pew
Microsoft Certified Trainer – 1 Million+ Students
Office Newb
Software Trainer

Rating Distribution

1 stars: 17 votes
2 stars: 35 votes
3 stars: 449 votes
4 stars: 2715 votes
5 stars: 4553 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!

Menu