Home

Database Basics

This tutorial provides a basic overview of database systems and its particular use in web applications. The lessons here will also focus on SQL and database programming.

In This Guide:

01 - Database - File Information Digitally
An introduction on database concepts
02 - The ER Model and Database Design
The logical view of a database
03 - Databases: Creation and Normalization
The various method of creating a database
04 - Databases - Architecture, Management, and Programming
This chapter focuses on the concepts of structuring, building and managing databases
05 - SQL - Getting Information from a Database
How the SQL works for a more complex database
06 - SQL- Putting Information into the Database
How to add, modify and delete tables and its contents
07 - SQL - Views, Combining Tables, and Built-In Functions
How to get data from one table at one time
08 - Database Programming
How to group queries together to do things in sequence
09 - Database Programming - ODBC and the Web
A deeper understanding of database programming
10 - Databases - A brief look at Security, Optimization, Monitoring, and Troubleshooting
A closer look at some database fundamentals