Over 170 advanced recipes to search, analyze, deploy, manage, and monitor data effectively with Elasticsearch 5.x About This Book Deploy and manage simple Elasticsearch nodes as well as complex cluster topologies Write native plugins to extend the functionalities of Elasticsearch 5.x to boost your business Packed with clear, step-by-step recipes to walk you through the capabilities of Elasticsearch 5.x Who This Book Is For If you are a developer who wants to get the most out of Elasticsearch for advanced search and analytics, this is the book for you. Some understanding of JSON is expected. If you want to extend Elasticsearch, understanding of Java and related technologies is also required. What You Will Learn Choose the best Elasticsearch cloud topology to deploy and power it up with external plugins Develop tailored mapping to take full control of index steps Build complex queries through managing indices and documents Optimize search results through executing analytics aggregations Monitor the performance of the cluster and nodes Install Kibana to monitor cluster and extend Kibana for plugins Integrate Elasticsearch in Java, Scala, Python and Big Data applications In Detail Elasticsearch is a Lucene-based distributed search server that allows users to index and search unstructured content with petabytes of data. This book is your one-stop guide to master the complete Elasticsearch ecosystem. We’ll guide you through comprehensive recipes on what’s new in Elasticsearch 5.x, showing you how to create complex queries and analytics, and perform index mapping, aggregation, and *ing. Further on, you will explore the modules of Cluster and Node monitoring and see ways to back up and restore a snapshot of an index. You will understand how to install Kibana to monitor a cluster and also to extend Kibana for plugins. Finally, you will also see how you can integrate your Java, Scala, Python, and Big Data applications such as Apache Spark and Pig with Elasticsearch, and add enhanced functionalities with custom plugins. By the end of this book, you will have an in-depth knowledge of the implementation of the Elasticsearch architecture and will be able to manage data efficiently and effectively with Elasticsearch. Style and approach This book follows a problem-solution approach to effectively use and manage Elasticsearch. Each recipe focuses on a particular task at hand, and is explained in a very simple, easy to understand manner.

Get the most out of the Elastic Stack for various complex analytics using this comprehensive and practical guide About This Book Your one-stop solution to perform advanced analytics with Elasticsearch, Logstash, and Kibana Learn how to make better sense of your data by searching, analyzing, and logging data in a systematic way This highly practical guide takes you through an advanced implementation on the ELK stack in your enterprise environment Who This Book Is For This book cater to developers using the Elastic stack in their day-to-day work who are familiar with the basics of Elasticsearch, Logstash, and Kibana, and now want to become an expert at using the Elastic stack for data analytics. What You Will Learn Build a pipeline with help of Logstash and Beats to visualize Elasticsearch data in Kibana Use Beats to ship any type of data to the Elastic stack Understand Elasticsearch APIs, modules, and other advanced concepts Explore Logstash and it’s plugins Discover how to utilize the new Kibana UI for advanced analytics See how to work with the Elastic Stack using other advanced configurations Customize the Elastic Stack and plugin development for each of the component Work with the Elastic Stack in a production environment Explore the various components of X-Pack in detail. In Detail Even structured data is useless if it can’t help you to take strategic decisions and improve existing system. If you love to play with data, or your job requires you to process custom log formats, design a scalable analysis system, and manage logs to do real-time data analysis, this book is your one-stop solution. By combining the massively popular Elasticsearch, Logstash, Beats, and Kibana, elastic.co has advanced the end-to-end stack that delivers actionable insights in real time from almost any type of structured or unstructured data source. If your job requires you to process custom log formats, design a scalable analysis system, explore a variety of data, and manage logs, this book is your one-stop solution. You will learn how to create real-time dashboards and how to manage the life cycle of logs in detail through real-life scenarios. This book brushes up your basic knowledge on implementing the Elastic Stack and then dives deeper into complex and advanced implementations of the Elastic Stack. We’ll help you to solve data analytics challenges using the Elastic Stack and provide practical steps on centralized logging and real-time analytics with the Elastic Stack in production. You will get to grip with advanced techniques for log analysis and visualization. Newly announced features such as Beats and X-Pack are also covered in detail with examples. Toward the end, you will see how to use the Elastic stack for real-world case studies and we’ll show you some best practices and troubleshooting techniques for the Elastic Stack. Style and approach This practical guide shows you how to perform advanced analytics with the Elastic stack through real-world use cases. It includes common and some not so common scenarios to use the Elastic stack for data analysis.

