Menu
  1. Home
  2. Programming
  3. SQL
  4. Short
  5. SQL Server Intermediate 3-day Course (Using MS SQL Management Studio), Live Virtual Classroom
Enquire Now

SQL Server Intermediate 3-day Course (Using MS SQL Management Studio), Live Virtual Classroom

Study Method
Online
Institution
PCWorkshops
Start Date
Enrol anytime

Course overview

Learn how to get valuable information, trends, summaries, statistics and insights from your company data. This course is ideal for managers and data analysts who need to get business intelligence from data.

Expand all and read more

Study method

  • Online
  • Blended
  • In-class
xo-logo

coursesonline.co.uk customers are now eligible to apply for an XO Student Discount Card.

Enrol in a course today to unlock exclusive deals.

Duration study load

  • 3 Days

Course features

  • SQL course certificate on completion (assessment based)
  • SQL course notes
  • Practical SQL course exercises, SQL course homework/SQL course revision work
  • To assist after the course, 1 free session for questions online SQL course via Skype or Teamviewer

Subjects

Core Sessions
Session 1: Database concepts
  • What is a database?
  • Tables, rows and columns
  • Indexes
  • Primary keys
  • Unique constraints and foreign keys
  • Client-server architecture
  • Supported data types
  • Table types
  • The Information Schema
Session 2: Using the SQL client
  • SQL Getting started and logging in
  • Selecting a database
  • Client commands
  • Entering and executing SQL statements
  • Retrieving previous commands
  • Creating, editing and executing SQL files
  • Redirecting output into a file Command line execution of SQL scripts
Session 3: Basic SELECT statements
  • The SQL SELECT statement
  • Case sensitivity
  • Quotes
  • Statement terminator
  • Syntax conventions
  • The select clause
  • The FROM clause
  • Conditions and the WHERE clause,
  • Boolean operators (AND and OR) and SQL conditional operators (=,!=,>,<, IN, and BETWEEN)
  • The ORDER BY clause
  • Column aliases
  • Arithmetic expressions
  • Null functions (“IS NULL,” “IS NOT NULL,”, “IsNull”, “Coalesce”)
  • Precedence of operators
Session 4: LIMIT/TOP, UNION and AGGREGATE functions
  • The LIMIT and TOP clauses
  • Aggregate (Sum, Average, Maximum, Minimum, Count)
  • Group By
  • Rollup with Group By
  • Having
Session 5: Subqueries, basic subqueries, nested subqueries, “WITH AS”
  • Joins: Cartesian products
  • Joins (Inner join, Left join, Right join, Full join)
  • Table aliases
  • Natural joins
  • Join using
  • Join on
  • Multi-table joins
  • Union
  • Union All
  • Except
  • Intersect
Session 6: Numeric functions

Numeric functions (ABS, SIGN, MOD, etc.) and string functions (Locate, Left, Right, Concat, etc), DATE and TIME functions

And more!
Want more information about the subjects for this course?
Get the course guide

Payment options

Course fees – £600

  • No government funding available for this course
Find out more about the payment options for this course
Get the course guide

About PCWorkshops

PCWorkshops mission is to be an integral partner to companies who up-skill and cross-skill their software and data staff.

We are based in London, Milton Keynes, Southend-On-Sea, Birmingham, Portsmouth and Manchester.

Our clients are in a variety of industries, e.g. e-commerce companies,
finance companies, insurance companies, software and technology companies and more.