Brahmanand Shukla - Learn T-SQL From Scratch: An Easy-to-Follow Guide for Designing, Developing, and Deploying Databases in the SQL Server and Writing T-SQL Queries Efficiently

www.bpbonline.com

FIRST EDITION 2022

Copyright BPB Publications, India

ISBN: 978-93-91392-413

All Rights Reserved. No part of this publication may be reproduced, distributed or transmitted in any form or by any means or stored in a database or retrieval system, without the prior written permission of the publisher with the exception to the program listings which may be entered, stored and executed in a computer system, but they can not be reproduced by the means of publication, photocopy, recording, or by any electronic and mechanical means.

LIMITS OF LIABILITY AND DISCLAIMER OF WARRANTY

The information contained in this book is true to correct and the best of authors and publishers knowledge. The author has made every effort to ensure the accuracy of these publications, but publisher cannot be held responsible for any loss or damage arising from any information in this book.

All trademarks referred to in the book are acknowledged as properties of their respective owners but BPB Publications cannot guarantee the accuracy of this information.

www.bpbonline.com

SQL Server has evolved over the last 2 decades into one of the most prominent databases for enterprise application development out there. It is never too late to start learning and I wouldnt miss an opportunity to learn SQL Server Coding from scratch from a book as useful as Learn T-SQL from Scratch.

I have known Brahmanand Shukla (aka Brahma) when I worked with Ebixcash Financial Technologies as CTO. Brahma worked on some of the toughest and complex SQL Server projects in that stint with me. He is a SQL Server development authority and runs a SQL Server based blog & consultancy, SQL Server Carpenters ( https://sqlservercarpenter.com/), working with marquee Customers in SQL Server area.

The book is by practitioner for a to-be practitioner, by an expert developer for a novice developer. It explains the concepts, and quickly jumps into the code and implementation of it. It does so with simply explained concepts, pictures, code snippets, SSMS snapshots, with a flair for hands on approach. So, anyone aiming to start off quickly with SQL Server development, with no background, will find this book hard to keep down. From simple concepts like tables, indexes, functions, and procedures, it goes to touch upon advanced topics as handling of XML & JSON data, transactions, and error handling.

Thanks to people like Brahmanand Shukla, author of this book, who share their practical knowledge with easy journey from basic to advanced concepts, you can discover that learning T-SQL has never been this easy.

Pradeep Paliwal
MTech (Data Science), BITS Piliani
MBA (Systems), XIMB
BE, VJTI

Regardless of the topic, from martial arts, to woodworking, to flying a plane, and certainly to building and maintaining databases, fundamentals matter more than anything else. If you dont have a good foundation for your building, it will collapse. Same thing goes for working with SQL Server. If you dont have the fundamentals well understood and properly applied, you, and the organization youre supporting, will suffer.

All of this is why a book like this one is so important.

While youre reading through this book, keep that concept in mind. You need to understand the fundamentals of SQL Server in order to do basic tasks, yes, but also the advanced ones. The structure and layout of the book builds knowledge and doesnt assume you already understand concepts. Youll be walked up to topics carefully. Youll get the fundamentals that are so important, vital in fact.

So, study it well and be better at your database development, maintenance, administration, analysis, pretty much anything and everything to do with SQL Server.