Over 70 practical recipes to analyze multi-dimensional data in SQL Server 2016 Analysis Services cubes About This Book Updated for SQL Server 2016, this book helps you take advantage of the new MDX commands and the new features introduced in SSAS Perform time-related, context-aware, and business related-calculations with ease to enrich your Business Intelligence solutions Collection of techniques to write flexible and high performing MDX queries in SSAS with carefully structured examples Who This Book Is For This book is for anyone who has been involved in working with multidimensional data. If you are a multidimensional cube developer, a multidimensional database administrator, or a report developer who writes MDX queries to access multidimensional cube, this book will help you. If you are a power cube user or an experienced business analyst, you will also find this book invaluable in your data analysis. This book is for you are interested in doing more data analysis so that the management can make timely and accurate business decisions. What You Will Learn Grasp the fundamental MDX concepts, features, and techniques Work with sets Work with Time dimension and create time-aware calculations Make analytical reports compact, concise, and efficient Navigate cubes Master MDX for reporting with Reporting Services (new) Perform business analytics Design efficient cubes and efficient MDX queries Create metadata-driven calculations (new) Capture MDX queries and many other techniques In Detail If you're often faced with MDX challenges, this is a book for you. It will teach you how to solve various real-world business requirements using MDX queries and calculations. Examples in the book introduce an idea or a problem and then guide you through the process of implementing the solution in a step-by-step manner, inform you about the best practices and offer a deep knowledge in terms of how the solution works. Recipes are organized by chapters, each covering a single topic. They start slowly and logically progress to more advanced techniques. In case of complexity, things are broken down. Instead of one, there are series of recipes built one on top of another. This way you are able to see intermediate results and debug potential errors faster. Finally, the cookbook format is here to help you quickly identify the topic of interest and in it a wide range of practical solutions, that is – MDX recipes for your success. Style and approach This book is written in a cookbook format, where you can browse through and look for solutions to a particular problem in one place. Each recipe is short, to the point and grouped by relevancy. All the recipes are sequenced in a logical progression; you will be able to build up your understanding of the topic incrementally.

Create interactive cross-platform reports and dashboards using SQL Server 2016 Reporting Services About This Book Get up to speed with the newly-introduced enhancements and the more advanced query and reporting features Easily access your important data by creating visually appealing dashboards in the Power BI practical recipe Create cross-browser and cross-platform reports using SQL Server 2016 Reporting Services Who This Book Is For This book is for software professionals who develop and implement reporting solutions using Microsoft SQL Server. It is especially relevant for professionals who are software engineers, software architects, DW/BI engineers, and DW/BI architects who perform simple to complex report authoring implementations. This book is also suitable for those who develop software solutions that integrate reporting solutions and are keen to learn about Microsoft SQL Server 2016’s features and capabilities. What You Will Learn Key capabilities, architecture, and components of Reporting Services New features that have been added to Reporting Services Design the architecture for reporting solutions Design the architecture for BI solutions Implement reporting solutions using Reporting Services Improve the performance, availability, and scalability of the reporting solution Enhance reporting solutions with custom programming and improved security In Detail Microsoft SQL Server 2016 Reporting Services comes with many new features. It offers different types of reporting such as Production, Ad-hoc, Dashboard, Mash-up, and Analytical. SQL Server 2016 also has a surfeit of new features including Mobile Reporting, and Power BI integration. This book contains recipes that explore the new and advanced features added to SQL Server 2016. The first few chapters cover recipes on configuring components and how to explore these new features. You’ll learn to build your own reporting solution with data tools and report builder, along with learning techniques to create visually appealing reports. This book also has recipes for enhanced mobile reporting solutions, accessing these solutions effectively, and delivering interactive business intelligence solutions. Towards the end of the book, you’ll get to grips with running reporting services in SharePoint integrated mode and be able to administer, monitor, and secure your reporting solution. This book covers about the new offerings of Microsoft SQL Server 2016 Reporting Services in comprehensive detail and uses examples of real-world problem-solving business scenarios. Style and approach This comprehensive cookbook follows a problem-solution approach to help you overcome any obstacle when creating interactive, visually-appealing reports using SQL Server 2016 Reporting Services. Each recipe focuses on a specific task and is written in a clear, solution-focused style.

