20 MIN
LESSON
Database and training
Lesson schedule
Tutor score
positve
feedbacks
Students feedbacks
Tutor information
General information
nick | divyatak |
---|---|
country | India |
languages | English, Hindi |
contact |
|
Education
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