Section 1: An introduction to SQLAfter chapter 1 presents the concepts and terms you need for working with relational databases and SQL, chapter 2 shows you how to use the Microsoft SQL Server 2000 Desktop Engine (MSDE) and the SQL Server client tools to run SQL statements on your own PC. Section 2: The essential SQL skillsEverything a programmer needs to know about querying a database to retrieve the data that's needed and using insert, update and delete statements to update the data in a database. That includes the use of inner and outer joins, summary queries, subqueries, data types, functions, and much more. Section 3: Database design and implementationLearn how to design a database and normalize that design. Then, learn how to implement that design by using either SQL DDL statements or the Enterprise Manager. Section 4: Advanced SQL skillsLearn how to get the maximum benefit from a database management system by using features like views, stored procedures, functions, triggers, cursors, transactions, locking, and security.
