Amazon Redshift
Upon completion of this training, trainees will be able to log in to the AWS Management Console and use EC2 Instance Connect to communicate with Redshift. They would also be able to create and resize a Redshift cluster. The trainees will be trained on loading data into Redshift and query data with Redshift.
Trainees should be familiar with:
- Basic understanding of the Linux bash shell
- Conceptual understanding of SQL and Redshift
Apache Hive
This is an introductory training on one of the most used tools in big data – Apache Hive, an ETL(Extraction, Transformation, and Loading) tool, and data warehouse infrastructure software that can create interaction between users and Hadoop Distributed File System (HDFS). The training starts with the introduction to Hive before progressing to the following topics, which utilize a hands-on approach to explain. Trainees will learn internal and external table structures, reading data from different formats into Hive structure. With the help of an easy and intuitive explanation, they will get a good grasp of how to load data into Hive, querying techniques, and generate views in Hive tables.
To get the most out of this training, trainees should have a good working knowledge of IT infrastructures, databases, and the Microsoft Azure platform.
Azure Synapse Analytics
This training is an introduction to Microsoft’s Azure Synapse Analytics. It covers serverless SQL pools, dedicated SQL pools, Spark pools, and Synapse Pipelines. We will also cover more advanced topics, such as optimization and security. The objective of the training is to create and use serverless SQL pools, dedicated SQL pools, Spark pools, and Synapse Pipelines.
- Experience with databases
- Experience with SQL (not mandatory)
Google BigQuery
BigQuery is Google’s managed data warehouse in the cloud. BigQuery is incredibly fast. It can scan billions of rows in seconds. It’s also surprisingly inexpensive and easy to use. Querying terabytes of data costs only pennies and you only pay for what you use since there are no up-front costs.
This is a hands-on training where you can follow along with the demos using your own Google Cloud account or a trial account. This training will first show trainees the fundamentals of how to use BigQuery and then how to optimize BigQuery to reduce costs, speed up your queries, and apply proper access control.
- Experience with databases
- Familiarity with writing queries using SQL is recommended
- A Google Cloud Platform account is recommended
SAP BW/HANA
This training covers SAP BW on HANA (7.5) which includes InfoObjects, Advanced DSO’s, HANA Composite Provider, DTP, Transformation, Eclipse Query designer with detailed step by step demo. Detailed hands-on experience on using BW Modeling tools(BW-MT) in HANA Studio will be given. The training covers all fundamental data modeling concepts in BW 7.5 on HANA with clear examples and demo.
- No prior experience required
- Knowledge of SAP will be an added advantage
- Having a BW System access can help to practice the demo
Snowflake
Harnessing the power of the cloud, Snowflake has unique capabilities in the form of unlimited and instant scalability, making it perhaps the ultimate data warehouse solution. Cloud elasticity is very much at the heart of Snowflake – making its unique architecture and value proposition difficult to compete with in the market. The objective of the training is to learn about Snowflake, Data warehouses and perform analytics on petabyte scale and beyond datasets.
To get the most from this training, it would help to have a basic understanding of:
- Basic Cloud and SaaS knowledge
- Basic DBA knowledge
- Basic SQL knowledge
Teradata
Teradata Education designs, develops and delivers education that builds skills and capabilities to enable your company to maximize and expand its Teradata investment. Through both our free and cost-effective training, trainees have access to our highly experienced instructors and a world-class collection of online content and instructor-led training.
- Experience with databases
- Experience with SQL (not mandatory)
SAP Data Warehouse Cloud
This training enables experienced SAP BW users, modelers as well as administrators to run and work with SAP Data Warehouse Cloud, SAP BW Bridge. The emphasis on how to integrate classic on-premise SAP sources and their extractors. Another scenario is the migration of existing SAP BW content and leverage of modeling capabilities in SAP Data Warehouse Cloud.
- There are no formal prerequisites for this SAP Data Warehouse Cloud training.
SAP HANA
In this training, trainees learn how you can use SAP HANA and new features in the ABAP programming language to optimize existing ABAP code and to develop innovative ABAP applications to enhance your business. This training will prepare them to develop more concise and well-performing ABAP programs using new features of the ABAP programming language and optimize ABAP applications that access data stored in the SAP HANA Database.
- To get the most out of this training, trainees should have a basic knowledge of both Microsoft Azure and SAP
SAP BW/4HANA
This training provides an overview of SAP BW/4HANA and detailed knowledge to design BW Queries in both SAP BW/4HANA and SAP BW powered by SAP HANA. Users of either system will gain the knowledge to create query definitions using the eclipse-based BW Query Designer in SAP HANA Studio and to make them available for analysis.
Schedule a Demo
Fill the form to schedule a demo with us.