BI Concepts

Connecting to Google Cloud SQL Using ODBC Connector

During the past few days, I've been diving into Google Cloud SQL. But, what is Cloud SQL?. Well, in summary is a fully-managed MySQL database service provided by Google and hosted in their own infrastructure. Therefore, you don't need to worry about things such as storage, security, or availability. In addition, Google provides a very flexible administration console that allow users to create and monitor their database instances.
One thing I was curious about was the possibility to connect an external application to Cloud SQL. In this article, I share two possible ways to connect a client machine to Cloud SQL.

PL/SQL Tutorial - Lesson 2: Variables and Constants

In this lesson we will review variables and how to use then in a PL/SQL block.

PL/SQL Tutorial - Lesson 1: What is PL/SQL?

Introduction

This tutorial is a very basic introduction to PL/SQL, the purpose is to provide you all the knowledge that you could need to start developing scripts in PL/SQL. If you want to  go more in depth and get more information about how PL/SQL works, sentence structure of functions you can go to the resources section.

Qlik Summer School Webinar Series - Visual Analitics Design Best Practices

The Visual Analytics Design Best Practices webinar was presented by Patrick Lundblad, Senior Product Manager, and Adam Booth, Product Designer. This session was really interesting not only because it was full of tips about data visualization design, but also because the very interesting facts about data visualization history.