Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

SQL - Introduction to SQL with MySQL

via Udemy

Overview

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

LEARNSQL WITHMySQL

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 SQLcomes into play. SQLstands 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.


WHYTHISCOURSE

This SQLcourse 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. MySQLis 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 TRUELEARNINGhappens 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 QAboard 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 SQLcourse you will learn the fundamental building blocks of creating, querying and working with databases using MySQL.

  • Learn Proper SQLSyntax Using the MySQLWorkbench

  • Learn Relational Database Design Concepts

  • Use the SQLSELECTStatement 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 SQLWhere Clause

  • Create Advanced Queries by Using the Proper Filter Operators

  • Use the SQLORDERBYKeyword to Sort the Results of a Query

  • Learn How to Properly Group Data and Create Calculations for Reporting

  • Use the SQLHAVINGClause to Filter within Data Groups

  • Create a MySQLDatabase from Scratch

  • Learn How to Create Tables and Manage Records within the Tables

  • And Much More...


WHAT AREYOUWAITINGFOR

Start your SQLjourney by enrolling now. See you in the course!

Taught by

Kyle Pew and Office Newb

Reviews

4.6 rating at Udemy based on 8464 ratings

Start your review of SQL - Introduction to SQL with MySQL

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.