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