Click here to Skip to main content
15,395,181 members

Articles by essentialSQL (Articles: 2, Technical Blogs: 135)

Articles: 2, Technical Blogs: 135

RSS Feed

Average article rating: 4.50

Database Development
SQL Server
21 Dec 2014   Updated: 21 Dec 2014   Rating: 4.00/5    Votes: 2   Popularity: 1.20
Licence: MIT    Views: 13,991     Bookmarked: 10   Downloaded: 0
Please Sign up or sign in to vote.
Learn to use Union, Intersect, and Except clauses
Programming Languages
SQL
13 May 2015   Updated: 13 May 2015   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: MIT    Views: 16,330     Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
This is a case study on how to use Joins, Subqueries, and Unions to combine data in SQL.

Average blogs rating: 4.53

Database Development
21 Oct 2014   Updated: 3 Nov 2014   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: MIT    Views: 13,700     Bookmarked: 12   Downloaded: 0
Please Sign up or sign in to vote.
Database Third Normal Form explained in simple English
21 Oct 2014   Updated: 21 Oct 2014   Rating: 4.88/5    Votes: 6   Popularity: 3.79
Licence: MIT    Views: 10,410     Bookmarked: 9   Downloaded: 0
Please Sign up or sign in to vote.
Database First Normal Form explained in simple English
21 Oct 2014   Updated: 21 Oct 2014   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: MIT    Views: 10,591     Bookmarked: 7   Downloaded: 0
Please Sign up or sign in to vote.
Database Second Normal Form explained in simple English
22 Oct 2014   Updated: 22 Oct 2014   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: MIT    Views: 7,113     Bookmarked: 9   Downloaded: 0
Please Sign up or sign in to vote.
How to combine table rows using UNION in SQL Server
22 Oct 2014   Updated: 22 Oct 2014   Rating: 5.00/5    Votes: 9   Popularity: 4.77
Licence: MIT    Views: 18,280     Bookmarked: 12   Downloaded: 0
Please Sign up or sign in to vote.
Database normalization in SQL explained in simple English
19 Jan 2016   Updated: 19 Jan 2016   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: MIT    Views: 9,042     Bookmarked: 10   Downloaded: 0
Please Sign up or sign in to vote.
How to Write SQL – Understand Database Table Meanings and Relationships – Step 1
29 Dec 2016   Updated: 29 Dec 2016   Rating: 5.00/5    Votes: 7   Popularity: 4.23
Licence: MIT    Views: 8,641     Bookmarked: 8   Downloaded: 0
Please Sign up or sign in to vote.
Introduction to cross join - create row combinations
6 Mar 2022   Updated: 6 Mar 2022   Rating: 3.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 2,230     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
Sooner or later, you want to know when a column contains in SQL another value.  In this article we’ll go over several ways you can test to see whether one value is contained within an another.
6 Mar 2022   Updated: 6 Mar 2022   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 2,140     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
In this article we look at SQL FULL JOIN examples and make a few notes of things to look for.
7 Mar 2022   Updated: 7 Mar 2022   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 2,040     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Top five performance tips for Stored Procedures
7 Mar 2022   Updated: 7 Mar 2022   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: CPOL    Views: 2,230     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
In this video and the following article, we’ll take you step-by-step through the process of changing a query’s filter criteria into a SQL variable, then ultimately into a stored procedure.
7 Mar 2022   Updated: 7 Mar 2022   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: CPOL    Views: 2,470     Bookmarked: 7   Downloaded: 0
Please Sign up or sign in to vote.
In this blog entry we do an overview of the order if execution in SQL.
7 Mar 2022   Updated: 7 Mar 2022   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 1,810     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
In this blog entry we discuss the difference between left join versus right join operators.
7 Mar 2022   Updated: 7 Mar 2022   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 2,480     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Puzzle to explore a SQL BOM example
7 Mar 2022   Updated: 7 Mar 2022   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: CPOL    Views: 2,200     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
Learn about a database cursor with an example and when to use it in a SP
7 Mar 2022   Updated: 7 Mar 2022   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 1,930     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
Learn about implicit data conversion and explicit type conversions with CAST AND CONVERT
7 Mar 2022   Updated: 7 Mar 2022   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 2,330     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
Comparison of a correlated sub query to a join
7 Mar 2022   Updated: 7 Mar 2022   Rating: 4.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 1,800     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
How to rewrite a subquery as a join
7 Mar 2022   Updated: 7 Mar 2022   Rating: 4.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 2,660     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
Puzzle to teach joins vs subqueries in SQL
MySQL
14 Aug 2019   Updated: 14 Aug 2019   Rating: 4.17/5    Votes: 3   Popularity: 1.99
Licence: MIT    Views: 3,290     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
This post discusses the major parts of a SQL database
14 Aug 2019   Updated: 14 Aug 2019   Rating: 4.47/5    Votes: 5   Popularity: 3.12
Licence: MIT    Views: 7,421     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
What is a Database Trigger?
SQL Server
11 Jan 2016   Updated: 11 Jan 2016   Rating: 4.89/5    Votes: 6   Popularity: 3.80
Licence: MIT    Views: 10,632     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Basic concepts of built-In functions in SQL Server
13 Mar 2019   Updated: 13 Mar 2019   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: MIT    Views: 3,480     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
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.
25 Apr 2019   Updated: 25 Apr 2019   Rating: 4.22/5    Votes: 6   Popularity: 3.28
Licence: MIT    Views: 3,920     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
SQL DISTINCT Clause For SQL Server
26 Apr 2019   Updated: 26 Apr 2019   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: MIT    Views: 3,062     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
SQL Server Hierarchical Query using the hierarchyid type
23 Oct 2014   Updated: 23 Oct 2014   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: MIT    Views: 7,480     Bookmarked: 9   Downloaded: 0
Please Sign up or sign in to vote.
Simplified Data Modeling in SQL
5 Jan 2016   Updated: 5 Jan 2016   Rating: 4.00/5    Votes: 1   Popularity: 0.00
Licence: MIT    Views: 9,910     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
Commonly used SQL Server data types
14 Jul 2016   Updated: 14 Jul 2016   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: MIT    Views: 7,251     Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
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.
3 Mar 2019   Updated: 3 Mar 2019   Rating: 2.87/5    Votes: 5   Popularity: 2.00
Licence: MIT    Views: 3,930     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
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.
14 Aug 2019   Updated: 14 Aug 2019   Rating: 4.50/5    Votes: 4   Popularity: 2.71
Licence: MIT    Views: 4,170     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
Difference between WHERE and HAVING clauses
24 Oct 2014   Updated: 24 Oct 2014   Rating: 4.75/5    Votes: 3   Popularity: 2.27
Licence: MIT    Views: 5,650     Bookmarked: 8   Downloaded: 0
Please Sign up or sign in to vote.
In today’s lesson, you’re going to learn how to filter the results returned from your queries using the WHERE clause.
24 Oct 2014   Updated: 24 Oct 2014   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: MIT    Views: 6,140     Bookmarked: 8   Downloaded: 0
Please Sign up or sign in to vote.
How to sort your query results in SQL Server
24 Oct 2014   Updated: 24 Oct 2014   Rating: 4.75/5    Votes: 3   Popularity: 2.27
Licence: MIT    Views: 6,072     Bookmarked: 7   Downloaded: 0
Please Sign up or sign in to vote.
Learn more about filtering results returned from your queries using the WHERE clause
25 Oct 2014   Updated: 25 Oct 2014   Rating: 4.71/5    Votes: 4   Popularity: 2.84
Licence: MIT    Views: 10,041     Bookmarked: 12   Downloaded: 0
Please Sign up or sign in to vote.
Simple SELECT queries in SQL Server
29 Oct 2014   Updated: 29 Oct 2014   Rating: 4.50/5    Votes: 2   Popularity: 1.35
Licence: MIT    Views: 5,470     Bookmarked: 7   Downloaded: 0
Please Sign up or sign in to vote.
In this lesson, you are going to explore how to do pattern matching with the SQL Where clause LIKE operator.
31 Oct 2014   Updated: 31 Oct 2014   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: MIT    Views: 9,150     Bookmarked: 8   Downloaded: 0
Please Sign up or sign in to vote.
How to use the Intersect Operator in SQL Server
14 Aug 2019   Updated: 14 Aug 2019   Rating: 3.00/5    Votes: 4   Popularity: 1.81
Licence: CPOL    Views: 3,570     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
Truncate and Delete in SQL
14 Aug 2019   Updated: 14 Aug 2019   Rating: 4.33/5    Votes: 3   Popularity: 2.07
Licence: MIT    Views: 3,380     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
Query plans in SQL
22 Oct 2014   Updated: 22 Oct 2014   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: MIT    Views: 8,300     Bookmarked: 9   Downloaded: 0
Please Sign up or sign in to vote.
Introduction to Outer Joins in SQL Server
22 Oct 2014   Updated: 22 Oct 2014   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: MIT    Views: 6,770     Bookmarked: 8   Downloaded: 0
Please Sign up or sign in to vote.
Introduction to Inner Joins in SQL Server
23 Oct 2014   Updated: 23 Oct 2014   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: MIT    Views: 7,540     Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
Query Results Using Pattern Matching in SQL
23 Oct 2014   Updated: 23 Oct 2014   Rating: 4.60/5    Votes: 3   Popularity: 2.19
Licence: MIT    Views: 9,200     Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
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.
23 Oct 2014   Updated: 23 Oct 2014   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: MIT    Views: 7,882     Bookmarked: 7   Downloaded: 0
Please Sign up or sign in to vote.
How to Group and Summarize your Results in SQL
29 Oct 2014   Updated: 29 Oct 2014   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: MIT    Views: 8,130     Bookmarked: 11   Downloaded: 0
Please Sign up or sign in to vote.
Grouping results returned from your queries using the GROUP BY clause
14 Nov 2014   Updated: 14 Nov 2014   Rating: 4.82/5    Votes: 5   Popularity: 3.37
Licence: MIT    Views: 39,704     Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
Sort Alphanumeric Values with SQL Server
21 Dec 2014   Updated: 21 Dec 2014   Rating: 4.57/5    Votes: 5   Popularity: 3.20
Licence: MIT    Views: 9,411     Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
How to use the Except Operator in SQLServer
4 Feb 2015   Updated: 4 Feb 2015   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: MIT    Views: 7,271     Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
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.
6 Feb 2015   Updated: 6 Feb 2015   Rating: 4.33/5    Votes: 2   Popularity: 1.30
Licence: MIT    Views: 10,900     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
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.
23 Feb 2015   Updated: 23 Feb 2015   Rating: 3.91/5    Votes: 4   Popularity: 2.35
Licence: MIT    Views: 26,641     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
What is the difference between GROUP BY and ORDER BY
2 Jan 2016   Updated: 2 Jan 2016   Rating: 4.20/5    Votes: 2   Popularity: 1.26
Licence: MIT    Views: 8,660     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
Introduction to SQL Server’s Common String Functions
2 Jan 2016   Updated: 2 Jan 2016   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: MIT    Views: 7,962     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
Introduction to SQL Server's built-in conversion functions
4 Jan 2016   Updated: 4 Jan 2016   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: MIT    Views: 5,551     Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
Introduction to SQL Server's built-in logical functions
4 Nov 2016   Updated: 4 Nov 2016   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: MIT    Views: 5,701     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
Introduction to SQL Server Data Modification statements
29 Dec 2016   Updated: 29 Dec 2016   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: MIT    Views: 4,750     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
Uncommon SQL server data types
30 Dec 2017   Updated: 30 Dec 2017   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: MIT    Views: 6,042     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
SQL set operations
30 Dec 2017   Updated: 30 Dec 2017   Rating: 3.89/5    Votes: 5   Popularity: 2.72
Licence: MIT    Views: 7,050     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
Benefits of stored procedures and how to create and execute them
30 Dec 2017   Updated: 30 Dec 2017   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: MIT    Views: 4,220     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
In this video, we'll walk you through how to use the LIKE clause.
30 Dec 2017   Updated: 30 Dec 2017   Rating: 5.00/5    Votes: 6   Popularity: 3.89
Licence: MIT    Views: 5,140     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
How to join dirty data using SQL Server
30 Dec 2017   Updated: 30 Dec 2017   Rating: 3.86/5    Votes: 3   Popularity: 1.84
Licence: MIT    Views: 9,821     Bookmarked: 6   Downloaded: 0
Please Sign up or sign in to vote.
In this puzzle, we’re going to learn how to create a cross tab query using SQL Server.
30 Dec 2017   Updated: 30 Dec 2017   Rating: 4.18/5    Votes: 7   Popularity: 3.53
Licence: MIT    Views: 7,483     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
In this puzzle, we’re going to learn how to create a dynamic pivot table using SQL Server.
30 Dec 2017   Updated: 30 Dec 2017   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: MIT    Views: 4,751     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
In this puzzle, we’re going to learn how to find the person whose birthday, among others, is in the middle.
30 Dec 2017   Updated: 30 Dec 2017   Rating: 3.43/5    Votes: 6   Popularity: 2.67
Licence: MIT    Views: 8,160     Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
In this puzzle, we’re going to learn how to query the data dictionary using SQL Server.
14 Aug 2019   Updated: 14 Aug 2019   Rating: 3.12/5    Votes: 6   Popularity: 2.43
Licence: MIT    Views: 3,305     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
How to use SQL Server Date functions
14 Aug 2019   Updated: 14 Aug 2019   Rating: 3.00/5    Votes: 2   Popularity: 0.90
Licence: CPOL    Views: 21,624     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
What is a Data Dictionary in SQL Server?
26 Apr 2019   Updated: 26 Apr 2019   Rating: 3.78/5    Votes: 6   Popularity: 2.94
Licence: MIT    Views: 3,610     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
SQL COALESCE Function and NULL
14 Aug 2019   Updated: 14 Aug 2019   Rating: 4.20/5    Votes: 2   Popularity: 1.26
Licence: MIT    Views: 6,081     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
How to combine results from more than one table
29 Dec 2019   Updated: 29 Dec 2019   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: MIT    Views: 1,671     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
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 a good skill to have.  As you start to explore business intelligence you’ll come across similar problems to solve.
23 Feb 2020   Updated: 23 Feb 2020   Rating: 4.50/5    Votes: 4   Popularity: 2.71
Licence: MIT    Views: 9,650     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
SQL COALESCE function and how you can test for null, and when present, substitute it for another value
Mobile Apps
Smartphone
14 Aug 2019   Updated: 14 Aug 2019   Rating: 3.10/5    Votes: 10   Popularity: 3.10
Licence: CPOL    Views: 4,951     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
SQLite3 is a compact free database you can use easily to create and use a database. Learn more about it in this blog post.
Productivity Apps and Services
Microsoft Office
14 Aug 2019   Updated: 14 Aug 2019   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: MIT    Views: 4,200     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
In this blog post, you will learn about stored procedures
29 Dec 2020   Updated: 29 Dec 2020   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: MIT    Views: 4,791     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
How to reconstruct full outer join in SQL using other join clauses
Sharepoint
10 Mar 2015   Updated: 10 Mar 2015   Rating: 4.67/5    Votes: 2   Popularity: 1.40
Licence: MIT    Views: 6,110     Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
Subqueries in the FROM clause
21 Mar 2015   Updated: 21 Mar 2015   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: MIT    Views: 5,681     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
Get ready to learn SQL Server 23: Using Subqueries in the HAVING clause
16 Jun 2015   Updated: 16 Jun 2015   Rating: 4.31/5    Votes: 5   Popularity: 3.01
Licence: MIT    Views: 34,133     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
Difference between primary and foreign keys, and why both are important to maintaining a relational database structure
16 Jun 2015   Updated: 16 Jun 2015   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: MIT    Views: 6,991     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Difference between Top and Offset & Fetch
16 Jun 2015   Updated: 16 Jun 2015   Rating: 4.45/5    Votes: 6   Popularity: 3.47
Licence: MIT    Views: 18,783     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Using OFFSET and FETCH with the ORDER BY clause
1 Jan 2016   Updated: 1 Jan 2016   Rating: 4.56/5    Votes: 5   Popularity: 3.18
Licence: MIT    Views: 49,481     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Difference between a join and a union
3 Jan 2016   Updated: 3 Jan 2016   Rating: 4.67/5    Votes: 5   Popularity: 3.26
Licence: MIT    Views: 39,473     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
What is the Difference between a Join and Subquery?
20 Jul 2016   Updated: 20 Jul 2016   Rating: 5.00/5    Votes: 6   Popularity: 3.89
Licence: MIT    Views: 10,920     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
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
19 Mar 2017   Updated: 19 Mar 2017   Rating: 3.76/5    Votes: 5   Popularity: 2.63
Licence: MIT    Views: 8,150     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
In this puzzle, we're going to learn how to create a bar chart using SQL Server.
19 Mar 2017   Updated: 19 Mar 2017   Rating: 3.91/5    Votes: 6   Popularity: 3.04
Licence: MIT    Views: 11,072     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
How to find a gap in a sequence using SQL Server
30 Dec 2017   Updated: 30 Dec 2017   Rating: 5.00/5    Votes: 8   Popularity: 4.52
Licence: MIT    Views: 9,411     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
Difference between a primary and unique key and why both are important to maintaining a relational database structure
1 Mar 2018   Updated: 1 Mar 2018   Rating: 4.00/5    Votes: 2   Popularity: 1.20
Licence: MIT    Views: 16,783     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Use IF…ELSE statements to program a Stored Procedure
1 Mar 2018   Updated: 1 Mar 2018   Rating: 2.45/5    Votes: 3   Popularity: 1.17
Licence: MIT    Views: 10,331     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
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.
20 Feb 2015   Updated: 20 Feb 2015   Rating: 4.60/5    Votes: 4   Popularity: 2.77
Licence: MIT    Views: 10,531     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
In this post, we discuss subqueries in the WHERE clause.
4 Nov 2016   Updated: 4 Nov 2016   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: MIT    Views: 4,891     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
Here is an introduction to the INSERT statement
Programming Languages
SQL
13 Mar 2019   Updated: 13 Mar 2019   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: MIT    Views: 4,382     Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
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.
13 Mar 2019   Updated: 13 Mar 2019   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: MIT    Views: 2,520     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
An answer to fix an error converting data type from varchar to float
29 Dec 2019   Updated: 29 Dec 2019   Rating: 4.64/5    Votes: 4   Popularity: 2.79
Licence: MIT    Views: 2,372     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
How to identify the top and bottom 25 percent to rank student scores
14 Aug 2019   Updated: 14 Aug 2019   Rating: 4.33/5    Votes: 3   Popularity: 2.07
Licence: MIT    Views: 2,561     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
What is a database table?
14 Aug 2019   Updated: 14 Aug 2019   Rating: 3.67/5    Votes: 3   Popularity: 1.75
Licence: MIT    Views: 3,400     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
Database indexes explained
31 Dec 2015   Updated: 31 Dec 2015   Rating: 4.57/5    Votes: 9   Popularity: 4.36
Licence: MIT    Views: 8,860     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
Difference between inner and outer joins
9 Jul 2016   Updated: 9 Jul 2016   Rating: 4.80/5    Votes: 6   Popularity: 3.74
Licence: MIT    Views: 7,190     Bookmarked: 6   Downloaded: 0
Please Sign up or sign in to vote.
Introduction to Common Table Expressions
23 Nov 2016   Updated: 23 Nov 2016   Rating: 4.00/5    Votes: 7   Popularity: 3.38
Licence: MIT    Views: 4,570     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Here is an introduction to the Delete statement
23 Nov 2016   Updated: 23 Nov 2016   Rating: 4.17/5    Votes: 4   Popularity: 2.51
Licence: MIT    Views: 7,231     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
An introduction to the UPDATE statement
1 Mar 2018   Updated: 1 Mar 2018   Rating: 4.47/5    Votes: 5   Popularity: 3.12
Licence: MIT    Views: 9,780     Bookmarked: 11   Downloaded: 0
Please Sign up or sign in to vote.
How to build dynamic SQL in a stored procedure
17 Jul 2015   Updated: 17 Jul 2015   Rating: 4.75/5    Votes: 11   Popularity: 4.75
Licence: MIT    Views: 34,934     Bookmarked: 9   Downloaded: 0
Please Sign up or sign in to vote.
How to use conditional logic in SQL with CASE expression
19 Jan 2016   Updated: 19 Jan 2016   Rating: 4.45/5    Votes: 5   Popularity: 3.11
Licence: MIT    Views: 8,151     Bookmarked: 6   Downloaded: 0
Please Sign up or sign in to vote.
Three simple steps to writing SQL queries
19 Jan 2016   Updated: 19 Jan 2016   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: MIT    Views: 4,720     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
Write SQL – Formulate your Question – Step 2
26 Jan 2016   Updated: 26 Jan 2016   Rating: 4.33/5    Votes: 3   Popularity: 2.07
Licence: MIT    Views: 5,720     Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
Write SQL - write the query
23 Feb 2017   Updated: 23 Feb 2017   Rating: 4.76/5    Votes: 12   Popularity: 5.13
Licence: MIT    Views: 17,806     Bookmarked: 13   Downloaded: 0
Please Sign up or sign in to vote.
How to calculate moving averages by working through a hypothetical stock market example
23 Feb 2017   Updated: 23 Feb 2017   Rating: 4.79/5    Votes: 8   Popularity: 4.33
Licence: MIT    Views: 9,036     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
How to identify the top and bottom 25 percent to rank student scores
25 Mar 2017   Updated: 25 Mar 2017   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: MIT    Views: 5,810     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
How to calculate moving averages
30 Dec 2017   Updated: 30 Dec 2017   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: MIT    Views: 5,861     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
In this puzzle, we’re going to learn how to rewrite a subquery using inner joins.
30 Dec 2017   Updated: 30 Dec 2017   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: MIT    Views: 4,861     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
Joins versus subqueries in SQL
30 Dec 2017   Updated: 30 Dec 2017   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: MIT    Views: 4,251     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
How to write a SQL UNION without using Set operations
30 Dec 2017   Updated: 30 Dec 2017   Rating: 4.50/5    Votes: 5   Popularity: 3.15
Licence: MIT    Views: 7,350     Bookmarked: 6   Downloaded: 0
Please Sign up or sign in to vote.
There are several ways to calculate a running total in SQL. In this article, we will cover two methods: Joins, and Window Functions.
30 Dec 2017   Updated: 30 Dec 2017   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: MIT    Views: 4,360     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
How to use the TOP clause in SQL
30 Dec 2017   Updated: 30 Dec 2017   Rating: 4.09/5    Votes: 6   Popularity: 3.18
Licence: MIT    Views: 4,980     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
How to select top rows within a query
13 Mar 2019   Updated: 13 Mar 2019   Rating: 3.67/5    Votes: 2   Popularity: 1.10
Licence: MIT    Views: 3,572     Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
In this episode of SQL Minute I want to share with you how to create a pivot or cross tab chart.
13 Mar 2019   Updated: 13 Mar 2019   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: MIT    Views: 9,061     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
A common question I get ask is whether I can have a CASE Statement in the WHERE Clause.
14 Aug 2019   Updated: 14 Aug 2019   Rating: 2.33/5    Votes: 2   Popularity: 0.70
Licence: MIT    Views: 3,390     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
SQL ACID explained
29 Dec 2019   Updated: 29 Dec 2019   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: MIT    Views: 1,471     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
How to select top rows within a query
22 Oct 2014   Updated: 22 Oct 2014   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: MIT    Views: 8,050     Bookmarked: 11   Downloaded: 0
Please Sign up or sign in to vote.
Introduction to database joins in SQL
4 Jan 2016   Updated: 4 Jan 2016   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: MIT    Views: 15,014     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
How to find duplicate values in SQL Server
4 Jan 2016   Updated: 4 Jan 2016   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: MIT    Views: 9,871     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Introduction to SQL Server’s Mathematical Functions
12 Feb 2017   Updated: 12 Feb 2017   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: MIT    Views: 5,361     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
In this article, well explore how to use the MERGE statement. We discuss some best practices, limitations, and wrap-up with several examples.
12 Feb 2017   Updated: 12 Feb 2017   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: MIT    Views: 9,461     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
This post discusses the difference between merge and update
17 Jun 2015   Updated: 17 Jun 2015   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: MIT    Views: 37,618     Bookmarked: 6   Downloaded: 0
Please Sign up or sign in to vote.
How do the SQL DISTINCT and TOP SELECT Clauses Work Together to Generate Results?
30 Aug 2016   Updated: 30 Aug 2016   Rating: 4.43/5    Votes: 8   Popularity: 4.00
Licence: MIT    Views: 12,362     Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
How to calculate the end of the month in SQL
25 Mar 2017   Updated: 25 Mar 2017   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: MIT    Views: 7,761     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
How to identify the top and bottom 25 percent to rank student scores
13 Mar 2019   Updated: 13 Mar 2019   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: MIT    Views: 3,091     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
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.
29 Dec 2019   Updated: 29 Dec 2019   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: MIT    Views: 1,731     Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
In this puzzle, we’re going to learn how to calculate moving averages by working through a hypothetical stock market example. Solving puzzles is a great way to learn SQL.  Nothing beats practicing what you’ve learned.
30 Dec 2017   Updated: 30 Dec 2017   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: MIT    Views: 5,570     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
How to do some basic data modeling
19 Mar 2017   Updated: 19 Mar 2017   Rating: 4.00/5    Votes: 5   Popularity: 2.80
Licence: MIT    Views: 6,750     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
Work with the AdventureWorks Bill of Materials using Subqueries
7 Mar 2022   Updated: 7 Mar 2022   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 2,000     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
In this article we’ve collected all the essential information about writing SQL queries into one ultimate guide to help you gain and practice this knowledge more effectively.
13 Mar 2019   Updated: 13 Mar 2019   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: MIT    Views: 3,340     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
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.
4 Mar 2022   Updated: 4 Mar 2022   Rating: 3.00/5    Votes: 3   Popularity: 1.43
Licence: CPOL    Views: 3,320     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Use STRING_SPLIT() to join two tables
7 Mar 2022   Updated: 7 Mar 2022   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 1,241     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
In this blog entry we do an overview of the SQL DATEDIFF function
7 Mar 2022   Updated: 7 Mar 2022   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 1,330     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
In this article we’re going to cover the seven data types you’ll most frequently encounter in your everyday use of SQL.
7 Mar 2022   Updated: 7 Mar 2022   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 1,930     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
The purpose of this article is to introduce you to SQL window functions and some of the high-level concepts.
7 Mar 2022   Updated: 7 Mar 2022   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 1,540     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
How to use SQL GROUP BY Clause is to consolidate like values into a single row
T-SQL
13 Mar 2019   Updated: 13 Mar 2019   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: MIT    Views: 3,281     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
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.
31 Dec 2015   Updated: 6 Jan 2016   Rating: 4.97/5    Votes: 10   Popularity: 4.97
Licence: MIT    Views: 46,696     Bookmarked: 11   Downloaded: 0
Please Sign up or sign in to vote.
Difference between Cast and Convert
13 Mar 2019   Updated: 13 Mar 2019   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: MIT    Views: 2,763     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
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.

Average tips rating:

No tips have been posted.

Average reference rating:

No reference articles have been posted.

Average project rating:

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/