| Weeks | Topics |
| 1 |
Entry into the database, database and data modeling, DBMS types and concepts
|
| 2 |
ER model, the presence of a set of assets, attributes, relations concepts, relationship types
|
| 3 |
Key areas, foreign key, descriptive qualities, to be converted to the correlation table
|
| 4 |
Relational database
|
| 5 |
Creating relational algebra and tables in MS Access application, field types, relationship identification, reporting, query and form design
|
| 6 |
The use of structured query language SQL and function
|
| 7 |
Querying data from related tables
|
| 8 |
Midterm
|
| 9 |
Data analysis and multiple tables
|
| 10 |
SQL functions and complex queries
|
| 11 |
DML commands
|
| 12 |
Statements made by the SQL command
|
| 13 |
Database objects
|
| 14 |
User access and control
|