Skip to main content
Side panel
Course Catalog
My Dashboard
Help
Getting Started
Help Center & FAQ
Search
Close
Search
Toggle search input
Log in or Sign up
Course Catalog
My Dashboard
Help
Getting Started
Help Center & FAQ
CS403: Introduction to Modern Database Systems
Sections
Course Introduction
Course Syllabus
Unit 1: Introduction to Modern Database Systems
Unit 2: Database Architecture and Date Languages
Unit 3: The History of Databases
Unit 4: The Entity-Relationship Model
Unit 5: The Relational Database Model
Unit 6: Relational Algebra
Unit 7: Introduction to Data Normalization
Unit 8: Introduction to SQL
Unit 9: Basic Select Statements
Unit 10: The Join Statement
Study Guide
Course Feedback Survey
Certificate Final Exam
Resources
Activities
Quizzes
Home
My programs
My certificates
CS403: Introduction to Modern Database Systems
Home
Courses
Course Catalog
Computer Science
CS403: Introduction to Modern Database Systems
Sections
Unit 10: The Join Statement
10.5: Assessment
SQL Exercises
Back to '10.5: Assessment\'
SQL Exercises
Mark as completed
If you'd like more practice with SQL, attempt some of these exercises.
Click
http://www.w3resource.com/mysql-exercises/
link to open resource.
Mark as completed
Previous
Jump to...
Jump to...
Course Syllabus
Before the Advent of Database Systems
Fundamental Concepts and Benefits of a Database
Introduction to Database Systems
Database Models
Types of Data Models and Data Modeling
Elements of Database Systems
Classification of Database Management Systems
Comparison of NoSQL Database Management Systems and Models
Classifying Database Management Systems: Regular and NoSQL
Unit 1 Assessment
Three-Schema Architecture
Data Modeling and a Framework for Database System Design
The Relational Data Model
Relational Databases
Introduction to Relational Databases
Unit 2 Assessment
A Brief History of Databases
History of Databases
Database Models
Unit 3 Assessment
Conceptual Designs
The Entity-Relationship Data Model
Entity-Relationships
Data Modeling: Entity-Relationship (E-R)
Data Models
Introduction to the Entity-Relationship Model
The Enhanced Entity-Relationship Model
Advanced Topics in E-R Modeling
Unit 4 Assessment
The Relational Data Model
The Relational Database Model
ER Model to Relational Mapping
Integrity Rules and Constraints
Unit 5 Assessment
Relational Algebra
The Relational Database Model
Relational Algebra
Relational Algebra and Relational Calculus
SQL Data Manipulation Language
The Relational Database Model
The Structured Query Language
Unit 6 Assessment
Database Normalization
Normalization
Normalized Database Design
Entity Relationship Diagrams
Data Anomalies
Functional Dependencies
Normalizing a Relation to BCNF Based on Functional Dependencies
Unit 7 Assessment
Introduction to SQL
Another Introduction to SQL
SQL Structured Query Language
SQL Tutorial
Drop Table
Alter Table
SQL Tutorial
SQL Tutorial
SQL Insert, Update, and Delete Commands
Unit 8 Assessment
SQL Tutorial
PostgreSQL Tutorial: AND, OR, NOT
SQL LIKE Operator
SQL BETWEEN Operator
SQL: Using WHERE Clause with NOT LIKE Operator and Escape Character
MySQL SELECT Statement
Select (SQL)
SQL ORDER BY Clause
Unit 9 Assessment
INNER JOIN
SQL Data Manipulation Language
SQL JOINS
Aggregates and JOINs
Inner vs. Outer Joins in SQL
SQL INNER JOIN
SQL OUTER JOIN
SQL RIGHT JOIN
SQL Full Outer Join
GROUP BY
SQL GROUP BY Clause
Unit 10 Assessment
CS403 Study Guide
Course Feedback Survey
CS403: Certificate Final Exam
Next