Database Management Course

Course Overview

Axcore Training Academy offers a database management course with a core focus to augment knowledge fundamental and relational database systems. It further covers the types of DBMS, the advantages of a DBMS. In order to demonstrate the upgradations in practice and theories over database management system with examples will be provided.

DBMS have similarities with running systems: both manipulate memory, procedure scheduling, I/O, communication

• In addition, DBMSs put into effect many data-management functions
• Other name for DBMS: database system, database manager
• DBMSs normally do not use the file machine of the working gadget of the machine
  where they are installed. Instead, the define their own richer file groups and
  access methods.

A single database typically serves the desires of a community of customers ⇒ different
perspectives or views on the same records are frequently natural

• View: some subset of the database or some restructuring of the database suited
  for an application
• Views are redundant with the simple definition of the database (they may also or may
  not be saved explicitly, this is an efficiency issue)
• DBMS takes care of the correspondence between views and database data
• View definitions are section of the database schema
• Other terms for view: subschema, exterior schema, derived relation

Course Requisites

1. Fundamental knowdlege regarding database concepts

Module 1

1. Overview of Database concepts and Relational Models
2. Overview of Database Architecture
3. Overview of Relational Database Languages
4. Data Modeling with help of Relationship Diagrams

Module 2

1. SQL
2. Web Database Programming
3. Conceptual Data Modeling
4. XML, XQuery and X Path

Module 3

1. Ontology and Data Model
2. Semantic Web
3. RDF, RDF Schema, and OWL
4. Storage and Indexing

 Module 4

1. Query processing and optimization
2. Parallel and distributed databases
3. NoSQL databases
4. Final Output