SD-70: Relational data base

3-Day Intensive Course for Technical Professionals

3 Intense Days
7 Hours per Day (Split into two 3.5-hour sessions)

Learning Path Visual

Your structured path from query basics to optimized relational systems:

Day 1: Core Concepts & SQL Foundations
Understand how relational databases work under the hood. Learn normalization, table design, and SQL syntax for querying and managing data.

Day 2: Joins, Transactions & Constraints
Explore multi-table relationships, inner and outer joins, integrity constraints, and transactional logic. Learn how to build robust, ACID-compliant systems.

Day 3: Indexing, Optimization & Administration
Implement indexing, query optimization, and view performance plans. Learn backup, user roles, and deployment strategies for production-grade RDBMS environments.

Course Overview

Relational databases remain the backbone of modern business systems — from web applications to financial platforms. This course gives developers, analysts, and IT professionals a full-stack understanding of relational design, SQL mastery, and database operations.

You’ll learn to design schemas, write advanced queries, and manage relational systems with best practices in data integrity, normalization, security, and performance.

You’ll learn how to:

• Design and normalize relational database schemas

• Use SQL to query, insert, update, and delete records

• Create relationships with foreign keys and enforce integrity constraints

• Implement transactions and understand ACID principles

• Use joins to work with multi-table systems

• Analyze performance using EXPLAIN plans

• Apply indexing strategies for large datasets

• Administer roles, backups, and user access in production

This course is ideal for learners transitioning from spreadsheets or NoSQL to structured data models and enterprise-grade RDBMS tools.

What’s Inside Each Day

Day 1 — Core Concepts & SQL Foundations

• What is a relational database?

• Entity-relationship modeling and schema design

• Normal forms: 1NF, 2NF, 3NF

• Creating tables and setting data types

• SQL basics: SELECT, INSERT, UPDATE, DELETE

• Filtering, ordering, aliases, and wildcards

• Hands-on: Design and populate a normalized database

Tools: PostgreSQL, MySQL, SQLite (CLI or GUI like DBeaver)
Focus: Schema Design • Data Modeling • SQL Syntax

Day 2 — Joins, Transactions & Constraints

• Foreign keys and referential integrity

• One-to-one, one-to-many, and many-to-many relationships

• Transactions: BEGIN, COMMIT, ROLLBACK

• Joins: INNER, LEFT, RIGHT, FULL OUTER

• Aggregate functions: GROUP BY, HAVING

• Hands-on: Write multi-table queries with joins and nested selects

Tools: PostgreSQL, MySQL Workbench or pgAdmin
Focus: Data Integrity • Querying Across Tables • Transaction Logic

Day 3 — Indexing, Optimization & Administration

• Indexes: B-tree, hash, composite

• Using EXPLAIN and query plans for optimization

• Views and materialized views

• Database user roles and access privileges

• Backup and restore (pg_dump, mysqldump)

• Hands-on: Optimize slow queries and set up user permissions

Tools: PostgreSQL, MySQL CLI/Admin tools
Focus: Performance • Security • Operational Management

Course Goals

By the end of this course, you’ll be able to:

• Model and design relational schemas that scale

• Query and manipulate relational data using SQL

• Apply joins and aggregate functions to extract insights

• Use transactions and constraints to maintain integrity

• Optimize queries and analyze performance bottlenecks

• Administer users and secure database environments

Who Should Take This Course?

• Developers working on data-backed applications

• Data analysts moving beyond spreadsheets

• Backend engineers integrating SQL databases

• Sysadmins and DevOps managing database systems

• Students or professionals learning core database theory

Class Reference: SD-70
Form Updated on: 06/16/2025 (Version 1)
Last Modified on: 06/16/2025

Program Note

This course uses open-source RDBMS tools and includes real-world use cases across finance, retail, healthcare, and software development — with optional migration labs (from spreadsheets or NoSQL to relational schemas).

Use the links for more tutorial:

Java point: https://www.javatpoint.com/dbms-tutorial

W3school: https://www.w3schools.com/SQL/sql_intro.asp

Microsoft: https://docs.microsoft.com/en-us/sql/?view=sql-server-ver15

MySQL: https://dev.mysql.com/doc/