Offered By: BDU
SQL and Relational Databases 101
Are you ready to dive into the world of SQL and relational databases? In just a few hours, you'll be able to discuss SQL basics and explain various aspects of the relational database model. Try our hands-on exercises as we guide your first steps into SQL and relational databases.
Continue readingCourse
Database
116k+ EnrolledAt a Glance
Are you ready to dive into the world of SQL and relational databases? In just a few hours, you'll be able to discuss SQL basics and explain various aspects of the relational database model. Try our hands-on exercises as we guide your first steps into SQL and relational databases.
About This Course
Course Syllabus
- 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
Recommended skills prior to taking this course
- None
Estimated Effort
3 Hours
Level
Beginner
Skills You Will Learn
Databases, SQL
Language
English
Course Code
DB0101EN