Curriculum

23 Topics
Course Overview
Instructor Introduction
Module 1 Introduction
Getting Started with Databases - Part 1
Getting Started with Databases - Part 2
Relational Databases
Structured Query Language
SQL Example
Database Systems
Database Management System
Enterprise-Class Database Systems
Syllabus
Assignment Deadlines and Time Management
Module 1 Introduction Reading
Components of a Database System
Database Management Systems
Lists Relational Database Management Systems and SQL
Module 1 Summary
Module 1 Summative Assessment
Components of a Database System Quiz
Database Management Systems Quiz
Lists Relational Database Management Systems and SQL Quiz
Meet and Greet Discussion

18 Topics
Module 2 Introduction
Entities
Relations
Keys
Setting Up Keys
Setting Up a Database in SQL Server - Part 1
Setting Up a Database in SQL Server - Part 2
Setting Up a Database in SQL Server - Part 3
Setting Up a Database in SQL Server - Part 4
Module 2 Introduction Reading
The Relational Model
Importance of Keys
Keys and Functional Dependencies
Module 2 Summary
Module 2 Summative Assessment
The Relational Model Quiz
Importance of Keys Quiz
Keys and Functional Dependencies Quiz

21 Topics
Module 3 Introduction
Introduction to SQL - Part 1
Introduction to SQL - Part 2
Introduction to SQL - Part 3
Introduction to SQL - Part 4
Introduction to SQL - Part 5
SQL Queries - Part 1
SQL Queries - Part 2
SQL Queries - Part 3
SQL Queries - Part 4
SQL Queries - Part 5
Module 3 Introduction Reading
Basic SQL Statements
Basic SQL Queries
Working with Multiple Tables
Module 3 Summary
Insights from an Industry Leader: Learn More About Our Program
Module 3 Summative Assessment
Basic SQL Statements Quiz
Basic SQL Queries Quiz
Working with Multiple Tables Quiz

18 Topics
Module 4 Introduction
SQL - Data Manipulation Language (DML) - Part 1
SQL - Data Manipulation Language (DML) - Part 2
Querying and Filtering Data - Exercises - Part 1
Querying and Filtering Data - Exercises - Part 2
Querying and Filtering Data - Exercises - Part 3
Querying and Filtering Data - Exercises - Part 4
Join Statements - Part 1
Join Statements - Part 2
Module 4 Introduction Reading
SQL - Data Manipulation Language (DML)
DML - Adding Data to a Table
DML - Updating and Deleting Data from a Table
Module 4 Summary
Module 4 Summative Assessment
SQL - Data Manipulation Language (DML) Quiz
DML - Adding Data to a Table Quiz
DML - Updating and Deleting Data from a Table Quiz

19 Topics
Module 5 Introduction
Working with Joints in MS-SQL - Part 1
Working with Joints in MS-SQL - Part 2
Working with Joints in MS-SQL - Part 3
Working with Joints in MS-SQL - Part 4
DDL
Creating Tables Using MS-SQL - Part 1
Creating Tables Using MS-SQL - Part 2
Creating Tables Using MS-SQL - Part 3
Creating Tables Using MS-SQL - Part 4
Module 5 Introduction Reading
Working with Subqueries
Aggregate Functions
SQL JOINS
Module 5 Summary
Module 5 Summative Assessment
Working with Subqueries Quiz
Aggregate Functions Quiz
SQL JOINS Quiz

18 Topics
Module 6 Introduction
Requirements Analysis - Part 1
Requirements Analysis - Part 2
ER Data Model
Binary Relationships - Part 1
Binary Relationships - Part 2
Crow's Foot Notation
Working with ER Diagrams in SQL - Part 1
Working with ER Diagrams in SQL - Part 2
Module 6 Introduction Reading
Database Development Lifecycle
Data Models
Entity Relationship Diagrams 
Module 6 Summary
Module 6 Summative Assessment
Database Development Lifecycle Quiz
Data Models Quiz
Entity Relationship Diagrams Quiz

22 Topics
Module 7 Introduction
Database Design - Part 1
Database Design - Part 2
Database Design - Part 3
Database Normalization - Part 1
Database Normalization - Part 2
Normal Forms - Part 1
Normal Forms - Part 2
Normal Forms - Part 3
Normal Forms Examples - Part 1
Normal Forms Examples - Part 2
Normal Forms Examples - Part 3
Normal Forms Demonstration
Module 7 Introduction Reading
ER Models and the Relational Models
Database Normalization
Representation of ER Diagrams and Relationships
Module 7 Summary
Module 7 Summative Assessment
ER Models and the Relational Models Quiz
Database Normalization Quiz
Representation of ER Diagrams and Relationships Quiz

21 Topics
Module 8 Introduction
Authentication
Authorization
SQL Server Login - Part 1
SQL Server Login - Part 2
Database Administration
SQL Server Rows
Views
Views Exercise
Database Security
Triggers - Part 1
Triggers - Part 2
Module 8 Introduction Reading
Importance of Database Administration
Database Administration and Data Administration
Database Security
Module 8 Summary
Module 8 Summative Assessment
Importance of Database Administration Quiz
Database Administration and Data Administration Quiz
Database Security Quiz

1 Topic
Summative Course Assessment

  Write a Review

Data Modeling and Applications

Go to Free Course