Database Administration Fundamentals for MS SQL Server Training Course

Course Code



35 hours (usually 5 days including breaks)


Background in Database Concept


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
•Referential Integrity

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

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



Related Categories

Related Courses

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

This site in other countries/regions