SQL level 1

This three-day Microsoft SQL Server Beginners Training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. This course leverages the same content as found in the Microsoft Official Academic Course (MOAC) for this exam.

Target Audience

The Microsoft Technology Associate (MTA) is Microsoft's newest suite of technology certification exams that validate fundamental knowledge needed to begin building a career using Microsoft technologies. This program provides an appropriate entry point to a future career in technology and assumes some hands-on experience or training but does not assume on-the-job experience.

Course Outline:

1. Getting Started with Microsoft SQL Server

• Overview of Microsoft SQL Server
• Installing and Configuring SQL Server
• Using the Tools in SQL Server

2. Designing Databases

• Creating Databases
• Designing Tables
• IndexesPartitioning

3. Retrieving and Manipulating Data

• Data Retrieval
• Advanced Data Retrieval
• Data Manipulation

4. Creating Database Objects

• Views
• Stored Procedures
• Functions
• Triggers
• Database Snapshots
• Service Broker
• Full-Text Indexing

5. Database Management

• Security
• Policy-Based Management
• Data Recovery
• SQL Server Agent
• Dynamic Management Views