Books
Brahmanand Shukla

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. You'll explore the SQL Server Management Studio (SSMS) used for developing and managing SQL Server databases. You'll then learn how to use DDL statements to create, modify and delete tables and indexes. Gradually, you'll be able to query in T-SQL using DML statements, joins, and various built-in functions. Successively, you'll learn XML and JSON data processing, and by the time you'll 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, you'll learn through simple examples and straightforward explanations, diagrams, and numerous real-world use-cases.
569 printed pages
Copyright owner
BPB Publications
Original publication
2021
Have you already read it? How did you like it?
👍👎
fb2epub
Drag & drop your files (not more than 5 at once)