The objective of the course is to introduce students to database management systems, SQL and data analysis with excel.
Each course has 6 lecture hours every week; 2 hours on a weekday evening through an instructor led live webinar and 4 hours classroom lecture on a Saturday or Sunday. Only people that cannot make it to the classroom on Saturday or Sunday will be permitted to join online at those times.
Students will work with the instructor and other members of their group to agree on the weekday evening day and time that the weekday session will hold. Student will work with the instructor and other members of their group to agree on the weekend day and time that the weekend session will hold. The possible time slots are: Saturdays 10AM to 2:30PM, Saturdays 3PM to 7:30PM or Sundays 1:30PM to 6PM. A 30 minutes break is included in the aforementioned time slots.
INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS
ADVANCED SQL
- Understanding Transaction Processing, Constraints, and Indexes
- Understanding Functions, Stored Procedures, Triggers, and Cursors
ADVANCED DATA ANALYSIS WITH EXCEL
-Excel BI Tool Series
- Excel Power User Training
- Excel BI Tools: PowerPivot and Interactive Visualizations
- Excel BI Tools: DAX Formulas for Dynamic Tables
- Excel BI Tools: Get and Transform Data
- Excel BI Tools: Power BI for Excel Users
-Excel Special Topics
- Excel Forecasting and What-If Analysis
- Excel Macros
- Excel 2013/2016 Programming with VBA
"Success is no accident. It is hard work, perseverance, learning, studying, sacrifice and most of all, love of what you are doing or learning to do" Pele