This book uses a simple step by step approach to explain the essential relational database design modelling techniques, and shows how Oracle SQL can be used to implement a database.

This book describes a lot of specific problems, and typical approaches that will lead to more robust code, However, my main goal is more general: it is to demonstrate how to think defensively, and how to proactively identify and eliminate potential vulnerabilities in T-SQL code during development rather than after the event when the problems have already occurred.

There are a lot of good books on SQL, so you can choose for a long time. This is a great guide considers the techniques of database design for mere developers, and methods of optimization of loads for system administrators.

Writing is truly a cooperative effort, despite what you may have heard about it. I’m so grateful for the editors, colleagues, friends, and family who continue to be ready and willing to lend their help.

The database/sql package is Go’s lightweight standard interface for relational databases, with support for backend drivers, prepared statements and transactions.