Databases with MySQL

Section outline

• Select section

  Collapse Expand

  Collapse all Expand all

  
  

  
  

  
  

  • Select activity Professor: Cristina RodriguesEmail: cristina.rodri...

    Completion

    Students must

    

    Mark as done

    Professor: Cristina Rodrigues

    Email: cristina.rodrigues@esg.ipsantarem.pt 

    
    

  • Select activity __________________________________________________...

    Completion

    Students must

    

    Mark as done

    
    

    ______________________________________________________________________________________________

    Course Information

  • Select activity Course Introduction Presentation

    

    Course Introduction Presentation File

    Completion

    Students must

    

    Mark as done

    Learning Outcomes  |  Syllabus  |  Evaluation  |  Bibliography

  • Select activity Course Information (pdf)

    

    Course Information (pdf) File

    Completion

    Students must

    

    Mark as done
  • Select activity __________________________________________________...

    Completion

    Students must

    

    Mark as done

    
    

    ______________________________________________________________________________________________

    Teacher and Students' Information

  • Select activity Presentation of Professor (Cristina Rodrigues)

    

    Presentation of Professor (Cristina Rodrigues) File

    Completion

    Students must

    

    Mark as done
  • Select activity Presentation of Students

    

    Presentation of Students URL

    Completion

    Students must

    

    Mark as done

    Please introduce yourself through the link provided.

  • Select activity __________________________________________________...

    Completion

    Students must

    

    Mark as done

    
    

    ______________________________________________________________________________________________

    Communication

  • Select activity News Forum/Questions

    

    News Forum/Questions

    Completion

    Students must

    

    Mark as done
  • Select activity __________________________________________________...

    Completion

    Students must

    

    Mark as done

    
    

    ______________________________________________________________________________________________

    Course Survey

    Please take a few minutes to respond to the following survey
    

    https://forms.gle/sLGmVuis811bJdXdA
    

  • Select activity __________________________________________________...

    Completion

    Students must

    

    Mark as done

    
    

    ______________________________________________________________________________________________

    Project Activities

  • Select activity Database Project Description (50 % of grade)

    

    Database Project Description (50 % of grade) File

    Completion

    Students must

    

    Mark as done
  • Select activity Database Project Example

    

    Database Project Example File

    Completion

    Students must

    

    Mark as done
  • Select activity Database Group Project Organization Forum

    

    Database Group Project Organization Forum

    Completion

    Students must

    

    Mark as done
  • Select activity Database Group Project Tutoring Booking

    

    Database Group Project Tutoring Booking URL

    Completion

    Students must

    

    Mark as done
  • Select activity Meeting Room

    

    Meeting Room URL

    Completion

    Students must

    

    Mark as done
  • Select activity __________________________________________________...

    Completion

    Students must

    

    Mark as done

    
    

    ______________________________________________________________________________________________

    MySQL Software Installation

  • Select activity MySQL Software Installation Resources

    

    MySQL Software Installation Resources Folder

    Completion

    Students must

    

    Mark as done

    In this folder you will find all the necessary resources for the software installation of the MYSQL virtual Machine.
    The installation of the software should be completed on Week 6 of the Databases with MySQL course.  Instructions are provided on the Week 6 section.
    
• Select section Week 1

  Collapse Expand

  Week 1

  Learning Activities:  Fundamentals of Database Management Systems
  

  • Select activity Contents and tasks of the week

    

    Contents and tasks of the week Page

    Completion

    Students must

    

    Mark as done
  • Select activity Lesson 1 - Fundamentals of Database Management Systems (presentation)

    

    Lesson 1 - Fundamentals of Database Management Systems (presentation) File

    Completion

    Students must

    

    Mark as done
  • Select activity Lesson 1 - Fundamentals of Database Management Systems (pdf))

    

    Lesson 1 - Fundamentals of Database Management Systems (pdf)) File

    Completion

    Students must

    

    Mark as done
  • Select activity Presentation of Students

    

    Presentation of Students URL

    Completion

    Students must

    

    Mark as done

    Please introduce yourself through the link provided.

