| |
| |
| Table of Contents | |
| |
| |
| |
| Introduction to Databases Overview of Databases | |
| |
| |
| The Database Development LIfe Cycle | |
| |
| |
| Entity Relationship Modeling | |
| |
| |
| Using an ER Model to Define Relational Database Tables | |
| |
| |
| |
| Creating SQL Server Databases Database System Architectures | |
| |
| |
| SQL Server 2005 DBMSsand Client Applications | |
| |
| |
| SQL Server Database Objects | |
| |
| |
| Creating and Managing Databases | |
| |
| |
| Creating Database Tables | |
| |
| |
| Deleting Database Tables | |
| |
| |
| Modifying Existing Database Tables | |
| |
| |
| |
| Creating SQL Queries to View Database Data Sample Databases | |
| |
| |
| Using SQL Queries to Retrieve Database Data | |
| |
| |
| Using Arithmetic Operations in Queries | |
| |
| |
| Using In-Line Functions in Queries | |
| |
| |
| Using Aggregate Functions in Queries | |
| |
| |
| Formatting Query Output | |
| |
| |
| Retrieving Data From Multiple Tables | |
| |
| |
| Creating Nester Queries | |
| |
| |
| Database Views | |
| |
| |
| Performing Set Operations in Queries | |
| |
| |
| |
| SQL Action Queries and T-SQL Scripts Inserting, Updating, and Deleting Database Data | |
| |
| |
| Database Transactions and Locking/Blocking | |
| |
| |
| T-SQL Programming | |
| |
| |
| Stores Procedures | |
| |
| |
| User-defined Functions | |
| |
| |
| Triggers | |
| |
| |
| |
| Introduction to Visual Basic and the Visual Basic Integrated Development Environment | |
| |
| |
| Net Framework | |
| |
| |
| Using the VB Integrates Development Environment (IDE) | |
| |
| |
| VB Programming Fundamentals | |
| |
| |
| Controlling Program Flow | |
| |
| |
| User-Defined Procedures | |
| |
| |
| |
| Creating VB .NET Database Applications Accessing Data in .Net | |
| |
| |
| Creating and Managing Data Access Components in the VB IDE | |
| |
| |
| Common Database Interfaces | |
| |
| |
| Working with Data-Bound Controls | |
| |
| |
| Using Program Commands to Manipulate Data | |
| |
| |
| Creating a Form Combining Data-Bound Controls and Program Commands | |
| |
| |
| Retrieving Data Synchronously | |
| |
| |
| |
| Creating Database Reports Common Database Report Layouts | |
| |
| |
| Creating A Single-Table Tabular Report | |
| |
| |
| Creating a Report That Displays Data From Multiple Tables | |
| |
| |
| Creating a Master-Details Report with Multiple Master-Detail Relationships | |
| |
| |
| Adding Summary and Formula Fields to a Report | |
| |
| |
| Creating a Report That Accepts an Input Parameter | |
| |
| |
| |
| Creating Web-based Database Applications Using ASP.NET Introduction to the World Wide Web | |
| |
| |
| Web Addressing Concepts | |
| |
| |
| HyperText Markup Language | |
| |
| |
| Introduction to ASP.NET.Creating Web Database Forms | |
| |
| |
| |
| Using XML in Database Applications Introduction to XML | |
| |
| |
| Creating SQL Server Queries to Retrieve XML-Formatted Data | |
| |
| |
| Extensivke Stylesheet Language Transformation (XSLTs) | |
| |
| |
| Creating and Processing XML Documents Using Data Sets | |
| |
| |
| Using .NET Program Commands to Create XML Files and Add XML Elements | |
| |
| |
| Sharing XML Data Using XML Web Services | |
| |
| |
| |
| SQL Server Database Administration SQL Server Database Management Tools | |
| |
| |
| Database Indexing | |
| |
| |
| Security and User Authentication | |
| |
| |
| Backup and Recovery | |
| |
| |
| Deploying Database Applications | |
| |
| |
| |
| Configuring a client/server SQL Server application development environment | |
| |
| |
| |
| Configuring a SQL Express development environments | |