Loading Events

The Skills Academy – Transact-SQL Query Scripting

Database developers, administrators and analysts wishing to manipulate data in a SQL Server environment will learn the essential core requirements by participating in this Skills Academy workshop. Covering three days, students will build their experience by initially starting with basic SQL architecture and progressing to more complex scripting design. This is an ideal course for an introduction into using Transact SQL as the primary querying language of SQL servers. The Skills Academy workshops offer a better way of learning by building the skills and confidence required to work in a real world IT environment. With a more time efficient and ‘hands on’ approach to training, resulting in hundreds of satisfied students, businesses have benefited from improved IT productivity and a rapid return on investment. Places are limited to only six per workshop guaranteeing each student an in-depth level of support to maximise their development

Topics covered:

  • Introduction to Microsoft SQL Server 2012/2014 platform, editions, versions, tools used to query, documentation sources, and the logical structure of databases
  • Introduction to T-SQL Querying introduces Transact SQL as the primary querying language of SQL Server, basic structure of T-SQL queries, logical flow of a SELECT statement, predicates and set-based operations
  • Writing SELECT Queries introduces the fundamentals of the SELECT statement, focusing on queries against a single
    table
  • Sorting and Filtering Data explains enhancing queries to limit the rows they return, control the order in which rows are displayed and resolve missing & unknown results
  • Querying Multiple Tables explains how to write queries which combine data from multiple sources in SQL Server, using JOINs for retrieving data from multiple tables
  • Grouping and Aggregating Data within a query, aggregating the grouped data and filtering groups with HAVING clause
  • Using DML to Modify Data uses Transact-SQL Data Manipulation Language to perform inserts, updates, and deletes to your data
  • Built-In Functions introduces functions that are built in to SQL Server 2014 for data type conversion, testing for logical results and nullability
  • Subqueries in various parts of a SELECT statement, scalar and multi-result subqueries, and the use of the IN and EXISTS operator
  • Programming with T-SQL basic introduction to T-SQL programming concepts and objects, batches, variables, control of flow elements such as loops and conditionals
  • Using Table Expressions return a valid relational table for further use in the query, views, derived tables, inline table-valued functions
  • Stored Procedures use of EXECUTE, how to pass input and output parameters to a procedure, and how to invoke system stored procedures
  • Improving Query Performance key guidelines for writing well-performing queries, monitor execution of queries and their impact on SQL Server

Download Course Outline