eMaestro - Learn | Excel | Arise

Database management

A DBMS provides mechanisms to deal with this kind of data inconsistency while allowing users to access data concurrently. A DBMS implements ACID(atomicity, durability, isolation , consistency) properties to ensure efficient transaction management without data corruption.

Database management Course

Course Syllabus

1. Introduction to Databases

Why and When are Databases needed ?
Relational Database Concepts
Database tables , Keys and Relations

2. Practical - Design a Simple Database

SQL (Structured Query Language)
What is SQL ? What SQL isn't ?
DDL (Data Definition Language) - Basic Data table operations
DML (Data Manipulation Language ) - Basic Database operations(Create,Read,Update,Delete,Insert)
Variable Types
Operators in SQL
Clauses (WHERE , AND ,No)

3. Write Queries to

Create tables
Insert data into tables
Read the data
Update data
Delete data

4. Advanced SQL

Working with multiple tables
Functions and their usages (SUM ,AVG..)
Writing Subqueries

5. Practical - Wirte advanced queries for

Summarizing data
Filtering Data