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
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 Feb 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