This Course is Best Suited For

In Business Automation Ltd, Four development teams, SQA & Project operation team, Onsite IT operation team, MIS, and Implementation team will be benefited. Also, participants studying computer science to entry-level professionals and IT specialists seeking to deepen their understanding of database management and development.

✔      Participants will learn Basic DBMS overview from beginner to intermediate level.

✔      Participants will gain practical proficiency in designing and implementing databases, enhancing their employability in fields such as software development, data analysis, and database            administration.

✔      Participants will deepen their understanding of data management principles, enabling them to contribute effectively to projects involving data storage, retrieval, and manipulation.

✔      The training equips participants with sought-after skills in database engineering, opening up opportunities for career advancement and higher-paying roles in the technology sector.

Why Join

The purpose of Fundamentals of Database Engineering is to equip students with essential skills in designing, implementing, and managing databases. It aims to provide a solid foundation in database concepts and technologies necessary for developing robust and efficient data management systems. The course enables participants to understand and apply best practices in database design and maintenance across various domains.

What You'll Learn

Module-1: Basic DBMS

• Introduction of database management system
• Overview of Databases
• What is a database?
• Types of database
• DDL, DML, DCT, TCL
• Database Setup

Module-2: Database Design

• Modeling and planning a database (student-course-teacher)
• Creating a database, DROP, Rename, select DB
• Creating tables, alter-drop-rename, truncate tables.
• Naming tables
• Columns and data types
• Numbers and other types
• Designing Keys, Indexes, and Constraints
• Primary and foreign keys, composite key, unique key

Module-3: Manipulating Tables and Data

• CRUD Operations
• Insert Data into the Table
• Select Data from the Table
• Select Data with Filters
• Update Data in Table
• Delete Data from the Table

Module-4: Relationships and Foreign Keys

• What are Relationships, Foreign Keys, and Normalization
• Creating relationships
• One-to-many relationships
• One-to-many relationships
• One-to-one relationships
• Entity Relationship Diagram (ERD) and a sample project database design
• Joining Tables
• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• CROSS JOIN
• Self Join
• Union, union all

 Module-5: Database SQL

• Statement and clauses
• Operators & keyword
• Comments & NULL Values
• Aggregate Functions
• Scalar Functions
• Wildcards & Aliases
• CONCAT, group concrete
• Subqueries
• Select insert, select-update, select-delete
• CASE

Module-6: Database Optimization

• Normalization
• First normal form
• Second normal form
• Third normal form
• Denormalization

Module-7: Advance topics

• ACID and transactions
• Trigger
• Views
• Stored procedures
• Database import and export
• Access control, different types of user management
• DB backup, optimization, performance, migration, and maintenance