Click here to Skip to main content
14,271,759 members

Articles by essentialSQL (Articles: 5, Technical Blogs: 108)

Articles: 5, Technical Blogs: 108

RSS Feed

Average article rating: 3.82

Site & Server Management
General
Posted: 14 Aug 2019   Updated: 14 Aug 2019   Views: 1,260   Rating: 3.00/5    Votes: 5   Popularity: 2.10
Licence: The MIT License      Bookmarked: 2   Downloaded: 0
SQL server’s date functions provide you a set of function that you can use to manipulate dates.  The function are used for a wide variety of operation such as adding weeks to a date, calculating the difference between two dates, or to decompose a date into its fundamental parts.
Content Management Server
General
Posted: 25 Apr 2019   Updated: 25 Apr 2019   Views: 2,570   Rating: 4.22/5    Votes: 6   Popularity: 3.28
Licence: The MIT License      Bookmarked: 2   Downloaded: 0
SQL DISTINCT Clause For SQL Server
Database
General
Posted: 3 Mar 2019   Updated: 3 Mar 2019   Views: 2,820   Rating: 2.87/5    Votes: 5   Popularity: 2.00
Licence: The MIT License      Bookmarked: 2   Downloaded: 0
In this puzzle, we’re going to learn how to work with the AdventureWorks Bill of Materials table.  Companies use a BOM (Bill of Materials) to itemize the products that are used or contained in another product. Solving puzzles is a great way to learn SQL.
SQL
Posted: 13 May 2015   Updated: 13 May 2015   Views: 11,300   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The MIT License      Bookmarked: 4   Downloaded: 0
This is a case study on how to use Joins, Subqueries, and Unions to combine data in SQL.
SQL Server
Posted: 21 Dec 2014   Updated: 21 Dec 2014   Views: 9,660   Rating: 4.00/5    Votes: 2   Popularity: 1.20
Licence: The MIT License      Bookmarked: 9   Downloaded: 0
Learn to use Union, Intersect, and Except Clauses The UNION, INTERSECT, and EXCEPT clauses are used to combine or exclude like rows from two or more tables.  They are useful when you need to combine the results from separate queries into one single result.  They differ from a join in that entire row

Average blogs rating: 4.57

