AquinasTraining.co.uk - training courses. Home  -  FAQ  -  Corporate Plans

SQL Server 2005: Transact-SQL Querying/Updating + Programming

SQ05-QP      Course duration (days): 4
Talk to a Training Advisor
Tel. 0800 652 0202
Availability (sort by: location | date)
Request availability by clicking a date.
England
Worcestershire
Worcester (WR1) 23/09/08 £ 1,360
Worcester (WR1) 08/12/08 £ 1,360
Prices exc. VAT.  Courses are vendor approved.
Need help? Contact us now.

Contents of this class

  • Introduction to Databases
  • Database Basics
  • Normalisation
  • Datatypes
  • Using SQL Server Management Studio
  • SQL Batches and the GO Command
  • Database Diagrams
  • Designing a Database
  • Querying and Updating the Database
  • Selecting Data
  • Inner Joins
  • Outer Joins
  • Cross Table Joins
  • UNION, INTERSECT and EXCEPT
  • Updating Data
  • Inserting Data
  • Deleting Data
  • Creating a Database
  • Creating Tables
  • Creating and Updating a Table with
  • Transact SQL
  • Testing Your Table
  • 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 in Management Studio
  • Putting the Performance Tools to Use
  • Advanced Programming with Transact SQL
  • Temporary Tables
  • Dynamic SQL
  • Cursors
  • Introduction to SQL Server Support for XML
  • Introduction to XML
  • XML Casting
  • XML Data Types
  • Data Integrity
  • Error Handling
  • Transactions
  • Triggers
  • Real World Development
  • Writing SQL for Reporting Tools
  • Troubleshooting
  • Other SQL Server 2005 Technologies
  • Best Practices
(C) AquinasTraining.co.uk - Contact Us