INF3707
Database Design and Implementation
Study Plan Scope
Block 1
Start: -
End: -
Introduction to databases
Downloading and installing DBMS software
Block 2
Start: -
End: -
How to use mySQL Workbench and development tools
Block 3
Start: -
End: -
How to retrieve data from single table
Block 4
Start: -
End: -
How to retrieve data from two or more tables
Block 5
Start: -
End: -
How to insert, update and delete data from a database
Block 6
Start: -
End: -
How to code summary queries
Block 7
Start: -
End: -
How to code subqueries
Block 8
Start: -
End: -
How to work with datatypes
Block 9
Start: -
End: -
How to use functions
Block 10
Start: -
End: -
How to design databases
Block 11
Start: -
End: -
How to create database tables and indexes
Block 12
Start: -
End: -
How to create views
Block 13
Start: -
End: -
Language skills for writing stored procedures
Block 14
Start: -
End: -
How to use transactions and locking
Block 15
Start: -
End: -
How to create stored procedures and functions
Block 16
Start: -
End: -
How to create triggers and events
Block 17
Start: -
End: -
Database administration (not examined
Block 18
Start: -
End: -
Securing a database (not examined)
Block 19
Start: -
End: -
Backup and restore database (not examined)
Block 20
Start: -
End: -
Hosting a database (not examined)
Lecturer Contacts
- Computing Department
- Role: Department Contact
- Email: computing@unisa.ac.za
- Phone: 0 11 670 9100
- Dr B. Chipangura
- Role: Lecturer
- Email: chipab@unisa.ac.za
- Phone: 0116709106
- Test
- Role: Contact
- Email: test@emial.com
- Phone: 0812312331
Upvote
Downvote
Report issue
Tracking
Download
Prescribed
Prescribed