Getting Started with SQL-Basic SQL
Course Introduction
()
Introduction to Databases
()
SELECT Statement
()
COUNT, DISTINCT, LIMIT
()
INSERT Statement
()
UPDATE and DELETE Statements
()
Getting Started with SQL-Summary and Module Assessment
Summary & Highlights
Introduction to Relational Databases and Tables-Introduction to Relational Databases and Tables
Relational Database Concepts
()
Types of SQL statements (DDL vs. DML)
()
CREATE TABLE Statement
()
ALTER, DROP, and Truncate tables
()
Introduction to Relational Databases and Tables-Optional: Hands-on Labs with Db2
Optional Db2 Labs
How to create a Database instance on Cloud
()
Introduction to Relational Databases and Tables-Summary and Module Assessment
Summary & Highlights
Intermediate SQL-Refining your Results
Using String Patterns and Ranges
()
Sorting Result Sets
()
Grouping Result Sets
()
Summary & Highlights
Intermediate SQL-Functions, Multiple Tables, and Sub-queries
Built-in Database Functions
()
Date and Time Built-in Functions
()
Sub-Queries and Nested Selects
()
Working with Multiple Tables
()
Summary & Highlights
Working with real-world data sets, Final Project & Exam-Assignment Preparation: Working with real-world data sets and built-in SQL functions
Working with Real World Datasets
()
Getting Table and Column Details
()
Working with real-world data sets, Final Project & Exam-Course Wrap-up
Congratulations & Next Steps
Course Team
Advanced SQL (Honors)-About this Honors module
About this Honors Module
Advanced SQL (Honors)- Views, Stored Procedures, and Transactions (Honors)
Views
()
Stored Procedures
()
ACID Transactions
()
Summary & Highlights
Advanced SQL (Honors)-JOIN Statements (Honors)
Join Overview
()
Inner Join
()
Outer Joins
()
Summary & Highlights