IT Courses - Microsoft SQL Server 2016 and 2017 Programming

Venue: Ilkeston
Cost (£): 1700.00

Course Overview

Comprehensive and intensive, this five-day course includes plenty of
illustrated examples and practical hands-on exercises to enhance your
learning experience.
Delegates should be familiar with basic programming concepts and
also understand the fundamental design of relational databases,
including the purpose of primary and foreign keys, entity relationships
and data normalisation. Our SQL Server 2016 and 2017 Relational
Database Design and Querying Fundamentals course would be the
ideal way for you to gain this knowledge.

Course Content

• 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
• Summarise 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
• SQL Server locks
• 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 user defined functions
• Create and implement triggers


Check Available Course Dates & Book »