Apple Pro Training Series: macOS Support Essentials 10.12 The Apple-Certified Way to Learn This is the official curriculum of the macOS Support Essentials 10.12 course and preparation for Apple Certified Support Professional (ACSP) 10.12 certification-as well as a top-notch primer for anyone who needs to support, troubleshoot, or optimize macOS Sierra. The only Apple-certified book on the market, this guide is designed for support technicians, help desk specialists, and ardent Mac users and takes you deep inside the macOS Sierra operating system. You'll find in-depth, step-by-step instruction on everything from installing and configuring macOS Sierra to managing networks and system administration-all on your way to preparing for the industry-standard ACSP certification. Covers updated system utilities and new features of macOS Sierra, including Siri and Optimized Storage. Features authoritative explanations of underlying technologies, troubleshooting, system administration, and much more. Focused lessons take you step by step through practical, real-world tasks. Lesson files and bonus material available for download-including lesson review questions to help prepare you for the Apple certification exam. Web Edition provides full text of the book available online as part of our Content Update Program with revised content for significant software updates.

Your database is the foundation of your application. Many programmers assume it's also the bottleneck of productive software development, but with the right techniques, this doesn't have to be true. SQL Antipatterns illustrates some of the most common misconceptions and pitfalls software developers face using relational databases. This book helps you to use a database to produce the most efficient results, and turn sluggish, inflexible code and thankless late-night hours into high-quality, reliable solutions and a job well done. The SQL database programming language is the core of most software in the world, but if you're like most software developers, you're self-taught in SQL, and you know just enough to get by. As a result, you might design fragile databases that cannot scale as the business grows, write queries that produce incorrect results and not know why, or deploy applications that are vulnerable to hackers. Don't reinvent the wheel to solve problems SQL was designed to solve--this book will teach you new SQL techniques for getting your job done. Whatever platform or programming language you use, whether you're a junior programmer or a Ph.D., SQL Antipatterns will show you how to design and build databases, how to write better database queries, and how to integrate SQL programming with your application like an expert. You'll also learn the best and most current technology for full-text search, how to design code that is resistant to SQL injection attacks, and other techniques for success.

Take a simple approach to learning the Oracle GoldenGate product. This approach provides the in-depth perspective of GoldenGate from an implementer's viewpoint; however, also addresses why the management viewpoint is important as well. Your journey through this book includes and architecture discussion of GoldenGate and the benefits of purchasing GoldenGate from a management perspective. Then the book quickly moves into advanced implementation components associated with GoldenGate. You'll find many use-cases and instructions throughout the book to help with everything from easy to complex GoldenGate implementations. An Oracle GoldenGate implementation generally consists of a group project, involving both business and technical resources. Pro Oracle GoldenGate for the DBA provides the viewpoint from the DBA's vantage point. This approach provides the components of who, what, why, when, and how in defining the implementation and support of a GoldenGate project. The success of most technical projects require the support of multiple resource groups, and Pro Oracle GoldenGate for the DBA supplies the insight for the DBA member to understand the implementation and support process. Takes you through justification, installation, and support. Provides the DBA perspective toward a successful a result. Covers from basic toward increasingly advanced implementations What You Will Learn Understand the core architecture of data replication using Oracle GoldenGate Implement a one-way setup of a classic capture and an integrated capture and replication Design, architect and implement a multi-master replication model Replicate unsupported data types using tokens Manage and troubleshoot multiple GoldenGate implementations New features of GoldenGate supported in Oracle 12c Who this Book is For Pro Oracle GoldenGate for the DBA is aimed squarely at Oracle database administrators who find themselves involved in GoldenGate integration projects. The book provides the DBA view into such projects, helping database administrators toward successful implementations and solid business results.

The Only Authorized Guide to IBM Cognos 8 Business Intelligence

Develop, deploy, and maintain a complete BI solution across your enterprise. IBM Cognos 8 Business Intelligence: The Official Guide shows you how to take full advantage of the robust service-oriented architecture and simplified role-based user interfaces. Learn how to create, share, and analyze data-rich reports that lead to increased productivity and better business decisions. Featuring real-world insight and expert tips, this is a must-have guide for IBM Cognos 8 Business Intelligence users of all levels, from administrators to end users. Measure and monitor performance using dashboards and scorecardsAndnbsp;Andnbsp;Andnbsp;Andnbsp; Assign user roles and privileges Andnbsp;Andnbsp;Andnbsp;Andnbsp;Andnbsp;Andnbsp;Andnbsp;Andnbsp;Andnbsp;Andnbsp;Andnbsp; Provide complete and consistent access to a broad range of data sources via Cognos ConnectionUse Cognos 8 Go! to extend BI to Office applications, mobile devices, and search enginesEnable business users to create reports with Query StudioDevelop new insights by exploring data in multiple dimensions and perspectives with Analysis StudioBuild Dimensional Reports with Report StudioUse Event Studio to identify and deliver mission-critical information Create, modify, organize, and publish a model from Cognos Framework ManagerAndnbsp;Andnbsp;Andnbsp;Andnbsp;Andnbsp;Andnbsp;Andnbsp;Andnbsp; Implement sound security measures Take advantage of the management tools in Cognos Administration to ensure maximum reliability and availability

