INTRODUCTION TO RDBMS / SQL

Background:
Databases are today an integral part of most information systems. Database approach offers a number of important and practical advantages to an organization. Reducing redundancy improves the consistency of data while reducing the waste in storage space. Sharing data often permits new data processing applications to be developed without having to create new data files. In general, less redundancy and greater sharing lead to less confusion between organizational units and less time spent resolving errors and inconsistencies reports. The data base approach also permits centralized control over data standards, security restrictions, and integrity controls. This facilitates the natural evolution and change of information systems and organizations. It encourages the use of powerful query language by users who have no previous programming experience. The database approach promotes the data independence, which insulates application programs from modifications to the database itself.

Objectives:
After completion of this programme, participants will be able to:

• Use MySQL database for storing required information

• Use Structured Query Language (SQL) to retrieve information required from the database

• Understand the importance of programming in MySQL

Contents:
· Introduction to RDBMS

· Data Modeling and Database Designing

· SQL Commands using MySQL

· Built-in functions in MySQL

· Loading data from text file to MySQL

· Programming in MySQL