Database Management System Course – Learning Centre [AweGenie]

DBMS - AweGenie

ABOUT THE COURSE 

Databases form the backbone of all major applications today – tightly or loosely coupled, intranet or internet based, financial, social, administrative, and so on. Structured Database Management Systems (DBMS) based on relational and other models have long formed the basis for such databases. Consequently, Oracle, Microsoft SQL Server, Sybase etc. have emerged as leading commercial systems while MySQL, PostgreSQL etc. lead in open source and free domain. While DBMS’s differ in details, they share a common set of models, design paradigms and a Structured Query Language (SQL). In this background the course would examine data structures, file organizations, concepts and principles of DBMS’s, data analysis, database design, data modeling, database management, data & query optimization, and database implementation. More specifically, the course introduces relational data models; entity-relationship modeling, SQL, data normalization, and database design. It would also introduce query coding practices using MySQL (or any other open system) through various assignments. Design of simple multi-tier client/server architectures based and Web-based database applications will also be introduced.

INTENDED AUDIENCE:

  • Students from all disciplines can enroll for this course.

PRE-REQUISTES:

  • Knowledge of Programming
  • Data Structure and Algorithms

INDUSTRY SUPPORT :
DBMS is so fundamental that all companies dealing with systems as well as application development (including web, IoT, embedded systems) have a need for the same. These include –

  • Microsoft
  • Samsung
  • Xerox
  • Yahoo
  • Google
  • IBM
  • TCS
  • Infosys
  • Amazon
  • Flipkart, etc.

COURSE

1. LECTURES

  1. DBMS Introduction
  2. DBMS Architecture – Part I
  3. DBMS Architecture – Part II
  4. DBMS ER Models
  5. DBMS Data Models
  6. DBMS ER Model to Relational Model
  7. SQL(Structured Query Language) Introduction
  8. SQL DDL – I
  9. DML Queries
  10. Functional Dependencies
  11. Normalisation
  12. Views
  13. SQL DCL
  14. SQL DDL – II
  15. Multi User Database Processing
  16. Security & Recovery

2. ASSIGNMENTS – Click here to download

3. PROJECTS –  Click here to download

4. PAPERS – Click here to download

Please follow and like us:

Author: Genie Rahul

AI enthusiast with a dream to help student community.

Leave a Reply

Your email address will not be published. Required fields are marked *