Tabla de Contenidos: “…Login/logout changes required in routes/notes.mjs -- View template changes supporting login/logout -- Running the Notes application with user authentication -- Twitter login support for the Notes application -- Registering an application with Twitter -- Implementing TwitterStrategy -- Securely keeping secrets and passwords -- The Notes application stack -- Summary -- Chapter 9: Dynamic Client/Server Interaction with Socket.IO -- Introducing Socket.IO -- Initializing Socket.IO with Express -- Real-time updates on the Notes homepage -- The Notes model as an EventEmitter class -- Real-time changes in the Notes home page -- Changing the homepage and layout templates -- Running Notes with real-time homepage updates -- Real-time action while viewing notes -- Changing the note view template for real-time action -- Running Notes with real-time updates while viewing a note -- Inter-user chat and commenting for Notes -- Data model for storing messages -- Adding messages to the Notes router -- Changing the note view template for messages -- Using a Modal window to compose messages -- Sending, displaying, and deleting messages -- Running Notes and passing messages -- Other applications of Modal windows -- Summary -- Chapter 10: Deploying Node.js Applications -- Notes application architecture and deployment considerations -- Traditional Linux Node.js service deployment -- Prerequisite - provisioning the databases -- Installing Node.js on Ubuntu -- Setting up Notes and user authentication on the server -- Adjusting Twitter authentication to work on the server -- Setting up PM2 to manage Node.js processes -- Node.js microservice deployment with Docker -- Installing Docker on your laptop -- Starting Docker with Docker for Windows/macOS -- Kicking the tires of Docker -- Creating the AuthNet for the user authentication service -- MySQL container for Docker…”

Tabla de Contenidos: “…Deciding on the best approach for ingesting from a database -- Ingesting streaming data -- Amazon Kinesis versus Amazon Managed Streaming for Kafka (MSK) -- Hands-on - ingesting data with AWS DMS -- Creating a new MySQL database instance -- Loading the demo data using an Amazon EC2 instance -- Creating an IAM policy and role for DMS -- Configuring DMS settings and performing a full load from MySQL to S3 -- Querying data with Amazon Athena -- Hands-on - ingesting streaming data -- Configuring Kinesis Data Firehose for streaming delivery to Amazon S3 -- Configuring Amazon Kinesis Data Generator (KDG) -- Adding newly ingested data to the Glue Data Catalog -- Querying the data with Amazon Athena -- Summary -- Chapter 7: Transforming Data to Optimize for Analytics -- Technical requirements -- Transformations - making raw data more valuable -- Cooking, baking, and data transformations -- Transformations as part of a pipeline -- Types of data transformation tools -- Apache Spark -- Hadoop and MapReduce -- SQL -- GUI-based tools -- Data preparation transformations -- Protecting PII data -- Optimizing the file format -- Optimizing with data partitioning -- Data cleansing -- Business use case transforms -- Data denormalization -- Enriching data -- Pre-aggregating data -- Extracting metadata from unstructured data -- Working with change data capture (CDC) data -- Traditional approaches - data upserts and SQL views -- Modern approaches - the transactional data lake -- Hands-on - joining datasets with AWS Glue Studio -- Creating a new data lake zone - the curated zone -- Creating a new IAM role for the Glue job -- Configuring a denormalization transform using AWS Glue Studio -- Finalizing the denormalization transform job to write to S3 -- Create a transform job to join streaming and film data using AWS Glue Studio -- Summary…”

Tabla de Contenidos: “…Chapter 3 Getting to Know SQL -- Where SQL Came From -- Knowing What SQL Does -- The ISO/IEC SQL Standard -- Knowing What SQL Does Not Do -- Choosing and Using an Available DBMS Implementation -- Microsoft Access -- Microsoft SQL Server -- IBM DB2 -- Oracle Database -- Sybase SQL Anywhere -- MySQL -- PostgreSQL -- Chapter 4 SQL and the Relational Model -- Sets, Relations, Multisets, and Tables -- Functional Dependencies -- Keys -- Views -- Users -- Privileges -- Schemas -- Catalogs -- Connections, Sessions, and Transactions -- Routines -- Paths -- Chapter 5 Knowing the Major Components of SQL -- Creating a Database with the Data Definition Language -- The containment hierarchy -- Creating tables -- Specifying columns -- Creating other objects -- Modifying tables -- Removing tables and other objects -- Operating on Data with the Data Manipulation Language (DML) -- Retrieving data from a database -- Adding data to a table -- Updating data in a table -- Deleting data from a table -- Updating views doesn't make sense -- Maintaining Security in the Data Control Language (DCL) -- Granting access privileges -- Revoking access privileges -- Preserving database integrity with transactions -- Chapter 6 Drilling Down to the SQL Nitty-Gritty -- Executing SQL Statements -- Interactive SQL -- Challenges to combining SQL with a host language -- Embedded SQL -- Module language -- Using Reserved Words Correctly -- SQL's Data Types -- Exact numerics -- Approximate numerics -- Character strings -- Binary strings -- Booleans -- Datetimes -- Intervals -- XML type -- ROW type -- Collection types -- REF types -- User-defined types -- Data type summary -- Handling Null Values -- Applying Constraints -- Column constraints -- Table constraints -- Foreign key constraints -- Assertions -- Book 2 Relational Database Development -- Chapter 1 System Development Overview…”

