SQL and Relational Databases 101 (IBM)

About Course

Data is one of the most critical assets of any business. Data needs a database to store and process data quickly. SQL is a language used for a database to query data.

In this introductory course, you’ll learn the basics of the SQL language and the relational databases. You’ll start by learning about the relational model and relational model concepts and constraints. By the end of this course, you will have learned and used the five basic SQL statements, some advanced SQL syntax, and join statements.

This isn’t your typical textbook introduction. You’re not just learning through lectures. At the end of each module there are assignments, hands-on exercises, review questions, and also a final exam. Successfully completing this course earns you a certificate. So let’s get started!

Module 1 -SQL and Relational Databases 101
Introduction to SQL and Relational Databases
Information and Data Models
Types of Relationships
Mapping Entities to Tables
Relational Model Concepts
Module 2 - Relational Model Constraints and Data Objects
Relational Model Constraints Introduction
Relational Model Constraints Advanced
Module 3 - Data Definition Language (DDL) and Data Manipulation Language (DML)
CREATE TABLE statement
INSERT statement
SELECT statement
UPDATE and DELETE statements
Module 4 - Advanced SQL
String Patterns, Ranges, and Sets
Sorting Result Sets
Grouping Result Sets
Module 5 - Working with multiple tables
Join Overview
Inner Join
Outer Join

Course Content

Module 0: Career Development

Career Assessment

00:00

Module 1: Intro to Course

Module 2: Course Completion

Module3: Certification and Ranking

Student Ratings & Reviews

No Review Yet

SQL and Relational Databases 101 (IBM)

About Course

What Will You Learn?

Course Content

Module 0: Career Development

Career Assessment

Module 1: Intro to Course

Start Your Course

Module 2: Course Completion

Course Verification

Module3: Certification and Ranking

Certificate and Rank