Font size:

Description:

This is a bundled training package. It contains training for each of the bundled items below:

Course Price
SQL Server 2008 R2: Running Queries and Manipulating Data $74.95
SQL Server 2008 R2: Performing Advanced Query Techniques $74.95
SQL Server 2008 R2: Implementing Programming Objects $74.95
SQL Server 2008 R2: Querying and Managing XML Data $74.95
SQL Server 2008 R2: Messaging, Full-Text Search, Scripts, and Track Changes $74.95
SQL Server 2008 R2: Gathering Performance Data $74.95

Bundle Price: $219.00
Total Savings: $230.70


SQL Server 2008 R2: Running Queries and Manipulating Data

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 and modify data within SQL Server databases. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database Development. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development certification.
  • recognize how to use SELECT to retrieve data
  • recognize how to use joins to retrieve data
  • recognize how to use INSERT to input data
  • recognize how to use UPDATE to change existing data
  • recognize how to use DELETE to remove data
  • recognize how to use MERGE to perform multiple operations
  • recognize how to use OUTPUT to generate output
  • recognize how to use subqueries
  • retrieve data
  • manipulate data

SQL Server 2008 R2: Performing Advanced Query Techniques

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 demonstrates how to perform advanced query techniques to manipulate data. It also identifies how to work with the COLLATE clause to manage international considerations when working with data. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database Development. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development certification.
  • recognize how to use built-in functions to perform operations on data
  • recognize how to manipulate the result sets of queries
  • recognize how to control execution plans
  • recognize how to store data in multiple languages within a database
  • use advanced queries

SQL Server 2008 R2: Implementing Programming Objects

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 programming objects using any of the Microsoft .NET Framework languages and then deploy them within SQL Server using assemblies. This course demonstrates how to create user-defined functions, DML and DDL triggers, and stored procedures, as well as how to use the control of flow language in transactions and handle any errors that might arise within them using TRY...CATCH, RAISERROR, and @@ERROR. The course also demonstrates how to use CLR integration in SQL Server 2008 by deploying CLR code into SQL Server. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database Development. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development certification.
  • recognize key characteristics of user-defined functions
  • recognize how to create and manage user-defined functions
  • recognize key characteristics of triggers
  • recognize how to create and manage triggers
  • recognize key characteristics of stored procedures
  • recognize how to create stored procedures
  • recognize how transaction control works in SQL Server 2008 R2
  • recognize how concurrency control works
  • recognize how to implement error handling
  • recognize key characteristics of CLR
  • recognize how to create CLR objects
  • create and manage programming objects in SQL Server 2008 R2

SQL Server 2008 R2: Querying and Managing XML Data

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, and how to query data using the XQuery language. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database Development. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development certification.
  • recognize how to implement XML data types and schemas
  • recognize how XPath is used
  • recognize how to query XML data using XQuery
  • recognize how to use FOR XML to construct XML
  • recognize how to use OPENXML
  • recognize how to create an XML index
  • use XML data in SQL Server 2008 R2

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

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 data capture. SQL Server's full-text search component can be implemented to ensure that specific data is returned based on search words and phrases. PowerShell has been integrated into SQL Server and offers cmdlets to perform actions on database objects using methods within SQL Server Management Object (SMO) models, and to run scripts to perform tasks within SQL Server. Developers can also use Database Mail to send messages to mail accounts within a profile. This course demonstrates how to implement Server Broker, change tracking, full-text search, and Database Mail. It also demonstrates how to invoke and use PowerShell to run scripts and perform actions on objects. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database Development. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development certification.
  • recognize how Service Broker is used
  • recognize how to create Service Broker objects
  • recognize how to create an application
  • recognize how to use change data capture in SQL Server 2008 R2
  • recognize how to perform change tracking in SQL Server 2008 R2
  • recognize how to perform a full-text search
  • recognize how to use the full-text predicates and functions
  • recognize how to use PowerShell in SQL Server 2008 R2
  • recognize how to use Database Mail in SQL Server 2008 R2
  • use Service Broker
  • use change tracking
  • use PowerShell
  • set up and use Database Mail

SQL Server 2008 R2: Gathering Performance Data

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 actual or planned execution plan for queries to ensure transactions are executed with the most efficient path possible. Another set of diagnostic tools provided by SQL Server 2008 R2 are the Dynamic Management Views (DMVs), which help you monitor the health of a server and diagnose problems that may be occurring. This course demonstrates how to view execution plans for transactions and how to use SQL Server Profiler to monitor the databases. It also demonstrates how to tune a database using a workload in Database Engine Tuning Advisor tool and how to use DMVs and catalog views to view system metadata. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database Development. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development certification.
  • recognize how to view execution plans in SQL Server 2008 R2
  • recognize how to use SQL Server Profiler
  • recognize how to use the Database Engine Tuning Advisor
  • recognize how to use DMVs
  • recognize how to use catalog views
  • collect performance data in SQL server 2008 R2
Register Now
Microsoft SQL Server 2008 R2: Part 3 e-learning bundle
  • Course ID:
    252798
  • Duration:
    10 hours
  • Price:
    $219