Course Overview
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!
FAQ
FAQ area empty
Course curriculum
-
Identify which Database by the USE statement
100 Xem trước -
SQL SELECT Statement Syntax
123 -
Using the SELECT Statement to Retrieve Columns from a Table
120 -
QUICK TIP - Query All Columns from a Table
69 Xem trước -
Using a Column Name Alias
236 -
Removing Duplicate Values by Using the DISTINCT Statement
141 -
Exercise #1 - SQL Select
-
Quiz #2 - SQL SELECT Statement Quiz
-
SQL WHERE Clause Syntax
149 -
Filter Records based on Single Criteria using the WHERE Clause
145 -
Filtering Text vs. Numeric Data
254 -
CHEAT SHEET - Filter Operators used in the WHERE Clause (DOWNLOAD)
-
Filtering with SQL AND Operator
202 -
QUICK TIP - MySQL Comments
199 -
Filtering Date Values with the Between Operator
429 -
Filtering with SQL OR Operator
263 -
Exercise #2 - SQL WHERE Clause
-
Quiz #3 - SQL Where Clause Quiz
-
SQL GROUP BY Syntax
205 -
Grouping SQL Data by a Column Value
129 -
QUICK TIP - DISTINCT VS. GROUP BY
321 -
Performing Calculations within the Grouped Data
213 -
CHEAT SHEET - MySQL Aggregate Functions when Grouping
93 -
Filtering Grouped Data with the SQL Having Clause
277 -
Exercise #4 - SQL GROUP BY Quiz
-
Quiz #5 - SQL GROUP BY Quiz
-
Create a New Database in MySQL
155 -
Using the DROP Statement to Delete a Database
101 -
Adding Tables to the Database using the CREATE TABLE Statement
350 -
Using the DROP Statement to Delete a Table
89 -
SQL NOT NULL Constraint
91 -
SQL AUTO_INCREMENT Column
71 -
SQL PRIMARY KEY Constraint
154 -
RECAP - Table Relationships
226 -
SQL FOREIGN KEY Constraint
413 -
Exercise #5 - Creating a MySQL Table
-
Quiz #6 - Creating a SQL Database
Requirment
-
No Prior Experience with Databases, SQL or MySQL is Necessary. This Course Starts at the Beginner Level
-
A Computer with Internet Connection (Windows, MAC, or Linux)
Outcomes
-
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
0 Student
1 Course
0 review