In just 24 sessions of one hour or less, you’ll learn how to use SQL to build effective databases, efficiently retrieve your data, and manage everything from performance to security! Using this book’s straightforward, step-by-step approach, you’ll learn hands-on through practical examples. Each lesson builds on what you’ve already learned, giving you a strong real-world foundation for success. The authors guide you from the absolute basics to advanced techniques—including views, transactions, Web data publishing, and even powerful SQL extensions for Oracle and Microsoft SQL Server! Step-by-step instructions carefully walk you through the most common SQL tasks. Quizzes and Exercises at the end of each chapter help you test your knowledge. By the Way notes present interesting information related to the discussion. Did You Know? tips offer advice or show you easier ways to perform tasks. Watch Out! cautions alert you to possible problems and give you advice on how to avoid them. Learn how to… Understand what SQL is, how it works, and what it does Define efficient database structures and objects “Normalize” raw databases into logically organized tables Edit relational data and tables with DML Manage database transactions Write effective, well-performing queries Categorize, summarize, sort, group, and restructure data Work with dates and times Join tables in queries, use subqueries, and combine multiple queries Master powerful query optimization techniques Administer databases and manage users Implement effective database security Use views, synonyms, and the system catalog Extend SQL to the enterprise and Internet Master important Oracle and Microsoft SQL Server extensions to ANSI SQL

Starter Kit Includes C++ compiler and IDE for Windows, Mac & Linux In just 24 lessons of one hour or less, you can learn the basics of programming with C++–one of the most popular and powerful programming languages ever created. Using a straightforward, step-by-step approach, this fast and friendly tutorial teaches you everything you need to know, from installing and using a compiler, to debugging the programs you’ve created, to what’s coming in C++0x, the next version of C++. Each lesson builds on what you’ve already learned, giving you a solid understanding of the basics of C++ programming concepts and techniques. Step-by-step instructions carefully walk you through the most common C++ programming tasks Quizzes and Exercises at the end of each chapter help you test yourself to make sure you’re ready to go on Starter Kit software provides everything you need to create and compile C++ programs on any platform–Windows, Mac or Linux Learn how to… Install and use a C++ compiler for Windows, Mac OS X or Linux Build object-oriented programs in C++ Master core C++ concepts such as functions, classes, arrays, and pointers Add rich functionality with linked lists and templates Debug your programs for flawless code Learn exception and error-handling techniques Discover what’s new in C++0x, the next version of C++ Jesse Liberty is the author of numerous books on software development, including best selling titles on C++ and .NET. He is the president of Liberty Associates, Inc. where he provides custom programming, consulting, and training. Rogers Cadenhead is a web application developer who has written many books on Internet-related topics, including Teach Yourself Java in 24 Hours. He maintains this book’s official website at http://cplusplus.cadenhead.org. CD-ROM Includes C++ compiler Visual development environment for Windows, Mac and Linux Source code for the book’s examples Register your book at informit.com/register for convenient access to updates and corrections as they become available.

MariaDB is a database server that offers drop-in replacement functionality for MySQL. Built by some of the original authors of MySQL, with assistance from the broader community of free and open source software developers, MariaDB offers a rich set of feature enhancements to MySQL, including alternate storage engines, server optimizations, and patches. MariaDB Crash Course teaches you all you need to know to be immediately productive with MariaDB. Master trainer Ben Forta introduces all the essentials through a series of quick, easy-to-follow, hands-on lessons. Instead of belaboring database theory and relational design, Forta focuses on teaching solutions for the majority of users who simply want to interact with data. Learn how to: Retrieve and sort data Filter data using comparisons, regular expressions, and full text search Join relational data Create and alter tables Insert, update, and delete data Leverage the power of stored procedures and triggers Use views and cursors Manage transactional processing Create user accounts and manage security via access control

