Show findcourses.co.uk as: Mobile

SQL - Introduction

Wise Owl
Course summary
Length: 2 days
Price: 695 - 795 GBP excl. VAT
Provider: Wise Owl plus
Course type: Open / Scheduled
Next available date: 08/01/2019 - London
Rating: (18 Reviews)
Course home page: Link
Course Dates
London
08/01/2019  
795 GBP
19/02/2019  
795 GBP
26/03/2019  
795 GBP
Manchester
31/01/2019  
695 GBP
28/02/2019  
695 GBP
09/04/2019  
695 GBP

Course description

Introduction to SQL Course - London, Manchester, BirminghamLearn Microsoft SQL Server Database - 2-Day Introductory Course in London and Manchester

With the Microsoft SQL Server database, delegates can efficiently and effectively extract and recover information from corporate databases.

This introductory 2-day course will provide delegates with a foundational understanding of the SQL Server structure as well as how apply it. Specifically, delegates will learn to create tables in SQL Server and how to write SQL in order to later extract information from it. This course will include exercises in the subject, to help delegates consolidate knowledge and grasp the three core learning outcomes:

  • The WHERE clause (setting criteria)
  • The ORDER BY clause (aggregating data)
  • The GROUP BY clause (creating inner, outer and full joints)

Suitability - Who should attend?

As this is an introductory course, it is suitable for delegates with all levels of ability. No prior knowledge of SQL is required. 

In order to maximise each delegate's learning experience, class sizes are kept to a maximum of 6 delegates.

Outcome / Qualification etc.


SQL Server Training CourseUpon completion of this course, delegates will be able to effectively navigate and apply SQL.

Training Course Content

This introductory training course in SQL will cover the principles functions of SQL server, including:

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 (if time)

  • Using COMPUTE
  • Using ALL when grouping
  • Using ROLLUP
  • Using CUBE

Views

  • The view designer
  • Limitations of the designer
  • Scripting views

Overview of functions (if time)

  • Types of function
  • Creating functions
  • Passing arguments

Overview of stored procedures (if time)

  • Creating stored procedures
  • Passing parameters
  • Basic variables

Expenses

This cost of this course is £695 + VAT per delegate for most venues and £795 + VAT for London. All courses include lunch at a local restaurant.

In-House Option

This course can also be delivered on-site for groups, teams or companies. 

About provider

Wise Owl - Specialist Microsoft Training in London, Birmingham, Manchester and more

The Wise Owl team has made a name for itself delivering specialist Microsoft training for software enthusiasts, by software enthusiasts. With a team of six dedicated full-time trainers, Wise Owl have the knowledge, resources and enthusiasm to deliver Microsoft training...


Read more and show all courses with this provider

Contact info

Wise Owl

Kingsmoor House, Railway Street,
SK13 2AA Hadfield Derbyshire

 Show phone number
www.wiseowl.co.uk


Reviews

Rachel E   |   21/05/2018
Content was very good; in particular the course was relaxed and informal. The trainer was brilliant and I am now more confident in SQL  Being able to take away manuals and content is very helpful.
          (5)
Scott H   |   21/05/2018
Trainer was fantastic and was always willing to help with questions. Really friendly and easy to talk to. My company already had positive experiences of Wise Owl with colleagues attending the training previously.
          (5)
Mark E   |   21/05/2018
Trainer was great, content was engaging and the materials provided were great.
          (5)
U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's first annual U.K. L&D Report!

UK L&D Report

Learn more

Reviews
SQL - Introduction
Course rating
          (4.9)
Based on 18 reviews