MYSQL (TECHNICIAN COURSE IN IT ) VIDEO TUTORIALS SWAHILI LANGUAGE

TECHNICIAN CERTIFICATE AND DIPLOMA IN IFNRORMATION TECHNOLOGY:

INTRODUCTION TO DATABASE PRINCIPLES (MYSQL)

NONE STUDENTS ARE NOT ALLOWED
prepared by: shamir suleman
phone: +255-656-848274
dodoma tanzania

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)

..

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