SQL and Relational Theory

SQL and Relational Theory
Author: C. Date
Publisher: "O'Reilly Media, Inc."
Total Pages: 447
Release: 2011-12-16
Genre: Computers
ISBN: 1449316409

SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put the theory into practice. In this insightful book, author C.J. Date explains relational theory in depth, and demonstrates through numerous examples and exercises how you can apply it directly to your use of SQL. This second edition includes new material on recursive queries, “missing information” without nulls, new update operators, and topics such as aggregate operators, grouping and ungrouping, and view updating. If you have a modest-to-advanced background in SQL, you’ll learn how to deal with a host of common SQL dilemmas. Why is proper column naming so important? Nulls in your database are causing you to get wrong answers. Why? What can you do about it? Is it possible to write an SQL query to find employees who have never been in the same department for more than six months at a time? SQL supports “quantified comparisons,” but they’re better avoided. Why? How do you avoid them? Constraints are crucially important, but most SQL products don’t support them properly. What can you do to resolve this situation? Database theory and practice have evolved since the relational model was developed more than 40 years ago. SQL and Relational Theory draws on decades of research to present the most up-to-date treatment of SQL available. C.J. Date has a stature that is unique within the database industry. A prolific writer well known for the bestselling textbook An Introduction to Database Systems (Addison-Wesley), he has an exceptionally clear style when writing about complex principles and theory.

Eloquent JavaScript, 3rd Edition

Eloquent JavaScript, 3rd Edition
Author: Marijn Haverbeke
Publisher: No Starch Press
Total Pages: 474
Release: 2018-12-04
Genre: Computers
ISBN: 1593279507

Completely revised and updated, this best-selling introduction to programming in JavaScript focuses on writing real applications. JavaScript lies at the heart of almost every modern web application, from social apps like Twitter to browser-based game frameworks like Phaser and Babylon. Though simple for beginners to pick up and play with, JavaScript is a flexible, complex language that you can use to build full-scale applications. This much anticipated and thoroughly revised third edition of Eloquent JavaScript dives deep into the JavaScript language to show you how to write beautiful, effective code. It has been updated to reflect the current state of Java¬Script and web browsers and includes brand-new material on features like class notation, arrow functions, iterators, async functions, template strings, and block scope. A host of new exercises have also been added to test your skills and keep you on track. As with previous editions, Haverbeke continues to teach through extensive examples and immerses you in code from the start, while exercises and full-chapter projects give you hands-on experience with writing your own programs. You start by learning the basic structure of the JavaScript language as well as control structures, functions, and data structures to help you write basic programs. Then you'll learn about error handling and bug fixing, modularity, and asynchronous programming before moving on to web browsers and how JavaScript is used to program them. As you build projects such as an artificial life simulation, a simple programming language, and a paint program, you'll learn how to: - Understand the essential elements of programming, including syntax, control, and data - Organize and clarify your code with object-oriented and functional programming techniques - Script the browser and make basic web applications - Use the DOM effectively to interact with browsers - Harness Node.js to build servers and utilities Isn't it time you became fluent in the language of the Web? * All source code is available online in an inter¬active sandbox, where you can edit the code, run it, and see its output instantly.

Think Java

Think Java
Author: Allen B. Downey
Publisher: "O'Reilly Media, Inc."
Total Pages: 251
Release: 2016-05-06
Genre: Computers
ISBN: 1491929537

Currently used at many colleges, universities, and high schools, this hands-on introduction to computer science is ideal for people with little or no programming experience. The goal of this concise book is not just to teach you Java, but to help you think like a computer scientist. You’ll learn how to program—a useful skill by itself—but you’ll also discover how to use programming as a means to an end. Authors Allen Downey and Chris Mayfield start with the most basic concepts and gradually move into topics that are more complex, such as recursion and object-oriented programming. Each brief chapter covers the material for one week of a college course and includes exercises to help you practice what you’ve learned. Learn one concept at a time: tackle complex topics in a series of small steps with examples Understand how to formulate problems, think creatively about solutions, and write programs clearly and accurately Determine which development techniques work best for you, and practice the important skill of debugging Learn relationships among input and output, decisions and loops, classes and methods, strings and arrays Work on exercises involving word games, graphics, puzzles, and playing cards

Advanced R

Advanced R
Author: Hadley Wickham
Publisher: CRC Press
Total Pages: 669
Release: 2015-09-15
Genre: Mathematics
ISBN: 1498759807

An Essential Reference for Intermediate and Advanced R Programmers Advanced R presents useful tools and techniques for attacking many types of R programming problems, helping you avoid mistakes and dead ends. With more than ten years of experience programming in R, the author illustrates the elegance, beauty, and flexibility at the heart of R. The book develops the necessary skills to produce quality code that can be used in a variety of circumstances. You will learn: The fundamentals of R, including standard data types and functions Functional programming as a useful framework for solving wide classes of problems The positives and negatives of metaprogramming How to write fast, memory-efficient code This book not only helps current R users become R programmers but also shows existing programmers what’s special about R. Intermediate R programmers can dive deeper into R and learn new strategies for solving diverse problems while programmers from other languages can learn the details of R and understand why R works the way it does.

Practical Common Lisp

