My mission is to help students ​and adults achieve a data ​engineering and intelligence ​career.

Data Engineering and Intelligence Courses

• I work directly with students in each course using a Zoom session.
• Lessons may be scheduled at convenient times for the student.
  

Introduction to Python Programming

• Setting up the Python development ​environment.
• Learning and coding strings and ​number variables in Python.
  
• Python conditional logic, functions ​and loops.
  
• Coding and debugging Python ​programs.
  
• Python dictionaries and tuples.
  
• Object oriented programming in ​Python.
  
• Reading and writing external files in ​Python.
  
• Using PIP to install Python packages.
  

10 One Hour Lessons

Course Price: $1295

Students may be Eligible for 20% ​Discount

Database Design & Implementation

• Relational Database Concepts & ​Terminology.
• Database Schemas Concepts & ​Terminology.
• OLTP & OLAP Databases
• Database Modeling and ​Normalization .
• Installing MySQL and/or SQL Server.
• Working with the Database’s Visual ​Design Interface.
• Building the Case Study’s Database ​Schemas, Indexes and Relationships

10 One Hour Lessons

Course Price: $1295

Students may be Eligible for 20% ​Discount

SQL Concepts and Programming*

• Introduction to Structured Query ​Language (SQL).
• SQL Statements and Operators
• Installing MySQL or SQL Server.
• Loading the Course Data
• Working with the Database’s Visual ​Design Interface.
• SQL Clauses and Aggregate Functions.
• SQL for Data Management.
• Introduction to Stored Procedures
• Writing Complex Queries including ​SubQueries.

10 One Hour Lessons

Course Price: $1295

Students may be Eligible for 20% Discount

*Students should have working knowledge of MySQL or ​SQL Server database systems.

Building a Database Warehouse Data ​Pipeline using SQL Server, SQL Server ​Systems Integration Services (SSIS) and ​Visual Studio*

• Introduction to Data Integration and ETL.
• Introduction to SQL Server Integration ​Services (SSIS).
• Installing and Using Visual Studio 2022.
• Installing SQL Server.
• Loading the Course Source Data and ​Database.
• Review of the Course’s Source Data, Database ​and SSIS Project.
• Creating and Re-Engineering the SSIS Project.

10 One Hour Lessons

Course Price: $1295

Students may be Eligible for 20% Discount

*Students should have working knowledge of SQL ​Server database system and SQL programming.

Building a Data Intelligence Solution ​using SQL Server, SSIS and Power BI*

• Course: Building a Database ​Warehouse Data Pipeline.
• Learn the key features of the Microsoft ​Power BI data visualization and ​analysis application.
• Review the case-study Power BI ​reports for the Colorado Covid ​solution.
• Re-engineer the Power BI reports and ​visuals for the Colorado Covid ​Solution.
• Integrate Python scripts into the ​reports for data analysis.

20 One Hour Lessons

Course Price: $1795

Students may be Eligible for 20% Discount

*Students should first take my course: Building a ​Database Warehouse Data Pipeline

About Instructor B Robert Carmel:

Imore than 25 years of experience working in Information Technology as a senior software and ​data engineer, solutions architect and technical trainer. Led multi-national projects with ​several Fortune 500 companies in the USA:

I am an excellent teacher and mentor. I have the patience and dedication to ​support new students who take on difficult challenges.