Learn how to most effectively use PL/SQL programming language with one of the most popular and widely-used software programs in large companies today -- Oracle (R)11g. ORACLE (R) 11G: PL/SQL PROGRAMMING & ORACLE (R) CD, 2E, International Edition uses Oracle (R) 11g to provide an overview of the PL/SQL programming language from a developer's perspective. The author begins with a step-by-step expanded introduction to fundamental PL/SQL concepts before progressing to the writing and testing of PL/SQL code. This edition also covers more advanced topics, such as Dynamic SQL and code tuning, as well as developments in bulk processing, compound triggers, PL/SQL compiler features and hiding source code. Updates reflect the latest Oracle (R) 11g release with the most recent figures and examples using the user-friendly SQL Developer tool. A wealth of real-world examples, a straightforward presentation, and accompanying Oracle (R) CD make this book is an invaluable resource in preparing for the new Oracle (R) Certification exam or mastering the PL/SQL programming language with Oracle (R).

With proven pedagogy that emphasizes critical-thinking, problem-solving, and in-depth coverage, New Perspectives helps students develop the Microsoft Office 2013 skills they need to be successful in college and beyond. Updated with all new case-based tutorials, New Perspectives Microsoft Access 2013 continues to engage students in applying skills to real-world situations, making concepts relevant. A new Troubleshoot case problem enhances critical thinking, and a new tutorial on Managing Your Files helps students navigate Windows 8. As always, New Perspectives improves learning outcomes and transference of skills by helping students understand why what they're learning is important.

Each new print copy includes Navigate 2 Advantage Access that unlocks a comprehensive and interactive eBook, student practice activities and assessments, a full suite of instructor resources, and learning analytics reporting tools. Databases Illuminated, Third Edition combines database theory with a practical approach to database design and implementation. Strong pedagogical features, including accessible language, real-world examples, downloadable code, and engaging hands-on projects and lab exercises create a text with a unique combination of theory and student-oriented activities. Providing an integrated, modern approach to databases, Databases Illuminated, Third Edition is the essential text for students in this expanding field. The text is packaged with a full suite of instructor resources, including a Test Bank, Solutions to Projects and Exercises, Lecture Slides in PowerPoint format, and Additional Projects. With Navigate 2, technology and content combine to expand the reach of your classroom. Whether you teach an online, hybrid, or traditional classroom-based course, Navigate 2 delivers unbeatable value. Experience Navigate 2 today at www.jblnavigate.com/2 Key features of the Third Edition include: * A new chapter on the emerging topics of Big Data, NoSQL, and NewSQL * Revised and expanded coverage on database security, including SQL injection * Extended coverage of SQL, with additional material on temporal database queries and JDBC * New features and downloadable SQL code for Oracle 12c, MySQL, and SQL Server * Updated information on social and ethical issues addressing new regulations and global issues * Use of the open source software LibreOffice, which is available worldwide at no cost * Access to Navigate 2 online learning materials including a comprehensive and interactive eBook, student practice activities and assessments, learning analytics reporting tools, and more

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. Troubleshoot, tune, and optimize your Oracle database efficiently and successfully every time This book explains how to take full advantage of the revolutionary Oracle Wait Interface to quickly pinpoint--and solve--core problems and bottlenecks, and increase productivity exponentially.

Learn SQL Server Reporting Services and become current with the 2016 edition. Develop interactive, dynamic reports that combine graphs, charts, and tabular data into attractive dashboards and reports to delight business analysts and other users of corporate data. Deliver mobile reports to anywhere and any device. Build vital knowledge of Reporting Services at a time when Microsoft's dominance in business intelligence is on the rise. Beginning SQL Server Reporting Services turns novices into skilled report developers. The book begins by explaining how to set up the development environment. It then walks you through creating your first reports using the built-in wizard. After showing what is possible, the book breaks down and explains the skills needed to create reports from scratch. And not just reports! But also dashboards with charts, graphs, and maps. Each chapter builds on knowledge gained in the previous chapters with step-by-step tutorials. Beginning SQL Server Reporting Services boosts your skills and provides you additional career options. Don't be without those options. Grab and read this book today. Build reports with and without the built-in wizard. Build interactive features such as drill-through reports. Build dashboards full of charts, graphs, and maps. Build mobile reports. What You Will Learn Set up your development environment. Organized projects and share components among reports. Create report using a wizard. Create reports from scratch, including grouping levels, parameters, and drill through features. Build interactive dashboard with graphs, charts, and maps. Deploy and manage reports for use by others in the business. Who This Book Is For Database professionals of all experience levels who have some experience in databases and want to make the leap into business intelligence reporting. The book is an excellent choice for those needing to add Reporting Services to their current list of skills, or who are looking for a skill set that is in demand for in order to break into IT.

