Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

SQL (Computer program language) --- Querying (Computer science) --- Data mining. --- Microsoft Excel (Computer file)

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

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,...

PL/SQL (Computer program language) --- Database design. --- Data base design --- System design --- Procedural Language/SQL --- Query languages (Computer science) --- Oracle (Computer file) --- Oracle7.3 --- Oracle 7.3 --- Personal Oracle7 --- Personal Oracle 7

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

The latest guide to using QGIS 2.14 to create great maps and perform geoprocessing tasks with ease About This Book Learn how to work with various data and create beautiful maps using this easy-to-follow guide. Give a touch of professionalism to your maps both for functionality and look and feel with the help of this practical guide. A progressive hands-on guide that builds on a geo-spatial data and adds more reactive maps by using geometry tools. Who This Book Is For This book is great for users, developers, and consultants who know the basic functions and processes of GIS and want to learn to use QGIS to analyze geospatial data and create rich mapping applications. If you want to take advantage of the wide range of functionalities that QGIS offers, then this is the book for you. What You Will Learn Install QGIS and get familiar with the user interface Load vector and raster data from files, databases, and web services Create, visualize, and edit spatial data Perform geoprocessing tasks and automate them Create advanced cartographic outputs Design great print maps Expand QGIS using Python In Detail QGIS is a user-friendly open source geographic information system (GIS) that runs on Linux, Unix, Mac OS X, and Windows. The popularity of open source geographic information systems and QGIS in particular has been growing rapidly over the last few years. Learning QGIS Third Edition is a practical, hands-on guide updated for QGIS 2.14 that provides you with clear, step-by-step exercises to help you apply your GIS knowledge to QGIS. Through clear, practical exercises, this book will introduce you to working with QGIS quickly and painlessly. This book takes you from installing and configuring QGIS to handling spatial data to creating great maps. You will learn how to load and visualize existing spatial data and create data from scratch. You will get to know important plugins, perform common geoprocessing and spatial analysis tasks and automate them with Processing. We will cover how to achieve great cartographic output and print maps. Finally, you will learn how to extend QGIS using Python and even create your own plugin. Style and approach A step by step approach to explain concepts of Geospatial map with the help of real life examples

Cartography --- Geospatial data. --- Geodatabases. --- Open source software. --- Cartographie --- Données géospatiales --- Géographie --- Logiciels libres --- Computer programs --- Logiciels --- Bases de données --- Digital mapping. --- Computer programs. --- Computer cartography --- Computer mapping --- Digitized mapping --- Mapping programs --- Mapping software --- Geographic information systems --- SQL (Computer program language) --- Structured Query Language (Computer program language) --- Declarative programming languages --- Query languages (Computer science)

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

SQL (Computer program language) --- Database management. --- Data base management --- Data services (Database management) --- Database management services --- DBMS (Computer science) --- Generalized data management systems --- Services, Database management --- Systems, Database management --- Systems, Generalized database management --- Electronic data processing --- Structured Query Language (Computer program language) --- Declarative programming languages --- Query languages (Computer science) --- iOS (Electronic resource) --- i Operating system --- iOS 4.0 --- iOs 5 --- iOS operating system --- iPhone OS

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

This book is an introduction and deep-dive into the many uses of dynamic SQL in Microsoft SQL Server. Dynamic SQL is key to large-scale searching based upon user-entered criteria. It’s also useful in generating value-lists, in dynamic pivoting of data for business intelligence reporting, and for customizing database objects and querying their structure. Executing dynamic SQL is at the heart of applications such as business intelligence dashboards that need to be fluid and respond instantly to changing user needs as those users explore their data and view the results. Yet dynamic SQL is feared by many due to concerns over SQL injection attacks. Reading Dynamic SQL: Applications, Performance, and Security is your opportunity to learn and master an often misunderstood feature, including security and SQL injection. All aspects of security relevant to dynamic SQL are discussed in this book. You will learn many ways to save time and develop code more efficiently, and you will practice directly with security scenarios that threaten companies around the world every day. Dynamic SQL: Applications, Performance, and Security helps you bring the productivity and user-satisfaction of flexible and responsive applications to your organization safely and securely. Your organization’s increased ability to respond to rapidly changing business scenarios will build competitive advantage in an increasingly crowded and competitive global marketplace. Discusses many applications of dynamic SQL, both simple and complex. Explains each example with demos that can be run at home and on your laptop. Helps you to identify when dynamic SQL can offer superior performance. Pays attention to security and best practices to ensure safety of your data.

Computer Science --- Engineering & Applied Sciences --- SQL (Computer program language) --- Computer programming. --- Computer security. --- Database management. --- Data base management --- Data services (Database management) --- Database management services --- DBMS (Computer science) --- Generalized data management systems --- Services, Database management --- Systems, Database management --- Systems, Generalized database management --- Computer privacy --- Computer system security --- Computer systems --- Computers --- Cyber security --- Cybersecurity --- Electronic digital computers --- Security of computer systems --- Electronic computer programming --- Electronic data processing --- Programming (Electronic computers) --- Structured Query Language (Computer program language) --- Security measures --- Programming --- Protection of computer systems --- Protection --- Computer science. --- Programming languages (Electronic computers). --- Computer Science. --- Database Management. --- Systems and Data Security. --- Programming Techniques. --- Programming Languages, Compilers, Interpreters. --- Data protection --- Security systems --- Hacking --- Coding theory --- Computer languages --- Computer program languages --- Computer programming languages --- Machine language --- Languages, Artificial --- Informatics --- Science --- Declarative programming languages --- Query languages (Computer science)