This book is the definitive guide to SQL*Plus, Oracle's interactive query tool. Despite the wide availability and usage of SQL*Plus, few developers and DBAs know how powerful it really is. This book introduces SQL*Plus, provides a syntax quick reference, and describes how to write and execute script files, generate ad hoc reports, extract data from the database, query the data dictionary tables, use the SQL*Plus administrative features (new in Oracle8i), and much more.

Oracle's built-in packages dramatically extend the power of the PL/SQL language, but few developers know how to use them effectively. This book is a complete reference to all of the built-ins, including those new to Oracle8. the enclosed diskette includes an online tool that provides easy access to the many files of source code and documentation developed by the authors.

"The Complete HyperCard Handbook" is your best choice for learning and mastering HyperCard whether you are a professional or a beginner.

Macintosh products expert Danny Goodman introduces HyperCard 2.2's powerful new features to you.

AppleScript support; Improved user interface design elements; Enhanced HyperTalk scripting language; Convenient Color Tools for applications design; Creating double-clickable applications

And shares his experience: using HyperCard for multimedia applications; debugging HyperTalk scripts; applying Apple events; using AppleScript with a multiuser FileMaker database

This book looks thoroughly at the field of Oracle relational database design, an often neglected area of Oracle, but one that has an enormous impact on the ultimate power and performance of a system. Focuses on both database and code design, including such special design areas as data models, denormalization, the use of keys and indexes, temporal data, special architectures (client/server, distributed database, parallel processing), and data warehouses.

Learn effective and scalable database design techniques in SQL Server 2019 and other recent SQL Server versions. This book is revised to cover additions to SQL Server that include SQL graph enhancements, in-memory online transaction processing, temporal data storage, row-level security, and other design-related features. This book will help you design OLTP databases that are high-quality, protect the integrity of your data, and perform fast on-premises, in the cloud, or in hybrid configurations. Designing an effective and scalable database using SQL Server is a task requiring skills that have been around for well over 30 years, using technology that is constantly changing. This book covers everything from design logic that business users will understand to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, author Louis Davidson shows you how to "get it right" in SQL Server database design and lay a solid groundwork for the future use of valuable business data. What You Will Learn Develop conceptual models of client data using interviews and client documentation Implement designs that work on premises, in the cloud, or in a hybrid approach Recognize and apply common database design patterns Normalize data models to enhance integrity and scalability of your databases for the long-term use of valuable data Translate conceptual models into high-performing SQL Server databases Secure and protect data integrity as part of meeting regulatory requirements Create effective indexing to speed query performance Understand the concepts of concurrency Who This Book Is For Programmers and database administrators of all types who want to use SQL Server to store transactional data. The book is especially useful to those wanting to learn the latest database design features in SQL Server 2019 (features that include graph objects, in-memory OLTP, temporal data support, and more). Chapters on fundamental concepts, the language of database modeling, SQL implementation, and the normalization process lay a solid groundwork for readers who are just entering the field of database design. More advanced chapters serve the seasoned veteran by tackling the latest in physical implementation features that SQL Server has to offer. The book has been carefully revised to cover all the design-related features that are new in SQL Server 2019.

Fill the gap between planning and doing with SSIS 2014 The 2014 release of Microsoft's SQL Server Integration Services provides enhancements for managing extraction, transformation, and load operations, plus expanded in-memory capabilities, improved disaster recovery, increased scalability, and much more. The increased functionality will streamline your ETL processes and smooth out your workflow, but the catch is that your workflow must change. New tools come with new best practices, and Professional Microsoft SQL Server 2014 Integration Services will keep you ahead of the curve. SQL Server MVP Brian Knight is the most respected name in the business, and your ultimate guide to navigating the changes to use Microsoft SQL Server Integration Services 2014 to your utmost advantage. * Implement new best practices for effective use of SSIS * Work through tutorials for hands-on learning of complex techniques * Read case studies that illustrate the more advanced concepts * Learn directly from the foremost authority on SSIS SQL Server Integration Services is a complex tool, but it's the lifeblood of your work. You need to know it inside out, and you must understand the full potential of its capabilities in order to use it effectively. You need to make sure the right architecture is in place. Professional Microsoft SQL Server 2014 Integration Services is your roadmap to understanding SSIS on a fundamental level, and setting yourself up for success.

