Microsoft SQL Server 2008 Programming
Duration: 5 Days
This 5 day course is intended for students new to querying with Microsoft SQL Server products and who need a total immersion in the subject on this latest release. This is a comprehensive and intensive course with plenty of illustrated examples and augmented with practical hands-on exercises. For the more experienced SQL Server developer, this course can be tailored to include only the material required. The Appendix module(s) detailed in the outline are included in the course material but are not delivered as part of the training due to time constraints. However, as this course is fully modularised, an Appendix module could be swapped out with any one of the main modules of comparable size and duration if so desired.
Topics Covered In This Course
Introduction to SQL Server Management Studio
Introduction to SQL and Transact-SQL
Using the SELECT Statement to Retrieve Data
Retrieving Specific Rows of Data Using the WHERE Clause
Formatting and Sorting Result Sets
Querying Data from Multiple Tables by Using Joins
Inserting Data into Tables
Deleting Data from Tables
Updating Data in Tables
Transactions and Locking
Working with SQL Server Date and Time Data
Querying XML Data
Summarizing Data Using Aggregate Functions
Ranking Grouped Data
Combining and Limiting Result Sets
Working with Subqueries
Performance Considerations for Writing
Common Table Expressions
Implementing Stored Procedures
Implementing User Defined Functions
Appendix 1. Querying Metadata
Appendix 2. Distributed Queries
What You Can Expect
Upon successful completion of this course, students will be able to:
Students should ideally be familiar with basic programming concepts, and
understand the fundamental design of relational databases and the concept of data normalization.
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]