SalePaperback
Learn SQL with MySQL
₹399 ₹359
Save: 10%
Learn Vue.js 2.0 in 7 Days
₹498 ₹448
Save: 10%
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
₹849 ₹764
Save: 10%
In stock
Ships within:
1-4 Days
In stock
ISBN:
SKU
9789391392413
Category Computer Engineering/IT Engineering
Category: Computer Engineering/IT Engineering
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.
Be the first to review “Learn T-SQL from Scratch ” Cancel reply
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.
Be the first to review “Learn T-SQL from Scratch ” Cancel reply
[wt-related-products product_id="test001"]
Related products
RELATED PRODUCTS
Computer Methods For Engineering With Matlab Applications, 2nd Edn
Save: 15%
Digital Forensics In The Era Of Artificial Intelligence
Save: 15%
Driving 5g Mobile Communications With Artificial Intelligence Towards 6g
Save: 15%
Geospatial Data Science Techniques And Applications
Save: 15%
Introduction To Programming And Problem-Solving Scala, 2nd Edition
Save: 15%
Machine Learning For Healthcare , Handling And Managing Data
Save: 15%
Secure Data Science Integrating Cyber Security And Data Science
Save: 15%
Security And Organization Within Iot And Smart Cities
Save: 15%
Reviews
There are no reviews yet.