Course Description
We partnered with
industry insiders to help you learn the data engineering skills that employers
look for. This curriculum features a combination of hands-on projects, case
studies, and career-related coursework.
Module
1: Data Modeling
This
module focuses on various aspects of database designing concepts right from
entities, keys, constraints, etc. to creating physical instance of databases.
The focus of Data Modeling is to understand different stages of database
designs patterns along with ways to gather business requirements.
Module 2: T-SQL
This
module exposes the candidates to the very details of TSQL programming along
with working on database objects such as tables, views, stored procedures, user
defined functions, triggers, and indexes. Module also covers performance
implications of multitude of SQL structures such as joins, sub-queries, set
operators, CTEs to be incorporated for implementing business requirements
Module 3: Data Warehousing
Data
Warehousing module provides detailed insight on the designing and developing
data structures to store historical data for analytical purposes. This module
further explains more about the internals and architecture of Data Warehouses
and Data Marts following Kimball or Inmon Methodologies.
Module 4: SSIS
In
this module candidates will learn SSIS Architecture and object model XML
Framework, Data flow task introduction, ADO.Net source and destination.
Furthermore, this module also focuses on writing XML Source , SQL Server
Destination and SQL Server Compact Destination.
Module 5: SSAS
In
this module candidates will learn purpose and application of creating
multi-dimensional cube and tabular models for further data analysis.
Furthermore, this module also focuses on writing MDX and DAX queries for
analytical purposes.
Module 6: SSRS
This
module is mainly used as presentation layer for creating different types of
visual reports for making business decisions. Candidates will be learning
different types of reporting constructs, publishing, maintaining reports on
Report Server.
Module 7: Power BI
This
module is primarily focused on creating data visualizations, data cleansing,
DAX for calculations etc. In this module candidates will also learn different
ways of publishing, embedding, maintaining reports & dashboards within Power
BI services and Power BI report server.
Module 8: Microsoft Azure
This
module focuses On IAAS & PASS services which includes compute, storage,
Azure data services(Azure SQL, Data pools, Synapse Analytics and Data Factory.
Module 9: Tableau
This
module offers different ways of developing business interactive dashboards
utilizing Tableau Desktop. Candidates will be exposed to various features of
Tableau related to data preparation, data blending, calculations utilizing LOD
expressions, and publishing to enterprise portal.
Module 10: Python
This
module offers overview of Python basics, data structures in Python, various
programming constructs and commonly used libraries. This will also include
various methods of extracting data, cleansing, and basic data visualizations
per business requirements.
Module 11: Snowflake
This
module focuses on the key concepts and architecture of Snowflake. Candidates
will learn how to provision a Virtual Data warehouse, migrating data to
Snowflake warehouse using SnowSQL & Snowpipe, querying Snowflake
warehouses, time-travel, Zero-copy cloning, etc
Module 12: TFS and Azure DevOps
Introduction
to TFS and Azure DevOps for project coordination, management, and version
control.
Agenda
Bootcamp summary:
- Included courses: T-SQL, Python, Tableau, Snowflake,
TFS and Azure DevOps, and more
- To be eligible, you should have:
- Intermediate understanding of database objects
(entities, attributes, constraints, relationships, joins, etc.)
- Average logic-building skills
- Ability to write basic DDL/DML/DQL (any SQL) queries
- Average technical presentation & delivery skills
- Basic exposure to any programming language (C, C++,
VB, Python, R, etc.)
- This program is available in person or online at any
learning center
- This program qualifies VA financial aid
- Take advantage of job placement support for the first year
after completing the program
- This program is eligible for CCS Learning Academy’s
Learn and Earn Program, which allows you to get up to 50% of your tuition
refunded after bootcamp completion if you are placed in a job through CCS
Global Tech
Audience
Graduates of the Data Science & Data Engineering Bootcamp get hired with the following types of job titles:
- Data Analyst
- Data Engineer
- Database Administrator
- Machine Learning Engineer
- Data Scientist
- Data Architect
- Statistician
- Business Analyst