Dignified Databases: A complete guide on designing and developing databases in Microsoft SQL Server - EBook

Understanding how to develop databases is crucial in the modern digital landscape. Databases serve as the backbone of information management in various industries. Proficiency in database development allows individuals to design and implement efficient data structures, ensuring the seamless storage, retrieval, and manipulation of information.

In a world where data is often considered the lifeblood of organizations, the ability to create well-organized and scalable databases is paramount for effective decision-making and streamlined business processes.

Dignified Databases is a complete guide on designing and developing databases in Microsoft SQL Server.

We start with an understanding of the fundamentals. We go over how to create tables, columns, and an understanding of data types. We build on these fundamentals, and eventually learn the more advanced development tools like constraints, indexes, triggers, and much more!

Here is the basic table of contents of the book:

• Chapter 1: Table Creation and Data Manipulation
  • Creating tables and columns
  • Understanding nullability
  • INSERT/UPDATE/DELETE statements
• Chapter 2: Data Types 
  • Integer data types
  • String data types
  • Date/time data types
  • User defined data types
• Chapter 3: Table Normalization
  • First Normal Form
  • Second Normal Form
  • Third Normal Form
  • Advanced Normal Forms
• Chapter 4: Constraints
  • Primary key constraints
  • Foreign key constraints
  • Unique constraints
  • Default constraints
  • Check constraints
• Chapter 5: Automatic Key Values
  • The IDENTITY property
  • Sequence Objects
  • The UNIQUEIDENTIFIER data type
• Chapter 6: Clustered and Nonclustered Indexes
  • Clustered Indexes
  • Nonclustered Indexes
  • The B-Tree
  • Unique Indexes
• Chapter 7: Temp Tables and Table Variables
  • Local and Global temp tables
  • Table variables
• Chapter 8: SQL Server Views
  • View properties
  • Updateable Views
  • Creating indexes on a View
• Chapter 9: User Defined Functions
  • Inline table valued functions
  • Multi statement table valued functions
  • Scalar functions
• Chapter 10: Stored Procedures
  • Understanding input parameters
  • Understanding output parameters
  • Starting a transaction within a stored procedure
• Chapter 11: Triggers
  • AFTER triggers
  • INSTEAD OF triggers
  • DDL (Data Definition Language) Triggers
• Chapter 12: Advanced Development Tools
  • Computed columns
  • Dynamic data masking
  • Temporal tables
  • Filegroups

All this content adds up to over 270 pages of information!

Whether you are a beginner or have been working with databases for a while, this book is for you! The book breaks down these difficult topics using helpful analogies and clear, plain speaking that is easy to understand. We take the time to thoroughly discuss these various development tools and work through simple examples to help you understand.

By the time you finish this book, you will have a SOLID understanding of the most common and useful development tools available to us in Microsoft SQL Server. You will certainly add value to yourself and your company, and hopefully further your career in data!