There are several ways to calculate a running total in SQL. In this article, we will cover two methods: Joins, and Window Functions. We’ll first look at how to calculate the running total using an INNER JOIN. By doing so, you’ll not only learn more about join conditions, but see how to take the result […]
Continue reading
“How do I start learn SQL Server?” That is the most popular question I’m asked. Many people just don’t know where to start. I understand! SQL is a simple enough language to write basic queries, but putting together all the pieces to get started isn’t straight forward. So, if you’re looking to get started learning […]
Continue readingCheck out these 9 best study tips I came across in to help you with 70-761 certification. If you’re planning on studying for exam 70-761, the I would recommend that you put these good habits into practice today. You’ll see that cramming isn’t effective, so its best to plan ahead. 9 Best Study Tips Whether […]
Continue reading
In this article we learn the difference between a primary and unique key, and why both are important to maintaining a relational database structure. 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 […]
Continue reading
To help you get the most out your studying time, I put together this 70-761 resource page to help you succeed in getting ready for your certification. These resources help you prepare to take the 70-761 Querying Microsoft SQL Server Certification exam. Microsoft’s Official 70-761 Resource Page When preparing for the 70-761, your first stop […]
Continue reading