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
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
Welcome to Systematix, your gateway to a world of boundless learning and professional growth! At Systematix, we believe that knowledge is the key to success, and we are dedicated to providing top-notch training solutions designed to empower individuals and organisations...