SQL & Databases (MySQL) enroll
Learn the fundamentals relational databases and the Structured Query Language (SQL) using MySQL.
7 Sections · 59 Pages · By Ryan Desmond
-
Level
Perfect for beginners
-
Duration
40 Hours.
-
What's included
40 lessons. 19 videos.
-
Certificate
SQL & Databases Certificate
This course is part of the following career tracks:
-
Java Enterprise Career Track enroll
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 enroll
Become 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 advanced data science, machine learning and deep learning techniques.
-
Python Web Development Career Track enroll
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.
-
2) MySQL & MySQL Workbench
-
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
-
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
-
Inserting Data
-
INSERT4 min
-
CREATE TABLE SELECT5 min
-
Adding Data to a Database6 min
-
Updating & Deleting Data
-
UPDATE4 min
-
DELETE3 min
-
Video: SQL Update + Delete9 min
-
Joining Tables
-
SQL JOINS4 min
-
INNER JOIN10 min
-
LEFT / RIGHT JOIN8 min
-
Video: JOINS22 min
-
UNION4 min
-
Video: UNION3 min
-
Aggregate Functions
-
SUM / COUNT / AVG5 min
-
MAX / MIN3 min
-
Video: COUNT(), SUM(), AVG(), MAX()6 min
-
GROUP BY3 min
-
Video: GROUP BY6 min
-
Flexible / Catch-All Queries
-
LIKE + Wildcards5 min
-
Video: LIKE + Wildcards4 min
-
IN3 min
-
BETWEEN3 min
-
Video: IN + BETWEEN3 min
-
ANY / ALL4 min
-
Stored Procedures
-
Working with SQL Stored Procedures8 min
-
Video: Stored Procedures3 min
-
Assignment
-
Journal: SQL Query Practice3 min
-
-
6) Managing Databases
-
7) Completion Certificate