SQL Server 2008 Data Management
This course is included in our On-demand training solution.
SQL Server 2008 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 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. Indexes can be created to allow for the quick retrieval of data from database tables. Administrators need to monitor and manage these indexes to ensure that they are being used efficiently. Importing and exporting data provides a way for database administrators to move data between tables, databases, and servers. This course demonstrates how to manage table partitions, configure data compression, as well as create and manage indexes in a database. It also shows how to import data using the BULK INSERT and OPENROWSET (BULK…) statements and how to import or export data using the bcp utility and the Import and Export Wizard. This course is one of a series in the SkillSoft learning path that covers the objectives for Microsoft SQL Server 2008 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance certification.
Professionals typically pursuing a career as a Database Administrator; individuals who don’t work directly with SQL Server as part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators.
One to two years of experience using SQL Server 2008 or two to three years of experience using a previous version of SQL Server
Managing Table Partitions in SQL Server 2008
SQL Server 2008 Data Compression in a Database
Introduction to Indexes in SQL Server 2008
Index Creation in SQL Server 2008
Managing Indexes in SQL Server 2008
Transferring Bulk Data in SQL Server 2008
Importing and Exporting Data in SQL Server 2008
Managing Tables, Indexes, and Data in SQL Server 2008