Scott Shaw – författare
120 kr
Skickas
172 kr
Skickas inom 3-6 vardagar
253 kr
Skickas inom 3-6 vardagar
559 kr
Skickas inom 10-15 vardagar
734 kr
Läs direkt efter köp
Beginning T-SQL 2012 begins with an introduction to databases, normalization, and to SQL Server Management Studio. Each subsequent chapter teaches an aspect of T-SQL, building on the skills learned in previous chapters. Exercises in each chapter give readers an opportunity for the hands-on practice that leads to true learning and distinguishes the competent professional.
Imparts best practices for writing T-SQL Helps you avoid common errors Shows how to write scalable code for good performance
559 kr
Skickas inom 10-15 vardagar
734 kr
Läs direkt efter köp
Transact–SQL is the language developers and DBAs use to interact with SQL Server. It’s used for everything from querying data, to writing stored procedures, to managing the database. New features in T-SQL 2012 include full support for window functions, stored sequences, the ability to throw errors, data paging, and more. All these important new features are covered in this book. Developers and DBAs alike can benefit from the expressive power of Transact-SQL, and Pro T-SQL 2012 Programmer''s Guide provides the gateway to success in applying this increasingly important database language to everyday business and technical tasks.
96 kr
Läs direkt efter köp
896 kr
Läs direkt efter köp
Beginning T-SQL is a performance-oriented introduction to the T-SQL language underlying the Microsoft SQL Server database engine. T-SQL is essential in writing SQL statements to get data into and out of a database. T-SQL is the foundation for business logic embedded in the database in the form of stored procedures and functions. Beginning T-SQL starts you on the path to mastering T-SQL, with an emphasis on best-practices and sound coding techniques leading to excellent performance. This new edition is updated to cover the essential features of T-SQL found in SQL Server 2014, 2012, and 2008.
Beginning T-SQL begins with an introduction to databases, normalization, and to SQL Server Management Studio. Attention is given to Azure SQL Database and how to connect to remote databases in the cloud. Each subsequent chapter teaches an aspect of T-SQL, building on the skills learned in previous chapters. Exercises in most chapters provide an opportunity forthe hands-on practice that leads to true learning and distinguishes the competent professional. Important techniques such as windowing functions are covered to help write fast executing queries that solve real business problems.
A stand-out feature in this book is that most chapters end with a "Thinking About Performance" section. These sections cover aspects of query performance relative to the content just presented. They''ll help you avoid beginner mistakes by knowing about and thinking about performance from Day 1.
Imparts best practices for writing T-SQLHelps you avoid common errorsShows how to write scalable code for good performance1 459 kr
Läs direkt efter köp
Pro T–SQL Programmer’s Guide is your guide to making the best use of the powerful, Transact-SQL programming language that is built into Microsoft SQL Server''s database engine. This edition is updated to cover the new, in-memory features that are part of SQL Server 2014. Discussing new and existing features, the book takes you on an expert guided tour of Transact–SQL functionality. Fully functioning examples and downloadable source code bring technically accurate and engaging treatment of Transact–SQL into your own hands. Step–by–step explanations ensure clarity, and an advocacy of best–practices will steer you down the road to success.
Transact–SQL is the language developers and DBAs use to interact with SQL Server. It’s used for everything from querying data, to writing stored procedures, to managing the database. Support for in-memory stored procedures running queries against in-memory tables is new in the language and gets coverage in this edition. Also covered are must-know features such as window functions and data paging that help in writing fast-performing database queries. Developers and DBAs alike can benefit from the expressive power of T-SQL, and Pro T-SQL Programmer''s Guide is your roadmap to success in applying this increasingly important database language to everyday business and technical tasks.
Covers the newly-introduced, in-memory database featuresShares the best practices used by experienced professionalsGoes deeply into the subject matter − an advanced book for the serious reader1 112 kr
Skickas inom 10-15 vardagar
896 kr
Läs direkt efter köp
Dive into the world of SQL on Hadoop and get the most out of your Hive data warehouses. This book is your go-to resource for using Hive: authors Scott Shaw, Ankur Gupta, David Kjerrumgaard, and Andreas Francois Vermeulen take you through learning HiveQL, the SQL-like language specific to Hive, to analyze, export, and massage the data stored across your Hadoop environment. From deploying Hive on your hardware or virtual machine and setting up its initial configuration to learning how Hive interacts with Hadoop, MapReduce, Tez and other big data technologies, Practical Hive gives you a detailed treatment of the software.
In addition, this book discusses the value of open source software, Hive performance tuning, and how to leverage semi-structured and unstructured data.
What You Will Learn
Install and configure Hive for new and existing datasetsPerform DDL operationsExecute efficient DML operationsUse tables, partitions, buckets, and user-defined functionsDiscover performance tuning tips and Hive best practicesWho This Book Is For
Developers, companies, and professionals who deal with large amounts of data and could use software that can efficiently manage large volumes of input. It is assumed that readers have the ability to work with SQL.
670 kr
Skickas inom 10-15 vardagar
181 kr
Skickas inom 5-8 vardagar
113 kr
Läs direkt efter köp
319 kr
Skickas inom 3-6 vardagar
314 kr
Skickas inom 3-6 vardagar
161 kr
Skickas inom 5-8 vardagar
294 kr
Skickas inom 3-6 vardagar
306 kr
Skickas inom 5-8 vardagar
325 kr
Skickas inom 3-6 vardagar
249 kr
Skickas inom 5-8 vardagar
325 kr
Skickas inom 3-6 vardagar
288 kr
Skickas inom 3-6 vardagar
313 kr
Skickas inom 3-6 vardagar
225 kr
Skickas inom 5-8 vardagar
327 kr
Skickas inom 3-6 vardagar
324 kr
Skickas inom 3-6 vardagar
283 kr
Skickas inom 5-8 vardagar
230 kr
Skickas inom 5-8 vardagar