Dubna University database course for 2nd (SQL) and 3rd (PL/SQL, API and etc) year students
- Database. DBMS. Relational database.
- Table. Row. Column.
- Data integrity.
- Primary key. Foreign key. Check. Unique key. Index
- One-to-many, many-to-many, one-to-one relationships.
- Database normalization.
- Database design. EER diagramm.
- DDL. Create. Alter. Drop.
- DML. Select. Insert. Update. Delete.
- JOINS.
- Where. Functions.
- Group by. Having. Aggregate functions. Order by.
- DCL.
- TCL. ACID.
- PL/SQL. Loops. Conditions.
- Cursor.
- Procedure. Functions.
- Exeptions. Package.
- Triggers.
- Big Data.
- API. RESTful. JSON. NodeJS example.
- ORM.
- Document-store - MongoDB.
- Redis. Cassandra.
- Elasticsearch.