Quick Look Course Summary:Querying MS SQL Server 2014 Training Course Course
  • Next Public Course Date:

  • Length: 3 day(s)

  • Price: 1 Person R 15,365.00 EX VAT 3 Person R 8,680.00 EX VAT 10 Person R 5,734.61 EX VAT

  • Certification Type:Accredited

  • Locations & Venues: Off-site or in-house. We train in all major city centres throughout South Africa.

Querying MS SQL Server 2014 Training Course Course: Introduction

This course introduces the SQL Server platform and major tools. It discusses editions, versions, tools used to query, documentation sources, and the logical structure of databases. We will discuss Transact SQL as the primary querying language of SQL Server and the basic structure of T-SQL queries, the logical flow of a SELECT statement, and introduces concepts such as predicates and set-based operations.

Querying MS SQL Server 2014 Training Course Course :Course Outline

1. Introduction to Microsoft SQL Server 2014

The Basic Architecture of SQL Server
SQL Server Editions and Versions
Getting Started with SQL Server Management Studio
Working with SQL Server 2014 Tools
Working with SQL Server Management Studio
Creating and Organizing T-SQL scripts
Using Books Online

2. Introduction to T-SQL Querying

Introducing T-SQL
Understanding Sets
Predicate Logic
Logical Order of Operations in SELECT statements
Introduction to Transact-SQL Querying
Executing Basic SELECT Statements
Queries which filter data using predicates
Queries which sort data using ORDER BY

3. Writing SELECT Queries

Writing Simple SELECT Statements
Eliminating Duplicates with DISTINCT
Using Column and Table Aliases
Writing Simple CASE Expressions

4. Querying Multiple Tables

Understanding Joins
Querying with Inner Joins
Querying with Outer Joins
Querying with Cross Joins and Self Joins
Querying Multiple Tables
Writing Queries That Use Inner Joins
Writing Queries That Use Multiple-Table Inner Join
Writing Queries That Use Self Joins
Writing Queries That Use Outer Joins
Writing Queries That Use Cross Joins

5. Sorting and Filtering Data

Sorting Data
Filtering Data with a WHERE Clause
Filtering with the TOP and OFFSET-FETCH Options
Working with Unknown and Missing Values
Sorting and Filtering Data
Queries That Filter Data Using a WHERE Clause
Queries That Filter Data Using an ORDER BY Clause
Queries That Filter Data Using the TOP Option
Queries That Filter Data Using the OFFSET-FETCH Clause

6. Working with SQL Server 2014 Data Types

Introducing SQL Server 2014 Data Types
Character Data
Date and Time Data
SQL Server 2014 Data Types
Queries That Return Date and Time Data
Queries That Use Date and Time Functions
Queries That Return Character Data
Queries That Use Character Functions

7. Using DML to Modify Data

Inserting Data
Modifying and Deleting Data
Using DML to Modify Data

8. Using Built-In Functions

Queries with Built-In Functions
Conversion Functions
Logical Functions
Functions that Work with NULL
Built-In Functions
Conversion functions
Logical functions
Test for nullability

9. Grouping and Aggregating Data

Aggregate Functions
GROUP BY Clause
Filtering Groups with HAVING
Grouping and Aggregating Data
Writing queries which use the GROUP BY clause
Queries which use aggregate functions
Writing queries which use distinct aggregate functions
Queries which filter groups with the HAVING clause

Querying MS SQL Server 2014 Training Course Course: Course Duration

3 day/s

Who should attend: Querying MS SQL Server 2014 Training Course Course

This course is intended for programmers, SQL Server.

**Quote does not include Any Exam Fees (if applicable)

IMPORTANT ACTION: Do Not Wait To Improve Your Skills.  

Book Now By Completing Online Booking Form / Customised Proposal or Obtain Approval For Your Already Received Customised Proposal

Get Free & personalised
Training Advice

Enjoy incredible savings the more delegates
you send. See for yourself...

BOTi COURSE COST CALCULATOR

Simply Select a date to see cost

Select Date *

Premises Provided by *

Laptop Provided by *

Region *

Administrative Courses

Human Resources Courses

Leadership & Management Courses

RPL & Learnerships Courses

Soft Skills Courses

Software & IT Courses

Specialist Courses

Top Rated