Secure your Oracle Database 12c with this valuable Oracle support resource, featuring more than 100 solutions to the challenges of protecting your data About This Book Explore and learn the new security features introduced in Oracle Database 12c, to successfully secure your sensitive data Learn how to identify which security strategy is right for your needs – and how to apply it Each ‘recipe’ provides you with a single step-by-step solution, making this book a vital resource, delivering Oracle support in one accessible place Who This Book Is For This book is for DBAs, developers, and architects who are keen to know more about security in Oracle Database 12c. This book is best suited for beginners and intermediate-level database security practitioners. Basic knowledge of Oracle Database is expected, but no prior experience of securing a database is required. What You Will Learn Analyze application privileges and reduce the attack surface Reduce the risk of data exposure by using Oracle Data Redaction and Virtual Private Database Control data access and integrity in your organization using the appropriate database feature or option Learn how to protect your databases against application bypasses Audit user activity using the new auditing architecture Restrict highly privileged users from accessing data Encrypt data in Oracle Database Work in a real-world environment where a multi-layer security strategy is applied In Detail Businesses around the world are paying much greater attention toward database security than they ever have before. Not only does the current regulatory environment require tight security, particularly when dealing with sensitive and personal data, data is also arguably a company’s most valuable asset - why wouldn’t you want to protect it in a secure and reliable databaseOracle Database lets you do exactly that. It’s why it is one of the world’s leading databases – with a rich portfolio of features to protect data from contemporary vulnerabilities, it’s the go-to database for many organizations. Oracle Database 12c Security Cookbook helps DBAs, developers, and architects to better understand database security challenges. Let it guide you through the process of implementing appropriate security mechanisms, helping you to ensure you are taking proactive steps to keep your data safe. Featuring solutions for common security problems in the new Oracle Database 12c, with this book you can be confident about securing your database from a range of different threats and problems. Style and approach Each chapter explains the different aspects of security through a series of recipes. Each recipe presents instructions in a step-by-step manner, supported by explanations of the topic.

