Need help with a Microsoft SQL Server topic? We have a variety of free and paid products to teach you everything you need to know!
1. Quintessential Queries: A complete guide on beginner to advanced querying tools in Microsoft SQL Server
One of the most essential tasks of any data professional is to use SQL to query the data in a database. We query databases to gather information to do things like analyze trends, summarize costs, see spending patterns, or make important business decisions.
This book is a complete guide on beginner to advanced querying tools in Microsoft SQL Server.
In this book, we start with the most basic querying tools you will likely see and use during your career as a data professional. Once we understand the basics, we graduate to the more advanced querying tools you will need to know for the more challenging tasks.
We always use clear, plain speaking when discussing these topics so they are easier to understand. We have also done our very best to ensure the information in the book is 100% accurate and that all important details you need to know are discussed. We’ve done our very best to offer the most clear, in-depth discussions we can on these complicated querying topics.
Click here to learn more about Quintessential Queries!
2. Dignified Databases: A complete guide on designing and developing databases in Microsoft SQL Server
Designing and developing databases is a critical skill in today’s data-driven world, where information serves as the backbone of nearly every industry. Properly designed and developed databases provide a structured and organized way to store, manage, and retrieve data, enabling businesses and organizations to make informed decisions and enhance overall efficiency.
Dignified databases is dedicated to teaching you the fundamentals of designing and developing databases in Microsoft SQL Server. We’ll learn about tools and features in Microsoft SQL Server that enable us to create databases with a high degree of data integrity and a low degree of data redundancy.
We’ll see how we can create well-designed databases that ensure our data is accurate, consistent, and reliable, which is crucial for making sound business decisions and building trust in the information stored within the system.
We start with an understanding of the most basic objects available to us in Microsoft SQL Server. Once we understand the fundamentals, we’ll build on that knowledge to learn about the more advance development tools we can use for the more challenging tasks.
Throughout this book, we will break down these complicated topics into terms that are easy to understand through simple examples and helpful analogies. Through the knowledge gained in this book, it is my hope that you will add value to yourself and further your career in data!
Click here to learn more about Dignified Databases
3. FREE EBOOK: T-SQL Stored Procedures: A complete guide on creating and using stored procedures in Microsoft SQL Server
We use stored procedures to introduce programming logic into our databases. This guide discusses all the rules you need to know when working with stored procedures and how we can use stored procedures to make complicated tasks very simple!
Stored procedures are considered an advanced topic in Microsoft SQL Server, with many rules you need to remember. In this ebook, we take the time to thoroughly break down the topic of stored procedures using simple, plain speaking and helpful analogies to help you understand.
Click here to learn more about T-SQL Stored procedures!
4. FREE EBOOK: SQL Server Indexes: A complete guide on creating and using indexes in Microsoft SQL Server
Indexes are very important when it comes to query performance. This guide discusses the various indexes available to us and how we can use them to efficiently organize our data in memory and speed up our queries!
Indexes are considered an advanced topic in Microsoft SQL Server. In this EBook, we take the time to thoroughly break down indexes using simple, plain speaking and helpful analogies to help you understand.
Click here to learn more about SQL Server Indexes!
5. FREE EBOOK: SQL Server Table Expressions: A complete guide on creating and using table expressions in Microsoft SQL Server
A proper understanding of table expressions is absolutely essential for the data professional who finds themselves needing to query Microsoft SQL Server databases. This guide discusses all the rules you need to know when working with the various table expressions and how we can use table expressions to simplify complex querying tasks.
There are several different types of table expressions to choose from, each with their pros and cons. The different table expressions discussed in this ebook are:
- Derived Tables
- Common Table Expressions
- Views
- User Defined Functions
In this ebook, we take the time to thoroughly break down the different table expressions using simple, plain speaking and helpful analogies to help you understand.
Click here to learn more about SQL Server Table Expressions!
6. FREE EBOOK: SQL Server User Defined Functions: A complete guide on creating and using user defined functions in Microsoft SQL Server
We create user-defined functions to save complex tasks as objects in the database. This guide discusses all the rules you need to know when working with the various user defined functions and how we can use user defined functions to simplify complex tasks.
There are three different types of user defined functions we can create in Microsoft SQL Server. They are:
- Scalar Functions
- Inline Table Valued Functions
- Multi Statement Table Valued Functions
In this ebook, we discuss when/where/how each type of function can be created and used to simplify complex tasks. We take the time to thoroughly break down the different user defined functions using simple, plain speaking and helpful analogies to help you understand.
Click here to learn more about SQL Server User Defined Functions!
7. FREE EBOOK: SQL Server Transactions: A complete guide on creating and using transactions in Microsoft SQL Server
An understanding of transactions is absolutely essential for the data professional who finds themselves needing to query and modify data in Microsoft SQL Server databases. This guide discusses all the basic rules you need to know when working with transactions and how we can use transactions to safeguard our data and maintain our data integrity.
There are many rules and important details one needs to know when working with transactions. In this ebook, we take the time to thoroughly break down the topic of transactions using simple, plain speaking and helpful analogies to help you understand.
Click here to learn more about SQL Server Transactions!
8. FREE EBOOK: SQL Server Constraints: A complete guide on creating and using constraints in Microsoft SQL Server
We use constraints to restrict the type of data that can be entered into our database. They help create a situation where bad data physically cannot be entered into the database, thus helping maintain the integrity of our data. This guide discusses all the various constraints available to us in Microsoft SQL Server.
In this EBook, we take the time to break down the various constraints using simple, plain speaking and helpful analogies to help you understand.
Click here to learn more about SQL Server Constraints!
9. FREE EBOOK: SQL Server Window Functions: A complete guide on everything you need to know about window functions in Microsoft SQL Server
Window functions are excellent tools to know when it comes to querying data. This guide discusses all the rules you need to know when working with the various window functions and how we can use window functions to return exactly the information we need.
Window functions are considered an advanced querying tool. In this ebook, we take the time to break down the various window functions using simple, plain speaking and helpful analogies to help you understand.
Click here to learn more about SQL Server Window Functions!
10. FREE EBOOK: SQL Server Data Types: A complete guide on the most common data types in Microsoft SQL Server
It’s important to know a-thing-or-two about data types in Microsoft SQL Server. You should understand that data types basically establish a constraint on our data.
In this EBook, we take the time to thoroughly explain the various data types offered by SQL Server. We use simple, plain speaking and helpful analogies to help you understand how they work, and to help you see the pros and cons of each.
Click here to learn more about SQL Server Data Types!
11: FREE EBOOK: SQL Server JOIN Operations: A complete guide on writing JOIN queries in Microsoft SQL Server
JOIN operations are usually the first advanced querying tools that new SQL professionals struggle with. An understanding of JOIN operations is absolutely essential for the new database professional. This guide discusses all the rules you need to know when working with the various JOIN operations and how we can use JOINs to return exactly the information we need.
In this EBook, we take the time to thoroughly break down the JOIN operations using simple, plain speaking and helpful analogies to help you understand.
Click here to learn more about SQL Server JOIN operations!
12. FREE EBOOK: SQL Server Table Normalization: A complete guide on understanding First, Second, and Third Normal Forms in Microsoft SQL Server
A proper understanding of table normalization is absolutely essential for the data professional who finds themselves needing to design and develop Microsoft SQL Server database tables. This guide discusses all the important rules you need to remember when normalizing tables to First, Second, and Third normal forms. It also contains a brief discussion of the more advanced normalization levels beyond Third normal form.
In this Ebook, we take the time to thoroughly break down the different normal forms using simple, plain speaking and helpful analogies to help you understand.
Click here to learn more about SQL Server Table Normalization!
FREE 1-Page Simple SQL Cheat Sheets
Here is a list of several FREE 1-page Simple SQL Cheat Sheets about various T-SQL topics. These guides can serve as a quick reference you can use throughout your career as a database professional:
SQL Server Views
SQL Server Set Operators
The IDENTITY Property
The GROUP BY Clause
Correlated Subqueries
The EXISTS Predicate
DML Triggers
SQL Server NULL
SQL Server String Functions