Your cart is empty
Maybe you got Access as part of Microsoft Office and wonder what it can do for you and your household; maybe you're a small business manager and don't have a techie on staff to train the office in Microsoft Access. Regardless, you want to quickly get your feet wet - but not get in over your head - and "Access 2003 for Starters: The Missing Manual" is the book to make it happen. Far more than a skimpy introduction, but much less daunting than a weighty tech book, "Access 2003 for Starters: The Missing Manual" demystifies databases and explains how to design and create them with ease. It delivers everything you need - and nothing you don't - to use Access right away. It's your expert guide to the Access features that are most vital and most useful, and it's your trusted advisor on the more in-depth features that are best saved for developers and programmers. Access is sophisticated and powerful enough for professional developers, but easy and practical enough for everyday users like you. This Missing Manual explains all the major features of Access 2003, including designing and creating databases, organizing and filtering information, and generating effective forms and reports. Bestselling authors, database designers, and programmers Scott Palmer, Ph.D., and Kate Chase are your guides for putting the world's most popular desktop data management program to work. Their clear explanations, step-by-step instructions, plenty of illustrations, and timesaving advice help you get up to speed quickly and painlessly. Whether you're just starting out or you know you've been avoiding aspects of the program and missing out on much of what it can do, this friendly, witty book will gently immerse you in Microsoft Access. Keep it handy, as you'll undoubtedly refer to it again and again.
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Write Powerful SQL Statements and PL/SQL Programs Learn how to access Oracle databases through SQL statements and construct PL/SQL programs. Oracle Database 12c SQL offers complete coverage of the latest database features and techniques. Find out how to write SQL statements to retrieve and modify database information, use SQL*Plus and SQL Developer, work with database objects, write PL/SQL programs, use performance optimization techniques, incorporate XML, and more. This Oracle Press guide contains everything you need to know to master SQL. Use SQL statements to access an Oracle database Work with SQL*Plus and SQL Developer Write PL/SQL programs Create tables, sequences, indexes, views, and triggers Design advanced queries containing complex calculations Create database objects to handle abstract data Use date, time stamp, and time interval data types Establish user roles and privileges Handle multimedia files using large objects Tune SQL statements to make them execute faster Generate, process, and store XML data Master the very latest Oracle Database 12c features Code examples in the book are available for download.
This new, advanced supplement to the 16-group program described in The Adolescent Self provides advanced exercises and techniques for adolescents who have mastered those taught in the original PRISM Workbook.
Write SQL statements that are more powerful, simpler, and faster using Oracle SQL and its full range of features. This book provides a clearer way of thinking about SQL by building sets, and provides practical advice for using complex features while avoiding anti-patterns that lead to poor performance and wrong results. Relevant theories, real-world best practices, and style guidelines help you get the most out of Oracle SQL. Pro Oracle SQL Development is for anyone who already knows Oracle SQL and is ready to take their skills to the next level. Many developers, analysts, testers, and administrators use Oracle databases frequently, but their queries are limited because they do not have the knowledge, experience, or right environment to help them take full advantage of Oracle's advanced features. This book will inspire you to achieve more with your Oracle SQL statements through tips for creating your own style for writing simple, yet powerful, SQL. It teaches you how to think about and solve performance problems in Oracle SQL, and covers advanced topics and shows you how to become an Oracle expert. What You'll Learn Understand the power of Oracle SQL and where to apply it Create a database development environment that is simple, scalable, and conducive to learning Solve complex problems that were previously solved in a procedural language Write large Oracle SQL statements that are powerful, simple, and fast Apply coding styles to make your SQL statements more readable Tune large Oracle SQL statements to eliminate and avoid performance problems Who This Book Is For Developers, testers, analysts, and administrators who want to harness the full power of Oracle SQL to solve their problems as simply and as quickly as possible. For traditional database professionals the book offers new ways of thinking about the language they have used for so long. For modern full stack developers the book explains how a database can be much more than simply a place to store data.
Advanced data management has always been at the core of efficient database and information systems. Recent trends like big data and cloud computing have aggravated the need for sophisticated and flexible data storage and processing solutions. This book provides a comprehensive coverage of the principles of data management developed in the last decades with a focus on data structures and query languages. It treats a wealth of different data models and surveys the foundations of structuring, processing, storing and querying data according these models. Starting off with the topic of database design, it further discusses weaknesses of the relational data model, and then proceeds to convey the basics of graph data, tree-structured XML data, key-value pairs and nested, semi-structured JSON data, columnar and record-oriented data as well as object-oriented data. The final chapters round the book off with an analysis of fragmentation, replication and consistency strategies for data management in distributed databases as well as recommendations for handling polyglot persistence in multi-model databases and multi-database architectures. While primarily geared towards students of Master-level courses in Computer Science and related areas, this book may also be of benefit to practitioners looking for a reference book on data modeling and query processing. It provides both theoretical depth and a concise treatment of open source technologies currently on the market.
Building on your existing SQL skills, this book teaches you how to apply useful jQuery techniques to applications developed using the Oracle Application Express (APEX) development tool. Pro jQuery in Oracle Application Express covers the fundamentals you need to start enhancing your applications, with some practical examples that you'll want in your own applications tomorrow. jQuery is a framework already utilized by APEX, and by learning the basics of jQuery you can leverage the flexible dynamic actions provide and see your applications raise the bar. Discover why you should embrace HTML5, CSS, and jQuery library capabilities, and how they can enhance the user experience. Oracle Application Express is a mature, browser-based, rapid-development environment with a strong community base around the #orclapex tag. jQuery is a language for the browser, with it you can treat your web page as if it were a database, interacting with a range of features and functions that can make you into a more constructive, more efficient developer. Exemplifies how productive APEX, CSS, and jQuery can be Transforms your PL/SQL skills to CSS and jQuery Provides jQuery snippets to enhance your application UX
MySQL's popularity has brought a flood of questions about how to solve specific problems, and that's where this cookbook is essential. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out examples, and clear, concise explanations for programmers who don't have the time (or expertise) to solve MySQL problems from scratch. Ideal for beginners and professional database and web developers, this updated third edition covers powerful features in MySQL 5.6 (and some in 5.7). The book focuses on programming APIs in Python, PHP, Java, Perl, and Ruby. With more than 200+ recipes, you'll learn how to: Use the mysql client and write MySQL-based programs Create, populate, and select data from tables Store, retrieve, and manipulate strings Work with dates and times Sort query results and generate summaries Use stored routines, triggers, and scheduled events Import, export, validate, and reformat data Perform transactions and work with statistics Process web input, and generate web content from query results Use MySQL-based web session management Provide security and server administration
Expert Oracle SQL: Optimization, Deployment, and Statistics is about optimizing individual SQL statements, especially on production database systems. This Oracle-specific book begins by assuming you have already identified a particular SQL statement and are considering taking steps to improve its performance. The book describes a systematic process by which to diagnose a problem statement, identify a fix, and to implement that fix safely in a production system. You'll learn not only to improve performance when it is too slow, but also to stabilize performance when it is too variable. You'll learn about system statistics and how the Cost-Based Optimizer uses them to determine a suitable execution plan for a given statement. That knowledge provides the foundation from which to identify the root cause, and to stabilize and improve performance. Next after identifying a problem and the underlying root cause is to put in place a solution. Expert Oracle SQL: Optimization, Deployment, and Statistics explains how to apply various remedies such as changing the SQL statement, adding hints, changing the physical design, and more, and how they can be brought to bear on fixing a problem once and for all. Rolling a change out smoothly is an important topic when dealing with tuning and optimization. Expert Oracle SQL: Optimization, Deployment, and Statistics does not let you down in this critical area. The book contains two chapters of good information from an experienced professional on how to safely deploy changes into production so that your systems remaining running and available throughout the deployment process. Describes a systematic approach to tuning Oracle SQL Explains how things are supposed to work, what can go wrong, and how to fix it Takes you through the steps needed to stabilize performance in your production systems
Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. This second edition is newly-updated to cover the 2016 editions of both SQL Server and Windows Server. Also in this edition is all-new content on troubleshooting and metadata. The book provides a solid and accurate understanding of how to implement systems requiring consistent and continuous uptime, as well as how to troubleshoot those systems in order to keep them running an reliable. Begin with an introduction to high-availability and disaster recovery concepts such as Recovery Point Objectives (RPOs), Recovery Time Objectives (RTO), availability levels, and the cost of downtime. Then move into detailed coverage of implementing and configuring the AlwaysOn feature set in order to meet the business objectives set by your organization. SQL Server AlwaysOn Revealed offers real-world advice on how to build and configure the most appropriate topology to meet the high-availability and disaster recovery requirements you are faced with. Content includes strong coverage on implementing clusters, on building AlwaysOn failover clustered instances, and on configuring AlwaysOn Availability Groups. This is a practical and hand-on book to get you started quickly in using one of the most talked-about SQL Server feature sets. Teaches you to build HA and DR solutions using the AlwaysOn feature set Provides real-world advice on configuration and performance considerations Demonstrates administrative techniques for the AlwaysOn feature set What You Will Learn Understand high availability and disaster recovery in SQL Server 2016 Build and configure a Windows Cluster Create and configure an AlwaysOn failover clustered instance Implement AlwaysOn Availability Groups and appropriately configure them Administer AlwaysOn technologies post implementation Troubleshoot and resolve problems with misbehaving systems Who This Book Is For Database administrators interested in growing their knowledge and skills in Microsoft SQL Server's high-availability and disaster recovery feature set.
Troubleshooting Oracle Performance, 2nd Edition is your systematic guide to diagnosing and resolving performance problems in database-backed applications involving Oracle's database engine. Christian Antognini brings a decade and a half experience to his topic. His first edition is one of the most well-respected books in its field. This second edition has been rigorously updated to cover the latest developments in Oracle Database 11g Release 2 through Oracle Database 12c. What do you do when your database application isn't running fast enough? You troubleshoot, of course. Finding the slow part of an application is often the easy part of the battle. It's finding a solution that's difficult. Troubleshooting Oracle Performance, 2nd Edition helps by providing a systematic approach to addressing the underlying causes of poor database application performance. The author freely shares his experience while explaining the underlying foundations of how SQL statements are executed by the Oracle database engine. You'll be able to draw a solid foundation of theory and shared experience as you face head-on the performance challenges in your daily work.* Written for developers by an application developer who has learned by doing * Gives a systematic approach to solving database application performance problems * Helps you plan for performance as you would for any other application requirement What you'll learn * Systematically identify performance problems * Configure the query optimizer to meet performance goals * Read and recognize inefficient execution plans * Minimize the impact of parsing upon performance * Optimize data access, joins, and the physical design of your database * Improve performance through parallel processing, materialized views, and result caching * Apply SQL tuning techniques such as hints, SQL profiles, stored outlines, and SQL plan baselines * Reduce inefficiencies from too much procedural code Who this book is for Troubleshooting Oracle Performance, Second Edition is targeted at application developers and database administrators involved in troubleshooting performance problems in Oracle-based applications.
If you're in charge of database administration, developing database software, or looking for database solutions for your company, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies can help you get a handle on this extremely popular relational database management system. Here you'll find what's new in the latest version; how to choose and install the right variation for your needs; how to monitor, maintain, and protect your data; and what it takes to keep your database healthy. You'll discover how to: Build and maintain tables Design a database and communicate with it Retrieve, analyze, and report data Build solid, robust database applications Use the SQL Server Optimizer and Query Designer Navigate SQL Server with Visual Studio Develop useful reports with the Report Builder and Report Designer Create Business Intelligence solutions with Business Intelligence Development Studio Configure your server and perform major administrative tasks To help you quickly find what you need, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies is divided into nine minibooks: Essential Concepts Designing and Using Databases Interacting With Your Data Database Programming Reporting Services Analysis Services Performance Tips and Tricks Database Administration Appendixes Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies gets you started, helps you solve problems, and will even answer your questions down the road!
You don't have to be a techie to use FileMaker Pro 12, but you do need to know what you're doing. With this crystal-clear guide, you'll learn how to create a powerful database that lets you do almost anything with your data. Whether you're running a business, printing a catalog, or planning a wedding, you'll learn how to customize your database and put it to work.
The important stuff you need to know: Get started. Tour FileMaker Pro's features and create your first database in minutes.Catalog your data. View, sort, and shape information in dozens of ways.Create professional documents. Publish reports, invoices, and other documents with ease.Harness processing power. Use calculations and scripts to crunch numbers, search text, and automate tasks.Add visual power and clarity. Create colorful charts to illustrate and summarize your data.Think like a developer. Dive into the high-level features of FileMaker Pro Advanced.
Now 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
Practical Oracle Database Appliance is a hands-on book taking you through the components and implementation of the Oracle Database Appliance. Learn about architecture, installation, configuration, and reconfiguration. Install and configure the Oracle Database Appliance with confidence. Make the right choices between the various configurations in order to realize your performance requirements. Manage and monitor the appliance to meet business requirements. Protect your data through proper backup and recovery procedures. Oracle Database is one of the most relied-up databases in industry. For many years Oracle Database was a software product that had to be installed and configured at no small expense. The Oracle Database Appliance makes Oracle Database into a plug-and-play proposition: Plug the appliance into the wall socket, and turn it on. That's it. You have a running database server. This book takes you through that beginning point and beyond, helping you to realize in your own organization the ease of deployment and management represented by the appliance. Covers the Oracle Database Appliance from architecture through configuration. Provides a technical resource for system- and database administrators. Examines practical use cases for the Oracle Database Appliance.
Benchmark Series: Microsoft Access 2016 Level 2 builds students' intermediate-to-advanced skills in Access 2016, and helps develop critical thinking and decision-making skills. Key Features Case study assessments of chapter and unit levels test students' abilities to solve problems independently. Projects-based approach creates a realistic context for learning practical skills.
Benchmark Series: Microsoft Access 2016 Level 1 builds students' introductory skills in Access 2016, and helps develop critical thinking and decision-making skills. Key Features Case study assessments of chapter and unit levels test students' abilities to solve problems independently. Projects-based approach creates a realistic context for learning practical skills.
As Microsoft's bestselling database manager, SQL Server is highly flexible and customizable, and has excellent support--the 2008 version offers several significant new capabilities. This book offers accurate and expert coverage on the updates to SQL Server 2008 such as its enhanced security; the ability to encrypt an entire database, data files, and log files without the need for application changes; a scalable infrastructure that can manage reports and analysis of any size and complexity; and its extensive performance data collection.
Beginning Oracle Application Express 4.2introduces version 4.2 of the popular and productive Oracle Application Express development platform.Called APEX for short, the platform enables rapid and easy development of web-based applications that make full use of Oracle Database. The release of APEX 4.2 brings extensive new Flash and HTML 5 charting capabilities, enhanced themes for mobile applications usable from phones and tablets, RESTful web services support, enhanced application packaging, and the many redesigned wizards give a new and fresh feel to the user interface. Whether you're new to Oracle or an old hand who's yet to test the waters of APEX, Beginning Oracle Application Express 4.2 introduces the processes and best practices you'll need to become proficient with APEX. The book shows off the programming environment, the utilities and tools available, and then continues by walking through the process of building a working system from the ground up. All code is documented and explained so that those new to the languages will not be lost. After reading this book, power users and programmers alike can quickly put together robust and scalable applications for use by one person, by a department, by an entire company. Covers brand-new functionality in APEX 4.2 Provides fully documented and explained example code Guides you through creating a working and fully deployable application What you'll learn Design, code, and troubleshoot APEX applications Create forms and generate reports Create charts using Flash and HTML 5 Apply best-practices to database and application design Create intuitive navigation that inspires confidence among users Secure your applications from outside attack Deploy applications for one, a dozen, or hundreds of users Choose between desktop and mobile user interfaces for deployed applications Who this book is for Beginning Oracle Application Express 4.2is for programmers and power users wanting to create rich, data-centric applications that are web-based, and that rest on Oracle's industry-leading database technology. Table of Contents An Introduction to APEX 4.0 A Developer's Overview Identifying the Problem and Designing the Solution SQL Workshop Application and Navigational Components Forms & ReportsThe Basics Forms & ReportsAdvanced Programatic Elements Security Application Deployment Understanding Websheets AWebSheets Example Extended Developer Tools Managing Workspaces Team Development Dyramic Actions
Prominent FileMaker developers Susan Prosser and Stuart Gripman know how to work magic with FileMaker Pro, and they share their knowledge in this bestselling book. You'll learn how to build a database and organize all of your information quickly and efficiently.
Create queries that make forms and reports useful
If you have large quantities of data in a Microsoft Access database, and need to study that data in depth, this book is a data cruncher's dream. "Access Data Analysis Cookbook" offers practical recipes to solve a variety of common problems that users have with extracting Access data and performing calculations on it. Each recipe includes a discussion on how and why the solution works. Whether you use Access 2007 or an earlier version, this book will teach you new methods to query data, different ways to move data in and out of Access, how to calculate answers to financial and investment issues, and more. Learn how to apply statistics to summarize business information, how to jump beyond SQL by manipulating data with VBA, how to process dates and times, and even how to reach into the Excel data analysis toolkit. The recipes demonstrate ways to: develop basic and sophisticated queries; apply aggregate functions, custom functions, regular expressions, and crosstabs; apply queries to perform non-passive activities such as inserting, updating, and deleting data; create and manipulate tables and queries programmatically; manage text-based data, including methods to isolate parts of a string and ways to work with numbers that are stored as text; use arrays, read and write to the Windows registry, encrypt data, and use transaction processing; and, use the FileSystemObject, use XML with XSLT, communicate with SQL Server, and exchange data with other Office products. They also demonstrate ways to: find answers from time-based data, such as how to add time, count elapsed time, work with leap years, and how to manage time zones in your calculations; deal with business and finance problems, including methods for calculating depreciation, loan paybacks, and Return on Investment (ROI); and, explore statistical techniques, such as frequency, variance, kurtosis, linear regression, combinations and permutations. "Access Data Analysis Cookbook" is a one-stop-shop for extracting nuggets of valuable information from your database, and anyone with Access experience will benefit from these tips and techniques, including seasoned developers. If you want to use your data, and not just store it, you'll find this guide indispensable.
You may like...
Using Excel for Business and Financial…
Danielle Stein Fairhurst Paperback R1,463 Discovery Miles 14 630
Big Data For Dummies
Judith S. Hurwitz, Alan Nugent, … Paperback
Oracle Exalogic Elastic Cloud Handbook
Tom Plunkett, Tj Palazzolo, … Paperback
New Perspectives on Microsoft (R) Access…
Joseph Adamski, Kathy Finnegan Paperback
Portable DBA Oracle
Robert Freeman Paperback
Oracle Business Intelligence 11g…
Mark Rittman Paperback
Problem-Solving Cases in Microsoft (R…
Ellen Monk, Joseph Brady, … Paperback
Access 2019 Bible
Michael Alexander, Richard Kusleika Paperback (1)
Oracle Database 10g RMAN Backup…
Matthew Hart, Robert Freeman Paperback
Oracle Business Process Management Suite…
Manoj Das, Manas Deb, … Paperback