Scribd
Upload
3 views1 page

SQL and Relational Databases Overview

The syllabus outlines a data analysis course focused on SQL and relational databases. It covers fundamental concepts, constraints, data definition and manipulation languages, and advanced techniques including working with multiple tables and joins. Each module builds on the previous one to provide a comprehensive understanding of data analysis using SQL.

Uploaded by

The All In One
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
3 views1 page

SQL and Relational Databases Overview

The syllabus outlines a data analysis course focused on SQL and relational databases. It covers fundamental concepts, constraints, data definition and manipulation languages, and advanced techniques including working with multiple tables and joins. Each module builds on the previous one to provide a comprehensive understanding of data analysis using SQL.

Uploaded by

The All In One
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

Syllabus data analysis

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)

Types of SQL statements (DDL vs. DML)


CREATE TABLE statement
INSERT statement
SELECT statement
UPDATE and DELETE statements
Module 4 - Advanced DDL and DML

String Patterns, Ranges, and Sets


Sorting Result Sets
Grouping Result Sets
Module 5 - Working with multiple tables

Join Overview
Inner Join
Outer Join

You might also like