MTA 98 364 - database fundamentals
2 likes876 views
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.
MTA 98 364 - database fundamentals
- 1. 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.