AWS Analytics - Live Training
| Class | Start Date | Status | Price |
|---|---|---|---|
| AWS Analytics FREE for recent college graduates |
Jan 09 | Open | $1,500.00 |
AWS Analytics - Online Training
| Class | Start Date | Status | Price |
|---|---|---|---|
| AWS Analytics FREE for recent college graduates |
Jan 09 | Open | $1,500.00 |
TO RESERVE YOUR SPOT:
Call: (540) 449-5501
E-mail: vijay@vxltraining.com
$500 payment immediately to reserve your spot and balance after the first day of class.
All of our credit card payments are processed by PayPal and are 100% secure.
You MUST EMAIL US with:
1) Name 2) Phone Number and 3) The Course you have signed up for, after you make your payment.
Please select the Option and Click on the Buy Now Button to pay for your class
Please select the Class and Option and Click on the Buy Now Button to pay for your class
Curriculum
Course : AWS Analytics
Total duration of course 30 hours,40 hours assignments, case studies, Projects
Tools covered in this Course:
1) AWS Glue server less ETL tool.
2) AWS Redshit
3) QuickSight, ,Dashboard reporting tool
4) Athena,
5) AWS Redshift Spectrum
AWS Glue server less ETL tool.
- Introduction to AWS Glue
- How It Works
- Getting Started
- Security
- Populating the AWS Glue Data Catalog
- Authoring Jobs
- Starting Jobs and Crawlers Using Triggers
- Running and Monitoring
- Performing Complex ETL Activities Using Workflows
- AWS Glue Schema Registry
- ETL Programming
- Matching Records with Find Matches
- AWS Glue API
- Troubleshooting
- Known Issues
- AWS Glue Release Notes
- Document History
Amazon Redshift
- System overview
- Getting started using databases
- Best practices
- Tutorials
- Working with automatic table optimization
- Loading data
- Unloading data
- Creating user-defined functions
- Creating stored procedures
- Creating materialized views
- Querying spatial data
- Querying data with federated queries
- Querying external data using Amazon Redshift Spectrum
- Using HyperLogLog sketches in Amazon Redshift
- Using machine learning in Amazon Redshift (preview)
- Ingesting and querying semistructured data in Amazon Redshift (preview)
- Querying data across databases (preview)
- Sharing data across clusters (preview)
- Tuning query performance
- Implementing workload management
- Managing database security
- SQL reference
- System tables reference
- Configuration reference
- Sample database
AWS Athena:
- Introduction to Amazon Athena?
- Setting Up
- Getting Started
- Accessing Amazon Athena
- Connecting to Data Sources
- Creating Databases and Tables
- Running Queries
- Security
- Using Workgroups to Control Query Access and Costs
- Tagging Resources
- Monitoring Logs and Troubleshooting
- Athena Engine Versioning
- SerDe Reference
- SQL Reference
- Code Samples, Service Quotas, and Previous JDBC Driver
- Release Notes
Amazon QuickSight
- Introduction to Amazon Quick Sight
- How It Works
- Exploring Data for Dashboard Subscribers
- Getting Started
- Using the Console
- Organizing Assets into Folders
- Working with Data
- Preparing Data
- Working with Analyses
- Working with Visuals
- Working with ML Insights
- Working with Dashboards
- Functions and Operators
- Embedding and Other SDKs
- Troubleshooting
- Administration
- AWS Security
Amazon Redshift Spectrum
- Querying external data using Amazon Redshift Spectrum
- Getting started with Amazon Redshift Spectrum
- IAM policies for Amazon Redshift Spectrum
- Using Redshift Spectrum with Lake Formation
- Creating data files for queries in Amazon Redshift Spectrum
- Creating external schemas
- Creating external tables
- Improving Amazon Redshift Spectrum query performance
- Monitoring metrics
- Troubleshooting queries
- Tutorial: Querying nested data with Amazon Redshift Spectrum
Class Location
22710 Haggerty Road, Suite 190
Farmington Hills, MI 48335
This class is currently Online Only due to COVID!!
Class Timings
Sat - Sun: 1pm - 4pm EST
Wed - Friday: 7pm - 9pm EST
Class will be for 5 Weeks
Office Location
22710 Haggerty Road, Suite 190
Farmington Hills, MI 48335
This class is currently Online Only due to COVID!!
SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign are trademarks or registered trademarks of SAP AG.