- Table View
- List View
Expert Oracle Application Express
by John Scott Doug Gault Nick Buytaert Karen Cannell Martin D'Souza Dimitri Gielis Roel Hartman Denes Kubicek Raj Mattamal Dan Mcghan Francis Mignault Tom Petrus Jorge Rimblas Christoph RuepprichExpert Oracle Application Express, 2nd Edition is newly updated for APEX 5. 0 and brings deep insight from some of the best APEX practitioners in the field today. You'll learn about important features in APEX 5. 0, and how those can be applied to make your development work easier and with greater impact on your business. Oracle Application Express (APEX) is an entirely web-based development framework that is built into every edition of Oracle Database. The framework rests upon Oracle's powerful PL/SQL language, enabling power users and developers to rapidly develop applications that easily scale to hundreds, even thousands of concurrent users. APEX has seen meteoric growth and is becoming the tool of choice for ad-hoc application development in the enterprise. The many authors of Expert Oracle Application Express, 2nd Edition build their careers around APEX. They know what it takes to make the product sing--developing secure applications that can be deployed globally to users inside and outside a large enterprise. The authors come together in this book to share some of their deepest and most powerful insights into solving the difficult problems surrounding globalization, configuration and lifecycle management, and more. New in this edition for APEX 5. 0 is coverage of Oracle REST Data Services, map integration, jQuery with APEX, and the new Page Designer. You'll learn about debugging and performance, deep secrets to customizing your application user interface, how to secure applications from intrusion, and about deploying globally in multiple languages. Expert Oracle Application Express, 2nd Edition is truly a book that will move you and your skillset a big step towards the apex of Application Express development. Contains all-new content on Oracle REST Data Services, jQuery in APEX, and map integration Addresses globalization and other concerns of enterprise-level development Shows how to customize APEX for your own application needs What you'll learn Build applications around Oracle REST Data Services Analyze data geographically using the built-in, map integration Deploy applications globally while respecting linguistic and cultural differences Customize applications by exploiting APEX's roots in PL/SQL Reduce the stress of managing application lifecycle and configuration Deploy new functionality through custom plug-ins Who this book is for Expert Oracle Application Express, 2nd Edition is aimed at APEX developers who seek the deepest possible knowledge of Oracle Application Express and how to develop with it. Readers should know and be proficient with APEX, and be prepared to expend some mental energy in absorbing the high-end material in this book. Table of Contents 1. APEX Builder, Denes Kubicek 2. Oracle REST Data Services, John Scott 3. Oracle APEX 5. 0 Charts Inside Out, Dimitri Gielis 4. Tabular Forms, Denes Kubicek 5. Team Development, Roel Hartman 6. Globalization, Francis Mignault 7. Debugging, Doug Gault 8. Dynamic Actions, Martin Giffy D'Souza 9. Lifecycle Management, Nick Buytaert 10. Plug-Ins, Dan McGhan 11. jQuery with APEX, Tom Petrus 12. Map Integration, Christoph Ruepprich 13. Themes and Templates, Jorge Rimblas 14. Report Printing, Karen Cannell
Expert Oracle Database Architecture
by Darl Kuhn Thomas KyteNow in its third edition, this best-selling book continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom Kyte and Darl Kuhn share a simple philosophy: "you can treat Oracle as a black box and just stick data into it, or you can understand how it works and exploit it as a powerful computing environment. " If you choose the latter, then you'll find that there are few information management problems that you cannot solve quickly and elegantly. This fully revised third edition covers the developments up to Oracle Database 12c. Significant new content is included surrounding Oracle's new cloud feature set, and especially the use of pluggable databases. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it. Don't treat Oracle Database as a black-box. Get this book. Get under the hood. Turbo-charge your career. Revised to cover Oracle Database 12c Proof-by-example approach: Let the evidence be your guide Dives deeply into Oracle Database's most powerful features What you'll learn Develop an evidence-based approach to problem solving Manage transactions in highly concurrent environments Speed access to data through table and index design Manage files and memory structures for performance and reliability Scale up through partitioning and parallel processing Load and unload data to interface with external systems Who this book is for Expert Oracle Database Architecture is aimed at Oracle Database administrators, at PL/SQL and Java developers writing code to be deployed inside the database, and at developers of external applications who use Oracle Database as a data store. It is the go-to book for those wishing to create efficient and scalable applications. Table of Contents Developing Successful Oracle Applications Architecture Overview Files Memory Structures Oracle Processes Locking and Latching Concurrency and Multi-versioning Transactions Redo and Undo Database Tables Indexes Datatypes Partitioning Parallel Execution Data Loading and Unloading
Expert Oracle Database Architecture: Techniques and Solutions for High Performance and Productivity
by Darl Kuhn Thomas KyteNow in its fourth edition and covering Oracle Database 21c, this best-selling book continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom Kyte and Darl Kuhn share a simple philosophy: "you can treat Oracle as a black box and just stick data into it, or you can understand how it works and exploit it as a powerful computing environment." If you choose the latter, then you’ll find that there are few information management problems that you cannot solve quickly and elegantly.This fully revised fourth edition covers the developments and new features up to Oracle Database 21c. Up-to-date features are covered for tables, indexes, data types, sequences, partitioning, data loading, temporary tables, and more. All the examples are demonstrated using modern techniques and are executed in container and pluggable databases. The book’s proof-by-example approach encourages you to let evidence be your guide. Try something. See the result. Understand why the result is what it is. Apply your newfound knowledge with confidence. The book covers features by explaining how each one works, how to implement software using it, and the common pitfalls associated with it. Don’t treat Oracle Database as a black box. Get this book. Dive deeply into Oracle Database’s most powerful features that many do not invest the time to learn about. Set yourself apart from your competition and turbo-charge your career.What You Will LearnIdentify and effectively resolve application performance issues and bottlenecksArchitect systems to leverage the full power and feature set of Oracle’s database engineConfigure a database to maximize the use of memory structures and background processesUnderstand internal locking and latching technology and how it impacts your systemProactively recommend best practices around performance for table and index structuresTake advantage of advanced features such as table partitioning and parallel executionWho This Book Is ForOracle developers and Oracle DBAs. If you’re a developer and want a stronger understanding of Oracle features and architecture that will enable your applications to scale regardless of the workload, this book is for you. If you’re a DBA and want to intelligently work with developers to design applications that effectively leverage Oracle technology, then look no further.
Expert Oracle Enterprise Manager 12c
by Kellyn Pot'Vin Bobby Curtis Pete Sharman Alex Gorbachev Anand Akela Gokhan Atil Leighton Nelson Niall LitchfieldEnterprise Manager 12c (EM12c), Oracle's newest and fully-integrated enterprise management product, now provides a complete cloud lifecycle management solution and enterprise environment management interface. Expert Oracle Enterprise Manager 12c opens up the secrets of this incredible management tool, saving you time while enhancing your visibility as someone management can rely upon to deliver reliable database service in today's increasingly chaotic and change-driven IT environment. Expert Oracle Enterprise Manager 12c covers all the topics you demand and need to function effectively, from basic monitoring and configuration to advanced metric extensions and plugins. Real-life scenarios and demonstrations place you in the comfort zone of using the EM12c console, and the experienced author team provides deep understanding of the inner workings of this new Enterprise Manager. Database administrators and system administrators are expected to offer increasing levels of service for 24X7 systems and newer cloud environments. Em12c offers robust, end-to-end intelligent management of the complete environment. It includes direct, real-time integration with Oracle's online knowledgebase. Expert Oracle Enterprise Manager 12c helps you master this important tool and manage any challenge that comes your way. Provides example solutions to everyday problems through EM12c features. Explains the changes in EM12c, included trusted extensions. Focuses on advanced aspects of the EM12c interface.
Expert Oracle Exadata
by Kerry Osborne Martin Bach Karl Arao Andy Colvin Frits Hoogland Randy Johnson Tanel PoderExpert Oracle Exadata, 2nd Edition opens up the internals of Oracle's Exadata platform so that you can fully benefit from the most performant and scalable database hardware appliance capable of running Oracle Database. This edition is fully-updated to cover Exadata 5-2 and Oracle Database 12c. If you're new to Exadata, you'll soon learn that it embodies a change in how you think about and manage relational databases. A key part of that change lies in the concept of offloading SQL processing to the storage layer. In addition there is Oracle's engineering effort in creating a powerful platform for both consolidation and transaction processing. The resulting value proposition in the form of Exadata has truly been a game-changer. Expert Oracle Exadata, 2nd Edition provides a look at the internals and how the combination of hardware and software that comprise Exadata actually work. Authors include Martin Bach, Andy Colvin, and Frits Hoogland, with contributions from Karl Arao, and built on the foundation laid by Kerry Osborne, Randy Johnson, and Tanel Poder in the first edition. They share their real-world experience gained through a great many Exadata implementations, possibly more than any other group of experts today. Always their goal is toward helping you advance your career through success with Exadata in your own environment. This book is intended for readers who want to understand what makes the platform tick and for whom--"how" it does what it is does is as important as what it does. By being exposed to the features that are unique to Exadata, you will gain an understanding of the mechanics that will allow you to fully benefit from the advantages that the platform provides. This book changes how you think about managing SQL performance and processing. It provides a roadmap to successful Exadata implementation. And it removes the "black box" mystique. You'll learn how Exadata actually works and be better able to manage your Exadata engineered systems in support of your business. This book: Changes the way you think about managing SQL performance and processing Provides a roadmap to successful Exadata implementation Removes the "black box" mystique, showing how Exadata actually works What you'll learn Configure Exadata from the ground up Optimize for mixed OLTP/DW workloads Migrate large data sets from existing systems Connect Exadata to external systems Support consolidation strategies using the Resource Manager Configure high-availability features of Exadata, including Real Application Clusters (RAC) and automatic storage management (ASM) Apply tuning strategies utilizing the unique features of Exadata Who this book is for Expert Oracle Exadata, 2nd Edition is for database administrators and developers who want to understand what makes Exadata unique so that they can take advantage of all the platform has to offer. It is also for anyone who needs to plan and execute migrations of systems to the Exadata platform. Finally, the book will be invaluable to those who support and maintain such systems. Table of Contents What Is Exadata? Offloading / Smart Scan Hybrid Columnar Compression Storage Indexes Exadata Smart Flash Cache Exadata Parallel Operations Resource Management Configuring Exadata Recovering Exadata Exadata Wait Events Understanding Exadata Performance Metrics Monitoring Exadata Performance Migrating to Exadata Storage Layout Compute Node Layout Unlearning Some Things We Thought We Knew Patching Appendix A: CELLCL and DCLI Appendix B: Online Exadata Resources Appendix C: Diagnostic Scripts Appendix D: Exachk
Expert Oracle Indexing and Access Paths
by Darl Kuhn Bill Padfield Sam R AlapatiSpeed up the execution of important database queries by making good choices about which indexes to create. Choose correct index types for different scenarios. Avoid indexing pitfalls that can actually have indexes hurting performance rather than helping. Maintain indexes so as to provide consistent and predictable query response over the lifetime of an application. Expert Oracle Indexing and Access Paths is about the one database structure at the heart of almost all performance concerns: the index. Database system performance is one of the top concerns in information technology today. Administrators struggle to keep up with the explosion of access and activity driven by the proliferation of computing into everything from phones to tablets to PCs in our increasingly connected world. At the heart of any good-performing database lies a sound indexing strategy that makes appropriate use of indexing, and especially of the vendor-specific indexing features on offer. Few databases fully exploit the wealth of data access mechanisms provided by Oracle. Expert Oracle Indexing and Access Paths helps by bringing together information on indexing and how to use it into one blissfully short volume that you can read quickly and have at your fingertips for reference. Learn the different types of indexes available and when each is best applied. Recognize when queries aren't using indexes as you intend. Manage your indexing for maximum performance. Confidently use the In Memory column store feature as an alternate access path to improve performance. Let Expert Indexing in Oracle Database 12c be your guide to deep mastery of the most fundamental performance optimization structure in Oracle Database. Explains how indexes help performance, and sometimes hinder it too Demystifies the various index choices so that you can chose rightly Describes the database administration chores associated with indexes Demonstrates the use of the In Memory column store as an alternate access path to the data What You Will Learn Create an overall indexing strategy to guide your decisions Choose the correct indexing mechanisms for your applications Manage and maintain indices to avoid degradation and preserve efficiency Take better advantage of underused index types such as index-organized tables Choose the appropriate columns to index, with confidence Blend partitioning and materialized views into your indexing strategy Who This Book Is For All levels of database administrators and application developers who are struggling with the database performance and scalability challenge. Any database administrator involved with indexing, which is any database administrator period, will appreciate the wealth of advice packed into this gem of a book.
Expert Oracle RAC 12c
by Riyaj Shamsudeen Syed Jaffar Hussain Tariq Farooq Kai YuExpert Oracle RAC 12c is a hands-on book helping you understand and implement Oracle Real Application Clusters (RAC), and to reduce the total-cost-of-ownership (TCO) of a RAC database. As a seasoned professional, you are probably aware of the importance of understanding the technical details behind the RAC stack. This book provides deep understanding of RAC concepts and implementation details that you can apply toward your day-to-day operational practices. You'll be guided in troubleshooting and avoiding trouble in your installation. Successful RAC operation hinges upon a fast-performing network interconnect, and this book dedicates a chapter solely to that very important and easily overlooked topic. All four authors are experienced RAC engineers with a wealth of hard-won experience encountering and surmounting the challenges of running a RAC environment that delivers on its promise. In Expert Oracle RAC 12c they provide you a framework in which to avoid repeating their hard-won lessons. Their goal is for you to manage your own RAC environment with ease and expertise. Provides a deep conceptual understanding of RAC Provides best practices to implement RAC properly and match application workload Enables readers to troubleshoot RAC with ease What you'll learn Know when to apply RAC, and when not to Design applications to take advantage of RAC Troubleshoot and solve clusterware problems Manage database backup and recovery in RAC Stay on top of locking issues and deadlock detection Harness the performance from parallel processing in RAC Support your RAC environment with a healthy network interconnect Who this book is for Expert Oracle RAC 12c is for experienced Oracle Database Administrators (DBAs) who are ready to take the next step in their career by expanding their skill set to include building and managing Oracle Real Application Clusters (RAC). DBAs and architects who are in the process of implementing RAC can immensely benefit from this book. It's an excellent choice for DBAs to learn RAC conceptually, understand best practices, and become experts in troubleshooting RAC problems. Table of Contents Overview of Oracle RAC Clusterware Management and Troubleshooting RAC Operational Practices RAC New Features Storage and ASM Practices Application Design Issues Managing and Optimizing a Complex RAC Environment Backup and Recovery in RAC Network Practices in RAC RAC Database Optimization Locks and Deadlocks Parallel Query in RAC Clusterware and Database Upgrades Oracle RAC One Node
Expert Oracle RAC Performance Diagnostics and Tuning
by Murali VallathExpert Oracle RAC Performance Diagnostics and Tuning provides comprehensive coverage of the features, technology and principles for testing and tuning RAC databases. The book takes a deep look at optimizing RAC databases by following a methodical approach based on scientific analysis rather than using a speculative approach, twisting and turning knobs and gambling on the system. The book starts with the basic concepts of tuning methodology, capacity planning, and architecture. Author Murali Vallath then dissects the various tiers of the testing implementation, including the operating system, the network, the application, the storage, the instance, the database, and the grid infrastructure. He also introduces tools for performance optimization and thoroughly covers each aspect of the tuning process, using many real-world examples, analyses, and solutions from the field that provide you with a solid, practical, and replicable approach to tuning a RAC environment. The book concludes with troubleshooting guidance and quick reference of all the scripts used in the book. Expert Oracle RAC Performance Diagnostics and Tuning covers scenarios and details never discussed before in any other performance tuning books. If you have a RAC database, this book is a requirement. Get your copy today. Takes you through optimizing the various tiers of the RAC environment. Provides real life case studies, analysis and solutions from the field. Maps a methodical approach to testing, tuning and diagnosing the cluster What you'll learn Dissect the eight stage pre-implementation testing process across all tiers of the RAC cluster Optimize your RAC cluster for availability and scalability Diagnose your cluster to get the root of any performance problem Establish a replicable methodology for testing, tuning, and diagnostics Walk through real-world examples and solutions. Learn how to be proactive to prevent common performance issues Discover an exhaustive list of tools to help optimize your RAC environment Who this book is for Expert Oracle RAC Performance Diagnostics and Tuning is for all those customers implementing RAC systems into a production environment without undergoing a systematic methodology for testing, tuning and problem solving. Table of Contents 1. Methodology 2. Capacity Planning and Architecture 3. Testing for Availability 4. Testing for Scalability 5. Real Application Testing 6. Tools and Utilities 7. SQL Tuning 8. Parallel Query Tuning 9. Tuning the Database 10. Tuning Recovery 11. Tuning Oracle Net 12. Tuning Storage Subsystem 13. Tuning Global Cache 14. Tuning the Cluster Interconnect 15. Optimization of Distributed Workload 16. Tuning the Oracle Clusterware 17. Enqueues, Waits and Latches 18. Problem Diagnostics A. The SQL Scripts Used in This Book Bibliography
Expert PHP 5 Tools
by Dirk MerkelEach chapter focuses on one topic, such as version control or debugging. After initially discussing essential concepts, the author takes an in-depth look at one or more tools relevant to the topic. Sample projects and plenty of well-documented code are used to work through practical application of the concepts. This book has been written for professional developers new to PHP and experienced PHP developers who want to take their skills to the next level by learning enterprise-level tools and techniques.
Expert PHP and MySQL
by Andrew Curioso Ronald Bradford Patrick GalbraithBest practices and expert techniques for even the most demanding MySQL-driven PHP applications PHP is the world's most popular, general-purpose, open-source scripting language and MySQL is the world's most popular open-source database. This expert-level book begins with a brief overview of the two technologies and quickly moves on to coverage of advanced programming techniques, as well as the exciting new features of the PHP 5. 3 release. Written by three of PHP and MySQL experts and veteran authors, this resource focuses on best practices and expert techniques that can be applied to the most difficult MySQL-driven PHP applications. The authors share design patterns and tools that they themselves have tested in order to save you valuable time usually spent on figuring things out via trial and error. Reveals best practices and advanced techniques for handling challenges you may face with MySQL-driven PHP apps Reviews practical data reporting techniques for separating business logic from presentation Explains how to obtain improved performance and flexibility through caching, multi-tasking, PHP extensions, and MySQL user defined functions Discusses security, optimization, and debugging Shares author-tested design patterns and tools to save you time and effort Packed with helpful examples and indispensable advice, this book shares tips and tricks that you can immediately apply to your projects. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Expert PHP and MySQL
by Marc RochkindExpert PHP and MySQL takes you beyond learning syntax to showing you how to apply proven software development methods to building commerce-grade PHP and MySQL projects that will stand the test of time and reliably deliver on customer needs. Developers of real-world applications face numerous problems that seem trivial on the surface, but really do take some skill to get right. Error handling is about more than just the mechanics in the PHP syntax, but also about handling MySQL errors, logging those errors, and about hiding information about application internals that error messages sometimes can expose. Meet these challenges and more head-on! Author Marc Rochkind shows how to begin a project right, with a clear contract and set of written requirements. You'll learn about project organization, setting up a solid development environment, connecting with client personnel. Database design is essential, and Expert PHP and MySQL has you covered with guidance on creating a sound model and database, and on pushing functionality into the database as appropriate; not everything should be done in PHP. Error handling is covered at both the PHP and MySQL levels. Application structure is covered. Guidance is provided on reporting. And finally there is conversion. In Expert PHP and MySQL you'll explore the following: The popular and widely used combination of PHP and MySQL Commercial-grade application of language and database features Human factors such as planning and organization Organizing a project to meet requirements and satisfy the customer Structuring an application for efficient development and future modification Coding PHP for productivity, reliability, security Generating online, downloadable, and printed reports Converting existing data to the new application What you'll learn Organize a project to meet requirements and satisfy the customer. Structure an application for efficient development and future modification. Design a database to model the business and support the application. Code PHP for productivity, reliability, security. Generate online, downloadable, and printed reports. Convert existing data to the new application. Who this book is for Expert PHP and MySQL is aimed at programmers competent in PHP and MySQL. Readers should know the mechanics of the language and the database, and have a desire to learn to build commercial systems that will stand the test of time and reliably deliver on customer needs. Table of Contents Project Organization Requirements Platforms and Tools The Database Application Structure Security, Forms, and Error Handling Reports and Other Outputs Data Conversion
Expert Performance Indexing in Azure SQL and SQL Server 2022: Toward Faster Results and Lower Maintenance Both on Premises and in the Cloud
by Edward Pollack Jason StrateTake a deep dive into perhaps the single most important facet of query performance—indexes—and how to best use them. Newly updated for SQL Server 2022 and Azure SQL, this fourth edition includes new guidance and features related to columnstore indexes, improved and consolidated content on Query Store, deeper content around Intelligent Query Processing, and other updates to help you optimize query execution and make performance improvements to even the most challenging workloads. The book begins with explanations of the types of indexes and how they are stored in a database. Moving further into the book, you will learn how statistics are critical for optimal index usage and how the Index Advisor can assist in reviewing and optimizing index health. This book helps you build a clear understanding of how indexes work, how to implement and use them, and the many options available to tame even the most large and complex workloads.What You Will LearnProperly index row store, columnstore, and memory-optimized tablesMake use of Intelligent Query Processing for faster query resultsReview statistics to understand indexing choices made by the optimizerApply indexing strategies such as covering indexes, included columns, and index intersectionsRecognize and remove unnecessary indexesDesign effective indexes for full-text, spatial, and XML data typesWho This Book Is ForAzure SQL and SQL Server administrators and developers who are ready to improve the performance of their database environment by thoughtfully building indexes to speed up queries that matter the most and make a difference to the business
Expert Performance Indexing in SQL Server
by Jason Strate Grant FritcheyThis book is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. You'll better understand what indexes are doing in the database and what can be done to mitigate and improve their effect on performance. The final destination is a guided tour through a number of real life scenarios showing approaches you can take to investigate, mitigate, and improve the performance of your database. Defines the types of indexes and their implementation options Provides use cases and common patterns in applying indexing Describes and explain the index metadata and statistics Provides a framework of strategies and approaches for indexing databases What you'll learn Properly index in-memory OLTP tables Recognize and remove unnecessary indexes Review statistics to understand indexing choices made by the optimizer Properly apply strategies such as covering indexes, included columns, index intersections, and more Write queries to make good use of the indexes already in place Design effective indexes for full-text, spatial, and XML data types Manage the big picture: Encompassing all indexes in a database, and all database instances on a server Who this book is for Expert Performance Indexing in SQL Server is intended for database administrators and developers who are ready to lift the performance of their environment by thoughtfully building indexes to speed up the queries that matter the most and make a difference to the business. Table of Contents Introduction 1. Index Fundamentals 2. Index Storage Fundamentals 3. Index Metadata and Statistics 4. XML Indexes 5. Spatial Indexes 6. Full-text Indexes and Semantic Search 7. Indexing Memory-Optimized Tables 8. Index Myths and Best Practices 9. Index Maintenance 10. Indexing Tools 11. Indexing Strategies 12. Query Strategies 13. Monitoring Your Indexes 14. Index Analysis 15. Indexing Methodology
Expert Performance Indexing in SQL Server 2019: Toward Faster Results and Lower Maintenance
by Jason StrateTake a deep dive into perhaps the single most important facet of good performance: indexes, and how to best use them. Recent updates to SQL Server have made it possible to create indexes in situations that in the past would have prevented their use.Other improvements covered in this book include new dynamic management views, the ability to pause and resume index maintenance, and the ability to more easily recover from failures during index creation and maintenance operations. This new edition also brings new content around the indexing of columnstore and in-memory tables, showing how these new types of tables and the queries that execute against them can also benefit from good indexing practices. The book begins with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. You will better understand what indexes are doing in the database and what can be done to mitigate and improve their effect on performance. You will get a look at the Index Advisor now available in Azure SQL Database, and learn how to review and maintain the health of your indexes. The final chapters present a guided tour through a number of scenarios showing approaches you can take to investigate, mitigate, and improve the performance of your database.What You Will LearnProperly index row store, columnstore, and in-memory tablesReview statistics to understand indexing choices made by the optimizerApply indexing strategies such as covering indexes, included columns, and index intersectionsRecognize and remove unnecessary indexesDesign effective indexes for full-text, spatial, and XML data typesManage the big picture: Encompass all indexes in a database, and all database instances on a serverWho This Book Is ForDatabase administrators and developers who are ready to lift the performance of their database environment by thoughtfully building indexes to speed up queries that matter the most and make a difference to the business
Expert Python Programming
by Tarek ZiadeThis book is an authoritative exploration of Python best practices and applications of agile methodologies to Python, illustrated with practical, real-world examples. This book is for Python developers who are already building applications, but want to build better ones by applying best practices and new development techniques to their projects. The reader is expected to have a sound background in Python programming.
Expert Python Programming - Second Edition
by Tarek Ziade Michal JaworskiBecome an ace Python programmer by learning best coding practices and advance-level concepts with Python 3.5 About This Book * Based on the latest stable version of Python (version 3.5) * Creating well manageable code that will run in various environments with different sets of dependencies * Packed with advanced concepts and best practices to write efficient Python code Who This Book Is For The book would appeal to web developers and Python programmers who want to start using version 3.5 and write code efficiently. Basic knowledge of Python programming is expected. What You Will Learn * Conventions and best practices that are widely adopted in the python community * Package python code effectively for community and production use * Easy and lightweight ways to automate code deployment on remote systems * Improve your code's quality, reliability, and performance * Write concurrent code in python * Extend python with code written in different languages In Detail Python is a dynamic programming language, used in a wide range of domains by programmers who find it simple, yet powerful. Even if you find writing Python code easy, writing code that is efficient and easy to maintain and reuse is a challenge. The focus of the book is to familiarize you with common conventions, best practices, useful tools and standards used by python professionals on a daily basis when working with code. You will begin with knowing new features in Python 3.5 and quick tricks for improving productivity. Next, you will learn advanced and useful python syntax elements brought to this new version. Using advanced object-oriented concepts and mechanisms available in python, you will learn different approaches to implement metaprogramming. You will learn to choose good names, write packages, and create standalone executables easily. You will also be using some powerful tools such as buildout and vitualenv to release and deploy the code on remote servers for production use. Moving on, you will learn to effectively create Python extensions with C, C++, cython, and pyrex. The important factors while writing code such as code management tools, writing clear documentation, and test-driven development are also covered. You will now dive deeper to make your code efficient with general rules of optimization, strategies for finding bottlenecks, and selected tools for application optimization. By the end of the book, you will be an expert in writing efficient and maintainable code. Style and approach An easy-to-follow guide that covers industry followed best practices in Python programming
Expert Python Programming,: Become a master in Python by learning coding best practices and advanced programming concepts in Python 3.7, 3rd Edition
by Michał Jaworski Tarek ZiadéRefine your Python programming skills and build professional grade applications with this comprehensive guideKey FeaturesCreate manageable code that can run in various environments with different sets of dependenciesImplement effective Python data structures and algorithms to write optimized codeDiscover the exciting new features of Python 3.7Book DescriptionPython is a dynamic programming language that's used in a wide range of domains thanks to its simple yet powerful nature. Although writing Python code is easy, making it readable, reusable, and easy to maintain is challenging. Complete with best practices, useful tools, and standards implemented by professional Python developers, the third edition of Expert Python Programming will help you overcome this challenge.The book will start by taking you through the new features in Python 3.7. You'll then learn the advanced components of Python syntax, in addition to understanding how to apply concepts of various programming paradigms, including object-oriented programming, functional programming, and event-driven programming. This book will also guide you through learning the best naming practices, writing your own distributable Python packages, and getting up to speed with automated ways of deploying your software on remote servers. You’ll discover how to create useful Python extensions with C, C++, Cython, and CFFI. Furthermore, studying about code management tools, writing clear documentation, and exploring test-driven development will help you write clean code.By the end of the book, you will have become an expert in writing efficient and maintainable Python code.What you will learnExplore modern ways of setting up repeatable and consistent development environmentsPackage Python code effectively for community and production useLearn modern syntax elements of Python programming such as f-strings, enums, and lambda functionsDemystify metaprogramming in Python with metaclassesWrite concurrent code in PythonExtend Python with code written in different languagesIntegrate Python with code written in different languagesWho this book is forThis book will appeal to you if you’re a programmer looking to take your Python knowledge to the next level by writing efficient code and learning the latest features of version 3.7 and above.
Expert Python Programming: Master Python by learning the best coding practices and advanced programming concepts, 4th Edition
by Tarek Ziade Michal JaworskiAttain a deep understanding of building, maintaining, packaging, and shipping robust Python applicationsKey FeaturesDiscover the new features of Python, such as dictionary merge, the zoneinfo module, and structural pattern matchingCreate manageable code to run in various environments with different sets of dependenciesImplement effective Python data structures and algorithms to write, test, and optimize codeBook DescriptionPython is used in a wide range of domains owing to its simple yet powerful nature. Although writing Python code is easy, making it readable, reusable, and easy to maintain can be challenging. Complete with best practices, useful tools, and standards implemented by professional Python developers, this fourth edition will help you in not only overcoming such challenges but also learning Python's latest features and advanced concepts. The book begins with a warm-up, where you will catch-up with the latest Python improvements, syntax elements, and interesting tools to boost your development efficiency. Further, the initial few chapters should allow experienced programmers coming from different languages to safely land in the Python ecosystem. As you progress, you will explore common software design patterns and various programming methodologies, such as event-driven programming, concurrency, and metaprogramming. You will also go through complex code examples and try to solve meaningful problems by bridging Python with C and C++, writing extensions that benefit from the strengths of multiple languages. Finally, you will understand the complete lifetime of any application after it goes live. By the end of the book, you should be proficient in writing efficient and maintainable Python code.What you will learnExplore modern ways of setting up repeatable and consistent Python development environmentsEffectively package Python code for community and production useLearn about modern syntax elements of Python programming, such as f-strings, dataclasses, enums, and lambda functionsDemystify metaprogramming in Python with metaclassesWrite concurrent code in PythonMonitor and optimize the performance of Python applicationExtend and integrate Python with code written in different languagesWho this book is forThe Python programming book is intended for expert programmers who want to learn Python's advanced-level concepts and latest features.Anyone who has basic Python skills should be able to follow the content of the book, although it might require some additional effort from less experienced programmers. It should also be a good introduction to Python 3.9 for those who are still a bit behind and continue to use other older versions.
Expert SQL Server In-Memory OLTP
by Dmitri KorotkevitchExpert SQL Server In-Memory OLTP is a deep dive into one of the most significant features of SQL Server 2014 - support for In-Memory Online Transaction Processing. The book describes the architecture and internals of the In-Memory OLTP Engine and explains how to develop, deploy, and maintain systems using it. With it you can dramatically increase transactional throughput to handle thousands of transactions per second supporting millions of customers. Dmitri Korotkevitch is the five-star author of Pro SQL Server Internals, and now brings his same combination of clear thinking and deep expertise to the question of how to recognize the opportunities and benefit from Microsoft's In-Memory OLTP feature set in SQL Server 2014. Learn the architecture and the internals in order to recognize when in-memory OLTP can make a difference. Learn useful scenarios for thoughtfully incorporating In-Memory support into existing applications. Recognize opportunities for In-Memory OLTP in new development. Don't be without Dmitri Korotkevitch and the deep expertise he imparts in Expert SQL Server In-Memory OLTP as you move forward in using SQL Server's new and important In-Memory OLTP feature set. Covers In-Memory OLTP internals and architecture, including data storage, indexing, multi-version concurrency control, transaction logging, and recovery Illustrates In-Memory OLTP programmability and the process of native compilation Guides in using In-Memory OLTP in new development and existing systems. What you'll learn Grasp the internal mechanisms underlying in-memory tables and their implementation Plan successful implementations, including the required memory size and I/O configuration Properly index in-memory tables, including with hash indexes and range indexes Accelerate T-SQL processing through the creation of natively-compiled stored procedures Control disk I/O by managing logging, checkpoint, and recovery of in-memory data Monitor and report on the benefits and performance of your in-memory solutions Who this book is for Expert SQL Server In-Memory OLTP is for application developers and database administrators who create and manage online transaction processing (OLTP) systems. In particular, the book is aimed at those wanting to take advantage of SQL Server's new offering of in-memory OLTP to dramatically improve performance and throughput of their systems. Table of Contents Introduction 1. Why In-Memory OLTP? 2. In-Memory OLTP Objects 3. Memory-Optimized Tables 4. Hash Indexes 5. Nonclustered Indexes 6. In-Memory OLTP Prgrammability 7. In-Memory OLTP Concurrency Model 8. Data Storage, Logging, and Recovery 9. Garbage Collection 10. Deployment and Management 11. Utilizing In-Memory OLTP 12. Appendix A: Memory Pointer Management 13. Appendix B: Page Splitting and Merging in Nonclustered Indexes 14. Appendix C: Analyzing Checkpoint File Pair State 15. Appendix D: In-Memory OLTP Migration Tools
Expert SQL Server In-Memory OLTP
by Dmitri KorotkevitchExpert SQL Server In-Memory OLTP is a deep dive into one of the most significant features of SQL Server 2014 - support for In-Memory Online Transaction Processing. The book describes the architecture and internals of the In-Memory OLTP Engine and explains how to develop, deploy, and maintain systems using it. With it you can dramatically increase transactional throughput to handle thousands of transactions per second supporting millions of customers. Dmitri Korotkevitch is the five-star author of Pro SQL Server Internals, and now brings his same combination of clear thinking and deep expertise to the question of how to recognize the opportunities and benefit from Microsoft's In-Memory OLTP feature set in SQL Server 2014. Learn the architecture and the internals in order to recognize when In-Memory OLTP can make a difference. Learn useful scenarios for thoughtfully incorporating in-memory support into existing applications. Recognize opportunities for In-Memory OLTP in new development. Don't be without Dmitri Korotkevitch and the deep expertise he imparts in Expert SQL Server In-Memory OLTP as you move forward in using SQL Server's new and important In-Memory OLTP feature set. Covers In-Memory OLTP internals and architecture, including data storage, indexing, multi-version concurrency control, transaction logging, and recovery Illustrates In-Memory OLTP programmability and the process of native compilation Guides in using In-Memory OLTP in new development and existing systems.
Expert SQL Server Transactions and Locking: Concurrency Internals for SQL Server Practitioners
by Dmitri KorotkevitchMaster SQL Server’s Concurrency Model so you can implement high-throughput systems that deliver transactional consistency to your application customers. This book explains how to troubleshoot and address blocking problems and deadlocks, and write code and design database schemas to minimize concurrency issues in the systems you develop.SQL Server’s Concurrency Model is one of the least understood parts of the SQL Server Database Engine. Almost every SQL Server system experiences hard-to-explain concurrency and blocking issues, and it can be extremely confusing to solve those issues without a base of knowledge in the internals of the Engine. While confusing from the outside, the SQL Server Concurrency Model is based on several well-defined principles that are covered in this book.Understanding the internals surrounding SQL Server’s Concurrency Model helps you build high-throughput systems in multi-user environments. This book guides you through the Concurrency Model and elaborates how SQL Server supports transactional consistency in the databases. The book covers all versions of SQL Server, including Microsoft Azure SQL Database, and it includes coverage of new technologies such as In-Memory OLTP and Columnstore Indexes.What You'll LearnKnow how transaction isolation levels affect locking behavior and concurrencyTroubleshoot and address blocking issues and deadlocksProvide required data consistency while minimizing concurrency issuesDesign efficient transaction strategies that lead to scalable codeReduce concurrency problems through good schema designUnderstand concurrency models for In-Memory OLTP and Columnstore IndexesReduce blocking during index maintenance, batch data load, and similar tasksWho This Book Is ForSQL Server developers, database administrators, and application architects who are developing highly-concurrent applications. The book is for anyone interested in the technical aspects of creating and troubleshooting high-throughput systems that respond swiftly to user requests.
Expert Scripting and Automation for SQL Server DBAs: Amplifying Productivity Through Automation
by Peter A. CarterThe market is trending toward a much smaller ratio of DBAs to SQL Server instances, but this book will help you meet this new reality by harnessing automation to continue building and maintaining reliable database platform services for your SQL Server enterprise. The book will help you automate your workload and manage more databases and instances with greater ease and efficiency by combining metadata-driven automation with the power of PowerShell. You'll soon be able to automate your new instance-builds and centralize your maintenance. This book walks you through automating the SQL Server build processes and maintenance of multiple instances from a single location, as well as how to use database metadata to drive your automation. With a heavier focus on PowerShell, this 2nd edition highlights modern techniques, such as configuration management. Also new in this edition, you will learn how to use PowerShell modules such as SqlServer and DBATools, which is a popular community module that you can rely on to keep your database estate running smoothly. You will understand the benefits of centralizing maintenance to better keep your enterprise responding with reliable performance to the loads placed upon it by your business. The book helps you become faster and better at what you do for a living, and thus will boost your value within the job market. What You Will Learn Automate SQL Server installation and configuration Apply techniques such as Desired State Configuration to prevent drift on your servers and instances Increase your value to your organization by automating low-value tasks and focusing your time on the higher-value ones Take advantage of database metadata to drive automation, allowing you to build intelligent automated routines Promote and demonstrate how to modernize database maintenance across your enterprise Apply tools such as PowerShell with modern techniques to increase your value in the job market Who This Book Is For SQL Server DBAs who want to increase their productivity by embracing automation
Expert Secrets: The Underground Playbook for Converting Your Online Visitors into Lifelong Customers
by Russell BrunsonMaster the art of what to say in your funnels to convert your online visitors into lifelong customers in this updated edition from the $100M entrepreneur and co-founder of the software company ClickFunnels.Your business is a calling. You've been called to serve a group of people with the products, services, and offers that you've created. The impact that the right message can have on someone at the right time in their life is immeasurable. Your message could help to save marriages, repair families, change someone's health, grow a company, or more. . . . But only if you know how to get it into the hands of the people whose lives you have been called to change.By positioning yourself as an expert and telling your story in a way that gets people to move, you will be able to guide people through your value ladder, offer solutions to their problems, and give them the results they are looking for. This is how you change the lives of your customers, and this is how you grow your company.In this updated edition of Expert Secrets, Russell Brunson, CEO and co-founder of the multimillion-dollar software company ClickFunnels, gives you the step-by-step strategies you need to turn your expertise into a carefully crafted sales message that will attract your dream customers.Don't hide inside your business. Implement these story selling techniques now so you can find your voice and gain the confidence to become a leader, build a movement of people whose lives you can change, and make this calling a career.
Expert Sniper Strategies for Fortniters: An Unofficial Guide to Battle Royale (Master Combat)
by Jason RichHit your target every time with this Fortnite expert sniper guide. This all‑new, unofficial, illustrated guide series will turn you into a master Fortnite: Battle Royale gamer by uncovering all the best strategies and secrets of this wildly popular game. Whether you play Fortnite Battle Royale on a PC, Mac, Xbox One, PlayStation 4, or your mobile device, you’ll find everything you need to stay at the top of your game. Each book is packed with useful insider tips on topics like, staying alive longer, exploring, collecting a powerful arsenal, building, and snagging more victories during each match. When it comes to achieving #1 Victory Royale, the Fortnite Battle Royale: Master Combat Series provides the ultimate competitive edge. Thanks to this comprehensive how‑to Fortnite shooting guide, you’ll gain the crucial battle skills you need to eliminate your enemies like a pro. Sniper rifles and projectile weapons are only as good as the player using them. This comprehensive resource will sharpen your skills and show you how and when to use the incredible range of guns, weapons, tools, and ammunition available during each match. There’s nothing more important in Fortnite than staying alive longer and battling your way to #1 Victory Royale. This straightforward guide has everything you need to prepare for long‑range, mid‑range, and close‑range combat situations so that you can emerge a winner.
Expert Systems in Chemistry Research
by Markus C. HemmerExpert systems allow scientists to access, manage, and apply data and specialized knowledge from various disciplines to their own research. Expert Systems in Chemistry Research explains the general scientific basis and computational principles behind expert systems and demonstrates how they can improve the efficiency of scientific workflows