Course Details

Back To All Courses
Course Image

Course Overview

Oracle Database – SQL Fundamentals I - Batch 2

Course Code: MC15007
Course Title: Oracle Database – SQL Fundamentals I
Start Date: October 15, 2025 📅
Duration: 20 hours ⏰
Mode: Blended (in-person, online, site visit) 🌐
Class Size: 30 participants 👥
Course Equivalent: 1 Credit Hour
Course Fee: 6000 BDT; (Discount Price: 4000 BDT)

Course Description 🗄️
Oracle Database – SQL Fundamentals I (MC15007) addresses the high demand for SQL skills across industries, as a foundational requirement for data analysts, database administrators, and backend developers. Aligned with Oracle Certification (1Z0-071), this course offers hands-on training in SQL query writing, data manipulation, and schema management using Oracle Database. Through practical tasks and a capstone project, learners will gain proficiency in relational databases, preparing for certification and real-world roles in IT and data management. 🚀

Learning Outcomes
Participants will:

  • Write and execute SQL queries in Oracle Database. ✍️

  • Understand relational database systems and Oracle architecture. 🗄️

  • Use functions, joins, subqueries, and schema objects effectively. 🔍

  • Prepare for Oracle 1Z0-071 certification. 📜

Target Audience 🎓

  • University students, IT learners.

  • Beginners in programming or databases.

  • Software developers seeking database skills.

  • Oracle SQL certification aspirants.

Entry Requirements 📋

  • Basic computer literacy.

  • No prior programming experience required.

  • Access to a computer with Oracle XE and SQL Developer installed.

  • Minimum age: 20 years (recommended).

Career Pathways 🚀

  • Oracle 1Z0-071 certification.

  • Advanced Oracle PL/SQL or database administration courses.

  • Roles: SQL Developer, Data Analyst, Database Administrator.

Course Details
Duration: 15 Oct 2025 - 31 Dec 2025
Faculty: Science and Information Technology
Level: Beginner to Advanced
Mode: Hybrid
Price: 4000 BDT 6000
Your Instructors
Instructor
Mayen Uddin Mojumdar

Senior Lecturer, Dept. of CSE, Daffodil International University
Instructor
Md. Sadhan Sarkar

Project Lead, Senior Software Engineer, Reve Systems Ltd.
What You'll Learn
  • Module 1: Intro to Databases & Oracle Environment: Database concepts, Oracle architecture.
  • Module 2: Basic SQL Queries: SELECT statements, filtering data; Functions & Expressions: Using SQL functions, conditional expressions.
  • Module 3: Aggregate Functions & Grouping: GROUP BY, HAVING clauses; Data Manipulation (DML): INSERT, UPDATE, DELETE operations.
  • Module 4: Tables & Schema Objects: Creating and managing database objects; Joins & Subqueries: Combining data, nested queries.
  • Module 5: Views & Indexes: Enhancing performance and usability. (Assessments: Quizzes, practical tasks, capstone project)
Ready to Start Learning?

Join thousands of students already enrolled

Lifetime access

Certificate included

30-day money back

Enroll Now