Desktop Gadgets
General
Posted: 13 Mar 2019   Updated: 13 Mar 2019   Views: 2,101   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The MIT License      Bookmarked: 4   Downloaded: 0
In this guide, I’ll show you how to get started using Power BI.  We’ll then get some sample data and use it to build a simple project.
Grid & Data Controls
General
Posted: 13 Mar 2019   Updated: 13 Mar 2019   Views: 1,300   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The MIT License      Bookmarked: 3   Downloaded: 0
A reader recently asked about a error converting data type error they received.  Since this is a common issue, especially when numeric data is stored withing VARCHAR datatypes, I thought you would appreciate the answer I shared with them. I’m using Windows 10 and SQL SMS 2014.
Site & Server Management
General
Posted: 11 Jan 2016   Updated: 11 Jan 2016   Views: 8,370   Rating: 4.89/5    Votes: 6   Popularity: 3.79
Licence: The MIT License      Bookmarked: 3   Downloaded: 0
Built-In Functions (SQL Server)
Amazon Web Services
General
Posted: 14 Aug 2019   Updated: 14 Aug 2019   Views: 2,690   Rating: 3.10/5    Votes: 10   Popularity: 3.10
Licence: The MIT License      Bookmarked: 0   Downloaded: 0
SQLite3 Review SQLite3 is a compact free database you can use easily create and use a database.
Content Management Server
General
Posted: 10 Mar 2015   Updated: 10 Mar 2015   Views: 5,220   Rating: 4.67/5    Votes: 2   Popularity: 1.40
Licence: The MIT License      Bookmarked: 5   Downloaded: 0
This is the fourth in a series of articles about subqueries.  In this post, we discuss subqueries in the FROM clause.
Posted: 21 Mar 2015   Updated: 21 Mar 2015   Views: 4,591   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The MIT License      Bookmarked: 2   Downloaded: 0
Get ready to learn SQL Server 23: Using Subqueries in the HAVING clause
Posted: 16 Jun 2015   Updated: 16 Jun 2015   Views: 26,540   Rating: 4.31/5    Votes: 5   Popularity: 3.01
Licence: The MIT License      Bookmarked: 2   Downloaded: 0
Difference between primary and foreign keys, and why both are important to maintaining a relational database structure
Posted: 16 Jun 2015   Updated: 16 Jun 2015   Views: 4,970   Rating: 5.00/5    Votes: 2   Popularity: 1.40
Licence: The MIT License      Bookmarked: 3   Downloaded: 0
Difference between Top and Offset & Fetch
Posted: 16 Jun 2015   Updated: 16 Jun 2015   Views: 13,550   Rating: 4.45/5    Votes: 6   Popularity: 3.47
Licence: The MIT License      Bookmarked: 3   Downloaded: 0
Using OFFSET and FETCH with the ORDER BY clause
Posted: 1 Jan 2016   Updated: 1 Jan 2016   Views: 42,290   Rating: 4.56/5    Votes: 5   Popularity: 3.15
Licence: The MIT License      Bookmarked: 3   Downloaded: 0
Difference between a join and a union
Posted: 3 Jan 2016   Updated: 3 Jan 2016   Views: 21,232   Rating: 4.67/5    Votes: 5   Popularity: 3.22
Licence: The MIT License      Bookmarked: 4   Downloaded: 0
What is the Difference between a Join and Subquery?
Posted: 20 Jul 2016   Updated: 20 Jul 2016   Views: 7,630   Rating: 5.00/5    Votes: 6   Popularity: 3.89
Licence: The MIT License      Bookmarked: 2   Downloaded: 0
Recursive CTE’s In this article we explore recursive CTE’s (Common Table Expressions).  Recursive CTEs are special in the sense they are allowed to reference themselves!  Because of this special ability, you can use recursive CTEs to solve problems other queries cannot.  Recursive CTEs are really go
Posted: 19 Mar 2017   Updated: 19 Mar 2017   Views: 6,160   Rating: 3.76/5    Votes: 5   Popularity: 2.54
Licence: The MIT License      Bookmarked: 2   Downloaded: 0
In this puzzle, we're going to learn how to create a bar chart using SQL Server.
Posted: 19 Mar 2017   Updated: 19 Mar 2017   Views: 5,880   Rating: 3.91/5    Votes: 6   Popularity: 2.96
Licence: The MIT License      Bookmarked: 4   Downloaded: 0
How to find a gap in a sequence using SQL Server
Posted: 30 Dec 2017   Updated: 30 Dec 2017   Views: 6,230   Rating: 5.00/5    Votes: 8   Popularity: 4.52
Licence: The MIT License      Bookmarked: 2   Downloaded: 0
Difference between a primary and unique key and why both are important to maintaining a relational database structure
Posted: 1 Mar 2018   Updated: 1 Mar 2018   Views: 7,350   Rating: 4.00/5    Votes: 2   Popularity: 1.20
Licence: The MIT License      Bookmarked: 3   Downloaded: 0
Use IF…ELSE statements to program a Stored Procedure
Posted: 1 Mar 2018   Updated: 1 Mar 2018   Views: 5,621   Rating: 2.45/5    Votes: 3   Popularity: 1.05
Licence: The MIT License      Bookmarked: 1   Downloaded: 0
After reading this article you will understand the basics of using the WHILE statement to write a loop within a stored procedure. All the examples for this lesson are based on Microsoft SQL Server Management Studio and the sample databases AdventureWorks and WideWorldImporters.
Posted: 13 Mar 2019   Updated: 13 Mar 2019   Views: 1,730   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The MIT License      Bookmarked: 1   Downloaded: 0
In this video we’ll walk you though the common data types used in SQL Server; you’ll see examples of each type’s values, and how to define them.
Posted: 26 Apr 2019   Updated: 26 Apr 2019   Views: 1,680   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The MIT License      Bookmarked: 1   Downloaded: 0
SQL Server Hierarchical Query using the hierarchyid type
Posted: 14 Aug 2019   Updated: 14 Aug 2019   Views: 1,250   Rating: 3.00/5    Votes: 2   Popularity: 0.90
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
What is a Data Dictionary? In SQL Server the data dictionary is a set of database tables used to store information about a database’s definition.  The dictionary contains information about database objects such as tables, indexes, columns, datatypes, and views.
Database
COM
Posted: 14 Aug 2019   Updated: 14 Aug 2019   Views: 1,050   Rating: 3.67/5    Votes: 3   Popularity: 1.75
Licence: The MIT License      Bookmarked: 1   Downloaded: 0
A database index allows a query to efficiently retrieve data from a database.  Indexes are related to specific tables and consist of one or more keys.  A table can have more than one index built from it.  The keys are a fancy term for the values we want to look up in the index.  The […].
Posted: 14 Aug 2019   Updated: 14 Aug 2019   Views: 1,490   Rating: 4.33/5    Votes: 3   Popularity: 2.07
Licence: The MIT License      Bookmarked: 1   Downloaded: 0
A relational database is made up of several components, of which the table is most significant.  The database table is where all the data in a database is stored, and without tables, there would not be much use for relational databases.
General
Posted: 23 Oct 2014   Updated: 23 Oct 2014   Views: 6,170   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The MIT License      Bookmarked: 9   Downloaded: 0
Simplified Data Modeling in SQL
Posted: 21 Oct 2014   Updated: 3 Nov 2014   Views: 10,520   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: The MIT License      Bookmarked: 12   Downloaded: 0
Database Third Normal Form explained in simple English
Posted: 31 Dec 2015   Updated: 31 Dec 2015   Views: 6,880   Rating: 4.57/5    Votes: 9   Popularity: 4.33
Licence: The MIT License      Bookmarked: 4   Downloaded: 0
Difference between inner and outer joins
Posted: 5 Jan 2016   Updated: 5 Jan 2016   Views: 7,440   Rating: 4.00/5    Votes: 1   Popularity: 0.00
Licence: The MIT License      Bookmarked: 0   Downloaded: 0
Commonly used SQL Server data types
Posted: 9 Jul 2016   Updated: 9 Jul 2016   Views: 5,331   Rating: 4.80/5    Votes: 6   Popularity: 3.70
Licence: The MIT License      Bookmarked: 6   Downloaded: 0
Introduction to Common Table Expressions
Posted: 14 Jul 2016   Updated: 14 Jul 2016   Views: 5,610   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: The MIT License      Bookmarked: 5   Downloaded: 0
In this article, we explore non recursive CTEs (Common Table Expressions). This is a broad class, and basically covers every form of CTEs except those that call themselves. This other class is called the recursive CTEs; they are covered in the next article.
Posted: 23 Nov 2016   Updated: 23 Nov 2016   Views: 3,650   Rating: 4.00/5    Votes: 7   Popularity: 3.36
Licence: The MIT License      Bookmarked: 3   Downloaded: 0
Here is an introduction to the Delete statement
Posted: 23 Nov 2016   Updated: 23 Nov 2016   Views: 5,490   Rating: 4.17/5    Votes: 4   Popularity: 2.51
Licence: The MIT License      Bookmarked: 2   Downloaded: 0
An introduction to the UPDATE statement
Posted: 1 Mar 2018   Updated: 1 Mar 2018   Views: 7,070   Rating: 4.47/5    Votes: 5   Popularity: 3.06
Licence: The MIT License      Bookmarked: 11   Downloaded: 0
How to build dynamic SQL in a stored procedure
Posted: 13 Mar 2019   Updated: 13 Mar 2019   Views: 1,640   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The MIT License      Bookmarked: 3   Downloaded: 0
In this SQL minute we’ll look at how you can use hierarchyid to query hierarchy data.  This is a two-part article.  In this article we look at how to do one query to get portion of the hierarchy.
Posted: 14 Aug 2019   Updated: 14 Aug 2019   Views: 1,770   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: The MIT License      Bookmarked: 2   Downloaded: 0
In this blog post, you will learn about stored procedures
SQL
Posted: 21 Oct 2014   Updated: 21 Oct 2014   Views: 7,750   Rating: 4.88/5    Votes: 6   Popularity: 3.79
Licence: The MIT License      Bookmarked: 9   Downloaded: 0
Database First Normal Form explained in simple English
Posted: 21 Oct 2014   Updated: 21 Oct 2014   Views: 8,400   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The MIT License      Bookmarked: 7   Downloaded: 0
Database Second Normal Form explained in simple English
Posted: 22 Oct 2014   Updated: 22 Oct 2014   Views: 5,480   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The MIT License      Bookmarked: 9   Downloaded: 0
How to combine table rows using UNION in SQL Server
Posted: 22 Oct 2014   Updated: 22 Oct 2014   Views: 14,850   Rating: 5.00/5    Votes: 9   Popularity: 4.77
Licence: The MIT License      Bookmarked: 12   Downloaded: 0
Database normalization in SQL explained in simple English
Posted: 24 Oct 2014   Updated: 24 Oct 2014   Views: 4,571   Rating: 4.75/5    Votes: 3   Popularity: 2.27
Licence: The MIT License      Bookmarked: 8   Downloaded: 0
In today’s lesson, you’re going to learn how to filter the results returned from your queries using the WHERE clause.
Posted: 24 Oct 2014   Updated: 24 Oct 2014   Views: 4,980   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The MIT License      Bookmarked: 8   Downloaded: 0
How to sort your query results in SQL Server
Posted: 24 Oct 2014   Updated: 24 Oct 2014   Views: 5,040   Rating: 4.75/5    Votes: 3   Popularity: 2.27
Licence: The MIT License      Bookmarked: 7   Downloaded: 0
Learn more about filtering results returned from your queries using the WHERE clause
Posted: 25 Oct 2014   Updated: 25 Oct 2014   Views: 7,730   Rating: 4.71/5    Votes: 4   Popularity: 2.84
Licence: The MIT License      Bookmarked: 12   Downloaded: 0
Simple SELECT queries in SQL Server
Posted: 29 Oct 2014   Updated: 29 Oct 2014   Views: 4,680   Rating: 4.50/5    Votes: 2   Popularity: 1.35
Licence: The MIT License      Bookmarked: 7   Downloaded: 0
In this lesson, you are going to explore how to do pattern matching with the SQL Where clause LIKE operator.
Posted: 31 Oct 2014   Updated: 31 Oct 2014   Views: 7,830   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The MIT License      Bookmarked: 8   Downloaded: 0
How to use the Intersect Operator in SQL Server
Posted: 17 Jul 2015   Updated: 17 Jul 2015   Views: 23,430   Rating: 4.75/5    Votes: 11   Popularity: 4.98
Licence: The MIT License      Bookmarked: 9   Downloaded: 0
How to use conditional logic in SQL with CASE expression
Posted: 19 Jan 2016   Updated: 19 Jan 2016   Views: 5,900   Rating: 4.45/5    Votes: 5   Popularity: 3.03
Licence: The MIT License      Bookmarked: 6   Downloaded: 0
Three simple steps to writing SQL queries
Posted: 19 Jan 2016   Updated: 19 Jan 2016   Views: 3,660   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The MIT License      Bookmarked: 4   Downloaded: 0
Write SQL – Formulate your Question – Step 2
Posted: 26 Jan 2016   Updated: 26 Jan 2016   Views: 4,920   Rating: 4.33/5    Votes: 3   Popularity: 1.91
Licence: The MIT License      Bookmarked: 5   Downloaded: 0
Write SQL - write the query
Posted: 23 Feb 2017   Updated: 23 Feb 2017   Views: 8,820   Rating: 4.76/5    Votes: 12   Popularity: 5.13
Licence: The MIT License      Bookmarked: 12   Downloaded: 0
How to calculate moving averages by working through a hypothetical stock market example
Posted: 23 Feb 2017   Updated: 23 Feb 2017   Views: 5,100   Rating: 4.79/5    Votes: 8   Popularity: 4.31
Licence: The MIT License      Bookmarked: 2   Downloaded: 0
How to identify the top and bottom 25 percent to rank student scores
Posted: 25 Mar 2017   Updated: 25 Mar 2017   Views: 4,650   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The MIT License      Bookmarked: 3   Downloaded: 0
How to calculate moving averages
Posted: 30 Dec 2017   Updated: 30 Dec 2017   Views: 4,020   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The MIT License      Bookmarked: 2   Downloaded: 0
In this puzzle, we’re going to learn how to rewrite a subquery using inner joins.
Posted: 30 Dec 2017   Updated: 30 Dec 2017   Views: 3,450   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The MIT License      Bookmarked: 0   Downloaded: 0
Joins versus subqueries in SQL
Posted: 30 Dec 2017   Updated: 30 Dec 2017   Views: 3,000   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The MIT License      Bookmarked: 3   Downloaded: 0
How to write a SQL UNION without using Set operations
Posted: 30 Dec 2017   Updated: 30 Dec 2017   Views: 4,430   Rating: 4.50/5    Votes: 5   Popularity: 3.15
Licence: The MIT License      Bookmarked: 6   Downloaded: 0
There are several ways to calculate a running total in SQL. In this article, we will cover two methods: Joins, and Window Functions.
Posted: 30 Dec 2017   Updated: 30 Dec 2017   Views: 3,330   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The MIT License      Bookmarked: 0   Downloaded: 0
How to use the TOP clause in SQL
Posted: 30 Dec 2017   Updated: 30 Dec 2017   Views: 3,630   Rating: 4.09/5    Votes: 6   Popularity: 3.11
Licence: The MIT License      Bookmarked: 0   Downloaded: 0
How to select top rows within a query
Posted: 13 Mar 2019   Updated: 13 Mar 2019   Views: 2,491   Rating: 3.67/5    Votes: 2   Popularity: 0.90
Licence: The MIT License      Bookmarked: 5   Downloaded: 0
In this episode of SQL Minute I want to share with you how to create a pivot or cross tab chart.
Posted: 13 Mar 2019   Updated: 13 Mar 2019   Views: 3,250   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The MIT License      Bookmarked: 2   Downloaded: 0
A common question I get ask is whether I can have a CASE Statement in the WHERE Clause.
SQL Server
Posted: 22 Oct 2014   Updated: 22 Oct 2014   Views: 6,860   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The MIT License      Bookmarked: 9   Downloaded: 0
Introduction to Outer Joins in SQL Server
Posted: 22 Oct 2014   Updated: 22 Oct 2014   Views: 5,330   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The MIT License      Bookmarked: 8   Downloaded: 0
Introduction to Inner Joins in SQL Server
Posted: 22 Oct 2014   Updated: 22 Oct 2014   Views: 6,750   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: The MIT License      Bookmarked: 11   Downloaded: 0
Introduction to database joins in SQL
Posted: 23 Oct 2014   Updated: 23 Oct 2014   Views: 5,920   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The MIT License      Bookmarked: 5   Downloaded: 0
Query Results Using Pattern Matching in SQL
Posted: 23 Oct 2014   Updated: 23 Oct 2014   Views: 6,680   Rating: 4.60/5    Votes: 3   Popularity: 2.19
Licence: The MIT License      Bookmarked: 5   Downloaded: 0
What is a Null Value? In databases a common issue is what value or placeholder do you use to represent a missing values.   In SQL, this is solved with null.  It is used to signify missing or unknown values.  The keyword NULL is used to indicate these values.
Posted: 23 Oct 2014   Updated: 23 Oct 2014   Views: 5,060   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The MIT License      Bookmarked: 7   Downloaded: 0
How to Group and Summarize your Results in SQL
Posted: 29 Oct 2014   Updated: 29 Oct 2014   Views: 6,130   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The MIT License      Bookmarked: 11   Downloaded: 0
Grouping results returned from your queries using the GROUP BY clause
Posted: 14 Nov 2014   Updated: 14 Nov 2014   Views: 27,860   Rating: 4.82/5    Votes: 5   Popularity: 3.37
Licence: The MIT License      Bookmarked: 5   Downloaded: 0
Sort Alphanumeric Values with SQL Server
Posted: 21 Dec 2014   Updated: 21 Dec 2014   Views: 7,180   Rating: 4.57/5    Votes: 5   Popularity: 3.20
Licence: The MIT License      Bookmarked: 5   Downloaded: 0
How to use the Except Operator in SQLServer
Posted: 4 Feb 2015   Updated: 4 Feb 2015   Views: 6,031   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The MIT License      Bookmarked: 5   Downloaded: 0
The purpose of this article is to introduce you to subqueries and some of their high-level concepts.  There are a lot of details to cover in order to learn sub queries, but you’ll see we cover those in depth in later articles.
Posted: 6 Feb 2015   Updated: 6 Feb 2015   Views: 8,610   Rating: 4.33/5    Votes: 2   Popularity: 1.30
Licence: The MIT License      Bookmarked: 1   Downloaded: 0
This is the second in a series of articles about subqueries. In this article, we discuss subqueries in the SELECT statement’s column list. Other articles discuss their uses in other clauses.
Posted: 20 Feb 2015   Updated: 20 Feb 2015   Views: 8,620   Rating: 4.60/5    Votes: 4   Popularity: 2.77
Licence: The MIT License      Bookmarked: 2   Downloaded: 0
In this post, we discuss subqueries in the WHERE clause.
Posted: 23 Feb 2015   Updated: 23 Feb 2015   Views: 23,840   Rating: 3.91/5    Votes: 4   Popularity: 2.35
Licence: The MIT License      Bookmarked: 2   Downloaded: 0
What is the difference between GROUP BY and ORDER BY
Posted: 2 Jan 2016   Updated: 2 Jan 2016   Views: 6,310   Rating: 4.20/5    Votes: 2   Popularity: 1.51
Licence: The MIT License      Bookmarked: 2   Downloaded: 0
Introduction to SQL Server’s Common String Functions
Posted: 2 Jan 2016   Updated: 2 Jan 2016   Views: 5,280   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The MIT License      Bookmarked: 1   Downloaded: 0
Introduction to SQL Server's built-in conversion functions
Posted: 4 Jan 2016   Updated: 4 Jan 2016   Views: 4,370   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The MIT License      Bookmarked: 5   Downloaded: 0
Introduction to SQL Server's built-in logical functions
Posted: 4 Jan 2016   Updated: 4 Jan 2016   Views: 10,840   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The MIT License      Bookmarked: 3   Downloaded: 0
How to find duplicate values in SQL Server
Posted: 4 Jan 2016   Updated: 4 Jan 2016   Views: 6,720   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The MIT License      Bookmarked: 3   Downloaded: 0
Introduction to SQL Server’s Mathematical Functions
Posted: 31 Dec 2015   Updated: 6 Jan 2016   Views: 30,155   Rating: 4.97/5    Votes: 10   Popularity: 4.97
Licence: The MIT License      Bookmarked: 11   Downloaded: 0
Difference between Cast and Convert
Posted: 19 Jan 2016   Updated: 19 Jan 2016   Views: 6,800   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: The MIT License      Bookmarked: 10   Downloaded: 0
How to Write SQL – Understand Database Table Meanings and Relationships – Step 1
Posted: 4 Nov 2016   Updated: 4 Nov 2016   Views: 3,670   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The MIT License      Bookmarked: 0   Downloaded: 0
Here is an introduction to the INSERT statement
Posted: 4 Nov 2016   Updated: 4 Nov 2016   Views: 3,930   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The MIT License      Bookmarked: 0   Downloaded: 0
Introduction to SQL Server Data Modification statements
Posted: 29 Dec 2016   Updated: 29 Dec 2016   Views: 5,180   Rating: 5.00/5    Votes: 7   Popularity: 4.23
Licence: The MIT License      Bookmarked: 7   Downloaded: 0
Introduction to cross join - create row combinations
Posted: 29 Dec 2016   Updated: 29 Dec 2016   Views: 3,650   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The MIT License      Bookmarked: 1   Downloaded: 0
Uncommon SQL server data types
Posted: 12 Feb 2017   Updated: 12 Feb 2017   Views: 3,720   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The MIT License      Bookmarked: 2   Downloaded: 0
In this article, well explore how to use the MERGE statement. We discuss some best practices, limitations, and wrap-up with several examples.
Posted: 12 Feb 2017   Updated: 12 Feb 2017   Views: 5,370   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The MIT License      Bookmarked: 2   Downloaded: 0
This post discusses the difference between merge and update
Posted: 30 Dec 2017   Updated: 30 Dec 2017   Views: 3,140   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The MIT License      Bookmarked: 2   Downloaded: 0
SQL set operations
Posted: 30 Dec 2017   Updated: 30 Dec 2017   Views: 5,230   Rating: 3.89/5    Votes: 5   Popularity: 2.62
Licence: The MIT License      Bookmarked: 2   Downloaded: 0
Benefits of stored procedures and how to create and execute them
Posted: 30 Dec 2017   Updated: 30 Dec 2017   Views: 3,030   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The MIT License      Bookmarked: 0   Downloaded: 0
In this video, we'll walk you through how to use the LIKE clause.
Posted: 30 Dec 2017   Updated: 30 Dec 2017   Views: 3,780   Rating: 5.00/5    Votes: 6   Popularity: 3.89
Licence: The MIT License      Bookmarked: 3   Downloaded: 0
How to join dirty data using SQL Server
Posted: 30 Dec 2017   Updated: 30 Dec 2017   Views: 7,010   Rating: 3.86/5    Votes: 3   Popularity: 1.62
Licence: The MIT License      Bookmarked: 6   Downloaded: 0
In this puzzle, we’re going to learn how to create a cross tab query using SQL Server.
Posted: 30 Dec 2017   Updated: 30 Dec 2017   Views: 5,291   Rating: 4.18/5    Votes: 7   Popularity: 3.32
Licence: The MIT License      Bookmarked: 4   Downloaded: 0
In this puzzle, we’re going to learn how to create a dynamic pivot table using SQL Server.
Posted: 30 Dec 2017   Updated: 30 Dec 2017   Views: 3,470   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The MIT License      Bookmarked: 1   Downloaded: 0
In this puzzle, we’re going to learn how to find the person whose birthday, among others, is in the middle.
Posted: 30 Dec 2017   Updated: 30 Dec 2017   Views: 5,960   Rating: 3.43/5    Votes: 6   Popularity: 2.67
Licence: The MIT License      Bookmarked: 5   Downloaded: 0
In this puzzle, we’re going to learn how to query the data dictionary using SQL Server.
Posted: 14 Aug 2019   Updated: 14 Aug 2019   Views: 1,820   Rating: 4.47/5    Votes: 5   Popularity: 3.12
Licence: The MIT License      Bookmarked: 4   Downloaded: 0
What is a Database Trigger? A database trigger is special stored procedure that is run when specific actions occur within a database.  Most triggers are defined to run when changes are made to a table’s data.
SQL Reporting Services
General
Posted: 17 Jun 2015   Updated: 17 Jun 2015   Views: 27,590   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The MIT License      Bookmarked: 6   Downloaded: 0
How do the SQL DISTINCT and TOP SELECT Clauses Work Together to Generate Results?
Posted: 30 Aug 2016   Updated: 30 Aug 2016   Views: 9,180   Rating: 4.43/5    Votes: 8   Popularity: 3.91
Licence: The MIT License      Bookmarked: 5   Downloaded: 0
How to calculate the end of the month in SQL
Posted: 25 Mar 2017   Updated: 25 Mar 2017   Views: 5,500   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The MIT License      Bookmarked: 2   Downloaded: 0
How to identify the top and bottom 25 percent to rank student scores
Posted: 13 Mar 2019   Updated: 13 Mar 2019   Views: 1,300   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The MIT License      Bookmarked: 2   Downloaded: 0
I recently put together a lesson on non-equi joins.  It is part of my Join Together Now course.  Click here get the course at a discount.  A non-equi join can be used to solve some interesting query problems.
Posted: 13 Mar 2019   Updated: 13 Mar 2019   Views: 1,620   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The MIT License      Bookmarked: 3   Downloaded: 0
In this lesson, we’re going to learn about the While Loop. So, what is a While Loop? Well, While Loop is set up using a While statement. While statements are used to repeatedly execute a block of SQL statements.
Posted: 26 Apr 2019   Updated: 26 Apr 2019   Views: 1,750   Rating: 3.78/5    Votes: 6   Popularity: 2.94
Licence: The MIT License      Bookmarked: 0   Downloaded: 0
SQL COALESCE Function and NULL
Posted: 14 Aug 2019   Updated: 14 Aug 2019   Views: 1,450   Rating: 4.17/5    Votes: 3   Popularity: 1.99
Licence: The MIT License      Bookmarked: 0   Downloaded: 0
A SQL database is used to store and retrieve data.  The database is housed in a database server and largely controlled by a database management system.  All SQL databases, whether they MS SQL Server, MySQL, Oracle, or Progress have several components in common.
Posted: 14 Aug 2019   Updated: 14 Aug 2019   Views: 930   Rating: 1.00/5    Votes: 1   Popularity: 0.00
Licence: The MIT License      Bookmarked: 0   Downloaded: 0
What are the  ACID Database Properties? The ACID database properties define the key characteristics SQL databases use to ensure database modification are saved in a consistent, safe, and robust manner. ACID is an acronym to remember the key principles of a transnational system.
Posted: 14 Aug 2019   Updated: 14 Aug 2019   Views: 2,200   Rating: 3.00/5    Votes: 4   Popularity: 1.81
Licence: The MIT License      Bookmarked: 0   Downloaded: 0
In SQL Server there are a couple a ways you can delete rows from a table.   You can use the TRUNCATE and DELETE command.  Though the end result of both commands is the same, there are very important differences you should know about. Whats the Difference between Truncate and Delete?
Posted: 14 Aug 2019   Updated: 14 Aug 2019   Views: 2,030   Rating: 4.20/5    Votes: 2   Popularity: 1.26
Licence: The MIT License      Bookmarked: 1   Downloaded: 0
Many times in a relational database the information you want to show in your query is in more than one table.  This begs the question “How do you combine results from more than one table?
Posted: 14 Aug 2019   Updated: 14 Aug 2019   Views: 1,910   Rating: 4.33/5    Votes: 3   Popularity: 2.07
Licence: The MIT License      Bookmarked: 0   Downloaded: 0
All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database.  You can get started using these free tools using my Guide Getting Started Using SQL Server.  Let’s get started and learn about a query plan. What is a Query Plan?
Design and Architecture
General
Posted: 30 Dec 2017   Updated: 30 Dec 2017   Views: 4,380   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: The MIT License      Bookmarked: 4   Downloaded: 0
How to do some basic data modeling
Work Issues
Pro Developer
Posted: 19 Mar 2017   Updated: 19 Mar 2017   Views: 5,060   Rating: 4.00/5    Votes: 5   Popularity: 2.80
Licence: The MIT License      Bookmarked: 4   Downloaded: 0
Work with the AdventureWorks Bill of Materials using Subqueries
Uncategorised Technical Blogs
General
Posted: 13 Mar 2019   Updated: 13 Mar 2019   Views: 1,110   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The MIT License      Bookmarked: 3   Downloaded: 0
I recently put together a lesson on  table aliases and multi-table joins.  It is part of my Join Together Now course.  Click here get the course at a discount.
Posted: 14 Aug 2019   Updated: 14 Aug 2019   Views: 2,650   Rating: 4.50/5    Votes: 4   Popularity: 2.71
Licence: The MIT License      Bookmarked: 1   Downloaded: 0
In this article learn when to use WHERE and HAVING.  Both perform similar functions, but for different purposes! All the examples for this article are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database.
No tips have been posted.
No reference articles have been posted.
No projects have been posted.

