Data Model, Application Development & AI-Driven DevOps
Take the full path or pick only the tracks you need. The total is 5+ hours of live one-on-one sessions, and we agree the split in a free intro call.
What You Will Be Able To Do
- Design a sound relational data model and explain when a data lake is the better choice.
- Find and fix slow SQL and PL/SQL using execution plans, indexes and rewrites.
- Build and unit-test a Java Spring service, and automate tasks in Python, Perl and shell.
- Set up a Git workflow and a Jenkins CI/CD pipeline that builds, tests and deploys your code.
- Containerise an app, deploy it to Kubernetes with Helm, and trace problems through EFK or Splunk logs.
- Trace a request across a REST API, a database, Kafka events and Splunk logs, and find where it failed.
Course Topics
- RDBMS concepts: entities, keys, relationships, normalisation
- Indexes, constraints, partitioning, transactions (ACID)
- OLTP vs OLAP, star schema, fact and dimension tables
- Data lake: raw / curated zones, CSV, JSON, Parquet, schema-on-read
- Lake vs warehouse vs database: choosing the right store
Outcome: you design an ER model for a real scenario and decide what belongs in the database versus the lake.
- SQL and PL/SQL performance tuning: execution plans, indexes, bind variables
- Java Spring Boot and JUnit
- Python, Perl, Shell scripting
- Coding best practices
Outcome: you make a slow query measurably faster and build a tested service that reads and writes to a database.
- Code source control e.g. Git: branching, pull requests, merge conflicts
- CI/CD pipeline e.g. Jenkins: build, test, deploy
- Code Gen AI tools e.g. Copilot
- Automation
Outcome: a commit to your repository triggers an automated build and test run.
- Docker images and containers
- Kubernetes (k8s): pods, deployments, services
- Helm
- EFK Stack, log analysis e.g. Splunk
Outcome: you deploy a containerised app to Kubernetes and trace an error through its logs.
- How a billing system fits together: application, REST API, database, event stream and logs, using Oracle BRM as the worked example (no BRM knowledge needed)
- REST APIs: request and response design, status codes, idempotency, retries, calling and testing with curl and Postman
- Database: tracing what an API call wrote, reading billing tables, and finding slow or locked queries
- Kafka: topics, partitions, producers, consumers, consumer lag, replaying events, and what happens when a consumer fails
- Splunk: ingesting logs, writing SPL searches, building dashboards and alerts, correlating by transaction ID
- Hands-on lab on a VM with Kafka, Splunk, a database and a sample subscription app, where we break things and find the cause
Outcome: you follow one request from the API call through the database and Kafka to the Splunk logs, and diagnose a failure end to end.
Fees
Billed in INR, for learners paying from India. For example, 5 hours = ₹7,500.
Billed in USD, for learners paying from outside India. For example, 5 hours = $150.
Live one-on-one sessions, 5+ hours in total. Session recordings and notes are included. You pay only for the hours you take. Team or corporate batches: ask for a quote.
Who It Is For
- A developer or support engineer with 0–8 years of experience who wants stronger database and DevOps skills
- Working on billing, finance or other data-heavy enterprise applications
- Moving from support or testing into development or DevOps
- Basic programming knowledge in any language
- A laptop with internet; we set up the tools together in the first session
- Not meant as a certification-exam crash course
How It Works
- Free intro call (20 min): we discuss your background and goals.
- Custom plan: you get a track list and a schedule.
- Live one-on-one sessions: a short demo, then you practise on a lab while I guide you.
- Recordings and notes after each session for revision.
Your Instructor
Book Your Free Intro Call
Tell us a little about yourself and we will reply within one working day with a suggested plan.
Prefer to talk? Write to learnbillsoft@gmail.com or call/WhatsApp +91 9922448557.
Questions
How long is the course?
5+ hours of live one-on-one sessions. The exact hours depend on the tracks you pick, and we agree them in the intro call.
What does it cost?
₹1,500 per hour for learners paying from India (5 hours = ₹7,500), and $30 per hour for learners paying from outside India (5 hours = $150).
Will I get recordings?
Yes, recordings and notes are shared after each session.
Can my team take it together?
Yes. Group and corporate batches are available; mention team size in the goals box.