This volume is for those interested in methods and tools for improving the development of educational hypermedia on a large scale. Interactive multimedia or hypermedia is one of the technologies which is most influencing the educating and training of people. This book shows how coordination and reuse pertain to the development of courseware, which provides new opportunities and challenges to researchers, practitioners, and designers from disciplines such as computer science, education, library science, communication and psychology.

SQL is the way to develop, program, and use database applications. SQL-92 is a major advance over earlier versions, offering the first complete SQL language. DB programmers will have the advantage of knowing that applications written in SQL-92 will be portable to all hardware platforms for many years to come. As the editor of the new standard, Jim Melton is an authority on the language and its new features. Using a highly readable, conversational style, the authors clearly present the power of SQL. They describe practical methods of using SQL to solve problems, advanced SQL query expressions, dynamic SQL, transaction models, and database design. Beginning with a tutorial on basic relational database concepts, subsequent chapters develop SQL and clarify the differences between SQL-89 and SQL-92. Throughout, a retail video and music store is used as an example that develops with the SQL presentation. The book is enhanced by a complete dynamic SQL example, coverage of international character sets, and a look at future generations of SQL. Whether you're a newcomer to SQL or an experienced programmer using PCs, workstations, mini- or mainframes, Understanding the New SQL is an essential resource for current and future implementation of SQL.

The visual way to get up to speed on Access 2010

It's one thing to gain access to Access. It's another thing entirely to figure out how to do all the things you want to do in Access, because the software is not all that intuitive. This full-color guide clearly shows you how to get the most out of Access 2010, including how to enter new records; create, edit, and design tables and forms; organize, analyze, and share data; generate concise reports; and much more.

With pages of step-by-step instructions, graphics, and helpful advice, this is the visual learner's Access book-keep this on your desk and flip to what you need, any time Explores the very latest features, functions, and tools of Access 2010, a database software tool that is part of the new Microsoft Office 2010Teaches you how to enter new records and create, edit, and design tables and formsExplains how to organize, analyze, and share data; generate concise reports; add smart tags to tables, save backup copies of your data; and moreDemonstrates through step-by-step instructions and numerous, full-color screen shots and graphics, so you can see exactly how to perform tasks

This unparalleled book contains everything you need to know to use Access 2010 effectively.

Dieses Buch erlautert Theorie und Praxis zu relationalen Datenbanken Was sind relationale Datenbanken? Die Antwort darauf geben die theoretischen Grundlagen und Praxisbeispiele in diesem Buch. Zunachst erlautert Thomas Studer die mathematisch prazise Darstellung des relationalen Modells und die relationale Algebra. Daneben widmet er sich der Datenbanksprache SQL und schafft damit den Praxisbezug. Die zahlreichen Beispiele auf Basis der open-source Datenbank PostgreSQL erleichtern die Anwendung. Dieses Buch erklart die grundlegenden Prinzipien des Schemaentwurfs und Normalformen fundiert und praxisnah und verbindet die relationale Datenbanktheorie mit Datenbankdesign. Studer hat aktuelle Entwicklungen im Blick Die vorliegende Auflage ist umfassend aktualisiert und dem aktuellen Kenntnisstand angepasst. Studer widmet sich in diesem Buch den folgenden Teilaspekten relationaler Datenbanken: Logische und physische Query-Optimierung Isolation von serializable Snapshots Zerlegung der dritten Normalform in die Boyce-Codd Normalform Rollen und Berechtigungen SQL als Sprache zur Datendefinition und Datenmanipulation Sicherheitsrichtlinien auf Zeilenebene Durch die nachhaltige Verbindung von Theorie und Praxis eignet sich das Buch "Relationale Datenbanken" fur: Studierende aus den Bereichen (Wirtschafts-)Informatik Praktiker wie Softwareentwickler, Systemadministratoren oder Fachinformatiker Besuchen Sie uns online und entdecken Sie die zahlreichen Begleitmaterialien zu diesem Buch, die alle frei zuganglich sind.

