 As companies grow and do more business, the data they store in databases similarly grows. If you want to be a go-to person on the inner workings of SQL Server, then this book will be your partner in achieving that goal.
If you have completed the SQL Queries Joes 2 Pros book you have written some advanced queries. This book builds on that knowledge and will show you more about the parts of SQL Server at work behind the scenes when you are running queries and creating new database objects. Most importantly, you will learn how to make the essential queries for your business run most efficiently and at the fastest speed possible.
Most of the exercises in this book are designed around proper database practices in the workplace. The workplace also offers common challenges and process changes over time. For example, it is good practice to use numeric data for IDs. If you have ever seen a Canadian postal code (zip code), you see the need for character data in relational information. You will occasionally see an off-the-beaten-path strategy demonstrated so you know how to approach a topic in a job interview or workplace assignment. |
|
