DB-203 : MS SQL Server 2008/2012 Database Administration
- 24Training hours
- 8Lectures
- 600Egyptian pounds
- 10Students maximum
- Understand how the MS SQL Server database management system works
- Administer a Microsoft SQL Server 2008/2012 database system
What the training programme covers
- SQL Server Functional Concepts and Architecture
- SQL Server Physical Concepts and Architecture
- Planning a SQL Server 2012 Installation
- Installing and Configuring SQL Server
- Creating and Using a Database
- Migrating, Consolidating, and Upgrading
- High Availability Overview
- Backing up SQL Server
- Restoring SQL Server
- Database Mirroring and Clustering
- Monitoring SQL Server
- Managing the SQL Server Agent Service
- Managing SQL Server Agent Jobs
- Administering SQL Server Agent Alerts
- Implementing Policy-Based Management
- Managing SQL Server Security
- Administering SQL Server Disaster Recovery
- Distributing Data with SQL Server Integration Services
- Linked Servers and Replication
- Implementing Data Partitions
- Managing SQL Server
- Monitoring and Troubleshooting SQL Server
- Optimizing SQL Server Performance
Who this course is for
- Anyone interested in moving into database administration.
Job title
Once you finish this course you can work as an MS SQL Server database administrator
Meet the instructors on this course
Chief Executive Officer and database developer
Waleed started out in computer science and programming at around the age of eleven, on the old Q-Basic language, and has worked with a long list of technologies across programming, databases and computer systems in general ever since. He is now chief executive of the software house Code-Times, Ltd, specialising in systems analysis, MS SQL Server database development, and building large-scale applications on MS .NET for both the web and Windows. Alongside that, Waleed runs the training departments at 7dash and designs and delivers a range of specialist computer-science programmes on a model of his own: training material as close as possible to the day-to-day reality of a working software company, rather than an academic syllabus with no regard for how the content is actually applied.
A message for the trainer? Send it from here.A message for the trainer? Send it from here.
The questions we are asked most about this training programme
- Does this course prepare me for any of Microsoft's specialist certifications?
- Yes, this course prepares you for the MSCTS certification in database administration.
What else comes with this course
-
Sit the course again, free of charge -
Drinks cafeteria -
A comfortable place to study
Reserve your seat on this course
Enter your details now and we will call you to fix a date and take you through the booking.
Have a question ?
We are glad to help you get a better grasp of things, so do not hesitate to contact us if you have any questions at all.