Microsoft Training - April-September 2009 - (Page 43) SQL Server T-SQL with Advanced Topics Learn how to build queries using T-SQL. Course 6136 Exclusive Course Global Knowledge exclusive curriculum In this course, you’ll start by learning about the basic features available in SQL Server, including how to design and create a database and how to build queries using Transact-SQL, the language of SQL Server. Then, you’ll learn to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. Explore the new enhancements to the Transact-SQL programming language, including improved support for error handling and hierarchical queries and how programmers can now use .NET languages like C# and Visual Basic to build database objects. You will also examine enhancements made to SQL Server for handling complex data structures, using partitioning, and working with XML. Hands-On Labs Lab 2: Designing and Creating a Database Lab 3: Data Selection Queries Lab 4: Modifying Data Lab 5: Working with SQL Server Management Studio Lab 6: Transact-SQL Programming Lab 7: Transactions and Error Handling Lab 8: Creating Views Lab 9: Creating Stored Procedures and Triggers Lab 10: Creating User-Defined Functions Lab 11: Using .NET Code in SQL Server 2005 Lab 12: Advanced Query Techniques Lab 13: Implementing SQL Server Partitions Lab 14: Complex Querying Lab 15: Advanced Techniques Lab 16: Working with XML Course Content What You’ll Learn in Class • asic database design principles and how to implement them in SQL B Server • undamentals of writing Transact-SQL queries that retrieve or modify F data • ifferences between view, stored procedures, triggers, and user-defined D functions • se the new Common Table Expressions for creating hierarchical U queries • erform calculations with Visual Basic and Visual C# code rather than P T-SQL • Discover partitioning with SQL Server • xamine new RANKing functions, Common Table Expressions, and E learn techniques for dealing with complex queries • Explore advanced techniques for working with complex data • Discover new XML capabilities in SQL Server 2005 1. A Tour of SQL Server 2005 • SQL Server 2005 Editions, Components, and Tools • Using SQL Server Management Studio (SSMS) • Working with Tables and Queries • New Transact-SQL Features • Business Intelligence Services 2. Designing and Creating a Database • Relational Database Design Principles • Implementing the Design 3. Data Selection Queries • Understanding Transact-SQL • The SELECT Statement • The WHERE Clause • Using ORDER BY to Sort Data • The GROUP BY Clause • Joining Tables 4. Modifying Data • Inserting, Updating, and Deleting Data • Understanding Transaction Isolation 5. Working with SQL Server Management Studio • Getting Started with SSMS • Exploring the Object Explorer • Working with the Query Editor • Using SQL Server Books Online 6. Transact-SQL Programming • Overview of Transact-SQL • Using Built-In Functions • Controlling Flow • Ranking Results 7. Transactions and Error Handling • Transaction Concepts • Applications and Transactions • Creating Explicit Transactions • Using TRY/CATCH Error Handling 8. Creating Views • What Is a View? • Creating Views • Updating Data Using a View • Using Computed Columns • Indexed Views • Partitioned Views 9. Creating Stored Procedures and Triggers • Creating Stored Procedures and Triggers 10. Creating User-Defined Functions • User-Defined Function Overview • Scalar Functions • Inline Table-Valued Functions • Multi-Statement Table-Valued Functions • Using Functions, Views, and Stored Procedures 11. Using .NET Code in SQL Server 2005 • Writing SQLCLR Code • SQLCLR Code Modules • Managing Code Modules • SQLCLR Security • T-SQL vs. .NET Code 12. Advanced Query Techniques • Full-Text Search • Using APPLY • Generating XML with FOR XML • Creating Recursive and Pivot Queries • Executing Dynamic SQL 13. Implementing SQL Server Partitions • Overview of Table-Based Partitioning • Creating Partitioned Tables • Querying and Managing Partitions 14. Complex Querying • Working with NULL Values • Ranking Grouped Data • Writing Correlated Subqueries • Using Common Table Expressions 15. Advanced Techniques • Complex Data and Structures • Writing More Efficient Queries • Working with Complex Queries • Maintaining Query Files 16. Working with XML • The XML Data Type • XML Schema Collections • Querying XML • Best Practices Who Needs To Attend Database administrators, developers, Business Intelligence Administrators and Analysts and report writers for SQL server, as well as other relational database professionals, developers, business analysts, report writers, and ETL professionals. Prerequisites Working experience with SQL Server 2000 or 2005; basic relational database concepts (e.g., tables, queries, and indexing); general knowledge of XML, Transact-SQL, and a fundamental understanding of networking and security concepts. Certification MCITP: Database Administrator Purchase online and get a Rewards Card to use on anything you want! www.globalknowledge.com/coolstuff Classroom Learning 4 days $2,595 Classroom Learning CA San Jose DC Washington DC Washington Jun 9-12 May 5-8 Aug 4-7 GA IL IL NC Atlanta Chicago Chicago Raleigh Virtual Classroom e-Learning 4, 8-hour sessions, $2,095 Jun 16-19 Apr 28-May 1 Sep 1-4 Apr 14-17 NJ NY TX TX Morristown New York Dallas Dallas On-Site Learning Call for info. Jul 21-24 Jun 16-19 May 19-22 Sep 15-18 Virtual Classroom e-Learning Apr 14-17 Aug 25-28 Jun 29-Jul 2 REGISTER NOW 1-800-COURSES www.globalknowledge.com/microsoft 43 http://www.globalknowledge.com/coolstuff http://www.globalknowledge.com/training/olm/go.asp?find=MIC6136&country=United+States http://www.globalknowledge.com/microsoft
For optimal viewing of this digital publication, please enable JavaScript and then refresh the page. If you would like to try to load the digital publication without using Flash Player detection, please click here.