Database developers design and implement relational database models (logical and physical) and database storage objects. They also program servers by using user-defined functions, triggers, stored procedures, Transact-SQL, or the CLR. They retrieve or modify data using SQL queries or tune and optimize queries
Intended Audience
- IT Professionals, IT generalists, and help desk professionals who want to learn about SQL Server 2008 are the audience for this course.
- This Certification provides students with product knowledge and skills needed to maintain a Microsoft SQL Server 2008 database. It is intended for IT Professionals wanting to become skilled on SQL Server 2008 product features and technologies for maintaining a database.
- It also provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. It is intended for IT Professionals who want to become skilled on SQL Server 2008 product features and technologies for designing a database.
Learning Goals:
- Installing and configuring SQL Server 2008
- Data storage management
- Indexing, Distributing and Partitioning Data
- Data Modeling
- Implementing the Physical Database
- Data Integrity
- Retrieving and Modifying Data
- Data Import / Export
- SQL Server Job scheduling
- Programming Business Logic- Triggers,Views ,Store Procedure- Function
- Query Optimizer
- Performance Monitoring
- SQL Server Security management
- SQL Server Backup & Recovery
- SQL Server database Replication, Mirroring, and Transactional Log Shipping.
Prerequisite: Architects and developers already familiar with SQL Server, and also developers who are just getting started with SQL Server and want to learn the basics.
Duration: 8 Weeks ( Saturday and Sunday)
Course Reviews
