Home
  
How it works
  
About the quality of your course
 
Managed services
  
Promote CourseMonster
  
 
 
 
 
Microsoft

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

Course Code: SQ05-QP      Days: 4
Show all Microsoft Courses
Scheduled Dates (sort by: location | date)
Request availability or book by selecting a date:
23/09/08 Worcestershire (WR1) £ 1,360
08/12/08 Worcestershire (WR1) £ 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