uLektz Skills

Learning Path

Non-Linear: Random Order

About the Course

Course Description

The course emphasizes the understanding of the fundamentals of relational systems including data models, SQL & query Optimization, Transaction Processing and concurrency control, Database technology and Advanced topics.

Objectives

1.Will familiarize about DBMS, QL & Query Optimization

2.Will demonstrate the Transaction Processing and Concurrency Control

3.Will develop knowledge in Advanced Topics like Database security, Database access, Control Cryptography and XML Databases

Prerequisite

There is no particular prerequisite to learn Database Management Systems, you will be able to do very well, if you have these basic skills:

1. Basic Programming Knowledge

2. Good Computer Knowledge

3. Good communication skills.

Course Study Materials

Module 1: Introduction to DBMS

1.1 File Systems Organization
1.2 Sequential, Pointer, Indexed, Direct
1.3 Purpose of Database System
1.4 Components of DBMS
1.5 Relational Algebra.
1.6 Logical Database Design: Relational DBMS
1.7 Domain Key Normal Form
1.8 Denormalization
Introduction to DBMS - Assessment 10 Questions

Module 2: SQL & Query Optimization

2.1 SQL Standards
2.2 Data types
2.3 Database Objects
2.4 QUERY OPTIMIZATION: Query Processing and Optimization
SQL & Query Optimization - Assessment 10 Questions

Module 3: Transaction Processing and Concurrency Control

3.1 Introduction
3.2 Properties of Transaction
3.3 Serializability
3.4 Concurrency Control
3.5 Locking Mechanisms
Transaction Processing and Concurrency Control - Assessment 10 Questions

Module 4: Trends in Database Technology

4.1 Overview of Physical Storage Media
4.2 Magnetic Disks
4.3 RAID
4.4 Tertiary storage
4.5 File Organization
4.6 Organization of Records in Files
4.7 Indexing and Hashing
4.8 Introduction to Distributed Databases
4.9 Data Warehouse
4.10 Mining
4.11 Data marts
Trends in Database Technology - Assessment 10 Questions

Module 5: Advanced Topics

5.1 DATABASE SECURITY: Data Classification
5.2 Threats and risks
5.3 Database access Control
5.4 Types of Privileges
5.5 Cryptography
5.6 Statistical Databases
5.7 Distributed Databases
5.8 Architecture
5.9 Transaction Processing
5.10 Data Warehousing and Mining
5.11 Classification
5.12 Association rules
5.13 Clustering
5.14 Information Retrieval
5.15 Relevance ranking
5.16 Crawling and Indexing the Web
5.17 Object Oriented Databases
5.18 XML Databases
Advanced Topics - Assessment 10 Questions

Final Assessment

Final Assessment 20 Questions

The certificate issued for the Course will have

Student's Name
Photograph
Course Title
Certificate Number
Date of Course Completion
Name(s) and Logo(s) of the Certifying Bodies

Only the e-certificate will be made available. No Hard copies. The certificates issued by The Academic Council of uLektz. can be e-verifiable at www.ulektzskills.com/verify.

Students will be assessed both at the end of each module and at the end of the Course.
Students scoring a minimum of 50% in the assessments are considered for Certifications