Database Management Systems
A Database Management System (or DBMS), is a software system that is used to create, maintain, and provide controlled access to user database. It provides a systematic method of creating, updating, storing, and retrieving data in a database. Most of today's database systems are referred to as a Relational Database Management System (RDBMS), because of their ability to store related data across multiple tables.
The course/tutorial covers discussion of database systems, the nature of the data, data association, data semantics and data models. A specific DBMS will be used to implement data models for use in business application programs such as:
- Microsoft Access
- Filemaker
- Microsoft SQL Server
- MySQL
- Oracle
Upon completion of this course/tutorial, the student should be able to:
- Design database using data models
- Database creation
- Tables
- Adding data to your database
- Querying a database
- Relational database design
- Use database programming languages to manipulate or process data efficiently
- Perform basic DB administrator’s function
- Understand various implementations of database management systems
The examples in this course/tutorial use MySQL. If you don't have MySQL, you can download a package of Apache, MySQL and PHP here.Instructions on how to configure and install WAMP in Windows likewise should be considered before using WAMP installer through this link.