Design, implement, and deliver successful streaming applications, machine learning pipelines and graph applications using Spark SQL API About This Book ? Learn about the design and implementation of streaming applications, machine learning pipelines, deep learning, and large-scale graph processing applications using Spark SQL APIs and Scala. ? Learn data exploration, data munging, and how to process structured and semi-structured data using real-world datasets and gain hands-on exposure to the issues and challenges of working with noisy and "dirty" real-world data. ? Understand design considerations for scalability and performance in web-scale Spark application architectures. Who This Book Is For If you are a developer, engineer, or an architect and want to learn how to use Apache Spark in a web-scale project, then this is the book for you. It is assumed that you have prior knowledge of SQL querying. A basic programming knowledge with Scala, Java, R, or Python is all you need to get started with this book. What You Will Learn ? Familiarize yourself with Spark SQL programming, including working with DataFrame/Dataset API and SQL ? Perform a series of hands-on exercises with different types of data sources, including CSV, JSON, Avro, MySQL, and MongoDB ? Perform data quality checks, data visualization, and basic statistical analysis tasks ? Perform data munging tasks on publically available datasets ? Learn how to use Spark SQL and Apache Kafka to build streaming applications ? Learn key performance-tuning tips and tricks in Spark SQL applications ? Learn key architectural components and patterns in large-scale Spark SQL applications In Detail In the past year, Apache Spark has been increasingly adopted for the development of distributed applications. Spark SQL APIs provide an optimized interface that helps developers build such applications quickly and easily. However, designing web-scale production applications using Spark SQL APIs can be a complex task. Hence, understanding the design and implementation best practices before you start your project will help you avoid these problems. This book gives an insight into the engineering practices used to design and build real-world, Spark-based applications. The book's hands-on examples will give you the required confidence to work on any future projects you encounter in Spark SQL. It starts by familiarizing you with data exploration and data munging tasks using Spark SQL and Scala. Extensive code examples will help you understand the methods used to implement typical use-cases for various types of applications. You will get a walkthrough of the key concepts and terms that are common to streaming, machine learning, and graph applications. You will also learn key performance-tuning details including Cost Based Optimization (Spark 2.2) in Spark SQL applications. Finally, you will move on to learning how such systems are architected and deployed for a successful delivery of your project. Style and approach This book is a hands-on guide to designing, building, and deploying Spark SQL-centric production applications at scale.

More than 80 recipes to help you leverage the various extensibility features available for Microsoft Dynamics and solve problems easily About This Book ? Customize, configure, and extend the vanilla features of Dynamics 365 to deliver bespoke CRM solutions fit for any organization ? Implement business logic using point-and-click configuration, plugins, and client-side *s with MS Dynamics 365 ? Built a DevOps pipeline as well as Integrate Dynamics 365 with Azure and other platforms Who This Book Is For This book is for developers, administrators, consultants, and power users who want to learn about best practices when extending Dynamics 365 for enterprises. You are expected to have a basic understand of the Dynamics CRM/365 platform. What You Will Learn ? Customize, configure, and extend Microsoft Dynamics 365 ? Create business process automation ? Develop client-side extensions to add features to the Dynamics 365 user interface ? Set up a security model to securely manage data with Dynamics 365 ? Develop and deploy clean code plugins to implement a wide range of custom behaviors ? Use third-party applications, tools, and patterns to integrate Dynamics 365 with other platforms ? Integrate with Azure, Java, SSIS, PowerBI, and Octopus Deploy ? Build an end-to-end DevOps pipeline for Dynamics 365 In Detail Microsoft Dynamics 365 is a powerful tool. It has many unique features that empower organisations to bridge common business challenges and technology pitfalls that would usually hinder the adoption of a CRM solution. This book sets out to enable you to harness the power of Dynamics 365 and cater to your unique circumstances. We start this book with a no-code configuration chapter and explain the schema, fields, and forms modeling techniques. We then move on to server-side and client-side custom code extensions. Next, you will see how best to integrate Dynamics 365 in a DevOps pipeline to package and deploy your extensions to the various SDLC environments. This book also covers modern libraries and integration patterns that can be used with Dynamics 365 (Angular, 3 tiers, and many others). Finally, we end by highlighting some of the powerful extensions available. Throughout we explain a range of design patterns and techniques that can be used to enhance your code quality; the aim is that you will learn to write enterprise-scale quality code. Style and approach This book takes a recipe-based approach, delivering practical examples and use cases so that you can identify the best possible approach to extend your Dynamics 365 deployment and tackle your specific business problems.

