Skip to main content

ISLA IPGT 23670

Database Technologies

Analytics and Business Data Science
  • ApresentaçãoPresentation
    1. Description of the course: The Database Technologies (DT) subject provides students with the theoretical and practical foundations of the main concepts in the area, focusing on data modeling and SQL language. 2. Scope of the course: DT professionals can use their knowledge to extract valuable insights from large data sets, aiding strategic decision-making. The intervention domain of DT includes: Data modeling: Designing and structuring data in an efficient way that suits business needs. SQL language: Manipulating and querying data in databases using the SQL language.
  • ProgramaProgramme
    Database fundamentals Database concept Relational and non -relational Data warehouse concept Architecture Major providers Data Models Table, View and MView Fact and Dimension Tables PK, FK, Index, SCD Schema & tablespaces Functions & Sequences Model definition Types of Data Models Star and Snowflake schema SQL Basics I Key concepts Exercises SQL Basics II Create database Create table Manipulate keys Create materialized view Exercises Evaluation exercise
  • ObjectivosObjectives
    Skills: Analyze and model data efficiently and appropriately to meet business needs. Use the SQL language to manipulate and query data in databases effectively. Understand the different components of a DBMS and how they integrate.
  • BibliografiaBibliography
    SQL, Luis Damas Fundamentos de Sistemas de Base de Dados, Elmasri & Navathe Conceitos de Sistemas de Base de Dados, Silberschatz, Korth & Sudarshan Técnicas de Modelagem de Dados, Rob & Coronel
  • MetodologiaMethodology
       
  • LínguaLanguage
    Português
  • TipoType
    Anual
  • ECTS
    3
  • NaturezaNature
    Mandatory
  • EstágioInternship
    Não