essentialSQL
Easy Computer Academy, LLC
United States United States
Hello my name is Kris. I’m here because I am passionate about helping non-techie people to overcome their fear of learning SQL.

I know what it is like to not know where to start or whether the time spent learning is worth the effort. That is why I am here to help you to:
- Get started in an easy to follow step-by-step manner.
- Use your time wisely so you focus on what is important to learn to get the most value from your time.
- Answer your questions. Really! Just post a comment and I’ll respond. I’m here to help.

It wasn’t long ago that I was helping a colleague with some reporting. She didn’t know where to start and soon got overwhelmed and lost as she didn’t know SQL.

I felt really bad, as she was under pressure to get some summary information to her boss, the built-in reports were falling short, and to make them better would require her to know SQL. At that time that seemed impossible! It in dawned on me, it doesn’t have to be that way.

Then I discovered a way for anyone with the desire to easily learn SQL. I worked with my co-worker, started to teach her what I learned and soon she was able to write reports and answer her boss’ questions without getting stressed or ploughing hours into manipulating data in Excel.

It hasn’t always been easy. Sometimes the information seems abstract or too conceptual. In this case I’ve found out that a visual explanation is best. I really like to use diagrams or videos to explain hard-to-grasp ideas.

Having video, pictures, and text really help to reinforce the point and enable learning.

And now I want to help you get the same results.

The first step is simple, click here ==> http://www.essentialsql.com/get-started-with-sql-server/