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
|