SalePaperback
Learn T-SQL from Scratch
Publisher:
BPB Publications
| Author:
Brahmanand Shukla
| Language:
English
| Format:
Paperback
Publisher:
BPB Publications
Author:
Brahmanand Shukla
Language:
English
Format:
Paperback
₹764
Save: 10%
In stock
Ships within:
1-4 Days
In stock
ISBN:
Page Extent:
440
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.
Description
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.
About Author
Brahmanand Shukla is a SQL Server Consultant with over 13 years of experience in Software Design, Development and Support. Brahmanand started his journey with SQL Server 2000 in the year 2007, and since then the SQL Server has been his second wife.
SQL Server is not the limit for Brahmanand. He has also designed and developed the databases in PostgreSQL, Oracle and Apache Cassandra. He has developed applications using VB 6.0, VB.Net, C#, ASP.Net, and Crystal Report. He has also delivered various cutting-edge ETL solutions in SSIS.
Brahmanand believes the database is no different than ordinary storage such as a cupboard. He feels proud to be known as the SQL Server Carpenter. He started blogging on SQL Server way back in 2016 and launched his personal weblog https://sqlservercarpenter.com/. He started his Consulting and Training firm under the same brand in 2020. He is also a community member of SQL Server Central.
Reviews
There are no reviews yet.
[wt-related-products product_id="test001"]
Reviews
There are no reviews yet.