EasterBlack-owned or founded brands at TargetGroceryClothing, Shoes & AccessoriesBabyHomeFurnitureKitchen & DiningOutdoor Living & GardenToysElectronicsVideo GamesMovies, Music & BooksSports & OutdoorsBeautyPersonal CareHealthPetsHousehold EssentialsArts, Crafts & SewingSchool & Office SuppliesParty SuppliesLuggageGift IdeasGift CardsClearanceTarget New ArrivalsTarget Finds#TargetStyleTop DealsTarget Circle DealsWeekly AdShop Order PickupShop Same Day DeliveryRegistryRedCardTarget CircleFind Stores

Sponsored

Pro T-SQL 2022 - 2nd Edition by Elizabeth Noble (Paperback)

Pro T-SQL 2022 - 2nd Edition by  Elizabeth Noble (Paperback) - 1 of 1
$45.49 sale price when purchased online
$79.99 list price
Target Online store #3991

About this item

Highlights

  • Learn how to write and design simple and efficient T-SQL code.
  • About the Author: Elizabeth Noble is a Microsoft Data Platform MVP and Director of Database Development in the metro Atlanta area.
  • 553 Pages
  • Computers + Internet, Databases

Description



Book Synopsis



Learn how to write and design simple and efficient T-SQL code. This is a hands-on book that teaches you how to write better T-SQL with examples and straightforward explanations. New in this edition is coverage of Parameter Sensitive Plan (PSP) optimization, Azure Synapse Link for real-time analytics, integration with S3-compatible object storage, and SQL Ledger tables based on blockchain. You'll learn to improve your T-SQL design in ways that provide faster performance, stronger security, and easier comprehension. The book identifies common anti-patterns in writing T-SQL and instructs you on how to change your code so you can be more confident in writing T-SQL code that is reliable and performs well.
Pro T-SQL 2022 is focused on the problems that developers are faced with and must solve in delivering successful applications. The content begins from a foundation of writing T-SQL that is clear and understandable. The book then takes youthrough writing SQL that performs well, is easy to manage through coding standards and version control, can be maintained and modified as business requirements change over time, scales as your business grows, and takes advantage of the full range of security features built into the SQL Server and Azure SQL database engines.

What You Will Learn

  • Choose the correct data types and database objects when designing your T-SQL
  • Write T-SQL that accesses your data efficiently and uses hardware effectively
  • Implement source control and testing methods to streamline your deployment process.
  • Design T-SQL that is flexible and can be enhanced or modified with little effort
  • Plan for long-term data management, including growth and purging of older data
  • Enhance database security through features such as encryption, data masking, row-level security, and the SQL Ledger blockchain table type

Who This Book Is For
Database developers who want to improve the efficiency of their applications with better T-SQL; developers who want to know more about T-SQL so they can be prepared to solve complex problems more easily; data professionals who want to write high-quality T-SQL that performs well, is flexible to changing needs, and is easy for others to understand



From the Back Cover



Learn how to write and design simple and efficient T-SQL code. This is a hands-on book that teaches you how to write better T-SQL with examples and straightforward explanations. New in this edition is coverage of Parameter Sensitive Plan (PSP) optimization, Azure Synapse Link for real-time analytics, integration with S3-compatible object storage, and SQL Ledger tables based on blockchain. You'll learn to improve your T-SQL design in ways that provide faster performance, stronger security, and easier comprehension. The book identifies common anti-patterns in writing T-SQL and instructs you on how to change your code so you can be more confident in writing T-SQL code that is reliable and performs well.
Pro T-SQL 2022 is focused on the problems that developers are faced with and must solve in delivering successful applications. The content begins from a foundation of writing T-SQL that is clear and understandable. The book then takes you through writing SQL that performs well, is easy to manage through coding standards and version control, can be maintained and modified as business requirements change over time, scales as your business grows, and takes advantage of the full range of security features built into the SQL Server and Azure SQL database engines.

What You Will Learn

  • Choose the correct data types and database objects when designing your T-SQL
  • Write T-SQL that accesses your data efficiently and uses hardware effectively
  • Implement source control and testing methods to streamline your deployment process.
  • Design T-SQL that is flexible and can be enhanced or modified with little effort
  • Plan for long-term data management, including growth and purging of older data
  • Enhance database security through features such as encryption, data masking, row-level security, and the SQL Ledger blockchain table type



About the Author



Elizabeth Noble is a Microsoft Data Platform MVP and Director of Database Development in the metro Atlanta area. When ze was introduced to hir first database over 10 years ago, ze found the career ze wanted to pursue. Hir passion is to help others improve the quality and speed of deploying database changes through automation. When ze is not trying to automate database development, ze can be found spending time with zir dogs, painting, paddle boarding, or throwing axes.
Dimensions (Overall): 10.0 Inches (H) x 7.0 Inches (W) x 1.16 Inches (D)
Weight: 2.16 Pounds
Suggested Age: 22 Years and Up
Sub-Genre: Databases
Genre: Computers + Internet
Number of Pages: 553
Publisher: Apress
Theme: General
Format: Paperback
Author: Elizabeth Noble
Language: English
Street Date: July 1, 2023
TCIN: 1003045428
UPC: 9781484292556
Item Number (DPCI): 247-50-2336
Origin: Made in the USA or Imported
If the item details above aren’t accurate or complete, we want to know about it.

Shipping details

Estimated ship dimensions: 1.16 inches length x 7 inches width x 10 inches height
Estimated ship weight: 2.16 pounds
We regret that this item cannot be shipped to PO Boxes.
This item cannot be shipped to the following locations: American Samoa (see also separate entry under AS), Guam (see also separate entry under GU), Northern Mariana Islands, Puerto Rico (see also separate entry under PR), United States Minor Outlying Islands, Virgin Islands, U.S., APO/FPO

Return details

This item can be returned to any Target store or Target.com.
This item must be returned within 90 days of the date it was purchased in store, shipped, delivered by a Shipt shopper, or made ready for pickup.
See the return policy for complete information.

Related Categories

Get top deals, latest trends, and more.

Privacy policy

Footer

About Us

About TargetCareersNews & BlogTarget BrandsBullseye ShopSustainability & GovernancePress CenterAdvertise with UsInvestorsAffiliates & PartnersSuppliersTargetPlus

Help

Target HelpReturnsTrack OrdersRecallsContact UsFeedbackAccessibilitySecurity & FraudTeam Member Services

Stores

Find a StoreClinicPharmacyOpticalMore In-Store Services

Services

Target Circle™Target Circle™ CardTarget Circle 360™Target AppRegistrySame Day DeliveryOrder PickupDrive UpFree 2-Day ShippingShipping & DeliveryMore Services
PinterestFacebookInstagramXYoutubeTiktokTermsCA Supply ChainPrivacyCA Privacy RightsYour Privacy ChoicesInterest Based AdsHealth Privacy Policy