• Select section Week 2

  Collapse Expand

  Week 2

  Learning Activities:  Relational Database Design and Development Methodologies using Data Normalization
  

  • Select activity Contents and tasks of the week

    

    Contents and tasks of the week Page

    Completion

    Students must

    

    Mark as done
  • Select activity Data Normalization Questions

    

    Data Normalization Questions Forum

    Completion

    Students must

    

    Mark as done
  • Select activity Lesson 2 - Data Normalization (presentation)

    

    Lesson 2 - Data Normalization (presentation) File

    Completion

    Students must

    

    Mark as done
  • Select activity Lesson 2 - Data Normalization (pdf)

    

    Lesson 2 - Data Normalization (pdf) File

    Completion

    Students must

    

    Mark as done
  • Select activity Data Normalization Tutorial (all steps)

    

    Data Normalization Tutorial (all steps) File

    Completion

    Students must

    

    Mark as done
• Select section Week 3

  Collapse Expand

  Week 3

  Learning Activities:  Relational Database Design and Development Methodologies using  Data Normalization

  • Select activity Contents and tasks of the week

    

    Contents and tasks of the week Page

    Completion

    Students must

    

    Mark as done
  • Select activity (1) Data Normalization Exercises

    

    (1) Data Normalization Exercises File

    Completion

    Students must

    

    Mark as done

    The Data Normalization Exercises should be completed by the end of the current week.  Please review the Data Normalization Tutorial (all steps), from the previous week,  in order to be able to resolve these exercises.

    All normal forms should be presented in the resolution of the exercises.

    The solutions to these exercises will be available on this platform at the end of the current week.

  • Select activity Send (1) Data Normalization Exercises Results

    

    Send (1) Data Normalization Exercises Results Assignment

    Completion

    Students must

    

    Mark as done
  • Select activity (1) Data Normalization Exercises Solutions

    

    (1) Data Normalization Exercises Solutions File

    Completion

    Students must

    

    Mark as done
• Select section Week 4

  Collapse Expand

  Week 4

  Learning Activities:  Relational Database Design and Development Methodologies using Entitity-Relationship Model

  
  

  • Select activity Contents and tasks of the week

    

    Contents and tasks of the week Page

    Completion

    Students must

    

    Mark as done
  • Select activity Entity-Relationship Model Questions

    

    Entity-Relationship Model Questions Forum

    Completion

    Students must

    

    Mark as done

    Ask here any questions or doubts about Entity-Relationship.

  • Select activity Send Definition of Theme and the names of them Members of the Database Group Project

    

    Send Definition of Theme and the names of them Members of the Database Group Project Assignment

    Opened: Monday, 19 September 2022, 11:00 PM

    Due: Monday, 26 September 2022, 11:00 PM

    Completion

    Students must

    

    Mark as done

    Please introduce the theme of your database project and the name of the members of your group of the Database Group Project.  There should be 2-3 members in each group.

  • Select activity Lesson 3 - Entity-Relationship (pdf)

    

    Lesson 3 - Entity-Relationship (pdf) File

    Completion

    Students must

    

    Mark as done
  • Select activity (2) Entity-Relationship Exercises

    

    (2) Entity-Relationship Exercises File

    Completion

    Students must

    

    Mark as done

    The Entity-Relationship Exercises should be completed by the end of the current week.  Please review  Lesson 3 - Entity-Relationship,  in order to be able to resolve these exercises.

    The solutions to these exercises will be available on this platform at the end of the current week.

    
    

  • Select activity Send (2) Entity-relationship Exercises Results

    

    Send (2) Entity-relationship Exercises Results Assignment

    Completion

    Students must

    

    Mark as done
  • Select activity (2) Entity-Relationship Exercises - Solutions

    

    (2) Entity-Relationship Exercises - Solutions File

    Completion

    Students must

    

    Mark as done
