NO PREPAYMENT!

Database course work

SQL, NoSQL, PostgreSQL, MySQL, MongoDB, Redis. ER diagrams, normalization, triggers, stored procedures, indexing and query optimization.

from UAH 2,500 Term from 5 days

Order in Telegram Order form

Areas of course work on databases

From designing relational schemes to working with document-oriented databases. The full cycle: from a conceptual model to a working application with a graphical interface.

PostgreSQL

The most powerful open-source RDBMS. Support for JSON, arrays, full-text search, extensions. An ideal choice for serious educational projects.

from UAH 2,500

MySQL / MariaDB

The most popular DBMS in educational institutions. InnoDB, MyISAM, triggers, stored procedures, views, transactions and ACID.

from UAH 2,500

Microsoft SQL Server

T-SQL, stored procedures, cursors, SSMS. It is often found in higher education institutions specializing in information technology and computer science.

from UAH 2,500

MongoDB (NoSQL)

Document-oriented database. Flexible scheme, aggregation (aggregation pipeline), indexing, replication. Comparison with the SQL approach.

from UAH 3,000

Redis / Caching

In-memory databases, caching, message queues, pub/sub. Optimization of application performance, sessions, counters.

from UAH 3,000

Database design

ER-diagrams, normalization (1NF-NFBC), denormalization, indexing, query optimization. Complete design cycle without code.

from UAH 2,000

How we work

TK analysis

We study the methodology, determine the subject area, the number of tables and the necessary functionality

Projecting

We create an ER-diagram, normalize the scheme, define connections, constraints and indexes

Implementation

We write SQL scripts, triggers, procedures, create a GUI application for working with the database

Demonstration

We show a video of the application, check requests, you pay after confirmation

What is included in the database course

ER diagram (Chen notation or UML)
Database creation SQL scripts (CREATE, ALTER, INDEX)
Normalization to 3NF / NFBK with an explanation
Triggers and Stored Procedures

Test data (INSERT) and complex queries (JOIN, subqueries)
Graphical interface (Python/Java/C# application)
Documentation and explanatory note
Free edits and defense preparation

Reviews about courses from databases

"Course with PostgreSQL - a database for a car dealership. 12 tables, triggers, stored procedures, a graphical interface in Python. The teacher gave 100 points for the ER diagram!"

Dmytro K.

NTUU "KPI", Kyiv

"I ordered a coursework with MongoDB - a library management system. Aggregations, indexing, comparison with the SQL approach. Everything is clearly according to the methodology. Thank you for your support!"

Olena S.

ONU named after Mechnikova, Odessa

"I needed a course with MySQL + Java GUI. It was done in 6 days: normalization to NFBC, triggers for auditing, an application on JavaFX. The code is clean, the comments are in place."

Artem B.

DNU named after Honchara, Dnipro

All reviews

Frequently asked questions about database courses

We work with all major DBMS: PostgreSQL, MySQL/MariaDB, Microsoft SQL Server, Oracle Database, SQLite for relational databases. For NoSQL: MongoDB (document-oriented), Redis (key-value), Cassandra (columnar), Neo4j (graph), Firebase Realtime Database and Firestore. We choose a DBMS in accordance with the requirements of your methodology.

Yes, if this is provided for in your terms of reference. We create GUI applications for working with the database in Python (Tkinter, PyQt), Java (JavaFX, Swing), C# (WPF, Windows Forms) or web interface (Django, Flask, Spring Boot). The application allows you to perform CRUD operations, search and filtering through a convenient interface.

Normalization is the process of organizing data to eliminate redundancy and anomalies. We perform normalization to the desired normal form with a detailed explanation of each step: definition of functional dependencies, reduction to 1NF, 2NF, 3NF or NFBC.

Usually, methods require from 8 to 15 tables with different types of relationships: one-to-one, one-to-many, many-to-many. We design exactly as many tables as specified in your TOR, with mandatory foreign keys, integrity constraints (CHECK, UNIQUE, NOT NULL) and indexes.

Yes, we perform database design separately: conceptual model (ER diagram), logical model with normalization, physical model with DDL scripts. We can also separately write only SQL queries, triggers or stored procedures to an already existing database. The design cost is from UAH 2,000.