About This Book
Chapter1 Overview of SQL Server
lesson 1:What is SQL Server
lesson 2:SQL Server Components
lesson 3:SQL Server Architecture Overview
lesson 4:SQL Server Security Overview
Review
Chapter2:Overview of Transact-SQL
lesson 1:SQL Server Programming Tools
lesson 2:Elements of Transact-SQL
lesson 3:Waysto Execute Transact-SQL Statements
Chapter3 Creating Databases
lesson 1:Introduction to Database Design
lesson 2:Introduction to SQL Server Databases
lesson 3:Creating and Dropping Databases
lesson 4:Managing Databases
lesson 5:The library Database
Review
Chapter4 Creating Database Objects
lesson 1:Creating Data Types
lesson 2:CReating Tables
lesson 3:Generating Scripts
Review
Chapter 5 Implementing Data Integrity
lesson 1:Types of Data Integrity
lesson 2:Using Constraints
lesson 3:Using Defaults and Rules
Review
Chapter 6:Planning and Creating Indexes
lesson 1:Introduction to Indexes
lesson 2:Index Architecture
lesson 3:Creating Indexes
Review
Chapter 7 Maintaining Indexes
lesson 1:Maintaining Indexes
lesson 2:Statistical Information
lesson 3:Full-Text Search
Review
Chapter 8 Querying Multiple Tables
lesson 1:Combining Data from Multiple Tables
lesson 2:Advanced Joins
Review
Chapter 9:Advanced Query Techniques
lesson 1:Subqueries
lesson 2:Using Cursors
lesson 3:Modifying Data
review
Chapter 10 Summarizing Data
lesson 1:Using Aggregate Functions
lesson 2:GROUP BY Fundamentals
lesson 3:Generating Aggregate Values within Result Sets
Review
Chapter 11 Implementing Views
lesson 1:Introduction to Views
lesson 2:Creating,Altering ,and Dropping Views
lesson 3:Advanced Topics
Review
Chapter 12 Managing Transactions and locks
lesson 1:Managing Transactions
lesson 2:SQL Server Locking
lesson 3:Managing locks
Review
Chapter 13 Working with Distributed Data
lesson 1:using External Data Sources
lesson 2:Working with Distributed Data
lesson 3:Excuting a Query on a Linked Server
Review
Chapter 14:Implementing Stored Procedures
lesson 1:Introduction to Stored Procedures
lesson 2:Creating,EXecuting,and Modifying Stored Procedures
lesson 3:Using Parameters and Error Messages
Review
Chapter 15 Implementing Triggers
lesson 1: Introducing Triggers
lesson 2: How Triggers Work
Appendices
Appendix A Questions and Answers
Appendix B Library Database CASe Study
Appendix C Database Schemas
Appendix D Performing Basic Queries
lesson 1:Retrieving Data
lesson 2:Modifying Data
Review
Glossary
Index
鄂公网安备 42010302001612号 