Trusted Training Partners

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

  • Length: 3 day(s)

  • Price (at your venue): 1 Person R 15,365.00 EX VAT 3 Person R 9,344.72 EX VAT 10 Person R 6,014.09 EX VAT

  • Certification Type:Accredited

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

Get Free & personalised
Training Advice

    Knowing your course will help us prepare for our consultation and phone call.

    The more people you send on our courses, the cheaper the unit cost.

    YesNo

    Input this code: captcha

    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

    Realize incredible savings by sending more delegates

    Do you want to save costs by doing training at your premises?

    Save costs by providing own laptop

    Region *

    Accredited Courses

    Additional Courses

    Software & IT Courses

    Top Rated