Tabla de Contenidos: “…Deploying a Cloud Function for Cloud Storage Events Using gcloud Commands -- Cloud Functions Receiving Events from Pub/Sub -- Deploying a Cloud Function for Cloud Pub/Sub Events Using Cloud Console -- Deploying a Cloud Function for Cloud Pub/Sub Events Using gcloud Commands -- Summary -- Exam Essentials -- Review Questions -- Chapter 11 Planning Storage in the Cloud -- Types of Storage Systems -- Cache -- Persistent Storage -- Object Storage -- Storage Types When Planning a Storage Solution -- Storage Data Models -- Object: Cloud Storage -- Relational: Cloud SQL and Cloud Spanner -- Analytical: BigQuery -- NoSQL: Cloud Firestore and Bigtable -- Choosing a Storage Solution: Guidelines to Consider -- Summary -- Exam Essentials -- Review Questions -- Chapter 12 Deploying Storage in Google Cloud -- Deploying and Managing Cloud SQL -- Creating and Connecting to a MySQL Instance -- Creating a Database, Loading Data, and Querying Data -- Backing Up MySQL in Cloud SQL -- Deploying and Managing Firestore -- Adding Data to a Firestore Database -- Backing Up Firestore -- Deploying and Managing BigQuery -- Estimating the Cost of Queries in BigQuery -- Viewing Jobs in BigQuery -- Deploying and Managing Cloud Spanner -- Deploying and Managing Cloud Pub/Sub -- Deploying and Managing Cloud Bigtable -- Deploying and Managing Cloud Dataproc -- Managing Cloud Storage -- Summary -- Exam Essentials -- Review Questions -- Chapter 13 Loading Data into Storage -- Loading and Moving Data to Cloud Storage -- Loading and Moving Data to Cloud Storage Using the Console -- Loading and Moving Data to Cloud Storage Using the Command Line -- Importing and Exporting Data -- Importing and Exporting Data: Cloud SQL -- Importing and Exporting Data: Cloud Firestore -- Importing and Exporting Data: BigQuery -- Importing and Exporting Data: Cloud Spanner…”

Tabla de Contenidos: “…Chapter 15: Structured Data -- Data analysis -- Installing MySQL -- Importing data -- Analyzing the data model -- HBase -- Installation -- Starting an HBase instance -- Stopping a HBase instance -- Preparing an HBase for migration -- Sqoop -- Installation -- Verifying the installation -- MySQL JDBC driver -- Importing data -- Verifying the imported data -- Summary -- Chapter 16: Unstructured Data -- Moving data into Hadoop -- Downloading Flume -- Environment configuration -- Configuring agent and sink -- Running Apache Flume -- Transferring a log file -- Converting images into text for analysis -- Tesseract OCR -- Installing Tesseract -- Practical example -- Complete code -- Program execution -- Summary -- Chapter 17: Data Visualization -- Matplotlib -- Installing Matplotlib -- Line chart -- Bar charts -- Stack charts -- Scatter charts -- Pie charts -- Geographic projections -- D3.js -- Installation -- Practical example -- Output -- Summary -- Chapter 18: Financial Trading System -- What is algorithmic trading? …”

Tabla de Contenidos: “…Getting Started with JIRA -- The JIRA architecture -- High-level architecture -- Web browsers -- Application services -- Data storage -- The JIRA installation directory -- The JIRA home directory -- System requirements -- Hardware requirements -- Software requirements -- Operating systems -- Java platforms -- Databases -- Application servers -- Installation options -- Installing JIRA -- Installing Java -- Installing MySQL -- Prepare MySQL for JIRA -- Installing JIRA -- Obtaining and installing JIRA -- Configuring jira-application.properties -- The JIRA setup wizard -- Configuring JIRA as a service -- Post-installation configurations -- Configuring the application server -- Configuring HTTPS -- Installing the database drivers -- Managing the database setup -- Summary -- 2. …”

