SQL Introduction for SQL Server

Unemployed Training

Training

In Leatherhead

Price on request

The best SQL Server courses

See all

See all

Description

  • Type

    Training

  • Level

    Beginner

  • Location

    Leatherhead

  • Duration

    1 Day

Aspect's Introduction to T-SQL for SQL Server training class teaches attendees the T-SQL and SQL Server skills they need to develop queries and data reports using SQL. Suitable for: Unemployed Training are here to help you find the skills you require to get back into employment. Whether you require new skills to change career or simply to bring your existing skills up to date, we can help you.

Facilities

Location

Start date

Leatherhead (Surrey)
See map

Start date

On request

About this course

Aspect Training’s course will enable delegates to:
•Understand how SQL Server works
•Learn to select the required records
•Learn to use SQL to output reports with 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

Course programme

Brief History of SQL
Relational Databases
[may be compressed due to attendee
experience]
Tables
Rows
Columns
Relationships
Datatypes
Primary Keys
Foreign Keys
Relational Database Management
System

SQL Server Objects
Valid Object References

SQL Statements
Database Manipulation Language (DML)
Database Definition Language (DDL)
Database Control Language (DCL)

Simple SELECTs with SQL Server
Introduction to the Northwind
Database
Some Basics
Comments
Whitespace and Semi-colons
Case Sensitivity

SELECTing All Columns in All Rows
Exploring the Tables
SELECTing Specific Columns
Sorting Records
Sorting By a Single Column
Sorting By Multiple Columns
Sorting By Column Position
Ascending and Descending Sorts

The WHERE Clause and Operator
Symbols
Checking for Equality
Checking for Inequality
Checking for Greater or Less Than
Checking for NULL
WHERE and ORDER BY

The WHERE Clause and Operator
Words
The BETWEEN Operator
The IN Operator
The LIKE Operator
The NOT Operator

Checking Multiple Conditions
AND
OR
Order of Evaluation

Writing SELECTs with Multiple
Conditions
Advanced SELECTs with SQL Server
Calculated Fields
Concatenation
Mathematical Calculations
Aliases

Aggregate Functions and Grouping
Aggregate Functions
Grouping Data

Built-in Data Manipulation Functions
Common Math Functions
Common String Functions
Common Date Functions

Subqueries, Joins, and Unions with
SQL Server
Subqueries
Joins
Table Aliases
Multi-table Joins

Outer Joins
Unions
UNION ALL
UNION Rules

Additional information

Comments: All Aspect Training's scheduled training courses are held in their Leatherhead, Surrey training centre. Visit our website www.unemployedtraining.co.uk to find out how we can help you.
Students per class: 8

See related categories

SQL Introduction for SQL Server

Price on request

The best SQL Server courses

See all

See all