SAS consultant in Delhi Gurgaon Noida

SAS consultant in Delhi Gurgaon Noida

Debendra Dhir
Debendra Dhir is a SAS instructor and consultant. A SAS user since 2002, he holds the following certifications for SAS 9 and SAS enterprise miner 7.1: SAS Certified Base Programmer, SAS Certified Advanced Programmer, Predictive Modeling with SAS® Enterprise Miner 7.1 , SAS Certified Statistical Business Analyst Using SAS 9: Regression and Modeling and SAS Certified Clinical Trials Programmer Using SAS 9,
He is passionate about teaching SAS technologies to transform business processes. His expertise is in combining the power of SAS programming and SAS analytics to build effective and actionable SAS applications. He has a M.Tech degree in computer science from Jawaharlal Nehru University , New Delhi.
He has Delivered corporate training to   Royal Bank of Scotland(RBS),Maruti Suzuki India Ltd. ,Smart Analyst,ICT, Datamatics WNS,Reliance group.

He has Experience with multivariate statistical methods, decision tree, and
Data mining with Neural networks.
He has Worked in different project with Grail Research, Samsung India

Postgresql training in delhi gurgaon noida

About Postgresql

There are many paid or free database . Postgresql is free opensouce databse  and  it is is constantly ranked a top database . Postgresql is used from data analytics to web development – and everything in between.

Who is the target audience?

NO prior database experience required . Anyone who wants to learn and do practically PostgreSQL database with the PgAdmin 4 Interface from basic to advance.

Course content

 

Introduction

Introduction

Setup and use PostgreSQL databases : Installing pgAdmin and PostgreSQL
Using PostgreSQL
Executing SQL commands
What Is A Database
pgAdmin Overview

Create Table
Create Table Columns
SEQUENCE for auto-incrementing fields
Add Data To A Table

PostgreSQL Select Statements
Nested SELECT statements for complex queries
PostgreSQL Where Clause

GROUP BY for aggregation of data

built-in functions and the HAVING construct

PostgreSQL Wildcards

PostgreSQL AND OR NOT

ORDER BY for sorting data :PostgreSQL Order By

INSERT INTO for adding data to a table: PostgreSQL Insert Into

PostgreSQL Update,  Delete, Limit

PostgreSQL Foreign Keys

What is a JOIN?
PostgreSQL Inner Join
PostgreSQL Join : JOINs and JOIN examples

DROP TABLE for deleting tables and data :PostgreSQL Delete Table

PostgreSQL Import and Export Tables

PostgreSQL Backup and Restore Database

Using the sample data provided

Case study

 

send your  query  to   info@iisastr.com

More  detail  visit   www.iisastr.com

Contact 9312506496  or 9871708300

Students  review   
  • review rating 5  Trainer has excellent knowledge and very supportive. Good pratical examples .

    thumb deepak agrawal
    10/04/2018
  • review rating 5  It was a great experience to get sas training in IISASTR. Debender sir is supportive and he always stresses on understanding the concept along with helping learn the coding.

    thumb Anusha Sharma
    7/23/2018
  • review rating 5  Highly recommended place for SAS trainings. Well equipped and time framed are each classes. The tutor is knowledgeable and delivers the best in each session. One place for SAS and other analytics classes.

    thumb apoorva gupta
    9/09/2018
  • review rating 5  I did a course on SPSS and the teacher not only taught me the software but also improved my understanding of statistical concepts and their application in everyday life. It was a very holistic learning experience! I tried a couple of other institutes as well, but found this one the best. Would recommend it to everyone!

    thumb Siddhi Pal
    8/26/2018
  • review rating 5  Training at IISASTR is wonderful as Trainer Mr. Debendra Dhir helps you understand each and every SAS course aspect briefly. Would strongly recommend this learning center to freshers as well as to experienced professionals!!

    thumb sunil sachdeva
    8/05/2018
  • review rating 5  i joined iisaster recently , Devender sir here is a very good teacher , sessions are very elaborate and practical knowledge of all the procedures is given in every session. I have managed to clear base and advanced SAS certification with a great score . All my doubts were also cleared on time with practical examples and explained very well by Devender sir. I would highly recommend IISASTR for learning SAS/R/PYTHON/BIG-DATA/TABLEAU.

    thumb Rishabh Saxena
    2/23/2018
  • review rating 5  over all exp is awesome..sir is very supportive and he explained the topic easily . main advantages is small batch trainer is highly knowledgeable in sas

    thumb Ajay Sharma
    5/05/2018
  • review rating 5  It was one of the best learning experience of my life till date. I learnt base and advanced SAS from Debendra Sir . The Concepts he taught me helped me to get a great Analytics job offer.I recommend IISASTR for every one who is interested in Analytics training.

    thumb PANKAJ SHEORAN
    11/25/2018
  • review rating 5  This institute will actually deliver to all its promises. Excellent SAS training institute in Delhi for sure. You will enjoy the course.

    thumb Shashank Bhardwaj
    6/20/2018
  • review rating 5  It was really easy to understand the course. The way sir taught was amazing and specially he make us do things on our own so that is a real plus point. I did my SAS Base course which also helped me in my profession.

    thumb Akshat Sangal
    12/26/2017