Tabla de Contenidos: “…The structure of an Angular application -- The package.json file -- Dotfiles - .editorconfig, .gitignore, and .angular-cli.json -- Environments -- Running the sample application -- Adding a new module -- Adding a new component -- Adding a new route -- Creating an Angular service -- Template data binding -- Simple deployment -- Summary -- Chapter 4: Building the Baseline Backend Application -- Additional notes about Laravel with Docker -- Creating the Docker Compose foundation -- Configuring nginx -- Configuring php-fpm -- Creating a docker-compose configuration file -- Building the application container -- Using PHP Composer to scaffold a Laravel application -- Creating the application scaffold -- Running the application -- Setting up a MySQL database -- Adding a storage folder -- Configuring the .env file -- Using a MySQL external client -- Migrations and database seed -- Creating the migration boilerplate -- Creating our first database seed -- Exploring the Workbench table view -- API documentation with the Swagger framework -- Installing the L5-Swagger library -- Creating the application API controller -- Generating and publishing the API documentation -- Adding Swagger definitions -- Summary -- Chapter 5: Creating a RESTful API Using Laravel - Part 1 -- Preparing the application and understanding what we are building -- Refactoring the application files -- What we are building -- The application's summary -- Creating models and migrations files -- Adding content to migration files -- Eloquent ORM relationship -- One-to-one relationship -- One-to-many relationship -- Many-to-many relationship -- Seeding our database -- Querying the database using Tinker -- Creating controllers and routes -- Creating and updating the controller function -- Creating the API routes -- Generating Swagger UI documentation -- Summary…”

Tabla de Contenidos: “…-- Building Pyramid applications with PyCharm -- Creating a Pyramid project -- Summary -- Questions -- Further reading -- Understanding Database Management in PyCharm -- Technical requirements -- Relational databases in a nutshell -- Structured Query Language -- The two halves of SQL -- Relationships -- More relational structures -- Database terminology uses simple English plurals -- Database tooling in PyCharm -- Setting up a MySQL database server with Docker -- Installing and running the MySQL container -- Stopping and starting the container -- Connecting to data sources using PyCharm -- Creating a new database -- Setting the SQL dialect (this is crucial) -- Grouping and color coding data sources -- Database design and manipulation -- Creating a table -- Altering existing structures -- Generating scripts -- Querying the data source using SQL -- Ad hoc queries -- Generating SQL statements -- Running the query -- Exporting query results -- Working with SQL files -- Summary -- Further reading -- Part 4: Data Science with PyCharm -- Turning On Scientific Mode -- Technical requirements -- Creating a scientific project in PyCharm -- Additional configuration for science projects in PyCharm -- Markdown plugins -- Adding images -- Installing the CSV plugin -- Installing the cell mode plugin -- Installing packages -- Backfill your requirements.txt file -- Adding some sciency code -- Toggling scientific mode -- Understanding the advanced features of PyCharm's scientific projects -- The documentation viewer -- Using code cells in PyCharm -- Using PyCharm code cells -- The cell mode plugin -- Summary -- Questions -- Dynamic Data Viewing with SciView and Jupyter -- Technical requirements…”

Tabla de Contenidos: “…Intro -- Title Page -- Copyright Page -- Table of Contents -- Introduction -- About This Book -- Foolish Assumptions -- Icons Used in This Book -- Beyond the Book -- Book 1 Getting Ready to Code for the Web -- Chapter 1 How Web Coding and Development Work -- The Nuts and Bolts of Web Coding and Development -- How the web works -- How the web works, take two -- Understanding the Front End: HTML and CSS -- Adding structure: HTML -- Adding style: CSS -- Understanding the Back End: PHP and MySQL -- Storing data on the server: MySQL -- Accessing data on the server: PHP -- How It All Fits Together: JavaScript -- How Dynamic Web Pages Work -- What Is a Web App? …”

