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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

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