What Will You Learn?
In this introductory free 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.
About This Course
Provider: Cognitive class
Format: Online
Duration: 3 hours to complete [Approx]
Target Audience: Beginners
Learning Objectives: You will be able to discuss SQL basics and explain various aspects of the relational database model after completing this free course
Course Prerequisites: NA
Assessment and Certification: NA
Instructor: IBM
Key Topics: SQL, Databases, Relational Databases
Topic Covered:
- - Introduction to SQL and Relational Databases
- - Information and Data Models
- - Types of Relationships
- - Mapping Entities to Tables
- - Relational Model Concepts
- - Relational Model Constraints Introduction
- - Relational Model Constraints Advanced
- - CREATE TABLE statement
- - INSERT statement
- - SELECT statement
- - UPDATE and DELETE statements
- - String Patterns, Ranges, and Sets
- - Sorting Result Sets
- - Grouping Result Sets
- - Join Overview
- - Inner Join
- - Outer Join
0 Comments