The Fifth Edition of Sams Teach Yourself SQL in 21 Days More than 48,000 sold! In just one hour a day, you’ll have all the skills you need to begin creating effective SQL queries, reports, and database applications. With this complete tutorial, you’ll quickly master the basics and then move on to more advanced features and concepts: Quickly apply essential SQL techniques in useful, real-world queries Design trustworthy, high-performance databases Manipulate your data with views and transactions Leverage powerful features including stored procedures, triggers, and cursors Work with new objects introduced with the latest SQL standards Get practical, expert tips on implementing SQL in your business environment Learn on your own time, at your own pace No previous SQL or database experience required Learn techniques that work with any current version of SQL Discover how to write faster, more efficient queries Secure your data using best practices from experienced database administrators Build more powerful databases with features exclusive to Oracle SQL*Plus, Oracle PL/SQL, and Microsoft Transact-SQL Write queries for the free, open source MySQL database Embed your SQL code in other applications

Apache Spark is a fast, scalable, and flexible open source distributed processing engine for big data systems and is one of the most active open source big data projects to date. In just 24 lessons of one hour or less, Sams Teach Yourself Apache Spark in 24 Hours helps you build practical Big Data solutions that leverage Spark’s amazing speed, scalability, simplicity, and versatility. This book’s straightforward, step-by-step approach shows you how to deploy, program, optimize, manage, integrate, and extend Spark–now, and for years to come. You’ll discover how to create powerful solutions encompassing cloud computing, real-time stream processing, machine learning, and more. Every lesson builds on what you’ve already learned, giving you a rock-solid foundation for real-world success. Whether you are a data analyst, data engineer, data scientist, or data steward, learning Spark will help you to advance your career or embark on a new career in the booming area of Big Data. Learn how to • Discover what Apache Spark does and how it fits into the Big Data landscape • Deploy and run Spark locally or in the cloud • Interact with Spark from the shell • Make the most of the Spark Cluster Architecture • Develop Spark applications with Scala and functional Python • Program with the Spark API, including transformations and actions • Apply practical data engineering/analysis approaches designed for Spark • Use Resilient Distributed Datasets (RDDs) for caching, persistence, and output • Optimize Spark solution performance • Use Spark with SQL (via Spark SQL) and with NoSQL (via Cassandra) • Leverage cutting-edge functional programming techniques • Extend Spark with streaming, R, and Sparkling Water • Start building Spark-based machine learning and graph-processing applications • Explore advanced messaging technologies, including Kafka • Preview and prepare for Spark’s next generation of innovations Instructions walk you through common questions, issues, and tasks; Q-and-As, Quizzes, and Exercises build and test your knowledge; "Did You Know?" tips offer insider advice and shortcuts; and "Watch Out!" alerts help you avoid pitfalls. By the time you're finished, you'll be comfortable using Apache Spark to solve a wide spectrum of Big Data problems.

Master T-SQL database design, development, and administration the easy way–hands-on! In just one hour a day, you’ll build all the skills you need to create effective database applications with T-SQL and SQL Server. With this complete tutorial, you’ll quickly master the basics and then move on to more advanced features and concepts: Learn the fundamentals of T-SQL from the ground up, one step at a time Succeed with the newest versions of T-SQL, SQL Server, and SQL Server Management Studio Use T-SQL effectively as both an application developer and DBA Master powerful stored procedures, triggers, transactions, and user-defined functions (UDFs) Systematically optimize and secure your SQL Server databases Learn on your own time, at your own pace No previous T-SQL or database programming experience required Learn how to design efficient, reliable SQL Server databases Define efficient tables, table relationships, fields, and constraints Make the most of T-SQL’s SELECT and UPDATE statements Work effectively with simple and complex views and joins Master stored procedure techniques every developer should know Build and use powerful User-Defined Functions (UDFs) Secure databases with authentication, roles, permissions, and principals Configure, maintain, and tune SQL Server for maximum reliability, performance, and value Back up, restore, and audit databases Optimize databases with the SQL Server Profiler, System Monitor, and Index Tuning Wizard Leverage valuable insight and time saving techniques from a world renowned database expert Register your book at informit.com/register for access to source code, example files, updates, and corrections as they become available.

