Course Code:
bespokemployskills
Duration:
462 hours
Prerequisites:
Basic Computer knowledge.
Overview:
- Incorporating technology into the learning environment not only creates a highly accessible course, but it also prepares the workforce for the next wave of technology.
- IT training programs cover a spectrum of areas inclusive of software applications, business applications, hardware, security, database, programming etc.
- In this live training, participants will learn how to work with Hadoop, Python, SQL, MapReduce, Pig, and Spark using Python as they step through multiple examples and use cases.
Course Outline:
Python:
| Introduction to Coding |
| Variables definitions |
| Loops |
| Conditions |
| Functions |
| Printing |
| Dealing with Files |
| OOP using Python |
| Python Data Modules |
| Using Pip |
| Exception Handling |
MS Excel
| Tabular data format |
| Excel expressions |
| Built-in Functions |
| IF Conditions |
| Conditional Formatting |
| Data aggregation |
| Text Processing |
| Data Visualization |
| Charts and Diagrams |
| Pivot Tables |
| Introduction to Macros |
Hadoop
| Introduction to Big Data |
| 4 Vs |
| Distributed Systems |
| Installing and Configuring Hadoop |
| Monitoring |
| Maintenance |
| Troubleshooting |
| Extracting data |
| Installing applications and scripts |
| Data aggregation |
SQL
| Introduction to SQL |
| SQL Statements |
| Using SQL Insert |
| Using SQL Update |
| Using SQL Delete |
| Using SQL Select |
| Creating Tables |
| Creating Users and Roles |
| Monitoring Database Server |
| Generating Reports |
| Backup and restore |
| SQL Procedures |
Technology Use
| Making use of technology |
| Power of software |
| Collaboration Applications |
| Communications Applications |
| Cloud Computing |
| Making using of Digital Transformation |
| Dealing with Technology Teams |
Information Use
| Information vs Data |
| Data Visualization |
| Creating Reports and Presentations |
| Creating Informative Dashboards |