SQL Introduction to SQL with MySQL

SQL – Introduction to SQL with MySQL
Genre: eLearning | MP4 | Video: h264, 1280×720 | Audio: AAC, 48.0 KHz

Become a SQL Guru by Learning the Building Blocks of Working with SQL using MySQL

What you’ll 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

Description
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

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.

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

Who this course is for:
Any Data User that wants to learn how to communicate with a database using SQL