Code | Lecturer(s) | Associate Lecturer(s) | Subsitute Lecturer(s) et other(s) |
---|---|---|---|
S-INFO-100 |
|
Language of instruction | Language of assessment | HT(*) | HTPE(*) | HTPS(*) | HR(*) | HD(*) | Term |
---|---|---|---|---|---|---|---|
Français | Français | 0 | 15 | 0 | 0 | 0 | Q1 |
Contents
Relational databases.
Basic SQL instructions.
MySQL environment.
Data selection and sorting, junction tables, functions, groups.
Subqueries (simple, complex, correlated)
Data manipulation language, transactions, constraints.
Views.
Security basics.
Required Reading
Required Learning Resources/Tools
Not applicable
Recommended Reading
Recommended Learning Resources/Tools
www.mysql.org
Other Recommended Reading
Not applicable
Mode of delivery
- Face to face
Term 1 Assessment - type
- Written examination
Term 1 Assessment - comments
Written examination with lecture notes available.
Term 2 Assessment - type
- N/A
Term 2 Assessment - comments
Not applicable
Term 3 Assessment - type
- Written examination
Term 3 Assessment - comments
Written examination with lecture notes available.
Resit Assessment - Term 1 (B1BA1) - Comments
Not applicable
Type of Teaching Activity/Activities
- Travaux pratiques / travaux de laboratoire / exercices de création et recherche en atelier / projet sur ordinateur /études de cas