2013-08-10 Database Real Project Workshop Saturday 8:00 to 11:00

[USA LaoTu Support Team]

Database Real Project Workshop
Real World Project Workshop:  Saturday  8:00 to 11:00   California Time
8/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.