RDBMS Fundamentals: A Beginner's Guide

Welcome to the world of Relational Database Management Systems (RDBMS)! This beginner's guide is designed to introduce you to the fundamental concepts and principles that underpin these powerful database systems. Whether you're a budding programmer, a curious data enthusiast, or simply someone looking to understand how databases work, this resource will provide you with a solid foundation.

In this guide, we will cover the following key topics:

• What is an RDBMS? A basic overview of RDBMS and its role in data management.

• Key Components of an RDBMS: Understanding the essential parts of a database system, including tables, columns, rows, and relationships.

• Data Types: Exploring the different types of data that can be stored in an RDBMS.

• Normalisation: Learning about the process of organizing data to minimize redundancy and improve data integrity.

• SQL Basics: A brief introduction to SQL, the standard language for interacting with RDBMS.

By the end of this guide, you will have a clear understanding of how RDBMS work and be equipped to start exploring databases on your own.

Table of Contents

1. Introduction to Database

2. Understanding Database Architecture

3. Understanding Databases Terminologies

4. The 12 Rules (Codd's Rules) for Database

5. First Form of Normalization (1NF) in RDBMS

6. Second form of Normalization (2NF) in RDBMS

7. Third form of Normalization (3NF) in RDBMS

8. Boyce Codd Normal Form (BCNF) in RDBMS

9. Introduction to SQL (Structured Query Language)

10. Datatypes in Oracle DB

11. Creating New Table in Database

12. Creating New Table from another Table

13. Insert (Add) new Records in Table

14. Updating Records in Table

15. Delete Records in Table

16. Alter Command to change Table Structure

17. Retrieving Data from Tables

18. Retrieving Data based on Matching Patterns in SQL

19. Handling NULL Values and Ordering Results

20. Aggregate Functions and Grouping Table data

21. Understanding Views in SQL

22. Indexing in Table Data in SQL

23. Managing Privileges

24. Commit and Rollback

25. Functions in Oracle

26. Joining Tables in Oracle

27. Set Operator in Oracle

28. Introduction to PL/SQL

29. PL/SQL Architecture and Block Structure

30. Fundamentals of PL/SQL

31. Assignment and Expression in PL/SQL

32. Condition and Iterative Controls in PL/SQL