Your cart is empty
A hands-on guide to using Excel in the business context First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away. Whilst there are many hundreds of tools, features and functions in Excel, this book focuses on the topics most relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Learn to create financial models to help make business decisions whilst applying modelling best practice methodology, tools and techniques. - Provides the perfect mix of practice and theory - Helps you become a DIY Excel modelling specialist - Includes updates for Excel 2019/365 and Excel for Mac - May be used as an accompaniment to the author's online and face-to-face training courses Many people are often overwhelmed by the hundreds of tools in Excel, and this book gives clarity to the ones you need to know in order to perform your job more efficiently. This book also demystifies the technical, design, logic and financial skills you need for business and financial modelling.
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. Achieve Extreme Application Performance for a Private Cloud with Oracle Exalogic Elastic Cloud Transition to a private cloud computing infrastructure and achieve unmatched levels of performance with help from this Oracle Press guide. Oracle Exalogic Elastic Cloud Handbook shows you how to plan, implement, and maintain a private cloud. Find out how to set up components, deploy Java applications, maximize redundancy and throughput, and migrate legacy workloads. Examples, screenshots, and diagrams are included throughout this comprehensive resource. Configure Oracle Exalogic Elastic Cloud nodes and racks Optimize Java EE application performance on Oracle WebLogic Server Provision and administer a highly scalable private cloud Build, debug, and manage custom Java applications Secure, monitor, and tune using Oracle Enterprise Manager Leverage capabilities from Oracle Fusion Middleware Consolidate Oracle and third-party application workloads
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. Master Oracle Business Intelligence 11g Reports and DashboardsDeliver meaningful business information to users anytime, anywhere, on any device, using Oracle Business Intelligence 11g. Written by Oracle ACE Director Mark Rittman, Oracle Business Intelligence 11g Developers Guide fully covers the latest BI report design and distribution techniques. Find out how to execute effective queries, build accurate models, use scorecards and KPIs, create dynamic reports, set up dashboards, and publish tosmartphones and wireless devices. This Oracle Press guide contains comprehensive details on Oracle Exalytics In-Memory Machine, the best-in-class, preintegrated BI platform. Install or upgrade to Oracle Business Intelligence 11g Develop and manage custom Oracle Business Intelligencerepositories Access relational, file, and multidimensional data sources Design print-quality reports with Oracle Business Intelligence Publisher Create web-enabled analyses, dashboards, and visualizations Integrate with other applications using Oracle BusinessIntelligence 11g Action Framework Employ authentication, authorization, and row-level security Configure and deploy Oracle Exalytics In-Memory Machine
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 Most Complete Guide to Maximizing Oracle Recovery Manager Deploy a rock-solid data backup and disaster recovery strategy with the in-depth guidance of this authoritative volume. From the exclusive publishers of Oracle Press books, Oracle Database 10g RMAN Backup & Recovery shows you, step by step, how to set up RMAN-ready databases, create reliable backup tapes and discs, and perform accurate Oracle system restores. Find out how to use RMAN from the command line and from Enterprise Manager, generate meaningful lists and reports, and automate administrative tasks using third-party media management tools. Plus, you'll learn to perform incremental backups, Flashback recoveries, and database cloning. Set up, configure, and maintain Oracle Database 10g RMAN Use RMAN recovery catalogs, target database packages, and control files Centralize backup tape management using Oracle Secure Backup Perform online, offline, and incremental system backups Monitor and tune performance with Enterprise Manager Grid Control and Database Control Accomplish complete and partial RMAN database restores Improve functionality using VERITAS NetBackup, EMC NetWorker Module, and Tivoli Storage Manager Overcome human errors using Flashback Versions Query and Transaction Query Create clone and standby databases from tape and disc backups Work with Real Application Cluster (RAC) databases and sync-and-split hardware technologies
YOUR ON-THE-JOB QUICK REFERENCE.
. Carry essential Oracle Database administration information and
troubleshooting techniques along with you so you can handle a wide
variety of tasks on the spot. This handy resource offers fast
access to administrative commands, error resolutions, best
practices, and more. Written by an Oracle expert and published by
Oracle Press, this convenient reference gives you quick solutions
in an easy-to-find format. Don't leave your desk without it! Get
details on: .
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. Master Oracle Business Process Management Suite 11gWritten by Oracle business process management experts, Oracle Business Process Management Suite 11g Handbook is a balanced combination of essential BPM concepts, best practices, and a detailed treatment of all the powerful features and functionalities of Oracle BPM Suite 11g. The book explains how to plan, develop, and deploy process-based business applications and enable enterprise-wide continuous process improvement. Implement successful BPM projects with help from this Oracle Press guide. Understand the architecture and functionalities of Oracle BPM Suite 11g Master BPMN 2.0 for business process modeling and implementation Address agility, business control, and transparency requirements with Oracle Business Rules 11g Develop rich interfaces with Oracle Application Development Framework (Oracle ADF) Work with the human task component of Oracle BPM 11g Plan a BPM initiative using the Oracle roadmap approach Apply the Oracle process engineering method to identify, select, define, and refine appropriate processes Implement a business process application using proven technical design and project delivery strategies
Optimize reporting and BI with Microsoft SQL Server 2016 Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports provides a comprehensive lesson in business intelligence (BI), operational reporting and Reporting Services architecture using a clear, concise tutorial approach. You'll learn effective report solution design based upon many years of experience with successful report solutions. Improve your own reports with advanced, best-practice design, usability, query design, and filtering techniques. Expert guidance provides insight into common report types and explains where each could be made more efficient, while providing step-by step instruction on Microsoft SQL Server 2016. All changes to the 2016 release are covered in detail, including improvements to the Visual Studio Report Designer (SQL Server Data Tools) and Report Builder, Mobile Dashboard Designer, the new Report Portal Interface, HTML-5 Rendering, Power BI integration, Custom Parameters Pane, and more. The Microsoft SQL Server 2016 release will include significant changes. New functionality, new capabilities, re-tooled processes, and changing support require a considerable update to existing knowledge. Whether you're starting from scratch or simply upgrading, this book is an essential guide to report design and business intelligence solutions. * Understand BI fundamentals and Reporting Services architecture * Learn the ingredients to a successful report design * Get up to speed on Microsoft SQL Server 2016 * Grasp the purpose behind common designs to optimize your reporting Microsoft SQL Server Reporting Services makes reporting faster, easier, and more powerful than ever in web, desktop and portal solutions. Compatibility with an extensive variety of data sources makes it a go-to solution for organizations across the globe. The 2016 release brings some of the biggest changes in years, and the full depth and breadth of these changes can create a serious snag in your workflow. For a clear tutorial geared toward the working professional, Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports is the ideal guide for getting up to speed and producing successful reports.
For Database Systems and Database Design and Application courses offered at the junior, senior and graduate levels in Computer Science departments. Written by well-known computer scientists, this introduction to database systems offers a comprehensive approach, focusing on database design, database use, and implementation of database applications and database management systems. The first half of the book provides in-depth coverage of databases from the point of view of the database designer, user, and application programmer. It covers the latest database standards SQL:1999, SQL/PSM, SQL/CLI, JDBC, ODL, and XML, with broader coverage of SQL than most other texts. The second half of the book provides in-depth coverage of databases from the point of view of the DBMS implementor. It focuses on storage structures, query processing, and transaction management. The book covers the main techniques in these areas with broader coverage of query optimization than most other texts, along with advanced topics including multidimensional and bitmap indexes, distributed transactions, and information integration techniques. Resources: * Open access Author Website 'http://infolab.stanford.edu/~ullman/dscb. html'includes Power Point slides, teaching notes, assignments, projects, Oracle Programming Guidelines, and solutions to selected exercises. * Instructor only Pearson Resources: Complete Solutions Manual (click on the Resources tab above to view downloadable files)
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. Apply Your SQL Server DBA Skills to Oracle Database AdministrationUse your SQL Server experience to set up and maintain a high-performance Oracle Database environment. Written by a DBA with expertise in both platforms, Oracle Database Administration for Microsoft SQL Server DBAs illustrates each technique with clear explanations, examples, and comparison tables. Get full details on Oracle Database intervals, creation assistants, management techniques, and query tools. High availability, disaster recovery, and security procedures are also extensively covered in this comprehensive Oracle Press guide. Install and configure Oracle Database on Windows or Linux systems Administer and monitor databases from Oracle Enterprise Manager Implement robust security using roles, permissions, and privileges Back up and restore databases with Oracle Recovery Manager Use the Oracle cost-based optimizer to tune performance Write, debug, and execute PL/SQL queries using Oracle SQL Developer Maximize availability with Oracle Real Application Clusters Build standby and failover servers using Oracle Data Guard
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. Learn cutting-edge technology from Oracle expertsWritten by Oracle insiders, this comprehensive guide covers everything you need to know about Real Application Clusters -- low-cost hardware platforms that can rival and exceed the quality of service, availability, and scalability of the most expensive mainframe systems. Concepts covered are applicable to all previous versions of Oracle Tuning and troubleshooting tips, providing insight on the most advanced diagnostics available Detailed coverage of advanced RAC concepts Working code for all examples available online
Introduce your students to the latest advancements that Microsoft (R) Access 2016 has to offer with MICROSOFT (R) OFFICE 365 & ACCESS 2016: COMPREHENSIVE -- the new edition in today's generation of acclaimed Shelly Cashman Series (R) books. For more than three decades, the Shelly Cashman Series (R) has effectively introduced computer skills to millions. MICROSOFT (R) OFFICE 365 & ACCESS 2016: COMPREHENSIVE continues the Series' strong history of innovation with a hallmark learning approach now enhanced to address the varied learning styles of today's students. A trademark, step-by-step, screen-by-screen approach provides a thorough understanding of Microsoft (R) Access 2016 through experimentation, critical thought, and personalization. This new edition and accompanying resources deliver effective educational materials specifically designed to engage readers, improve retention, and prepare students for future success in working with all aspects of Microsoft (R) Access 2016.
Help your students develop the complete Microsoft (R) Access 2016 skills they need to be successful in college and beyond with the emphasis on critical-thinking, problem-solving, and in-depth coverage found in NEW PERSPECTIVES MICROSOFT OFFICE 365 & ACCESS 2016: COMPREHENSIVE. Updated with all-new case-based modules, this thorough introduction applies the progressive skills students are learning to real-world situations to ensure that concepts remain highly relevant. A new Productivity Apps module visually introduces Microsoft (R) OneNote, Sway, Office Mix and Edge with fun, hands-on activities. Companion Sways provide videos and step-by-step instructions to help students learn to master each app. With an unmatched emphasis on learning outcomes and transference of skills, NEW PERSPECTIVES MICROSOFT (R) OFFICE 365 & ACCESS 2016: COMPREHENSIVE engages students by clearly demonstrating the importance of the extensive Microsoft (R) Access 2016 skills they're learning.
This book describes the next generation of business applications in the innovative new SAP Business Suite 4 SAP HANA (SAP S/4HANA), exploiting the revolutionary capabilities of the SAP HANA in-memory database. Numerous real-world examples are presented illustrating the disruptive potential of this technology and the quantum leap it has facilitated in terms of simplicity, flexibility, and speed for new applications. The intuitive structure of this book offers a straightforward business perspective grounded in technology in order to enable valuable business insights drawn from the wealth of real-world experience of the book's two authors, both prominent figures in the field of business application systems: Hasso Plattner and Bernd Leukert. Hasso Plattner is the co-founder of SAP and the founder of the Hasso Plattner Institute, affiliated with the University of Potsdam, Germany. Bernd Leukert is a member of the SAP Executive Board and the Global Managing Board of SAP.
Master database creation and management Access 2019 Bible is your, comprehensive reference to the world's most popular database management tool. With clear guidance toward everything from the basics to the advanced, this go-to reference helps you take advantage of everything Access 2019 has to offer. Whether you're new to Access or getting started with Access 2019, you'll find everything you need to know to create the database solution perfectly tailored to your needs, with expert guidance every step of the way. The companion website features all examples and databases used in the book, plus trial software and a special offer from Database Creations. Start from the beginning for a complete tutorial, or dip in and grab what you need when you need it. Access enables database novices and programmers to store, organize, view, analyze, and share data, as well as build powerful, integrable, custom database solutions -- but databases can be complex, and difficult to navigate. This book helps you harness the power of the database with a solid understanding of their purpose, construction, and application. Understand database objects and design systems objects Build forms, create tables, manipulate datasheets, and add data validation Use Visual Basic automation and XML Data Access Page design Exchange data with other Office applications, including Word, Excel, and more From database fundamentals and terminology to XML and Web services, this book has everything you need to maximize Access 2019 and build the database you need.
"Robert Pearl, a well-known DBA in the SQL community, explains his holistic vision of a database instance that needs regular check-ups and gives the tools, scripts, and best practices he has collected over the years." Alberto Bolchini, Computing Reviews, May 9, 2016 Healthy SQL is about ensuring the ongoing performance health of a SQL Server database. An unhealthy database is not just an inconvenience; it can bring a business to its knees. And if you are the database administrator, the health of your SQL Server implementation can be a direct reflection on you. It's in everyone's best interest to have a healthy SQL implementation. Healthy SQL is built around the concept of a medical checkup, giving you the tools you need to assess the current health of your database and take action to improve upon that health and maintain good performance to your business. Healthy SQL aids in developing a rigorous routine so that you know how healthy your SQL Server machines are, and how you can keep those same servers healthy and fit for duty. The book is filled with practical advice and a time-tested strategy, helping you put together a regimen that will ensure your servers are healthy, your implementation is fully optimized, your services are redundant and highly available, and you have a plan for business continuity in the event of a disaster. If your current environment doesn't match up with these criteria, then pick up a copy of Healthy SQL today and start your journey on the road to a fit and tight SQL Server deployment.
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
Your all-access guide to all things Access 2016 If you don't know a relational database from an isolationist table but still need to figure out how to organize and analyze your data Access 2016 For Dummies is for you. Written in a friendly and accessible manner, it assumes no prior Access or database-building knowledge and walks you through the basics of creating tables to store your data, building forms that ease data entry, writing queries that pull real information from your data, and creating reports that back up your analysis. Add in a dash of humor and fun, and Access 2016 For Dummies is the only resource you'll need to go from data rookie to data pro! This expanded and updated edition of Access For Dummies covers all of the latest information and features to help data newcomers better understand Access' role in the world of data analysis and data science. Inside, you'll get a crash course on how databases work and how to build one from the ground up. Plus, you'll find step-by-step guidance on how to structure data to make it useful, manipulate, edit, and import data into your database, write and execute queries to gain insight from your data, and report data in elegant ways. * Speak the lingo of database builders and create databases that suit your needs * Organize your data into tables and build forms that ease data entry * Query your data to get answers right * Create reports that tell the story of your data findings If you have little to no experience with creating and managing a database of any sort, Access 2016 For Dummies is the perfect starting point for learning the basics of building databases, simplifying data entry and reporting, and improving your overall data skills.
This book is the definitive reference on PL/SQL, considered throughout the database community to be the best Oracle programming book available. Like its predecessors, this 6th edition of Oracle PL/SQL Programming covers language fundamentals, advanced coding techniques, and best practices for using Oracle's powerful procedural language. Thoroughly updated for Oracle Database 12c, this edition reveals new PL/SQL features and provides extensive code samples, ranging from simple examples to complex and complete applications, in the book and on the companion website. It's an indispensable reference for both novices and experienced Oracle programmers.
With the New Perspectives' critical-thinking, problem-solving approach, students will gain a comprehensive understanding of Microsoft Office Access 2010 and will learn how to take advantage of the flexibility it offers. Case-based tutorials challenge students to apply what they are learning to real-life tasks, preparing them to easily transfer skills to new situations. With New Perspectives, students understand why they're learning what they're learning and are better situated to retain skills beyond the classroom.
If you are a typical Oracle professional, you don't have the luxury of time to keep up with new technology and read all the new manuals to understand each new feature of the latest release from Oracle. You need a comprehensive source of information and in-depth tips and techniques for using the new technology. You need Oracle Internals: Tips, Tricks, and Techniques for DBAs.
Master database creation and management Access 2016 Bible is your, comprehensive reference to the world's most popular database management tool. With clear guidance toward everything from the basics to the advanced, this go-to reference helps you take advantage of everything Access 2016 has to offer. Whether you're new to Access or getting started with Access 2016, you'll find everything you need to know to create the database solution perfectly tailored to your needs, with expert guidance every step of the way. The companion website features all examples and databases used in the book, plus trial software and a special offer from Database Creations. Start from the beginning for a complete tutorial, or dip in and grab what you need when you need it this book gives you an expert Access 2016 companion on call 24/7. Access enables database novices and programmers to store, organize, view, analyze, and share data, as well as build powerful, integrable, custom database solutions but databases can be complex, and difficult to navigate. This book helps you harness the power of the database with a solid understanding of their purpose, construction, and application. * Understand database objects and design systems objects * Build forms, create tables, manipulate datasheets, and add data validation * Use Visual Basic automation and XML Data Access Page design * Exchange data with other Office applications, including Word, Excel, and more From database fundamentals and terminology to XML and Web services, this book has everything you need to maximize Access 2016 and build the database you need.
This book encourages students to expand their understanding of the Access 2010 software through experimentation, exploration and planning ahead. End of chapter exercises prepare students to become more capable software users by requiring them to use critical thinking and problem-solving skills to create real-life documents.
Thinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9.5 to 10, you'll also discover that PostgeSQL is more than a database system-it's an impressive application platform as well. With examples throughout, this book shows you how to achieve tasks that are difficult or impossible in other databases. This third edition covers new features, such as ANSI-SQL constructs found only in proprietary databases until now: foreign data wrapper (FDW) enhancements; new full text functions and operator syntax introduced in version 9.6; XML constructs new in version 10; query parallelization features introduced in 9.6 and enhanced in 10; built-in logical replication introduced in Version 10.e. If you're a current PostgreSQL user, you'll pick up gems you may have missed before. Learn basic administration tasks such as role management, database creation, backup, and restore Apply the psql command-line utility and the pgAdmin graphical administration tool Explore PostgreSQL tables, constraints, and indexes Learn powerful SQL constructs not generally found in other databases Use several different languages to write database functions Tune your queries to run as fast as your hardware will allow Query external and variegated data sources with foreign data wrappers Learn how to use built-in replication to replicate data
PROBLEM-SOLVING CASES IN MICROSOFT (R) ACCESS (R) AND EXCEL (R), 11E, International Edition helps you apply the Access (R) database management system and Excel (R) spreadsheet to effectively analyze and solve real-world, business problems. Six individual tutorials build a practical knowledge of each software application's capabilities, while twelve all-new case studies present scenarios and problems common in business. Further, a skill-building integration feature requires readers to use Access (R) and Excel (R) together on cases, making this the most up-to-date, practical guide for these widely used software programs.
You may like...
Oracle Database 12c Release 2 New…
Bob Bryla, Robert Freeman Paperback
Big Data For Dummies
Judith S. Hurwitz, Alan Nugent, … Paperback
Beginning Oracle SQL for Oracle Database…
Ben Brumm Paperback
Database Management Systems
Raghu Ramakrishnan, Johannes Gehrke Paperback
Dynamic SQL - Applications, Performance…
Edward Pollack Paperback
Access 2019 For Dummies
Laurie A Ulrich, Ken Cook Paperback (1)
Laravel: Up & Running - A Framework for…
Matt Stauffer Paperback
Oracle SQL Revealed - Executing Business…
Alex Reprintsev Paperback
Problem Solving Cases in MS Access…
Ellen Monk, Joseph Brady, … Paperback
Oracle Application Express by Design…
Patrick Cimolini Paperback