SQL SERVER, BUSINESS INTELLIGENCE AND BIG DATA PROGRAM

PROGRAM OVERVIEW

Combining the best of traditional Database development, Business Intelligence and cutting edge technologies in Big Data, this program will provide students skillsets for different Information Technology positions, including Database Developer, Business Analyst, DWH Engineer, ETL Developer, Data Analyst and Data Engineer.

 This three-course program will cover the Database fundamentals, SQL Server Development, Data warehousing and Business Intelligence using Microsoft Business Intelligence stack, Hadoop and Spark eco-system components and Big Data Services in cloud. In each course, students will work on a project  based on real-world industry tasks and will have the opportunity to hear from several guest speakers. The program will include an interview preparation session and conclude with a Hiring Day with leading employers in the greater Seattle area.

COURSE 1: RELATIONAL DATABASE THEORY AND DESIGN USING SQL

DURATION: 32 HOURS

CLASS TIMES: WEEKENDS 8 AM TO 5 PM

NEXT START DATES: OCTOBER 15, 2016

LOCATION: 3600 136TH PL SE, BELLEVUE, WA

COST: $1095

20% OFF: $876

This hands-on focused course covers Database fundamentals, SQL Server Development, T-Sql programming, branching and conditional logic, using transactions and concurrency, Optimization and Performance Tuning. This course is a pre-requisite for the Business Intelligence course.

TOPICS INCLUDE

  • Data Modeling
  • Normalization
  • Transaction Management
  • High-Availability & Scalability Solutions
  • Maintenance
  • Security
  • Disaster Recovery
  • Optimization & Performance Tuning
  • T-SQL Programming
  • Project based on real-world industry tasks
Register

COURSE 2: BUSINESS INTELLIGENCE

DURATION: 32 HOURS

CLASS TIMES: WEEKENDS 8 AM TO 5 PM

NEXT START DATES: OCTOBER 29, 2016

LOCATION: 3600 136TH PL SE, BELLEVUE, WA

COST: $1095

20% OFF: $876

This course covers fundamentals of Data warehousing and Business Intelligence, ETL design and implementation using Sql Server Integration Services (SSIS), implementing OLAP Cubes using Sql Server Analysis Services (SSAS), implementing Reporting solutions using Sql Server Reporting Services (SRS) and Data analysis and visualization using Power BI.

TOPICS INCLUDE

  • Data warehousing and Business Intelligence Concepts
  • Dimensional Modeling
  • ETL with SSIS
  • OLAP with SSAS
  • MDX Programming
  • Reports Development using SSRS
  • Power BI development
  • Project based on real-world industry tasks
Register

COURSE 3: BIG DATA DEVELOPMENT

DURATION: 32 HOURS

CLASS TIMES: WEEKENDS 8 AM TO 5 PM

NEXT START DATES: NOVEMBER 12, 2016

LOCATION: 3600 136TH PL SE, BELLEVUE, WA

COST: $1095

20% OFF: $876

In this program, you will learn how to apply cutting-edge tools and techniques to store, transform and extract valuable insights from Big Data. You will learn to work with the Hadoop eco-system components and Spark. The carefully crafted curriculum is designed to prepare you for industry standard real-world problems.

TOPICS INCLUDE

  • Hadoop Distributed File System (HDFS) Architecture.
  • Working with Hadoop FS Shell commands
  • MapReduce Framework and Programming Model
  • Hive and HiveQL
  • Spark
  • Sqoop
  • Big Data in Cloud
  • Project based on real-world industry tasks
Register

MEET THE INSTRUCTORS


GREG HAY

Born and raised in the greater Seattle-area, Greg Hay has more than 24 years of experience working with Relational Databases. His industry experience includes positions with Microsoft, Walt Disney, WebMD and Bill and Melinda Gates Foundation among many others. Greg is an experienced educator, presently lectures at University of Washington and has successfully developed curriculum and taught numerous Database and Business Intelligence courses. He has also taught Database courses at Microsoft, University of Chicago, City University of Seattle and Bellevue College. He holds a Master’s degree in Information Management from University of Washington.

REVIN CHALIL

Revin is a Big Data Development Engineer at Expedia with extensive hands-on experience in Hadoop eco-system components and Spark. Revin’s expertise include HDFS, MapReduce, Hive, Spark, Sqoop, Big Data Services in Amazon Web Services, programming in Java and Python, Bash scripting, MongoDB, Sql Server and PostgresQL. He has more than 13 years of hands-on design and development experience in Data centered Analytical solutions and has completed entire life cycle of several Big Data projects in multi-terabyte environments. Revin’s prior work experience includes positions with Microsoft, International Game Technology and CapitalOne.