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

Requirements

Background in Database Concept

  35 Hours
 

Testimonials

Related Courses

Administering in Microsoft SQL Server

  21 hours

Microsoft SQL Server 2008/2012 (MSSQL)

  14 hours

Business Intelligence in MS SQL Server 2008

  14 hours

Developing in SQL Server Business Intelligence

  35 hours

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

  14 hours

T-SQL Fundamentals with SQL Server Training Course

  14 hours

SQL language in MSSQL

  14 hours

SQL in SQL Server

  14 hours

Transact SQL Advanced

  7 hours

Transact SQL Basic

  14 hours

Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012

  21 hours

Administration with Powershell

  35 hours

Business Intelligence with SSAS

  14 hours