Introduction: introduction to SQL Server 2000. Part 1 Mastering T-SQL: database definitions basics; database definition advanced; data manipulation Basics; advanced statement features; writing stored procedures and triggers; extended stored procedures. Part 2 Windows applications: using ActiveX data objects; using ODBC; using Database Access Objects (DAO); using ODBCDirect; using Remote Data Objects (RDO); using DB-library. Part 3 Web applications: integrating SQL server and IIS for web/database development; using Active Server Pages (ASP); using SQL Server Web Wizard. Part 4 Desktop applications: development using Access 2000; development using Excel 2000. Part 5 Management, replication and analysis applications: SQL-DMO; replication; DTS; MDX/ADOMD. Part 6 Administration for the developer: managing serves; managing databases and objects; security; backup; application performance troubleshooting. Part 7 relational database concepts: intrlational database management systems; database design; entity-relationship diagramming. Appendices: maximums; administrative tools; system stored procedures reference; using English query; tips for Oracle developers.