Prepare for Microsoft Exam 70-768-and help demonstrate your real-world mastery of Business Intelligence (BI) solutions development with SQL Server 2016 Analysis Services (SSAS), including modeling and queries. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: * Design a multidimensional BI semantic model * Design a tabular BI semantic model * Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX) * Configure and maintain SSAS This Microsoft Exam Ref: * Organizes its coverage by exam objectives * Features strategic, what-if scenarios to challenge you * Assumes you are a database or BI professional with experience creating models, writing MDX or DAX queries, and using SSAS

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. Maximize Oracle Exadata CapabilitiesLeverage all of the powerful features available in the Oracle Exadata Database Machine using the proven techniques inside this Oracle Press guide. Written by Oracle experts, Achieving Extreme Performance with Oracle Exadata shows you how to take full advantage of this complete, optimized package of software, servers, and storage. Best practices for enterprise deployments, high availability, administration, backup and recovery, data warehousing, online transaction processing, consolidation, and migration are included in this authoritative resource. Take advantage of the tightly integrated hardware and software in the Oracle Exadata Database Machine Work with Oracle Exadata software features, including Smart Scans, Oracle Exadata Hybrid Columnar Compression, storage indexes, Oracle Exadata Smart Flash Cache, and I/O Resource Manager Understand Oracle Exadata Database Machine balanced hardware architecture Architect, administer, and monitor Oracle Exadata Storage Servers Deploy data warehouses on the Oracle Exadata Database Machine Run online transaction processing (OLTP) workloads on the Oracle Exadata Database Machine Consolidate databases with and migrate databases to the Oracle Exadata Database Machine

Combining theory with everyday practicality, this definitive volume is packed with the up-to-date information, new features, and explanations you need to get the very most out of SQL and its latest standard. The book is unique in that every chapter highlights how the new SQL standard applies to the three major databases, Oracle 11g, IBM DB2 9.5, and Microsoft SQL Server 2008. The result is a comprehensive, useful, and real-world reference for all SQL users, from beginners to experienced developers.

Master Oracle Database 12c Release 2's powerful In-Memory option Maximize database performance and dramatically cut transaction processing time using Oracle Database 12c Release 2's In-Memory feature and the detailed instruction and best practices offered in this Oracle Press guide. You will discover how to exponentially improve efficiency and enable smarter, faster, more informed business decisions enterprise-wide. Oracle Database 12c Release 2 In-Memory: Tips and Techniques for Maximum Performance starts by teaching, step-by-step, how to configure the software and construct In-Memory enabled databases. From there, you will discover how to deliver optimized analytics, use In-Memory Advisor, effectively secure mission-critical data, and distribute real-time, actionable business intelligence. This hands-on resource also provides thorough coverage of Oracle Real Application Clusters and Oracle Multitenant integration. * Offers proven implementation tips drawn from the author's experience * Features real-life case studies not available elsewhere * Written by an Oracle enterprise architect and well-known speaker

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. The only Oracle Press guide to MySQL Workbench explains how to design and model MySQL databases.MySQL Workbench Data Modeling and Development helps developers learn how to effectively use this powerful product for database modeling, reverse engineering, and interaction with the database without writing SQL statements. MySQL Workbench is a graphical user interface that can be used to create and maintain MySQL databases without coding. The book covers the interface and explains how to accomplish each step by illustrating best practices visually. Clear examples, instructions, and explanations reveal, in a single volume, the art of database modeling. This Oracle Press guide shows you how to get the tool to do what you want. Annotated screen shots demonstrate all interactions with the tool, and text explains the how, what, and why of each step. Complete coverage Installation and Configuration; Creating and Managing Connections; Data Modeling Concepts; Creating an ERD; Defining the Physical Schemata; Creating and Managing Tables; Creating and Managing Relationships; Creating and Managing Views; Creating and Managing Routines; Creating and Managing Routine Groups; Creating and Managing User & Groups; Creating and Managing SQL Scripts; Generating SQL Scripts; Forward Engineering a Data Model; Synchronize a Model with a Database; Reverse Engineering a Database; Managing Differences in the Data Catalog; Creating and Managing Model Notes; Editing Table Data; Editing Generated Scripts; Creating New Instances; Managing Import and Export; Managing Security; Managing Server Instances

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 edition of Understanding Oracle APEX 5 Application Development shows APEX developers how to build practical, non-trivial web applications. The book introduces the world of APEX properties, explaining the functionality supported by each page component as well as the techniques developers use to achieve that functionality. The book is targeted at those who are new to APEX and just beginning to develop real projects for production deployment. Reading the book and working the examples will leave you in a good position to build good-looking, highly-functional, web applications. Topics include: conditional formatting, user-customized reports, data entry forms, concurrency and lost updates, and updatable reports. Accompanying the book is a demo web application that illustrates each concept mentioned in the book. Specific attention is given in the book to the thought process involved in choosing and assembling APEX components and features to deliver a specific result. Understanding Oracle APEX 5 Application Development is the ideal book to take you from an understanding of the individual pieces of APEX to an understanding of how those pieces are assembled into polished applications. Teaches how to develop non-trivial APEX applications. Provides deep understanding of APEX functionality. Shows the techniques needed for customization.

