-Module 1 “Overview of SQL Server 2005/2008” introduces SQL Server 2005/2008. It defines some of the important characteristics of SQL Server 2005/2008and explains the environments in which it is designed to work. You will be introduced to the different parts of the product and given some idea as to the role played by these parts.
-Module 2 “Installing SQL Server 2005/2008” explains how to install SQL Server 2005/2008. It lists the hardware and software requirements of the program, and it explains the specific information you have to supply and the decisions you have to make during the installation process. This Module covers using default, named, and multiple instances of SQL Server 2005/2008.
-Module 3 “Preparing to Use SQL Server 2005/2008” reviews the results of installing SQL Server 2005/2008. This Module explains starting, stopping, and pausing SQL Server services. The Module also covers working with OSQL, SQL Query Analyzer, and SQL Server Enterprise Manager.
- Module 4 “Upgrading to SQL Server 2005/2008” shows you how to perform a version upgrade of a complete SQL Server 6.5 or 7.0 installation to SQL Server 2005/2008. This Module also explains how to perform an online database upgrade from SQL Server 7.0.
-Module 5 “Understanding System and User Databases” explains SQL Server 2005/2008databases. This includes the structure of a data file and the architecture of the transaction log. This Module concludes with a discussion about system tables, including the querying of system and database catalogs.
- Module 6 “Creating and Configuring User Databases” teaches how to create a new user database, set database options for new or existing databases, and manage the size of data and transaction log files. This Module concludes with a discussion about placing database files on multiple disks for recovery, fault tolerance, and performance.
- Module 7 “Populating a Database” discusses the population of user databases with existing data. It shows you how to transfer and transform data. This Module focuses on the use of DTS, Bcp, and the BULK INSERT Transact-SQL statement.
- Module 8 “Developing a Data Restoration Strategy” presents an overview of the SQL Server 2005/2008backup and restore processes and discusses the issues that you should consider when planning a backup and restore strategy for a SQL Server 2005/2008installation.
- Module 9 “Backing Up and Restoring SQL Server” teaches you how to perform database backups using disk and tape. It also teaches you how to perform database restorations. This Module explains how to use SQL Server Enterprise Manager and Transact-SQL statements.
- Module 10 “Managing Access to SQL Server 2005/2008” discusses controlling access to SQL Server 2005/2008, including the authentication process and the authorization process. The Module concludes by showing you how to create and manage logins.
- Module 11 “Managing SQL Server Permissions” shows how to grant data-base-specific permissions. It also discusses the use of application roles. The Module concludes by teaching you how to design an access and permissions strategy.
- Module 12 “Performing Administrative Tasks” teach you how to perform a variety of configuration tasks and setup tasks. These include the configuration of the SQL Server service, the SQL Server Agent service, SQL Mail, SQLAgentMail, and XML. The Module concludes with a discussion of the performance of periodic maintenance tasks.
- Module 13 “Automating Administrative Tasks” shows you how to automate routine tasks using operators, jobs, and alerts. It also teaches the creation of a database maintenance plan. It concludes by teaching you to create multiserver jobs.
- Module 14 “Monitoring SQL Server Performance and Activity” discusses the development of a performance monitoring methodology. This Module introduces each of the monitoring tools and shows you how to use each tool. The Module concludes by teaching you how to perform specific monitoring tasks, such as for memory use or slow-performing queries.
- Module 15 “SQL Server Reporting Services (SSRS) & SQL Server Analysis Services (SSAS)
SSRS: A complete set of tools that you can use to create, manage, and view reports.
SSAS: Advanced data analysis and interactive reporting &could find many uses for the predictive power of data mining.
- Module 16 “Maintaining High Availability” discusses the use of standby servers, including the use of log shipping to automate the process of maintaining a standby server.