Big data,Cassandra,AWS,Mysql,MariaDB,Linux for Beginners

Learn how to create an AWS account and set up a service account through the AWS console. Explore the 750 hours per month free tier and essential sign-up steps.

Launch an AWS instance with a simple setup, configure security and ports, generate and download an SSH key, and learn to stop the instance to avoid charges.

Access your Windows-based instance by using an SSH client, such as PuTTY. Install the client, save your private key, enter the instance IP, and connect via SSH.

learn to access a linux instance using a key pair, set file permissions to 600, and connect via the instance's public ip address with ssh.

Create a Cassandra instance on aws by setting up a two-server cluster, installing Java, and configuring no single point of failure.

Create a two-node Cassandra cluster on AWS by configuring keyspace and tables, adjusting Cassandra settings (private IP seeds, listen and RPC addresses), then start the cluster and verify status.

Create a keyspace and a users table in Cassandra, insert, update, and delete sample records, and verify changes across replicated instances.

Create a three-node mariaDB Galera cluster on Ubuntu servers in AWS, enabling reliable replication and high availability, while comparing GPL open-source licensing with commercial options.

Create a MariaDB Galera cluster on three Ubuntu servers by configuring private IPs, copying and reusing the config, starting services, and verifying a three-node cluster with show status.

Learn to design a fault-tolerant AWS VPC by creating a virtual private cloud, configuring non-overlapping CIDR blocks, subnets, and gateways across multiple availability zones.

Learn to create AWS VPC peering connections across VPCs, grant permissions, accept requests, and update route tables with VPC IDs and IP ranges in steps 4 and 5.

Learn to deploy a multi-zone cluster by creating multiple AWS instances across availability zones, configure a VPC and security groups, and open essential ports for communication and replication.

Create a MGC across multiple availability zones to ensure fault tolerance by provisioning three instances, configuring private IPs, managing credentials, backing up configs, and starting services.

Secure AWS instance access by restricting ssh to your ip via security group rules. Find your ip, add it to the ssh rule, and enable access only when needed.

Explore how to connect Cassandra with MariaDB, set up a Cassandra keyspace and table, and exchange data with a relational database using a SQL-like approach and a Cassandra driver.

Learn HAProxy configuration overview, using a load balancer to route requests to healthy database servers, with round-robin and weighted balancing to handle high traffic and ensure availability.

Set up haproxy on AWS to manage a MariaDB Galera cluster, configure the proxy, adjust security groups and IP addresses, and verify access via a web-based interface.

Learn how to view haproxy workloads via web and terminal using a MariaDB client, configure access via IP-based grants, and use a proxy to connect to multiple databases.

Create a four-machine MySQL cluster on AWS, focusing on management, security groups, port configuration, and setting up cluster members and API clients for communication.

Learn to create a MySQL cluster with four cloud machines on AWS, focusing on data nodes setup, file preparation, user creation, and configuring server IP addresses.

Create a four-node MySQL cluster on AWS, set up a miscible group and users, configure permissions and cluster files, and verify data read and write across the nodes.

Learn how to create a database in MySQL with the NDB cluster engine, switch to the database, and access, update, and query tables using basic SQL commands.

Create a car dealer table in MySQL, with dealer_id as an autoincrementing integer primary key and not null, plus columns for name, email, and address details.

Learn how to describe a table in MySQL, including identifying the primary key, data types, and defaults, and using commands to inspect table structure.

Use pattern matching with like in mysql to restrict show columns output to column names that match a pattern, displaying only matching columns.

Learn how to insert and retrieve data in MySQL, define primary keys with auto_increment, set defaults, and inspect tables using describe and show columns in a car dealer example.

Learn how to use MySQL comparison and logical operators to filter data with where clauses, including conditions like price less than 10000 and manufacturer BMW.

Learn how to use the MySQL order by clause to sort data in ascending or descending order, understand default sorting behavior, and apply it to a specific column.

Learn how to limit MySQL output to the first rows, including the first five rows, and understand how ordering affects which records appear.

Learn how MySQL uses distinct values to count unique rows and alias a result with as to display a specific name.

Update a row in MySQL to apply a 10 percent price reduction on a car, using the price column and a where clause, then delete the sold car row.

Rename a table in MySQL using the basic syntax you’ll likely use often to update table names, illustrated by renaming a car dealer table.

Learn how to drop a table in MySQL, including specifying the table name and removing a table from a database.

Explore how to drop a MySQL database, focusing on the 'drop database' command, the role of semicolons, and the potential dangers of careless execution.

Create a single-node hdfs-based hadoop cluster to run map reduce jobs and explore the ecosystem with spark.

Set up a single-node Hadoop cluster by generating and securing SSH keys, configuring environments, starting Hadoop, creating HDFS directories, and verifying the name node status in the browser.

Create a single node Hadoop cluster and run a MapReduce job to count word occurrences in a book, transferring files from local to a server and displaying results.