Facebook Twitter Gplus LinkedIn Google Maps E-mail RSS
Home Courses MS SQL Server 2008 DBA

MS SQL Server 2008 DBA

Database administrators install or configure Microsoft SQL Server and manage or  maintain databases or multidimensional databases, user accounts, database  availability, recovery and reporting. They also design or implement security or  server automation and monitor and troubleshoot database activity. As a  database administrator, your specialized training in database maintenance and  optimization puts you in charge of an organization’s important data solutions.  You ensure that database security, availability, and performance satisfy  business requirements. To do this, your expertise must span archival, data distribution, and the design of high-availability solutions.

SQL Server 2008 Database Administrator (70-432, 70-450)

Maintaining a Microsoft SQL 2008 Database (6231A)

  • Installing and Configuring  SQL Server
  • Managing Databases and  Files
  • Disaster Recovery
  • Managing Security
  • Transferring Data
  • Automating Administrative  Tasks
  • Implementing Replication
  • Maintaining High  Availability Monitoring
  • SQL Server Troubleshooting and  Performance Tuning

Implementing Microsoft SQL 2008 Database (6232A)

  • Creating Databases and  Database Files
  • Creating Data Types and  Tables
  • Creating and Tuning  Indexes
  • Implementing Data  Integrity by Using Constraints and Triggers
  • Using XML
  • Implementing Views
  • Implementing Stored  Procedures
  • Implementing Functions
  • Implementing Managed Code  in the Database
  • Managing Transactions and  Locks
  • Using Service Broker

Upgrading your SQL 2000 Database Admin to SQL 2008 Database Admin (6317A)

  • An Introduction to SQL  Server 2008
  • Installing and Upgrading  to SQL Server 2008
  • Storage Enhancements in SQL  Server 2008
  • SQL Server 2008  Administration Enhancements
  • Security Enhancements with  SQL Server 2008
  • SQL Server 2008 Disaster  Recovery
  • High Availability in SQL  Server 2008
  • Replication Enhancements  in SQL Server 2008
  • SQL Server 2008  Policy-Based Management
  • SQL Server 2008 Monitoring  Enhancements
  • SQL Server 2008  Performance

Writing queries using SQL Server Transact-SQL(T-SQL)(2778A)

  • Getting Started with  Databases and Transact-SQL in SQL Server 2008
  • Querying and Filtering  Data
  • Grouping and Summarizing  Data
  • Joining Data from Multiple  Tables
  • Working with Sub queries
  • Modifying Data in Tables
  • Querying Meta data, XML,  and Full-Text Indexes
  • Using Programming Objects  for Data Retrieval
  • Using Advanced Querying  Techniques