sql server course: public and custom on-site training course

<body bgcolor="#FFFFFF"> <h1>SQL Server  7 Applications Programming</h1> <h2>SQL Server 7 Training Course Summary</h2> <h2>SQL Server 7 Training Course <strong>Duration</strong></h2> <p class="Blockquote">5 Days</p> <h2>SQL Server 7 Training Course <strong>Objectives</strong></h2> <p class="Blockquote">This course provides an intensive hands-on introduction to developing client/server systems within an SQL-Server environment. It includes advanced SQL queries, stored procedures and triggers and the client access methods available for developing "front-ends". The Client-side programming focuses on Visual Basic, although other client-side platforms are discussed too.</p> <h2><strong>Who Should Attend </strong>SQL Server 7 Training Course </h2> <p class="Blockquote"><font SIZE="2">Programmers looking to gain the skills to develop commercial SQL Server applications.</font></p> <h2><strong>Pre Requisite Skills</strong></h2> <p class="Blockquote"><font SIZE="2">SQL and RDBMS Programming skills. </font></p> <h2><strong>Associated </strong>SQL Server 7 <strong>Training Course(s)</strong></h2> <p class="Blockquote"><a href="sql-server-2000-training-uk.html" target="_self">SQL Server 2000</a></p> <h2>SQL Server 7 Course Outline</h2> <h3>1. SQL Server & Client/Server Overview</h3> <p class="BodyText">1.1 What is SQL Server? <ul> <li><p class="BodyText">SQL Server History </p> </li> <li><p class="BodyText">Microsoft Access versus SQL Server: Where to draw the line.</p> </li> </ul> <h3>2 Creating & Configuring SQL Server for Client/Server Systems </h3> <p class="BodyText">2.1 Installation Issues: Case and Character Set Issues</p> <p class="BodyText">2.2 Buying the right NT Server</p> <p class="BodyText">2.3 Configuring SQL Server for Client/Server Systems</p> <p class="BodyText">2.4 Creating Databases and logs Optimally</p> <p class="BodyText">2.5 Getting Security Right from the Beginning</p> <p class="BodyText">2.6 Upsizing and Other tools to get the data in</p> <h3>3. Advanced SQL Queries</h3> <p class="BodyText">3.1 Transact SQL Built-In Functions & Other Oddities </p> <p class="BodyText">3.2 Handling Dates in SQL Server - Ages, Finding Gaps and ranges, Handling times </p> <p class="BodyText">3.3 Comparing Tables with Full Outer Joins</p> <p class="BodyText">3.4 OLAP functionality</p> <p class="BodyText">3.5 Medians, Variance and Standard Deviation</p> <p class="BodyText">3.6 Running Totals & numbered lists</p> <p class="BodyText">3.7 Using Correlated Subqueries in the SELECT List</p> <p class="BodyText">3.8 Navigating Trees with SQL</p> <p class="BodyText">3.9 Other Techniques</p> <h3>4. Indexes and Query optimisation</h3> <p class="BodyText">4.1 Clustered versus Non-Clustered indexes</p> <p class="BodyText">4.2 Using composite indexes and index covering</p> <p class="BodyText">4.3 Using SHOWPLAN to see if the index is being used.</p> <p class="BodyText">4.4 Using FILLFACTOR correctly.</p> <p class="BodyText">4.5 Index Maintenance & Updating Statistics </p> <p class="BodyText">4.6 Using SQL Trace to determine Client SQL </p> <h3>5. Programming with Transact SQL</h3> <p class="BodyText">5.1 Transact SQL Batch and script rules</p> <p class="BodyText">5.2 Transaction processing commands</p> <p class="BodyText">5.3 Using Variables</p> <p class="BodyText">5.4 Control of flow Statements</p> <p class="BodyText">5.5 Using global variables</p> <p class="BodyText">5.6 Scrolling through records using SQL and variables</p> <p class="BodyText">5.7 Using Cursors to scroll through records</p> <p class="BodyText">5.8 Temporary tables and the EXEC() function.</p> <h3>6. Writing Stored Procedures</h3> <p class="BodyText">6.1 The Create Procedure statement</p> <p class="BodyText">6.2 Compilation problems and methods</p> <p class="BodyText">6.3 Passing parameters</p> <p class="BodyText">6.4 Returning Values and Updating Parameters</p> <p class="BodyText">6.5 Temporary Procedures and AutoStart Procedures</p> <h3>7. Implementing Triggers</h3> <p class="BodyText">7.1 Basic Trigger assumptions and syntax</p> <p class="BodyText">7.2 Relationship with constraints </p> <p class="BodyText">7.3 Using @@Rowcount effectively </p> <p class="BodyText">7.4 Using Cursors in triggers</p> <h3>8. Client-Side SQL Server Development - Overview </h3> <p class="BodyText">8.1 Client-side Development ~ Choosing the Appropriate Tool </p> <p class="BodyText">8.2 Using Microsoft Access & the Access Upsizing Tool </p> <p class="BodyText">8.3 Using Visual Basic 5.0</p> <p class="BodyText">8.4 Using Visual FoxPro.</p> <p class="BodyText">8.5 Using Visual C++</p> <p class="BodyText">8.6 Using Visual InterDev</p> <h3>9. Visual Basic Access Methods</h3> <p class="BodyText">9.1 Using JET/DAO with Linked Tables</p> <p class="BodyText">9.2 Using JET/DAO with Pass through Queries</p> <p class="BodyText">9.3 Using the ODBC API</p> <p class="BodyText">9.4 Using VBSQL</p> <p class="BodyText">9.5 Using RDO</p> <p class="BodyText">9.6 Using ODBCDirect</p> <p class="BodyText">9.7 Using ADO, OLE-DB and future client-side development. </p> <h3>10. Retrieving Data to the Client</h3> <p class="BodyText">10.1 Establishing connections and ODBC DSNs with SQL Server</p> <p class="BodyText">10.2 Choosing the right CursorDriver</p> <p class="BodyText">10.3 Opening resultsets.</p> <p class="BodyText">10.4 Navigating through resultsets </p> <p class="BodyText">10.5 Finding Records using DAO/Seek where possible.</p> <h3>11. Updating Data through the client</h3> <p class="BodyText">11.1 Linking Tables into JET and using Bound forms in Access.</p> <p class="BodyText">11.2 Using Bound Data Controls in Visual Basic</p> <p class="BodyText">11.3 Using Updatable resultsets</p> <p class="BodyText">11.4 Using the Batch Cursor Library</p> <p class="BodyText">11.5 Using Stored Procedures</p> <h3>12. Handling Errors</h3> <p class="BodyText">12.1 Raising Errors Server-Side</p> <p class="BodyText">12.2 Pre-emptive error handling in VB Forms</p> <p class="BodyText">12.3 Error handling and Validation at the Client</p> <h3>13. Using DMO to build Server-Side SQL Server Apps</h3> <p class="BodyText">13.1 DMO Overview</p> <p class="BodyText">13.2 Connecting to SQL Server</p> <p class="BodyText">13.3 Adding to the Devices collection+</p> <p class="BodyText">13.4 Modifying a property</p> <h2 class="centred">SQL Server 7 Training Course - JB International, London, UK</h2> <h2 class="centred">0800 028 640</h2> <p align="center"><a href="index.html" target="_top">JB International Home Page</a></p> <p align="center"><a href="courses.html" target="_self">Full Course Listing</a></p>  <script type="text/javascript" language="javascript"> var sc_project=582355; var sc_invisible=1; var sc_partition=4; var sc_security="c24ee6c6"; </script> <script type="text/javascript" language="javascript" src="http://www.statcounter.com/counter/frames.js"></script><noscript><a href="http://www.statcounter.com/" target="_blank"><img src="http://c5.statcounter.com/counter.php?sc_project=582355&java=0&security=c24ee6c6&invisible=1" alt="hit counter code" border="0"></a> </noscript>  </body>