Portada

LEARN T-SQL FROM SCRATCH IBD

BPB PUBLICATIONS
11 / 2021
9789391392413
Inglés

Sinopsis

Advance your career as an SQL Server developer and DBAáKEY FEATURESááâùÅ Cutting-edge coverage from community experts to learn T-SQL programming.âùÅ Detailed explanation of concepts and techniques for easy understanding.âùÅ Numerous practical demonstrations of T-SQL querying and programming applications.á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. áWHAT YOU WILL LEARNâùÅ Concise understanding of relational databases and the SQL Server.âùÅ Learn how to create database tables and indexes using T-SQL.âùÅ Learn to add, modify, and delete records.âùÅ Practice how to slice and dice data by running smart T-SQL queries.âùÅ Perform advanced analytical analysis using various functions.âùÅ Discover Error Handling and Transaction Management.âùÅ Administer XML and JSON handling with T-SQL.âùÅ Practice different deployment modes for T-SQL objects.WHO THIS BOOK IS FORááIf you want to know how to design, develop, and maintain SQL Server databases and run sophisticated T-SQL queries without much hassle, this book is for you. Readers with a basic understanding of programming would have an advantage.

PVP
53,05