As part of the Pocket Primer series, this book provides an overview of the major concepts to program Microsoft Access/VBA. The focus of this book is on basic programming instructions for both Access 2013 and previous versions. Features: Provides an overview of the most important Access/VBA programming techniques Covers both Access 2013 and 2010 versions Includes CD with source code, projects, and figures

Want to create applications that run faster and perform better on SAP HANA? Learn how to design, test, and deploy native SAP HANA applications with SAP HANA XSA. Get started by exploring your development environment, tools, and the SAP HANA XSA architecture. Then define your data model with Core Data Services and HDB, add your application layer-Node.js, Java, or custom-and develop your presentation layer. Finish up by securing, troubleshooting, and deploying your app. Highlights include: Developing native applications, Development environment, Development tools, SAP HANA XSA architecture, Data models, Application layer, Presentation layer, Security, Debugging, Sample code. With this book, you will be able to: Learn to use the SAP HANA XS Advanced application server, Design apps from start to finish: define the data model, add the application layer, and develop a presentation layer, Secure, troubleshoot, and deploy completed apps.

Description Phoenix is a modern web framework built for the Elixir programming language. Elegant, fault-tolerant, and performant, Phoenix is as easy to use as Rails and as rock-solid as Elixir's Erlang-based foundation. Phoenix in Action builds on your existing web dev skills, teaching you the unique benefits of Phoenix along with just enough Elixir to get the job done. Phoenix in Action is an example-based tutorial that teaches you how to use the Phoenix framework to build production-quality web apps. Following a running example of an online auction site, you'll design and build everything from the core components that drive the app to the real-time user interactions where Phoenix really shines. You'll handle business logic, database interactions, and app designs that take advantage of functional programming as you discover a better way to develop web applications. Key features * Use channels for real-time communication * Learn database interactions with Ecto * Hands-on examples * Step-by-step instructions * Jargon-free Audience Written for web developers familiar with a framework like Rails or ASP.NET. No experience of Elixir or Phoenix required. About the technology Phoenix is a web framework for the Elixir language. Phoenix applications are blazingly fast, and as a developer you'll appreciate the attention to detail in the framework design that makes you superproductive almost immediately. In particular, Phoenix channels provide an easy way to set up and manage real-time communication.

This authorized guide from Oracle Press explains how to administer Oracle9i on all of the major UNIX platforms, including Solaris, HP-UNIX and IBM-UNIX, and Linux. Inside, youll find proven techniques and UNIX scripts that can be used to perform dozens of UNIX-related tasks.

Benchmark Series: Microsoft Access 2013 Level 1 builds students' introductory skills in Access 2013, 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.

This book is for students preparing to become certified for the 70-444 and 70-432 Microsoft SQL Server 2005/2008 Database Administration exam. The Microsoft Official Academic Course (MOAC) lessons correlate and are mapped to the Microsoft Certified Information Technology Professional, (MCITP) 70-444 and 70-432 certification exam. This text covers installing and configuring Microsoft SQL Server and managing and maintaining databases and multidimensional databases, user accounts, database availability, recovery, and reporting. This text guides students through the design and implementation of security or server automation as well as monitoring and troubleshooting SQL Server activity. The MOAC IT Professional series is the Official from Microsoft, turn-key Workforce training program that leads to professional certification and was authored for college instructors and college students.
MOAC gets instructors ready to teach and students ready for work by delivering essential resources in 5 key areas: Instructor readiness, student software, student assessment, instruction resources, and learning validation. With the Microsoft Official Academic course program, you are getting instructional support from Microsoft; materials that are accurate and make course delivery easy.

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.

If you want to study, build, or simply validate your thinking about modern cloud native data center networks, this is your book. Whether you're pursuing a multitenant private cloud, a network for running machine learning, or an enterprise data center, author Dinesh Dutt takes you through the steps necessary to design a data center that's affordable, high capacity, easy to manage, agile, and reliable. Ideal for network architects, data-center operators, and network and containerized application developers, this book mixes theory with practice to guide you through the architecture and protocols you need to create and operate a robust, scalable network infrastructure. The book offers a vendor-neutral way to look at network design. For those interested in open networking, this book is chock-full of examples using open source software, from FRR to Ansible. In the context of a cloud native data center, you'll examine: Clos topology Network disaggregation Network operating system choices Routing protocol choices Container networking Network virtualization and EVPN Network automation

