Learn ETL & SQL With Nitin Srivastava.

Welcome to my website. I am Nitin Srivastava. A Data & Analytics consultant by profession with 15+ years of professional experience. I have worked with multiple enterprises using various technologies supporting Data Analytics requirements.

As a Data & Analytics consultant, primary skill has always been SQL. Also I have worked a lot in the past decade to build and maintain data warehouse for multiple enterprises.

I am also very much inclined on creating systems which can repeatedly deliver projects with minimum human intervention and saving thousands of man-hours in doing same tasks again and again. 

About


Contact

Create data model from SQL | Step-by-Step guide for reverse engineering

Build Data Warehouse from Scratch | Dummy Project with codebase

Free Teradata Utilties

Check out these topics to get you started

Teradata

Data Engineering

ETL

Amazon Redshift

Start your learning journey by reading posts

Teradata
Redshift
SQL
Data Warehouse
Teradata
Teradata is one of the most popular Data Warehouse solution available in the market. Many of the top enterprises use Teradata for their analytical and decision support system.
If you are working in Teradata or looking to start learning Teradata I will recommend following learning path to you.

1. Teradata Basics
   • Overview of Teradata tutorial & topics
   • Teradata Architecture
   • Data Distribution in Teradata
   • Different types of Storage Space in Teradata
     • No more room in database in Teradata
   • HASHROW, HASHBUCKET, HASHAMP in Teradata
   • Difference between primary index and secondary index in teradata
   • Primary Index vs Primary Key
   • Locks in Teradata
   • Compression in Teradata – Introduction
     • Single Value, Multi-Value, Algorithm & Block level Compression in Teradata
   • Teradata dbqlogtbl for resource consumption
     • Identify slow query in Teradata
     • 5 Reasons for Slow Query performance in Teradata
   • 6 ways to load data from file in Teradata
2. Teradata Table Design
   • Teradata Create Table
   • Teradata secondary index
   • Teradata Create View
   • Create volatile table Teradata
3. Teradata SQL Assistant
   • Teradata SQL Assistant
   • Teradata SQL Assistant import data
4. Teradata Utilties
   • BTEQ Script
     • Parameters in Query
   • Teradata TPT
     • Load multiple files in TPT
     • Teradata TPT Export
   • Teradata TDLOAD
   • Teradata Import Script Generator – Free Utility
5. Teradata SQL
   • teradata concatenate
   • teradata cast
   • handle NULL like PRO
     • coalesce teradata
     • teradata nullif
   • teradata union vs union all
   • numeric overflow occurred during computation
   • teradata case when
   • regular expression in teradata
   • teradata remove special characters
   • teradata split string into rows
   • converting multiple rows into single row in teradata
   • teradata combine rows
   • teradata recursive query
   • table/view/trigger name is ambiguous
   • teradata export data to excel
   • order by is not allowed in subqueries
   • qualify row_number() over (partition by
   • teradata rank vs row_number
   • teradata casespecific
   • set session charset utf-8 in teradata
   • scd types in teradata
   • scd type 1 implementation in teradata
   • scd type 2 implementation in teradata
   • teradata sql commands cheat sheet
   • teradata interview questions
   • duplicate unique prime key error
     • teradata delete duplicate rows
6. Teradata Date & Timestamp
   • teradata date functions
     • teradata date format
     • invalid date supplied teradata
   • teradata interval
     • interval field overflow teradata
   • teradata timestamp
     • load timestamp am-pm value
   • teradata convert number to time
   • teradata sysdate
7. Teradata Stored Procedure
   • sql security invoker
   • teradata stored procedure
   • cursor in teradata
   • teradata stored procedure access
   • teradata stored procedure activity count
   • teradata stored procedure parameters
8. Teradata Miscellaneous
   • SELECT with GRANT option Teradata
   • Metadata of view in Teradata
   • Teradata to Hadoop migration
   • Spark Teradata connection
   • Teradata Zeppelin connection

Redshift
Amazon Redshift is the modern cloud data warehouse service offered by AWS (Amazon Web Services). It is considered as one of the fastest data analytical engine availabe in the market today.
If you are working in Amazon Redshift or looking to start learning Amazon Redshift I will recommend following learning path to you.


Amazon Redshift Course for Absolute Beginners : Join the course

1. Redshift Table Design
   • redshift create table example
   • 4 create table redshift example
2. Redshift Table Load
   • redshift copy from s3
   • redshift copy parquet
3. Redshift SQL
   • redshift select
   • redshift alias
   • redshift order by
   • redshift distinct
4. Redshift Stored Procedure
   • redshift stored procedure with parameters example
5. AWS Certificates
   • aws solution architect associate certification
   • aws data analytics certification

SQL
SQL (Structured Query Language) is used to Query data present in database tables. It follows ANSI standard and is considered as the most important skill for any Data related job in the market.
If you are SQL beginner I will recommend reading below posts

1. SQL Examples
   • derived table vs subquery
   • target row updated by multiple source rows
   • add leading zeros in sql
   • rows between 1 preceding and 1 preceding
   • identify and delete duplicate rows
   • sql previous row
   • difference between table and view

Data Warehouse
Data warehouse is used to store and analyse historical data generated by multiple sources. The data warehouse enabled business to take informed decisions to increase business.
If you are a beginner I will recommend reading below posts

1. Data Warehouse
   • data warehouse migration project
   • star vs snowflake schema
   • create data model
   • slowly changing dimension
   • build data warehouse from scratch