SQL Server Querying using Transact
| Date |
Location |
Duration |
Cost |
24 Jan 2011 (Mon)
25 Jan 2011 (Tue)
26 Jan 2011 (Wed) | Sunderland | 3 | £ 985 |
19 Jul 2011 (Tue)
20 Jul 2011 (Wed) | Washington | 3 | £ 985 |
01 Sep 2011 (Thu)
02 Sep 2011 (Fri) | Washington | 3 | £ 985 |
10 Oct 2011 (Mon)
11 Oct 2011 (Tue) | Washington | 3 | £ 985 |
Please contact us to discuss private course dates and locations |
Course Overview
This course is intended to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2005. It is a very hands on course that covers SQL query writing from the basics to advanced queries.
Prerequisites
- An understanding of basic relational database concepts, including:
- Logical and physical database design
- Data integrity concepts.
- Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many).
- How data is stored in tables (rows and columns).
Objectives
Training Options
- Private course at your company office throughout the UK, at one of our training venues (Durham, Newcastle or Washington) or at an independent location, convenient to you
- Bespoke course written to your specific needs, at your company office throughout the UK, at our training venue or at an independent location, convenient to you
- For further information please contact us on 0191 377 8377
What's Included
- 1 delegate per computer
- Relaxed refreshment area at our training venues
- Lunch and refreshments when training is delivered at our training venue
- Comprehensive course manual and exercises
Course Content
Introduction to Transact-SQL
The transact-SQL programming language
Types of transact-SQL statements
Transact-SQL syntax elements
Using SQL server books online
Using Transact-SQL Querying Tools
SQL query analyzer
Using the object browser tool in SQL query analyzer
Using the OSQL utility
Executing transact-SQL statements
Creating and executing transact-SQL scripts
Retrieving Data
Retrieving data by using the select statement
Filtering data
Formatting result sets
How queries are processed
Performance considerations
Retrieving data and manipulating result sets
Grouping and Summarizing Data
Listing the top n values
Using aggregate functions
Grouping by fundamentals
Generating aggregate values within result sets
Using the compute and compute by clauses
Grouping and summarizing data
Joining Multiple Tables
Using aliases for table names
Combining data from multiple tables
Combining multiple result sets
Querying multiple tables
Working with Subqueries
Introduction to subqueries
Using a subquery as a derived table
Using a subquery as an expression
Using the exists and not exists clauses
Working with subqueries
Modifying Data
Using transactions
Inserting data
Deleting data
Updating data
Modifying data
Introduction to Programming Objects
Introduction to views
Advantages of views
Creating views
Introduction to stored procedures
Introduction to triggers
Introduction to user-defined functions
Working with views
SQL Server training courses in North East England, Durham, Washington, SQL Server 2005 Querying Using Transact Newcastle, North East
Print