Search

Ads


Category: SQL softwares

What is a Dynamic Pivot Table?

0 In this puzzle, we’re going to learn how to create a dynamic pivot table using SQL Server.  A dynamic pivot table is a great way to summarize data. ...

Learn to use the Data Dictionary in SQL Server

0 In this puzzle, we’re going to learn how to query the data dictionary using SQL Server.  Knowing how to query the data dictionary is good to know. ...

Learn how to Calculate the Median Value using PERCENTILE_DISC

0 In this puzzle we’re going to learn how to find the person whose birthday, among others, is in the middle.  Knowing how to calculate the median value is...

What is the difference between a subquery and inner join?

0 In this puzzle, we’re going to learn how to rewrite a subquery using inner joins.  Knowing about a subquery versus inner join can help you with...

Joins versus Subqueries SQL Puzzle

0 In this puzzle, we’re going to learn about joins versus subqueries.  In many queries you can substitute joins and subqueries.  Yet, since each has...

Data Modeling Principles in Action

0 In this puzzle, we’re going to learn how to do some basic data modeling.  Many of you have expressed an interest in learning more about data modeling...

SQL Server and Set Operations

0 In this puzzle, we’re going to about SQL set operations.  Set operations allow us to compare rows from two or more tables to arrive at a result.   For...

How to use SQL Union in Set Operations

0   In this puzzle, we’re going to learn how to write a SQL UNION without using Set Operations.  Set operations allow us to compare rows from two or more...

70-761 Certification and Study Guide

Recently Microsoft released “Exam 70-761: Querying Data with Transact-SQL – Microsoft.”  To help you study for this certification, I put together my 70-761 study...

Create a 70-761 Study Plan

Getting ready to study for the 70-761 can be intimidating!  There are some many topics to study and so little time to do so.  It can be overwhelming!  So why not...