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

只要你有颗求变的心并愿意行动，到这里来，必使你得改变！成千聪明华人循此捷径高薪进入大公司！ => 注重实战的教学作风 新开课程 时间内容 => Topic started by: USA LaoTu Support Team on March 13, 2017, 10:43:26 AM

Title: C# Fundamentals for MSBI 第一期 16:00-19:00 Sat, 04/29/17 to 6/17/17
Post by: USA LaoTu Support Team on March 13, 2017, 10:43:26 AM

C# Fundamentals for MSBI  第一期  16:00-19:00  Sat, 04/29/17 to 6/10/17
Total 7 * 3hr = 21 hours

USALaoTu 始终瞄准市场急需高薪数据分析师工作为中心，培养学生能做会说两个基本点，专家真人授课，讲解实际数据分析工作项目，经验和绝招，把美加欧澳成千聪明求变爱家男女高薪送进大公司。

应广大同学们在求职和工作中的要求，USALaoTu特邀请北美MSBI领域高级专家，MSBI2012课程讲师 Dr. 新 隆重开出新课 C# Fundamentals for MSBI  第一期。

北美在职MSBI专家教授业界实战实用傲人技术，高薪转行利器。

找到工作的同学们都说：”MSBI 是找工作的敲门砖“，这个 C# for MSBI 课 是任何一个想转行做MSBI 和正在做MSBI的人都不能错过的，把你的MSBI ETL 技术带到更高级的好课。

I. C# Basics for Beginners
 1. IDE (Integrated Development Environment) for this class
    --If you are SSIS2014 students, that is enough for this class.
   
 2. Introduction to C# and .NET Framework     
   001 Brief Introduction: History
   002 C# vs .NET
   003 What is CLR
   004 Architecture of .NET Applications
   005 Our First C# Application - Demo
   
 2. Primitive Types and Expressions
   006 Variables and Constants - Demo
   007 Overflowing
   008 Scope
   009 Type Conversion - Demo
   010 Operators - Demo
   011 Comments
 
 3. Non-Primitive Types
   012 Class - Demo
   013 Structs - Demo
   014 Arrays - Demo
   015 String - Demo
   016 Enum - Demo
   017 Reference Types and Value Types - Demo
 
 4. Control Flow
   018 Conditional Statements 
   019 Demo IfElse and SwitchCase
   020 Iteration Statements(For Loops, Foreach Loops, While Loops, Do ...While)
   021 Random Class
 
 5. Arrays and Lists
   022 Arrays - Demo
   023 Lists - Demo
 
 6. Working with Dates
   024 DateTime
   025 TimeSpan
 
 7. Working with Text
   026 String - Demo
   027 A simple case to Code with Text
   028 StringBuilder - Demo
   029 Procedural Programming
   
 8. Working with Files
   030 System.IO Namespace
   031 File and FileInfo - Demo
   032 Directory and DirectoryInfo - Demo
   033 Path - Demo
   034 File Existing?, Create, Copy and Remove
   
 9. Debugging Applications
    034 Debugging Tools in Visual Studio
 
II. Application of C# Scripts in SSIS and SSRS
  -- Real Projects (how to work with data from Web, Databases and text files and excel spreadsheet, data cleasing etc.)

Title: Re: C# Fundamentals for MSBI 第一期 16:00-19:00 Sat, 04/29/17 to 6/17/17
Post by: newleaf on April 06, 2017, 02:46:57 PM

For the class "C# for MSBI" real projects, will cover:
1. How to load structured and unstructured flat files (txt and csv etc.)
2. How to modify Excel (Spreadsheet) contents through C#
3. C#.NET for SQL CLR Stored Procedure and Functions
4. How to generate XML format reports
5. How to read/write XML files or datasets from web
6. How to extract data from web sites
    (1) Download data form website through FTP sites and URL directly
    (2) Download and upload data from/to SharePoint Site List through
        a. SharePoint SiteList Source and Destination Adapter
        b. Web Services with Windows Authentication using pagination parameters (with row limit 5000)
            i) less than 5000 approach
            ii) how to get greater than 5000 rows with row limit 5000.
        c. Client-side Object Model (CSOM)
    (3) How to extract(parse or screen scraping) website page contents and directly load into database tables through htmlagiltypack and .NET DataSets(DataTable);
    (4) How to parse/deserialize json files or json data from website and load data into database tables through Json.NET -NewtonSoft.JSON, Newtonsoft.Json.Linq and Regex etc;
7. How to use Regular expression to clean the dirty data using Replace function, StreamReder/StreamWriter to read/rewrite data files for data loading.

In the meantime,Regular Expression(Regex), XML, HTML and JSON file format and syntax, and basic Linq(syntax and methods-lambda expression, Linq to XML, Database, JSON), .NET connected to variable relation databases will be introduced.

Title: Re: C# Fundamentals for MSBI 第一期 16:00-19:00 Sat, 04/29/17 to 6/17/17
Post by: USA LaoTu Support Team on April 16, 2017, 10:56:23 AM

This C# Fundamentals for MSBI  第一期  meets 7 times.

Sat, Apr 29, 2017 4:00 PM - 7:00 PM PDT
Sat, May 6, 2017 4:00 PM - 7:00 PM PDT
Sat, May 13, 2017 4:00 PM - 7:00 PM PDT
Sat, May 20, 2017 4:00 PM - 7:00 PM PDT
Sat, Jun 3, 2017 4:00 PM - 7:00 PM PDT
Sat, Jun 10, 2017 4:00 PM - 7:00 PM PDT
Sat, Jun 17, 2017 4:00 PM - 7:00 PM PDT

Title: Re: C# Fundamentals for MSBI 第一期 16:00-19:00 Sat, 04/29/17 to 6/17/17
Post by: USA LaoTu Support Team on April 23, 2017, 07:57:06 PM

直播回放: USALaoTu 343次专业求职辅导周会：
-- 同学求职问答；
-- 祝贺婕喜同学下周开始上班！怎样做才能送出简历后每天收到十几封邮件；
-- C# for MSBI 老师介绍倾心之作课程内容；
-- 咱国生化博士转行五年在金融, 健保领域做MSBI的老同学经验谈。
 (https://youtu.be/63tGVS2m5T4)

Title: Re: C# Fundamentals for MSBI 第一期 16:00-19:00 Sat, 04/29/17 to 6/17/17
Post by: Frankc on April 27, 2017, 10:01:50 PM

For people who have not learned MSBI, SQL, and SSIS, what is the minimum requirement to take the couse?

Title: Re: C# Fundamentals for MSBI 第一期 16:00-19:00 Sat, 04/29/17 to 6/17/17
Post by: USA LaoTu Support Team on April 28, 2017, 10:33:38 PM

You will always get useful knowledge from the class, like HTML, web page etc.
All the software installation questions will be addressed in class.

Title: Re: C# Fundamentals for MSBI 第一期 16:00-19:00 Sat, 04/29/17 to 6/17/17
Post by: newleaf on June 11, 2017, 08:15:35 PM

All covered Contents are included now.