“…The course is meticulously structured to guide you through setting up a MySQL environment, enabling practical engagement from the onset. …”

Tabla de Contenidos: “…Chapter 1: Introduction to Relational Database Management Systems -- Chapter 2: Installing and Using MySQL Workbench -- Chapter 3: Understanding Data Types -- Chapter 4: Designing and Creating a Database -- Chapter 5: Importing and Exporting Data -- Chapter 6: Querying a Single Table -- Chapter 7: Querying Multiple Tables -- Chapter 8: Modifying Data and Table Structures -- Chapter 9: Working with Expressions -- Chapter 10: Grouping and Summarizing Data -- Chapter 11: Advanced Querying Techniques -- Chapter 12: Programmable Objects -- Chapter 13: Exploring and Processing Your Data -- Chapter 14: Telling a Story with Your Data -- Chapter 15: Best Practices for Designing and Querying -- Chapter 16: SQL Appendix…”

Tabla de Contenidos: “…Exercise 4-1: Summary -- Joins -- Exercise 4-2: Expanding Data Through Joins -- Inner Join -- Right Join -- Left Join -- Semi-Join -- Anti-Join -- Semi-Join and Anti-Join Aliases -- Using the IN Operator -- Negating the IN Operator -- Full Join -- Exercise 4-2: Summary -- Putting It All Together -- Exercise 4-3: Problem Solving with SQL Expressions and Conditional Queries -- Expressions as Columns -- Using an Inner Query -- Using Conditional Select Expressions -- Exercise 4-3: Summary -- Summary -- Chapter 5: Bridging Spark SQL with JDBC -- Overview -- MySQL on Docker Crash Course -- Starting Up the Docker Environment -- Docker MySQL Config -- Exercise 5-1: Exploring MySQL 8 on Docker -- Working with Tables -- Connecting to the MySQL Docker Container -- Using the MySQL Shell -- The Default Database -- Creating the Customers Table -- Inserting Customer Records -- Viewing the Customers Table -- Exercise 5-1: Summary -- Using RDBMS with Spark SQL and JDBC -- Managing Dependencies -- Exercise 5-2: Config-Driven Development with the Spark Shell and JDBC -- Configuration, Dependency Management, and Runtime File Interpretation in the Spark Shell -- Runtime Configuration -- Local Dependency Management -- Runtime Package Management -- Dynamic Class Compilation and Loading -- Spark Config: Access Patterns and Runtime Mutation -- Viewing the SparkConf -- Accessing the Runtime Configuration -- Iterative Development with the Spark Shell -- Describing Views and Tables -- Writing DataFrames to External MySQL Tables -- Generate Some New Customers -- Using JDBC DataFrameWriter -- SaveMode -- Exercise 5-2: Summary -- Continued Explorations -- Good Schemas Lead to Better Designs -- Write Customer Records with Minimal Schema -- Deduplicate, Reorder, and Truncate Your Table -- Drop Duplicates -- Sorting with Order By -- Truncating SQL Tables -- Stash and Replace…”

