💠 Database Management System Concept

Objective: This lab-based Oracle SQL tutorial is designed to build a strong practical foundation in SQL programming using Oracle Database. Each lab includes step-by-step exercises, real-world scenarios, and SQL scripts for active learning.

🔍 Lab 1: Introduction & Basic Queries

Explore Oracle SQL*Plus
SELECT – Retrieve data from a table
Practice: Query employees and departments
Analytical SQL Questions for Employees & Departments

🔃 Lab 2: Sorting and Filtering Data

🔗 Lab 3: Joining Tables

📊 Lab 4: Grouping and Aggregation

🔁 Lab 5: Subqueries

➕ Lab 6: Set Operations

🔄 Lab 7: Pivoting Data

🎚 Lab 8: Limiting Rows

🏗 Lab 9: Creating and Modifying Tables

📁 Lab 10: Data Types

🔐 Lab 11: Constraints

✏️ Lab 12: Modifying Data

⏳ Lab 13: Temporary Tables

👁 Lab 14: Views

⚡ Lab 15: Indexes

📛 Lab 16: Synonyms

CREATE, DROP SYNONYM
Practice: Use synonyms for object access

🔢 Lab 17: Sequences

🔢 SQL & PL/SQL CONCEPTUAL EXERCISE

📛 PL SQL LAB Based Exercise

Section 1: SQL Subquery & Join Questions (30 Questions)

Overview of Subqueries
- Single-row vs Multi-row Subqueries
- Correlated vs Non-Correlated Subqueries
Overview of SQL Joins
- INNER, LEFT, RIGHT, FULL OUTER, CROSS
Combining Subqueries with Joins
Lab Questions 1–30

Section 2: PL/SQL Trigger Lab Exam (30 Questions)

Introduction to PL/SQL Triggers
Types of Triggers: BEFORE, AFTER, INSTEAD OF
Row-level vs Statement-level Triggers
Trigger Syntax and Examples
Lab Questions 1–30

Section 3: PL/SQL Stored Procedure

Q31 – Safe Delete Product with Exception Handling

Section 4: PL/SQL Cursor Lab Exam (30 Questions)

Introduction to Cursors
Implicit vs Explicit Cursors
Cursor Attributes (%ROWCOUNT, %FOUND, %NOTFOUND, %ISOPEN)
Cursor Loops and FOR Loops
Lab Questions 1–30

Section 5: Additional Resources

Best Practices for PL/SQL and SQL Queries
Common Errors and Debugging Tips
Recommended References and Tutorials

🧰 Tools Required

Oracle Database (XE or Standard)
SQL Developer or compatible tool
Sample schema: HR, SCOTT, or custom dataset

✅ Learning Outcomes

Master Oracle SQL fundamentals
Write optimized SQL queries
Design and manage Oracle database objects

📘 C Programming Language

🖥️ Learn C Programming From Scratch

Master C with practical examples, easy tutorials, and hands-on projects

📘 C Programming Syllabus

This is a detailed C programming syllabus designed for a 6-month semester. It is suitable for undergraduate students or beginners learning C programming.

📘 Module 1: Introduction to Programming (Weeks 1–2)

💡 Practice Problems for C Programming

Variables, Input, and Output: Write a C program to declare variables, take user input, and display the output.

Integer Data with Arithmetic Operators: Perform basic arithmetic operations using C.

Integer Division with Type Casting: Display division result as a floating-point using type casting.

Area of a Circle: Calculate area using π × r².

Celsius to Fahrenheit Conversion: Convert Celsius temperature to Fahrenheit.

Absolute Value: Display absolute value of any number.

Float & Double Manipulation: Handle and display float/double types.

Even / Odd Check: Check if a number is even or odd.

Positive / Negative / Zero: Check a number's sign.

Find Largest and Smallest: Determine the largest and smallest of three numbers.

🎥 Reference Videos: Playlist 1 Playlist 2

🧮 Module 2: Operators and Expressions (Week 3)

Practice Problems for C Programming

🔁 Module 3: Control Structures (Weeks 4–5)

Decision making:

Loops:

Jump statements:

🧵 Module 4: Arrays and Strings (Weeks 6–7)

1D Arrays
2D Arrays
Multidimensional Arrays
C String Programming Basics
5 beginner-friendly problems with code of String in C
String operations and functions (strcpy, strlen, etc.)

