This is a beginner's guide to SQL Server 7 providing the core information needed to work within relational databases and serves as the entry point for all those making the transition or upgrade to SQL Server Version 7 - from here one can next learn how to build the actual database.
Part I: SQL Server: Basic Concepts. Database Systems and SQL Server. SQL Server Enterprise Manager and Query Analyzer. Part II: Transact-SQL Language. SQL Components. Data Definition Language. Simple Queries. Complex Queries. Modification of a Tables Contents. SQL Extensions and Stored Procedures. Views. Indices and Query Optimization. System Catalog. SQL Server Security. Triggers. Transactions. SQL Server System Environment. Part III: SQL Server: System Administration. Overview of System Administration. Planning and Completing the Installation of SQL Server. Managing Databases and Database Files. Managing Security. Backup and Recovery. Data Transfer. Automating System Administration Tasks. Troubleshooting SQL Server. Performance and Tuning. Data Replication. Part IV: Microsoft Decision Support Services. Data Warehousing--An Introduction. Client Components for MS Decisions Support Services. Server Components in Microsoft Decision Support Services. Appendix: A: SQL Server Keywords.
