SQL Pocket Primer

SQL Pocket Primer
Title SQL Pocket Primer PDF eBook
Author Oswald Campesato
Publisher Mercury Learning and Information
Pages 329
Release 2022-03-09
Genre Computers
ISBN 1683928121

Download SQL Pocket Primer Book in PDF, Epub and Kindle

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

Microsoft Access Programming Pocket Primer

Microsoft Access Programming Pocket Primer
Title Microsoft Access Programming Pocket Primer PDF eBook
Author Julitta Korol
Publisher Mercury Learning and Information
Pages 288
Release 2015-05-15
Genre Computers
ISBN 1942270593

Download Microsoft Access Programming Pocket Primer Book in PDF, Epub and Kindle

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

Dealing With Data Pocket Primer

Dealing With Data Pocket Primer
Title Dealing With Data Pocket Primer PDF eBook
Author Oswald Campesato
Publisher Mercury Learning and Information
Pages 218
Release 2022-05-04
Genre Computers
ISBN 1683928180

Download Dealing With Data Pocket Primer Book in PDF, Epub and Kindle

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

Java for Developers Pocket Primer

Java for Developers Pocket Primer
Title Java for Developers Pocket Primer PDF eBook
Author Oswald Campesato
Publisher Mercury Learning and Information
Pages 298
Release 2022-11-30
Genre Computers
ISBN 1683925483

Download Java for Developers Pocket Primer Book in PDF, Epub and Kindle

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

SQL Primer

SQL Primer
Title SQL Primer PDF eBook
Author Rahul Batra
Publisher Apress
Pages 199
Release 2018-06-15
Genre Computers
ISBN 1484235762

Download SQL Primer Book in PDF, Epub and Kindle

Build a core level of competency in SQL so you can recognize the parts of queries and write simple SQL statements. SQL knowledge is essential for anyone involved in programming, data science, and data management. This book covers features of SQL that are standardized and common across most database vendors. You will gain a base of knowledge that will prepare you to go deeper into the specifics of any database product you might encounter. Examples in the book are worked in PostgreSQL and SQLite, but the bulk of the examples are platform agnostic and will work on any database platform supporting SQL. Early in the book you learn about table design, the importance of keys as row identifiers, and essential query operations. You then move into more advanced topics such as grouping and summarizing, creating calculated fields, joining data from multiple tables when it makes business sense to do so, and more. Throughout the book, you are exposed to a set-based approach to the language and are provided a good grounding in subtle but important topics such as the effects of null value on query results. With the explosion of data science, SQL has regained its prominence as a top skill to have for technologists and decision makers worldwide. SQL Primer will guide you from the very basics of SQL through to the mainstream features you need to have a solid, working knowledge of this important, data-oriented language. What You'll Learn Create and populate your own database tables Read SQL queries and understand what they are doing Execute queries that get correct results Bring together related rows from multiple tables Group and sort data in support of reporting applications Get a grip on nulls, normalization, and other key concepts Employ subqueries, unions, and other advanced features Who This Book Is For Anyone new to SQL who is looking for step-by-step guidance toward understanding and writing SQL queries. The book is aimed at those who encounter SQL statements often in their work, and provides a sound baseline useful across all SQL database systems. Programmers, database managers, data scientists, and business analysts all can benefit from the baseline of SQL knowledge provided in this book.

Python Tools for Data Scientists Pocket Primer

Python Tools for Data Scientists Pocket Primer
Title Python Tools for Data Scientists Pocket Primer PDF eBook
Author Oswald Campesato
Publisher Mercury Learning and Information
Pages 434
Release 2022-10-21
Genre Computers
ISBN 1683928210

Download Python Tools for Data Scientists Pocket Primer Book in PDF, Epub and Kindle

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

Oracle SQL Tuning Pocket Reference

Oracle SQL Tuning Pocket Reference
Title Oracle SQL Tuning Pocket Reference PDF eBook
Author Mark Gurry
Publisher "O'Reilly Media, Inc."
Pages 113
Release 2002-01-01
Genre Computers
ISBN 0596552130

Download Oracle SQL Tuning Pocket Reference Book in PDF, Epub and Kindle

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.