| |
| |
| Preface | |
| |
| |
| |
| Database Basics | |
| |
| |
| What Is a Database? | |
| |
| |
| What Is a Database Platform? | |
| |
| |
| Business Cases | |
| |
| |
| |
| Introducing Jones Novelties, Incorporated | |
| |
| |
| Tables and Fields | |
| |
| |
| Designing Your Database | |
| |
| |
| |
| Designing Tables and Relationships | |
| |
| |
| Manipulating Data with Objects | |
| |
| |
| Data Types | |
| |
| |
| Creating a Database Schema | |
| |
| |
| Using Visual Studio to Create a Database | |
| |
| |
| Designating Indexes and the Primary Key | |
| |
| |
| Creating Database Diagrams | |
| |
| |
| Using Microsoft Visio to View and Alter a Database Schema | |
| |
| |
| Relationships | |
| |
| |
| Using Referential Integrity to Maintain Consistency | |
| |
| |
| Testing Referential Integrity Constraints, Using Server Explorer | |
| |
| |
| Cascading Updates and Cascading Deletes | |
| |
| |
| Normalization | |
| |
| |
| One-to-One Relationships | |
| |
| |
| One-to-Many Relationships | |
| |
| |
| Many-to-Many Relationships | |
| |
| |
| Creating a User Interface in a Windows Forms Application | |
| |
| |
| Connecting to a Database and Working with Records | |
| |
| |
| Creating a Data Browser Application | |
| |
| |
| Performing Binding Programmatically | |
| |
| |
| About Data-Aware Controls in .NET | |
| |
| |
| Updating Records in the Data Browser Application | |
| |
| |
| Creating New Records in a Data-Bound Form | |
| |
| |
| Deleting Records from a Data-Bound Form | |
| |
| |
| Validating Data Entry in a Data-Bound Form | |
| |
| |
| Validation at the Database Engine Level | |
| |
| |
| Summary | |
| |
| |
| Questions and Answers | |
| |
| |
| |
| Structured Query Language Queries and Commands | |
| |
| |
| What is a Query? | |
| |
| |
| Testing Queries with the Server Explorer | |
| |
| |
| Retrieving Records with the SELECT Clause | |
| |
| |
| Designating a Record Source with the FROM Clause | |
| |
| |
| Specifying Criteria with the WHERE Clause | |
| |
| |
| Operators in WHERE Clauses | |
| |
| |
| Sorting Results with ORDER BY | |
| |
| |
| Sorting in Descending Order | |
| |
| |
| Sorting on Multiple Fields | |
| |
| |
| Displaying the Top or Bottom of a Range with TOP | |
| |
| |
| Creating Top Percentage Queries | |
| |
| |
| Joining Related Tables in a Query | |
| |
| |
| Expressing a Join in SQL | |
| |
| |
| Using Outer Joins to Return Additional Data | |