Vi ste ovdje
Overview/Description
Skillsoft Mentors are available to help students with their studies for exam 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance*. You can reach them by entering a Mentored Chat Room or by using the Email My Mentor service.* This asset has been updated for SQL Server 2008 R2.
Target Audience
Individuals who are studying the associated Skillsoft content in preparation for, or to become familiar with, the skills and competencies being measured by the actual certification exam.
Prerequisites
Familiarity with the exam objectives listed below and skills and...
Overview/Description
Enterprises use databases to store their most critical data. To protect and ensure the data's availability, database administrators need to establish a solid backup and restoration plan. Such plans are used to protect data in the event of a disaster by allowing complete sets of duplicate data to be restored in a timely fashion. There are multiple types of backups that can be taken to ensure the recovery of data, including a full recovery or a point-in-time recovery. SQL Server 2008 R2 also offers database snapshots, which can be used to revert a database to a specific...
Overview/Description
SQL Server 2008 R2 provides table and index partitioning to allow data to be stored across multiple filegroups within a database. This makes tables and indexes that contain large amounts of data more manageable. Partitions in the database may need to be split to allow for more data to be stored, or data from one partition may need to be moved to another partition. SQL Server 2008 R2 provides Transact-SQL statements to ensure that administrators can perform these tasks to manage the table partitions. SQL Server also provides data compression at the table row and page level...
Overview/Description
Database maintenance is an ongoing task for SQL Server 2008 R2 administrators. This requires the integrity of the database to be checked, the database size to be kept to a minimum by ensuring the files are the correct sizes, and maintenance tasks to be run regularly. SQL Server 2008 R2 Transact-SQL provides DBCC statements, which in turn provides statements to maintain the database and database files. An administrator can also use maintenance plans to run a series of tasks on specific databases using a schedule or on demand. This course demonstrates how to confirm the...
Overview/Description
To keep SQL Server 2008 R2 databases running as efficiently as possible, administrators use a variety of performance tuning and monitoring tools. The SQL Server Profiler enables administrators to use trace files and logs to analyze a database's performance. They can also use the Windows System Monitor to monitor SQL Server 2008 R2 using counters, which monitor specific aspects of the server for performance issues. SQL Server 2008 R2 includes the Activity Monitor, which provides an overview of the system's performance in real-time. And the Database Engine Tuning Advisor...
Overview/Description
SQL Server 2008 R2 provides several key features that improve the availability of servers and databases so that downtime for users is minimized. These solutions include database mirroring, log shipping, replication, and failover clusters. These reliability features help administrators maintain multiple sets of data that help ensure that critical systems remain accessible, and can be fully recovered in the event of a disaster. This course addresses how to configure database mirroring, log shipping, replication, and failover clusters to ensure that SQL Server 2008 R2...
Overview/Description
SQL Server 2008 R2 is a comprehensive database platform, consisting of components and management tools such as SQL Server Management Studio, Business Intelligence Development studio, and the SQL Server Database Engine. These tools allow administrators and developers to build and maintain software solutions, and perform required functions in a server environment. This course identifies SQL Server 2008 R2 components and management tools, and outlines the requirements for installing SQL Server 2008 R2. The steps required to complete a fresh installation of a SQL Server 2008...
Overview/Description
SQL Server 2008 R2's core component is its Database Engine, which provides storage, processing, and security for enterprise data through its controlled access and rapid transaction processing. Another feature of SQL Server 2008 R2 is the SQL Server Management Studio graphical user tool which allows administrators and developers to create and configure instances and databases on an enterprise level. SQL Server 2008 R2 also includes the SQL Server Configuration Manager for managing SQL Server services, SQL Server network configuration, and SQL Native Client. This course...
Overview/Description
Microsoft SQL Server 2008 R2 provides enhanced security features to ensure that each instance is secure. Using SQL Server 2008 R2 security features, administrators can guarantee that access to a SQL Server instance is granted only to specified users, using either Windows Authentication or Mixed Mode Authentication by creating logins and then mapping the logins to the databases within the instance. Administrators also have the ability to encrypt a SQL Server instance using transparent data encryption (TDE) and to encrypt the data within a database using encryption...
Overview/Description
To test your knowledge on the skills and competencies being measured by the vendor certification exam*. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.* This TestPrep has been updated for SQL Server 2008 R2.
Target Audience
Individuals...
- 1 od 2
- ››
Koraci do učenja
Prijavite se, a ako nemate korisničko ime, registrirajte se.
Pronađite edukacijske programe u Katalogu i Certifikaciji, ili koristite polje za pretragu.
Upisani programi dostupni su u meniju Korisnik, Moji tečajevi.
Trebate pomoć?
- Česta pitanja - FAQ
- telefon: +385 1 6558 440
- email: support@cognita.hr
- Kontakt forma
