Author Topic: Content of Real World Database Projects Workshop  (Read 8038 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 3880
  • Karma: +35/-11
Content of Real World Database Projects Workshop
« on: December 01, 2013, 11:11:29 PM »
Real World Project Workshop: Video Record Course

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 Reports
         Many techniques to create different kinds of cool Crystal  Reports.
         Formula, Parameter Reports, Sub Reports, Report Alert, Version Control,
         Lots of 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
Click here to make payment with Credit Card.

找工作

  • MSBI2012 Part1 SSIS ETL
  • Jr. Member
  • *
  • Posts: 69
  • Karma: +2/-0
Re: Content of Real World Dataase Projects Workshop
« Reply #1 on: May 16, 2014, 08:24:04 AM »
题目打错了。 database 写错了。

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 3880
  • Karma: +35/-11
Re: Content of Real World Database Projects Workshop
« Reply #2 on: May 16, 2014, 08:35:58 AM »
Fixed.
You are the best!