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
- Introduction to Database Concepts and Architecture
- Database Concepts and Architecture
- Data Modeling using Entity Relationship Diagrams
- The Relational Data Model
- Test 1
- The Relational Algebra
- SQL The Relational Database Standard
- Test 2
- Practical Experience with a Relational DBMS Providing SQL
- Normalization as a Process for Verification of Data Model Design
- SQL Interaction with Programming Interfaces
- Desktop Database Packages
INTRODUCTION TO SQL
- Filtering and Retrieving Data
- Sorting and Filtering Data
- Calculated Fields and Functions
- Summarizing and Grouping Data
- Working with Subqueries
- Creating and Using Table Joins
- Inserting, Updating, and Deleting Data
- Table Creation and Maintenance
- Creating and Understanding Views
INTRODUCTION TO DATA ANALYSIS WITH EXCEL
- Excel 2016 Introduction
- Excel 2016 Charts, Formatting and Reporting
- Excel 2016 Database Features and PivotTables
- Excel 2016 Workbooks, Formulas and Functions
- Excel Tips, Tricks Keyboard Shortcuts and Timesavers
- Excel 2016 Introduction to Macros
"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