In just 24 sessions of one hour or less, you’ll discover how to implement, monitor, and manage a TCP/IP network–even the latest cloud-based and IPv6 networks. Using this book’s straightforward, step-by-step approach, you’ll uncover the essentials of TCP/IP and put that knowledge to work through practical examples. Each lesson builds on what you’ve already learned, giving you a strong real-world foundation for success. Expert author and network engineer Joe Casad guides you from the basics to advanced techniques—including TCP/IP’s architecture, layers, subnetting, CIDR, routing, security, utilities, remote access, web services, streaming, and much more. Practical discussions provide an inside look at TCP/IP components and protocols. Step-by-step instructions walk you through many common tasks. Q&As at the end of each hour help you test your knowledge. Notes and tips point out shortcuts and solutions and help you steer clear of potential problems. If you’re looking for a smart, concise introduction to the protocols that power the Internet, start your clock and look inside. Sams Teach Yourself TCP/IP in 24 Hours is your guide to the secrets of TCP/IP. Learn how to… Understand what TCP/IP is, and how it works Discover how IPv6 differs from IPv4, and how to migrate or coexist with IPv6 Work with TCP/IP’s Network Access, Internet, Transport, and Application layers Implement flexible addressing with subnetting and CIDR Establish efficient and reliable routing Implement name resolution Secure TCP/IP networks—detect and prevent attacks Automatically configure TCP/IP clients and hosts Provide classic TCP/IP services and powerful new Web services Use TCP/IP in advanced cloud-based environments Support efficient media streaming and webcasting Capitalize on the benefits of the new HTML5 standard Run TCP/IP protocols over wireless networks Troubleshoot TCP/IP networks with ping, traceroute, and other tools Provide for monitoring and remote access Deploy efficient email systems with POP3, IMAP4, and SMTP Walk through all facets of implementing a TCP/IP network

Sams Teach Yourself Java in 24 Hours, Sixth Edition Covering Java 7 and Android Development In just 24 lessons of one hour or less, you can learn how to create Java applications. Using a straightforward, step-by-step approach, popular author Rogers Cadenhead helps you master the skills and technology you need to create desktop and web programs, web services, and even an Android app in Java. Full-color figures and clear step-by-step instructions visually show you how to program with Java. Quizzes and Exercises at the end of each chapter help you test your knowledge. Notes, Tips, and Cautions provide related information, advice, and warnings. Learn how to… Set up your Java programming environment Write your first working program in just minutes Control program decisions and behavior Store and work with information Build straightforward user interfaces Create interactive web programs Use threading to build more responsive programs Read and write files and XML data Master best practices for object-oriented programming Create flexible, interoperable web services with JAX-WS Use Java to create an Android app PART I: Getting Started HOUR 1: Becoming a Programmer HOUR 2: Writing Your First Program HOUR 3: Vacationing in Java HOUR 4: Understanding How Java Programs Work PART II: Learning the Basics of Programming HOUR 5: Storing and Changing Information in a Program HOUR 6: Using Strings to Communicate HOUR 7: Using Conditional Tests to Make Decisions HOUR 8: Repeating an Action with Loops PART III: Working with Information in New Ways HOUR 9: Storing Information with Arrays HOUR 10: Creating Your First Object HOUR 11: Describing What Your Object Is Like HOUR 12: Making the Most of Existing Objects PART IV: Programming a Graphical User Interface HOUR 13: Building a Simple User Interface HOUR 14: Laying Out a User Interface HOUR 15: Responding to User Input HOUR 16: Building a Complex User Interface PART V: Moving into Advanced Topics HOUR 17: Creating Interactive Web Programs HOUR 18: Handling Errors in a Program HOUR 19: Creating a Threaded Program HOUR 20: Reading and Writing Files PART VI: Writing Internet Applications HOUR 21: Reading and Writing XML Data HOUR 22: Creating Web Services with JAX-WS HOUR 23: Creating Java2D Graphics HOUR 24: Writing Android Apps PART VII: Appendixes APPENDIX A: Using the NetBeans Integrated Development Environment APPENDIX B: Where to Go from Here: Java Resources APPENDIX C: This Book’s Website APPENDIX D: Setting Up an Android Development Environment

