Call now: (800) 766-1884  


 SQL Server Tips
 SQL Server Training

 SQL Server Consulting
 SQL Server Support
 SQL Server Remote DBA

 SQL Server Scripts
 Scripts Menu





Getting started with SQL for SQL Server

2007 by Burleson Consulting

This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices

Optional supplemental mentoring


Key Features

* Learn about SQL constructs.

* Use SQL*Plus.

* Learn advanced SQL operators.

* Use aggregation in SQL.

* Understand SQL Tuning.



Course Description

Getting started with SQL for SQL Server is an intensive three-day course designed to provide SQL Server professionals with an in-depth understanding of the SQL Server SQL dialect and how to formulate and tune SQL statements for optimal performance.

Book Required

  SQL For SQL Server

Bryan Syverson

ISBN 978-1890774165


This course is designed for practicing SQL Server professionals who have basic experience with SQL and the use of a relational database. Prior experience with SQL Server is not required, but experience using SQL with a relational database is highly desirable.

This course was designed by Donald K. Burleson.  Author or more than 30 database books, Burleson has over two decades of real-world DBA experience.

Learning Objectives

By the end of this course the student will be able to formulate basic and advanced SQL queries including correlated subqueries and outer joins. The student will also become familiar with SQL Server SQL and will be able to use the EXPLAIN PLAN utility to view SQL execution plans.

Getting Started with SQL Server SQL

2009 by Donald K. Burleson

Introduction to SQL constructs
  • Review of Basic SQL statements
  • Select, Project, Join
  • Describing SQL Server tables
  • Restricting row returns
Using SQL*Plus 
  • Creating basic reports
  • Using the set commands
  • Column wrapping
  • Creating breaks and summaries
  • Adding prompts to queries

Joining SQL Server tables
  • Equi-join
  • Outer join
  • Hiding joins by creating views
  • Subqueries
  • Exercise – write a subquery
  • Correlated subquery
  • Non-correlated subqueries

Advanced SQL operators
  • Between operator
  • IN and NOT In operators
  • Sub-queries
  • EXISTS clause
  • Using wildcards in queries (LIKE operator)


Aggregation in SQL
  • Count(*)
  • Sum
  • Avg
  • Min and max
  • Using the group by clause

SQL access methods
  • Review of Basic joining methods
  • Merge join
  • Hash Join
  • Nested Loop join
  • Advanced SQL operators
  • Between operator

SQL Tuning
  • Introduction to SQL optimization
  • Collecting table and index statistics
  • Using column histograms
  • Changing the default optimizer modes
  • SQL reusability
  • Table high-water mark
  • Table striping and table partitions
  • Interpreting EXPLAIN PLAN Output
  • Using indexes to improve performance
  • Identifying full-table scans
  • Re-writing SQL queries
  • Using hints to improve SQL performance
  • Using parallel query to improve performance
  • Tuning sub-queries



This is a BC SQL Server training course (c) 2009

Burleson is the America's Team

Note: The pages on this site were created as a support and training reference for use by our staff of DBA consultants.  If you find it confusing, please exit this page.

Errata?  SQL Server technology is changing and we strive to update our SQL Server support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:and include the URL for the page.

Burleson Consulting
SQL Server database support


Copyright 1996 -  2013 by Vaaltech Web Services. All rights reserved.