INTRODUCTION TO DATABASE PRINCIPLES (MYSQL)

 TECHNICIAN CERTIFICATE  AND DIPLOMA IN IFNRORMATION TECHNOLOGY: 

INTRODUCTION TO DATABASE PRINCIPLES (MYSQL)

NONE STUDENTS  ARE NOT ALLOWED

 introduction PLAY

NOTE:   USE KNOWLEDGE OF MICROSOFT ACCESS TO EXPLAIN MSQL INTRODUCTION HAVE THE SAME MEANING

-introduction to microsoft access database
-what are primary keys
-database  types
-relational database management system(RDBMS)
-table properties
-field properties
-enforcing referential integrity
-table relation ship types
-data type
-microsoft access objects
-table (parent table, child table)

.. lecture one

1.  creating the first database
2.  delete database
3. create again database
4. creating table
5.input data in the database
6.enter primary key
7. filtering commands in the database
8.table attributes
9. field properties

1. create admin password in the database
2. create users in the database
3. drop user in the database
4. view user in the database
5. rename user in the database
6. change user password in the database

1. access  and  mysql  databases
2. SQL  and GUI

is prepared wait until  16/02/2017
lecture six

is prepared wait until   16/02/2017

do not sale or burn on the CD  any of tutorial  without owner permission