There is more to being a Junior DBA than knowing SQL.  The DBA works at the intersection of the database, server, operations

Read More
Ten Things a Junior DBA Should Learn

Welcome to Essential SQL Online SQL Tutorial. Use this page to get started learning SQL. SQL Tutorial Overview Use SQL (Structured Query

Read More
SQL Tutorial for SQL Server

For a beginner, learning any kind of programming language can be challenging and can cause you to make mistakes quite often. However,

Read More
5 Typical SQL Syntax Mistakes

In the 70-761 exam covers the SQL Server 2016. Since this exam covers the data query, most of the topics that are

Read More
70-761 Exam: Newly Added Topics

This is the first in a series of articles on how to Get Started with Power BI.  For those of you unaware,

Read More
Get Started with Power BI Desktop

Whether you are a database administrator, programmer, or an SQL specialist, who is looking for employment, your resume will often be the

Read More
6 Suggestions About Writing A Resume for Business Intelligence

“How do I start learn SQL Server?”  That is the most popular question I’m asked.  Many people just don’t know where to

Read More
Learn SQL Server

Check out these 9 best study tips I came across in to help you with 70-761 certification. If you’re planning on studying

Read More
9 Best Study Tips for 70-761 Certification

To help you get the most out your studying time, I put together this 70-761 resource page to help you succeed in

Read More
EssentialSQL 70-761 Resource Page

Studying and preparing for the 70-761 can be intimidating. There are many topics you need to cover, but with so little time.

Read More
How to Create a 70-761 Study Plan Today!

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

Read More
70-761 Certification and Study Guide

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

Read More
What is a Dynamic Pivot Table?

In this puzzle, we are going to learn how to join dirty data using the SQL Server. There are many instances that

Read More
Learn how to Work Joins and Messy Data

Preparing for the 70-461 Exam In order to be successful studying for the 70-461 exam, you’ll need a good strategy and plan. 

Read More
How to Study for the 70-461 Exam

You can do this!  Pass exam 70-461. It may seem intimidating, but you can pass Exam 70-461 Querying SQL Server.  All it

Read More
9 Best Tips for 70-461 Certification

In this lesson you are going to explore how to do pattern matching with the SQL Where clause LIKE operator.  Using this

Read More
Do Partial Matches Using LIKE

SQLite3 Review SQLite3 is a compact free database you can use easily create and use a database.  Though SQLite3 is not a

Read More
What is SQLite3?

This is the first in a series of lessons devoted to teaching you SQL.  We are going to install SQLite and then

Read More
How to Install SQLite and the Sample Database