Data analyst training with LIVE projects

School Of Analytics
In New Delhi

Price on request
You can also call the Study Centre
93126... More
Want to speak to an Advisor about this course?

Important information

Typology Training
Start New delhi
Class hours 20 hours of class
  • Training
  • New delhi
  • 20 hours of class
Description

Important information
Venues

Where and when

Starts Location
On request
New Delhi
65,1st floor,Rampuri,kalkaji,new delhi, 110019, Delhi, India
See map
Starts On request
Location
New Delhi
65,1st floor,Rampuri,kalkaji,new delhi, 110019, Delhi, India
See map

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

Achievements for this centre


Students that were interested in this course also looked at...
See all