MTA Database Certification Prep Training

Benefits of Microsoft Technology
Associate (MTA) Certificate
 Standout from the crowd
 Explore the field of Software
Development
 Prove your skillset & build confidence
 Improve your chances for a Job
 Convert your ideas to application
 Become a programmer
 Develop your own app
 Build your portfolio
 Our Instructor are certified professionals
 We help student develop programming
and logical thinking skills
 We provide all the material required for
the training
 Every student participates, learns and
has fun
For more information about our Tech Camp,
contact NRCLC at (714) 505-3475 or visit our
website at www.facebook.com/nrclc
www.twitter.com/nrclc
www.nrclc.com/blog
Database Administration
Fundamentals
(714) 505-3475
www.nrclc.com
1835 W. Orangewood Ave.
Suite 200, Orange, CA 92868

Microsoft Technology Associate
Introduction to Database Design
The hands-on course will help students
learn to design and manage databases and
understand the Data Definition
Language, Data Manipulation Language
and Data Definition Language. Database
design courses will include
understanding various data types, Tables,
Views, Store Procedures, Trigger,
indexes, Data reliability and integrity.
Students will learn to design and develop
database as part of the project.
Prerequisite: Knowledge of computer
basic or equivalent.
Technology: Microsoft SQL Server
2008/2010
Introduction to SQL & T-SQL
The hands-on course will help the student
learn to write from simple to complex
SQL queries. SQL is used to query the
database to manage data through the
application, to analysis data, and to
generate business reports. Students will
learn to use SQL and T-SQL
programming language to add, delete,
update, edit, use formula and function
and sort and search data in the database.
Students will use SQL language as part
the project.
Prerequisite: Introduction to Database
Design.
2008/2010
MTA 98-364: Database Administration
Fundamentals Test Prep
The hands-on course will help students to
gain the fundamental knowledge and
skills required to manage and administer
Microsoft SQL Server database. Students
will practice creating databases,
managing data with SQL, apply database
concepts, create view, stored procedure,
triggers, account, assign permission and
understand backup & recovery. Students
will work with the database as part the
project.
Prerequisite: Introduction to SQL or
equivalent.
2008/2010
MTA 98-364: Database Administration Fundamentals
This MTA Training course helps students prepare for MTA Exam 98-364. Candidates for this course are in the process of expanding their
knowledge and skills in the following areas: relational database concepts, security requirements for databases and the data stored in them,
database objects, such as tables and views, graphical tools and T-SQL scripts, database queries, stored procedures.
Introduction
to Database
Design
Introduction
to SQL & T-
SQL
Database
Administration
Fundamental
Test Prep
Take
MTA 98-361
Exam

MTA Database Certification Prep Training

Recommended

Recommended

More Related Content

What's hot

What's hot (19)

Similar to MTA Database Certification Prep Training

Similar to MTA Database Certification Prep Training (20)

More from NR Computer Learning Center

More from NR Computer Learning Center (20)

Recently uploaded

Recently uploaded (20)

MTA Database Certification Prep Training