Data analyst training with LIVE projects

School Of Analytics
In New Delhi

Price on request
You can also call the Study Centre
93126... More
Compare this course with other similar courses
See all

Important information

  • 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

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

Compare this course with other similar courses
See all