Learn the simplest ways to get things done with Microsoft Access 2013

Get the full-color, visual guide that makes learning Microsoft Access 2013 plain and simple Follow the book's easy steps and screenshots and clear, concise language to learn the simplest ways to build a database and sort information.

Here's WHAT you'll learn:

Build and manage your own databaseApply professional designs across your databasesCreate presentations and publish reports onlineSecure your database with passwords and encryptionExchange data with other databases and documentsInteract with your data easier using macros Here's HOW you'll learn it:

Jump in wherever you need answersFollow easy STEPS and SCREENSHOTS to see exactly what to doGet handy TIPS for new techniques and shortcutsUse TRY THIS Exercises to apply what you learn right away

This practical, hands-on tutorial/reference/guide to MySQL is perfect for beginners, but it also works for experienced developers who are not getting the most from MySQL. As you would expect, this book shows how to code all of the essential SQL statements for creating and working with a MySQL database. But beyond that, this book also shows how to design a database, including how to use the graphical MySQL Workbench to create an EER model. It shows how to take advantage of relatively new MySQL features such as foreign keys, transactions, stored procedures, stored functions, triggers, and events. It even presents a starting set of skills for a database administrator (DBA), including how to secure and back up databases. And like all Murach books, it uses the distinctive "paired pages" format, which breaks the material into manageable skills to speed up both learning and reference. A great help for MySQL users at any level.

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. Deliver BI Solutions with Microsoft Office PerformancePoint Server 2007 Maximize the powerful BI tools available in PerformancePoint 2007 with help from this practical guide. You will learn how to collect and store data, monitor progress, analyze performance, distribute dynamic reports, and create maintainable projects and forecasts. Business Intelligence with Microsoft Office PerformancePoint Server 2007 provides full details on creating scorecards and dashboards, performing advanced analysis on data, and setting up business plans. You will also learn how to integrate PerformancePoint with ProClarity, Excel 2007, and SQL Server Reporting Services. Configure, deploy, and secure all the PerformancePoint components Create KPIs, scorecards, reports, and dashboards with the Dashboard Designer Create business models with the Planning Business Modeler and create budgets and forecasts with Excel 2007 Enable advanced data analysis with PerformancePoint Server and ProClarity tools Take advantage of the enhanced analytic capabilities of Excel 2007 Use SQL Server Reporting Services for analytics Align performance with organizational objectives

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. Extract and analyze mission-critical enterprise data using Microsoft Office 2007 This authoritative volume is a practical guide to the powerful new collaborative Business Intelligence tools available in Office 2007. Using real-world examples and clear explanations, Microsoft Office 2007 Business Intelligence: Reporting, Analysis, and Measurement from the Desktop shows you how to use Excel, Excel Services, SharePoint, and PerformancePoint with a wide range of stand-alone and external data in today's networked office. You will learn how to analyze data and generate reports, scorecards, and dashboards with the Office tools you're already using to help you in your everyday work. Create Excel PivotTables and PivotCharts and apply Conditional Formatting Convert Excel spreadsheets into Excel Tables with Conditional Formatting and Charting Connect external data to Excel using Office Data Connections and SharePoint Create SharePoint dashboards that display data from multiple sources Add Key Performance Indicators and Excel Services reports to your dashboards Harness advanced SQL Server 2005 data analysis tools with the Excel Data Mining Add-In and Visio Cluster Diagrams Generate integrated PerformancePoint Scorecards Create Visio PivotDiagrams and Windows Mobile spreadsheets All of the examples in the book can be downloaded for free by doing the following: go to www.mhprofessional.com. Click on the Computing tab. Click on the Downloads page. Click on the book's title to download the examples.

The new edition of the successful previous version is 25 per cent revised and packed with more than 200 pages of new material on the 2008 release of SQL Server Integration Services (SSIS). Renowned author Brian Knight and his expert coauthors show developers how to master the 2008 release of SSIS, which is both more powerful and more complex than ever. Case studies and tutorial examples acquired over the three years since the previous edition will contribute to helping illustrate advanced concepts and techniques. New chapters include coverage of data warehousing using SSIS, new methods for managing the SSIS platform, and improved techniques for ETL operations.