Database Administration using SQL Server

Course Overview:

• List the features of SQL Server 2008
• Describe the SQL Server database architecture
• Discuss SQL Server Security
• Install SQL Server 2008
• Configure network libraries
• Alter databases
• Attach and detach databases
• Create and manage database objects like tables, constraints, indexes, stored procedures, triggers and views.
• Manage Users, Groups, Roles, and Logins
• Use the Database Maintenance Plan Wizard
• Use DBCC for Integrity Checks

Course Contents:

• List the features of SQL Server 2008
• Identify the operating systems that support SQL Server 2008
• Describe the SQL Server database architecture
• List database objects
• Discuss SQL Server Security
• Install SQL Server 2008
• Upgrade to SQL Server 2008
• Perform a custom upgrade
• Configure network libraries
• Create physical files for SQL Server databases
• Create file groups
• Create databases and databases files
• Alter databases
• Manage database by expanding and shrinking
• Attach and detach databases
• Create and manage database objects like tables, constraints, indexes, stored procedures, triggers and views.
• Alter database objects.
• Design optimization of SQL Server Applications - Indexing, Locking, Recompiling, Optimizing Databases
• Troubleshoot Transaction locking using SQL Profiler, Enterprise Manager, or Transact-SQL
• Use the System Monitor to optimize hardware resources
• Use Trace and System Monitor - Cache Hits, Connections, Locks, Memory Allocation, Recompilation and Transactional Throughput
• Set up IIS virtual directories to support XML
• Import and export data. Methods include the Bulk Insert task, the bulk copy program, Data Transformation Services (DTS), and heterogeneous queries
• Develop and manage DTS packages
• Create and Manage linked servers
• Convert data types
• Explain Replication and the different types of replication
• Configure, maintain, and troubleshoot replication services
• Configure Security Modes
• Manage Users, Groups, Roles, and Logins
• Grant,deny, or revoke permissions
• Configure Security Mapping for Linked Servers
• Perform security auditing using SQL Profiler
• Use Views and Stored Procedures to enhance security
• Describe SQL Server Agent
• Explain creating and managing Jobs and Alerts
• Describe SQL Mail and SQL Agentmail Explain disaster recovery
• Plan and execute backups -
• Recover the system state and restore data
• Describe Log Shipping
• Use the Database Maintenance Plan Wizard

Benefits of the Course:

Ministry Approved Certificate