Microsoft SQL training | Writing SQL (2 days)

You may have a fantastic database, but unless you can extract useful information from it, it may as well not exist! This two-day course shows you how to mine your database, from getting a mailing list of people meeting certain criteria through to compiling summary information for the board. Note that the SQL language varies slightly between different database providers; this course teaches the T-SQL or Transact-SQL language using SQL Server 2005.

Writing SQL training - Course Contents

The contents of our Writing SQL course are as follows (any items marked with a * will be covered if time allows). If you aren't sure if this is the right course for you, please either click on one of the content headings below and try some exercises or call or email us to talk through your options. We want you to be on the right Microsoft SQL training course as much as you do!

Using SQL Server
  • Using Object Explorer
  • Hiding system objects
Creating databases - overview
  • Designing databases
  • Primary keys
  • Indexing fields
Working with tables
  • Creating tables
  • Allowing nulls or not
  • Identity fields
Database diagrams
  • Creating database diagrams
  • Joining tables with relationships
Simple Queries
  • Creating queries
  • Comments
  • Indentation and case
Setting criteria using WHERE
  • Wildcards (% and _)
  • Setting criteria for dates
  • Coping with nulls
Outputting to Excel
  • Results, text and grid options
  • Copying and pasting column headings
  • Exporting using SQL
  • Exporting using the menu
Calculations
  • Calculated columns
  • Using aliases
  • String functions and concatenation
Calculations using dates
  • GetDate
  • Converting dates
  • Useful date functions
Basic joins
  • Inner joins
  • Table aliases
  • Left and right outer joins
More exotic joins
  • Cross joins
  • Full outer joins
  • Self joins
Aggregation and grouping
  • SUM, AVG, MIN, MAX
  • Various ways to count
  • Grouping by fields
  • Using HAVING to filter results
More complicated grouping (*)
  • Using COMPUTE
  • Using ALL when grouping
  • Using ROLLUP
  • Using CUBE
Views
  • The view designer
  • Limitations of the designer
  • Scripting views
Scalar functions
  • Types of function
  • Creating functions
  • Passing arguments
Subqueries (*)
  • The concept of a subquery
  • Using ALL, ANY and IN
  • Correlated subqueries
  • Using EXISTS
Progamming (*)
  • Global variables (@@)
  • Creating and setting variables
  • IF statements
  • BEGIN/END blocks
  • WHILE loops
Stored procedures and parameters (*)
  • Creating and altering stored procedures
  • Input and output parameters
  • System stored procedures
  • Setting default values

To help see if this is the right course for you, you can see and download examples of our SQL courseware. You can also look at the differences between Microsoft SQL versions and see on which SQL version we currently train.

Writing SQL training - Pre-requisites

You will get more out of the course if you are already familiar with at least one relational database, whether built in Access or SQL Server.

Writing SQL training - Schedule and Prices

Prices for this Microsoft SQL training course are as follows:

There will be a maximum of 6 people on each course, and each person will have their own computer. Please take a moment to see why our Microsoft SQL training courses are so different, then use our easy-to-use web-based or telephone booking system to book your course place. Alternatively, call (01457) 858877 or email our training co-ordinator.

Onsite Microsoft SQL training

In addition to our standard scheduled Microsoft training courses, we also offer onsite Microsoft SQL training. This allows you to create a Microsoft SQL training course uniquely tailored to the needs of your staff, covering only those aspects of Microsoft SQL which they need to learn.

Recommended sites: TechTutorials

All content copyright Wise Owl Business Solutions Ltd 2009.  All rights reserved.