Tabla de Contenidos: “…""Setting up Java for Apache Tomcat""""Apache Tomcat packages, files, and service""; ""Deploying the WAR file in Apache Tomcat""; ""Chapter 7: Managing Databases""; ""Introduction""; ""Using MySQL packages, files, and services""; ""Using MySQL databases""; ""Creating MySQL database users""; ""Running MySQL queries""; ""Providing MySQL user grants""; ""Using PostgreSQL packages, files, and services""; ""Setting up PostgreSQL groups and users""; ""Configuring PostgreSQL databases""; ""Chapter 8: Configuring Salt Cloud""; ""Introduction""; ""Configuring the Salt cloud environment""…”

Tabla de Contenidos: “…FindBugsCobertura and Clover; The Sonar community and ecosystem; The SonarSource company; Awards and conferences; Sonar license; Summary; Chapter 2: Installing Sonar; Prerequisites for Sonar; Checking your Java installation; Installing Maven on Linux; Installing Maven on Windows; Installing MySQL on Linux; Installing MySQL on Windows; Downloading Sonar; Installing the Sonar web server; Sonar server basic configuration; Configuring MySQL; Creating the database; Setting up Sonar with MySQL; Starting Sonar as a service; Run as a service on Linux; Run as a service on Windows…”

Tabla de Contenidos: “…Data Types: DatetimeDB2; MySQL; Oracle; PostgreSQL; SQL Server; Data Types: Decimal; DB2's DECFLOAT Type; DECIMAL/NUMBER Type; Datetime Conversions: DB2; Datetime Conversions: MySQL; Date and Time Elements; TO_DAYS and FROM_DAYS; Unix Timestamp Support; Seconds in the Day; DATE_FORMAT and TIME_FORMAT; Datetime Conversions: Oracle; Datetime Conversions: PostgreSQL; Datetime Conversions: SQL Server; CAST and SET DATEFORMAT; CONVERT; DATENAME and DATEPART; DAY, MONTH, and YEAR; Datetime Functions: DB2; Datetime Functions: MySQL; Datetime Functions: Oracle; Getting Current Date and Time…”

Tabla de Contenidos: “…Cover -- Title Page -- Copyright and Credits -- Dedication -- Packt Upsell -- Contributors -- Table of Contents -- Preface -- Chapter 1: Introducing JEE and Eclipse -- JEE -- The presentation layer -- Java Servlets -- JavaServer Pages -- JavaServer Faces -- The business layer -- Enterprise JavaBeans -- The enterprise integration layer -- Java Database Connectivity -- The Java Persistence API -- Java Connector Architecture -- Web services -- Eclipse IDE -- Workspace -- Plugin -- Editors and views -- Perspective -- Eclipse preferences -- Installing products -- Installing Eclipse -- Installing the Tomcat server -- Installing the GlassFish server -- Installing MySQL -- Installing MySQL on Windows -- Installing MySQL on macOS X -- Installing MySQL on Linux -- Creating MySQL users -- Summary -- Chapter 2: Creating a Simple JEE Web Application -- Configuring Tomcat in Eclipse -- JavaServer Pages -- Creating a dynamic web project -- Creating JSP -- Running JSP in Tomcat -- Using JavaBeans in JSP -- Using JSTL -- Java Servlet -- Creating WAR -- JavaServer Faces -- Using Maven for project management -- Maven views and preferences in Eclipse JEE -- Creating a Maven project -- Maven archetype -- Exploring the POM -- Adding Maven dependencies -- Maven project structure -- Creating a WAR file using Maven -- Summary -- Chapter 3: Source Control Management in Eclipse -- The Eclipse subversion plugin -- Installing the Eclipse Subversion plugin -- Adding projects to an SVN repository -- Committing changes to an SVN repository -- Synchronizing with an SVN repository -- Checking out a project from SVN -- Eclipse Git plugin -- Adding a project to Git -- Committing files in the Git repository -- Viewing file differences after modifications -- Creating a new branch -- Committing a project to a remote repository -- Pulling changes from a remote repository…”

“…–Roger Carlson, Microsoft Access MVP (2006-2015) “Rather than stumble around reinventing wheels or catching glimpses of the proper approaches, do yourself a favor: Buy this book.” —Dave Stokes, MySQL Community Manager, Oracle Corporation Effective SQL brings together practical solutions and insights so you can solve complex problems with SQL and design databases that simplify data management in the future. …”

“…This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in Microsoft SQL Server 2008, Oracle 11g, and the MySQL 5.1 and PostgreSQL 8.3 open source database products. …”

“…This course is designed for users that already have a working knowledge of PHP and MySQL, and who develop PHP-based websites that contain sensitive or financial information. …”

“…About This Book Exploit the power of GeoServer to provide agile, flexible, and low -cost community projects Share real-time maps quickly Boost your map server's performance using the power and flexibility of GeoServer Who This Book Is For If you are a web developer with knowledge of server side scripting, have experience in installing applications on the server, and want to go beyond Google Maps by offering dynamically built maps on your site with your latest geospatial data stored in MySQL, PostGIS, MySQL, or Oracle, this is the book for you. …”

“…You’ll learn how to replicate data across Oracle databases and other platforms, including MySQL and Microsoft SQL Server, and perform near-zero-downtime migrations and upgrades. …”

“…Watch and learn how to write queries using the world’s #1 open source database, MySQL--and build skills you can use with any database, from Oracle to SQL Server! …”

“…If you have a basic understanding of Drupal and the Linux-Apache-MySQL-PHP (LAMP) stack, you’re ready to get started. …”

Tabla de Contenidos: “…Getting to know the JSON file format -- Working with databases -- Flat-file databases -- Relational (SQL) databases -- Project 2 - Configuring a MySQL database server -- Document-oriented databases -- Time series databases -- Project 3 - Configuring an InfluxDB server -- Summary -- Further reading -- Chapter 5: Implementing REST and MQTT Protocols for Communication -- Technical requirements -- Working with REST -- Project 1 - Defining tables within MySQL -- Working with SQL -- Project 2 - Inserting data into a MySQL table -- Project 3 - Retrieving data from a MySQL table -- Project 4 - Updating data in a MySQL table -- Project 5 - Deleting data from a MySQL table -- Implementing a REST API using JavaScript -- Installing Node.js -- Setting up an application structure -- Understanding routes and routing -- Project 6 - Defining a route -- Implementing a REST API using Python -- Installing dependencies -- Creating the application structure -- REST API for InfluxDB -- Getting sample data into InfluxDB -- Generating an API token -- Making an API call -- Working with MQTT -- Installing the Mosquitto MQTT broker -- Installing the Telegraf agent -- Summary -- Further reading -- Part 2: Sending Data -- Chapter 6: Utilizing Various Communication Technologies -- Technical requirements -- Utilizing short-range communications -- Bluetooth -- Zigbee -- Wi-Fi -- Utilizing medium-range communications -- RS-485 -- HC-12 -- Utilizing long-range communications -- LoRaWAN -- SigFox -- Cellular communication -- Communicating with REST APIs -- Testing the API endpoint using Postman -- Project 1 - Send sensor readings to the REST API -- Summary -- Chapter 7: Communicating with LoRaWAN -- Technical requirements -- Introduction to LoRa and LoRaWAN -- Installing a board driver for the Portenta H7 -- Installing the LoRa library -- Using point-to-point communication…”

Tabla de Contenidos: “…Hello Docker -- 2.Installing Linux -- 3.Oracle Database -- 4.MySQL Database -- 5.MongoDB -- 6.Apache Cassandra -- 7.Couchbase -- 8.Apache Hadoop -- 9.Apache Hive -- 10.Apache HBase -- 11.Apache Sqoop -- 12.Apache Kafka -- 13.Apache Solr -- 14.Apache Spark -- Appendix…”

Tabla de Contenidos: “…Cover ; Copyright; Credits; About the Author; About the Reviewer; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Setting Up the Environment; Setting up the environment with Vagrant; Introducing Vagrant; Installing Vagrant; Using Vagrant; Setting up the environment on OS X; Installing PHP; Installing MySQL; Installing Nginx; Installing Composer; Setting up the environment on Windows; Installing PHP; Installing MySQL; Installing Nginx; Installing Composer; Setting up the environment on Ubuntu; Installing PHP; Installing MySQL; Installing Nginx; Summary…”

Tabla de Contenidos: “…Beginning PHP 5.3; About the Author; Acknowledgments; Contents; Introduction; Part I: Getting Up and Running with PHP; Part II: Learning the Language; Part III: Using PHP in Practice; Appendix A: Solutions to Exercises; Appendix B: Configuring PHP; Appendix C: Alternatives to MySQL; Appendix D: Using PHP from the Command Line; Index…”

Tabla de Contenidos: “…Server-side programming with PHP -- bk. 6. Managing data with MySQL -- bk. 7. Into the future with AJAX -- bk. 8. …”

“…The Huawei GaussDB (for MySQL) used in the book is a Huawei cloud-based high-performance, highly applicable relational database that fully supports the syntax and functionality of the open source database MySQL. …”