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

Hands on experience for MySQL,MariaDB,Cassandra,Nosql and Big data ( Hadoop ) on AWS cloud and advance your career.
3.9 (19 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
407 students enrolled
Instructed by Theo W. Development / Databases
92% off
Take This Course
  • Lectures 38
  • Length 4 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2016 English

Course Description

By 2020, there will be a lot of shortage for data scientists and analytic professionals. The United States alone faces a shortage of 140,000 to 190,000 people with analytical expertise. This course gives you what you need to get started for data scientists, system administrator, devOps. You will be able to create MySQL cluster that uses ndb storage engine, create MariaDB Galera cluster, create Cassandra cluster, and also you will be able to create a hadoop cluster. You will be able to load balance for your databases using Ha-proxy. You will be able to deploy all of these on AWS cloud with Amazon Elastic Compute Cloud (EC2). You will get reinforced by hands on experience with an assignemt on every section. Furthermore, you will also be able to map between MariaDB with Cassandra, so you can use both RDBMS and NoSQL all together for your needs. You can advance your career with this course, save thousands of dollars that you spend otherwise, and make it easier to land a job.

What are the requirements?

  • A passion to learn
  • A passion to advance your career
  • A passion for success
  • Need Internet access since most of these classes will be deployed on AWS
  • A computer/Laptop with any OS (Windows, Ubuntu, Mac OS, etc)

What am I going to get from this course?

  • Learn about AWS | Amazon Elastic Compute Cloud (EC2), Security group, launch instance, access to it
  • Learn about basic MySQL and NoSQL(Cassandra) syntax
  • Learn about how to create one of the leading NoSQL DB, Cassandra cluster on AWS
  • Learn about High Available MySQL cluster with NDB engine
  • Learn about how to create MariaDB Galera cluster for true master-master , fault tolerant RDBMS on AWS
  • Learn about how to create instances( for databases) on different available zones on a cloud for true fault tolerant
  • Learn about how to connect between MariaDB(RDBMS) with Cassandra(NoSQL) storage
  • Learn about how to load balance for database servers
  • Learn about how to create a Hadoop cluster and do map-reduce jobs

Who is the target audience?

  • Anyone new to database
  • Anyone who would like to become a Web developer, Database developer, System Administrator
  • Anyone who doesn't have enough time, but want to learn practical things by doing it
  • This is for anyone who haven't had any experience, but would like to get started for various databases and hands on experience with them
  • If you / your company wants to know about what databases out on the market and would like to try and save a lot of time with these videos

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Course Introduction
Section 2: AWS(Amazon Web Services) EC2 . AWS account, instance, access
Create an AWS account
Create an AWS instance
Access to an instance ( Windows )
Access to an instance ( Linux )
1 question

Create AWS account, and create at least one micro instance on AWS and access to it. 

Don't forget to stop your instance after you finish your task ; )

Section 3: Create a Cassandra cluster on commodity hardwares for scalability
Create one Cassandra instance on AWS
Create a Cassandra cluster with two servers on AWS
Create a Keyspace, table, and Insert, Update, Delete data on it.
1 question

Create a Cassandra cluster and make a Keyspace,table, then insert data into it.

Section 4: MariaDB Galera Cluster
Create a MariaDB Galera Cluster with three Ubuntu servers 1st part
Create a MariaDB Galera Cluster with three Ubuntu servers 2nd part
1 question

Launch three instances and create a Galera DB cluster

* Don't forget to stop your instances after your task ;)

Create AWS VPC Peering connection. Five steps( step 1,2,3)
Create AWS VPC Peering connection. Five steps( step 4,5)
Create a MGC on different availability zones for a true fault tolerance-(A)
Create a MGC on different availability zones for a true fault tolerance-(B)
Secure AWS instance access
1 question

Create your MariaDB Galera Cluster on a different availability zones with AWS VPC peer connection. 

Connect between MariaDB and Cassandra
Section 5: Haproxy (High available proxy ) load balance
Haproxy configuration overview
Haproxy configuration on AWS with MariaDB Galera cluster
View Haproxy work loads through web and terminal with MariaDB client
1 question

Create a HAProxy server and load balance your databases.

Section 6: Mysql cluster
Create a Mysql Cluster with 4 machines on the cloud on AWS 1st part (Management)
Create a Mysql Cluster with 4 machines on the cloud on AWS 2nd part( Data nodes)
Create a Mysql Cluster with 4 machines on the cloud on AWS 3rd (sql node)
1 question

Create a MySQL cluster before proceeding please.

MySQL : Create a database
MySQL : Create a Table
MySQL : Describe a table
MySQL : Pattern matching
MySQL : Insert Data, Retrieve Data, Check tables
MySQL : Comparison Operators & logical operators
MySQL : Order By
MySQL : Limit By
MySQL : Distinct, Count, Name As
MySQL : Update a row and Delete a row
MySQL : Rename a Table
MySQL : Drop a table
MySQL : Drop a database
Section 7: Hadoop Single node cluster
Create a Single Node Hadoop Cluster part 1
Create a Single Node Hadoop Cluster part 2
Create a Single Node Hadoop Cluster part 3 And run a map reduce job
1 question

Create a Hadoop cluster

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Theo W., Software Engineer, Architect for start ups

Theo has been in the IT industry over 10 years in experience, and he is a software engineer and consulting for infrastructure and Internet of things and acted as a technical consultant for small companies. He is the one of the first group of Cassandra Developer Certified and constantly looking for ways to find the best solution for companies' needs. He believes that securing job is very important and can be made by hands on experience and knowledge.

Ready to start learning?
Take This Course