Author Topic: C# Fundamentals for MSBI 第一期 16:00-19:00 Sat, 04/29/17 to 6/17/17  (Read 12518 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 3974
  • Karma: +35/-11
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.)

newleaf

  • Core Package
  • Hero Member
  • *
  • Posts: 715
  • Karma: +5/-0
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.
--Success is not final; failure is not fatal. It's the courage to continue that counts. (--Winston Churchill)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 3974
  • Karma: +35/-11
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


Frankc

  • Core Package
  • Newbie
  • *
  • Posts: 5
  • Karma: +0/-0
For people who have not learned MSBI, SQL, and SSIS, what is the minimum requirement to take the couse?



USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 3974
  • Karma: +35/-11
You will always get useful knowledge from the class, like HTML, web page etc.
All the software installation questions will be addressed in class.

newleaf

  • Core Package
  • Hero Member
  • *
  • Posts: 715
  • Karma: +5/-0
All covered Contents are included now.
--Success is not final; failure is not fatal. It's the courage to continue that counts. (--Winston Churchill)