Call now: (800) 766-1884  



 Home


 SQL Server Tips
 SQL Server Training

 SQL Server Consulting
 SQL Server Support
 SQL Server Remote DBA



 Articles
 Services
 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

Audience

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
Syllabus

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
  • Using IN, NOT IN, EXISTS and NOT EXISTS
  • 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
  • Using EXPLAIN PLAN
  • 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.