Table of contents:
- Entity/Relationship data model (Basic elements)
- Constraints in the E/R model
- Weak entity sets
- From E/R diagrams to Realtional designs
- Algebraic and Logical Query Languages
- Simple queries in SQL (DDL - Create, DML - INSERT, UPDATE, DELETE, SELECT, JOIN, OUTER JOIN, Subqueries, UDF, GROUP BY, OUTER JOIN)
- Scalar Functions and ArithmeticФайл
- Create Objects
- Maintaining Data
- UNION, CTE
- Recursive SQLФайл
- Basic SQL Procedure Structure
- Using Flow of Control Statements
- Overview of SQL PL Language Elements
- Cursors and Result Sets
- Condition Handling
- Nested SQL Procedures
Exercices - practicing the topics:
Course project:
The database for the series The 100 aims to store information about the data of the series in its own website - The100Base.
The100Base -> documentation, diagrams, realisation