Incorporate the power of Einstein in your Salesforce application About This Book ? Make better predictions of your business processes using prediction and predictive modeling ? Build your own custom models by leveraging PredictionIO on the Heroku platform ? Integrate Einstein into various cloud services to predict sales, marketing leads, insights into news feeds, and more Who This Book Is For This book is for developers, data scientists, and Salesforce-experienced consultants who want to explore Salesforce Einstein and its current offerings. It assumes some prior experience with the Salesforce platform. What You Will Learn ? Get introduced to AI and its role in CRM and cloud applications ? Understand how Einstein works for the sales, service, marketing, community, and commerce clouds ? Gain a deep understanding of how to use Einstein for the analytics cloud ? Build predictive apps on Heroku using PredictionIO, and work with Einstein Predictive Vision Services ? Incorporate Einstein in the IoT cloud ? Test the accuracy of Einstein through Salesforce reporting and Wave analytics In Detail Dreamforce 16 brought forth the latest addition to the Salesforce platform: an AI tool named Einstein. Einstein promises to provide users of all Salesforce applications with a powerful platform to help them gain deep insights into the data they work on. This book will introduce you to Einstein and help you integrate it into your respective business applications based on the Salesforce platform. We start off with an introduction to AI, then move on to look at how AI can make your CRM and apps smarter. Next, we discuss various out-of-the-box components added to sales, service, marketing, and community clouds from salesforce to add Artificial Intelligence capabilities. Further on, we teach you how to use Heroku, PredictionIO, and the force.com platform, along with Einstein, to build smarter apps. The core chapters focus on developer content and introduce PredictionIO and Salesforce Einstein Vision Services. We explore Einstein Predictive Vision Services, along with analytics cloud, the Einstein Data Discovery product, and IOT core concepts. Throughout the book, we also focus on how Einstein can be integrated into CRM and various clouds such as sales, services, marketing, and communities. By the end of the book, you will be able to embrace and leverage the power of Einstein, incorporating its functions to gain more knowledge. Salesforce developers will be introduced to the world of AI, while data scientists will gain insights into Salesforce’s various cloud offerings and how they can use Einstein’s capabilities and enhance applications. Style and approach This book takes a straightforward approach to explain Salesforce Einstein and all of its potential applications. Filled with examples, the book presents the facts along with seasoned advice and real-world use cases to ensure you have all the resources you need to incorporate the power of Einstein in your work.

Master the capabilities of PostgreSQL 9.6 to efficiently manage and maintain your database About This Book ? Your one-stop guide to mastering the advanced concepts in PostgreSQL with ease ? Master query optimization, replication, and high availability with PostgreSQL ? Extend the functionalities of PostgreSQL to suit your organizational needs with minimum effort Who This Book Is For If you are a PostgreSQL data architect or an administrator who wants to understand how to implement advanced functionalities and master complex administrative tasks with PostgreSQL, then this book is perfect for you. Prior experience of administrating a PostgreSQL database and a working knowledge of SQL is required to make the best use of this book. What You Will Learn ? Get to grips with the advanced features of PostgreSQL 9.6 and handle advanced SQL ? Make use of the indexing features in PostgreSQL and fine-tune the performance of your queries ? Work with the stored procedures and manage backup and recovery ? Master the replication and failover techniques ? Troubleshoot your PostgreSQL instance for solutions to the common and not-so-common problems ? Learn how to migrate your database from MySQL and Oracle to PostgreSQL without any hassle In Detail PostgreSQL is an open source database used for handling large datasets (Big Data) and as a JSON document database. It also has applications in the software and web domains. This book will enable you to build better PostgreSQL applications and administer databases more efficiently. We begin by explaining the advanced database design concepts in PostgreSQL 9.6, along with indexing and query optimization. You will also see how to work with event triggers and perform concurrent transactions and table partitioning, along with exploring SQL and server tuning. We will walk you through implementing advanced administrative tasks such as server maintenance and monitoring, replication, recovery and high availability, and much more. You will understand the common and not-so-common troubleshooting problems and how you can overcome them. By the end of this book, you will have an expert-level command of the advanced database functionalities and will be able to implement advanced administrative tasks with PostgreSQL. Style and Approach This book is a comprehensive guide covering all the concepts you need to master PostgreSQL. Packed with hands-on examples, tips and tricks, even the most advanced concepts are explained in a very easy-to-follow manner. Every chapter in the book does not only focus on how each task is performed, but also why.

