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 ( column1 datatype [NULL […]
Read MorePost Tagged with: "SQL Server"
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: DDL describes a bunch of commands that CREATE Data Structures, like […]
Read More8.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 products whose average order quantities are less […]
Read More8.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 […]
Read MoreHow to connect to Azure DW via SQL Server Management Studio (SSMS)
Azure DW has been become more and more popular, and there is no doubt that Microsoft is putting all its efforts on the cloud. For those who wants to begin with this trend in Business Intelligence , simple questions can pop up our minds. This article will explain how to setup a simple data base in […]
Read More7 – 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 […]
Read More6 – 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 […]
Read MoreIntroduction to BIDS Helper Add-in
Watch the video demonstration of BIDSHelper add-in for SQL Server Data tool. BIDS helper is Business Intelligence Development Studio/SSDT add-in to enhance functionality of the BI projects. BIDS helper has lots of features to enhance your Tabular/Multidimensional Cube, Integration service package and Reporting service reports. So if you want to […]
Read MoreJourney to Microsoft Certified Master: SQL Server 2008
By: Simon Liew MCM Journey to Microsoft Certified Master: SQL Server 2008 I attempted Microsoft Certified Master (MCM) exam in second half of 2012 and thankfully passed both Knowledge Exam (88-970) and the Lab Exam (88-971) in my first attempt. I’m categorised in the “new” MCM program because I took […]
Read More