Microsoft training courses, Cisco training courses, Prince2 training courses, ISEB training courses with locations nationwide
Call now to speak to an experienced Training Advisor
 
     
 
Home
  
How it works
  
About the quality of your course
 
Managed services
  
Partner CourseMonster
  
 
 
Thousands of Microsoft, ISEB, ITIL, Cisco and Prince2 Training Courses and more
  
 
Browse Microsoft Training Courses

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

Course Code: SQ05-QP      Days: 4
Show all Microsoft Courses
Scheduled Dates
Locations filtered. Show all UK course locations.
Request availability or book by selecting a date:
England
Worcestershire
Worcester (WR1) 08/12/08 £ 1,360
Worcester (WR1) 12/01/09 £ 1,360
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.

Course Outline

  • 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


How to make a booking for the SQ05-QP course
 
  CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.  
     
CourseMonster® Patent Pending © SeaKom, All Rights Reserved - Channel partners with Business Training Partnership