After the course, you will be able to understand and apply the following:
Getting Started with Databases and T-SQL
Querying and Filtering Data
Joining Data from Multiple Tables
Grouping and Summarizing Data
Working with Subqueries
Modifying Data in Tables
SQL 2008 Introduction course is suitable for those who are looking to analyse their data using specific query features incorporated within SQL.
You are not required to have any.prior knowledge or experience of SQL. However, use or understanding of MS Access Queries or simliar would be beneficial.
This is a 2 day SQL 2008 Introduction Course.
Course starts at 09:30 and runs until 16:30
Alternate timing available upon request
This course can be run onsite, at our training centre or any preferred location in the UK.
The course can be held on a date that suits you.
Overview of SQL Server
Overview of SQL Server Databases
Overview and Syntax Elements of T-SQL
Working with T-SQL Scripts
Using T-SQL Querying Tools
Exploring the Components and Executing Queries in SQL Server Management Studio
Generating a Report from an SQL Server Database Using Microsoft Office Excel
Using the SELECT Statement
Working with NULL Values
Formatting Result Sets
Performance Considerations for Writing Queries - indexes
Querying Multiple Tables by Using Joins
Applying Joins for Typical Reporting Needs
Combining and Limiting Result Set
Summarizing Data by Using Aggregate Functions
Summarizing Grouped Data
Ranking Grouped Data
Creating Crosstab Queries
Writing Basic Subqueries
Writing Correlated Subqueries
Comparing Subqueries with Joins and Temporary Tables
Using Common Table Expressions
Data into Tables
Data from Tables
Data in Tables
Overview of Transactions