 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft SQL Server 2000 Programming Part 2
Course Aims
This course along with our "Microsoft SQL Server 2000 Programming Part 1" course will introduce readers to the major topics of building database applications with Microsoft SQL Server 2000. The key focus of the course is on server database design and implementation using SQL Server 2000, but it also covers some client development - including Access 2000's ADP format, Visual Basic using ADO, and ASP with XML. The course will help readers to design and implement a server-side database, implement all the tables and indexes, implement server-side validation through rules and triggers and to build stored procedures to put complex parts of the application server-side. Three different client platforms - Access 2000, Visual Basic and Front Page - are used to build front-ends for the application. |
Assumed Knowledge
A good working knowledge of the SQL interface, table creation, basic query and report writing functions, macro development and relational database concepts gained from practical experience in developing simple applications with another RDBMS is assumed. Previous programming experience is essential. You should have also completed our "Microsoft SQL Server 2000 Programming Part 1" course.
|
Course Audience
This course has been created for readers who are using or planning to use SQL Server 2000 in their applications or who wish to take the Microsoft Certified Professional exam for SQL Server. It should be useful both to people that are new to SQL Server and to those who have experience with an earlier version. |
|
Table of Contents
|
Rapid Client-Side Development with Microsoft Access 2000
|
Microsoft Access - The Perfect Partner for SQL Server
|
|
Upsizing Access Applications to Microsoft SQL Server 2000
|
|
|
|
Introduction to VBA Programming
|
The VBA Programming Environment
|
|
Functions and Subroutines
|
|
Programming in the VBA Language
|
|
Using Variables and Expressions
|
|
Branching and Looping Commands
|
|
Line Continuation Character
|
|
Using Arrays and Collections
|
|
Optional and Named Arguments
|
|
Writing Useful Error Handlers
|
|
|
|
Writing the Code Behind Access Forms
|
Using Form Events to Build GUIs
|
|
Code Behind Forms and Class Modules
|
|
GUI Problems and Solutions
|
|
|
Data Access through ADO
|
Bound versus Unbound Forms
|
|
The ActiveX Data Object Model
|
|
Working with Objects and Collections
|
|
Example of ADO Through a Simple ASP Page
|
|
|
|
Programming with DTS Object Library and DMO
|
Data Transformation Services
|
|
Using the DTSPackage Object Library
|
|
Distributed Managements Objects
|
|
Creating/Modifying Databases Through DMO
|
|
|
|
Web-Based SQL Server Front-ends
|
Static Web Pages - an HTML Primer
|
|
Generating Web Pages from SQL Server
|
|
|
|
Data Warehousing With SQL Server's Analysis Services
|
Introduction to Data Warehousing
|
|
Designing a Database for OLAP
|
|
Using Data Transformation Services to Populate the Warehouse
|
|
Using OLAP Manager to Create Cubes
|
|
Browsing Cubes and the PivotTable Service
|
|
|
|
|
|
