Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Order CD-ROMs   Order Videos 
Microsoft SQL Server 2008 for Developers
with Don Kiely and Frank Tillinghast


View the Course Outline

In this course, you'll learn about the features that are available in SQL Server, how to design and create a database, and how to build basic queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. more...

Course includes 54+ hours of total training time...

  • 16 modules of training
  • Over 18 hours of media run time
  • Over 500 pages of printable courseware
  • Step-by-step hands-on-labs
  • Sample code
Format Modules Retail Price
SQL Server 2008 for Developers
CD-ROM

 16 CD-ROMs

$995.00  
CD-ROM & Books

 16 CD-ROMs + Printed Books

$1,187.00  
DVD-ROM

 2 DVD-ROMs

$995.00  
DVD-ROM & Books

  2 DVD-ROMs + Printed Books

$1,187.00  
Read about Don Kiely and Frank Tillinghast. .
Course Outline (Outlines are subject to change.)
Microsoft SQL Server 2008 for Developers

Modules Run Time Pages
16 18 hours 500

In this course, you'll learn about the features that are available in SQL Server, how to design and create a database, and how to build basic queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You'll learn how to use the Transact-SQL programming language for error handling and hierarchical queries, dealing with complex data structures and processes, how to make your databases more scalable through partitioning, and how to use .NET languages like Visual C# and Visual Basic to build database objects.

SQL Server 2008 includes a rich set of tools that go beyond the basics of querying and manipulating data. You'll learn how to take advantage of the user-friendly management console that integrates both authoring and administrative tasks. You'll learn how to take advantage of SQL Server's tools for analyzing and tuning your databases. You'll also learn about integration services, implementing security, and Microsoft's new Business Intelligence (BI) suite.


In this course you will learn...
  • Understand the differences between views, stored procedures, triggers, and user-defined functions.
  • How to write and use stored procedures to provide a safe, controlled, efficient way to execute Transact-SQL code to access and update data and database objects.
  • Explore the various types of user-defined functions and how to support reusable database code.
  • Discover how transactions can protect the integrity of your data and ways to handle errors that occur when code executes.
  • Learn why using .NET code, using either Visual C# or Visual Basic, in the database overcomes many Transact-SQL limitations, and how SQL Server protects itself from misbehaving code.
  • Use advanced querying techniques for grouping aggregated data, executing multiple actions with the MERGE statement, and others.
  • Understand the complex data types in SQL Server, such as for spatial and hierarchical data, and how they support complex data operations.
  • How to partition data to store data in ways that improve the efficiency of queries.
  • See how the Visual Studio Team System for Database Professionals edition supports designing, creating, and deploying databases in a collaborative environment.
  • Investigate the XML data type and its properties and methods, and how it supports both free form and relational data.
  • Understand Business Intelligence to add reporting and analysis capabilities to your databases and applications.
Prerequisites:

To get the most out of the Microsoft SQL Server 2008 course, you should have a solid understanding of relational databases and the concepts in the SQL Server 2008 Installing, Querying, and Security course. No particular programming experience is required, but the course is taught from a developer's perspective.

Creating Views

  • What Is a View?
  • Creating Views
  • Updating Data Using a View
  • Using Computed Columns
  • Indexed Views
  • Partitioned Views
Creating Stored Procedures and Triggers
  • Creating Stored Procedures
  • Creating Triggers
Creating User-Defined Functions
  • User-Defined Functions Overview
  • Scalar Functions
  • Inline Table-Valued Functions
  • Multi-Statement Table-Valued Functions
  • Using Functions, Views, and Stored Proceduresul
Transactions and Error Handling
  • Transaction Concepts
  • Applications and Transactions
  • Creating Explicit Transactions
  • Using TRY/CATCH Error Handling
Using .NET Code in SQL Server
  • Introduction
  • Writing SQLCLR Code
  • SQLCLR Code Modules
  • SQLCLR Security
  • T-SQL vs .NET Code
Advanced SQLCLR Code Techniques
  • Advanced SQLCLR Code Modules
  • Managing Code Modules
Advanced Query Techniques
  • Full-Text Search
  • Advanced T-SQL Techniques
  • Executing Dynamic SQL
Advanced Data Types
  • Introduction
  • The HierarchyID Data Type
  • Sparse Columns and Column Sets
  • FILESTREAM Storage
  • Spatial Data
Implementing Partitions
  • SQL Server Partitions
  • Creating Partitioned Tables
  • Querying Patitions
  • Managing Partitions
Complex Querying
  • Complex Queries
  • Ranking
  • Correlated SubQueries
  • Common Table Expressions
Advanced Techniques
  • Complex Data and Structures
  • Efficient Queries
  • Working with Complex Queries
  • Maintaining Query Files
Design and Deployment with Visual Studio
  • Team System for Database Professionals
  • Creating Databases and Managing Projects
  • Database and Project Management
Working with XML
  • XML Data Type
  • XML Schema Collections
  • Querying XML
  • Best Practices
Business Intelligence Services
  • Introduction to Business Intelligence Services
  • Using Integration Services
  • Using Analysis Services
  • Using Reporting Services

back to top


Your Instructor

Don Kiely has been using and programming computers since the mid-1970s, when he first punched IBM punch cards for batch processing to solve engineering problems. Now Don is a nationally recognized author, instructor and consultant who travels the country sharing his expertise in SQL Server and security. He has written business software using assembly, C/C++, dBASE, Nantucket Clipper, RPG II, C#, and Visual Basic for a variety of industries, and has taught software and business administration courses at community colleges. Now Don is an author and a consultant for a variety of companies that develop distributed applications for public and private organizations. Don is also the author or coauthor of several programming books, and a featured speaker at SQL Server conferences.

Frank Tillinghast is a senior consultant with MTOW Software Solutions. He is a Microsoft Certified Solution Developer and has been developing applications for over fifteen years. Most of his time is spent consulting for companies nationwide with troubled projects or mentoring projects to successful completion. When he is not developing software or mentoring clients, Frank is teaching other developers. He has taught thousands of application developers how to create business solutions with Visual Studio .NET. VB.NET, ASP.NET, Visual C#, and SQL Server.

back to top


 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy