Posted on

MySQL Crash Course

Copyright © 2023 by Rick Silva.

ISBN-13: 978-1-7185-0300-7 (print)
ISBN-13: 978-1-7185-0301-4 (ebook)

[GitHub] https://github.com/ricksilva/mysql_cc

MySQL Crash Course is a fast-paced, no-nonsense introduction to relational database development. It’s filled with practical examples and expert advice that will have you up and running quickly.

You’ll learn the basics of SQL, how to create a database, craft SQL queries to extract data, and work with events, procedures, and functions. You’ll see how to add constraints to tables to enforce rules about permitted data and use indexes to accelerate data retrieval. You’ll even explore how to call MySQL from PHP, Python, and Java.

Three final projects will show you how to build a weather database from scratch, use triggers to prevent errors in an election database, and use views to protect sensitive data in a salary database.

You’ll also learn how to:

  • Query database tables for specific information, order the results, comment SQL code, and deal with null values
  • Define table columns to hold strings, integers, and dates, and determine what data types to use
  • Join multiple database tables as well as use temporary tables, common table expressions, derived tables, and subqueries
  • Add, change, and remove data from tables, create views based on specific queries, write reusable stored routines, and automate and schedule events

The perfect quick-start resource for database developers, MySQL Crash Course will arm you with the tools you need to build and manage fast, powerful, and secure MySQL-based data storage systems.

Posted on

CompTIA A+ Certification All-in-One Exam Guide, Eleventh Edition (Exams 220-1101 & 220-1102), 11th Edition

book cover

Copyright © 2023 by McGraw Hill. All rights reserved.

ISBN: 978-1-26-461015-0
MHID: 1-26-461015-7

This bestselling on-the-job reference and test preparation guide has been fully revised for new 2022 exam objectives

This highly effective self-study exam guide has been thoroughly updated to cover 100% of the topics covered on the latest version of the exam. This new edition includes expanded coverage of mobile computing, cloud and virtualization services, Windows 10, Linux, enhanced security, and advanced software troubleshooting procedures.

CompTIA A+ Certification All-in-One Exam Guide, Eleventh Edition (Exam 220-1101 & 220-1102) enables you to take the test with complete confidence. In keeping with the All-In-One philosophy, the book serves both as an exam guide and as a practical reference for IT support and technical personnel. Online content includes 200 accurate practice questions, sample Mike Meyers training videos, sample TotalSim interactive lab simulations, Mike’s favorite PC hardware Cool Tools, and a searchable PDF glossary.

  • Online content includes 200 practice questions, sample video training featuring Mike Meyers, sample Total Sim interactive lab simulations, and a searchable PDF glossary
  • Contains a coupon for 10% off of the exam fee—a $46 value
  • Written by experienced trainer Scott Jernigan and edited by training guru Mike Meyers

Posted on

Microsoft Defender for Cloud

book cover

Copyright © 2023 by Pearson Education, Inc.

ISBN-13: 978-0-13-787845-1
ISBN-10: 0-13-787845-1
Library of Congress Control Number: 2022944665

The definitive practical guide to Microsoft Defender for Cloud Fully covers new components and multi-cloud enhancements!

Microsoft Defender for Cloud offers comprehensive tools for hardening resources, tracking security posture, protecting against attacks, and streamlining security management all in one natively integrated toolset. Now, leading Microsoft security experts Yuri Diogenes and Tom Janetscheck help you apply its robust protection, detection, and response capabilities throughout your operations, protecting workloads running on all your cloud, hybrid, and on-premises platforms.

This guide shows how to make the most of new components, enhancements, and deployment scenarios, as you address todays latest threat vectors. Sharing best practices, expert tips, and optimizations only available from Microsofts Defender for Cloud team, the authors walk through improving everything from policies and governance to incident response and risk management. Whatever your role or experience, theyll help you address new security challenges far more effectively — and save hours, days, or even weeks.

Two of Microsofts leading cloud security experts show how to:

  • Assess new threat landscapes, the MITRE ATT&CK framework, and the implications of assume-breach
  • Explore Defender for Cloud architecture, use cases, and adoption considerations including multicloud with AWS and GCP
  • Plan for effective governance, successful onboarding, and maximum value
  • Fully visualize complex cloud estates and systematically reduce their attack surfaces
  • Prioritize risks with Secure Score, and leverage at-scale tools to build secure cloud-native apps
  • Establish consistent policy enforcement to avoid drift
  • Use advanced analytics and machine learning to identify attacks based on signals from all cloud workloads
  • Enhance security posture by integrating with the Microsoft Sentinel SIEM/SOAR, Microsoft Purview, and Microsoft Defender for Endpoint
  • Leverage just-in-time VM access and other enhanced security capabilities

About This Book

  • For architects, designers, implementers, SecOps professionals, developers, and security specialists working in Microsoft Azure environments
  • For all IT professionals and decision-makers concerned with securing modern hybrid/multicloud environments, cloud-native apps, and PaaS services