Microsoft SQL Server 2005 Certification Course

Microsoft SQL Server 2005 Certification Course
 
  • Price: US$ 249.00
  • Publisher: Element K
  • Number of modules: 9
  • Length: 18 hours
  • Language: English
  • Subscription: 12 months
whats-included

Do you Work with Microsoft SQL Server 2005?  Get this Certification to Advance Your DBA Career

Get ready for Microsoft exam 70-431 with Official Microsoft Learning Products published by ElementK.

Course includes 9 virtual labs:

1. Getting Started with Databases and Transact-SQL

2. Grouping and Summarizing Data

3. Joining Data from Multiple Tables

4. Modifying Data in Tables

5. Performing Basic Queries

6. Querying Metadata, XML, and Full-Text Indexes

7. Using Advanced Querying Techniques

8. Using Programming Objects for Data Retrieval in Microsoft SQL Server 2005

9. Working with Subqueries

 

Microsoft SQL Server 2005 Certification Course Details

Module Name Description
Getting Started with Databases and Transact-SQL in Microsoft SQL Server 2005 (4326) MSR Analyze how client/server architecture works, and examine the various database and business tasks that can be performed by using the components of Microsoft SQL Server 2005. Query SQL Server 2005 databases by using T-SQL querying tools. In addition, this course explains the basics of the T-SQL language, its syntax, and how to manage T-SQL scripts. 
Grouping and Summarizing Data in Microsoft SQL Server 2005 (4328) MSR Group and summarize data when generating reports in Microsoft SQL Server 2005. Rank group data and create cross-tabulation queries. Use aggregate functions including functions native to SQL Server, functions that use NULL values, and custom aggregate functions using the .NET Framework. In addition, this course covers the GROUP BY, HAVING, COMPUTE, PIVOT, UNPIVOT, ROLLUP, and CUBE clauses and functions such as SUM, AVG, COUNT, MAX, MIN, GROUPING, RANK, DENSE_RANK, NTILE, and ROW_NUMBER.
Joining Data from Multiple Tables in Microsoft SQL Server 2005 (4329) MSR Retrieve data from multiple tables by using Transact-SQL (T-SQL) in Microsoft SQL Server 2005. Apply the inner join, outer join, cross join, and self join to retrieve the desired result set. Also use the APPLY operator to join using a user-defined function. Then examine the various techniques provided by SQL Server 2005 to combine and limit result sets such as UNION, EXCEPT, INTERCEPT, TOP, and TABLESAMPLE.
Modifying Data in Microsoft SQL Server 2005 (4331) MSR Modify data in tables using Transact-SQL (T-SQL) in Microsoft SQL Server 2005. You insert, delete, and update single or multiple rows of data in the tables. Use statements such as INSERT, DELETE, UPDATE, INSERT SELECT, SELECT INTO, and TRUNCATE TABLE statements. Then examine implicit and explicit transactions, the importance of transaction isolation levels, and how to manage transactions.
Performing Basic Queries in Microsoft SQL Server 2005 (4327) MSR Perform basic queries in Microsoft SQL Server 2005. Use Transact-SQL (T-SQL) statements such as SELECT to write queries, filter data, and format result sets. In addition, this course covers the performance considerations that affect data retrieval and the use of the Query Optimizer.
Querying Metadata, XML, and Full-Text Indexes in Microsoft SQL Server 2005 (4332) MSR  Query metadata, XML data, and full-text indexes by using Transact-SQL (T-SQL) in Microsoft SQL Server 2005. Query metadata by using SQL Server views and commands. Query XML data by using OpenXML and XQuery. Query relational data combined with XML data. In addition, analyze the purpose and process of querying full-text indexes.
Using Advanced Querying Techniques in Microsoft SQL Server 2005 (4334) MSR Apply advanced querying techniques in Microsoft SQL Server 2005. Follow best practices to query complex data involving data/time and multinational data. Query complex table structures such as data stored in hierarchies and self-referencing tables. Also analyze query execution and optimize query performance. Then use Microsoft Visual SourceSafe for managing query source files.
Using Programming Objects for Data Retrieval in Microsoft SQL Server 2005 (4333) MSR Retrieve data by using the various programming objects provided by Microsoft SQL Server 2005. Encapsulate expressions with user-defined functions and SQL Server views. Utilize stored procedures, and triggers to encapsulate T-SQL logic. Then perform distributed queries and learn how SQL Server works with heterogeneous data such as databases, spreadsheets, and other servers.  
Working with Subqueries in Microsoft SQL Server 2005 (4330) MSR Write subqueries and correlated subqueries by using Transact-SQL (T-SQL) in Microsoft SQL Server 2005. Determine the best option among subqueries, joins, and temporary tables to get desired result. Refine subqueries by using the ANY, ALL, and SOME operators. In addition, this course explains common table expressions (CTEs) to write recursive queries.