Author : Asif Momen
Publisher : Packt Publishing Ltd
Page : 220 pages
File Size : 37,88 MB
Release : 2012-07-10
Category : Computers
ISBN : 1849686750
Build and manage your Oracle Database XE environment with this fast paced, practical guide
Author : Saurabh K. Gupta
Publisher : Packt Publishing Ltd
Page : 428 pages
File Size : 11,18 MB
Release : 2016-02-15
Category : Computers
ISBN : 1785282522
Master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c About This Book Learn advanced application development features of Oracle Database 12c and prepare for the 1Z0-146 examination Build robust and secure applications in Oracle PL/SQL using the best practices Packed with feature demonstrations and illustrations that will help you learn and understand the enhanced capabilities of Oracle Database 12c Who This Book Is For This book is for Oracle developers responsible for database management. Readers are expected to have basic knowledge of Oracle Database and the fundamentals of PL/SQL programming. Certification aspirants can use this book to prepare for 1Z0-146 examination in order to be an Oracle Certified Professional in Advanced PL/SQL. What You Will Learn Learn and understand the key SQL and PL/SQL features of Oracle Database 12c Understand the new Multitenant architecture and Database In-Memory option of Oracle Database 12c Know more about the advanced concepts of the Oracle PL/SQL language such as external procedures, securing data using Virtual Private Database (VPD), SecureFiles, and PL/SQL code tracing and profiling Implement Virtual Private Databases to prevent unauthorized data access Trace, analyze, profile, and debug PL/SQL code while developing database applications Integrate the new application development features of Oracle Database 12c with the current concepts Discover techniques to analyze and maintain PL/SQL code Get acquainted with the best practices of writing PL/SQL code and develop secure applications In Detail Oracle Database is one of the most popular databases and allows users to make efficient use of their resources and to enhance service levels while reducing the IT costs incurred. Oracle Database is sometimes compared with Microsoft SQL Server, however, Oracle Database clearly supersedes SQL server in terms of high availability and addressing planned and unplanned downtime. Oracle PL/SQL provides a rich platform for application developers to code and build scalable database applications and introduces multiple new features and enhancements to improve development experience. Advanced Oracle PL/SQL Developer's Guide, Second Edition is a handy technical reference for seasoned professionals in the database development space. This book starts with a refresher of fundamental concepts of PL/SQL, such as anonymous block, subprograms, and exceptions, and prepares you for the upcoming advanced concepts. The next chapter introduces you to the new features of Oracle Database 12c, not limited to PL/SQL. In this chapter, you will understand some of the most talked about features such as Multitenant and Database In-Memory. Moving forward, each chapter introduces advanced concepts with the help of demonstrations, and provides you with the latest update from Oracle Database 12c context. This helps you to visualize the pre- and post-applications of a feature over the database releases. By the end of this book, you will have become an expert in PL/SQL programming and will be able to implement advanced concepts of PL/SQL for efficient management of Oracle Database. Style and approach The book follows the structure of the Oracle Certification examination but doesn't restrict itself to the exam objectives. Advanced concepts have been explained in an easy-to-understand style, supported with feature demonstrations and case illustrations.
Author : Asif Momen
Publisher : Packt Pub Limited
Page : 146 pages
File Size : 24,13 MB
Release : 2012
Category : Computers
ISBN : 9781849686747
This book discusses concepts and tasks through real-world examples. The author uses simple language, screenshots, and a step-by-step approach to get you started with Oracle Database administration. If you are a student or beginner who is learning to administer Oracle Database, then this book is for you. This book is designed to cover the problems that novice DBAs particularly struggle with, so no prior knowledge of Oracle database administration is expected.
Author : John P Jeffries
Publisher : Packt Publishing Ltd
Page : 422 pages
File Size : 43,13 MB
Release : 2015-07-27
Category : Computers
ISBN : 178398077X
GoldenGate exchanges data among systems in a timely manner and meets the demand for real-time access to information regardless of volume. The new release, 12c, includes an optimized database, intelligent and integrated delivery capabilities, expanded heterogeneity, and tighter security. Perform zero downtime data migration to on-premise or public cloud with GoldenGate's feature-rich portfolio. Start with the installation and learn the design concepts and enhanced configuration of GoldenGate 12c. Exploit new 12c features to successfully implement GoldenGate on your enterprise. Dive deep into configuring GoldenGate for high availability, DDL support, and reverse processing. Build fast, secure, robust, scalable technical solutions by tuning data delivery and networks. Finally, enrich your data replication knowledge by learning the troubleshooting tips.
Author : Gavin JT Powell
Publisher : Elsevier
Page : 683 pages
File Size : 43,2 MB
Release : 2004-10-15
Category : Computers
ISBN : 0080479839
Developers and DBAs use Oracle SQL coding on a daily basis, whether for application development, finding problems, fine-tuning solutions to those problems, or other critical DBA tasks. Oracle SQL: Jumpstart with Examples is the fastest way to get started and to quickly locate answers to common (and uncommon) questions. It includes all the basic queries: filtering, sorting, operators, conditionals, pseudocolumns, single row functions, joins, grouping and summarizing, grouping functions, subqueries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions, DML, datatypes (including collections), XML in Oracle, DDL for basic database objects such as tales, views and indexes, Oracle Partitioning, security, and finally PL/SQL. * Each of the hundreds of SQL code examples was tested on a working Oracle 10g database * Invaluable everyday tool that provides an absolute plethora of properly tested examples of Oracle SQL code * Authors have four decades of commercial experience between them as developers and database administrators
Author : Dejan Sarka
Publisher : Packt Publishing Ltd
Page : 607 pages
File Size : 29,19 MB
Release : 2017-03-22
Category : Computers
ISBN : 1786460742
Get the most out of the rich development capabilities of SQL Server 2016 to build efficient database applications for your organization About This Book Utilize the new enhancements in Transact-SQL and security features in SQL Server 2016 to build efficient database applications Work with temporal tables to get information about data stored in the table at any point in time A detailed guide to SQL Server 2016, introducing you to multiple new features and enhancements to improve your overall development experience Who This Book Is For This book is for database developers and solution architects who plan to use the new SQL Server 2016 features for developing efficient database applications. It is also ideal for experienced SQL Server developers who want to switch to SQL Server 2016 for its rich development capabilities. Some understanding of the basic database concepts and Transact-SQL language is assumed. What You Will Learn Explore the new development features introduced in SQL Server 2016 Identify opportunities for In-Memory OLTP technology, significantly enhanced in SQL Server 2016 Use columnstore indexes to get significant storage and performance improvements Extend database design solutions using temporal tables Exchange JSON data between applications and SQL Server in a more efficient way Migrate historical data transparently and securely to Microsoft Azure by using Stretch Database Use the new security features to encrypt or to have more granular control over access to rows in a table Simplify performance troubleshooting with Query Store Discover the potential of R's integration with SQL Server In Detail Microsoft SQL Server 2016 is considered the biggest leap in the data platform history of the Microsoft, in the ongoing era of Big Data and data science. Compared to its predecessors, SQL Server 2016 offers developers a unique opportunity to leverage the advanced features and build applications that are robust, scalable, and easy to administer. This book introduces you to new features of SQL Server 2016 which will open a completely new set of possibilities for you as a developer. It prepares you for the more advanced topics by starting with a quick introduction to SQL Server 2016's new features and a recapitulation of the possibilities you may have already explored with previous versions of SQL Server. The next part introduces you to small delights in the Transact-SQL language and then switches to a completely new technology inside SQL Server - JSON support. We also take a look at the Stretch database, security enhancements, and temporal tables. The last chapters concentrate on implementing advanced topics, including Query Store, columnstore indexes, and In-Memory OLTP. You will finally be introduced to R and how to use the R language with Transact-SQL for data exploration and analysis. By the end of this book, you will have the required information to design efficient, high-performance database applications without any hassle. Style and approach This book is a detailed guide to mastering the development features offered by SQL Server 2016, with a unique learn-as-you-do approach. All the concepts are explained in a very easy-to-understand manner and are supplemented with examples to ensure that you—the developer—are able to take that next step in building more powerful, robust applications for your organization with ease.
Author : Allen B. Downey
Publisher : "O'Reilly Media, Inc."
Page : 251 pages
File Size : 28,79 MB
Release : 2016-05-06
Category : Computers
ISBN : 1491929537
Currently used at many colleges, universities, and high schools, this hands-on introduction to computer science is ideal for people with little or no programming experience. The goal of this concise book is not just to teach you Java, but to help you think like a computer scientist. You’ll learn how to program—a useful skill by itself—but you’ll also discover how to use programming as a means to an end. Authors Allen Downey and Chris Mayfield start with the most basic concepts and gradually move into topics that are more complex, such as recursion and object-oriented programming. Each brief chapter covers the material for one week of a college course and includes exercises to help you practice what you’ve learned. Learn one concept at a time: tackle complex topics in a series of small steps with examples Understand how to formulate problems, think creatively about solutions, and write programs clearly and accurately Determine which development techniques work best for you, and practice the important skill of debugging Learn relationships among input and output, decisions and loops, classes and methods, strings and arrays Work on exercises involving word games, graphics, puzzles, and playing cards
Author : Avi Wigderson
Publisher : Princeton University Press
Page : 434 pages
File Size : 10,6 MB
Release : 2019-10-29
Category : Computers
ISBN : 0691189137
An introduction to computational complexity theory, its connections and interactions with mathematics, and its central role in the natural and social sciences, technology, and philosophy Mathematics and Computation provides a broad, conceptual overview of computational complexity theory—the mathematical study of efficient computation. With important practical applications to computer science and industry, computational complexity theory has evolved into a highly interdisciplinary field, with strong links to most mathematical areas and to a growing number of scientific endeavors. Avi Wigderson takes a sweeping survey of complexity theory, emphasizing the field’s insights and challenges. He explains the ideas and motivations leading to key models, notions, and results. In particular, he looks at algorithms and complexity, computations and proofs, randomness and interaction, quantum and arithmetic computation, and cryptography and learning, all as parts of a cohesive whole with numerous cross-influences. Wigderson illustrates the immense breadth of the field, its beauty and richness, and its diverse and growing interactions with other areas of mathematics. He ends with a comprehensive look at the theory of computation, its methodology and aspirations, and the unique and fundamental ways in which it has shaped and will further shape science, technology, and society. For further reading, an extensive bibliography is provided for all topics covered. Mathematics and Computation is useful for undergraduate and graduate students in mathematics, computer science, and related fields, as well as researchers and teachers in these fields. Many parts require little background, and serve as an invitation to newcomers seeking an introduction to the theory of computation. Comprehensive coverage of computational complexity theory, and beyond High-level, intuitive exposition, which brings conceptual clarity to this central and dynamic scientific discipline Historical accounts of the evolution and motivations of central concepts and models A broad view of the theory of computation's influence on science, technology, and society Extensive bibliography
Author : Thomas Kyte
Publisher : Apress
Page : 1328 pages
File Size : 26,73 MB
Release : 2010-11-16
Category : Computers
ISBN : 9781430212799
* A proven best-seller by the most recognized Oracle expert in the world. * The best Oracle book ever written. It defines what Oracle really is, and why it is so powerful. * Inspired by the thousands of questions Tom has answered on his http://asktom.oracle.com site. It tackles the problems that developers and DBAs struggle with every day. * Provides everything you need to know to program correctly with the database and exploit its feature-set effectively.
Author : Byron Ellis
Publisher : John Wiley & Sons
Page : 432 pages
File Size : 15,94 MB
Release : 2014-06-23
Category : Computers
ISBN : 1118838025
Construct a robust end-to-end solution for analyzing and visualizing streaming data Real-time analytics is the hottest topic in data analytics today. In Real-Time Analytics: Techniques to Analyze and Visualize Streaming Data, expert Byron Ellis teaches data analysts technologies to build an effective real-time analytics platform. This platform can then be used to make sense of the constantly changing data that is beginning to outpace traditional batch-based analysis platforms. The author is among a very few leading experts in the field. He has a prestigious background in research, development, analytics, real-time visualization, and Big Data streaming and is uniquely qualified to help you explore this revolutionary field. Moving from a description of the overall analytic architecture of real-time analytics to using specific tools to obtain targeted results, Real-Time Analytics leverages open source and modern commercial tools to construct robust, efficient systems that can provide real-time analysis in a cost-effective manner. The book includes: A deep discussion of streaming data systems and architectures Instructions for analyzing, storing, and delivering streaming data Tips on aggregating data and working with sets Information on data warehousing options and techniques Real-Time Analytics includes in-depth case studies for website analytics, Big Data, visualizing streaming and mobile data, and mining and visualizing operational data flows. The book's "recipe" layout lets readers quickly learn and implement different techniques. All of the code examples presented in the book, along with their related data sets, are available on the companion website.
