Data analyst training with LIVE projects
Training
In New Delhi
Price on request
Description
-
Type
Training
-
Location
New delhi
-
Class hours
20h
Facilities
Location
Start date
New Delhi
(Delhi)
See map
65,1st floor,Rampuri,kalkaji,new delhi, 110019
Start date
On request
Reviews
Have you taken this course?
Course programme
RDBMS CONCEPTS:-
• What is RDBMS
• Codd’s Rules
• Functional dependency
• Partial dependency
• Transitive dependency
• Normalization o Ist Normal Form o IInd Normal Form o IIIrd Normal (BCNF)
• Primary key, Foreign Key, Candidate Key
• Entity, Attributes, Relationship
• ER Modeling
• Cardinality
• Management of Locks
• Data Types
• DML (Data Manipulation Language)
• Select
• Insert
• Delete
• Update
• DDL (Data Definition Language)
• Alter
• Create
• Drop
• Truncate
• DCL (Data Control Language)
• Grant
• Revoke
• TCL (Transaction Control language)
• Commit
• Rollback
• Save points
• Constraints
• Primary Key
• Foreign key
• Check
• not null
• Unique
• %type, %row type
• Conditional Structure
• If
• Then
• Else Loop
• End loop
• For loop
• While loop
• Cursor (Éxplicit, Implicit) and cursor variable
• Error handling with exception
• Brief Introduction of Function, Procedure, Package, Trigger
• Brief idea of view, index, sequence
• Data modeling
• Modeling concepts
• Understanding data modeling concepts
• Enterprise Data modeling
• Relationship types
• Relationship cardinality
• Dimensional Modeling
• Defining entity types
• Primary Key , foreign key
• Report generation
• Creating logical Model
• Creating physical model
Data analyst training with LIVE projects
Price on request