Master the art of developing message-based applications with RabbitMQAbout This BookLearn how to administer, manage, and extend your own message broker, RabbitMQDevelop clients to make a message bridge between your software systems using RabbitMQDiscover how to achieve proficiency with RabbitMQ with the well-defined de*ions of the topicsWho This Book Is ForIf you are an intermediate-level RabbitMQ developer, who wants to achieve professional-level expertise in the subject, this book is for you. You’ll also need to have a decent understanding of message queuing.What You Will LearnAdminister RabbitMQ using different toolsUnderstand the roots and details of messaging, message brokers, and AMQP protocolScale the RabbitMQ server using the clusters and high availability techniquesExtend RabbitMQ by developing the Erlang OTP-based applications that use the RabbitMQ APIManage the RabbitMQ server using its powerful toolsMonitor the RabbitMQ Server using different open source tools such as Nagios, Munin, and ZabbixEnsure your RabbitMQ’s security using SSL, SASL, and access controlDevelop RabbitMQ clients using Java, Python, and C# with an industry exampleIn DetailRabbitMQ is one of the most powerful Open Source message broker software, which is widely used in tech companies such as Mozilla, VMware, Google, AT&T, and so on. RabbitMQ gives you lots of fantastic and easy-to-manage functionalities to control and manage the messaging facility with lots of community support. As scalability is one of our major modern problems, messaging with RabbitMQ is the main part of the solution to this problem.This book explains and demonstrates the RabbitMQ server in a detailed way. It provides you with lots of real-world examples and advanced solutions to tackle the scalability issues.You’ll begin your journey with the installation and configuration of the RabbitMQ server, while also being given specific details pertaining to the subject. Next, you’ll study the major problems that our server faces, including scalability and high availability, and try to get the solutions for both of these issues by using the RabbitMQ mechanisms. Following on from this, you’ll get to design and develop your own plugins using the Erlang language and RabbitMQ’s internal API. This knowledge will help you to start with the management and monitoring of the messages, tools, and applications. You’ll also gain an understanding of the security and integrity of the messaging facilities that RabbitMQ provides. In the last few chapters, you will build and keep track of your clients (senders and receivers) using Java, Python, and C#.Style and approach An easy-to-follow guide, full of hands-on examples based around managing, monitoring, extending, and securing RabbitMQ and its internal tools. You will learn how to develop your own clients using Java, Python, and C#.

Leverage the power of Scala with different tools to build scalable, robust data science applicationsAbout This BookA complete guide for scalable data science solutions, from data ingestion to data visualizationDeploy horizontally scalable data processing pipelines and take advantage of web frameworks to build engaging visualizationsBuild functional, type-safe routines to interact with relational and NoSQL databases with the help of tutorials and examples providedWho This Book Is ForIf you are a Scala developer or data scientist, or if you want to enter the field of data science, then this book will give you all the tools you need to implement data science solutions.What You Will LearnTransform and filter tabular data to extract features for machine learningImplement your own algorithms or take advantage of MLLib’s extensive suite of models to build distributed machine learning pipelinesRead, transform, and write data to both SQL and NoSQL databases in a functional mannerWrite robust routines to query web APIsRead data from web APIs such as the GitHub or Twitter APIUse Scala to interact with MongoDB, which offers high performance and helps to store large data sets with uncertain query requirementsCreate Scala web applications that couple with JavaScript libraries such as D3 to create compelling interactive visualizationsDeploy scalable parallel applications using Apache Spark, loading data from HDFS or HiveIn DetailScala is a multi-paradigm programming language (it supports both object-oriented and functional programming) and *ing language used to build applications for the JVM. Languages such as R, Python, Java, and so on are mostly used for data science. It is particularly good at analyzing large sets of data without any significant impact on performance and thus Scala is being adopted by many developers and data scientists. Data scientists might be aware that building applications that are truly scalable is hard. Scala, with its powerful functional libraries for interacting with databases and building scalable frameworks will give you the tools to construct robust data pipelines.This book will introduce you to the libraries for ingesting, storing, manipulating, processing, and visualizing data in Scala.Packed with real-world examples and interesting data sets, this book will teach you to ingest data from flat files and web APIs and store it in a SQL or NoSQL database. It will show you how to design scalable architectures to process and modelling your data, starting from simple concurrency constructs such as parallel collections and futures, through to actor systems and Apache Spark. As well as Scala’s emphasis on functional structures and immutability, you will learn how to use the right parallel construct for the job at hand, minimizing development time without compromising scalability. Finally, you will learn how to build beautiful interactive visualizations using web frameworks.This book gives tutorials on some of the most common Scala libraries for data science, allowing you to quickly get up to speed with building data science and data engineering solutions.Style and approachA tutorial with complete examples, this book will give you the tools to start building useful data engineering and data science solutions straightaway

