SQL Server Querying and Programming
This course will allow delegates to understand and use Transact SQL for both querying and programming (Q&P) in a Microsoft SQL Server environment. Additionally, this course is suitable for all versions of SQL Server.
Book your virtual training
- Date
- Venue
- Cost
- More info
- Date and time to suit you
- VenueWe will train your team
wherever they are based - CostContact us for price
- Fill in the form and we'll be in touch
within a working day.
Book your place
- Date
- Venue
- Cost
- Availability
- Date07 Jun 2021
- VenueVirtual Classroom Learning
- Cost£1,596
- AvailabilityAvailable
- Book Now
- Date23 Aug 2021
- VenueWorcester
- Cost£1,596
- AvailabilityAvailable
- Book Now
- Date22 Nov 2021
- VenueVirtual Classroom Learning
- Cost£1,596
- AvailabilityAvailable
- Book Now
This course covers important Transact SQL features such as data types, joins, sequences, subqueries, indexes and views. It includes creating stored procedures, user defined functions and triggers. Exercises are included to consolidate the skills taught.
Database developers and support personnel who need to be able to query and programme SQL Server databases using Transact SQL. The course is also suitable for application developers (Visual Basic, C#, etc.) who need to query SQL Server databases.
- 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
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.
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.
- Database Basics
- Data Types
- Using SQL Server Management Studio
- SQL Batches and the GO Command
- Selecting Data
- Selecting Columns from a Table
- Inner, Outer and Cross Joins
- Overview of Graph Database
- Union, Intersect and Except
- Updating, Inserting and Deleting Data
- Merging Data
- Recording Changes
- Creating & Altering Tables
- Creating and Updating a Table with Transact SQL
- Dropping Tables
- Temporal Tables
- Variables
- Functions
- Scalar Functions
- Aggregate Functions
- Splitting, Aggregating and Trimming Strings
- Stored Procedures
- Creating Stored Procedures
- Executing Stored Procedures
- Controlling Flow of Code
- User Defined Functions
- Subqueries
- Grouping and Summaries
- Views
- Common Table Expressions
- Pivot Tables
- Ranking Functions
- Window Functions
- Designing Indexes
- Creating an Index
- Creating an Index on a View
- Viewing the Execution Plan
- Putting the Performance Tools to Use
- Temporary Tables
- Declaring a Variable with the Table Datatype
- Dynamic SQL
- Cursors
- Introduction to XML
- XML Casting
- FOR XML
- Overview of SQL Server Support for JSON
- Error Handling
- Try... Catch Block
- Transactions and Locks
- Triggers
- Triggers in Management Studio
- Writing SQL for Reporting Tools
- Troubleshooting
- Other SQL Server Technologies
- Best Practices
Delegates must have a good understanding of relational databases. This can be obtained by attending our SQL Server Essentials course. Delegates must also have a basic knowledge of Microsoft Windows.