Introduction to SQL (classroom)

Wise Owl

Course

In Manchester and London

£ 895 + VAT

The best SQL Server courses

See all

See all

Description

  • Class hours

    12h

  • Duration

    2 Days

  • Start date

    Different dates available

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 (although you can elect to use SQL Server 2008 if you prefer; the differences are small). Suitable for: This Writing SQL course is aimed primarily at businesses and public sector organisations

Important information

Documents

  • Intro SQL course outline.pdf

Facilities

Location

Start date

London
See map
Holland House 1-4 Bury Street, EC3A 5AW

Start date

Different dates availableEnrolment now open
Manchester (Lancashire)
See map
Barlow House, Minshull Street, M1 3DZ

Start date

Different dates availableEnrolment now open

About this course

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Using SQL Server
  • Creating databases - overview
  • Working with tables
  • Database diagrams
  • Simple Queries
  • Setting criteria using WHERE
  • Outputting to Excel
  • Calculations
  • Calculations using dates
  • Basic joins
  • More exotic joins
  • Aggregation and grouping
  • Views

Teachers and trainers (5)

Andrew Gould

Andrew Gould

Senior Trainer

Andy Brown

Andy Brown

Microsoft Trainer & Programmer

David Wakefield

David Wakefield

Director / Programmer / Trainer

Sam Lowrie

Sam Lowrie

Trainer

Shaun Wantling

Shaun Wantling

Trainer

Course programme

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
Views
  • The view designer
  • Limitations of the designer
  • Scripting views

If time

Subqueries
  • The concept of a subquery
  • Using ALL, ANY and IN
  • Using EXISTS
  • Correlated subqueries

If time

Derived tables and CTEs
  • Using derived tables
  • Common Table Expressions (CTEs)
  • Multiple CTEs in a single query

Additional information

£895 + VAT for most venues (£1,195 + VAT for London) * Also available online or as a tailored course at your premises.

See related categories

Introduction to SQL (classroom)

£ 895 + VAT

The best SQL Server courses

See all

See all