Learn Database design, development,and administration using the feature-rich SQL Developer 4.1 interfaceAbout This BookExplore all the SQL Developer 4.1 features useful for Oracle database developers, architects, and administratorsUnderstand how this free tool from Oracle has evolved over the years and has become a complete tool that makes life easy for Oracle and third-party database usersThe author, Ajith Narayanan, has a total of 10+ years of work experience as an Oracle [APPS] DBAWho This Book Is ForThis book is intended for Oracle developers who are responsible for database management. You are expected to have programming knowledge of SQL and PL/SQL, and must be familiar with basic Oracle database concepts.What You Will LearnInstall and navigate through all the advanced features of SQL Developer that were introduced in version 4.1Browse, create, edit, and delete (drop) database objectsUse the SQL worksheet to run SQL statements and *s, edit and debug PL/SQL code, manipulate and export (unload) dataCarry out all DBA-related activities such as exporting/importing, tuning, and analyzing database performance issuesQuickly analyze, create, and edit the data model using data modelerExtend the SQL developer capabilities by exploring the APEX related pages, enabling and working with RESTful servicesUse the available reports and create new custom reports with custom *sGrasp how to connect to third-party databases and work smoothly with themIn DetailAt times, DBAs support 100s of databases at work. In such scenarios, using a command-line tool like putty adds to the difficulty, while SQL Developer makes the life of a developer, DBA, or DB architect easier by providing a graphical user interface equipped with features that can bolster and enhance the user experience and boost efficiency. Features such as DBA panel, Reports, Data Modeler, and Data Miner are just a few examples of its rich features, and its support for APEX, REST Services, timesten, and third-party database drivers demonstrate its extensibility.You may be a newbie to databases or a seasoned database expert, either way this book will help you understand the database structure and the different types of objects that organize enterprise data in an efficient manner. This book introduces the features of the SQL Developer 4.1 tool in an incremental fashion, starting with installing them, making the database connections, and using the different panels. By sequentially walking through the steps in each chapter, you will quickly master SQL Developer 4.1.Style and approachThis book follows a step-by-step approach and is in a conversational and easy-to-follow style. Screenshots , and detailed explanations of the basic and advanced features of SQL Developer 4.1 that will make your work and life easy.

A practical tutorial containing clear, step-by-step explanations of all the concepts required to understand the technology involved in virtualizing your application infrastructure. Each chapter uses real-world scenarios so that the readers can put into practice what they learn immediately and with the right guidance. Each topic is written defining a common need and developing the process to solve it using Microsoft App-V. This book is for system administrators or consultants who want to master and dominate App-V, and gain a deeper understanding of the technology in order to optimize App V implementations. Even though the book does not include basic steps like installing App-V components or sequencing simple applications; application virtualization beginners will receive a comprehensive look into App-V before jumping into the technical process of each chapter.

