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