Course Name:Database Administration Fundamentals-Microsoft SQL Server 2012
Refer to Exam: Database Fundamentals (98-364)-MTA
Class Duration: 2hrs a day, Twice a week
Course Duration: 16 hrs

Course Outline:

• 1- Different Types of Databases
• 2- Relational Database Concepts
• 3- Database Data Types
• 4- The SQL Language
• 5- Introducing the SQL Server Management Studio (SSMS)
• 6- Creating and Using Tables
• 7- Creating and Using Views
• 8- Creating Stored Procedures
• 9- Basic Queries
• 10- Complex Conditions
• 11- Multi-Table Queries
• 12- Modifying Data
• 13- Database Normalization
• 14- Keys and Contraints
• 15- Indexes
• 16- Security
• 17- Backup and Recovery
• 18- Continual Maintenance
• 19- Preparing for Your Database Administration Fundamentals (98-364) Certification Exam