MTA 98 364 - database fundamentals

NR Computer Learning Center 1835 W. Orangewood, Suite 200 Orange . CA 92868 Phone: (714) 505-3475 www.nrclc.com
NR Computer Learning Center
Microsoft Technology Associate (MTA)
MTA 98-364: Database Administration Fundamentals
The 5 days hands-on training provides the required knowledge and skills to manage and administer Microsoft SQL
Server database. Students will learn to create a database, create an account, assign permission, create tables,
relationships, views, triggers, stored procedures, functions, managing data using SQL and understand backup &
recovery.
Audience: This is an excellent course for students planning to major in Computer Science, learn to develop an
application in C#, starting a career in Database Administration or preparing for MTA 98-364 Certification exam. The
MTA Certification exam 98-364 validates the fundamental knowledge needed to begin building a career as Database
Administrator.
Day 3: Introduction to SQL
• Data Definition Language
• Data Manipulation Language
• Data Definition Language
• SQL queries
• Selecting, inserting, updating or
deleting data
• Using Joins, Union and intersect
Day 4: Introduction to T-SQL
• Writing Store Procedures
• Writing User Defined Functions
Creating and Invoking triggers
• Using functions
• Using formula and function
Day 5: Database Security
• Database security
• Identifying objects that can be
secured
• Setting accounts and roles
Database backup and restore
Topics:
Day1: Introduction to Database
• Core database concepts
• Tables. Fields, records
• Using forms
• Using Reports
• Relational database concept
• Starting SQL Server
• Creating a database
• Creating account
• Setting permission
Day 2: Database Design
• Creating Tables, Index & Views
• Keys: Primary, foreign and
composite
• Data Normalization
• Relationship between foreign and
primary keys
• Views and Indexes
• E-R Diagram
To register, visit www.nrclc.com or
call 714-505-3475
Prerequisites: Basic
computer skills.
Upon successful completion of training, the student will be familiar with relational database concepts, security
requirements for databases and the data storage, database objects, such as tables and views, SQL and T-SQL scripts,
writing database queries, stored procedures.

MTA 98 364 - database fundamentals

Recommended

Recommended

More Related Content

Similar to MTA 98 364 - database fundamentals

Similar to MTA 98 364 - database fundamentals (20)

More from NR Computer Learning Center

More from NR Computer Learning Center (20)

Recently uploaded

Recently uploaded (20)

MTA 98 364 - database fundamentals