Tabla de Contenidos: “…. -- Chapter 12: Advanced Zabbix Database Management -- Technical requirements -- Setting up MySQL partitioning for your Zabbix database -- Getting ready -- How to do it... -- How it works... -- See also -- Using the PostgreSQL TimescaleDB functionality -- Getting ready -- How to do it... -- How it works... -- See also -- Securing your Zabbix MySQL database -- Getting ready -- How to do it... -- How it works... -- Chapter 13: Bringing Zabbix to the Cloud with Zabbix Cloud Integration -- Technical requirements -- Setting up AWS monitoring -- Getting ready -- How to do it... -- How it works... -- There's more... -- Setting up Microsoft Azure monitoring -- Getting ready -- How to do it... -- How it works... -- There's more... -- Building your Zabbix Docker monitoring -- Getting ready -- How to do it... -- How it works... -- There's more... -- Index -- Other Books You May Enjoy…”

Tabla de Contenidos: “…Funding Cannot Be Saved for Use in Later Implementation Periods Projects Begin Planning and Design in the First Year of an Implementation Period; Project Effects Are Offset by Planning, Design, and Construction Time; Projects Must Continually Operate; Handling and Processing of Data Within the Planning Tool; MySQL Database; Analytical Module; General Algebraic Modeling System Optimization Module; Tableau Results Visualizer; CHAPTER THREE: Analytic Procedures; Characterization of Projects; Project Costs and Duration of Implementation; Conflicts Among Projects…”