• Select section Week 5

  Collapse Expand

  Week 5

  Learning Activities:  Relational Database Design and Development Methodoligies, Conversion of Entity Relationship Model to Relational Model

  • Select activity Contents and tasks of the week

    

    Contents and tasks of the week Page

    Completion

    Students must

    

    Mark as done
  • Select activity Lesson 4 - Conversion ERD to Relational Model (pdf)

    

    Lesson 4 - Conversion ERD to Relational Model (pdf) File

    Completion

    Students must

    

    Mark as done
  • Select activity (3) Entity-Relationship Conversion Exercises

    

    (3) Entity-Relationship Conversion Exercises File

    Completion

    Students must

    

    Mark as done

    The Entity-Relationship Conversion  Exercises should be completed by the end of the current week and handed in in the link provided below.  Please review  Lesson 4 - Conversion ERD to Relational Model (pdf) ,  in order to be able to resolve these exercises.

    The solutions to these exercises will be available on this platform at the end of the current week.

    
    
    

  • Select activity Send (3) Entity-Relationship Exercises Results

    

    Send (3) Entity-Relationship Exercises Results Assignment

    Completion

    Students must

    

    Mark as done
  • Select activity (3) Entity-Relationship Conversion Exercises - Solutions

    

    (3) Entity-Relationship Conversion Exercises - Solutions File

    Completion

    Students must

    

    Mark as done
  • Select activity Send Database Group Project Description

    

    Send Database Group Project Description Assignment

    Opened: Monday, 19 September 2022, 11:00 PM

    Due: Monday, 26 September 2022, 11:00 PM

    Completion

    Students must

    

    Mark as done

    Please upload a word file with the following items:

    Introduction(A brief description of the assignment);
    Description of the current system;
    Objectives of the new system;

    An example can be found in Database Project Example.
    

• Select section Week 6

  Collapse Expand

  Week 6

  Activities:  MySQL Software Installation

  • Select activity Contents and tasks of the week

    

    Contents and tasks of the week Page

    Completion

    Students must

    

    Mark as done
  • Select activity To complete all the procedures necessary to instal...

    Completion

    Students must

    

    Mark as done

    To complete all the procedures necessary to install the software that will be used in this course´s SQL exercises, please follow all the instructions in the tutorial video provided bellow.
    
  • Select activity MySQL Software Installation Questions

    

    MySQL Software Installation Questions Forum

    Completion

    Students must

    

    Mark as done

    Please ask here any questions about MYSQL software installation.

  • Select activity Virtual Machine download and configuration tutoria...

    Completion

    Students must

    

    Mark as done

    Virtual Machine download and configuration tutorial

     

     
    

  • Select activity English version of MySQL virtual machine software

    

    English version of MySQL virtual machine software URL

    Completion

    Students must

    

    Mark as done

    Download the English version of the software that will be used for completing the SQL exercises.   A zip file will made available with all the software customised to use the English language.  For the correct installation procedures, please follow the instructions in the tutorial provided.

  • Select activity Portuguese version of MySQL virtual machine software

    

    Portuguese version of MySQL virtual machine software URL

    Completion

    Students must

    

    Mark as done

    Download the Portuguese version of the software that will be used for completing the SQL exercises.   A zip file will made available with all the software customised to use the Portuguese language.  For the correct installation procedures, please follow the instructions in the tutorial provided.

  • Select activity Send Database Group Project Requeriments Analysis

    

    Send Database Group Project Requeriments Analysis Assignment

    Opened: Monday, 19 September 2022, 11:00 PM

    Due: Monday, 26 September 2022, 11:00 PM

    Completion

    Students must

    

    Mark as done

    Please upload a word file with the following items:

    Design of the conceptual model :

    Entity-Relationship Diagram,  Data schema,  Attributes and keys.

    An example can be found in Database Project Example.
    

