United States | (UTC+05:30)  change

Database concepts and SQL



INR 4000.00

Course Code7121VVB7
Duration90 day(s)

Program Manager

Dr KRV Subramanian

sandeep@thegrace.in

919886003702


Social


This course is offered By Radix Learning Pvt. Ltd.

Course Objective

This course will help an entry-level programmer learn the foundational concepts of Relational Database Management Systems and to apply these in practice. It also helps in learning how to use the Structured Query Language to work with databases.

Learning Tools

  • Study Material - Standard
  • Radix Learning
  • Assessment
  • Participant Questions
  • Forum

Mode of Payment

1. Online

Course Delivery and Access Methodology

The course is delivered over internet.  You must complete the enrollment process before you can access the course.
You must use Internet Explorer 11.0 (or above), Mozilla Firefox 35.0 (or above) or Google Chrome 40.0 (or above) to use Quampus. Additionally you must install Adobe Flash Player (latest version) in your browser also.  Your browser must have Java Scripts enabled. There may not be difficulty in running on other browsers, but it is not tested on them.

Withdrawal and Refund Policy

Withdrawal is permitted but there will be no refund of payment.


Collapse

Chapter 1: Introduction to Databases & Database Management Systems

Reference(s):
  • To articulate the need, role and importance of database in software applications
    To establish the need for data independence and a system to handle complexities of data handling
    To explain the different models of database systems
    To introduce the basic principles, theory and concepts of relational databases

Chapter 2: Basics of Database Modeling & Entity-Relationship Diagrams

Reference(s):
  • To lay the foundations of database design concepts
    To enumerate the different distinct steps involved in database design
    To explain the nature, role and importance of entities and their relationships
    To discuss ER diagrams, the notations and methods of developing them

Chapter 3: Applications of E-R Modeling I

Reference(s):
  • To enable the learner to perform ER modeling in specific situations
    To illustrate the process involved in doing ER modeling

Chapter 4: Applications of E-R Modeling II

Reference(s):
  • To strengthen to foundations of ER modeling through guided problem solving
    To explain the advanced concepts of ER modelling

Chapter 5: Introduction to Database Normalization - Why, What, How

Reference(s):
  • To explain the need and importance of normalization
    To define what normalization is
    To enable the learner to examine relational tables and state the need for normalization
    To gain an understanding about the different kinds of normal forms

Chapter 6: The First Form

Reference(s):
  • To enable the learner to define what First Normal Form is
    To normalize a database into First Normal Form

Chapter 7: The Second Normal Form

Reference(s):
  • To enable the learner to define what Second Normal Form is
    To normalize a database into Second Normal Form

Chapter 8: The Third Normal Form

Reference(s):
  • To enable the learner to define what Third Normal Form is
    To state the advantages of having the databases in third normal form
    To state the consequences of not having databases in third normal form
    To normalize a database into Third Normal Form

Chapter 9: The Boyce-Coed Normal Form

Reference(s):
  • To enable the learner to define what Fourth Normal Form or BCNF is
    To state the advantages of having the databases in BCNF normal form
    To state the consequences of not having databases in BCNF normal form
    To normalize a database into BCNF Normal Form
    To articulate the complexities and tradeoffs involved in performing BCNF and not having databases in BCNF

Chapter 10: Introduction to Structured Query Language (SQL)

Reference(s):
  • To lay the foundations of structured query language
    To discuss the role, importance and uses of DDL, DML and DCL
    To enable learner to write a simple select and a conditional select statement

Chapter 11: Using SQL - I

Reference(s):
  • To explain the usage of aggregate functions
    To enumerate the various logical operators and their order of precedence in evaluation
    To enable learners to use SQL in specific situations through a miscellany of illustrations

Chapter 12: Using SQL - II

Reference(s):
  • To strengthen the foundation of using SQL through a miscellany of nontrivial cases
    To enable the learner to develop capabilities to demonstrate correct use of SQL in problem solving

Chapter 13: Elements of joins

Reference(s):
  • To articulate the need for an operation like JOIN
    To enumerate the different JOIN operations through appropriate illustrations
    To explain the usage of the GROUP BY clause and the HAVING clause
    To discuss the nature, role and importance of writing subqueries

Chapter 14: Managing Database Objects

Reference(s):
  • To explain the components of a typical RDBMS
    To discuss ways of creating tables in a RDBMS, with and without cnstraints
    To enumerate some of the main constraints encountered in most applications
    To obtain an overview of the various tasks and methods involved in managing database objects

Chapter 15: Data Dictionary and Database Security

Reference(s):
  • To discuss the nature and importance of data dictionary
    To explain the main ways of using a data dictionary
    To articulate the nature and importance of database security
    To explain the issues involved in administering databases with security as prime concern

Chapter 16: A Peek at What Lies Ahead in RDBMS

Reference(s):
  • To discuss the evolution and challenges of RDBMS
    To enumerate some of the main concerns being addressed in modern RDBMS
    To provide a view of the path of evolution that RDBMS are likely to take

Mr. Rahul Kumar Choubey
Assigned Subjects
  • Database concepts and SQL (BTH0000236)