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

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.

Becoming a coder is all fun and games!

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. Captain Code is 400 glossy color pages of goodness packed with welcoming images, useful tips and tidbits, and engaging, readable text that focuses on doing while having fun. All code listings are in full-color and QR codes link to bonus content, downloads, challenge solutions, and more.

Captain Code makes coding exciting and rewarding, as it prepares a new generation to take their next steps forward—in education, careers, or both.

So, are you ready to unleash your coding superpower and become Captain Code?

MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. This book will teach you all you need to know to be immediately productive with the latest version of 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

Empower Students to Tell Their Stories with Adobe Spark!

Adobe Spark is a fun, free content-creation tool that anyone can use. Easily accessible on web browsers, Chromebooks, and mobile devices, Adobe Spark''s intuitive and easy-to-use design makes it the perfect tool for learners of all ages to create . . .

Video book reportsModern, responsive webpage "papers"Video journalsScience posters and videosWeb newsletters . . . and so much more!

In the hands of creative educators, Adobe Spark provides students with a fun way to embrace critical communication and creativity skills. But what if you don''t consider yourself a "creative educator" or just aren''t sure where to start?

That''s where 40 Ways to Inject Creativity into Your Classroom with Adobe Spark comes to the rescue! Experienced educators Ben Forta and Monica Burns offer step-by-step guidance on how to incorporate this powerful tool into your classroom in ways that are meaningful and relevant. They present 40 fun and practical lesson plans suitable for a variety of ages and subjects as well as 15 graphic organizers to get you started.

With the tips, suggestions, and encouragement in this book, you''ll find everything you need to inject creativity into your classroom using Adobe Spark.

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

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.

Becoming a coder is all fun and games!

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. Captain Code is 400 glossy color pages of goodness packed with welcoming images, useful tips and tidbits, and engaging, readable text that focuses on doing while having fun. All code listings are in full-color and QR codes link to bonus content, downloads, challenge solutions, and more.

Captain Code makes coding exciting and rewarding, as it prepares a new generation to take their next steps forward—in education, careers, or both.

So, are you ready to unleash your coding superpower and become Captain Code?

MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. This book will teach you all you need to know to be immediately productive with the latest version of 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

Empower Students to Tell Their Stories with Adobe Spark!

Adobe Spark is a fun, free content-creation tool that anyone can use. Easily accessible on web browsers, Chromebooks, and mobile devices, Adobe Spark''s intuitive and easy-to-use design makes it the perfect tool for learners of all ages to create . . .

Video book reportsModern, responsive webpage "papers"Video journalsScience posters and videosWeb newsletters . . . and so much more!

In the hands of creative educators, Adobe Spark provides students with a fun way to embrace critical communication and creativity skills. But what if you don''t consider yourself a "creative educator" or just aren''t sure where to start?

That''s where 40 Ways to Inject Creativity into Your Classroom with Adobe Spark comes to the rescue! Experienced educators Ben Forta and Monica Burns offer step-by-step guidance on how to incorporate this powerful tool into your classroom in ways that are meaningful and relevant. They present 40 fun and practical lesson plans suitable for a variety of ages and subjects as well as 15 graphic organizers to get you started.

With the tips, suggestions, and encouragement in this book, you''ll find everything you need to inject creativity into your classroom using Adobe Spark.