Which languages should you learn for data science?
Data science is an exciting field to work in, combining advanced statistical and quantitative skills with real-world programming ability. There are many potential programming languages that the aspiring data scientist might consider specializing in. While there is no correct answer, there are several things to take into consideration. Your success
Spreadsheets getting you down? Converting row data to JSON trees is a breeze.
Like many of you, I often have to take the result of SQL queries [http://www.sqlcourse.com/intro.html] and convert the rowsets to JSON data objects [http://www.json.org/]. Sometimes I have to do the same with CSV files from spreadsheets. The transformation process can be a hassle, though anyone can do it. Yet, it
SQLAlchemy makes ETL magically easy
One of the key aspects of any data science workflow is the sourcing, cleaning, and storing of raw data in a form that can be used upstream. This process is commonly referred to as “Extract-Transform-Load,” or ETL for short. It is important to design efficient, robust, and reliable ETL processes,
Exploring a powerful SQL pattern: ARRAY_AGG, STRUCT and UNNEST
by Lak Lakshmanan Exploring a powerful SQL pattern: ARRAY_AGG, STRUCT and UNNEST It can be extremely cost-effective (both in terms of storage and in terms of query time) to use nested fields rather than flatten out all your data. Nested, repeated fields are very powerful, but the SQL required to
How to write modular, readable SQL using named result sets and functions
by Lak Lakshmanan How to write modular, readable SQL using named result sets and functions My professional journey in computers has involved C++, then Java, and now Python. SQL remains, at best, a foreign language. For my own sanity, therefore, I’ve brought some of my programming best practices to SQL.
How to get started with PostgreSQL
by Akul Tomar How to get started with PostgreSQL PostgreSQL is an open source Relational Database Management System (RDBMS). In this article, I’ll provide an introduction to getting started with PostgreSQL. Here is what we’ll cover: * Installation [https://medium.com/p/9d3bc1dd1b11#d220] * Administration [https://medium.com/p/9d3bc1dd1b11#d003] * Basic Database Operations Installation
How to work optimally with relational databases
Relational databases handle data smoothly, whether working with small volumes or processing millions of rows. We will be looking at how we can use relational databases according to our needs, and get the most out of them. MySQL has been a popular choice for small to large enterprise companies because
How to deploy a Blazor application on Azure
Introduction In this article, we will learn how to deploy an ASP.NET Core hosted Blazor application on Azure. We will use Visual Studio 2017 to publish the app. We will create a SQL database server on Azure to handle DB operations. Prerequisites * Install the .NET Core 2.1 or