CoursesSQL & Databases
Beginner → Advanced
SQL, Oracle & PostgreSQL
Master the database skills behind every ERP and business app — from queries to migrations.
Duration6 weeks
Sessions12 live sessions
FormatLive online · small group
FeeOn request
Who it's for
You'll need: None — we start from SELECT. Comfort with a computer is enough.
Developers
You want to write faster queries and design better databases.
Report & MIS analysts
You build reports and want deeper SQL power.
Teams migrating
You are planning or running an Oracle to PostgreSQL move.
What you'll build
Sales & Stock Reporting Database
Design a sales and inventory database, write the key business reports, then migrate it from Oracle to PostgreSQL.
Yours to keep for your portfolio
By the end you'll
Write complex joins, CTEs and window functions
Design normalised, well-indexed schemas
Tune slow queries with execution plans
Plan and run an Oracle → PostgreSQL migration
Syllabus
6 weeks · 12 live sessions · notes & recordings included- Week 01 SQL foundations SELECT, filters, joins, grouping, aggregates
- Week 02 Advanced queries Subqueries, CTEs, window functions, pivots
- Week 03 Database design Normalisation, keys, constraints, ERP-style schemas
- Week 04 PL/SQL & PL/pgSQL Procedures, functions, triggers, transactions
- Week 05 Performance Indexes, execution plans, query tuning
- Week 06 Migration Oracle → PostgreSQL: tools, data types, testing, cut-over
Your instructor
Bikalp Kumar Karn
CTO at Neo Software, Golchha Organization. 15+ years and 100+ projects across ERP, Odoo, NextERP, SAP and custom enterprise software. You learn what is used in real production systems — not just textbook examples.
Live online sessions
Recordings of every class
Notes & source code
Hands-on assignments
Certificate of completion
Enroll
Save your seat in the next batch.
Small groups only. Send your details and I'll share the next start date and fee within 1 day.