Beginning SQL Server 2000 DBA, Baya Pavliashvili; Michael Benkovich; Tony Bain; B
Автор: Robin Dewson; Louis Davidson; Tony Bain; Chuck Haw Название: SQL Server 2000 Stored Procedures Handbook ISBN: 1590592875 ISBN-13(EAN): 9781590592878 Издательство: Springer Рейтинг: Цена: 4611.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание:
Stored procedures are compiled T-SQL statements that reside on the database. They are the cornerstones of successful data manipulation, and data-handling operations of every complexity make use of them. This book is an in-depth guide to a key area of database development.
This book tackles real-world problems faced by developers when working with stored procedures, showing you how to solve these problems, avoid the common pitfalls, and produce faster, more robust stored procedures. Put simply: if you want to write better stored procedures, then this is the book for you.
Автор: Cuppett Название: DevOps, DBAs, and DBaaS ISBN: 1484222075 ISBN-13(EAN): 9781484222072 Издательство: Springer Рейтинг: Цена: 4890.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание:
Learn how DBAs in a DevOps environment manage data platforms and change requests to support and optimize continuous integration, delivery, testing, and deployment in the application development life cycle. On the Dev side, DBAs evaluate change requests to ensure compliance with organizational best practices and guard against degradation of database performance and the validity of dependent objects. On the Ops side, DBAs perform release and troubleshooting activities in support of the application, manage the data platform’s access and security, and monitor and maintain performance of the databases that they have designed and provisioned.DevOps, DBAs, and DBaaS investigates the complex intersection between DBA functions and DevOps processes. DevOps teams traditionally viewed DBAs as process outliers who disrupt and retard SDLC timelines. At each touch point, veteran DBA Mike Cuppett shows how DBAs can most effectively contribute to decreasing release cycle times and improving product resiliency by applying automation, orchestration, and DBaaS solutions to database administration in ways that dovetail with DevOps requirements and metrics. At a high level, Cuppett demonstrates the importance of leveling silo walls in the IT supply chain and of measuring application performance holistically by reference to satisfaction of customer requirements and end-user experience. At a technical level, he drills into topics and case studies on diagnosing and resolving problems commonly encountered by DBAs and DevOps teams when meshing database management with application delivery.
What You Will Learn
Techniques and best practices at all points of collaboration between DBAs and DevOps teams in product developmentTools for measuring DBA inputs to DevOps processes by holistic criteria of end-user experience and business requirementHow to integrate open source database technologies with DevOpsWhen to decouple application and database layers and move to DBaaS modelsHow to overcome language and mindset barriers between DBAs and DevOps teams
Who This Book Is For
DBAs who are leaning toward or already involved with DevOps and DevOps engineers, team leaders, developers and product managers who are already working with DBAs or planning to integrate DBAs in DevOps teams. The secondary readership is executives and managers in companies that practice DevOps.
Автор: Churcher Название: Beginning SQL Queries ISBN: 1484219546 ISBN-13(EAN): 9781484219546 Издательство: Springer Рейтинг: Цена: 3912.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Get started on mastering the one language binding the entire database industry. That language is SQL, and how it works is must-have knowledge for anyone involved with relational databases, and surprisingly also for anyone involved with NoSQL databases. SQL is universally used in querying and reporting on large data sets in order to generate knowledge to drive business decisions.Good knowledge of SQL is crucial to anyone working with databases, because it is with SQL that you retrieve data, manipulate data, and generate business results. Every relational database supports SQL for its expressiveness in writing queries underlying reports and business intelligence dashboards. Knowing how to write good queries is the foundation for all work done in SQL, and it is a foundation that Clare Churcher's book, Beginning SQL Queries, 2nd Edition, lays well.
What You Will Learn
Write simple queries to extract data from a single tableCombine data from many tables into one business result using set operationsTranslate natural language questions into database queries providing meaningful information to the businessAvoid errors associated with duplicated and null valuesSummarize data with amazing ease using the newly-added feature of window functionsTackle tricky queries with confidence that you are generating correct resultsInvestigate and understand the effects of indexes on the efficiency of queries
Who This Book Is For
Beginning SQL Queries, 2nd Edition is aimed at intelligent laypeople who need to extract information from a database, and at developers and other IT professionals who are new to SQL. The book is especially useful for business intelligence analysts who must ask more complex questions of their database than their GUI–based reporting software supports. Such people might be business owners wanting to target specific customers, scientists and students needing to extract subsets of their research data, or end users wanting to make the best use of databases for their clubs and societies.
Автор: Russell Sinclair Название: From Access to SQL Server ISBN: 1893115240 ISBN-13(EAN): 9781893115248 Издательство: Springer Рейтинг: Цена: 6008.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: This book covers what Access developers need to know about SQL Server, covering the two most common versions of both products: Microsoft Access 97 and 2000 and Microsoft SQL Server 6.5 and 7. Further, it includes detailed information on how to work with SQL Server outside of the Access environment and how to design efficient SQL Server databases.
Автор: Rodney Landrum; Walter Voytek Название: Pro SQL Server Reporting Services ISBN: 1590594231 ISBN-13(EAN): 9781590594230 Издательство: Springer Рейтинг: Цена: 4750.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: `SQL Server Reporting Services` is the reporting technology for Microsoft, and provides the means to design, author, and deploy business reports via web or company intranet. This book takes a thorough look at each step necessary to create secure and professional reports, in order to give the reader a skill-set to build versatile and secure reports.
Автор: Adam Machanic; Lara Rubbelke; Hugo Kornelis Название: Expert SQL Server 2005 Development ISBN: 159059729X ISBN-13(EAN): 9781590597293 Издательство: Springer Рейтинг: Цена: 6008.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Databases are software. I've based the second half of a software development career that began in 1978 on this simple idea. If you've found this book, chances are you're willing to at least entertain the possibility that databases and their attendant programmability are worthy of the same rigor and process as the rest of an application. Good for you It's a great pleasure for me to join you on this jo- ney, however briefly, via this foreword. There is a good possibility that you've grown as skeptical as I have of the conventional wisdom that treats the "back end" as an afterthought in the design and budgeting process. You're now seeking actionable insights into building or improving a SQL Server 2005 design and development process. The book you're holding is chock-full of such insights. And before turning you over to Adam, Hugo, and Lara, I'd like to offer one of my own.
Автор: Joseph Sack Название: SQL Server 2005 T-SQL Recipes ISBN: 159059570X ISBN-13(EAN): 9781590595701 Издательство: Springer Рейтинг: Цена: 7126.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: * Comprehensive T-SQL Coverage, including all SQL Server 2005 new features, from an established SQL Server expert and author. * Unique, easy-reference format - ideal for preparing for a SQL Server job interview, or for a SQL Server certification test
Автор: Chad Russell; Jon Stephens Название: Beginning MySQL Database Design and Optimization ISBN: 1590593324 ISBN-13(EAN): 9781590593325 Издательство: Springer Рейтинг: Цена: 5449.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание:
Nearly every non-trivial application requires data persistence, and for an application of any significant size and scope, persistence is typically achieved using a database. If you're building or maintaining any significant application and are using MySQL, this book is for you. For open source and other types of projects, the MySQL database is a very popular choice: it's free, fast, robust, and scalable, and it runs on all of the major platforms, allowing maximum use of available hardware resources. But it's easy to disregard MySQL's speed and other advantages if your database design is inefficient. Needlessly duplicating data, using improper types for columns, overloading a single table where multiple tables should be used, failing to leverage the calculation features of MySQL, and making multiple queries instead of an efficient single query are some of the common mistakes.
Beginning MySQL Database Design and Optimization shows you how to identify, overcome, and avoid gross inefficiencies. It demonstrates how to maximize the many data manipulation features that MySQL includes. This book explains how to include tests and branches in your queries, how to normalize your database, and how to issue concurrent queries to boost performance, among many other design and optimization topics. You'll also learn about some features new to MySQL 4.1 and 5.0 like subqueries, stored procedures, and views, all of which will help you build even more efficient applications.
Автор: Cristian Darie; Mihai Bucica; Emilian Balanescu Название: Beginning PHP and PostgreSQL E-Commerce ISBN: 159059648X ISBN-13(EAN): 9781590596487 Издательство: Springer Рейтинг: Цена: 6008.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: "Beginning PHP and PostgreSql E-Commerce: From Novice to Professional" deals with computers/software.
Автор: Beard Название: Beginning SQL Server R Services ISBN: 1484222970 ISBN-13(EAN): 9781484222973 Издательство: Springer Рейтинг: Цена: 4191.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание:
Learn how to develop powerful data analytics applications quickly for SQL Server database administrators and developers. Organizations will be able to sift data and derive the business intelligence needed to drive business decisions and profit. The addition of R to SQL Server 2016 places a powerful analytical processor into an environment most developers are already comfortable with – Visual Studio. This book walks even the newest of users through the creation process of a powerful R-language tool set for use in analyzing and reporting on your data.As a SQL Server database administrator or developer, it is sometimes difficult to stay on the bleeding edge of technology. Microsoft’s addition of R to SQL Server 2016 is sure to be a game-changer, and the language will certainly become an integral part of future releases. R is in fact widely used today in statistical and related applications, and its use is only growing. Beginning SQL Server R Services helps you jump on board this important trend by providing good examples with detailed explanations of the WHY and not just the HOW.Walks you through setup and installation of SQL Server R Services.Explains the basics of working with R Tools for Visual Studio.Provides a road map to successfully creating custom R code.
What You Will Learn
Discover R’s role in the SQL Server 2016 hierarchy.Manage the components needed to run SQL Server R Services code.Run R-language analytics and queries inside the database.Create analytic solutions that run across multiple datasets.Gain in-depth knowledge of the R language itself.Implement custom SQL Server R Services solutions.
Who This Book Is For
Any level of database administrator or developer, but specifically it's for those developers with the need to develop powerful data analytics applications quickly. Seasoned R developers will appreciate the book for its robust learning pattern, using visual aids in combination with properties explanations and scenarios. Beginning SQL Server R Services is the perfect “new hire” gift for new database developers in any organization.
Автор: Allan Hirt Название: Pro SQL Server 2005 High Availability ISBN: 159059780X ISBN-13(EAN): 9781590597804 Издательство: Springer Рейтинг: Цена: 11358.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: This book comprehensively covers the technology, the people, the process, and the real-world best practices for planning, deploying, administering, and maintaining highly available SQL Server 2005 instances.
ООО "Логосфера " Тел:+7(495) 980-12-10 www.logobook.ru
