Mastering SQL Server 2000
Mastering SQL Server 2000 is the one indispensable resource for anyone working with the latest version of SQL Server. Whether you build or administer SQL Server databases or write applications that communicate with them, you'll find the background knowledge and the practical instruction you need to accomplish any task, from the most basic to the most advanced. Coverage includes:
- Understanding SQL Server architecture
- Designing an efficient normalized database
- Writing Transact-SQL statements and batches
- Creating databases
- Creating tables and views
- Creating stored procedures and triggers
- Administering SQL Server
- Managing SQL Server security
- Designing applications using ADO, SQL-DMO, and SQL-NS
- Using Data Transformation Services
- Integrating SQL Server with the Internet
- Optimizing SQL Server performance
- Understanding and managing replication
- Using Analysis Services to analyze data
- Using Microsoft English Query
- Troubleshooting common problems
Joseph L. Jorden is an MCSE, MCT, CCNA, and CCDA who has been administering databases for the last seven years. Currently Joseph works independently, consulting and instructing on a variety of technologies.
Table of Contents
PART I: INTRODUCING SQL SERVER.
1. Introduction to SQL Server 2000.
2. Overview of Database Concepts.
3. Overview of SQL Server.
4. Database Design and Normalization.
PART II: TRANSACT-SQL.
5. Transact-SQL Overview and Basics.
6. SELECT Queries.
7. Action Queries.
8. Advanced Transact-SQL.
PART III: DIGGING INTO SQL SERVER.
9. Using SQL Server Enterprise Manager.
14. Stored Procedures.
15. Using Triggers.
PART IV: ADMINISTERING SQL SERVER.
16. Basic Administrative Tasks.
17. Automating Administration.
18. Security and SQL Server 2000.
PART V: DEVELOPMENT WITH SQL SERVER.
19. ADO and SQL Server.
21. SQL Namespace.
22. Data Transformation Services.
23. The Web Assistant Wizard.
24. Integrating SQL Server with Internet Information Server.
PART VI: ADVANCED TOPICS.
26. Monitoring and Optimizing SQL Server 2000.
28. Analysis Services.
29. Microsoft English Query.
Appendix A: Transact-SQL Reference.
Appendix B: Installing Microsoft SQL Server 2000.
Sign up now »
- FTFlash / ActionScript Developer - ContractNSW
- FTLead Software EngineerSA
- FTSenior Python DeveloperNSW
- FTOS Web Applications DeveloperNSW
- FTTechnical Business AnalystNSW
- FTQuality ManagerSA
- FTR&D EngineerSA
- FT.NET - Sitecore Developer - Melbourne - PermNSW
- FTJob Title: Mac Systems/ Enterprise Systems EngineerNZ
The key trend affecting enterprise mobility today can be summarized in four letters: BYOD – Bring Your Own Device. As the number of end-users bringing devices into your organization grows, ...
The nature of work has changed fundamentally and forever and it continues to evolve rapidly. Geographic distance and ...
"Suggesting that people's "purpose is to get information to flow through the ..."
Why change management doesn’t work
"Darn those pesky laws that get in the way of commercial exploitation ..."
Larry Page wants to see your medical records
"Instead of partitioning the device between corporate and personal data, another approach ..."
Dual-Persona Smartphones Not a BYOD Panacea
"Well that's a nice back-handed compliment isn't it? So now, finally, my ..."
After two-year hiatus, EFF accepts bitcoin donations again
"Actually, both Mobile App developers and CIOs should be blamed for it. ..."
CIOs struggle to deliver timely mobile business apps: survey
- Layered defenses largely fail to block exploits, says NSS
- Researchers warn of increased Zeus malware activity this year
- AusCERT 2013: Four dissenters to spur next year's security debates
- AusCERT 2013: Kill the password, says Mozilla
- AusCERT 2013: Unmanaged, unknown privileged logins opening the door for APTs: Cyber-Ark
- Analytics and personalisation drive leading marketer behaviour: Report
- Innovation and big data take centre stage during CMO panel
- Twitter targets second screen interaction with Amplify advertising partnerships
- Facebook talks hyper-targeting, analytics and cross-platform at AANA event
- Tapping into social experience: Tourism Australia