• Select section Week 7

  Collapse Expand

  Week 7

  Learning Activities:  SQL Data Definition Language (DDL)

  
  

  • Select activity Contents and tasks of the week

    

    Contents and tasks of the week Page

    Completion

    Students must

    

    Mark as done
  • Select activity Lesson 5 - SQL (pdf)

    

    Lesson 5 - SQL (pdf) File

    Completion

    Students must

    

    Mark as done
  • Select activity SQL Questions

    

    SQL Questions Forum

    Completion

    Students must

    

    Mark as done

    Ask here any questions or doubts about Entity-Relationship.

  • Select activity MYSQL Simple DataBase usage @@PLUGINFILE...

    Completion

    Students must

    

    Mark as done

    MYSQL Simple DataBase usage
    

     

     
    

  • Select activity (4) SQL DDL Exercises

    

    (4) SQL DDL Exercises File

    Completion

    Students must

    

    Mark as done

    The SQL DDL  Exercises should be completed by the end of the current week.  Please review  Lesson 5 -  SQL (pdf) ,  in order to be able to resolve these exercises.

    The solutions to these exercises will be available on this platform at the end of the current week.

    
    

  • Select activity Send (4) SQL DDL Exercises Results

    

    Send (4) SQL DDL Exercises Results Assignment

    Completion

    Students must

    

    Mark as done
  • Select activity (4) SQL DDL Exercises - Solutions

    

    (4) SQL DDL Exercises - Solutions File

    Completion

    Students must

    

    Mark as done
• Select section Week 8

  Collapse Expand

  Week 8

  Learning Activities:  SQL  (Structured Query Language)  - Data Modification Language (DML)

  • Select activity Contents and tasks of the week

    

    Contents and tasks of the week Page

    Completion

    Students must

    

    Mark as done
  • Select activity (5) SQL DML Exercises

    

    (5) SQL DML Exercises File

    Completion

    Students must

    

    Mark as done

    The SQL DML  Exercises should be completed by the end of the current week.  Please review  Lesson 5 - SQL,  in order to be able to resolve these exercises.

    The solutions to these exercises will be available on this platform at the end of the current week.

    
    
    

  • Select activity Send (5) SQL DML Exercises Results

    

    Send (5) SQL DML Exercises Results Assignment

    Completion

    Students must

    

    Mark as done
  • Select activity (5) SQL DML Exercises - Solutions

    

    (5) SQL DML Exercises - Solutions File

    Completion

    Students must

    

    Mark as done
• Select section Week 9

  Collapse Expand

  Week 9

  Learning Activities:  SQL  (Structured Query Language)  - Data Modification Language (DML) - Simple Querys

  • Select activity Contents and tasks of the week

    

    Contents and tasks of the week Page

    Completion

    Students must

    

    Mark as done
  • Select activity Lesson 6 - Simple Querys

    

    Lesson 6 - Simple Querys File

    Completion

    Students must

    

    Mark as done
  • Select activity Send Database Group Project Database Creation SQL Script

    

    Send Database Group Project Database Creation SQL Script Assignment

    Opened: Monday, 19 September 2022, 11:00 PM

    Due: Monday, 26 September 2022, 11:00 PM

    Completion

    Students must

    

    Mark as done

    Please upload all the SQL database creation script for the Database Project. An example can be found in Database Project Example.

• Select section Week 10

  Collapse Expand

  Week 10

  Learning Activities:  SQL  (Structured Query Language)  - Data Modification Language (DML) - Simple Querys

  
  

  • Select activity Contents and tasks of the week

    

    Contents and tasks of the week Page

    Completion

    Students must

    

    Mark as done
  • Select activity How to Resolve Query Exercises Tutorial @@PLU...

    Completion

    Students must

    

    Mark as done

    How to Resolve Query Exercises Tutorial

     

     
    

  • Select activity (6) Simple Querys SQL Exercises

    

    (6) Simple Querys SQL Exercises File

    Completion

    Students must

    

    Mark as done

    The Simple Querys SQL Exercises should be completed by the end of the current week.  Please review  Lesson 6 - Simple Querys,  in order to be able to resolve these exercises.

    The solutions to these exercises will be available on this platform at the end of the current week.

    
    
    

  • Select activity Send (6) Simple Querys SQL Exercises Results

    

    Send (6) Simple Querys SQL Exercises Results Assignment

    Opened: Tuesday, 18 April 2023, 11:54 AM

    Completion

    Students must

    

    Mark as done
  • Select activity (6) Simple Querys - Solutions

    

    (6) Simple Querys - Solutions File

    Completion

    Students must

    

    Mark as done
