If you're a business or IT professional, this short hands-on guide teaches you how to pull and transform data with SQL in significant ways. You will quickly master the fundamentals of SQL and learn how to create your own databases.Author Thomas Nield provides exercises throughout the book to help you practice your newfound SQL skills at home, without having to use a database server environment. Not only will you learn how to use key SQL statements to find and manipulate your data, but you'll also discover how to efficiently design and manage databases to meet your needs.You'll also learn how to:Explore relational databases, including lightweight and centralized modelsUse SQLite and SQLiteStudio to create lightweight databases in minutesQuery and transform data in meaningful ways by using SELECT, WHERE, GROUP BY, and ORDER BYJoin tables to get a more complete view of your business dataBuild your own tables and centralized databases by using normalized design principlesManage data by learning how to INSERT, DELETE, and UPDATE records

    This bestselling Sybex study guide covers 100% of all exam objectives. You'll prepare for the exam smarter and faster with Sybex thanks to expert content, real-world examples, advice on passing each section of the exam, access to the Sybex online interactive learning environment, and much more. Reinforce what you've learned with key topic exam essentials and chapter review questions. Along with the book, you also get access to Sybex's superior online interactive learning environment that includes: Four unique 250 question practice exams to help you identify where you need to study more. Get more than 90 percent of the answers correct, and you're ready to take the certification exam. More than 650 Electronic Flashcards to reinforce your learning and give you last-minute test prep before the exam A searchable glossary in PDF to give you instant access to the key terms you need to know for the exam Coverage of all of the exam topics in the book means you'll be ready for: Security and Risk Management Asset Security Security Engineering Communication and Network Security Identity and Access Management Security Assessment and Testing Security Operations Software Development Security

    It also works beautifully with other open source tools, such as the MySQL database and the Apache web server. However, as more web sites are developed in PHP, they become targets for malicious attackers, and developers need to prepare for the attacks.Security is an issue that demands attention, given the growing frequency of attacks on web sites. Essential PHP Security explains the most common types of attacks and how to write code that isn't susceptible to them. By examining specific attacks and the techniques used to protect against them, you will have a deeper understanding and appreciation of the safeguards you are about to learn in this book.In the much-needed (and highly-requested) Essential PHP Security, each chapter covers an aspect of a web application (such as form processing, database programming, session management, and authentication). Chapters describe potential attacks with examples and then explain techniques to help you prevent those attacks.Topics covered include:Preventing cross-site scripting (XSS) vulnerabilitiesProtecting against SQL injection attacksComplicating session hijacking attemptsYou are in good hands with author Chris Shiflett, an internationally-recognized expert in the field of PHP security. Shiflett is also the founder and President of Brain Bulb, a PHP consultancy that offers a variety of services to clients around the world.

    The 4th Edition of this AJN Book-of-the-Year award winner has been thoroughly updated to deliver even more resources and tools, plus new DSM-5 content. "Psych Notes is packed with all of the essential content necessary to REVIEW (you should also have expanded knowledge of this content) and pass the ANCC PMHNP certification exam. You will be astonished with the depth and breadth of information contained in this easy to read and use (spiral bound) book. Be sure to access the online information that accompanies this book, too as it contains a grid comparing the changes from DSM-IV and DSM-5!" --Sandra Hannon-Engel, Ph.D., RN, CNS, PMHNP, Assistant Professor, William F. Connell School of Nursing, Boston College, Boston, MA. "It's a pretty good book for both nursing students and practicing RN's. No matter what specialty you're in you'll come across patients that are psychologically unstable and this book gives you a quick and easy reference to your needs. Everything is laid out in simple form and focuses on the most pertinent topics in psych." - Jim Astapan, Amazon.com "Very good source for fast references." - Ileana, Amazon.com "An amazingly complete collection of all that pertains to psych/mental health care. An easy to use resource and a wonderful review." - Camille Grosso, Ph.D., R.N.

    At $29 and cheaper than a good pizza, you will get the book in its current partial form, along with all future chapters, updates, and fixes for free. As of the day I wrote this description, Code Bright had 130 pages and was just getting started. To give you some perspective on how detailed it is, Code Happy was 127 pages in its complete state. Want to know more? Carry on reading.Welcome back to Laravel. Last year I wrote a book about the Laravel PHP framework. It started as a collection of tutorials on my blog, and eventually became a full book. I definitely didn’t expect it to be as popular as it was. Code Happy has sold almost 3000 copies, and is considered to be one of the most valuable resourcesfor learning the Laravel framework.Code Bright is the spiritual successor to Code Happy. The framework has grown a lot in the past year, and has changed enough to merit a new title. With Code Bright I hope to improve on Code Happy with every way, my goal is, to once again, build the most comprehensive learning experience for the framework. Oh, and to still be funny. That’s very important to me.Laravel Code Bright will contain a complete learning experience for all of the framework’s features. The style of writing will make it approachable for beginners, and a wonderful reference resource for experienced developers alike.You see, people have told me that they enjoyed reading Code Happy, not only for its educational content, but for its humour, and for my down to earth writing style. This is very important to me. I like to write my books as if we were having a conversation in a bar.When I wrote Code Happy last year, I was simply a framework enthusiast. One of the first to share information about the framework. However, since then I have become a committed member of the core development team. Working directly with the framework author to make Laravel a wonderful experience for the developers of the world.One other important feature of both books, is that they are published while in progress. This means that the book is available in an incomplete state, but will grow over time into a complete title. All future updates will be provided for free.What this means is that I don’t have to worry about deadlines, or a fixed point of completion. It leads to less stress and better writing. If I think of a better way to explain something, I can go back and change it. In a sense, the book will never be completed. I can constantly add more information to it, until it becomes the perfect resource.Given that this time I am using the majority of my spare time to write the title (yes, I have a full time job too!), I have raised the price a little to justify my invested time. I was told by many of my past readers that they found the previous title very cheap for the resource that it grew into, so if you are worried about the new price, then let me remind you what you will get for your 29 bucks.The successor to Code Happy, seen by many as the #1 learning resource for the Laravel PHP framework.An unending source of information, chapters will be constantly added as needed until the book becomes a giant vault of framework knowledge.Comedy, and a little cheesy, but very friendly writing.

    With this fun and friendly beginners guide, you will quickly grasp how to play Minecraft in the three modes of game play: survival, creative, and hardcore. The easy-to-understand writing style walks you through every step of the way, from downloading the game to choosing a gaming platform to defending your creations against monsters and winning the game by defeating the Ender Dragon. Explains how to use blocks to build amazing creations and engage in gameplay with other players Details techniques for travelling across the biomes Zeroes in on playing wisely in Survival mode so you can acquire resources to maintain your health and hunger Shares tips for playing carefully in Creative mode, using your unlimited supply of resources, the ability to fly, and more Helps you play in Hardcore mode Minecraft For Dummies, Portable Edition goes where you go as you create a world you won't want to leave!

    A celebrated writing coach with a sense of humor and a gentle touch, she’s also a master writer herself with a long and distinguished career in both teaching and practicing the art of writing.The Book on Writing contains 25 chapters in three sections: A dozen essential but easy-to-apply guidelines to good writing, from the importance of clarity to the value of a conversational tone. Paula LaRocque believes learning is easier and more successful when we are not only told but also shown. So her Book on Writing is chockfull of actual writing examples that supplement and illustrate principles that apply as naturally to fiction as they do to nonfiction.How to tell a story—from building suspense, to effective description, to the uses of metaphor and literary devices. Paula LaRocque also deals with the narrative “engine” and the value of the archetype in plotting and characterization—as well as with pace and speed and leveling what she terms writing’s “speedbumps.” A clear and concise handbook that deals with common problems in grammar, usage, punctuation, and style—the kind of problems that often trouble even wordsmiths. The handbook also debunks pesky language “rules” that are actually myths. The Book on Writing is one-stop shopping for writers. Read it once, and you’ll be a better writer. Read it often, and you’ll be among the best.

    This classic guide—fully updated for Windows Server 2003, Windows XP, and Windows 2000, including 64-bit extensions—describes the architecture and internals of the Windows operating system. You’ll find hands-on experiments you can use to experience Windows internal behavior firsthand, along with advanced troubleshooting information to help you keep your systems running smoothly and efficiently. Whether you’re a developer or a system administrator, you’ll find critical architectural insights that you can quickly apply for better design, debugging, performance, and support.Get in-depth, inside knowledge of the Windows operating system: Understand the key mechanisms that configure and control Windows, including dispatching, startup and shutdown, and the registry Explore the Windows security model, including access, privileges, and auditing Investigate internal system architecture using the kernel debugger and other tools Examine the data structures and algorithms that deal with processes, threads, and jobs Observe how Windows manages virtual and physical memory Understand the operation and format of NTFS, and troubleshoot file system access problems View the Windows networking stack from top to bottom, including mapping, APIs, name resolution, and protocol drivers Troubleshoot boot problems and perform crash analysis

    Together, they are building forever. Alexis Black persevered through her mother’s death and her father’s imprisonment. And after escaping a long and abusive relationship, the college junior promised her foster parents not to date for at least a year. But when she meets an incoming freshman on the first day of their scholarship program, she feels the world melt away, as though it were only the two of them in the room. Justin Black lived in abandoned houses before going through the child welfare system. But when he grabs the chance for better opportunities by pursuing higher education, he can’t help but be drawn to a beautiful third-year student. Recognizing a fellow survivor, he cherishes the ease of their deep conversations and her wonderful moments of raw vulnerability that makes him fall hard. In a stark and wholehearted true story that shares how two individuals on separate paths found each other, Alexis and Justin merge their course into one full of hope and purpose. And hand-in-hand, they learn to communicate effectively and avoid patterns of trauma to intentionally break the cycle of unhealthy behaviors. Written in an engaging novelistic style, the authors put forward a thoughtful exchange of ideas and personal experiences illustrating how anybody, no matter their backgrounds, can have a life of self-empowerment and joy. Broken down into four sections that cover crucial topics such as “Worthiness” and “Mental Health,” this compelling narrative will help any who are learning to love themselves and want to end the line of toxic relationships. Redefining Normal: How Two Foster Kids Beat The Odds and Discovering Healing, Happiness, and Love is a page-turning memoir that will open your eyes to possibilities and dreams. If you like honest tales of triumph, refreshing transparency, and resilient faith in God, then you’ll adore Justin Black and Alexis Black’s inspirational autobiography. This story contains mentions of domestic violence, trauma, sexual assault, and other difficult issues faced on the road to healing.

    And this book will teach you all you need to know to be immediately productive with MySQL. By working through 30 highly focused hands-on lessons, your MySQL Crash Course will be both easier and more effective than you'd have thought possible. Learn how to: Retrieve and sort data Filter data using comparisons, regular expressions, full text search, and much more 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 Ben Forta is Macromedia's Senior Technical Evangelist, and has almost 20 years of experience in the computer industry in product development, support, training, and product marketing. Ben is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes (now in its third edition, and translated into over a dozen languages), ColdFusion Web Application Construction Kit, and Advanced ColdFusion Development (both published by Que Publishing), Sams Teach Yourself Regular Expressions in 10 Minutes, as well as books on SQL, Flash, JSP, HomeSite, WAP, Windows 2000, and other subjects.

    It provides guidance to help customers apply best practices in the design, delivery, and maintenance of secure AWS environments. This documentation is offered for free here as a Kindle book, or you can read it in PDF format at https://aws.amazon.com/whitepapers/.

    This practical guide shows how Apache ZooKeeper helps you manage distributed systems, so you can focus mainly on application logic. Even with ZooKeeper, implementing coordination tasks is not trivial, but this book provides good practices to give you a head start, and points out caveats that developers and administrators alike need to watch for along the way.In three separate sections, ZooKeeper contributors Flavio Junqueira and Benjamin Reed introduce the principles of distributed systems, provide ZooKeeper programming techniques, and include the information you need to administer this service.Learn how ZooKeeper solves common coordination tasksExplore the ZooKeeper API’s Java and C implementations and how they differUse methods to track and react to ZooKeeper state changesHandle failures of the network, application processes, and ZooKeeper itselfLearn about ZooKeeper’s trickier aspects dealing with concurrency, ordering, and configurationUse the Curator high-level interface for connection managementBecome familiar with ZooKeeper internals and administration tools

    The prewritten progress notes can be easily and quickly adapted to fit a particular client need or treatment situation. Saves you hours of time-consuming paperwork, yet offers the freedom to develop customized progress notes Organized around 43 behaviorally based presenting problems, including depression, intimate relationship conflicts, chronic pain, anxiety, substance abuse, borderline personality, and more Features over 1,000 prewritten progress notes (summarizing patient presentation, themes of session, and treatment delivered) Provides an array of treatment approaches that correspond with the behavioral problems and DSM-5™ diagnostic categories in The Complete Adult Psychotherapy Treatment Planner, Fifth Edition Offers sample progress notes that conform to the requirements of most third-party payors and accrediting agencies, including CARF, The Joint Commission (TJC), COA, and the NCQA Identifies the latest evidence-based care treatments with treatment language following specific guidelines set by managed care and accrediting agencies

    With SQL and this task-based guide to it, you can do it too—no programming experience required!After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily launches into the tasks that will get you comfortable with SQL fast. In addition to explaining SQL basics, this updated reference covers the ANSI SQL:2003 standard and contains a wealth of brand-new information, including a new chapter on set operations and common tasks, well-placed optimization tips to make your queries run fast, sidebars on advanced topics, and added IBM DB2 coverage.Best of all, the book's examples were tested on the latest versions of Microsoft Access, Microsoft SQL Server, Oracle, IBM DB2, MySQL, and PostgreSQL. On the companion Web site, you can download the SQL scripts and sample database for all these systems and put your knowledge to work immediately on a real database..

    ―Jacob Boudreau CTO of Stord | Forbes 30 Under 30 Joel's book and show provide incredible insights for young startup developers and fellow CTOs alike. Joel offers a human perspective and real practical advice on the challenges and opportunities facing every Modern CTO. ― Christian Saucier | Entrepreneur and P2P Systems Architect I've really come to respect what Joel is doing in the community. His podcast and book are filling a much needed hole and I'm excited to see what else the future has in store. ― Don Pawlowski Chief Technology Officer at University Tees Modern CTO Everything you need to know to be a Modern CTO. Developers are not CTOs, but developers can learn how to be CTOs. In Modern CTO, Joel Beasley provides readers with an in-depth road map on how to successfully navigate the unexplored and jagged transition between these two roles. Drawing from personal experience, Joel gives a refreshing take on the challenges, lessons, and things to avoid on this journey.Readers will learn how Modern CTOs: Manage deadlines Speak up Know when to abandon ship and build a better one Deal with poor code Avoid getting lost in the product and know what UX mistakes to watch out for Manage people and create momentum … plus much more Modern CTO is the ultimate book when making the leap from developer to CTO. Update: Kindle Formatting issues resolved 5/13/18. Thank you for the feedback.