dbmstutorials.com
Menu Space
PySpark:
Spark Overview and Setup
PySpark Dataframe Options
PySpark Dataframe Write Modes
PySpark File to Dataframe-Part 1
PySpark File to Dataframe-Part 2
PySpark DB to Dataframe
PySpark Dataframe to File-Part 1
PySpark Dataframe to File-Part 2
PySpark Dataframe to DB
PySpark Dataframe Preview-Part 1
PySpark Dataframe Preview-Part 2
PySpark Dataframe Basic Operations
PySpark Dataframe Schema
PySpark Dataframe Add Columns
PySpark Dataframe Modify Columns
PySpark Dataframe Rename Columns
PySpark Dataframe Drop Columns
PySpark Dataframe Partitions-Part 1
PySpark Dataframe Partitions-Part 2
PySpark Dataframe Caching
PySpark Dataframe Joins
PySpark Dataframe Filters
PySpark Dataframe Sort
PySpark Dataframe Sort Partitions
PySpark Dataframe Duplicates
PySpark Dataframe Seq Number
PySpark Dataframe Set Operation
PySpark DF String to Timestamp
PySpark Dataframe Format Timestamp
PySpark Dataframe Explode
PySpark Dataframe Multiple Explode
PySpark DF Date Functions-Part 1
PySpark DF Date Functions-Part 2
PySpark DF Date Functions-Part 3
PySpark Dataframe Handling Nulls
PySpark DF Aggregate Functions
PySpark Dataframe Pivot
PySpark DF Window Functions-Part 1
PySpark DF Window Functions-Part 2
PySpark DF Window Functions-Part 3
PySpark Dataframe Sampling
PySpark Dataframe Split
PySpark DF Array Functions-Part 1
PySpark DF Array Functions-Part 2
PySpark DF Array Functions-Part 3
PySpark DF Array Functions-Part 4
PySpark DF Array Functions-Part 5
PySpark Send Dataframe as Mail
Teradata:
Teradata Setup on Mac
Teradata Architecture
Teradata Primary Index(PI)
Teradata Spaces
Teradata Table Types
Teradata NoPI Tables
Teradata Table Properties
Teradata Datatypes
Teradata Partitioned PI
Teradata Secondary Index
Teradata Join Strategies
Teradata Join Index
Teradata Hash Index
Teradata Locks
Teradata Compression(MVC)
Teradata String Functions
Teradata String Functions Part 2
Teradata Regexp Functions
Teradata Numeric Functions
Teradata Date Functions
Teradata Calendar Functions
Teradata Analytical Functions
Teradata Analytical Functions Part 2
Teradata Misc. Functions
Teradata Procedures
Teradata Macros
Teradata Period Datatype
Teradata Collect Statistics
Teradata Subqueries
Teradata TOP n Operator
Teradata SAMPLE Clause
Teradata Secure Transactions
Teradata Terminal Commands
Teradata System Table Queries
Teradata System Table Queries Part2
Teradata User Creation
Hadoop Ecosystem: Hive
Hadoop Setup on Mac
Hive Setup on Mac
Hive Scripts & Variables
Hive Tables
Hive Data Load & Export
Hive Incremental Data Load
Hive SERDE
Hive Table Related Commands
Hive Partitioning & Bucketing
Hive Indexing & Materialized View
Hive Errors
Python:
Python Basics
Python Variables & User Input
Python Loops & Control Stmts
Python User Defined Functions
Python List
Python List Functions
Python Slicing
Python Exception Handling
Python File Handling Part 1
Python File Handling Part 2
Python File Handling Part 3
Python Set
Python Set Functions
Python Curl Command
Python Virtual Environment
Kafka:
Kafka Introduction
Kafka Starting Servers
Kafka Topic Operations
Kafka Topic Producer
Kafka Topic Consumer
Kafka Secure Topic Consumer
Kafka Consumer Groups
Kafka Purge Operation
Spark:
Spark RDD Creation
Spark Aggregate By Key
Hadoop Ecosystem: Sqoop
Sqoop Introduction
Sqoop Import Part 1
Sqoop Import Part 2
Sqoop Import Part 3
Sqoop Hive Import
Sqoop Export Part 1
Sqoop Export Part 2
Sqoop Errors
SingleStore / MemSQL:
SingleStore From Terminal
SingleStore Tables
SingleStore Alter Tables
SingleStore Update Using Other Table
SingleStore Delete Using Other Table
SQL:
SQL WHERE vs HAVING
SubQuery in SQL
Vertica:
Vertica Storage Model
Vertica Tables
Vertica Projections
Vertica Metadata Info Part One
Vertica Metadata Info Part Two
Vertica File To Table
Vertica To Vertica Load
Teradata Random:
Transpose Columns to Rows
Transpose Rows to Columns
Recursive Queries
Merge Rows on Date / Timestamp
Group Consecutive Dates
Breaking Timestamp Range
Convert String to Table
Convert String to Columns
Multi Column Split to Rows
Group By Vs Distinct
Hash Index Vs Join Index
Left Outer Vs Right Outer Join
Epoch Time To Timestamp
Subtract Timestamps
Date/Timestamp Formatting
String to Date/Timestamp
Number Formatting
Removing Duplicates
Convert String For In-Clause
First & Last Days
SET Operators
Dynamic SQL Statements
Teradata Upsert / Merge
Update Using Other Table
Delete Using Other Table
Count(*) Vs Count(1)
Alter tables
AlphaNumeric Data Operation
Ansi Mode vs Teradata Mode
Cumulative Distinct Count
Hour to Hour Range
Timestamp(6) To Timestamp(0)
Teradata 15 New Features
Teradata 16 New Features
Querying Byte Column
Implicit Datatype Conversion
Find Prime Numbers
Duplicates in SET Table
Surrogate key
Identity Column
Referential Integrity
Run Commands as Daemon
DB Utilities:
Oracle SQLLoader
Oracle Data Exporter
Teradata TPT Introduction
Teradata TPT Execute & Debug
Teradata TPT Export
Teradata TPT Export-Template
Teradata TPT Load
Teradata TPT Load-Template
Teradata TPT Stream
Teradata TPT Update Operator
Teradata TPT Inserter Operator
Teradata TPT Selector Operator
Teradata TPT DDL Operator
Teradata TPT OS Operator
Teradata to Teradata Load
