Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member will contact you shortly.
Course Outline
Lesson 1 - SQL basics:
- Select statements
- Join types
- Indexes
- Views
- Subqueries
- Union
- Creating tables
- Loading data
- Dumping data
- NoSQL
Lesson 2 - Data Modeling:
- Transaction based ER systems
- Data warehousing
- Data warehouse models
- Star schema
- Snowflake schemas
- Slowly changing dimensions (SCD)
- Structured and non-structured data
- Different table type storage engines:
- Column based
- Document-based
- In Memory
Lesson 3 - Index in the NoSQL/Data science world
- Constraints (Primary)
- Index-based scanning
- performance tuning
Lesson 4 - NoSQL and non-structured data
- When to use NoSQL
- Eventually consistent data
- Schema on read vs. Schema on write
Lesson 5 - SQL for data analytics
- Windowing function
- Lateral Joins
- Lead & Lag
Lesson 6 - HiveQL
- SQL Support
- External and Internal Tables
- Joins
- Partitions
- Correlated subqueries
- Nested queries
- When to use Hive
Lesson 7 - Redshift
- Design and structured
- Locks and shared resources
- Postgres differences
- When to use redshift
Requirements
- An understanding of databases
- Experience with SQL an asset.
Audience
- Business analysts
- Software developers
- Database developers
Testimonials
The content, as I found it very interesting and think it would help me in my final year at University.
Krishan Mistry - NBrown Group
Richard's training style kept it interesting, the real world examples used helped to drive the concepts home.
Jamie Martin-Royle - NBrown Group
I generally liked the fernando's knowledge.
Valentin de Dianous - Informatique ProContact INC.
The subject matter and the pace were perfect.
Tim - Ottawa Research and Development Center, Science Technology Branch, Agriculture and Agri-Food Canada
The tutor, Mr. Michael Yan, interacted with the audience very well, the instruction was clear. The tutor also go extent to add more information based on the requests from the students during the training.
Ottawa Research and Development Center, Science Technology Branch, Agriculture and Agri-Food Canada
the introduction of new packages
Ottawa Research and Development Center, Science Technology Branch, Agriculture and Agri-Food Canada
Michael the trainer is very knowledgeable and skillful about the subject of Big Data and R. He is very flexible and quickly customize the training to meet clients' need. He is also very capable to solve technical and subject matter problems on the go. Fantastic and professional training!
Xiaoyuan Geng - Ottawa Research and Development Center, Science Technology Branch, Agriculture and Agri-Food Canada
The broad coverage of the subjects
- Roche
Intensity, Training materials and expertise, Clarity, Excellent communication with Alessandra
Marija Hornis Dmitrovic - Marija Hornis
The example and training material were sufficient and made it easy to understand what you are doing
Teboho Makenete
I liked the way that my trainer was teaching us, and the Meeting Room was taken for our course.
Mohammed Othman Karim, Sulaymaniyah Asayish Agency
Interactive topics and the style used by the lecture to simplified the topics for the students
Miran Saeed - Mohammed Othman Karim, Sulaymaniyah Asayish Agency
Smart and cleverness
Mohammed Othman Karim, Sulaymaniyah Asayish Agency
the trainer and his ability to lecture
ibrahim hamakarim - Mohammed Othman Karim, Sulaymaniyah Asayish Agency
Practical exercises
JOEL CHIGADA - University of the Western Cape
R programming
Osden Jokonya - University of the Western Cape
Overall the Content was good.
Sameer Rohadia
presentation of technologies
Continental AG / Abteilung: CF IT Finance
Willingness to share more
Balaram Chandra Paul
trainer's knowledge
Fatma Badi - Maitha Jamal Alshamsi, Dubai Electricity & Water Authority
Related Courses
SPSS Modeler
14 hours
Databricks
14 hours
Data Cleaning
7 hours
Sensu: Beginner to Advanced
14 hours
Automated Monitoring with Zabbix
14 hours
Fluentd for Log Data Unification
14 hours
Nagios Core
21 hours
Nagios
35 hours
Nagios XI Administration
21 hours
Advanced Nagios
21 hours
Zenoss Monitoring for Administrators
21 hours
Netdata
7 hours