In just 24 sessions of one hour or less, you’ll learn how to build complete, reliable, and modern Windows applications with Microsoft® Visual Basic® 2015. Using a straightforward, step-by-step approach, each lesson builds on what you’ve already learned, giving you a strong foundation for success with every aspect of VB 2015 development. Notes present interesting pieces of information. Tips offer advice or teach an easier way to do something. Cautions advise you about potential problems and help you steer clear of disaster. Learn How To Master VB 2015 by building a complete feature-rich application Navigate VB 2015 and discover its new shortcuts Work with objects, collections, and events Build attractive, highly-functional user interfaces Make the most of forms, controls, modules, and procedures Efficiently store data and program databases Make decisions in code Use powerful object-oriented techniques Work with graphics and text files Manipulate filesystems and the Registry Add email support Create efficient modules and reusable procedures Interact effectively with users Write code to preview and print documents Debug with VB 2015’s improved breakpoint features Distribute your software Download all examples and source code presented in this book from informit.com/title/9780672337451 as they become available. Who Should Read This Book Those who have little or no programming experience or who might be picking up Visual Basic as a second language. Bug Alert Description: Changing the startup form's name in a VB WinForms app does not update the "Startup form" #4517 Explanation: In the latest Visual Basic update on GitHub, Microsoft accidentally introduced a significant bug that you should be aware of. In the Visual Basic project properties dialog on one of the tabs (Application), is a drop down box for selecting the "startup object". This can be either a Main method or a System.Windows.Forms instance (or System.Windows.Window for WPF). When you do a rename on a form (say from the code editor in source or from the solution explorer) currently set as the startup form the rename doesn't cascade to the startup object project property cause the project to enter an invalid state where the user must now manually reset this project property from the now nonexistent Form to the new name. This is a huge annoyance. The fix for the bug (until Microsoft addresses) can be found here: http://www.jamesfoxall.com/teach-visual-basic-2015-errata/

With SQL (Structured Query Language) you can create tables within a database, add and delete data, query for information, change system settings, and trigger actions based on changes to the database. Whether you're a programmer, administrator, or database designer, Teach Yourself SQL in 21 Days, Second Edition provides all the information needed to fully understand this powerful tool and use it to its fullest potential.Using step-by-step instructions, real-world examples, and expert advice, you'll improve your productivity, taking your skills to new heights. Completely updated and revised, this easy-to-understand guide explores SQL, showing you how to construct and optimize queries, use stored procedures and triggers to tune a database for maximum performance, and master the fundamental concepts and features of SQL.

Join the leagues of thousands of programmers and learn C++ from some of the best. The fifth edition of the best seller Sams Teach Yourself C++ in 21 Days, written by Jesse Liberty, a well-known C++ and C# programming manual author and Bradley L. Jones, manager for a number of high profiler developer websites, has been updated to the new ANSI/ISO C++ Standard. This is an excellent hands-on guide for the beginning programmer. Packed with examples of syntax and detailed analysis of code, fundamentals such as managing I/O, loops, arrays and creating C++ applications are all covered in the 21 easy-to-follow lessons. You will also be given access to a website that will provide you will all the source code examples developed in the book as a practice tool. C++ is the preferred language for millions of developers-make Sams Teach Yourself the preferred way to learn it!

