MTA 98-364: Database Administration Fundamentals

NR Computer Learning Center (NRCLC) offers hands-on training to help students gain the fundamental knowledge and skills required to manage a Microsoft database. Students will learn the database design concepts, creating database objects, managing data, using SQL statement, using T-SQL, developing Stored Procedure and administrating a database.This course will help students prepare for MTA 98-364 exams.

Technology

Microsoft SQL Server 2008 R2, T-SQL, SQL

Topic:

  • Core database concepts
  • Tables, columns/fields, rows/records
  • Relational database concepts.
  • Data manipulation language (DML).
  • Data definition language (DDL).
  • Using ANSI SQL and T-SQL
  • Creating database objects
  • Data types
  • Selecting, inserting, updating, or deleting data
  • Manipulating data
  • Extracting data suing select statement
  • Extracting data by using joins
  • Combining result sets by using union and intersect
  • Using insert statements
  • Using update statement to update data in a table
  • Deleting data from single or multiple tables
  • Ensuring data and referential integrity by using transactions
  • Stored procedures and functions.
  • Five most common levels of normalization
  • How to normalize a database to third normal form
  • Keys: Primary, foreign, and composite
  • Choosing appropriate primary keys
  • Selecting appropriate data type for keys
  • Selecting appropriate fields for composite keys
  • The relationship between foreign and primary keys
  • Views and Indexes
  • Clustered and non-clustered indexes
  • Administering a database
  • Database security concepts
  • Identifying the objects can be secured, should be secured
  • User accounts, and roles
  • Database backups and restore

Prerequisites

  • Introduction to Database Design and SQL or equivalent

Target Audience

  • Student wanting to learn review database design, SQL language, T-SQL or prepare for Microsoft Technology Associate (MTA) Exam

The Training Includes

  • Classroom instruction
  • Hands-on workshops
  • Training Material
  • Quick Reference Guide

For more information

call 714-505-3475