“…This book presents each of the SQL commands and describes its use in both commercial (Microsoft SQL Server 2000 and Oracle 8i) and open source (MySQL, PostgreSQL 7.0) implementations. Each command reference includes the command syntax (by vendor, if the syntax differs across implementations), a description, and informative examples that illustrate important concepts and uses." …”

“…With this quick guide, you'll learn the basics of hapi and use those skills to build an application and a REST API with MySQL. You'll then wrap up with a Capstone project of industry relevance, understanding solution design, and how hapi fits into industry relevant projects for data driven apps. …”

“…For implementation purposes, the jOOQ examples explained in this book are written in the Spring Boot context for Maven/Gradle against MySQL, Postgres, SQL Server, and Oracle. By the end of this book, you'll be a jOOQ power user capable of integrating jOOQ in the most modern and sophisticated apps including enterprise apps, microservices, and so on. …”

Tabla de Contenidos: “…A single controller plus network node with one or more compute nodesSummary; Chapter 2: Installing OpenStack; System requirements; Operating system requirements; Initial network configuration; Interface configuration; Before you begin; Permissions; Configuring the OpenStack repository; Installing OpenStack utilities; Setting the hostnames; Disabling SELinux; Removing iptables rules; Installing and configuring Network Time Protocol; Upgrading the system; Installation of OpenStack; Installing and configuring the MySQL database server; Installing the MySQL database client…”

Tabla de Contenidos: “…Backup and restore functionalitiesIndexing; Using Memcache; Breaking our application into modules; Summary; Chapter 5: Storing Data in Google Cloud SQL; Creating a Cloud SQL instance; Configuring access; Setting the root password; Connecting to the instance with the MySQL console; Creating the notes database; Creating a dedicated user; Creating tables; Connecting to the instance from our application; Loading and saving data; Using the local MySQL installation for development; Summary; Chapter 6: Using Channels to Implement a Real-time Application; Understanding how the Channel API works…”

Tabla de Contenidos: “…Working with PHP includes and templates -- chapter 13. Setting up MySQL and phpMyAdmin -- chapter 14. Storing records in a database -- chapter 15. …”

Tabla de Contenidos: “…-- AWS and the shared responsibility model -- Azure and the shared responsibility model -- GCP and the shared responsibility model -- Command-line tools -- AWS CLI -- Azure CLI -- Google Cloud SDK -- Summary -- Chapter 2: Securing Compute Services -- Technical requirements -- Securing VMs -- Securing Amazon Elastic Compute Cloud (EC2) -- Securing Azure Virtual Machines -- Securing Google Compute Engine (GCE) and VM instances -- Securing managed database services -- Securing Amazon RDS for MySQL -- Securing Azure Database for MySQL -- Securing Google Cloud SQL for MySQL -- Securing containers -- Securing Amazon Elastic Container Service (ECS) -- Securing Amazon Elastic Kubernetes Service (EKS) -- Securing Azure Container Instances (ACI) -- Securing Azure Kubernetes Service (AKS) -- Securing Google Kubernetes Engine (GKE) -- Securing serverless/function as a service -- Securing AWS Lambda -- Securing Azure Functions -- Securing Google Cloud Functions -- Summary -- Chapter 3: Securing Storage Services -- Technical requirements -- Securing object storage -- Securing Amazon Simple Storage Service -- Securing Azure Blob storage -- Securing Google Cloud Storage -- Securing block storage -- Best practices for securing Amazon Elastic Block Store -- Best practices for securing Azure managed disks -- Best practices for securing Google Persistent Disk -- Summary -- Securing file storage -- Securing Amazon Elastic File System -- Securing Azure Files…”

Tabla de Contenidos: “…Providing Domain Name ServicesAdding a Relational Database: MySQL; Configuring Mail Securely with Postfix, POP3, and IMAP; Putting Apache to Work; Adding FTP Services with ProFTPD; Summarizing Your Web Statistics with Webalizer; Synchronizing the System Clock; Installing Perl Modules Needed by SpamAssassin; What's Next; The Domain Name System; DNS Basics; Advantages of Localized DNS Administration; Getting into the BIND; Components of BIND; Setting Up a DNS Server; Using a chroot Environment for Security; Configuring an Authoritative DNS Server; Your Responsibility in DNS…”

