Trusted Training Partners

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

  • Length: 3 day(s)

  • Price (at your venue): 1 Person R 16,700.00 EX VAT 3 Person R 11,644.28 EX VAT 10 Person R 7,836.00 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

    Querying MS SQL Server 2012
    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.

    Querying MS SQL Server 2012
    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
    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
    Basic SELECT Statements
    Executing queries which filter data using predicates
    Executing queries which sort data using ORDER BY

    3. Writing SELECT Queries
    Writing Basic 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

    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
    Writing Queries That Filter Data Using an ORDER BY Clause

    6. Working with SQL Server 2014 Data Types
    Introducing SQL Server 2014 Data Types
    Working with Character Data
    Working with Date and Time Data

    7. Using DML to Modify Data
    Inserting Data
    Modifying and Deleting Data
    Using DML to Modify Data

    8. Using Built-In Functions
    Writing Queries with Built-In Functions
    Conversion Functions
    Logical Functions
    Using Functions to Work with NULL
    Built-In Functions

    9. Grouping and Aggregating Data
    Aggregate Functions
    Using the GROUP BY Clause
    Filtering Groups with HAVING
    Grouping and Aggregating Data
    Write queries which use distinct aggregate functions

    Querying MS SQL Server 2012
    Training Course Course: Course Duration

    3 day/s

    Who should attend: Querying MS SQL Server 2012
    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 *

    Please Contact Us Now - We Will Respond in 15 Minutes


      Accredited Courses

      Additional Courses

      Leadership & Management Courses

      Software & IT Courses

      Top Rated