ISLA IPGT 22349

Database Programming

• ApresentaçãoPresentation

  This curricular unit aims at the development of skills in the project area and implementation of information systems and databases.
• ProgramaProgramme

  Relational Databases Project - SQL language - Definition of the structure of the databases. - Interrogation of databases. - Sub-questions - Sequences - Data manipulation - Division (Universal Quantification) - Views - Client-Server Application Development - Stored procedures. - Data Integrity - Definition of integrity constraints and triggers in PL-SQL / T-SQL. - Data Access Based Applications -Transactions - Notion of transaction. - Disaster recovery techniques. - Data Privacy - Definition of users, user profiles and SQL access privileges - Distributed Database (BDD) - Object Oriented Database (BDOO) - Data Warehousing Concepts - OLAP and Data Mining
• ObjectivosObjectives

  This course aims to: 1. Review and refine the database modeling technique. 2. Understand and deepen the domain of SQL language. 3. SQL Server Interface Handling Basics. 4. Database concept, with its own programming and interface and its use by different customers.
• BibliografiaBibliography

  Luís D., ?SQL?, Editora FCA, 1999. Gouveia, F., Fundamentos de Base de Dados, Editora FCA, 2014 José Luís Pereira, ?Tecnologia de bases de dados?, Editora FCA, 1998. Alberto Magalhães SQL Server 2008
• MetodologiaMethodology

  active methodologies
• LínguaLanguage

  Português
• TipoType

  Semestral
• ECTS

  6
• NaturezaNature

  Mandatory
• EstágioInternship

  Não