16. Module: Conceitos de Base de Dados com PostgreSQL

Bases de dados relacionais são uma parte importante de qualquer sistema SIG. Neste módulo, irá aprender sobre conceitos de Sistema de Gestão de Bases de Dados Relacionais (RDBMS) e vai usar o PostgreSQL para criar uma nova base de dados para armazenar dados, bem como aprender sobre outras funções típicas de RDBMS.

• 16.1. Lesson: Introduction to Databases
  • 16.1.1. What is a Database?
  • 16.1.2. Tabelas
  • 16.1.3. Columns / Fields
  • 16.1.4. Records
  • 16.1.5. Datatypes
  • 16.1.6. Modelling an Address Database
  • 16.1.7. Database Theory
  • 16.1.8. Normalisation
  • 16.1.9. Try Yourself
  • 16.1.10. Indexes
  • 16.1.11. Sequences
  • 16.1.12. Entity Relationship Diagramming
  • 16.1.13. Constraints, Primary Keys and Foreign Keys
  • 16.1.14. Transactions
  • 16.1.15. In Conclusion
  • 16.1.16. What’s Next?
• 16.2. Lesson: Implementing the Data Model
  • 16.2.1. Install PostgreSQL
  • 16.2.2. Ajuda
  • 16.2.3. Create a database user
  • 16.2.4. Verify the new account
  • 16.2.5. Create a database
  • 16.2.6. Starting a database shell session
  • 16.2.7. Make Tables in SQL
  • 16.2.8. Create Keys in SQL
  • 16.2.9. Create Indexes in SQL
  • 16.2.10. Dropping Tables in SQL
  • 16.2.11. A word on pgAdmin III
  • 16.2.12. In Conclusion
  • 16.2.13. What’s Next?
• 16.3. Lesson: Adding Data to the Model
  • 16.3.1. Insert statement
  • 16.3.2. Sequencing Data Addition According to Constraints
  • 16.3.3. Try Yourself
  • 16.3.4. Select data
  • 16.3.5. Update data
  • 16.3.6. Delete Data
  • 16.3.7. Try Yourself
  • 16.3.8. In Conclusion
  • 16.3.9. What’s Next?
• 16.4. Lesson: Queries
  • 16.4.1. Ordering Results
  • 16.4.2. Filtering
  • 16.4.3. Joins
  • 16.4.4. Sub-Select
  • 16.4.5. Aggregate Queries
  • 16.4.6. In Conclusion
  • 16.4.7. What’s Next?
• 16.5. Lesson: Views
  • 16.5.1. Creating a View
  • 16.5.2. Modifying a View
  • 16.5.3. Dropping a View
  • 16.5.4. In Conclusion
  • 16.5.5. What’s Next?
• 16.6. Lesson: Rules
  • 16.6.1. Creating a logging rule
  • 16.6.2. In Conclusion
  • 16.6.3. What’s Next?