SQL Server Training UKObjectives |
|
Please click here for a full list of our latest SQL Server 2005 training courses
Duration
5 Days
Who Should Attend
Programmers looking to gain the skills to develop commercial
SQL Server applications.
Pre Requisite Skills
SQL and RDBMS Programming skills.
Associated courses
SQL Server 2005 training - coming
soon!
SQL Server 2000 Applications Development
training
SQL Server 2000 Database Administration
SQL
Server Performance Tuning
SQL
Server OLAP, DTS, Data Warehouses & Cubes / Analysis Services Training
SQL Design and Information
Retrieval
1.1 What is SQL Server?
SQL Server History
Microsoft Access versus SQL Server: Where to draw the line.
2.1 Installation Issues: Case and Character Set Issues
2.2 Buying the right NT Server
2.3 Configuring SQL Server for Client/Server Systems
2.4 Creating Databases and logs Optimally
2.5 Getting Security Right from the Beginning
2.6 Upsizing and Other tools to get the data in
3.1 Transact SQL Built-In Functions & Other Oddities
3.2 Handling Dates in SQL Server - Ages, Finding Gaps and ranges, Handling times
3.3 Comparing Tables with Full Outer Joins
3.4 OLAP functionality
3.5 Medians, Variance and Standard Deviation
3.6 Running Totals & numbered lists
3.7 Using Correlated Subqueries in the SELECT List
3.8 Navigating Trees with SQL
3.9 Other Techniques
4.1 Clustered versus Non-Clustered indexes
4.2 Using composite indexes and index covering
4.3 Using SHOWPLAN to see if the index is being used.
4.4 Using FILLFACTOR correctly.
4.5 Index Maintenance & Updating Statistics
4.6 Using SQL Trace to determine Client SQL
5.1 Transact SQL Batch and script rules
5.2 Transaction processing commands
5.3 Using Variables
5.4 Control of flow Statements
5.5 Using global variables
5.6 Scrolling through records using SQL and variables
5.7 Using Cursors to scroll through records
5.8 Temporary tables and the EXEC() function.
6.1 The Create Procedure statement
6.2 Compilation problems and methods
6.3 Passing parameters
6.4 Returning Values and Updating Parameters
6.5 Temporary Procedures and AutoStart Procedures
7.1 Basic Trigger assumptions and syntax
7.2 Relationship with constraints
7.3 Using @@Rowcount effectively
7.4 Using Cursors in triggers
8.1 Client-side Development ~ Choosing the Appropriate Tool
8.2 Using Microsoft Access & the Access Upsizing Tool
8.3 Using Visual Basic 5.0
8.4 Using Visual FoxPro.
8.5 Using Visual C++
8.6 Using Visual InterDev
9.1 Using JET/DAO with Linked Tables
9.2 Using JET/DAO with Pass through Queries
9.3 Using the ODBC API
9.4 Using VBSQL
9.5 Using RDO
9.6 Using ODBCDirect
9.7 Using ADO, OLE-DB and future client-side development.
10.1 Establishing connections and ODBC DSNs with SQL Server
10.2 Choosing the right CursorDriver
10.3 Opening resultsets.
10.4 Navigating through resultsets
10.5 Finding Records using DAO/Seek where possible.
11.1 Linking Tables into JET and using Bound forms in Access.
11.2 Using Bound Data Controls in Visual Basic
11.3 Using Updatable resultsets
11.4 Using the Batch Cursor Library
11.5 Using Stored Procedures
12.1 Raising Errors Server-Side
12.2 Pre-emptive error handling in VB Forms
12.3 Error handling and Validation at the Client
13.1 DMO Overview
13.2 Connecting to SQL Server
13.3 Adding to the Devices collection+
13.4 Modifying a property