• Select section Week 11

  Collapse Expand

  Week 11

  Learning Activities :  Dante Project Multiplier Event

  MULTIPLIER EVENT - IPSantarém, Higher School of Education
  16 of december

  
  

  EVIDENCES
  
  

  
  

  
  

  
  

  • Select activity Contents and tasks of the week

    

    Contents and tasks of the week Page

    Completion

    Students must

    

    Mark as done
  • Select activity Multiplier Event Exercise

    

    Multiplier Event Exercise File

    Completion

    Students must

    

    Mark as done
  • Select activity Send Multiplier Event Exercise Results

    

    Send Multiplier Event Exercise Results Assignment

    Completion

    Students must

    

    Mark as done
  • Select activity New Challenges of Education XXI Century

    

    New Challenges of Education XXI Century File

    Completion

    Students must

    

    Mark as done

    professor Cristina Novo
    

  • Select activity Dante Project presentation

    

    Dante Project presentation File

    Completion

    Students must

    

    Mark as done

    João Samartinho professor

• Select section Week 12

  Collapse Expand

  Week 12

  Learning Activities :  SQL  (Structured Query Language)  - Data Modification Language (DML) - Join Querys

  
  

  • Select activity Contents and tasks of the week

    

    Contents and tasks of the week Page

    Completion

    Students must

    

    Mark as done
  • Select activity Lesson 7 - Join Querys

    

    Lesson 7 - Join Querys File

    Completion

    Students must

    

    Mark as done
• Select section Week 13

  Collapse Expand

  Week 13

  Learning Activities:  SQL  (Structured Query Language)  - Data Modification Language (DML) - SQL Functions

  • Select activity Contents and tasks of the week

    

    Contents and tasks of the week Page

    Completion

    Students must

    

    Mark as done
  • Select activity (7) SQL Join Querys Exercises

    

    (7) SQL Join Querys Exercises File

    Completion

    Students must

    

    Mark as done

    The Join Querys SQL Exercises should be completed by the end of the current week.  Please review  Lesson 7 - Join Querys,  in order to be able to resolve these exercises.

    The solutions to these exercises will be available on this platform at the end of the current week.

    
    
    

  • Select activity Send (7) SQL Join Querys Exercises Results

    

    Send (7) SQL Join Querys Exercises Results Assignment

    Completion

    Students must

    

    Mark as done
• Select section Week 14

  Collapse Expand

  Week 14

  Learning Activities:  SQL  (Structured Query Language)  - Data Modification Language (DML) - SQL Functions

  
  

  • Select activity Contents and tasks of the week

    

    Contents and tasks of the week Page

    Completion

    Students must

    

    Mark as done
  • Select activity Lesson 8 - SQL Functions Querys

    

    Lesson 8 - SQL Functions Querys File

    Completion

    Students must

    

    Mark as done
  • Select activity (8) SQL Funcion Querys Exercises

    

    (8) SQL Funcion Querys Exercises File

    Completion

    Students must

    

    Mark as done

    The SQL Function Querys Exercises should be completed by the end of the current week.  Please review  Lesson 8 - SQL Function Querys,  in order to be able to resolve these exercises.

    The solutions to these exercises will be available on this platform at the end of the current week.

    
    
    

  • Select activity Send (8) SQL Funcion Querys Exercises Results

    

    Send (8) SQL Funcion Querys Exercises Results Assignment

    Opened: Tuesday, 2 May 2023, 11:17 AM

    Completion

    Students must

    

    Mark as done
