Study programme 2020-2021 | Français | ||
Databases I (part A) | |||
Learning Activity |
Code | Lecturer(s) | Associate Lecturer(s) | Subsitute Lecturer(s) et other(s) | Establishment |
---|---|---|---|---|
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 |
Organisational online arrangements for the end of Q3 2020-2021 assessments (Covid-19) |
---|
|
Description of the modifications to the Q3 2020-2021 assessment procedures (Covid-19) |
Written examination on campus. |
Organisational arrangements for the end of Q1 2020-2021 assessments (Covid-19) online or face-to-face (according to assessment schedule)
Description of the modifications to the Q1 2020-2021 online assessment procedures (Covid-19) online or face-to-face (according to assessment schedule)
Written examination on campus.
Content of Learning Activity
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 Learning Resources/Tools
Not applicable
Recommended Learning Resources/Tools
www.mysql.org
Other Recommended Reading
Not applicable
Mode of delivery
Type of Teaching Activity/Activities
Evaluations
The assessment methods of the Learning Activity (AA) are specified in the course description of the corresponding Educational Component (UE)