Search courses 👉
Professional Training

MS SQL Server 2016/17 Programming

Future Savvy, In London (+4 locations)
Length
5 days
Next course start
Enquire for more information (+5 start dates)
Course delivery
Classroom, Virtual Classroom
Length
5 days
Next course start
Enquire for more information (+5 start dates)
Course delivery
Classroom, Virtual Classroom
Leave your details so the provider can get in touch

Course description

MS SQL Server 2016/17 Programming

This 5 day course is intended for students new to querying and programming with Microsoft SQL Server products who need a total immersion in the subject on a SQL Server 2016 or 2017 platform. This is a very comprehensive and intensive course with plenty of illustrated examples and augmented with practical hands-on exercises to enhance the learning experience.

Additionally, with the course structure being fully modularised, customised versions of this course can also be devised and delivered to suit individual requirements. In fact, specific content from this course could also be combined with material from other related courses to produce a bespoke training package – just ask for details

Upcoming start dates

Choose between 5 start dates

Enquire for more information

  • Classroom
  • Birmingham

Enquire for more information

  • Classroom
  • London

Enquire for more information

  • Classroom
  • Manchester

Enquire for more information

  • Classroom
  • Reading

Enquire for more information

  • Virtual Classroom
  • Online

Suitability - Who should attend?

Prerequisites

Students should be familiar with basic programming concepts and also understand the fundamental design of relational databases including, but not restricted to, the purpose of primary and foreign keys, entity relationships, and data normalization, such as can be found in the following course.

SQL Server 2016 and 2017 Relational Database Design and Querying Fundamentals

Outcome / Qualification etc.

Upon successful completion of this course, students will be able to:

  • Identify the Primary Components of a Typical SQL Server 2016 or 2017 Installation
  • Identify the Tools Available in SQL Server 2016 or 2017
  • Use SQL Server Management Studio (SSMS)
  • Understand the Components of Transact-SQL (T-SQL)
  • Retrieve, Filter and Sort Data
  • Work with the Native SQL Server Data Types
  • Query Data from Multiple Tables Using Joins
  • Summarize and Group Data
  • Use Window Functions for Ranking and Aggregating Data
  • Combine and Limit Result Sets
  • Work with Subqueries
  • Use Crosstab Queries
  • Use Common Table Expressions
  • Work with SQL Server Date and Time Data
  • Modify Data with INSERT, DELETE and UPDATE
  • Merge Data with the MERGE Statement
  • Understand and Implement Transactions
  • Understand SQL Server Locks
  • Understand SQL Server Indexes
  • Understand Query Performance Issues
  • Create and Manage Views
  • Control the Flow of Program Execution
  • Create and Implement Stored Procedures
  • Handle Errors and Exceptions
  • Create and Implement Triggers

Training Course Content

  • Introduction to SQL Server Management Studio
  • Introduction to SQL Server Integration Services
  • Introduction to SQL and Transact-SQL
  • Using the SELECT Statement to Retrieve Data
  • Filtering Rows of Data with the WHERE Clause
  • Formatting and Sorting Result Sets
  • Working with SQL Server Data Types
  • Querying Data from Multiple Tables Using Joins
  • Summarizing Data Using Aggregate Functions
  • Window Functions
  • Combining and Limiting Result Sets
  • Working with Subqueries
  • Temporary Storage
  • Crosstab Queries
  • Common Table Expressions
  • SQL Server Date and Time Data Types
  • Inserting Data into Tables
  • Deleting Data from Tables
  • Updating Data in Tables
  • Merging Data
  • Transactions and Locking
  • SQL Server Indexes
  • Query Performance Considerations
  • Implementing Views
  • Controlling Program Execution
  • Implementing Stored Procedures
  • Error Handling
  • Implementing User Defined Functions
  • Implementing Triggers
  • Appendix 1. Querying Metadata
  • Appendix 2. Distributed Queries

Request info

Contact form

Fill out your details to find out more about MS SQL Server 2016/17 Programming.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Future Savvy

Welcome to Future Savvy, your gateway to a world of boundless learning and professional growth! At Future Savvy, we believe that knowledge is the key to success, and we are dedicated to providing top-notch training solutions designed to empower individuals...

Read more and show all courses with this provider

Ads