Home

SQL Server Querying and Programming

in
Learn to query and programme using SQL Server
Overview

The course will allow delegates to understand and use Transact SQL for both querying and programming in a Microsoft SQL Server environment. This course uses SQL Server 2012 but is equally suitable for previous versions.

Course code
SQL4QAP
Duration
4 days
Delivery style
Classroom
Course type
Public or Private
Purpose of this course

This course covers important Transact SQL features such as data types, joins, sequences, subqueries, indexes, views and table-valued parameters. It includes creating stored procedures, user defined functions and triggers. Exercises are included to consolidate the skills taught.  

Who is this course for

Database developers and support personnel who need to be able to query and programme SQL Server databases using Transact SQL.

Benefits to your organisation

SQL Server is becoming an increasingly popular choice for enterprise wide applications. This course will give your organisation the ability to develop both Transact SQL queries and programmes. These queries and programmes will often be used as the basis of corporate reports.

Benefits to you as an individual

Many roles now require knowledge of SQL Server. This course will equip you with the skills to understand and use Transact SQL. You will have confidence to develop queries and programmes in Transact SQL.

Prerequisites

Delegates must have a good working knowledge of relational databases. This can be obtained by attending our SQL Server Essentials course. Delegates must have a basic knowledge of Microsoft Windows

You will learn how to
  • Write Transact SQL queries
  • Develop stored procedures
  • Use inner, outer and cross joins
  • Use many advanced Transact SQL syntaxes
  • Build indexes to improve query performance
  • Control locking and consistency through transactions
Open quote

Teaching methods were clear, helpful and enjoyable to understand all the object orientated programming techniques covered.  Also great hospitality from all staff.

Close quote
Duncan Tipton
Object Oriented Programming with Visual Basic
Course content Show details
Introduction to Databases
  • Database Basics
  • Normalization
  • Data Types
  • Using SQL Server Management Studio
  • Using Enterprise Manager & Query Analyzer
  • SQL Batches and the GO Command
  • Database Diagrams
  • Designing a Database
Querying and Updating the Database
  • Selecting Data
  • Selecting Columns from a Table
  • Inner, Outer and Cross Joins
  • Union, Intersect and Except
  • Updating, Inserting and Deleting Data
  • Merging Data in SQL Server 2008 onwards
  • Capturing & Tracking Changes in SQL Server 2008 onwards
Creating a Database
  • Creating & Altering Tables
  • Creating and Updating a Table with Transact SQL
  • Dropping Tables
Programming with Transact SQL
  • Datatypes and Variables
  • Stored Procedures
  • Controlling Flow of Code
  • User Defined Functions
Advanced Querying
  • Subqueries
  • Grouping and Summaries
  • Views
  • Common Table Expressions
  • Pivot Tables
  • The Output Clause
Optimisation
  • Designing Indexes
  • Creating an Index
  • Creating an Index on a View
  • Viewing the Execution Plan
  • Putting the Performance Tools to Use
Advanced Programming with Transact SQL
  • Temporary Tables
  • Declaring a Variable with the Table Datatype
  • Dynamic SQL
  • Cursors
Introduction to SQL Server Support for XML
  • Introduction to XML
  • XML Casting
  • XML Methods
Data Integrity
  • Error Handling
  • Try... Catch Block
  • Transactions and Locks
  • Triggers
  • Triggers in Management Studio
Real World Development
  • Writing SQL for Reporting Tools
  • Troubleshooting
  • Other SQL Server Technologies
  • Best Practices
Course Outline v2.0

Copyright © 2009 Quanta Training Ltd. All rights reserved.       Terms of Business | Privacy Policy | Acknowledgements