Connecticut Information Technology Institute

The Introduction to SQL Databases course is the first step for people looking to move into a database professional role. The course describes fundamental database concepts including database types, database languages, and database designs.  This course will cover data analysis and the languages of SQL; additional focus will be on data modeling,  the concept of normalization, and relationships. Performance, including indexing and queries, as well as database objects such as tables and views will be covered.

Course Objectives:

• Describe key database concepts in the context of SQL Server
• Describe database languages used in SQL Server
• Describe data modeling techniques
• Describe normalization and denormalization techniques
• Describe relationship types and effects in database design
• Describe the effects of database design on performance
• Describe commonly used database objects

Delivery Method: Virtual Instructor-Led Training

Course Duration: 3 Days

Intended Audience: This course is for people moving into a database role or beginners looking to understand the methods and functions of databases with the intent of moving into the data analyst role.

Details: There is no certification associated with this course. It is not ETPL-approved.

Register for this Course

This course provides the solid foundational skills required for Tableau Desktop Specialist certification. It’s for anyone who works with data, regardless of analytical background.

Course Objectives:

• Connect to your data.
• Edit and save a data source.
• Understand Tableau terminology.
• Use the Tableau interface/paradigm to effectively create powerful visualizations.
• Create basic calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations.
• Build dashboards to share visualizations.
• Cross Tabs
• Pie and bar charts
• Geographic maps
• Dual-axis and combo charts with different mark types
• Heat maps
• Highlight tables
• Treemaps
• Scatter plots

Delivery Method: Virtual Instructor Led Training

Intended Audience: This is the official training course for Tableau Desktop Specialist Certification. This course is for the beginning Tableau user. You'll learn important Tableau Desktop concepts, techniques for simple and complex visualizations, and interactive dashboards in preparation for your exam. Skills are taught in two days of in-class instruction plus additional self-paced eLearning.

Register for this Course

This course is designed to expand your skills and distinguish yourself as a Tableau power user. It’s structured for those who have working experience with Tableau and want to take it to the next level. You should understand how to build basic worksheets and dashboards, but may scratch your head when working with more complex issues.

Course Objectives:

• Build advanced chart types and visualizations.
• Build complex calculations to manipulate your data.
• Use statistical techniques to analyze your data.
• Use parameters and input controls to give users control over certain values.
• Implement advanced geographic mapping techniques and use custom images and geocoding to build spatial visualizations of non-geographic data.
• Prep your data for analysis.
• Combine data sources using data blending.
• Combine data from multiple tables in the same data source using joins.
• Make your visualizations perform as well as possible using the Data Engine, extracts, and efficient connection methods.
• Build better dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Implement efficiency tips and tricks.

Delivery Method: Virtual Instructor Led Training

Intended Audience:  This course is designed to provide you with the skills required to become a Tableau power user. It’s made for the professional who has solid working experience with Tableau and wants to take it to the next level. You should have a deep understanding of all the fundamental concepts of building worksheets and dashboards but may scratch your head when working with more complex issues.

Register for this Course

This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Finally, this course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.

Course Objectives:

• Ingest, clean, and transform data
• Model data for performance and scalability
• Design and create reports for data analysis
• Apply and perform advanced report analytics
• Manage and share report assets
• Create paginated reports in Power BI

Delivery Method: Virtual Instructor Led Training, or on site at CITI's Stamford campus.

Course Duration: 4 Days

Intended Audience:  The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.

Register for this Course

This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.

Delivery Method: Virtual Instructor Led Training

Register for this Course