Querying Microsoft SQL Server
Course
Inhouse
Description
-
Type
Course
-
Methodology
Inhouse
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.
About this course
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).
Reviews
Course programme
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
- Delegates will be able to :
- Describe the uses of and ways to execute the Transact-SQL language.
- Use querying tools.
- Write SELECT queries to retrieve data.
- Group and summarize data by using Transact-SQL.
- Join data from multiple tables.
- Write queries that retrieve and modify data by using subqueries.
- Modify data in tables.
- Describe how to create programming objects.
- Comprehensive colour course manual and exercises
- Use of a Modern Training suite with 19 inch flat screen monitors
- 1 delegate per computer
- Lunch (When at our training venue)
- Refreshments (When at our training venue)
- Relaxed refreshment area at our training room
Introduction to Transact-SQL
- The transact-SQL programming language
- Types of transact-SQL statements
- Transact-SQL syntax elements
- Using SQL server books online
- 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 by using the select statement
- Filtering data
- Formatting result sets
- How queries are processed
- Performance considerations
- Retrieving data and manipulating result sets
- 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
- Using aliases for table names
- Combining data from multiple tables
- Combining multiple result sets
- Querying multiple tables
- 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
- Using transactions
- Inserting data
- Deleting data
- Updating data
- Modifying data
- Introduction to views
- Advantages of views
- Creating views
- Introduction to stored procedures
- Introduction to triggers
- Introduction to user-defined functions
- Working with views
Querying Microsoft SQL Server