Imate žicu za učenje?

SQL Server 2008 R2: Creating and Altering Partitions

Overview/Description SQL Server 2008 R2 offers the use of partitions to manage subsets of data for large tables and indexes. Partitions can be used to improve the read/write performance on tables within a database by allowing the data within tables to be spread across multiple filegroups, whereas standard tables must be contained within a single filegroup. Data that is stored within partitions is treated as a logical entity, and the partitioned tables and indexes support the same properties as a standard table. SQL Server 2008 R2 allows views to be partitioned, which joins data from multiple...

SQL Server 2008 R2: Creating and Implementing Database Objects

Overview/Description SQL Server 2008 R2 is a robust database system that provides a number of database objects used to store and view data. In order to configure a SQL Server 2008 R2 database to meet business requirements, administrators and developers must fully understand how to design, create, and configure these database objects. These objects include tables for storing data in the database, views to allow access to the data within specific tables, and indexes to optimize the performance of the database for data retrieval. This course identifies each of these database objects and...

SQL Server 2008 R2: Gathering Performance Data

Overview/Description In order to keep SQL Server 2008 R2 running as efficiently as possible, SQL Server 2008 R2 provides a variety of performance tuning and optimization utilities. Among these utilities are the SQL Server Profiler and the Database Engine Tuning Advisor. The SQL Server Profiler allows you to use trace files and logs to analyze your database’s performance. The Database Engine Tuning Advisor allows you to analyze a database’s workload and effectively configure the physical design structure of databases based on your analysis. SQL Server 2008 R2 offers the ability to view the...

SQL Server 2008 R2: Implementing Programming Objects

Overview/Description In SQL Server 2008 R2 you can use Transact-SQL statements to access data in the databases. Transact-SQL statements can be grouped together in a number of ways to create more complex queries when one Transact-SQL statement will not retrieve the desired results. You can group Transact-SQL statements by creating programming objects within a database. These programming objects include stored procedures, functions, and triggers (based on either DML or DDL statements). SQL Server 2008 R2 provides integration with Common-runtime language (CLR). This enables a developer to create...

SQL Server 2008 R2: Messaging, Full-Text Search, Scripts, and Track Changes

Overview/Description SQL Server 2008 R2 provides many components to ensure that database developers can perform many tasks within the database without having to create custom applications. SQL Server's Service Broker component allows developers to create applications that can work with other SQL Server components to complete a specific task by communicating using messages to relay the task information within the instance or between instances of SQL Server 2008 R2. SQL Server 2008 R2 also offers a way for developers to track changes within the database using either change tracking or change...

SQL Server 2008 R2: Performing Advanced Query Techniques

Overview/Description Transact-SQL offers advanced query techniques, such as built-in aggregate, scalar, and ranking functions, and common table expressions to manipulate the result set for a query. To manipulate the result sets and generate rollup information, such as totals, the CUBE, GROUPING SETS, and ROLLUP operators can be used with the GROUP BY statement. UNION, INTERSECT, and EXCEPT can be used to gather specific results in a query. Transact-SQL also provides features that manage international concerns with regards to stored data, such as the collation and sort order. This course...

SQL Server 2008 R2: Querying and Managing XML Data

Overview/Description XML has been integrated into SQL Server 2008 R2 so that XML data can be stored within databases using the XML data type. You can query this data using the XQuery language within the XML data type methods. SQL Server 2008 R2 also provides support for using FOR XML to extract relational data from a database in XML format and the use of OPENXML to generate relational views from XML. This course demonstrates how to use the xml data type, XML schema collations, and how to create XML indexes. It also explores how to retrieve data using FOR XML, process XML data using OPENXML,...

SQL Server 2008 R2: Running Queries and Manipulating Data

Overview/Description SQL Server 2008 R2 includes the SQL Server Management Studio which allows access to SQL Server databases and enables you to access database data. This data can be retrieved and modified through the use of Transact-SQL within the Query Edit window of the Management Studio tool. Using Transact-SQL you can select data from a database’s tables and filter the results to include only the data that you require. Transact-SQL statements also allow you to update, change, and remove data from tables. This course identifies the basic T-SQL statements that can be used to retrieve...

Koraci do učenja

1Prijavi se

Prijavite se, a ako nemate korisničko ime, registrirajte se.

2Pronađi i upiši program

Pronađite edukacijske programe u Katalogu i Certifikaciji, ili koristite polje za pretragu.

3Uči

Upisani programi dostupni su u meniju Korisnik, Moji tečajevi.

»Detaljne upute

Trebate pomoć?