Create

10 – TSQL Create Table Statement

Hi! Today I learned about the Create Table statement, it allows you to create and define tables, as what I studied on the last episode, it is a DDL statement (Data Definition Language). CREATE TABLE The syntax for this statement in SQL Server (TSQL) id: CREATE TABLE table_name (...
Concepts

9 – Learning DDL and DML concepts

Hello there! Learning about DDL and DML concepts is a fundamental foundation for becoming a Data Wrangling and Data Warehousing extraordinaire.  SQL statements are divided into two major categories: Data Definition Language (DDL) and Data Manipulation Language (DML).  In Short:...

8.2 – TSQL Having and Union command

Today I kept studying about TSQL (Having and Union command). I also finished the TSQL tutorial from Microsoft that Luis sent me. HAVING clause The first example shows a HAVING clause with an aggregate function. It groups the SalesOrderDetail rows by product ID and eliminates...
TSQL

8.1 – TSQL command (Group By)

In the last episode you saw that I studied TSQL for the new project, today I had some issues with the machine, connection, permissions and SQL Server. Now everything is well set up and I could keep studying some TSQL! The command that I studied today was Group By, it is used in...
TSQL

7 – TSQL for a new project

A new project is coming around and I will help with some Business Intelligence tasks. Today I started to study TSQL for this new project, the idea is to get the basics and some concepts about it and during the work I’ll improve this knowledge. The next step is to learn the...
TSQL

6 – Learning TSQL basics concepts

Next step is a big progress, it is about learning TSQL basics, basically if you learn this concept and the most common commands that we are going to see here, you can do a lot of work in SQL database and you can improve this knowledge so much faster. TSQL (short for Transact SQL)...

Free Microsoft 4 Oracle

When talking to our customers who have Oracle databases, tell them that Microsoft offers the deal of a lifetime…. free Microsoft licensing and rapid migration tools to allow customers to break free from expensive Oracle lock-in. Considering it is about $28,000 per 2 core...

BICG embrace Data Vault

Last year I had the opportunity to meet Dan Linstedt, the godfather of Data Vault. Along with Ralph Kimball and Bill Inmon, these 3 innovators represent the father, son and holy spirit of organizing data in the Enterprise. BICG have their very own Certified Data Vault 2.0...

5 – Learning more DAX Commands

In my journey of learning Data Warehouse, I kept learning about DAX, I tried to find some useful DAX commands that can help you day by day. The commands that worked out are: SUMX, SUM IF FILTER RANKX ALL   I used a Portuguese reference to learn about it, so I will explain...

4 – Learning about DAX basics

Today I started learning about DAX basics and how it works on Power Pivot. Here is a basic and simple concept about it. Data Analysis Expressions (DAX) is a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one...
12
Send