Learn T-SQL From Scratch

This book will teach you the fundamentals of SQL SQL Server databases and how to write queries and programs using T-SQL. After reading this book you will be able to create modify and delete databases tables and indexes. You can practice querying the data and running complex analytics on it. You will also be able to add delete and modify procedures user-defined functions triggers and views. The journey of learning T-SQL with this book begins with an understanding of SQL and database fundamentals. Youll explore the SQL Server Management Studio (SSMS) used for developing and managing SQL Server databases. Youll then learn how to use DDL statements to create modify and delete tables and indexes. Gradually youll be able to query in T-SQL using DML statements joins and various built-in functions. Successively youll learn XML and JSON data processing and by the time youll reach the end of this book you will learn to program in SQL Server and various strategies to deploy your databases and programs. Throughout the book youll learn through simple examples and straightforward explanations diagrams and numerous real-world use-cases.