• Select section Week 15

  Collapse Expand

  Week 15

  Learning Activities:  SQL  (Structured Query Language)  - Data Modification Language (DML) - Group Functions, SubQuerys

  
  

  
  

  • Select activity Contents and tasks of the week

    

    Contents and tasks of the week Page

    Completion

    Students must

    

    Mark as done
  • Select activity Lesson 9 - SQL Group Functions Querys

    

    Lesson 9 - SQL Group Functions Querys File

    Completion

    Students must

    

    Mark as done
  • Select activity (9) SQL Group Funcion Querys Exercises

    

    (9) SQL Group Funcion Querys Exercises File

    Completion

    Students must

    

    Mark as done

    The SQL Group Function Querys Exercises should be completed by the end of the current week and handed in in the link provided below.  Please review  Lesson 9 -  SQL Group Functions Querys ,  in order to be able to resolve these exercises.

    The solutions to these exercises will be available on this platform at the end of the current week.

    
    

  • Select activity Send (9) SQL Group Funcion Querys Exercises Results

    

    Send (9) SQL Group Funcion Querys Exercises Results Assignment

    Completion

    Students must

    

    Mark as done
  • Select activity Lesson 10 - SubQuerys

    

    Lesson 10 - SubQuerys File

    Completion

    Students must

    

    Mark as done
  • Select activity (10) SQL SubQuerys Exercises

    

    (10) SQL SubQuerys Exercises File

    Completion

    Students must

    

    Mark as done

    The SQL SubQuerys Exercises should be completed by the end of the current week and handed in in the link provided below.  Please review  Lesson 10 - SubQuerys,  in order to be able to resolve these exercises.

    The solutions to these exercises will be available on this platform at the end of the current week.

    
    
    

  • Select activity Send (10) SQL SubQuerys Exercises Results

    

    Send (10) SQL SubQuerys Exercises Results Assignment

    Completion

    Students must

    

    Mark as done
  • Select activity (10) SQL SubQuerys Exercises Solutions

    

    (10) SQL SubQuerys Exercises Solutions File

    Completion

    Students must

    

    Mark as done
  • Select activity Send Database Group Project SQL Querys Script

    

    Send Database Group Project SQL Querys Script Assignment

    Opened: Monday, 19 September 2022, 11:00 PM

    Due: Monday, 26 September 2022, 11:00 PM

    Completion

    Students must

    

    Mark as done

    Please upload all the SQL database querys script for the Database Group Project. An example can be found in Database Project Example.

• Select section Week 16

  Collapse Expand

  Week 16

  Learning Activities:  Evaluation of the students in the course Databases with MySQL

  
  

  • Select activity Contents and tasks of the week

    

    Contents and tasks of the week Page

    Completion

    Students must

    

    Mark as done
  • Select activity Database Group Project Presentation Booking

    

    Database Group Project Presentation Booking URL

    Completion

    Students must

    

    Mark as done

    Please book a date and time to present the Database Group Project.

  • Select activity Meeting Room for Database Group Project Presentation

    

    Meeting Room for Database Group Project Presentation URL

    Completion

    Students must

    

    Mark as done
  • Select activity Send Final Report of Database Group Project

    

    Send Final Report of Database Group Project Assignment

    Completion

    Students must

    

    Mark as done

    Please upload the file with the complete report of the Database Group Project. The description of files to upload can be found in Database Project Description (50 % of grade).

  • Select activity Final Exam

    

    Final Exam File

    Completion

    Students must

    

    Mark as done

    Please resolve the Final Exam and hand it in scanned after completing it.

  • Select activity Send Final Exam

    

    Send Final Exam Assignment

    Completion

    Students must

    

    Mark as done

    After completing the  final exam, it should be scanned and handed in in this section.

  • Select activity Students' Grades for the 1st semester Databases with MySQL Erasmus Course

    

    Students' Grades for the 1st semester Databases with MySQL Erasmus Course File

    Completion

    Students must

    

    Mark as done
  • Select activity __________________________________________________...

    Completion

    Students must

    

    Mark as done

    
    

    ______________________________________________________________________________________________

    Course Survey

    
    

    Please take a few minutes to respond to the following survey

    https://forms.gle/sLGmVuis811bJdXdA