Tabla de Contenidos: “…; How This Book Is Organized; Demonstration Platforms; Using Code Examples; Comments and Questions; Safari® Enabled; Acknowledgments; Firefox and Friends; Mozilla to Firefox and Thunderbird; XML Technologies; XML History; XSLT and XPath; RDF; CSS; At the Top of It All: The DOM; Mixing Document Types; Getting Started; Supporting Tools; Apache web server; PHP; MySQL; Getting the Browser; XUL Basics; File Structure; XUL Widgets; Boxes; Adding Styling; Box Sizes…”

Tabla de Contenidos: “…Types of AttackWeb Server Security; PHP Security; MySQL Security; Joomla Security; Summary; Chapter 15: What Joomla! …”

“…No matter what DBMS you are using—Oracle, DB2, SQL Server, MySQL, PostgreSQL—misunderstandings can always arise over the precise meanings of terms, misunderstandings that can have a serious effect on the success of your database projects. …”

“…Based on real-world examples, this updated cookbook provides a framework to help you construct solutions and executable examples in severalflavors of SQL, including Oracle, DB2, SQL Server, MySQL, andPostgreSQL. SQL programmers, analysts, data scientists, database administrators, and even relatively casual SQL users will find SQL Cookbook to be a valuable problem-solving guide for everyday issues. …”

“…Understand what’s possible when you use PHP programs Learn language fundamentals, including data types, variables, operators, and flow control statements Explore functions, strings, arrays, and objects Apply common web application techniques, such as form processing, data validation, session tracking, and cookies Interact with relational databases like MySQL or NoSQL databases such as MongoDB Generate dynamic images, create PDF files, and parse XML files Learn secure scripts, error handling, performance tuning, and other advanced topics Get a quick reference to PHP core functions and standard extensions…”

Tabla de Contenidos: “…Restricting access to su or sudoRestricting permissions to run scripts; Restricting access to services; SELinux audit logs; SELinux troubleshooting; Summary; Chapter 3: Linux for Different Purposes; Configuring a gateway server; Setting up a VPN server; Implementing BIND as a DNS server; Setting up a web server using Apache-MySQL-PHP; Setting up an FTP server; Securing Apache and FTP with OpenSSL; References; Summary; Chapter 4: Mail Server with Postfix; Setting up and configuring of Postfix mail server; Setting up MariaDB for virtual domains and users…”

Tabla de Contenidos: “…Persisting UsersThe Sign Out Process; The Login Process; Getting My(SQL) Groove On; MySQL Requirements; Connecting to Databases; Creating ImageStore; Implementing ImageStore in DBImageStore; Uploading Images; Using Channels and Selects for Timeouts; Looping on selects; Throwing Away Goroutines; Using the Resized Images; Passing and Failing; Testing Multiple Variations of Inputs; Testing Between Packages; Testing the Gophr Authentication; Testing Remote HTTP requests; Benchmark Regressions; What is a package?…”

Tabla de Contenidos: “…Localizing PluginsSummary; Chapter 6: Widgetizing WordPress; Using Widgets in WordPress; Building Widgets with the Widget API; Widgetizing Your Theme; Summary; Chapter 7: Understanding the WordPress Database Class; Examining the Schema and Properties of the Database Class; Adding Data to MySQL with WordPress; Retrieving Data from MySQL with WordPress; Preventing SQL Injection; Summary; Chapter 8: Dissecting the Loop and WP_ Query; Defining the Loop; Wrangling the Loop with Plugins; Developing Custom and Multiple Loops; Using Loops Strategically; Summary…”

Tabla de Contenidos: “…System packagesPerl modules; Debian/Ubuntu package lists; Setting up repositories or sources; Configuring the CPAN shell; Installing Koha's software stack; Installing packages using the package manager; Installing packages from the Linux prompt; Installing packages using shell scripts; Installing packages using dselect; Installing Perl modules using CPAN; Troubleshooting CPAN installations; Setting up Koha's MySQL database; Configuring Koha's installation: Makefile.PL; Completing Koha's installation; Summary; Chapter 2: Configuring the Apache2 Web Server; Understanding Apache2 Configuration…”