Practical Common Lisp
Author: Peter Seibel
Publisher: Apress
Total Pages: 506
Release: 2006-11-01
Genre: Computers
ISBN: 1430200170

* Treats LISP as a language for commercial applications, not a language for academic AI concerns. This could be considered to be a secondary text for the Lisp course that most schools teach . This would appeal to students who sat through a LISP course in college without quite getting it – so a "nostalgia" approach, as in "wow-lisp can be practical..." * Discusses the Lisp programming model and environment. Contains an introduction to the language and gives a thorough overview of all of Common Lisp’s main features. * Designed for experienced programmers no matter what languages they may be coming from and written for a modern audience—programmers who are familiar with languages like Java, Python, and Perl. * Includes several examples of working code that actually does something useful like Web programming and database access.

Python for Everybody

Python for Everybody
Author: Charles R. Severance
Publisher:
Total Pages: 242
Release: 2016-04-09
Genre:
ISBN: 9781530051120

Python for Everybody is designed to introduce students to programming and software development through the lens of exploring data. You can think of the Python programming language as your tool to solve data problems that are beyond the capability of a spreadsheet.Python is an easy to use and easy to learn programming language that is freely available on Macintosh, Windows, or Linux computers. So once you learn Python you can use it for the rest of your career without needing to purchase any software.This book uses the Python 3 language. The earlier Python 2 version of this book is titled "Python for Informatics: Exploring Information".There are free downloadable electronic copies of this book in various formats and supporting materials for the book at www.pythonlearn.com. The course materials are available to you under a Creative Commons License so you can adapt them to teach your own Python course.

Writing Word Macros

Writing Word Macros
Author: Steven Roman
Publisher: "O'Reilly Media, Inc."
Total Pages: 420
Release: 1999
Genre: Computers
ISBN: 9781565927254

Many Microsoft Word users and VBA programmers don't realize the extensive opportunities that exist when Word's object model is accessed using Visual Basic for Applications (VBA). By creating what is commonly called a "Word macro," you can automate many features available in Word. Writing Word Macros (previously titled Learning Word Programming) is the introduction to Word VBA that allows you to do these things and more. Book jacket.

JavaScript

JavaScript
Author: David Flanagan
Publisher: "O'Reilly Media, Inc."
Total Pages: 1096
Release: 2011-04-25
Genre: Computers
ISBN: 0596805527

A revised and updated edition offers comprehensive coverage of ECMAScript 5 (the new JavaScript language standard) and also the new APIs introduced in HTML5, with chapters on functions and classes completely rewritten and updated to match current best practices and a new chapter on language extensions and subsets. Original.

Simply Scheme

Simply Scheme
Author: Brian Harvey
Publisher: MIT Press
Total Pages: 620
Release: 1999
Genre: Computers
ISBN: 9780262082815

Showing off scheme - Functions - Expressions - Defining your own procedures - Words and sentences - True and false - Variables - Higher-order functions - Lambda - Introduction to recursion - The leap of faith - How recursion works - Common patterns in recursive procedures - Advanced recursion - Example : the functions program - Files - Vectors - Example : a spreadsheet program - Implementing the spreadsheet program - What's next?

Statistics from A to Z

Statistics from A to Z
Author: Andrew A. Jawlik
Publisher: John Wiley & Sons
Total Pages: 440
Release: 2016-09-21
Genre: Mathematics
ISBN: 1119272009

Statistics is confusing, even for smart, technically competent people. And many students and professionals find that existing books and web resources don’t give them an intuitive understanding of confusing statistical concepts. That is why this book is needed. Some of the unique qualities of this book are: • Easy to Understand: Uses unique “graphics that teach” such as concept flow diagrams, compare-and-contrast tables, and even cartoons to enhance “rememberability.” • Easy to Use: Alphabetically arranged, like a mini-encyclopedia, for easy lookup on the job, while studying, or during an open-book exam. • Wider Scope: Covers Statistics I and Statistics II and Six Sigma Black Belt, adding such topics as control charts and statistical process control, process capability analysis, and design of experiments. As a result, this book will be useful for business professionals and industrial engineers in addition to students and professionals in the social and physical sciences. In addition, each of the 60+ concepts is covered in one or more articles. The 75 articles in the book are usually 5–7 pages long, ensuring that things are presented in “bite-sized chunks.” The first page of each article typically lists five “Keys to Understanding” which tell the reader everything they need to know on one page. This book also contains an article on “Which Statistical Tool to Use to Solve Some Common Problems”, additional “Which to Use When” articles on Control Charts, Distributions, and Charts/Graphs/Plots, as well as articles explaining how different concepts work together (e.g., how Alpha, p, Critical Value, and Test Statistic interrelate). ANDREW A. JAWLIK received his B.S. in Mathematics and his M.S. in Mathematics and Computer Science from the University of Michigan. He held jobs with IBM in marketing, sales, finance, and information technology, as well as a position as Process Executive. In these jobs, he learned how to communicate difficult technical concepts in easy - to - understand terms. He completed Lean Six Sigma Black Belt coursework at the IASSC - accredited Pyzdek Institute. In order to understand the confusing statistics involved, he wrote explanations in his own words and graphics. Using this material, he passed the certification exam with a perfect score. Those statistical explanations then became the starting point for this book.