Database Real Project Workshop
Real World Project Workshop:
Saturday 8:00 to 11:00 California Time8/10 (3 Hours) Rongrong -- PL/SQL
Clinical Patient Data Processing using cursor and database link.
8/17 No class
8/24 (3 hours) Xiaowen / Lily -- SQL -T-SQL/ Cursor
Project 1: Use BCP extract data from database with column header
Project 2: T-SQL Procedure
Project 3: How to load more than 1000 excel files into database, VBA Micro, DOS Scripts, SQL, T-SQL Scripts
Project 4: Real World Order Validation Project T-SQL Procedure
8/31 (3 Hours) Joe -- Crystal Report
Many techniques to create different kinds of cool Crystal Reports.
Formula, Parameter Reports, Sub Reports, Report Alert,
Lots of experience and tips, etc.
9/07 (4 Hours) Wei / Lisa -- ETL
Use SQL code, Write ETL process. Based on a consulting project. more than 20 yrs experience.
Contains core part skills of ETL. Can be used for any industry.
How to process Data Warehouse Dimension table data type 2 data.
Please do not share the source code. Copy Right material. Real world experience.
How to use the script component and stored procedure in ETL package
9/14 (4 Hours) Catherine / Renee -- SSRS
Real world SSRS projects, matrix, parameter reports;
How to add different charts on reports;
Real world projects of Convert Crystal Reports to SSRS reports;
T-SQL Store Procedure with cursor for reporting;
Pivot query, use sql pivot query for generating report.
Registration Price:
General Public: $ 1100
Core Package Student: $799
Register Course: Click here register this live online class.