Tag: SQL Server
-
Beyond the Basics: Views, Ranking Functions and Aggregation with ROLLUP
Welcome back to our ongoing MSSQL series! In our previous post, we dived into Subqueries for precise data filtering and understood the foundational concept of Candidate Keys for robust database design. Today, we’re expanding our toolkit even further by exploring three powerful features that enhance data presentation, analysis, and aggregation: Views (virtual tables for simplified…
-
User-Defined Functions (UDFs): Extending SQL’s Capabilities
Welcome back to our journey through MSSQL! In our last post, Stored Procedures and Rules: Enhancing Database Control , we mastered encapsulating complex logic with Stored Procedures and understood why CHECK Constraints are vital for data integrity. Now, let’s explore User-Defined Functions (UDFs), another powerful way to extend SQL’s functionality and make your code more…
-
Stored Procedures and Rules: Enhancing Database Control
Welcome back to our MSSQL journey! In the previous post, we explored the power of SQL Triggers for automating database actions. Now, let’s unlock two more powerful features that give you greater control over your database operations and data integrity: Stored Procedures and Rules. These tools allow for the encapsulation of complex logic, enhance security,…
-
SQL Triggers: Automating Database Actions
Welcome back, data adventurers! In our previous post, we delved deep into SQL Functions, discovering how these powerful tools help us summarize, manipulate, and extract insights from our data. We explored everything from COUNT() and SUM() to UPPER(), TRIM(), and essential date functions like GETDATE() and DATEDIFF(). Today, we’re taking another significant leap forward. We’ll…
-
MSSQL: Overview and Your Guide to Installation and Setup
Welcome back to our blog series on the fascinating realm of databases! Following our foundational exploration of Databases and RDBMS, today we’re taking a focused dive into a powerful and widely adopted Relational Database Management System: Microsoft SQL Server (MSSQL). This post will serve as your starting point for understanding, installing, and connecting to MSSQL,…