Introduction to SQL (online)

Wise Owl

Short course

Online

£ 725 VAT inc.

The best SQL Server courses

See all

See all

Description

  • Type

    Short course

  • Level

    Beginner

  • Methodology

    Online

  • Class hours

    12h

  • Duration

    2 Days

  • Delivery of study materials

    Yes

  • Personal tutor

    Yes

  • Virtual classes

    Yes

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.

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

  • SQL
  • Database
  • Database training
  • SQL Database
  • Server

Teachers and trainers (5)

Andrew Gould

Andrew Gould

Senior Trainer

David Wakefield

David Wakefield

Director / Programmer / Trainer

Rick Gould

Rick Gould

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

Also available as a classroom course at our premises in Manchester or London or at your venue.

See related categories

Introduction to SQL (online)

£ 725 VAT inc.

The best SQL Server courses

See all

See all