Course Preview
Week 1?
Module 1 provides the context for Database Management Essentials. When you’re done, you’ll understand the objectives for the course and know what topics and assignments to expect. Keeping these course objectives in mind will help you succeed throughout the course!
Intro
Course Flow
Installation Of Software
Making Connections To Local Database
Introduction to Databases and DBMSs
Organizational Roles
DBMS Overview
Transaction Processing
Basic SQL Create table Statement
Integrity Constraints
Module 1 Quiz
Week 2
Select Statement Introduction
Join Operations
Assignments
Information on Keys and Constraints
String Patterns, Ranges, Sorting and Grouping
Week 3
Group BY Clause
Multiple Table Problems
Join And Grouping Operations
Set Operators
Modification Statements
Query Formulation Errors
Final Assignment
