Series

Connecting to Databases via Python

There are quite a few different packages available that can be used in Python to connect to databases. This series provides examples about using Python to connect to SQL Server, Teradata, SQLite, Oracle, MySQL, etc. 

Plotting with Pandas DataFrame

Plotting chats with Pandas DataFrame. You can easily plot these charts: Pie Chart, Line Chart, Bar Chart, Area Chart, Scatter Chart, Hexbin Chart, etc.

Spark DataFrame Transformation Tutorials

This series includes tutorials about how to transform Spark DataFrame. For example, operations about add, remove, rename, change data types to columns. It also shows how to create DataFrame object in memory. 

Spark Connect to Databases

This series includes tutorials about how to read data from or write data into databases via JDBC or other drivers. With Java, Spark can interact with many SQL databases such as SQL Server, Oracle, Teradata, MySQL, PostgreSQL, SQLite, etc. 

Parse, Load and Write Files in Spark

This series includes articles about how to read and write files in Spark incl. plain text file, CSV, TSV, XML, Parquet, Avro, Orc, etc. 

Advanced Spark Topics

Advanced Spark related topics and tutorials. These articles are focusing on more advanced Spark topics incl. framework, architecture, etc. 

Querying Teradata using SQL

This series collects commonly used SQL queries to retrieve data from Teradata database. It also shows you how to do some basic filters and transformation using SQL statements. 

Install Teradata Tools & Utilities

This series shows you how to install Teradata tools incl. Teradata virtual machine image, Utilities tools. etc. on Windows.

With these tools, you can practice Teradata SQL and test Teradata new features easily in your machine. 

Install Big Data Tools on Linux

This series provides detailed tutorials about installing big data tools such as Hadoop, Spark, Sqoop, Zeppelin, Hive, Sqoop, etc. on UNIX-alike systems such as Linux or MacOS.  

* Logos used in the picture are registered trademarks of Apache or Linux foundations. 

Big Data Tools on Windows 10

This series provides detailed tutorials about installing big data tools such as Hadoop, Spark, Sqoop, Zeppelin, Hive, Sqoop, etc. on Windows 10 using Java and Windows native libraries.  

* Logos used in the picture are registered trademarks of Apache or Microsoft.