USA LaoTu 高薪转行做数据第一平台

只要你有颗求变的心并愿意行动,到这里来,必使你得改变!成千聪明华人循此捷径高薪进入大公司! => 坚定正确的转行方向 高薪捷径 视频试看 => Topic started by: USA LaoTu Support Team on December 01, 2013, 11:11:29 PM

Title: Content of Real World Database Projects Workshop
Post by: USA LaoTu Support Team 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. (http://student.usalaotu.com/make_payment.php)
Title: Re: Content of Real World Dataase Projects Workshop
Post by: 找工作 on May 16, 2014, 08:24:04 AM
题目打错了。 database 写错了。
Title: Re: Content of Real World Database Projects Workshop
Post by: USA LaoTu Support Team on May 16, 2014, 08:35:58 AM
Fixed.
You are the best!