Download or read book SQL Pocket Primer written by Oswald Campesato and published by Mercury Learning and Information. This book was released on 2022-03-09 with total page 329 pages. Available in PDF, EPUB and Kindle. Book excerpt: As part of the best-selling Pocket Primer series, this book is primarily for data scientists and machine learning engineers who want to expand their current knowledge of SQL using MySQL as the primary RDBMS. It includes Python-based code samples to access data from a MySQL table in a Pandas data frame and Java-based code samples for accessing data in a MySQL database, along with XML documents and JSON documents. The book also introduces NoSQL, presents an overview of MongoDB, and SQLite--an open-source RDBMS available on mobile devices. The final chapter of the book covers a diverse set of miscellaneous topics, such as normalization, schemas, database optimization, and performance. Numerous code samples and listings are included to support myriad topics. Companion files with source code and figures are available from the publisher. FEATURES: Covers extensive topics related to SQL, using MySQL as the primary RDBMS Introduces NoSQL, presents an overview of MongoDB, and SQLite--an open-source RDBMS available on mobile devices Features companion files with source code and figures from the book

Download or read book Microsoft Access Programming Pocket Primer written by Julitta Korol and published by Mercury Learning and Information. This book was released on 2015-05-15 with total page 288 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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

Download or read book Dealing With Data Pocket Primer written by Oswald Campesato and published by Mercury Learning and Information. This book was released on 2022-05-04 with total page 218 pages. Available in PDF, EPUB and Kindle. Book excerpt: As part of the best-selling Pocket Primer series, this book is designed to introduce the reader to the basic concepts of managing data using a variety of computer languages and applications. It is intended to be a fast-paced introduction to some basic features of data management and covers statistical concepts, data-related techniques, features of Pandas, RDBMS, SQL, NLP topics, Matplotlib, and data visualization. Companion files with source code and color figures are available. FEATURES: Covers Pandas, RDBMS, NLP, data cleaning, SQL, and data visualization Introduces probability and statistical concepts Features numerous code samples throughout Includes companion files with source code and figures

Download or read book Java for Developers Pocket Primer written by Oswald Campesato and published by Mercury Learning and Information. This book was released on 2022-11-30 with total page 298 pages. Available in PDF, EPUB and Kindle. Book excerpt: As part of the best-selling Pocket Primer series, this book is designed to provide a thorough introduction to Java development for people who are relatively new to the Java programming language. It is intended to be a fast-paced introduction to the core concepts of Java and Java APIs, illustrated with code samples using primarily Java 8. Companion files with source code are available. FEATURES: Covers Boolean logic, loops, arrays, recursion, OOP concepts, data structures, streams, SQL, and more Lists new features in Java 9 through Java 13 Features numerous code samples throughout Includes companion files with source code

Download or read book Python Tools for Data Scientists Pocket Primer written by Oswald Campesato and published by Mercury Learning and Information. This book was released on 2022-10-21 with total page 434 pages. Available in PDF, EPUB and Kindle. Book excerpt: As part of the best-selling Pocket Primer series, this book is designed to provide a thorough introduction to numerous Python tools for data scientists. The book covers features of NumPy and Pandas, how to write regular expressions, and how to perform data cleaning tasks. It includes separate chapters on data visualization and working with Sklearn and SciPy. Companion files with source code are available. FEATURES: Introduces Python, NumPy, Sklearn, SciPy, and awk Covers data cleaning tasks and data visualization Features numerous code samples throughout Includes companion files with source code

Download or read book Oracle SQL Tuning Pocket Reference written by Mark Gurry and published by "O'Reilly Media, Inc.". This book was released on 2002-01-01 with total page 113 pages. Available in PDF, EPUB and Kindle. Book excerpt: One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. Poorly tuned SQL statements are one of the leading causes of substandard database performance and poor response time. SQL statements that perform poorly result in frustration for users, and can even prevent a company from serving its customers in a timely manner. In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark's knowledge is the result of many hard-fought tuning battles during his many years of providing Oracle tuning services to clients. Mark provides insights into the workings of the rule-based optimizer that go well beyond what the rules tell you. Mark also provides solutions to many common problems that occur with both the rule-based and cost-based optimizers. In addition to the specific problem/solution scenarios for the optimizers, Mark provides a number of handy SQL tuning tips. He discusses the various optimizer hints, telling you when they can be used to good effect. Finally, Mark discusses the use of the DBMS_STATS package to manage database statistics, and the use of outlines to specify execution plans for SQL statements in third-party applications that you can't otherwise modify.

