20 MIN

Database and training

Score: 0
20.00 USD /single lesson (60 min.)
Science / Computer Science / Da...

Lesson schedule

Tutor score

Lessons given:

Students feedbacks

Tutor information

General information

nick divyatak
country India
languages English, Hindi


Experienc e Summary:

I am working in an IT firm with 2 years of experience ,i have qualified UGC NET in Computer science in 2014 and now taking online as well as offline classes. I am passionate about teaching,i would love to share my Knowledge with all.

Education Detail:

Bac helor of Computer Applications (B.C.A.) from Banasthali University in 2010.

Master of Computer Applications (M.C.A.) from Banasthali University in 2013.

Teaching Experience in School or College:

I have taught in many coaching classes,I have qualified UGC NET in computer science, I can teach most of the subjects of computer science (C,C++,Java ,DBMS ,OS ,Networking,Compiler design,Data Structures etc) And I can also teach Aptitude,Reasoning, and I can also give coaching for NET computer science.

Experience: 2 years

About me

The Data base training include Detailes Training of Database,SQL,PLSQL and RDBMS.

Student can learn these four cources individualy also.

Course Structure

1.Basic concepts

1.1 Database and Need for DBMS

1.2 Characteristics of DBMS

1.3 Database Users

1.4 3-tier architecture of DBMS 6

(its advantages over 2-tier)

1.5 Data Models

1.6 Views of data-schemas and instances

1.7 Data Independence

2 Database Design using ER model

2.1 Entities

2.2 Relationships

2.3 Representation of entities, attributes,

relationship attributes, relationship set

2.4 Generalization, aggregation

2.5 Structure of relational Database and

different types of keys.

Expressing M: N relation

2.7 Reducing ER diagrams to tables.

3 Relational Model

3.1 Codd’s rules

3.2 Relational data model & relational algebra

3.2.1Relational model concept

3.2.2Relational model constraints

3.2.3Relational Algebra

3.3 Relational database language

Data definition in SQL, Views and

Queries in SQL, Specifying constraints

and Indexes in SQL.

4 Relational Database design

4.1 Database Design – ER to Relational

4.2 Functional dependencies

4.3 Normalization

Normal forms based on primary keys

(1 NF, 2 NF, 3 NF, BCNF, 4 NF, 5 NF)

4.4 Loss less joins and dependency

preserving decomposition

5. SQL in Detail

6.PLSQL in Detail

7. Introduction to RDBMS 

8. Transaction Mangement

9. Concurrency Control

10. Recovery System