Your cart is empty
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. A Complete Study System for OCA Exam 1Z0-062Prepare for the Oracle Certified Associate Oracle Database 12c Installation and Administration exam with this exclusive Oracle Press guide. Each chapter features challenging exercises, a certification summary, a two-minute drill, and a self-test to reinforce the topicspresented. This authoritative resource helps you pass the exam and also serves as an essential, on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-062, including: Installing and upgrading Oracle Database software Managing the database instance Configuring the Oracle network environment Managing database storage structures Administering user security Managing undo data and data concurrency Implementing Oracle Database auditing Performing database maintenance Managing performance and tuning SQL Managing resources using Oracle Database Resource Manager Automating tasks Moving data Performing backup and recovery Installing Oracle Grid Infrastructure for a standalone server Electronic content includes: 185+ practice exam questions with detailed answers and explanations Test engine that provides custom exams by chapter or by domain PDF copy of the book
Pro SQL Database for Windows Azure, 2nd Edition shows how to create enterprise-level database deployments without the usual investment in datacenter and other infrastructure. Take advantage instead of Microsoft's worldwide backbone for cloud computing that delivers all the power of SQL Server in the form of the cloud-based SQL Database for Windows Azure. You can create and deploy a database in mere minutes that is accessible worldwide and takes advantage of SQL Database's high-availability features to protect your data while ensuring 99.9% uptime. SQL Azure is ideally suited for startups, who can benefit from instant access to a robust and secure web-accessible database platform for use in rapidly deploying new products to market. SQL Azure is also ideal for small and mid-sized businesses, giving them the same ability to deploy SQL Server as any large enterprise, but without the management overhead. Even large enterprises find SQL Azure useful in creating failover environments, development environments, extra capacity to handle surges in demand, and more.Pro SQL Database for Windows Azure covers the very latest in Microsoft's fast-moving, cloud platform, showing how to program and administer it in a variety of cloud computing scenarios. You'll learn to program SQL Azure from ASP.NET, from WinForms, and from SQL Reporting Services. You'll learn to manage the platform by planning for scalability, troubleshooting performance issues, and implementing strong security. You'll learn the unique aspects of SQL Azure such as sharding and federation support that combine to place SQL Azure a step above and ahead of the competiton. * Shows how to use SQL Azure from classic Windows applications, ASP.NET and Windows Communication Foundation * Covers management, performance, scalability, and troubleshooting * Addresses the all-important issue of securing your data * Helps you properly design for high-performance in a cloud environment * Helps you adopt the new Federations feature in SQL Azure What you'll learn * Create and manage SQL Database for Windows Azure databases * Access SQL Azure from WinForms, ASP.NET, Reporting Services, and more * Optimize database design for Azure's distributed cloud platform * Share data between databases using SQL Database's Data Synch Service * Secure data from intrusion and unauthorized access * Learn strategies for data migration and backup Who this book is for Pro SQL Database for Windows Azure, 2nd Edition is aimed at developers and database administrators desiring instant access to a fully-capable SQL Server database environment without the pain of sorting out and managing the physical infrastructure. Table of ContentsChapter 1: Getting Started with SQL Database Chapter 2: Design Considerations Chapter 3: Security Chapter 4: Data Migration and Backup Strategies Chapter 5: Programming with SQL Database Chapter 6: SQL Reporting Chapter 7: SQL Data Sync Chapter 8: Windows Azure and ASP.NET Chapter 9: Designing for High Performance Chapter 10: Federations Chapter 11: Performance Tuning Chapter 12: Windows Azure Mobile Services Appendix A: SQL Database Management Portal Appendix B: SQL Database Quick Reference
Effectively query and modify data using Transact-SQL Master T-SQL fundamentals and write robust code for Microsoft SQL Server and Azure SQL Database. Itzik Ben-Gan explains key T-SQL concepts and helps you apply your knowledge with hands-on exercises. The book first introduces T-SQL's roots and underlying logic. Next, it walks you through core topics such as single-table queries, joins, subqueries, table expressions, and set operators. Then the book covers more-advanced data-query topics such as window functions, pivoting, and grouping sets. The book also explains how to modify data, work with temporal tables, and handle transactions, and provides an overview of programmable objects. Microsoft Data Platform MVP Itzik Ben-Gan shows you how to: Review core SQL concepts and its mathematical roots Create tables and enforce data integrity Perform effective single-table queries by using the SELECT statement Query multiple tables by using joins, subqueries, table expressions, and set operators Use advanced query techniques such as window functions, pivoting, and grouping sets Insert, update, delete, and merge data Use transactions in a concurrent environment Get started with programmable objects-from variables and batches to user-defined functions, stored procedures, triggers, and dynamic SQL
Prepare for Microsoft Exam 70-767-and help demonstrate your real-world mastery of skills for managing data warehouses. This exam is intended for Extract, Transform, Load (ETL) data warehouse developers who create business intelligence (BI) solutions. Their responsibilities include data cleansing as well as ETL and data warehouse implementation. The reader should have experience installing and implementing a Master Data Services (MDS) model, using MDS tools, and creating a Master Data Manager database and web application. The reader should understand how to design and implement ETL control flow elements and work with a SQL Service Integration Services package. Focus on the expertise measured by these objectives: * Design, and implement, and maintain a data warehouse * Extract, transform, and load data * Build data quality solutionsThis Microsoft Exam Ref: * Organizes its coverage by exam objectives * Features strategic, what-if scenarios to challenge you * Assumes you have working knowledge of relational database technology and incremental database extraction, as well as experience with designing ETL control flows, using and debugging SSIS packages, accessing and importing or exporting data from multiple sources, and managing a SQL data warehouse. Implementing a SQL Data Warehouse About the Exam Exam 70-767 focuses on skills and knowledge required for working with relational database technology. About Microsoft Certification Passing this exam earns you credit toward a Microsoft Certified Professional (MCP) or Microsoft Certified Solutions Associate (MCSA) certification that demonstrates your mastery of data warehouse management Passing this exam as well as Exam 70-768 (Developing SQL Data Models) earns you credit toward a Microsoft Certified Solutions Associate (MCSA) SQL 2016 Business Intelligence (BI) Development certification. See full details at: microsoft.com/learning
Get started with the new Access 2013 with this impressive all-in-one reference! Microsoft Access allows you to store, organize, view, analyze, and share data; the new release enables you to build even more powerful, custom database solutions that integrate with the web and enterprise data sources. This compilation of nine indispensible minibooks is exactly what you need to get up to speed on the latest changes to Access. This easy-to-understand resource provides both new and experienced Access users with invaluable advice for connecting Access to SQL Server, manipulating data locally, getting up to speed on the latest features of Access 2013, creating queries and macros, and much more. From the basics to advanced functions, this book is what you need to make Access more accessible. * Shows you how to store, organize, view, analyze, and share data using Access 2013 * Includes nine minibooks that cover such topics as database design, tables, queries, forms, reports, macros, database administration, securing data, programming with Visual Basic for Applications (VBA), and using Access with the web * Helps you build database solutions that integrate with the web and other enterprise data solutions * Offers plenty of techniques, tips, and tricks to help you get the most out of Access This all-in-one guide offers you access to all things Access 2013!
Take the right steps when a breach of your Oracle Database environment becomes known or suspected. You will learn techniques for discerning how an attacker got in, what data they saw, and what else they might have done. This book helps you understand forensics in relation to Oracle Database, and the tools and techniques that should be used to investigate a database breach. You will learn the measures to put in place now to make it harder for an attack to be successful, and to aid in the detection and investigation of future attacks. You will know how to bring together tools and methods to create a holistic approach and investigation when an event occurs, helping you to be confident of your ability to react correctly and responsibly to threats against your organization's data. What You'll Learn Detect when breaches have or may have occurred React with confidence using an organized plan Determine whether a suspected breach is real Determine the scope of data that has been compromised Preserve evidence for possible criminal prosecutions Put in place measures to aid future investigations Who This Book is For Database administrators, system administrators, and other technology professionals who may be called upon to investigate breaches of security involving Oracle Database
Loved by instructors for the visual and flexible way to build computer skills, the Illustrated Course Guides are ideal for teaching Microsoft Access 2013 to students across experience levels. Each two-page spread focuses on a single skill, making information easy to follow and absorb. The Illustrated Course Guides split Microsoft Access 2013 concepts and skills into three manageable levels - Basic, Intermediate, and Advanced - perfect for workshops or accelerated courses.
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 Data Guard 11g Provide superior data protection, availability, and disaster recovery using the tested techniques in this Oracle Press guide. Cowritten by a team of Oracle experts, Oracle Data Guard 11g Handbook provides a sound architectural foundation along with best practices for configuration, monitoring, maintenance, and troubleshooting. You will get full details on implementing deployment architectures to address requirements that extend beyond disaster recovery. This invaluable resource also includes a complete set of monitoring scripts available for download. Develop a disaster recovery plan for your Oracle database to meet your organization's requirements Configure and deploy Oracle Data Guard for your environment Tune and troubleshoot your physical and logical standby databases Implement the Oracle Data Guard Broker management framework Integrate with Oracle Grid Control Monitor your Oracle Data Guard environment Enable read-only services and disaster recovery with Oracle Active Data Guard Configure seamless database and application failover Minimize planned downtime using Oracle Data Guard switchover Handle backup and recovery with Oracle Recovery Manager
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 Definitive Guide to SQL Get comprehensive coverage of every aspect of SQL from three leading industry experts. Revised with coverage of the latest RDBMS software versions, this one-stop guide explains how to build, populate, and administer high-performance databases and develop robust SQL-based applications. SQL: The Complete Reference, Third Edition shows you how to work with SQL commands and statements, set up relational databases, load and modify database objects, perform powerful queries, tune performance, and implement reliable security policies. Learn how to employ DDL statements and APIs, integrate XML and Java scripts, use SQL objects, build web servers, handle remote access, and perform distributed transactions. Techniques for managing in-memory, stream, and embedded databases that run on today's mobile, handheld, and wireless devices are included in this in-depth volume. Build SQL-based relational databases and applications Create, load, and modify database objects using SQL Construct and execute simple, multitable, and summary queries Implement security measures with authentication, privileges, roles, and views Handle database optimization, backup, recovery, and replication Work with stored procedures, functions, extensions, triggers, and objects Extend functionality using APIs, dynamic SQL, and embedded SQL Explore advanced topics such as DBMS transactions, locking mechanisms, materialized views, and two-phase commit protocol Understand the latest market trends and the future of SQL
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 the Business Intelligence Tools in Microsoft SQL Server 2008 Manage, analyze, and distribute enterprise data with help from this expert resource. Delivering Business Intelligence with Microsoft SQL Server 2008 covers the entire BI lifecycle and explains how to build robust data integration, reporting, and analysis solutions. Real-world examples illustrate all of the powerful BI capabilities of SQL Server 2008. This is your one-stop guide for transforming disparate data into actionable insight for users throughout your organization. Understand the goals and benefits of business intelligence Design and create relational data marts and OLAP cubes Manage Analysis Services databases using BI Development Studio Cleanse data and populate data marts with SQL Server Integration Services Take advantage of the flexibility of the Unified Dimensional Model Manipulate and analyze data using MDX scripts and queries Use data mining to identify data patterns, correlations, and clustering Develop and distribute interactive reports with SQL Server 2008 Reporting Services Integrate business intelligence into enterprise applications using ADOMD.NET and the Report Viewer Control
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. Best Practices for Deploying and Managing Master Data Services (MDS)Effectively manage master data and drive better decision making across your enterprise with detailed instruction from two MDS experts. Microsoft SQL Server 2008 R2 Master Data Services Implementation & Administration shows you how to use MDS to centralize the management of key data within your organization. Find out how to build an MDS model, establish hierarchies, govern data access, and enforce business rules. Legacy system integration and security are also covered. Real-world programming examples illustrate the material presented in this comprehensive guide. Create a process-agnostic solution for managing your business domains Learn how to take advantage of the data modeling capabilities of MDS Manage hierarchies and consolidations across your organization Import data by using SQL Server Integration Services and T-SQL statements Ensure data accuracy and completeness by using business rules and versioning Employ role-based security at functional, object, and attribute levels Design export views and publish data to subscribing systems Use Web services to progrmmatically interact with your implementation
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. Design and Deliver PeopleSoft Enterprise Resource Planning Solutions Develop data-driven Oracle PeopleSoft applications and business intelligence reports with help from the expert advice in this Oracle Press guide. PeopleSoft Developer's Guide for PeopleTools & PeopleCode shows you how to build and enhance PeopleSoft modules that maximize return on investment. Set up PeopleSoft Pure Internet Architecture, create PeopleCode projects, integrate HTML and Web features, and create reports with Oracle XML Publisher. You will also learn how to use COBOL, SQR, PeopleSoft Application Engine, and Middleware integration. Install and configure PeopleSoft Pure Internet Architecture Work with PeopleCode components, objects, and classes Build pages and modules using the PeopleTools application designer Add HTML and Web elements in PeopleCode Implement code on the middle tier tools and work with process manager Execute powerful batch processes with application engine Generate detailed reports using Oracle XML Publisher and SQR Debug, secure, and optimize your PeopleSoft applications
Book + Content Update Program SQL Server 2016 High Availability Unleashed provides start-to-finish coverage of SQL Server's powerful high availability (HA) solutions for your traditional on-premise databases, cloud-based databases (Azure or AWS), hybrid databases (on-premise coupled with the cloud), and your emerging Big Data solutions. This complete guide introduces an easy-to-follow, formal HA methodology that has been refined over the past several years and helps you identity the right HA solution for your needs. There is also additional coverage of both disaster recovery and business continuity architectures and considerations. You are provided with step-by-step guides, examples, and sample code to help you set up, manage, and administer these highly available solutions. All examples are based on existing production deployments at major Fortune 500 companies around the globe. This book is for all intermediate-to-advanced SQL Server and Big Data professionals, but is also organized so that the first few chapters are great foundation reading for CIOs, CTOs, and even some tech-savvy CFOs. Learn a formal, high availability methodology for understanding and selecting the right HA solution for your needs Deep dive into Microsoft Cluster Services Use selective data replication topologies Explore thorough details on AlwaysOn and availability groups Learn about HA options with log shipping and database mirroring/ snapshots Get details on Microsoft Azure for Big Data and Azure SQL Explore business continuity and disaster recovery Learn about on-premise, cloud, and hybrid deployments Provide all types of database needs, including online transaction processing, data warehouse and business intelligence, and Big Data Explore the future of HA and disaster recovery In addition, this book is part of InformIT's exciting Content Update Program, which provides content updates for major technology improvements! As significant updates are made to SQL Server, sections of this book will be updated or new sections will be added to match the updates to the technologies. As updates become available, they will be delivered to you via a free Web Edition of this book, which can be accessed with any Internet connection. To learn more, visit informit.com/cup. How to access the Web Edition: Follow the instructions inside to learn how to register your book to access the FREE Web Edition.
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. Design and Deploy Highly Responsive Data-Driven Web 2.0 Applications Deliver next-generation user capabilities and client-side services in your Oracle-based Web applications by combining the powerful features of AJAX and PHP. Written by Web 2.0 programming experts, Oracle Database AJAX & PHP Web Application Development shows you how to design faster, lighter, more responsive Web applications while reducing code support and creation time. You'll learn how to develop modular AJAX and PHP code, add dynamically updated content, and implement click-to-edit and drag-and-drop functionality. You'll also get details on incorporating cutting-edge mashup, reporting, and communication features. Build robust Web applications that utilize the latest AJAX, PHP, and modularity techniques Construct AJAX and PHP objects, controllers, iframes, and models Simplify programming with reusable modules, open-source libraries, and templates Optimize scalability, availability, performance, and security Auto-refresh Web pages and execute XML calls using the HttpRequest object Add HTML drill-down tables, DOM drag-and-drop, and click-to-edit features Retrieve data from external sources using Remote Procedure Calls and Pear-based services Solve browser navigation button, bookmarking, and history tracking issues Allow end users to customize Web pages using tracking, JSON, and mashups Facilitate client-side communication with VOIP, IM, targeted reporting, and file sharing
CREATE ROBUST DATA MANAGEMENT AND BUSINESS INTELLIGENCE APPLICATIONS
Build powerful, enterprise-wide database programs using Microsoft SQL Server 2005 and the comprehensive information contained in this definitive volume. "Microsoft SQL Server 2005 Developer's Guide" explains how to develop server-side and client-side database applications and analyze business intelligence data. All of the brand-new features are covered in-depth -- including .NET CLR Integration, Reporting Services, Integration Services, Notification Services, and Service Broker. Real-world examples and practical tips detail how to use SQL Server 2005 as a cross-tier database platform with Visual Studio 2005, create custom management scripts with SQLCMD, and improve performance with SQL Profiler.
ESSENTIAL SKILLS FOR DATABASE PROFESSIONALS Use SQL Server Management Studio and Business Intelligence Development Studio Write stored procedures and use T-SQL Data Definition Language (DDL) and Data Manipulation Language (DML) Create custom database objects with .NET CLR Build enterprise database applications using ADO, ADO.NET, and ADOMD.NET Develop and deploy SQL Server Integration Services packages Design enterprise reports using Reporting Services and Report Builder Integrate cross-platform data using XML and Web services Extend SQL Server manageability using SQL Management Objects (SMO)
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. FOREWORD by Tom Kyte Your Must-Have Guide to Everything New in Oracle Database 11g Realize the full potential of Oracle Database 11g with help from the experts. Written by Robert G. Freeman, and with insightful commentary throughout from Arup Nanda, this Oracle Press guide offers full details on the architectural changes, database administration upgrades, availability and recovery revisions, security enhancements, and programming innovations. Every new and updated feature is covered and presented with screenshots, code samples, tables, and charts. Find out how to take full advantage of all the new and improved capabilities of Oracle Database 11g, including: New Oracle Automatic Storage Management features, such as Fast Disk Resync, Compatibility Attributes, Preferred Mirror Read, and Rolling Upgrade components Improved Automated Memory Management capabilities New database design features, such as virtual columns, tablespace encryption, and true table-level data compression New Database Advisors for data recovery and repair, partitioning, and streams performance New tuning features, such as Automatic SQL Tuning and SQL Performance Analyzer Enhancements to Oracle RMAN, including active database duplication and UNDO backup optimization Improved auditing and security capabilities Advanced BI, data warehousing, and partitioning features New SQL and PL/SQL enhancements
Work with Oracle database's high-availability and disaster-management technologies. This book covers all the Oracle high-availability technologies in one place and also discusses how you configure them in engineered systems and cloud services. You will see that when you say your database is healthy, it is not limited to whether the database is performing well on day-to-day operations; rather it should also be robust and free from disasters. As a result, your database will be capable of handling unforeseen incidents and recovering from disaster with very minimal or zero downtime. Oracle High Availability, Disaster Recovery, and Cloud Services explores all the high-availability features of Oracle database, how to configure them, and best practices. After you have read this book you will have mastered database high-availability concepts such as RAC, Data Guard, OEM 13c, and engineered systems (Oracle Exadata x6/x7 and Oracle Database Appliance). What You Will Learn Master the best practices and features of Exadata and ODA Implement and monitor high availability with OEM 13c Clone databases using various methods in Oracle 12c R2 Work with the Oracle sharding features of Oracle 12c R2 Who This Book Is ForOracle database administrators
Upgrading Relational Databases with Objects presents a clear-headed overview of how to use object-oriented (OO) technology to improve existing relational databases. This practical how-to guide starts with the basics of OO and works its way up to examples and what-if scenarios that illustrate how OO technology is, should be and should not be integrated with relational databases. It draws a keen distinction between applications that can be best performed with each technology. The book describes such object technologies as OLE and CORBA and what their impacts will be on relational database connectivity and provides a brief tutorial on relational and object concepts. It then moves on to advanced object/relational, SQL3, OO database technology and the Internet.
Written for readers who have little or no previous experience with databases, SQL, or Microsoft SQL Server database software, this book provides a systematic approach to learning SQL (Structured Query Language) using SQL Server database software. It starts with simple SQL concepts, and progresses to more complex query development. Each chapter is written in a step-by-step manner and has examples that can be executed using SQL Server. Using the sample database, readers can experience hands-on SQL programming in SQL Server. This text also presents exercises at the end of the chapters to help readers gain proficiency in SQL.
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. Develop and Deploy Fast, Secure Web ApplicationsEven if you have limited programming experience, you can develop and deploy professional-quality applications using Oracle's new rapid web application development tool. Oracle HTML DB Handbook shows you how to quickly create secure and scalable web applications that can be instantly deployed. Learn how you can consolidate spreadsheets and desktop databases into an Oracle Database and share your applications over the web. You'll also get details on administration and security. Real-world sample projects get you started using Oracle HTML DB right away. Install and configure Oracle HTML DB Work with Oracle database objects using SQL Workshop Create, review, edit, run and delete application elements with the HTML DB Application Builder Work with themes and templates Create, edit, and delete HTML DB pages Work with reports and process forms Implement navigational elements in applications Administer and manage applications and users Add computations, processes, and validations to applications Implement HTML DB security measures
Transform disparate enterprise data into actionable business intelligence
Put timely, mission-critical information in the hands of employees across your organization using Microsoft SQL Server 2005 and the comprehensive information in this unique resource. "Delivering Business Intelligence with Microsoft SQL Server 2005" shows you, step-by-step, how to author, customize, and distribute information that will give your company the competitive edge. It's all right here -- from data mining, warehousing, and scripting techniques to MDX queries, KPI analysis, and the all-new Unified Dimensional Model. Real-world examples, start-to-finish exercises, and downloadable code throughout illustrate all of the integration, analysis, and reporting capabilities of SQL Server 2005.
ESSENTIAL SKILLS FOR DATABASE PROFESSIONALSUnderstand the goals and benefits of business intelligence Manage Analysis Services databases using BI Development Studio Improve performance and decrease latency using proactive caching Create interactive reports using SQL Server 2005 Reporting Services Enable ad hoc reporting using Report Models and Report Builder Integrate with applications using ADOMD.NET and the Report Viewer Control Design and create relational data marts and OLAP cubes Perform powerful data analysis using MDX queries and scripts Perform complex operations with Integration Services Uncover behavior patterns and proclivities using data mining
Prepare for Microsoft Exam 70-765-and help demonstrate your real-world mastery of provisioning SQL Server databases both on premise and in SQL Azure. 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: * Implement SQL in Azure * Manage databases and instances * Manage storage This Microsoft Exam Ref: * Organizes its coverage by exam objectives * Features strategic, what-if scenarios to challenge you * Assumes you have working knowledge of SQL Server administration and maintenance, as well as Azure skills Provisioning SQL Databases About the Exam Exam 70-765 focuses on skills and knowledge for provisioning, upgrading, and configuring SQL Server; managing databases and files; and provisioning, migrating, and managing databases in the Microsoft Azure cloud. About Microsoft Certification Passing this exam as well as Exam 70-764: Administering a SQL Database Infrastructure earns you MCSA: SQL 2016 Database Administration certification, qualifying you for a position as a database administrator or infrastructure specialist. See full details at: microsoft.com/learning
Carry out data analysis with PySpark SQL, graphframes, and graph data processing using a problem-solution approach. This book provides solutions to problems related to dataframes, data manipulation summarization, and exploratory analysis. You will improve your skills in graph data analysis using graphframes and see how to optimize your PySpark SQL code. PySpark SQL Recipes starts with recipes on creating dataframes from different types of data source, data aggregation and summarization, and exploratory data analysis using PySpark SQL. You'll also discover how to solve problems in graph analysis using graphframes. On completing this book, you'll have ready-made code for all your PySpark SQL tasks, including creating dataframes using data from different file formats as well as from SQL or NoSQL databases. What You Will Learn Understand PySpark SQL and its advanced features Use SQL and HiveQL with PySpark SQL Work with structured streaming Optimize PySpark SQL Master graphframes and graph processing Who This Book Is ForData scientists, Python programmers, and SQL programmers.
Loved by instructors for its visual and flexible way to build computer skills, the Illustrated Series is ideal for teaching Microsoft Office Access 2010 to both computer rookies and hotshots. Each two-page spread focuses on a single skill, making information easy to follow and absorb. Large, full-color illustrations represent how the students' screen should look. Concise text introduces the basic principles of the lesson and integrates a case study for further application.
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. Step-by-Step, Full-Color Graphics!Get started using Access 2007 right away--the QuickSteps way. Color screenshots and clear instructions show you how to use all the new and improved features. Follow along and learn to work with the new Office interface and ribbon, create databases and tables, and enter and edit data. You'll also find out how to retrieve information, create forms, and generate reports. Plus, you can flip straight to the information you need easily using the color-coded tabs. Get the book that gets you started using Access 2007 in no time. In each chapter: Shortcuts for accomplishing common tasks Need-to-know facts in concise narrative Helpful reminders or alternate ways of doing things Bonus information related to the topic being covered Errors and pitfalls to avoid
You may like...
Access 2016 For Dummies
Laurie A Ulrich, Ken Cook Paperback
Professional Microsoft SQL Server 2016…
Paul Turley Paperback
Oracle Exalogic Elastic Cloud Handbook
Tom Plunkett, Tj Palazzolo, … Paperback
Access 2019 For Dummies
Laurie A Ulrich, Ken Cook Paperback (1)
Oracle Database 10g Real Application…
K. Gopalakrishnan Paperback
Database Systems: Pearson New…
Hector Garcia-Molina, Jeffrey Ullman, … Paperback R1,722 Discovery Miles 17 220
Oracle Database 12c Install, Configure…
Ian Abramson, Michael Abbey, … Paperback
New Perspectives Microsoft Office 365…
Mark Shellman, Sasha Vodnik Paperback
Problem Solving Cases in MS Access…
Ellen Monk, Joseph Brady, … Paperback
Access 2016 Bible
Michael Alexander, Richard Kusleika Paperback