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