Download or read book Microsoft Word and Excel 2013 365 written by Theodor Richardson and published by Mercury Learning and Information. This book was released on 2014-10-20 with total page 402 pages. Available in PDF, EPUB and Kindle. Book excerpt: As part of the new Pocket Primer series, this book provides an overview of the major concepts and tutorial videos to use Word and Excel. The book serves as a starting point for deeper exploration of Word and Excel. The focus of this book is on using these two software packages and includes instruction for Word 365, which includes both Word 2013 for Windows and Word 2011 for Macintosh. Features: Includes tutorial videos on the companion DVD Provides an overview of the most important Word and Excel techniques Contains Word and Excel graphics and animation effects

Download or read book Data Science Fundamentals Pocket Primer written by Oswald Campesato and published by Mercury Learning and Information. This book was released on 2021-05-12 with total page 428 pages. Available in PDF, EPUB and Kindle. Book excerpt: As part of the best-selling Pocket Primer series, this book is designed to introduce the reader to the basic concepts of data science using Python 3 and other computer applications. It is intended to be a fast-paced introduction to some basic features of data analytics and also covers statistics, data visualization, linear algebra, and regular expressions. The book includes numerous code samples using Python, NumPy, R, SQL, NoSQL, and Pandas. Companion files with source code and color figures are available. FEATURES: Includes a concise introduction to Python 3 and linear algebra Provides a thorough introduction to data visualization and regular expressions Covers NumPy, Pandas, R, and SQL Introduces probability and statistical concepts Features numerous code samples throughout Companion files with source code and figures

Download or read book Learning SQL written by Alan Beaulieu and published by O'Reilly Media. This book was released on 2009-04-11 with total page 338 pages. Available in PDF, EPUB and Kindle. Book excerpt: Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals. Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will: Move quickly through SQL basics and learn several advanced features Use SQL data statements to generate, manipulate, and retrieve data Create database objects, such as tables, indexes, and constraints, using SQL schema statements Learn how data sets interact with queries, and understand the importance of subqueries Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.

Download or read book SQL Injection Attacks and Defense written by Justin Clarke-Salt and published by Elsevier. This book was released on 2012-06-18 with total page 577 pages. Available in PDF, EPUB and Kindle. Book excerpt: What is SQL injection? -- Testing for SQL injection -- Reviewing code for SQL injection -- Exploiting SQL injection -- Blind SQL injection exploitation -- Exploiting the operating system -- Advanced topics -- Code-level defenses -- Platform level defenses -- Confirming and recovering from SQL injection attacks -- References.

Download or read book Android written by Oswald Campesato and published by Mercury Learning and Information. This book was released on 2017-04-13 with total page 322 pages. Available in PDF, EPUB and Kindle. Book excerpt: As part of the best selling Pocket Primer series, this book provides an overview of the major aspects and the source code to use the latest versions of Android. It has coverage of the fundamental aspects of Android that are illustrated via code samples for versions 4.x through 7.x and features the Google Pixel phone. This Pocket Primer is primarily for self-directed learners who want to learn Android programming and it serves as a starting point for deeper exploration of its numerous applications. Companion disc (also available for downloading from the publisher) with source code, images, and appendices. Features: •Contains latest material on Android VR, graphics/animation, apps, and features the new Google Pixel phone •Includes companion files with all of the source code, appendices, and images from the book •Provides coverage of the fundamental aspects of Android that are illustrated via code samples for versions 4.x through 7.x On the Companion Files: • Source code samples • All images from the text (including 4-color) • Appendices (see Table of Contents)

