How to find us
|
Contacts

Database Technologies 2017/2018

  • 6 ECTS
  • Taught in Portuguese
  • Both continuous and final Assessment

Objectives

Objectives:
1. Review and enhance the modelation technic for Data bases
2. Understand and go deeper on SQL language
3. Understand the basic concepts of SQL Server interface program
4. Understand the n-tier solution development
5. Understand the BD as an object with it's own rules and interface and it's use through different clients

Recommended Prerequisites

Strong knowledge of algoritms and programming both tradicional and objects

Good capacity to manipulate classes and methods

Strong knowledge on DB modelation and SQL fundamentals

Strong knowledge of VB.NET

Teaching Metodology

Direct teaching
Resolution of practical problems on session
Individual resolution of gradually more complex problems

Body of Work

T-SQL programming
Transactions
Triggers
Cursors
n-Tier applications development
Replication
Introduction to Oracle and PL/SQL
Introduction to NoSQL

Recommended Bibliography

Sessions documentation

Complementary Bibliography

Development systems Help
Books online for SQL Server

Weekly Planning

1ª.SQL
1. Data definition, Restrictions and Schema;
2. Basic Queries
2ª.3. More complex Queries
3ª.3. More complex Queries; 4. INSERT, DELETE e UPDATE
4ª.5. VIEWS; 6. Stored Procedures; 7. Triggers
5ª.8. Transactions; 9. Locks
6ª.T-SQL Programming
1. Reserved Keywords
2. Transact-SQL Syntax Conventions
3. Built-in Functions
7ª.Built-in Functions
8ª.Built-in Functions
9ª.Control-of-Flow Language
10ª.5. Cursors;6. Data Types
11ª.7. Expressions; 8. Language Elements; 9. Operators
12ª.10. Predicates;13. SET Statements; 14. Variables; 15. CREATE FUNCTION
13ª. DB with SQL, implementing business rules with Triggers and Stored Procedures
Interface components to connect to DB SP's
14º.VB interface building
15ª.Global evaluation

Demonstration of the syllabus coherence with the curricular unit's objectives

With the development of T-SQL statements, with the presentation of real cases and the construction of their solutions, mechanisms for understanding the role of databases in information systems are created.

Demonstration of the teaching methodologies coherence with the curricular unit's objectives

Given the practical aspects of the theme, only individual construction of solutions allows the students to acquired and internalize the mechanisms that support the creation of information systems solutions with databases.

relevant generic skillimproved?assessed?
Achieving practical application of theoretical knowledgeYesYes
Adapting to new situationsYesYes
Analytical and synthetic skillsYesYes
Balanced decision makingYes 
CreativityYesYes
Event organization, planning and managementYesYes
Foreign language proficiency  
Information and learning management  
Initiative and entrepreneurship capabilityYesYes
IT and technology proficiencyYesYes
Problem Analysis and AssessmentYesYes
Problem-solvingYesYes
Research skillsYesYes
Self-assessmentYes 
Written and verbal communications skills  
This website uses cookies to provide better functionality and for performance measurements (European Union Directive 2009/136/EC)
Please take a few minutes do answer a few quick questions about our website.