In just 24 sessions of one hour or less, Sams Teach Yourself Python in 24 Hours will help you get started fast, master all the core concepts of programming, and build anything from websites to games. Using this book’s straightforward, step-by-step approach, you’ll move from the absolute basics through functions, objects, classes, modules, database integration, and more. Every lesson and case study application builds on what you’ve already learned, giving you a rock-solid foundation for real-world success! Step-by-step instructions carefully walk you through the most common Python development tasks. Quizzes and Exercises at the end of each chapter help you test your knowledge. Notes present interesting information related to the discussion. Tips offer advice or show you easier ways to perform tasks. Warnings alert you to possible problems and give you advice on how to avoid them. Learn how to… Install and run the right version of Python for your operating system Store, manipulate, reformat, combine, and organize information Create logic to control how programs run and what they do Interact with users or other programs, wherever they are Save time and improve reliability by creating reusable functions Master Python data types: numbers, text, lists, and dictionaries Write object-oriented programs that work better and are easier to improve Expand Python classes to make them even more powerful Use third-party modules to perform complex tasks without writing new code Split programs to make them more maintainable and reusable Clearly document your code so others can work with it Store data in SQLite databases, write queries, and share data via JSON Simplify Python web development with the Flask framework Quickly program Python games with PyGame Avoid, troubleshoot, and fix problems with your code

Presents a guide to writing effective SQL queries, from simple data selection and filtering to joining multiple tables and modifying sets of data, with information on how to solve a variety of challenging SQL problems.

In just a short time, you can learn how to use PHP, MySQL, and JavaScript together to create dynamic, interactive websites and applications using three leading web development technologies. No previous programming experience is required. Using a straightforward, step-by-step approach, each lesson in this book builds on the previous ones, enabling you to learn the essentials of full-stack web application development – from HTML, CSS, and JavaScript on the front end, to PHP scripting and MySQL databases on the server. Regardless of whether you run Linux, Windows, or MacOS, the book includes complete instructions to install all the software you need to set up a stable environment for learning, testing, and production. Step-by-step instructions carefully walk you through the most common web application development tasks. Practical, hands-on examples show you how to apply what you learn. Quizzes and exercises help you test your knowledge and stretch your skills. Learn how to: • Build web pages with HTML5 and CSS • Use JavaScript to build dynamic, interactive web pages • Get PHP, MySQL, and JavaScript to work together to create modern, standards-compliant web applications • Enhance interactivity with AJAX • Leverage JavaScript libraries such as jQuery • Work with cookies and user sessions • Get user input with web-based forms • Use basic SQL commands • Interact with the MySQL database using PHP • Write maintainable code and get started with version control • Decide when frameworks such as Bootstrap, Foundation, React, Angular, and Laravel can be useful • Create a web-based discussion forum or calendar • Add a storefront and shopping cart to your site Contents at a Glance PART I Web Application Basics 1 Understanding How the Web Works 2 Structuring HTML and Using Cascading Style Sheets 3 Understanding the CSS Box Model and Positioning 4 Introducing JavaScript 5 Introducing PHP PART II Getting Started with Dynamic Web Sites 6 Understanding Dynamic Web Sites and HTML5 Applications 7 JavaScript Fundamentals: Variables, Strings, and Arrays 8 JavaScript Fundamentals: Functions, Objects, and Flow Control 9 Understanding JavaScript Event Handling 10 The Basics of Using jQuery PART III Taking Your Web Applications to the Next Level 11 AJAX: Getting Started with Remote Scripting 12 PHP Fundamentals: Variables, Strings, and Arrays 13 PHP Fundamentals: Functions, Objects, and Flow Control 14 Working with Cookies and User Sessions 15 Working with Web-Based Forms PART IV Integrating a Database into Your Applications 16 Understanding the Database Design Process 17 Learning Basic SQL Commands 18 Interacting with MySQL Using PHP PART V Getting Started with Application Development 19 Creating a Simple Discussion Forum 20 Creating an Online Storefront 21 Creating a Simple Calendar 22 Managing Web Applications PART VI Appendixes A Installation QuickStart with XAMPP B Installing and Configuring MySQL C Installing and Configuring Apache D Installing and Configuring PHP