Intro to SQL/MySQL
This course will teach you the basics of SQL/MySQL. It will teach you how to install a query browser, create schemas and tables, and write queries using basic commands, mathematical operators functions and joins to pull data from a SQL/MySQL database. This is a beginner level course which is meant to give you an introduction to basic SQL/MySQL commands. This is not a course on database concepts, but is meant for individuals who want to take the first steps towards learning tools for pulling data from a database for building analytical reports.
Table of Contents 
Edit this course
-
Chapter 1. Getting started (~19 Minutes)
Concepts:- 1. What is SQL ? (~7 Minutes)
- 2. Downloading the query browser and connecting to the database (~2 Minutes)
- 3. Creating a SQL/MySQL Database and table (~7 Minutes)
-
Chapter 2. Basic MySQL commands (~56 Minutes)
Concepts:- 1. SELECT command (~7 Minutes)
- 2. SELECT command with keyword distinct (~1 Minutes)
- 3. WHERE clause with logical operators, IN command, BETWEEN command, LIKE command (~2 Minutes)
- 4. ORDER BY operator (Part 1) (~7 Minutes)
- 5. ORDER BY operator (Part 2) (~7 Minutes)
- 6. ORDER BY operator (Part 3) (~7 Minutes)
- 7. INSERT command (~7 Minutes)
- 8. UPDATE command (~6 Minutes)
- 9. DELETE command (~7 Minutes)
-
Chapter 3. MySQL Functions (~22 Minutes)
Concepts:- 1. COUNT() (~2 Minutes)
- 2. AVG() (~3 Minutes)
- 3. SUM(),MIN(),MAX() (~7 Minutes)
- 4. GROUP BY (~7 Minutes)
-
Chapter 4. Advanced MySQL (Types of Keys) (~15 Minutes)
Concepts:- 1. Primary Key (~5 Minutes)
- 2. Foreign Key (~7 Minutes)
-
Chapter 5. MySQL Joins (~62 Minutes)
Concepts:- 1. Joins (~9 Minutes)
- 2. Left Join (~7 Minutes)
- 3. Inner Join (~26 Minutes)
- 4. Outer Join (~17 Minutes)