Download or read book Sams Teach Yourself Microsoft SQL Server T SQL in 10 Minutes written by Ben Forta and published by Sams Publishing. This book was released on 2007 with total page 0 pages. Available in PDF, EPUB and Kindle. Book excerpt: An action-oriented, project-based self study guide to the essentials of Transact-SQL, the SQL variant used in the Microsoft SQL Server.

Download or read book SQL Cookbook written by Anthony Molinaro and published by "O'Reilly Media, Inc.". This book was released on 2006 with total page 632 pages. Available in PDF, EPUB and Kindle. Book excerpt: A guide to SQL covers such topics as retrieving records, metadata queries, working with strings, data arithmetic, date manipulation, reporting and warehousing, and hierarchical queries.

Download or read book HTML5 Mobile written by Oswald Campesato and published by Mercury Learning and Information. This book was released on 2013-11-30 with total page 261 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book provides HTML5 technologies for developing HTML5 Mobile hybrid mobile applications, primarily for self-directed learners who are comfortable with HTML/Javascript and who want to learn how to create mobile applications using HTML5 for Android and iOS. Readers will learn how to use CSS3 and HTML5 Canvas to render 2D shapes, apply transformations, and create animation effects. Readers will learn about JavaScript toolkits such as jQuery Mobile, PhoneGap, and D3 for creating HTML5 hybrid mobile applications. FEATURES * Discusses various HTML5 APIs with Android and iOS * Contains CSS3 and HTML5 Canvas graphics and animation effects * Uses jQuery Mobile to develop hybrid HTML5 Mobile apps * Uses PhoneGap to develop hybrid HTML5 Mobile apps * Provides supplemental code samples and videos on the DVD eBook Customers: Companion files are available for downloading with order number/proof of purchase by writing to the publisher at [email protected].

Download or read book Essential Math for Data Science written by Thomas Nield and published by "O'Reilly Media, Inc.". This book was released on 2022-05-26 with total page 357 pages. Available in PDF, EPUB and Kindle. Book excerpt: Master the math needed to excel in data science, machine learning, and statistics. In this book author Thomas Nield guides you through areas like calculus, probability, linear algebra, and statistics and how they apply to techniques like linear regression, logistic regression, and neural networks. Along the way you'll also gain practical insights into the state of data science and how to use those insights to maximize your career. Learn how to: Use Python code and libraries like SymPy, NumPy, and scikit-learn to explore essential mathematical concepts like calculus, linear algebra, statistics, and machine learning Understand techniques like linear regression, logistic regression, and neural networks in plain English, with minimal mathematical notation and jargon Perform descriptive statistics and hypothesis testing on a dataset to interpret p-values and statistical significance Manipulate vectors and matrices and perform matrix decomposition Integrate and build upon incremental knowledge of calculus, probability, statistics, and linear algebra, and apply it to regression models including neural networks Navigate practically through a data science career and avoid common pitfalls, assumptions, and biases while tuning your skill set to stand out in the job market

Download or read book State of the Computer Book Market 2011 written by Mike Hendrickson and published by "O'Reilly Media, Inc.". This book was released on 2012-05-01 with total page 67 pages. Available in PDF, EPUB and Kindle. Book excerpt: This annual report examines the key trends and developments -- most notably, the demise of Borders -- that shaped the 2011 computer book market.

Download or read book Data Pipelines Pocket Reference written by James Densmore and published by O'Reilly Media. This book was released on 2021-02-10 with total page 277 pages. Available in PDF, EPUB and Kindle. Book excerpt: Data pipelines are the foundation for success in data analytics. Moving data from numerous diverse sources and transforming it to provide context is the difference between having data and actually gaining value from it. This pocket reference defines data pipelines and explains how they work in today's modern data stack. You'll learn common considerations and key decision points when implementing pipelines, such as batch versus streaming data ingestion and build versus buy. This book addresses the most common decisions made by data professionals and discusses foundational concepts that apply to open source frameworks, commercial products, and homegrown solutions. You'll learn: What a data pipeline is and how it works How data is moved and processed on modern data infrastructure, including cloud platforms Common tools and products used by data engineers to build pipelines How pipelines support analytics and reporting needs Considerations for pipeline maintenance, testing, and alerting