Microsoft Training - April-September 2009 - (Page 40) SQL Server 2005 for Developers Leverage the power of SQL Server 2005 for database and application development. Course 6063 Enhanced Course OMLP-based & Global Knowledge enhanced Redeem your SATVs on this course at www.globalknowledge.com/satv. Lab 1: Creating Databases and Database Files • Creating a Database • Creating Schemas • Creating a Database Snapshot Lab 2: Creating Data Types and Tables • Creating Data Types • Creating Tables • Creating Partitioned Tables Lab 3: Using Transact-SQL and XML • Writing Select Statements and Use Select Operators • Writing Table Joins, Views, and Sub-queries • Creating Views with Aggregate Functions and Group By • Writing Insert, Update, and Delete statements • Using Compute, Compute By, Cube and Rollup • Using Pivot and Unpivot operations • Utilizing Recursive Capabilities (CTEs) • Mapping Relational Data and XML • Storing XML Natively in the Database • Using XQuery with XML Methods • Creating native XML Web Services Lab 4: Creating and Tuning Indexes • Creating Indexes • Defining Clustered, Non-Clustered, and Unique Indexes • Defining Index Creation Fill Factors • Tuning Indexes • Optimizing Indexes • Using Online Index Operations • Utilizing Physical Storage • Creating XML Indexes Lab 5: Implementing Data Integrity by Using Constraints • Creating Constraints • Disabling Constraints Lab 6: Implementing Data Integrity by Using Triggers and XML Schemas • Creating Triggers • Implementing XML Schemas Lab 7: Implementing Views • Creating Views • Creating Indexed Views • Creating Partitioned Views Hands-On Labs Lab 8: Implementing Stored Procedures • Creating Stored Procedures • Working with Execution Plans • Passing Parameters • Returning Parameters • Recompiling Stored Procedures Lab 9: Implementing Functions • Creating Functions • Working with Functions • Controlling Execution Context Lab 10: Implementing Managed Code in the Database • Importing an Assembly • Creating Managed Database Objects • Creating and Testing CLR Database Objects • Creating a Stored Procedure and Loading an Assembly • Comparing T-SQL and Managed Code • Utilizing String Manipulation Comparison • Exploring Data Access Lab 11: Managing Transactions and Locks • Using Transactions • Managing Locks Lab 12: Using Service Broker and ADO.Net (Optional) • Creating Service Broker Objects • Implementing the Initiating Service • Implementing the Target Service • Utilizing ADO.Net 2.0 Lab 13: Using Notification Services (Optional) • Setting up Notification Services Lab 14: Security – Native Data Encryption (Optional) • Using the New Security Model • Creating and Utilizing Schema Objects • Utilizing System Tables as Views • Using Native Data Encryption • Creating Views for Security • Implementing Ownership Chains Course Description Get the knowledge and skills to implement a Microsoft SQL Server 2005 database in this course. Learn to use SQL Server 2005 product features and tools related to implementing a database. Make the most of Microsoft SQL Server 2005’s many new features for Developers to increase flexibility, productivity, scalability, and performance. Examine .Net integration, Native XML Data Type, SQL Service Broker, Native Data Encryption, Notification Services, Web Services, ADO.Net 2.0, SQL Server Management Studio, Business Intelligence Development Studio, and integration with Visual Studio 2005. In this hands-on course, you will explore the new and existing features using the development of example applications as a solution-based training model. Along with our proprietary content, this course incorporates material from the following Official Microsoft Learning Product (OMLP): • Course 2779: Implementing a Microsoft SQL Server 2005 Database What You’ll Learn in Class • • • • • • • • • • • • • • • • • • • Create databases and database files Create data types and tables Use XML-related features in Microsoft SQL Server 2005 Plan, create, and optimize indexes for performance and storage I mplement data integrity in Microsoft SQL Server 2005 by using constraints, triggers, and XML schemas C reate and implement database objects: views, stored procedures, triggers, and functions Implement managed code in the database Manage transactions and locks Use Service Broker to build a messaging-based solution Use Service Broker for asynchronous messaging Use Notification Services to generate and send notifications Use Transact-SQL to query and manipulate data Use Transact-SQL to define and modify database objects Explore Transact-SQL enhancements Compare Transact-SQL and CLR-based stored procedures Utilize .Net Framework hosting with Visual Studio 2005 Utilize ADO.Net 2.0 Develop an XML Web Service in the database tier Enable Native Data Encryption Course Content 1. Creating Databases and Database Files 2. Creating Data Types and Tables 3. Using Transact-SQL and XML 4. Creating and Tuning Indexes 5. Implementing Data Integrity by Using Constraints 6. Implementing Data Integrity by Using Triggers and XML Schemas 7. Implementing Views 8. Implementing Stored Procedures 9. Implementing Functions 10. Implementing Managed Code in the Database 11. Managing Transactions and Locks 12. Using Service Broker and ADO.Net 13. Using Notification Services 14. Security – Native Data Encryption Prerequisites • asic knowledge of the Microsoft Windows operating system and its B core functionality • Basic knowledge of relational databases • Some experience with database design • Familiarity with basic Transact-SQL is helpful Classroom Learning 5 days $2,995 Classroom Learning CA San Francisco Mar 30-Apr 3 CA San Jose Jun 8-12 DC Washington May 4-8 DC Washington Jul 20-24 GA Atlanta May 11-15 GA IL IL NC NJ NJ Atlanta Chicago Chicago Raleigh Morristown Morristown Virtual Classroom e-Learning 5, 8-hour sessions, $2,495 Sep 14-18 Apr 6-10 Jul 6-10 Jun 15-19 May 18-22 Aug 10-14 NY NY ON ON ON ON New York New York Ottawa Ottawa Toronto Toronto On-Site Learning Call for info. Jun 1-5 Aug 24-28 Mar 30-Apr 3 Jul 20-24 Jun 1-5 Aug 24-28 TX Dallas TX Dallas May 4-8 Aug 3-7 Virtual Classroom e-Learning Jun 8-12 Sep 28-Oct 2 Jul 27-31 40 REGISTER NOW 1-800-COURSES www.globalknowledge.com/microsoft http://www.globalknowledge.com/satv http://www.globalknowledge.com/training/olm/go.asp?find=MIC6063&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.