Whether you're an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And Sams Teach Yourself SQL in 10 Minutes offers the straightforward, practical answers you need to help you do your job. Expert trainer and popular author Ben Forta teaches you just the parts of SQL you need to know-starting with simple data retrieval and quickly going on to more complex topics including the use of joins, subqueries, stored procedures, cursors, triggers, and table constraints. You'll learn methodically, systematically, and simply-in short, quick lessons that will each take only 10 minutes or less to complete.

Everyone should learn to code. Much like drawing and sketching, playing an instrument, cooking, or taking pictures and shooting videos, coding is a creative endeavor, which means it's a way to actually create stuff, and creating stuff is incredibly rewarding and satisfying. Sure, it's fun to spend hours on your phone looking at what other people have created; but that's nothing compared to the joy and satisfaction of creating things that other people consume and use. Yep, coding is fun!

And if that weren't enough, when you learn to code you develop all sorts of invaluable skills and traits beyond just coding. These include planning, problem solving, communication, logic, empathy, attention to detail, patience, resilience, persistence, and creativity. And it turns out that these skills (especially creativity and creative problem solving) are some of the most in-demand out there. So, coding will help your future career, too, regardless of what that career may be. But, where to start?

Captain Code is a welcoming, engaging, and fun introduction to becoming a coder, designed for the young (ages 10-17) and young-at-heart. Experienced educators and coders Ben & Shmuel Forta will guide you using Python, one of the most popular programming languages in the world. You'll learn by creating games, yes, games, from simple projects to retro text-based adventures to complete graphical arcade style games.

Improves English progress at Key Stage 2 by 3.75 times the UK national average Dominic Traynor, the founder of LitFilmFest, and experienced educator Cath Bufton-Green offer a practical method for primary teachers to radically improve English attainment in their classroom. This innovative approach links global challenges including politics, social change, the environment, health and advertising to the five key National Curriculum areas in English: reports, instructions, persuasive language, fiction and poetry, and presentation skills. It develops reading and writing through exciting, real-world tasks such as emailing a politician, creating a viral video and using social media to start petitions. Literacy Beyond the Classroom presents ready-to-use lesson plans, exercises and activities to help teachers bring this concept to life in the primary classroom. This way of learning has been found to improve English progress at Key Stage 2 by 3.75 times the UK national average. The projects can be completed in Adobe Spark. By teaching English in this practical, purposeful and more meaningful way, we can inspire the YouTube generation to learn the literacy skills they need to influence the world around them and have a positive impact as global citizens.

Learn to use one of the most powerful text processing and manipulation tools available Regular expression experts have long been armed with an incredibly powerful tool, one that can be used to perform all sorts of sophisticated text processing and manipulation in just about every language and on every platform. That's the good news. The bad news is that for too long, regular expressions have been the exclusive property of only the most tech savvy. Until now. Ben Forta's Learning Regular Expressions teaches you the regular expressions that you really need to know, starting with simple text matches and working up to more complex topics, including the use of backreferences, conditional evaluation, and look-ahead processing. You'll learn what you can use, and you'll learn it methodically, systematically, and simply. Regular expressions are nowhere near as complex as they appear to be at first glance. All it takes is a clear understanding of the problem being solved and how to leverage regular expressions to solve them. Read and understand regular expressions Use literal text and metacharacters to build powerful search patterns Take advantage of advanced regular expression features, including lookahead and backreferences Perform powerful search-and-replace operations in all major professional editing tools Add sophisticated form and text processing to web applications Search for files using command-line tools like grep and egrep Use regular expressions in programming languages like JavaScript, Java, PHP, Python, Microsoft .NET, and C#, as well as in DBMSs including MySQL and Oracle Work with phone numbers, postal codes, social security numbers, IP addresses, URLs, email addresses, and credit card numbers Contents at a Glance 1 Introducing Regular Expressions 2 Matching Single Characters 3 Matching Sets of Characters 4 Using Metacharacters 5 Repeating Matches 6 Position Matching 7 Using Subexpressions 8 Using Backreferences 9 Looking Ahead and Behind 10 Embedding Conditions 11 Regular Expression Solutions to Common Problems Appendix A Regular Expressions in Popular Applications and Languages