Duration
35 hours (usually 5 days including breaks)
Requirements
Background in Database Concept
Overview
After completing this course, students will be able to:
- Understand Core Database Concepts
- Create Database Objects
- Manipulate Data
- Understand Data Storage
- Administer a Database
Course Outline
Module 1: Understanding Core Database Concepts
•Introduction core database concepts
•Define databases
•Example of relational database tables
•Introduce common database terminology
•Relational Concepts
•Normalization
•Referential Integrity
•Constraints
Module 2: Creating Database Objects
•Data types
•Data Objects
•DLL (Data Definition Language) Statements
•Creating Scripts
Module 3: Manipulating Data
•Using DML (data manipulation language) Statements
•Using SELECT Statement
•Using INSERT, UPDATE, and DELETE to manage data
•Indexes
•Triggers
Module 4: Understanding Data Storage
•Designing Tables
•Creating and Modifying Tables
•Viewing Tables
•Deleting a Table
Module 5: Administering a Database
•SQL Server Security
•Securing Database and Objects
•Performing Database Backups
•Performing Database Restores