Tabla de Contenidos: “…""Default Node""""Node Inheritance""; ""Variable Scoping""; ""The Puppet Style Guide""; ""Making (More) Magic With Modules""; ""Version-Controlling Your Modules""; ""Creating a Module to Manage SSH""; ""The ssh::install Class""; ""The ssh::config Class""; ""The ssh::service Class""; ""Creating a Module to Manage Postfix""; ""The postfix::package Class""; ""The postfix::config Class""; ""The postfix::service Class""; ""Managing MySQL with the mysql Module""; ""The mysql::install Class""; ""The mysql::config Class""; ""The mysql::service Class""; ""Managing Apache and Websites""…”

Tabla de Contenidos: “…Adding multiple JSON documentsSequential JSON update commands; Indexing updates using CSV; Summary; Chapter 5: Index Data Using Structured Data Source Using DIH; Indexing data from MySQL; Configuring datasource; DIH commands; Indexing data using XPath; Summary; Chapter 6: Indexing Data Using Apache Tika; Introducing Apache Tika; Configuring Apache Tika in Solr; Indexing PDF and Word documents; Summary; Chapter 7: Apache Nutch; Introducing Apache Nutch; Installing Apache Nutch; Configuring Solr with Nutch; Summary; Chapter 8: Commits, Real-Time Index Optimizations, and Atomic Updates…”

Tabla de Contenidos: “…; DBSyncers - the unknown bottleneck; Summary; Chapter 4: Tuning the MySQL Database; Comparisons between databases; The main configuration parameters…”

Tabla de Contenidos: “…; ""Summary""; ""Chapter 3: Applications for the Cloud""; ""Case Study of Storm: A Data-Driven, Cloud-Based Solution""; ""Case Study of iCloud: Storm Manager App""; ""Case Study of Azure: Grocery Store Customer Application""; ""Case Study of MySQL: Storm Point of Sale Application""…”

Tabla de Contenidos: “…; The LAMP Stack; The Drupal Core; Security; Content Types; Contributed Modules; Themes; The Drupal Design Philosophy; Database; Forms; Security; Menus and Paths; Users, Roles, and Permissions; Summary; CHAPTER 2 The Page Lifecycle; The Drupal Page Lifecycle; Menu Handler; Menus; The Menu Tree; Theming; Summary; CHAPTE R 3 Wherefore Drupal?; PHP; Arrays; MySQL; Summary…”

Tabla de Contenidos: “…WordPress.org -- New in WordPress 3.0 -- Chapter 2: Installing WordPress -- Getting What You Need -- Setting up the MySQL Database -- Choosing Your Blog's URL -- Installing WordPress -- Editing the wp-config File -- Troubleshooting Common Installation Problems -- Chapter 3: Managing User Accounts -- Managing User Profiles -- Adding and Deleting Users -- Chapter 4: The Dashboard -- Right Here: Right Now -- Meeting the Public: Comments and Links -- Plugins -- QuickPress -- Recent Drafts -- WordPress Blog -- Keeping Current: Other WordPress News -- Customizing the Dashboard -- Beyond the Dashboard -- Chapter 5: Futureproofing Your Blog -- General Settings -- Writing Settings -- Reading Settings -- Discussion Settings -- Avatar Settings -- Media Settings -- Privacy Settings -- Permalink Settings -- Chapter 6: Preparing to Post -- Breaking Down the Elements of a Post -- Composing and Formatting a Post -- Adding Media to a Post -- Creating Tags and Categories -- Setting Advanced Posting Options -- Customizing the Add New Post Screen -- Chapter 7: Publishing Your Post (Finally!) …”

Tabla de Contenidos: “…-- Frontend, Backend, and the Cloud -- Classic Websites vs Single Page Applications -- The Talk About Programming Languages -- Summary -- Part II: The Tech Stack -- Chapter 2: SQL Basics -- Installing MySQL -- Database Structure and Creation -- SQL Selects -- Homework -- SQL Functions -- SQL Joins -- Indexes -- Homework (5-15 Mins) -- Summary -- Chapter 3: HTML and CSS -- HTML -- CSS -- Bootstrap -- Homework -- Summary -- Chapter 4: GraphQL and JavaScript -- GraphQL -- JavaScript -- Functional Programming -- Constants and Variables -- Functions -- Shorthand if Statements -- Arrays -- Destructuring and Spread -- Promises -- Summary -- Chapter 5: The Backend -- The Setup (Optional) -- Homework -- Your First Query -- Setting Up the ORM -- Homework -- Your First Mutation -- Homework -- Summary -- Chapter 6: The Frontend -- The Figma UX/UI -- The Setup -- The Static Page -- Creating the Popup -- Homework (30-40 Min) -- Creating React Components -- Homework (10 Min) -- Linking the Backend and the Frontend Using Apollo -- Using Mutations to Create a Customer -- Homework -- Summary -- Chapter 7: Going Fullstack -- The Design Ticket -- The New Feature Ticket -- Homework -- Summary -- Chapter 8: Automated Testing -- Testing Concepts -- Unit Testing -- Test Driven Development -- Integration Tests -- End-to-End Testing -- Homework -- Summary -- Chapter 9: Other Frameworks and Technologies…”

Tabla de Contenidos: “…Ticks -- Signals -- Alarms -- Multiprocessing -- Summary -- Chapter 6: Prominent OOP Features -- Object inheritance -- Objects and references -- Object iteration -- Object comparison -- Traits -- Reflection -- Summary -- Chapter 7: Optimizing for High Performance -- Max execution time -- Memory management -- File uploads -- Session handling -- Output buffering -- Disabling debug messages -- Zend OPcache -- Concurrency -- Summary -- Chapter 8: Going Serverless -- Using the serverless framework -- Using Iron.io IronWorker -- Summary -- Chapter 9: Reactive Programming -- Similarities with event-driven programming -- Using RxPHP -- Installing RxPHP -- Observable and observer -- Subject -- Operator -- Writing custom operators -- Non-blocking IO -- Using React -- Installing React -- React event loop -- Observables and event loop -- Summary -- Chapter 10: Common Design Patterns -- Base patterns -- The registry pattern -- Creational patterns -- The singleton pattern -- The prototype pattern -- The abstract factory pattern -- The builder pattern -- The object pool pattern -- Behavioral patterns -- The strategy pattern -- The observer pattern -- The lazy initialization pattern -- The chain of responsibility pattern -- Structural patterns -- The decorator pattern -- Summary -- Chapter 11: Building Services -- Understanding the client-server relationship -- Working with SOAP -- XML extensions -- Creating server -- Creating WSDL file -- Creating client -- Working with REST -- JSON extensions -- Creating server -- Creating client -- Working with Apache Thrift (RPC) -- Installing Apache Thrift -- Defining service -- Creating server -- Creating client -- Understanding microservices -- Summary -- Chapter 12: Working with Databases -- Working with MySQL -- Installing MySQL -- Setting up sample data -- Querying via the MySQLi driver extension -- Connecting…”

Tabla de Contenidos: “…-- Summary -- Chapter 10: Windows IoT Core -- Getting started -- Flashing IoT -- Python for Linux or Windows 7 and 8 -- The first boot -- Remote connections -- Visual Studio (VS) -- Installing Visual Studio 2015 -- The Hello World application -- Deploying the application -- Debugging -- Breakpoints -- Unhandled exceptions -- Samples -- Windows 10 IoT WebGUI -- Setting up the startup app -- Peripherals -- Bluetooth -- Wireless -- Summary -- Chapter 11: Running Your ownCloud -- Installation -- Requirements -- MySQL -- nginx and PHP -- Permissions -- The first configuration -- The admin configuration -- The server admin -- Installing apps -- Calendar -- Other apps -- Daily functionality -- The World Wide Access -- Summary -- Chapter 12: The Internet of Things - Sensors in the Cloud -- What is IoT? …”