Learn to write SQL queries to select and analyze data, and improve your ability to manipulate data. This book will help you take your existing skills to the next level.

Author Mark Simon kicks things off with a quick review of basic SQL knowledge, followed by a demonstration of how efficient SQL databases are designed and how to extract just the right data from them. You’ll then learn about each individual table’s structure and how to work with the relationships between tables. As you progress through the book, you will learn more sophisticated techniques such as using common...

Learn the basics of JavaScript to enhance your web pages. This book focuses on modern JavaScript programming and encourages a well-organized approach to programming in general.

JavaScript for Web Developers explains each foundational concept of the language, followed by a practical implementation of that lesson to reinforce what you’ve learned. Author Mark Simon starts with the basics of JavaScript programming, followed by a tutorial on manipulating HTML elements. You will then learn to work with forms, along with CSS and Event Listeners. Hands-on projects...

Use PHP to enhance your web pages. This book shows you how PHP programming works, and how to write and organize PHP code.

The book starts with steps to download and install a setup for a sample website that will form the basis for upcoming chapters. You start by writing PHP code and learn how to mix it with HTML and manage the code. From there, you will learn about dynamic content, along with a deep dive into form processing and sending email. Saving uploaded data and uploading files is discussed next. You will learn how to configure your PHP project and develop a library. You will...