Tabla de Contenidos: “…Items required for this project -- Adafruit HUZZAH ESP8266 breakout -- USB FTDI connector -- WS2811 NeoPixels LED strip -- 5V and 3.3V (optional) power supply -- 1000μF capacitor -- Logic level shifting IC -- 400-600Ω resistor -- JST SM or JST PH connectors (optional) -- Getting the CheerLights code set up -- Set up the Arduino IDE -- Installing the NeoPixel library -- Testing the ESP8266 -- Connect the ESP8266 Huzzah to the USB FTDI connector (FT232RL) and your computer -- Switching the ESP8266&amp -- #160 -- Huzzah&amp -- #160 -- into deployment mode -- Deploying your code -- Connecting it all together -- Connecting the data pins -- Power the NeoPixels -- Power up the ESP8266 -- Programming the ESP8266 Huzzah for CheerLights -- Let's try a simple single-color display -- Let's try some interesting modifications -- Summary -- Chapter 4: Erase Parking Headaches with OpenCV and Raspberry Pi -- Introduction to smart parking systems -- Sensor devices for smart parking -- Presence sensor -- Ultrasonic sensor&amp -- #160 -- -- Camera -- Configure the camera -- Accessing our Raspberry Pi via SSH -- Machine vision systems -- Introduction to machine vision -- Testing the camera -- Installing OpenCV on the Raspberry Pi -- Detecting the vehicle plate number -- OpenALPR -- Integrating the library -- Programming the script for Python -- Cloud API -- PHP REST API script for OpenALPR -- Architecture of the parking system -- Logging spaces in a database -- Configuring a MySQL database server -- Installing MySQL -- Installing the MySQL driver for PHP -- Testing PHP and MySQL -- Installing phpMyAdmin for administrating databases -- Configuring the Apache server -- Entering the phpMyAdmin remote panel -- Integrating the Raspberry Pi and camera into the database -- Programming the script software -- Node Express app for openALPR -- Amazon Web Services IoT…”

Tabla de Contenidos: “…-- Introduction to Spring Web MVC -- Key building blocks of a Spring Web MVC application -- Introduction to the Dispatcher servlet -- Building Hello World web application with Spring Boot -- The Spring STS Setup in Eclipse IDE -- Introduction to Spring Boot -- Building &amp -- #160 -- Hello World web app using Spring Boot -- Implementing Controllers -- Handling request parameters -- The RequestParam annotation -- The RequestBody annotation -- The PathVariable annotation -- Handling Interceptors -- Handling Response -- Response as an instance of ModelAndView -- Using @ResponseBody annotation -- Creating a RESTful web service -- Dockerizing a Spring Boot application -- Summary -- Chapter 2: Preparing the Spring Web Development Environment -- Installing the Java SDK -- Installing/configuring Maven -- Installing the Eclipse IDE -- Import the existing Maven project in Eclipse -- Creating a new Maven project in Eclipse&amp -- #160 -- -- Installing/configuring the Apache Tomcat server -- Adding/configuring Apache Tomcat in Eclipse -- Installing/configuring the MySQL database -- Installing/configuring the MySQL server&amp -- #160 -- -- Using the MySQL connector -- Connecting to the MySQL database from a Java class -- Introduction to Docker -- What are Docker containers? …”

Tabla de Contenidos: “…-- Reflected XSS -- Stored XSS -- Patching the Application to Prevent XSS Attacks -- Wrapping It Up -- Part V: Locking Up for the Night -- Chapter 11 Securing Apache and MySQL -- Programming Languages, Web Servers, and Operating Systems Are Inherently Insecure -- Securing a UNIX, Linux, or Mac OS X Environment -- Securing Apache -- Securing MySQL -- Wrapping It Up -- Chapter 12 Securing IIS and SQL Server -- Securing a Windows Server Environment -- Securing IIS -- Securing SQL Server -- Wrapping It Up -- Chapter 13 Securing PHP on the Server -- Using the Latest Version of PHP -- Using the Security Features Built into PHP and Apache -- Using ModSecurity -- Hardening php.ini -- Wrapping It Up -- Chapter 14 Introduction to Automated Testing -- Why Are We Talking About Testing in a Security Book? …”