SQL & Databases (MySQL)
Course Summary
Learn the fundamentals of relational databases and the Structured Query Language (SQL) using MySQL.
7 Sections · 72 Pages · By Ryan Desmond
-
Level
Perfect for beginners
-
Duration
40 Hours.
-
What's included
41 lessons. 19 videos. 12 quizzes. 5 journals.
-
Certificate
SQL & Databases Certificate
This course is part of the following career tracks:
-
Python Web Development Career Track
Become a professional Python developer. Learn to build your own products, scripts, and automations from scratch using Python, Django, Flask, SQL, APIs, and more. Learn to think like a Python developer, and dive into the wonderful black hole of tinkering with code until it works! This track starts with Python basics, and takes you through building complete Python full stack web applications.
-
Java Enterprise Career Track
Become a full stack Java developer. Learn to build and deploy production-grade software using Java, Spring, and AWS - like the learning platform you’re lookin’ at right now! This track includes the complete package to go from beginner to professional full stack Java developer. See why CodingNomads ranked one of the best online Java courses by Forbes and ZDNet.
-
Data Science + Machine Learning + AI Career Track
Join the AI revolution by becoming a machine learning and data science engineer. Learn to build end-to-end machine learning models that solve decision making problems in areas of your interest. This career track starts with Python, and takes you through building a portfolio of projects using in-demand data science, machine learning and deep learning techniques.
-
2) MySQL & MySQL Workbench
-
3) Creating Relational Databases
-
What is a Relational Database?6 min
-
Link: Tutorial on Relational Database Design
-
Create a DB Schema + Tables16 min
-
Let's Add Some Data!9 min
-
Video: Creating a Simple Relational Database26 min
-
Assignments
-
Assignment: Create a Travel Company Database
-
Journal: Primary & Foreign Keys
-
Quiz: Creating Relational Databases
-
-
4) Importing MySQL Demo Database
-
5) SQL Commands for Querying Databases
-
Retrieving Data
-
SELECT4 min
-
SELECT DISTINCT4 min
-
Video: SQL SELECT + SQL SELECT DISTINCT4 min
-
Quiz: Retrieving Data
-
Filtering Queries
-
SELECT WHERE4 min
-
AND / OR / NOT6 min
-
Video: Filtering SQL Queries3 min
-
ORDER BY4 min
-
LIMIT3 min
-
Video: SQL ORDER BY + SQL LIMIT3 min
-
Quiz: Filtering Queries
-
Inserting Data
-
INSERT4 min
-
CREATE TABLE SELECT5 min
-
Adding Data to a Database6 min
-
Quiz: Inserting Data
-
Updating & Deleting Data
-
UPDATE4 min
-
DELETE3 min
-
Video: SQL Update + Delete9 min
-
Quiz: Updating & Deleting Data
-
Joining Tables
-
SQL JOINS4 min
-
INNER JOIN10 min
-
LEFT / RIGHT JOIN8 min
-
Video: JOINS22 min
-
UNION4 min
-
Video: UNION3 min
-
Quiz: Joining Tables
-
Aggregate Functions
-
SUM / COUNT / AVG5 min
-
MAX / MIN3 min
-
Video: COUNT(), SUM(), AVG(), MAX()6 min
-
GROUP BY3 min
-
Video: GROUP BY6 min
-
Quiz: Aggregate Functions
-
Flexible / Catch-All Queries
-
LIKE + Wildcards5 min
-
Video: LIKE + Wildcards4 min
-
IN3 min
-
BETWEEN3 min
-
Video: IN + BETWEEN3 min
-
ANY / ALL4 min
-
Quiz: Flexible Queries
-
Stored Procedures
-
Working with SQL Stored Procedures8 min
-
Video: Stored Procedures3 min
-
Quiz: Stored Procedures
-
Assignment
-
Journal: SQL Query Practice
-
-
6) Managing Databases
-
Using MySQL from the CLI4 min
-
Video: Using MySQL from the CLI8 min
-
MySQL Database Backup & Restore: CLI8 min
-
Video: MySQLdump & Restore from the CLI4 min
-
MySQL Database Backup & Restore: MySQL Workbench8 min
-
Video: Intro to AWS RDS10 min
-
Assignment
-
Journal: Import + Export from MySQL
-
Quiz: Managing Databases
-
-
7) SQL Certificate Request