Thorough and updated coverage of database design and SQL for DB2 are the focus of this guide for the relational database-management system used on IBM i computer systems. Suitable for classroom instruction or self-study, this book explains the most widely used database language and the way that language is implemented on a variety of computer platforms. Topics covered include database concepts, SQL inquiries, web applications, and database security, and the material is reinforced by numerous illustrations, examples, and exercises.

Benchmark Series: Microsoft Access 2010 Level 2 builds students' intermediate-to-advanced skills in Access 2010, and helps develop critical thinking and decision-making skills. Case study assessments at chapter and unit levels test students' abilities to solve problems independently Projects-based approach creates a realistic context for learning practical skills

DESCRIPTION PostGIS is an open source spatial database extender for PostgreSQL. It equals or surpasses proprietary alternatives, allowing the creations of location-aware queries with just a few lines of SQL code, and provides a back-end for mapping, raster analysis, and routing applications with minimal effort. PostGIS in Action, Second Edition teaches readers of all levels to write spatial queries that solve real-world problems. After covering the background in vector, raster and topology based GIS, it quickly moves into analyzing, viewing, and mapping data. The book shows how to optimize queries for maximum speed, simplify geometries for greater efficiency, analyze rasters, vectorize rasters, better manage data utilizing topologies, and create custom functions for applications. It covers PostGIS 2.0 and 2.1 series, PostgreSQL 9.1- 9.3 features and shows how to integrate with other GIS tools. RETAIL SELLING POINTS Comprehensive coverage of PostGIS Applies PostGIS to real-world problems Significant updates to the first edition AUDIENCE Familiarity with relational database concepts is helpful but not required. This book is for programmers, GIS and DB practitioners, scientists, researchers, educators, and engineers. ABOUT THE TECHNOLOGY PostGIS (pronounced post-jis) is a spatial database extender for the PostgreSQL open source relational database management system. It's the most powerful open source spatial database engine. It also adds to PostgreSQL several spatial data types and over 300 functions for working with these spatial types.

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. Ramp Up Your PL/SQL Programming SkillsMaster PL/SQL through the hands-on exercises, extensive examples, and real-world projects inside this Oracle Press guide. Filled with best practices, Oracle Database 11g PL/SQL Programming Workbook covers all the latest features and enhancements of the language. Mastery checks at the end of each chapter reinforce the material covered, and sample code from the book is available for download. Even experienced Oracle professionals will benefit from this practical resource. Understand the Oracle development architecture and the mechanics of connections Work with data types, structures, blocks, cursors, and PL/SQL semantics Write, deploy, and use functions, procedures, and packages Manage transactions and more Use dynamic SQL statements in real-world applications Support online transaction processing and data warehousing applications with external tables Find syntax samples and best practices to solve problems Write, deploy, and use object types For a complete list of Oracle Press titles, visit www.OraclePressBooks.com

Marquee Series: Microsoft Access 2010 offers a highly visual, hands-on approach to learning Microsoft Access. Ideal for 1 or 2 credit courses, this text facilitates self-paced, accelerated, and traditional learning formats. Quick success with step-by-step, project-based instruction in two- and four-page activities. Four progressive levels of case-based assessment, including the popular Marquee Challenge, ensure software mastery at the introductory level. NEW! Includes activities on preparing MLA research papers. NEW! Individual Challenge connects students' lives and interests to project goals.

With Paradigm's new Benchmark Series: Microsoft Access 2010 Levels 1 and 2, students build mastery skills in the Access 2010 application. Its project-based approach creates a realistic context for learning practical skills. Teaches key skills for using Windows 7 and Internet Explorer 8. Mentoring instructional style guides students step-by-step in planning, creating, and managing databases to report and analyze information. Case study assessments at chapter and unit levels test students' abilities to solve problems independently. This text aligns to the Microsoft Office Specialist objectives.

Paradigm's new Benchmark Series: Microsoft Access 2010 Level 1 builds students' introductory skills in Access 2010, and helps develop critical thinking and decision-making skills. Case study assessments at chapter and unit levels test students' abilities to solve problems independently. Case study assessments at chapter and unit levels test students' abilities to solve problems independently. Project approach creates a realistic context for learning practical skills.

Benchmark Series: Microsoft Access 2010 Level 2 builds students' intermediate-to-advanced skills in Access 2010, and helps develop critical thinking and decision-making skills. Case study assessments at chapter and unit levels test students' abilities to solve problems independently Projects-based approach creates a realistic context for learning practical skills