Data Analytics
The complete analytics stack — Python, Pandas, Power BI, MySQL, and Advanced Excel. The natural next step after mastering DBMS, applying your SQL skills in a full analytical workflow.
₹15,000 5 Months
MySQL · SQL Queries · Joins · Transactions
Database Management
System (DBMS) Course
Master the foundational skill that every software application depends on — databases. From understanding relational data models and installing MySQL through writing 350+ real queries, mastering joins, subqueries, stored procedures, and transactions — this course makes you fully fluent in the universal language of data: SQL.
MySQL 8.0
MySQL Workbench
SQL Queries
Joins & Subqueries
Views & Transactions
MySQL Functions
60
Classes
60h
Duration
10
Modules
350+
Queries
10–15
Batch Size
Course Details
What You Get
Everything you need to become confident with databases — from understanding relational data models through writing complex queries, designing schemas, and administering a MySQL server for real-world applications.
60 Classes · 60 Hours
A focused 60-hour programme covering every aspect of database management — from installation and data types through advanced joins, subqueries, transactions, stored procedures, views, and MySQL functions with 350+ hands-on practice queries.
ISO & MSME Certificate
Earn a government-recognized, ISO-certified DBMS completion certificate — a credential that proves your SQL and database skills to employers across IT, banking, e-commerce, and every industry that manages structured data.
350+ Solved Queries
Structured practice with 20+ queries on table creation, 100+ basic query exercises, 100+ advanced query solutions, 50+ join and subquery problems — building real muscle memory so you can write SQL confidently in any interview or job setting.
Small Batch Sizes
Only 10–15 students per batch ensures personal attention, immediate doubt resolution, and a focused learning environment critical for mastering complex SQL concepts like window functions, correlated subqueries, and transaction isolation levels.
Bengali & Hindi Medium
Complex database concepts — normalization, ACID properties, query optimization, and transaction control — taught clearly in Bengali and Hindi, ensuring every student genuinely understands the material and not just the syntax.
MySQL + Oracle Both Covered
Train on MySQL 8.0 and MySQL Workbench — the industry-standard open-source database — with an introduction to Oracle Express and Enterprise Edition, giving you versatility for both open-source and enterprise environments.
Full Curriculum
Course Syllabus
10 comprehensive modules — from MySQL installation and foundational SQL through advanced joins, subqueries, views, transactions, and MySQL functions — making you a complete, job-ready database professional.
Module 1: Introduction to MySQL & Relational Databases
The gateway to the world of databases. Understand what a relational database is, why SQL is the universal language of data, and set up your complete MySQL development environment — MySQL 8.0 Server, MySQL Workbench, and an introduction to Oracle's editions. By the end of this module, you'll have a working database environment and understand the fundamental concepts that power every database-driven application on earth.
1 ModuleMySQL 8.0MySQL WorkbenchOracle XERelational Model
01
What is a Database and Why Do We Need SQL?The fundamental problem of data storage and retrieval — what a database is, why flat files fail at scale, how relational databases solve data organization challenges, and why SQL became the standard language for interacting with structured data used by billions of applications worldwide.
02
MySQL 8.0, MySQL Workbench & Oracle EditionsInstalling MySQL 8.0 Server and MySQL Workbench on Windows — the complete step-by-step setup process. Introduction to Oracle Express Edition (free) and Enterprise Edition (commercial), understanding where each is used in industry, and navigating the MySQL Workbench interface to write, execute, and save queries.
Module 2: How to Create Tables — Data Types, Keys & Constraints
Tables are the core structure of every relational database. This module covers every SQL data type, how to enforce data integrity with constraints, and how to design tables that are clean, efficient, and relationship-ready. You will practise with 20+ real-world table creation exercises — building schemas for e-commerce, HR, banking, and inventory management systems.
1 ModuleSQL Data TypesPrimary KeysForeign KeysConstraintsAuto Increment20+ Exercises
01
SQL Data TypesComplete coverage of MySQL data types — numeric types (INT, BIGINT, DECIMAL, FLOAT), string types (VARCHAR, CHAR, TEXT, BLOB), date and time types (DATE, DATETIME, TIMESTAMP, TIME, YEAR), and JSON. Understanding which type to choose for each use case — and why the wrong choice causes performance, storage, and data integrity problems.
02
Primary Keys — Uniquely Identifying Every RowWhat a primary key is and why every table must have one. Single-column primary keys, composite primary keys, natural vs. surrogate keys, and the relationship between primary keys and data integrity. Best practices used in production database design at every major company.
03
NULL Values and NOT NULL ConstraintsUnderstanding NULL — what it means (unknown, not empty), how it differs from zero or empty string, how NULL propagates through expressions and comparisons, and when to use NOT NULL constraints to enforce required data. Real-world consequences of unconstrained NULL values in production databases.
04
AUTO_INCREMENT — Generating Unique IDsUsing AUTO_INCREMENT to generate unique integer identifiers automatically — the most common pattern for primary key generation. Setting starting values, resetting sequences, understanding gaps, and combining AUTO_INCREMENT with PRIMARY KEY constraints for bulletproof record identification.
05
20+ Table Creation Queries with SolutionsHands-on practice: creating complete database schemas for real-world scenarios — a university (students, courses, enrollments), an e-commerce system (products, orders, customers), a hospital (patients, doctors, appointments), and a banking system (accounts, transactions). Each with proper data types, constraints, and relationships.
Module 3: How to Create a Basic Query — WHERE, Operators & Patterns
The SELECT statement is the heart of SQL — everything a data analyst or developer does begins here. This module covers every aspect of filtering, comparing, and retrieving data with precision. With 100+ practice queries, you will develop true SQL fluency — the ability to look at any data requirement and immediately know how to write the query.
1 ModuleSELECTWHERE ClauseComparison OperatorsLogic ValuesLIKE & Wildcards100+ Queries
01
Using the WHERE ClauseThe fundamental filtering mechanism — restricting query results to exactly the rows you need. WHERE clause syntax, position in the SELECT statement, how the database evaluates WHERE conditions row by row, and the order of operations for complex conditions combining multiple criteria.
02
Conditional Statements — AND, OR, NOTCombining multiple conditions with AND (both must be true), OR (either must be true), and NOT (reversal of a condition). Truth tables for understanding compound logic, parentheses for controlling evaluation order, and real-world examples filtering customer records by multiple criteria simultaneously.
03
Multiple Conditions & Complex FilteringBuilding sophisticated filter expressions with nested conditions, mixing AND and OR, using IN for list membership (WHERE department IN ('Sales','HR','IT')), and BETWEEN for range queries. Strategies for writing readable multi-condition WHERE clauses that other developers can understand and maintain.
04
Comparison OperatorsAll comparison operators in MySQL — equal (=), not equal (!= and <>), greater than (>), less than (<), greater than or equal (>=), less than or equal (<=). Using each for numeric, string, and date column comparisons with practical examples from salary analysis, date range filtering, and inventory queries.
05
Logic Values — TRUE, FALSE & NULL HandlingBoolean logic in SQL — how TRUE and FALSE are stored and evaluated, the three-valued logic of SQL (TRUE, FALSE, UNKNOWN) caused by NULL, IS NULL and IS NOT NULL operators, using IFNULL and COALESCE to handle NULL values in expressions and output.
06
NULL Values in QueriesDeep dive into NULL handling in WHERE clauses — why WHERE column = NULL never works (and why IS NULL is required), NULL propagation in arithmetic and string expressions, NULL in aggregate functions (COUNT vs COUNT(*)), and best practices for NULL-safe query writing in production code.
07
Patterns & Wildcard Characters — LIKE OperatorPattern matching with LIKE — the % wildcard (matches any sequence of characters), the _ wildcard (matches exactly one character). Finding all customers whose name starts with 'A', products containing 'Pro', emails from a specific domain, and phone numbers matching a pattern. REGEXP for advanced pattern matching.
08
Comparing Column ValuesComparing one column against another column in the same table or joined tables — finding employees earning above the department average, products with price greater than cost, students whose marks exceed the passing threshold. Self-referential comparisons and their use in hierarchical data analysis.
09
100+ Queries with SolutionsIntensive practise across all basic query concepts — filtering employee records, querying product catalogs, retrieving student data with complex conditions, date-based filtering, pattern matching exercises, and NULL-handling scenarios. Each query comes with a complete solution and explanation of the approach.
Modules 4, 6 & 7: Advanced Queries — Aggregations, Functions, Subqueries & Views
This is where SQL transforms from a retrieval tool into a powerful analytical engine. Aggregate functions summarize millions of rows into insights. Date and string functions handle real-world messy data. Subqueries enable queries within queries for layered analysis. Views create reusable query abstractions. Over 210+ queries practised across these modules — making advanced SQL feel instinctive.
3 ModulesAggregate FunctionsGROUP BY & HAVINGDate FunctionsString FunctionsSubqueriesViews210+ Queries
01
DISTINCT Values — Eliminating DuplicatesUsing SELECT DISTINCT to return unique values from a column or combination of columns. Finding all unique product categories, distinct customer cities, unique department names — and understanding how DISTINCT interacts with multiple columns and aggregate functions.
02
TOP Values — LIMIT and OFFSETRestricting result sets with LIMIT (top N rows) and OFFSET (skip N rows) — the foundation of pagination in web applications. Finding top 10 best-selling products, bottom 5 performers, page 3 of customer records. Using ORDER BY with LIMIT for meaningful "top N" queries.
03
Date Functions — Extracting & Calculating DatesMySQL's complete date function library — NOW(), CURDATE(), CURTIME(), DATE(), YEAR(), MONTH(), DAY(), HOUR(), DAYNAME(), MONTHNAME(). Date arithmetic with DATE_ADD(), DATE_SUB(), DATEDIFF(), TIMESTAMPDIFF(). Filtering records by date range, calculating customer age, finding overdue orders, and computing employee tenure.
04
Date Calculations & Time IntelligenceAdvanced date manipulation — calculating days between dates (delivery time, project duration), finding records from the last 30 days or current month, quarter calculations, fiscal year filtering, and building time-series aggregations. Essential for analytics, reporting, and any time-sensitive business query.
05
Aggregate Functions — COUNT, SUM, AVG, MAX, MINThe analytical powerhouse of SQL. COUNT(*) vs COUNT(column) and their NULL behavior, SUM for totaling sales and quantities, AVG for averages, MAX and MIN for extremes. GROUP BY for segmented aggregations (total sales by region, average salary by department), HAVING for filtering grouped results — the complete pattern for analytical SQL.
06
String Functions — Text ManipulationMySQL string functions for real-world text data — CONCAT() and CONCAT_WS() for combining columns, UPPER() and LOWER() for case normalization, LENGTH() and CHAR_LENGTH(), SUBSTRING() and MID() for extraction, REPLACE(), TRIM(), LTRIM(), RTRIM() for cleaning, LOCATE() for searching within strings. Essential for data cleaning and report generation.
07
Sorting & Ranking Data — ORDER BYSingle and multi-column sorting with ORDER BY ASC/DESC, sorting by expressions and calculated columns, NULL handling in sort order, and using FIELD() for custom sort sequences. Introduction to window functions — ROW_NUMBER(), RANK(), and DENSE_RANK() for ranking records within partitions without losing any rows from the result set.
08
Saving, Executing & Modifying QueriesWorking professionally in MySQL Workbench — saving SQL scripts, organizing queries into files, using query history, executing partial selections, commenting complex queries for documentation, and modifying saved queries efficiently. Best practices for managing a library of reusable analytical queries.
09
Subqueries — Queries Within QueriesNon-correlated subqueries in WHERE, FROM, and SELECT positions — finding employees earning above the company average, products more expensive than the category average. Correlated subqueries that reference the outer query for row-by-row evaluation. EXISTS and NOT EXISTS for set membership testing. The powerful pattern of using subqueries instead of joins for complex filtering.
10
Views — Reusable Query AbstractionsCreating simple and complex views to encapsulate commonly used queries. WITH CHECK OPTION to prevent views from accepting data that doesn't meet the view's filter criteria. Updatable views vs. read-only views. Using views to simplify permissions, hide complexity from application developers, and create stable interfaces that survive schema changes.
11
Importing and Exporting DataBulk data operations — importing CSV and Excel data into MySQL using LOAD DATA INFILE and MySQL Workbench's import wizard. Exporting query results to CSV, Excel, and JSON for reporting. mysqldump for database-level export. Understanding character encoding issues that corrupt data during import/export and how to prevent them.
12
210+ Advanced Queries with SolutionsComprehensive practise across all advanced topics — 100+ advanced query exercises (aggregations, string manipulation, date calculations, ranking), 10+ data manipulation exercises (INSERT, UPDATE, DELETE with complex conditions), and 10+ subquery and view exercises. Complete annotated solutions explain not just the answer but the reasoning behind every approach.
Modules 5, 8 & 9: Joins, Views & Transaction Control
Real databases store data across multiple related tables — and joins are how you bring it all together. This module set covers every type of join with practical business examples, views for query reuse and security, and transaction control for maintaining data integrity when multiple operations must succeed or fail together. The skills that distinguish professional SQL developers from beginners.
3 ModulesInner JoinLeft JoinFull Outer JoinSelf JoinUNIONViewsCOMMIT & ROLLBACK70+ Queries
01
INNER JOIN — Matching Records in Both TablesThe most common join type — returning only rows where the join condition matches in both tables. Syntax with ON and USING clauses, joining on primary and foreign key relationships, multiple table joins in a single query (three, four, or more tables), and using table aliases to keep complex join queries readable. The foundation of relational data retrieval.
02
LEFT JOIN — All Rows From the Left TableRetrieving all rows from the left table plus matching rows from the right — including NULLs where no match exists. Finding customers who have never placed an order, employees not assigned to any project, products with no sales history. The critical difference from INNER JOIN for identifying gaps in data relationships.
03
FULL OUTER JOIN — All Rows From Both TablesCombining LEFT and RIGHT JOIN results to see all records from both tables regardless of matches. Simulating FULL OUTER JOIN in MySQL (which lacks native support) using UNION of LEFT and RIGHT joins. Use cases in data reconciliation — comparing two lists to find records unique to each side.
04
SELF JOIN — Joining a Table to ItselfQuerying hierarchical data within a single table — finding an employee's manager (both stored in the same employees table), comparing products in the same category, finding pairs of records that meet a condition. Self joins with clear table aliases, and when self-joins are the right pattern versus recursive CTEs.
05
UNION, EXCEPT & INTERSECT — Set OperationsCombining results from multiple queries with UNION (all unique rows from both queries) and UNION ALL (including duplicates). Simulating EXCEPT (rows in first query not in second) and INTERSECT (rows in both queries) in MySQL. Column count and type compatibility requirements, and practical use cases for combining data from multiple tables or time periods.
06
Presenting Query Results & Generating ReportsTransforming raw query output into meaningful reports — calculated columns for derived metrics, CASE expressions for conditional categorization (e.g., 'High/Medium/Low' sales tiers), column aliases for readable output, FORMAT() for number formatting. Structuring SELECT queries to produce output that stakeholders can read and act on directly.
07
Saving Query Results & ExportingUsing CREATE TABLE AS SELECT to materialize query results as a new table, INSERT INTO SELECT for populating tables from queries, exporting to CSV for Excel analysis, and generating formatted reports for non-technical stakeholders. Building automated reporting pipelines using stored query scripts.
08
Transaction Control — COMMIT & ROLLBACKWhat a transaction is — a set of operations that must all succeed or all fail together. START TRANSACTION, COMMIT to make changes permanent, ROLLBACK to undo all changes in the transaction. Real-world examples: bank transfers (debit one account, credit another — must both succeed), order processing (reserve stock + create order record — atomic operation).
09
SAVEPOINT — Partial RollbacksCreating named checkpoints within a transaction with SAVEPOINT, rolling back to a specific savepoint with ROLLBACK TO SAVEPOINT, and releasing savepoints. When to use savepoints in complex multi-step operations where you want the option to partially undo work without abandoning the entire transaction.
10
AUTO COMMIT & Transaction SettingsMySQL's default AUTO COMMIT mode — every statement is its own transaction. Disabling AUTO COMMIT for explicit transaction control, the difference between implicit and explicit transactions, and how to configure transaction behavior for different application requirements. Understanding when AUTO COMMIT causes data integrity problems in multi-step operations.
Module 10: MySQL Functions — String, Date, Control Flow & Casting
MySQL's built-in function library is one of the most powerful tools in any SQL developer's toolkit. This module covers all four major function categories: string-to-date conversion for handling inconsistent date formats, control flow functions for conditional logic inside queries, casting functions for data type conversion, and an extensive 100+ query practise set that applies all functions to real-world data transformation scenarios.
1 ModuleSTR_TO_DATEDATE_FORMATIF & CASEIFNULL & COALESCECAST & CONVERT100+ Queries
01
STR_TO_DATE() and DATE_FORMAT() — Date ConversionHandling the most common real-world data quality problem — dates stored as strings in inconsistent formats. STR_TO_DATE() to parse text into proper DATE or DATETIME values using format specifiers (%Y, %m, %d, %H, %i, %s). DATE_FORMAT() to output dates in any required display format — for reports, APIs, or regional formatting requirements (DD/MM/YYYY, MM-DD-YYYY, etc.).
02
Control Flow Functions — Conditional Logic in SQLEmbedding conditional logic directly in queries without procedural code. IF(condition, true_value, false_value) for simple binary conditions. CASE WHEN for multi-branch conditions — categorizing salary ranges, rating products, assigning grade letters, generating status labels. IFNULL() for NULL substitution, NULLIF() for converting specific values to NULL. The complete toolkit for conditional data transformation in SELECT and WHERE clauses.
03
Casting Functions — CAST() and CONVERT()Converting data between types safely — CAST(expression AS type) and CONVERT(expression, type) for transforming strings to numbers, numbers to strings, strings to dates, and between numeric types. Understanding implicit vs. explicit type conversion, when MySQL converts silently (and when that causes bugs), and using CAST to ensure correct arithmetic in mixed-type expressions. Essential for data cleaning and ETL processes.
04
100+ Function Queries with Complete SolutionsComprehensive practise applying all MySQL functions to realistic scenarios — formatting customer data for reports, converting imported date strings to DATE values, applying conditional pricing rules with CASE, type-safe arithmetic with CAST, NULL-safe calculations with COALESCE, and building complete data transformation pipelines using multiple functions composed together. All 100+ queries include full solutions and explanation of the function logic.
What You'll Learn
Learning Outcomes
Graduate as a confident SQL practitioner — capable of designing schemas, writing complex queries, managing transactions, and extracting meaningful insights from any relational database.
Design & Create Databases
Design normalized relational schemas with proper data types, primary and foreign key constraints, and referential integrity — building databases that scale cleanly and avoid the data quality problems that plague poorly designed systems.
Write Complex SQL Queries
Write SELECT queries of any complexity — multi-condition WHERE clauses, aggregate functions with GROUP BY and HAVING, subqueries in any position, and window functions for ranking and running totals — drawing precise answers from any dataset.
Master All Types of Joins
Confidently use INNER, LEFT, RIGHT, FULL OUTER, and SELF joins to combine data from multiple tables — the core skill that turns a database from a collection of isolated tables into an integrated information system you can query holistically.
Manage Transactions & Data Integrity
Use COMMIT, ROLLBACK, and SAVEPOINT to ensure that complex multi-step database operations either complete fully or leave the database unchanged — the ACID guarantee that protects production data in banking, e-commerce, and every critical application.
Create Views & Stored Queries
Encapsulate frequently-used complex queries as views, simplify application code by hiding schema complexity, implement basic access control by exposing only relevant columns through views, and build a reusable SQL query library for team use.
Apply MySQL Functions Expertly
Use MySQL's complete built-in function library — string manipulation, date conversion and formatting, conditional logic with IF/CASE, and type casting with CAST/CONVERT — to transform, clean, and present data exactly as required by any business or reporting need.
Who Should Join?
This Course Is For You
SQL is the most universally required technical skill in the job market today. Every software developer, data analyst, and backend engineer works with databases daily — and this course gives you that foundational fluency.
🎓
CS & IT Students
BCA, MCA, BTech CSE/IT, BSc Computer Science, and Diploma students. Database management is a compulsory exam topic — and learning it practically in MySQL makes the theory click. More importantly, it turns your resume into one that gets shortlisted for developer and analyst internships.
💻
Developers & Backend Engineers
PHP, Python, Java, and Node.js developers who use databases every day but have never formally learned SQL. This course turns you from someone who copies SQL from Stack Overflow into someone who understands exactly what their queries are doing — and can optimize them when they're slow.
📊
Aspiring Data Analysts
Anyone pursuing a career in data analytics, business intelligence, or data science. SQL is listed in every data analyst job description in India — and this course provides the complete SQL foundation you need before moving on to Power BI, Python Pandas, or any other analytics tool.
FAQ
Frequently Asked Questions
What is the fee for the DBMS course at PBA Institute?
The batch class fee is ₹6,000 for the complete course — 60 classes, 60 hours, 10 modules covering MySQL, SQL queries, joins, subqueries, views, transactions, and MySQL functions with 350+ solved queries. One-to-One personalized sessions are available at a higher fee with a fully flexible schedule. Both include study materials, software installation support, and an ISO-certified government-recognized certificate.
Do I need prior programming experience to join?
No prior programming or database experience is required. The course begins from the very basics — what a database is and why SQL is needed — before progressing through table creation, queries, joins, and advanced functions. PBA Institute teaches in Bengali and Hindi, ensuring no language barrier. All you need is a laptop and the willingness to learn.
What software will I learn during this course?
The course covers MySQL 8.0 Server (the world's most popular open-source RDBMS), MySQL Workbench (the official GUI tool for database design and query execution), and an introduction to Oracle Express Edition and Oracle Enterprise Edition — giving you familiarity with both the dominant open-source and enterprise database platforms.
Is the DBMS course available online?
Yes. PBA Institute offers both online and in-person DBMS classes with the same instructor, same curriculum, and the same live coding sessions as the Howrah campus. Online students participate in live sessions, get their queries reviewed in real time, and receive the same ISO-certified certificate as classroom students.
What jobs can I get after completing this DBMS course?
This course prepares you for roles including Database Administrator (DBA), SQL Developer, Backend Developer (MySQL focus), Data Analyst (SQL component), MIS Executive, and Junior Data Engineer. SQL is required in virtually every technology role, and this course provides the complete foundation. Many students combine this with PBA's Python or Data Analytics course for maximum job market value.
How is PBA Institute's DBMS certificate recognized?
You receive a course completion certificate from PBA Institute — ISO 9001:2015 Certified and MSME Government Registered. This is a recognized, government-backed credential that carries genuine weight when applying for database developer, SQL analyst, or backend developer roles across India. The MSME registration gives it official government standing unlike most private training certificates.
Turn Data Into Your Career
Ready to Master Database Management?
Join PBA Institute's DBMS course in Howrah. Master MySQL, SQL queries, joins, subqueries, views, transactions, and MySQL functions across 60 classes and 60 hours. Earn an ISO certificate and build the database skills that every software and analytics role in India demands.
Explore More
Related Courses
Build on your DBMS foundation with these courses at PBA Institute — every one a natural complement or next step in your data career.