SQL Server 2000 Training Course - London, UK: public and custom on-site training course

<body bgcolor="#FFFFFF"> <h1><font face="Arial">SQL Server 2000 Training Course Summary</font></h1> <h3><strong>SQL Server 2000 Training Course Objectives</strong></h3> <p class="BodyText">This SQL Server 2000 training course has been written to cover all the main aspects of building applications using Microsoft's latest database technology. The key focus is on server database design and implementation using Microsoft SQL Server 2000 but it also covers some client development, focusing on three Microsoft technologies: Access 2000's new ADP format, Visual Basic using ADO and ASP with XML.</p> <p class="BodyText">The general objective of the course is to design a server-side database, implement all the tables and indexes, implement server-side validation through rules and triggers and build stored procedures to put complex parts of the application server-side. Then three different client platforms are used to build front-ends to the application: using Access 2000, Visual Basic and Front Page. Available as a public or closed course at our London training centre, or can be tailored to your team's requirements and delivered onsite as a bespoke, customised training course.</p> <h3><strong>Who Should Attend the SQL Server 2000 Training Course</strong></h3> <p class="BodyText">Developers using Microsoft SQL Server 2000</p> <h3><strong>Pre Requisite Skills to attending the SQL Server 2000 Training Course</strong></h3> <p class="BodyText">SQL and RDBMS Programming skill.</p> <p><a href="sqlserver-outline.html">Click here for SQL Server 7 outline </a></p> <h1><font face="Arial">SQL Server 2000 Training Course Outline</font></h1><h3><b> <font SIZE="4">1</font><font FACE="MS Sans Serif" SIZE="4"> </font><font SIZE="4">Microsoft SQL Server 2000 Overview & History</font></b></h3> <font FACE="Arial" SIZE="2"><p class="Blockquote">Relational Database Overview</p> <p class="Blockquote">SQL Server Evolution</p> <p class="Blockquote">The 2000 Release & it's new features</p></font> <h3><font SIZE="4"><b>2 Data Storage & Management</b></font></h3> <font FACE="Arial" SIZE="2"><p class="Blockquote">How is data organised in SQL Server & NT </p> <p class="Blockquote">Creating Databases </p> <p class="Blockquote">Using File groups to Position Objects </p> <p class="Blockquote">Shrinking databases.</p></font> <h3><font SIZE="4"><b>3 Designing Tables with integrity</b></font></h3> <font FACE="Arial" SIZE="2"><p class="Blockquote">Designing Tables Through the Database Diagram </p> <p class="Blockquote">Creating Tables through Enterprise Manager and the basic CREATE TABLE syntax </p> <p class="Blockquote">SQL Server Data types </p> <p class="Blockquote">Calculated columns and user-defined data types</p> <p class="Blockquote">Table enforced constraints and Rules</p> <p class="Blockquote">The IDENTITY property </p> <p class="Blockquote">Setting up Referential Integrity</p></font> <h3><font SIZE="4"><b>4 Transact SQL</b></font></h3> <font FACE="Arial" SIZE="2"><p class="Blockquote">Querying Microsoft SQL Server 7.0 Tables </p> <p class="Blockquote">Basic Transact SQL queries </p> <p class="Blockquote">Transact SQL built-in Functions </p></font> <p class="Blockquote"><font FACE="Arial" SIZE="2">Advanced Querying tricks and techniques</font></p><font FACE="Arial" SIZE="2"> <p class="Blockquote">Querying linked servers and other remote data sources</p> <p class="Blockquote">Full-Text Searching</p></font> <h3><font SIZE="4"><b>5 Indexes</b></font></h3> <font FACE="Arial" SIZE="2"><p class="Blockquote">The query optimiser</p> <p class="Blockquote">Index types in SQL Server 2000</p> <p class="Blockquote">Creating Indexes</p> <p class="Blockquote">Using composite indexes for index covering</p> <p class="Blockquote">Analysing index use and optimising SQL Server 2000 indexes</p> <p class="Blockquote">Using optimiser hints effectively</p></font> <h3><font SIZE="4"><b>6 Making best use of Views </b></font></h3> <font FACE="Arial" SIZE="2"><p class="Blockquote">The Uses of Views </p> <p class="Blockquote">Using Calculated Columns </p> <p class="Blockquote">Creating views</p> <p class="Blockquote">Indexed Views</p></font> <h3><font SIZE="4"><b>7 Transaction Programming in SQL Server</b></font></h3> <font FACE="Arial" SIZE="2"><p class="Blockquote">How data is changed in SQL Server 2000</p> <p class="Blockquote">Inserting, copying, changing & removing records </p> <p class="Blockquote">Transaction processing commands </p> <p class="Blockquote">Distributed Transactions </p> <p class="Blockquote">Locking Issues, transaction isolation levels and locking 'hints'</p></font> <h3><font SIZE="4"><b>8 Programming with Transact SQL</b></font></h3> <font FACE="Arial" SIZE="2"><p class="Blockquote">The Query Analyzer as a developer's environment </p> <p class="Blockquote">Transact SQL Batch and script rules </p> <p class="Blockquote">Using Variables and control of flow statements </p> <p class="Blockquote">Using Global Variables </p> <p class="Blockquote">Using The EXEC() function. </p> <p class="Blockquote">Error Handling </p> <p class="Blockquote">Using Cursors</p></font> <h3><font SIZE="4"><b>9 Writing Stored Procedures and User-Defined Functions</b></font></h3> <font FACE="Arial" SIZE="2"><p class="Blockquote">SQL Server 2000 Query caching & related issues</p> <p class="Blockquote">Uses for Stored Procedures & User-Defined functions</p> <p class="Blockquote">A useful UDF. </p> <p class="Blockquote">Compilation problems and methods </p> <p class="Blockquote">Stored procedures parameters </p> <p class="Blockquote">Returning values and updating parameters </p> <p class="Blockquote">Temporary procedures and AutoStart Procedures</p></font> <h3><font SIZE="4"><b>10 Implementing Triggers</b></font></h3> <font FACE="Arial" SIZE="2"><p class="Blockquote">Basic Trigger assumptions and syntax </p> <p class="Blockquote">Uses for triggers </p> <p class="Blockquote">AFTER triggers and INSTEAD OF triggers </p> <p class="Blockquote">Nested Triggers </p> <p class="Blockquote">Changing the order of trigger execution </p> <p class="Blockquote">Disabling Triggers</p></font> <h3><font SIZE="4"><b>11 Using DTS and writing server-based applications</b></font></h3> <font FACE="Arial" SIZE="2"><p class="Blockquote">DTS Overview </p> <p class="Blockquote">Building DTS packages with ActiveScript</p> <p class="Blockquote">The DTSObjects library and how to manipulate it</p> <p class="Blockquote">SQL Server's own library - DMO (Distributed Management Objects)</p> <p class="Blockquote">Using DMO</p></font> <h3><font SIZE="4"><b>12 Fast Client-Server Development using Microsoft Access 2000</b></font></h3> <font FACE="Arial" SIZE="2"><p class="Blockquote">Rapid Application development with Microsoft Access 2000</p> <p class="Blockquote">Access Project Concepts</p> <p class="Blockquote">Upsizing from Jet to Microsoft SQL Server</p> <p class="Blockquote">Converting DAO to ADO</p> <p class="Blockquote">Building scalable solutions with MSDE</p></font> <h3><font SIZE="4"><b>13 VBA programming using ActiveX Data Objects and other methods</b></font></h3> <font FACE="Arial" SIZE="2"><p class="Blockquote">What is OLE-DB? </p> <p class="Blockquote">The ActiveX Data Object Model </p> <p class="Blockquote">Connection Management </p> <p class="Blockquote">ADO Resultsets </p> <p class="Blockquote">ADO Commands</p> <p class="Blockquote">DAO and Jet</p> <p class="Blockquote">RDO.</p></font> <h3><font SIZE="4"><b>14 Web-based SQL Server Front Ends</b></font></h3> <font FACE="Arial" SIZE="2"><p class="Blockquote">Using Microsoft Access 2000 and Front Page to build data-driven web-pages</p> <p class="Blockquote">Building data-driven web pages using Active Server Pages </p> <p class="Blockquote">XML overview </p> <p class="Blockquote">Driving web-pages with SQL Server data using XML</p> </font><h3><font SIZE="4"><b>15 Data Warehousing with Microsoft SQL Server's Analysis Services</b></font></h3> <font FACE="Arial" SIZE="2"><p class="Blockquote">Introduction to Data Warehousing and Analysis Services</p> <p class="Blockquote">Designing a Database for OLAP </p> <p class="Blockquote">Using Data Transformation Services to Populate the Warehouse </p> <p class="Blockquote">Using Analysis Manager to create Cubes </p> <p class="Blockquote">Browsing Cubes and the PivotTable Service </p> <p class="Blockquote">Programming Analysis Services: An introduction to MDX and DSO </p> <p class="Blockquote">Maintaining Data Warehouses</p></font> <h1 class="centred"><strong><font face="Arial">SQL Server 2000 Training Course</font></strong></h1> <h1 class="centred"><strong><font face="Arial">JB INTERNATIONAL, London, UK</font></strong></h1> <h1 class="centred"><strong><font face="Arial">0800 028 6400       </font></strong></h1> <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> </body>