In this article let’s look at window functions vs GROUP BY queries.
Here is a list of good questions I’ve been asked by my students in class or via email.
Whether you’re looking to find out the difference between of primary an foreign key or want to know what is a data dictionary, you’ll find answers to many common problems.
If you have a question that I haven’t answered, please ask! You can contact me here. I’m always looking to see what you guys need helps with, as it helps me learn! I love helping!
All the examples for this lesson are based on Microsoft SQL Server Management Studio and the sample databases AdventureWorks and WideWorldImporters. You can get started using these free tools using my guide Getting Started Using SQL Server
Everyone has their favorite DBMS, is your favorite one of the top databases? Though some non-relational products have entered the top ten,
There is more to being a Junior DBA than knowing SQL. The DBA works at the intersection of the database, server, operations
What is a Database Trigger? A SQL trigger is special stored procedure that is run when specific actions occur within a database.
Both TOP and OFFSET & FETCH can be used to limit the number of rows returned. OFFSET and FETCH can return similar
Its is easy to get confused between inner join vs outer join clauses. Both inner and outer joins are used to combine
Primary Key vs Unique Key. It really not about one or the other. You actually may need both a primary key and
A reader recently asked me to help them solve a problem combining data from multiple tables into a single result. What was
Use joins and UNIONS to combine data from two or more tables. Read this article to find out each command’s strengths and
In SQL Server there are a couple a ways you can delete rows from a table. You can use the TRUNCATE and DELETE
Table of contentsWhat are the ACID Database Properties?What’s an Example of ACID Properties? What are the ACID Database Properties? The ACID properties
When modifying one table based on the contents of another it may be tempting to simply use the merge statement, but before
I’m commonly asked whether whether I can have a CASE Statement in the WHERE Clause. There are a number of examples using
This article is inspired by a series of questions that one of my readers, Nan, recently sent me regarding SQL DISTINCT, TOP,
Sort Alphanumeric Values with SQL Server Recently a reader asked me how to sort an alpha numeric field in SQL in natural
What is a Null Value? In databases a common issue is what value or placeholder do you use to represent a missing
A database index allows a query to efficiently retrieve data from a database. Indexes are related to specific tables and consist of
A relational database is made up of several components, of which the table is most significant. The database table is where all
The main objective of a database management system is to store, retrieve, and process data. In order to do this in a
A SQL database is used to store and retrieve data. The database is housed in a database server and largely controlled by