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.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Course Introduction|
|Section 2: AWS(Amazon Web Services) EC2 . AWS account, instance, access|
Create an AWS accountPreview
Create an AWS instance
Access to an instance ( Windows )
Access to an instance ( Linux )
|Quiz 1||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.
|Quiz 2||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
|Quiz 3||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
|Quiz 4||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
|Quiz 5||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)
|Quiz 6||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
|Quiz 7||1 question|
Create a Hadoop cluster
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.