Part 1 Managing SQL Server: introduction - brief overview of relational databases; brief history of SQL Server; new features in Release 7.0; SQL SQL Server fundamental concepts - SQL Server's client/server model, SQL Server basic components, servers, databases, devices, transact-SQL, administrator, command-line utilities; SQL Server administration - using the SQL Enterprise Manager, starting and stopping SQL Server, installing clients, creating databases, creating tables, SQL Server data types, creating indexes, creating views, using transact SQL, creating stored procedures, importing and exporting data; SQL Server security - SQL Server security concepts, standard security, integrated security, using the SQL Security Manager, adding administrators, adding and dropping users, adding and dropping groups, securing databases, securing table and views, securing columns, using permissions, restricting access through views; SQL Server backup and recovery - using checkpoints, backing-up and restoring databases, back-up and restoring transaction logs, using removable media; data warehousing with SQL Server - SQL Server replication fundamentals, system requirements, replication model, publisher, distributor, subscriber, the pushing model, the pulling model, setting up SQL Server data replication, setting up publishing, setting up a subscriber, publishing to ODBC data sources; performance tuning SQL Server - sizing a database, putting tembdb in RAM, caching, indexing, using ShowPlan, using stored procedures, NT Performance Monitor; advanced management using SQL DMO - the DMO architecture, application, SQL Server, database, tables, sample DMO application - export tables, adding the SQL OLE reference to VB, enumerating collections. Part 2 Database development with SQL Server: introduction to relational databases; an SQL primer; developing applications with VB and DAO; developing applications with ODBC; developing applications with VB and RDO; developing applications with VB library OCX; developing Internet applications. (Part contents)