Array Practice Problems

String Practice Problems

🆕Top 5 Array and String Problems in C (ICPC Style) 🌟

🧩 Module 5: Functions (Weeks 8–9)

📍 Module 6: Pointers (Weeks 10–11)

📦 Module 7: Structures and Unions (Weeks 12–13)

📁 Module 8: File Handling (Weeks 14–15)

💾 Module 9: Dynamic Memory Allocation (Week 16)

Memory allocation functions: malloc(), calloc(), realloc(), free()
Memory leaks and handling

⚙️ Module 10: Preprocessor Directives (Week 17)

#define, #include, #ifdef, #ifndef
Macros and conditional compilation

🔀 Module 11: Miscellaneous Topics (Week 18)

Command-line arguments
Enumerations and typedefs

🛠️ Weeks 19–24: Project & Final Assessment

Mini project development
Internal assessments and lab tests
Final practical and written exams

🧪 Lab Work / Assignments

Write a C program in fill up an array using pointer with array.

Sort and array in ascending and descending order.

Write a C program to input 5 values into an array and use a pointer to calculate sum of all values.

Write a program in C to display the longest word in a sentence.

Write a program to display the number of vowel, number and special character in a word given by the user.

Write a C program which contains multiple types user defined functions. Like-

       No No → No arguments, No return
       Yes No → Arguments, No return
       No Yes → No arguments, Return
       Yes Yes → Arguments and Return

Write a C program using Call by Value and Call by Reference.
Write any program using local and global variables in terms of scope, lifetime, and accessibility.
Write a C program that uses a recursive function to calculate and display the factorial of a number.
Write a C program that takes a string as input from the user and checks whether the string is a palindrome or not using pointers.

Write a C program to input two strings from the user and find the longest common substring between them. The program should check the characters of both strings and display the longest sequence of consecutive characters that appears in both strings.

Input:

String 1: ahsan

String 2: ahsanarif

Output:

Longest Common Substring: ahsan

a. Write a C program that takes an integer n and prints the following pattern using nested loops. For n = 5:

   5
   5 6
   5 6 7
   5 6 7 8
   5 6 7 8 9

Write a C program to input two numeric arrays of the same size and add their corresponding elements. Store the results in a third array and display the resulting array.

   Example:
   Sample Input:
   Array 1: 1 2 3 4
   Array 2: 5 6 7 8
   Sample Output:
   Result: 6 8 10 12

A B C D
B C D E
C D E F
D E F G

                  A
                  B A
               C B A
           D C B A

Develop a C program to draw a pattern of characters like the one shown below:

                A
              B B
            C C C
          D D D D

SQL Insert command in details

Understanding the SQL INSERT Command

Let’s take a closer look at the SQL INSERT command below:

INSERT INTO customers
(customer_id, first_name, last_name, email, created_at)
VALUES (101, 'Ahsan', 'Arif', 'aa@x.com', '11-jan-4');

At first glance, this might appear to be a basic statement, but it plays a vital role in managing data within relational databases. Let’s break it down.

INSERT INTO customers

This tells the database to add a new record to the customers table—a central location where client information is stored. Keeping this data accurate and up to date is key for managing customer relationships effectively.

Column List

Within the parentheses, we list the fields where data will be inserted:

customer_id: A unique identifier for each customer, ensuring proper tracking and referencing.
first_name and last_name: These fields store the customer's name for personalization and service.
email: Critical for communication—used for updates, offers, and notifications.
created_at: A timestamp marking when the record was created, useful for historical tracking and analysis.

VALUES Clause

Here we provide the actual data:

101 as the customer ID
'Ahsan' as the first name
'Arif' as the last name
'aa@x.com' as the email
'11-jan-4' as the creation date

Why It Matters

Each insert like this keeps the customer database current. Accurate data entry is essential—it drives better insights, personalized services, targeted marketing, and streamlined operations.

Real-World Impact

Whether it's a retail brand tailoring promotions or a service team addressing customer needs, having precise and structured customer data enables more effective engagement and decision-making.

Final Thoughts

This simple command highlights the power of structured data. Every row added brings value—not just as stored information, but as an opportunity to understand and serve customers better. As you continue exploring SQL, remember that even the most basic operations are foundational to effective data management.

Thanks for reading—I hope this breakdown clarified how meaningful even a single SQL statement can be.