Database & Backend Development
An advanced course in database and backend engineering. You learn advanced SQL on PostgreSQL, then transactions, isolation and indexing, then transfer to MySQL and MongoDB. You build a secure Node.js and Express REST API with authentication, authorization, tests, backup and restore, and a cloud deployment plan. You finish with a documented capstone and client handover. All business data is simulated.
- Duration: 20 weeks
- Modules: 12
- Fee: Rs 19,999 (about Rs 3,333 a month on EMI)
- Field: Dev & Technology
Roles this track prepares you for
- Backend Developer
- API Developer
- Node.js Developer
- Database Administrator
- Database Developer
- SQL Developer
- Backend Engineer
- PostgreSQL Developer
- Junior Database Administrator
- Software Engineer
Curriculum
- Backend Thinking, Readiness and Lab Setup - Check your readiness, bridge terminal and HTTP gaps, follow a request from client to database, set up an isolated lab and plan entities, API resources and permissions.
- Take the readiness diagnostic and choose your path
- Bridge: terminal, Git and HTTP essentials
- Follow a request from client to database
- Set up the isolated database and Node lab
- Verify connectivity and read lab logs
- Turn a brief into entities, resources and permissions
- Advanced SQL: CTEs, Window Functions and JSON - Write correct, readable PostgreSQL queries with joins, grouping, CTEs, subqueries, window functions, JSON and date handling, and avoid duplicate-row and NULL mistakes.
- SELECT, filtering and NULL behaviour in depth
- Joins and accidental row duplication
- Aggregation, grouping and HAVING
- CTEs and subqueries
- Window functions for rankings and running totals
- JSON columns, dates and text in PostgreSQL
- Data Modelling, Normalization and Reporting - Model entities and relationships, choose keys and constraints, normalize deliberately, weigh denormalization, build views for reporting and review a flawed schema.
- Entities, relationships and cardinality
- Keys, constraints and data integrity
- Normalization step by step
- Deliberate denormalization and its costs
- Views for reporting
- Review and repair a flawed schema
- Transactions, Isolation and Concurrency - Use transactions, savepoints, isolation levels and locking to keep stock and order data correct under failure and concurrent writes, and handle deadlocks.
- Make an order succeed or fail as one unit
- Roll back a whole order or just one failed line
- See what two sessions can read at each isolation level
- Make the second order wait with a row lock
- Cause a deadlock, read 40P01, and retry safely
- Place two orders at once and keep stock correct
- Indexes, Query Plans and PostgreSQL Operations - Choose and test indexes, read query plans, run migrations that preserve data, set least-privilege roles and learn basic maintenance and monitoring.
- Build indexes on 200,000 orders and measure what they cost
- Read query plans with EXPLAIN and EXPLAIN ANALYZE
- Composite, partial and covering indexes on orders_big
- Change the schema safely with up and down migrations
- Give each app role only the privileges it needs
- Keep the database healthy with statistics, vacuum and activity checks
- MySQL Transfer and Dialect Differences - Repeat a representative relational task in MySQL and identify the differences in types, generated IDs, placeholders, transactions, indexes and import and export.
- Set up MySQL and map the v1 types
- Port the schema and seed to MySQL
- Rewrite the reports for MySQL
- Run the stock scenario on InnoDB
- Read EXPLAIN before and after an index
- Import, export and compare with PostgreSQL
- Robust Node.js Services - Write reliable Node.js code with modules, configuration, async error handling, streams, a basic HTTP server, structured logs and clean shutdown.
- Modules, packages and configuration
- Async code and error handling
- Files, JSON and streams
- A small web server with node:http
- Logs and a clean shutdown
- Diagnose async faults
- Express and REST API Design - Design Express REST APIs with middleware, validation, consistent errors and status codes, pagination and filtering, idempotency and a documented contract.
- Routing and middleware
- Validation and resource contracts
- Status codes and consistent errors
- Pagination, filtering and sorting
- Idempotency and business state transitions
- Write the API contract and request examples
- PostgreSQL-Backed APIs and Testing - Connect the API to PostgreSQL with pooling and parameterized queries, add service boundaries and transactions, and prove persistence and failure behaviour with integration tests.
- Connection pooling and parameterized queries
- Routes, services and repositories
- Transactions inside an API request
- Migrations, seeds and resettable test data
- Integration tests against a real test database
- Persistence, rollback and race tests
- MongoDB Design, Indexing and Aggregation - Model documents with deliberate embedding and references, query and index MongoDB, use aggregation and the Node driver, and understand atomicity and transaction prerequisites.
- Document modelling: embed or reference
- CRUD and filtering documents
- Indexes and schema validation
- Aggregation pipelines
- Using the Node driver safely
- Atomic updates and transactions
- Authentication, Authorization and API Security - Implement password hashing, login, one fully taught session or token approach, role and ownership checks, input defences, rate limits and negative permission tests.
- Password hashing and registration
- Sessions, tokens and logout
- Roles and ownership
- Input defence and injection
- Rate limits and secrets
- Tests that prove refusals
- Backup, Restore, Cloud Deployment and Capstone - Verify a backup by restoring it to a clean database, configure a secure deployment with persistence and rollback, and deliver the integrated capstone with a runbook and handover.
- Back up, restore, verify
- Configuration, secrets and TLS
- Deploy so the data survives
- Release, roll back, recover
- Capstone: build and prove the service
- Handover and defence of design tradeoffs
Frequently asked questions
How long is the Database & Backend Development course?
It runs for 20 weeks, with 12 modules. It is self-paced online learning from EasySkill Career Academy, Surat.
How much does the Database & Backend Development course cost?
The fee is Rs 19,999, or about Rs 3,333 a month on EMI.
What will I build in Database & Backend Development?
Every module ends in a graded practical task that AI checks in about 30 seconds, so you finish with a portfolio you can show to employers or clients.
Which roles does Database & Backend Development prepare me for?
It prepares you to apply for roles such as Backend Developer, API Developer, Node.js Developer, Database Administrator, Database Developer. It does not guarantee a job or income.
Can I learn online, or do I have to visit a centre?
You can learn fully online. EasySkill also has centres in Adajan, Vesu and Bhestan, Surat, if you prefer to visit.
All career tracks