We use cookies to offer you a better experience and to analyse how visitors use our site, you may consent to our cookies by continuing to use our site, or you may view more information and choose to reject cookies by clicking here. Thank you

Contact us online or call us on 0191 377 8377

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields

PDF
Course SQL Server Querying Microsoft SQL Server 20461
  • Course Duration5 Days
  • Course Options
    Public Scheduled
    Public Scheduled
    Fixed content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!
    Private
    Private
    Flexible content, flexible date, flexible location, variable length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.
    Virtual

Overview
This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
Prerequisites
    • Basic knowledge of the Microsoft Windows operating system and its core functionality.
    • Working knowledge of relational databases.
Objectives
    • Write SELECT queries
    • Query multiple tables
    • Sort and filter data
    • Describe the use of data types in SQL Server
    • Modify data using Transact-SQL
    • Use built-in functions
    • Group and aggregate data
    • UsE subqueries
    • Use table expressions
    • Use set operators
    • Use window ranking, offset and aggregate functions
    • Implement pivoting and grouping sets
    • Execute stored procedures
    • Program with T-SQL
    • Implement error handling
    • Implement transactions
Target Audience
    • This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren't necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.
What's included
    • For courses held on our premises, complimentary tea, coffee and biscuits are available. Lunch is not provided, however, there is a wide variety of eateries within a short walk of the centre.
    • Comprehensive course materials and exercises
Course Content
    • Introduction to Microsoft SQL Server 2014
      The Basic Architecture of SQL Server

      SQL Server Editions and Versions

      Getting Started with SQL Server Management Studio
    • Introduction to T-SQL Querying
      Introducing T-SQL

      Understanding Sets

      Understanding Predicate Logic

      Understanding the Logical Order of Operations in SELECT statements
    • Writing SELECT Queries
      Writing Simple SELECT Statements

      Eliminating Duplicates with DISTINCT

      Using Column and Table Aliases

      Writing Simple CASE Expressions
    • Querying Multiple Tables
      Understanding Joins

      Querying with Inner Joins

      Querying with Outer Joins
    • 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
    • Working with SQL Server 2014 Data Types
      Introducing SQL Server 2014 Data Types

      Working with Character Data

      Working with Date and Time Data
    • Using DML to Modify Data
      Inserting Data

      Modifying and Deleting Data
    • Using Built-In Functions
      Writing Queries with Built-In Functions

      Using Conversion Functions

      Using Logical Functions

      Using Functions to Work with NULL
    • Grouping and Aggregating Data
      Using Aggregate Functions

      Using the GROUP BY Clause

      Filtering Groups with HAVING
    • Using Subqueries
      Writing Self-Contained Subqueries

      Writing Correlated Subqueries

      Using the EXISTS Predicate with Subqueries
    • Using Table Expressions
      Using Derived Tables

      Using Common Table Expressions

      Using Views

      Using Inline Table-Valued Functions
    • Using Set Operators
      Writing Queries with the UNION Operator

      Using EXCEPT and INTERSECT

      Using APPLY
    • Using Window Ranking, Offset, and Aggregate Functions
      Creating Windows with OVER

      Exploring Window Functions
    • Pivoting and Grouping Sets
      Writing Queries with PIVOT and UNPIVOT

      Working with Grouping Sets
    • Executing Stored Procedures
      Querying Data with Stored Procedures

      Passing Parameters to Stored Procedures

      Creating Simple Stored Procedures

      Working with Dynamic SQL
    • Programming with T-SQL
      T-SQL Programming Elements

      Controlling Program Flow
    • Implementing Error Handling
      Using TRY / CATCH Blocks

      Working with Error Information
    • Implementing Transactions
      Transactions and the Database Engine

      Controlling Transactions

      Isolation Levels

 

Course Dates Please contact us to discuss dates for this course, thank you

IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk

Printed: 23 Aug 19

 

 

 

Contact us

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields