No Starch Press
Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. The book focuses on using SQL to find the story your data tells, with the popular open-source database PostgreSQL and the pgAdmin interface as its primary tools.
You'll first cover the fundamentals of databases and the SQL language, then build skills by analyzing data from the U.S. Census and other federal and state government agencies. With exercises and real-world examples in each chapter, this book will teach even those who have never programmed before all the tools necessary to build powerful databases and access information quickly and efficiently.
Create databases and related tables using your own data; Define the right data types for your information; Aggregate, sort, and filter data to find patterns; Use basic math and advanced statistical functions; Identify errors in data and cle ...
||Coding with Minecraft|
You've mined for diamonds, crafted dozens of tools, and built all sorts of structures - but what if you could program robots to do all of that for you in a fraction of the time?
In Coding with Minecraft, you'll create a virtual robot army with Lua, a programming language used by professional game developers. Step-by-step coding projects will show you how to write programs that automatically dig mines, collect materials, craft items, and build anything that you can imagine. Along the way, you'll explore key computer science concepts like data types, functions, variables, and more.
Program robots that make smart decisions with flow control; Reuse code so that your robots can farm any crop you want, including wheat, sugar cane, and even cacti; Program a factory that generates infinite building supplies; Design an algorithm for creating walls and buildings of any size; Code yourself a pickaxe-swinging robotic lumberjack; Create a robot that digs mine shafts with stairs so you can exp ...
||20 Easy Raspberry Pi Projects|
20 Easy Raspberry Pi Projects is a beginner-friendly collection of electronics projects, perfectly suited for kids, parents, educators, and hobbyists looking to level up their hardware skills.
After a crash course to get you set up with your Raspberry Pi, you'll learn how to build interactive projects like a digital drum set; a WiFi controlled robot; a Pong game; an intruder alarm that sends email notifications; a gas leak detector; a weather forecaster; and IoT gadgets that control electronics around the house. Along the way, you'll work with core components like LCD screens, cameras, sensors, and even learn how to set up your own server.
Each project provides step-by-step instructions, full-color photos and circuit diagrams, and the complete code to bring your build to life. If you're ready to hit the ground running and make something interesting, let 20 Easy Raspberry Pi Projects be your guide. ...
||Arduino Project Handbook, Volume 2|
This second volume of the Arduino Project Handbook delivers 25 more beginner-friendly electronics projects. Get up and running with a crash course on the Arduino, and then pick any project that sparks your interest and start making!
Each project includes cost and time estimates, simple instructions, colorful photos and circuit diagrams, a troubleshooting section, and the complete code to bring your build to life. With just the Arduino board and a handful of components, you'll make gadgets like a rainbow light display, noise-level meter, digital piano, GPS speedo≠meter, and fingerprint scanner.
This collection of projects is a fast and fun way to get started with microcontrollers that's perfect for beginners, hobbyists, parents, and educators. ...
||The SparkFun Guide to Processing|
Processing is a free, beginner-friendly programming language designed to help non-programmers create interactive art with code.
The SparkFun Guide to Processing, the first in the SparkFun Electronics series, will show you how to craft digital artwork and even combine that artwork with hardware so that it reacts to the world around you. Start with the basics of programming and animation as you draw colorful shapes and make them bounce around the screen.
With a little imagination and Processing as your paintbrush, you'll be on your way to coding your own gallery of digital art in no time! Put on your artist's hat, and begin your DIY journey by learning some basic programming and making your first masterpiece with The SparkFun Guide to Processing. ...
||The GNU Make Book|
GNU make is the most widely used build automation tool, but it can be challenging to master and its terse language can be tough to parse for even experienced programmers. Those who run into difficulties face a long, involved struggle, often leaving unsolved problems behind and GNU make's vast potential untapped.
The GNU Make Book demystifies GNU make and shows you how to use its best features. You'll find a fast, thorough rundown of the basics of variables, rules, targets, and makefiles. Learn how to fix wastefully long build times and other common problems, and gain insight into more advanced capabilities, such as complex pattern rules. With this utterly pragmatic manual and cookbook, you'll make rapid progress toward becoming a more effective user.
GNU make is known for being tricky to use, but it doesn't have to be. If you're looking for a deeper understanding of this indispensable tool, you'll find The GNU Make Book to be an indispensable guide. ...
||Cracking Codes with Python|
Learn how to program in Python while making and breaking ciphers - algorithms used to create and send secret messages!
After a crash course in Python programming basics, you'll learn to make, test, and hack programs that encrypt text with classical ciphers like the transposition cipher and Vigen√®re cipher. You'll begin with simple programs for the reverse and Caesar ciphers and then work your way up to public key cryptography, the type of encryption used to secure today's online transactions, including digital signatures, email, and Bitcoin.
Each program includes the full code and a line-by-line explanation of how things work. By the end of the book, you'll have learned how to code in Python and you'll have the clever programs to prove it!
You'll also learn how to: Combine loops, variables, and flow control statements into real working programs; Use dictionary files to instantly detect whether decrypted messages are valid English or gibberish; Create test programs to make sur ...
||Learn Java the Easy Way|
Java is the world's most popular programming language, but it's known for having a steep learning curve. Learn Java the Easy Way takes the chore out of learning Java with hands-on projects that will get you building real, functioning apps right away.
You'll start by familiarizing yourself with JShell, Java's interactive command line shell that allows programmers to run single lines of code and get immediate feedback. Then, you'll create a guessing game, a secret message encoder, and a multitouch bubble-drawing app for both desktop and mobile devices using Eclipse, an industry-standard IDE, and Android Studio, the development environment for making Android apps.
As you build these apps, you'll learn how to: Perform calculations, manipulate text strings, and generate random colors; Use conditions, loops, and methods to make your programs responsive and concise; Create functions to reuse code and save time; Build graphical user interface (GUI) elements, including buttons, menus, pop ...
||Practical Packet Analysis, 3rd Edition|
It's easy to capture packets with Wireshark, the world's most popular network sniffer, whether off the wire or from the air. But how do you use those packets to understand what's happening on your network?
Updated to cover Wireshark 2.x, the third edition of Practical Packet Analysis will teach you to make sense of your packet captures so that you can better troubleshoot network problems. You'll find added coverage of IPv6 and SMTP, a new chapter on the powerful command line packet analyzers tcpdump and TShark, and an appendix on how to read and reference packet values using a packet map.
Practical Packet Analysis will show you how to: Monitor your network in real time and tap live network communications; Build customized capture and display filters; Use packet analysis to troubleshoot and resolve common network problems, like loss of connectivity, DNS issues, and slow speeds; Explore modern exploits and malware at the packet level; Extract files sent across a network from packet ...
||Coding iPhone Apps for Kids|
Apple's Swift is a powerful, beginner-friendly programming language that anyone can use to make cool apps for the iPhone or iPad. In Coding iPhone Apps for Kids, you'll learn how to use Swift to write programs, even if you've never programmed before.
You'll work in the Xcode playground, an interactive environment where you can play with your code and see the results of your work immediately! You'll learn the fundamentals of programming too, like how to store data in arrays, use conditional statements to make decisions, and create functions to organize your code - all with the help of clear and patient explanations.
Once you master the basics, you'll build a birthday tracker app so that you won't forget anyone's birthday and a platform game called Schoolhouse Skateboarder with animation, jumps, and more!
As you begin your programming adventure, you'll learn how to: Build programs to save you time, like one that invites all of your friends to a party with just the click of a but ...
||The Arduino Inventor's Guide|
The Arduino microcontroller makes it easy to learn about electronics, but it can be hard to know where to start. The 10 projects in this book will teach you to build, code, and invent with the super-smart Arduino and a handful of parts.
First, you'll master the basics with a primer that explains how a circuit works, how to read a wiring schematic, and how to build and test projects with a solderless breadboard. Then you'll learn how to make your hardware move, buzz, flash, and interact with the world using motors, LEDs, sensors, and more as you build these 10 projects:The classic first Arduino project: blinking an LED;A miniature traffic light;An LED screen that displays animated patterns and shapes;A fast-paced button-smashing game to test your reflexes;A light-sensitive, color-changing night-light;A challenging ball-balancing game;A temperature-sensing mini greenhouse with an automated fan and vent;A motorized ...