This book is written in a clear conversational style, which emphasizes a practical learn-by-doing approach. This step by step guide has illustrative examples to implement Ext JS library features in your Oracle APEX applications If you are an Oracle APEX application developer who wants to take APEX applications to the next level by taking advantage of Ext JS features, this book is for you. Prior knowledge of Oracle APEX is required, however, no prior knowledge of Ext JS is required.

Covering SQL Developer fundamentals as well more intermediate and advanced topics, this book uses in-depth explanation and detailed examples to help you get the most out of Oracle SQL Developer. The book has a modular structure, so that you can dip into any chapter that covers your current area of focus and get going. This book is for Oracle developers who want to ease their database development, and enhance their productivity using Oracle SQL Developer. You should have a programming knowledge of SQL and PL/SQL, and a general familiarity with Oracle database concepts.

This book is a hands-on tutorial detailing Oracle Enterprise Manager Grid Control's management of Middleware. It is a 'how-to', and provides best practices, tips, and troubleshooting guidelines for managing middleware with Oracle Enterprise Manager. This book is targeted at Middleware Administrators, IT Architects, and System Administrators who want to monitor, diagnose, and maximize the system performance of Oracle [if gte mso 9] Normal 0 false false false EN-US X-NONE X-NONE ![endif]--[if gte mso 9] ![endif] Fusion Middleware solutions. The book assumes basic knowledge of middleware/application server management. It can also be used by Database Administrators who want to become Middleware Administrators.

Throughout the book, we will follow a fictional company, the case study will help you in implementing FIM 2010 R2. All the examples in the book will relate to this fictive company and you will be taken from design, to installation, to configuration of FIM 2010 R2. If you are implementing and managing FIM 2010 R2 in your business, then this book is for you. You will need to have a basic understanding of Microsoft based infrastructure using Active Directory. If you are new to Forefront Identity Management, the case-study approach of this book will help you to understand the concepts and implement them.

This is a practical guide providing comprehensive solutions for SQL query problems, and is full of concrete real-world examples to help you create and troubleshoot your SQL queries in SAP Business One. If you are a system administrator who uses SQL query as your tool of choice for solving specific problems throughout SAP Business One, then this book is for you. It may also be useful if you are a developer or consultant using this technology, and can benefit end users by improving your search for important business information. A rudimentary knowledge of SAP Business One and SQL Server is required to use this book efficiently. Examples covered are relevant to SBO 2007A users, for which the 8.8 release is mostly compatible. All SQL query examples within the book are verified under SQL Server 2005, so they are guaranteed to run under this release, in addition to SQL Server 2008. Non-SAP Business One users can also gain knowledge from the many examples throughout the book. It is hard to find another book with so many SQL query examples.

Follow valuable and practical recipes touring the fundamental features of Dynamics AX extension.This title is for business professionals, such as administrators and consultants, who want to take full advantage of the features of Dynamics AX. This book has a wide appeal and you do not need to be a SharePoint, database or programming expert. As long as you know a little about these elements, you will be able to take full advantage of the business efficiency created with Dynamics AX extensions.

vSphere High Performance Cookbook is written in a practical, helpful style with numerous recipes focusing on answering and providing solutions to common, and not-so common, performance issues and problems.The book is primarily written for technical professionals with system administration skills and some VMware experience who wish to learn about advanced optimization and the configuration features and functions for vSphere 5.1.

A practical guide which will help to discover how to setup and configure the Salesforce CRM application. It offers solutions and practical examples on how to further improve and maintain its functionality with clear systematic instructions. Being highly organized and compact, this book contains detailed instructions with screenshots, diagrams, and tips that clearly describe how you can administer and configure complex Salesforce CRM functionality with absolute ease.This book is for administrators who want to develop and strengthen their Salesforce CRM skills in the areas of configuration and system management. Whether you are a novice or a more experienced admin, this book aims to enhance your knowledge and understanding of the Salesforce CRM platform and by the end of the book, you should be ready to administer Salesforce CRM in a real-world environment.