课程1. Microsoft SQL Server Database Administrator (MSSQL DBA)
本课程包括47章：
每个chapter约半小时至一小时,内容翔实,讲解清晰明了,只要你有颗上进的心,付出行动，跟着老师的视频step by step地学习,反复练习,数月之内,让你从零基础到完全掌握Microsoft Server DBA的各种技能.
职业方向： SQL Server DBA; SQL Server Developer; SQL Server Engineer
雇主类型： 银行业; 保险行业；电信行业；石油化工；生物医疗行业；电子工程行业； 信息技术行业, 等等
Microsoft SQL Server DBA课程大纲
Chapter 1：SQL Server Overview/Installation
Chapter 2：SQL Server Tools
Chapter 3 : Introducing System Database
Chapter 4：Create a database
Chapter 5：Basic T-SQL Query
Chapter 6：SQL Server Data types
Chapter 7：Constraints
Chapter 8：Create Table/Views
Chapter 9：Design ER-Diagram
Chapter 10：Create Stored Procedures/UDF
Chapter 11：Create Triggers/Cursor
Chapter 12：Using System functions
Chapter 13：Security Management
Chapter 14：Database Backup and Recovery
Chapter 15：Performance Monitor
Chapter 16：SQL Profiler
Chapter 17：Monitoring Locks
Chapter 18：Using Index
Chapter 19：T-SQL Optimization
Chapter 20：Jobs/Operators/Alerts
Chapter 21：Windows Scheduled Task
Chapter 22：SQL Server Logs/Event Viewer
Chapter 23：Database Mail
Chapter 24：Common management Commands
Chapter 25 : Common windows commands
Chapter 26: Advanced T-SQL Query
Chapter 27: Virtual Domain Controller Using VMWare
Chapter 28: Database Mirroring
Chapter 29: Database Replication
Chapter 30: Log Shipping
Chapter 31: Failover Cluster
Chapter 32: Transactions
Chapter 33: Create Linked Server
Chapter 34: Table Partition
Chapter 35: Full-text Search
Chapter 36: Cloud: AWS SQL Server
Chapter 37: SQL Server 2012 New Features
Chapter 38: BI-SSAS-Concepts
Chapter 39: BI-SSAS-Build Cube
Chapter 40: BI-SSRS-Concepts
Chapter 41: BI-SSRS-Build a Report
Chapter 42: BI-SSIS-Concepts
Chapter 43: BI-SSIS-Build a Package
Chapter 44: Linux_Centos
Chapter 45: Open Source RDBMS: MySQL
Chapter 46: SQL Server Monitor Tools: Zabbix and Solarwinds
Chapter 47: SQL Server 2012 Always On
Chapter 48: Introduce Oracle 12C
Chapter 49: Introduce MongoDB
Chapter 1：SQL Server Overview/Installation
Chapter 2：SQL Server Tools
Chapter 3 : Introducing System Database
Chapter 4：Create a database
Chapter 5：Basic T-SQL Query
Chapter 6：SQL Server Data types
Chapter 7：Constraints
Chapter 8：Create Table/Views
Chapter 9：Design ER-Diagram
Chapter 10：Create Stored Procedures/UDF
Chapter 11：Create Triggers/Cursor
Chapter 12：Using System functions
Chapter 13：Security Management
Chapter 14：Database Backup and Recovery
Chapter 15：Performance Monitor
Chapter 16：SQL Profiler
Chapter 17：Monitoring Locks
Chapter 18：Using Index
Chapter 19：T-SQL Optimization
Chapter 20：Jobs/Operators/Alerts
Chapter 21：Windows Scheduled Task
Chapter 22：SQL Server Logs/Event Viewer
Chapter 23：Database Mail
Chapter 24：Common management Commands
Chapter 25 : Common windows commands
Chapter 26: Advanced T-SQL Query
Chapter 27: Virtual Domain Controller Using VMWare
Chapter 28: Database Mirroring
Chapter 29: Database Replication
Chapter 30: Log Shipping
Chapter 31: Failover Cluster
Chapter 32: Transactions
Chapter 33: Create Linked Server
Chapter 34: Table Partition
Chapter 35: Full-text Search
Chapter 36: Cloud: AWS SQL Server
Chapter 37: SQL Server 2012 New Features
Chapter 38: BI-SSAS-Concepts
Chapter 39: BI-SSAS-Build Cube
Chapter 40: BI-SSRS-Concepts
Chapter 41: BI-SSRS-Build a Report
Chapter 42: BI-SSIS-Concepts
Chapter 43: BI-SSIS-Build a Package
Chapter 44: Linux_Centos
Chapter 45: Open Source RDBMS: MySQL
Chapter 46: SQL Server Monitor Tools: Zabbix and Solarwinds
Chapter 47: SQL Server 2012 Always On
Chapter 48: Introduce Oracle 12C
Chapter 49: Introduce MongoDB
课程2. Ｍicorsoft SQL Server Business Intelligence (MSBI)
本课程分为四部分：
Part 1: Fundamental SQL Server and TSQL
Part 2: SSRS (SQL Server Reporting Services)
Part 3: SSIS (SQL Server Integration Services)
Part 4: SSAS (SQL Server Analysis Services)
每 个chapter约半小时至一小时,内容翔实,讲解清晰明了,只要你有颗上进的心,付出行动,跟着老师的视频step by step地学习,反复练习,数月之内,让你从零基础到完全掌握Microsoft Server Business Intelligence 的各种技能.
职业方向: SQL Server Developer; BI Developer; Report Developer; Data Analyst; ETL Engineer
雇主类型： 银行业; 保险行业；电信行业；石油化工；生物医疗行业；电子工程行业； 信息技术行业， 等等
MSBI课程大纲
Part 1: Fundamental SQL Server and TSQL
Chapter 1: SQL Server Overview/Installation
Chapter 2: SQL Server Tools
Chapter 3: Introducing System Database
Chapter 4: Create a database
Chapter 5: Basic T-SQL Query
Chapter 6: SQL Server Data types
Chapter 7: Constraints
Chapter 8: Create Table/Views
Chapter 9: Design ER-Diagram
Chapter 10: Create Stored Procedures/UDF
Chapter 11: Create Triggers/Cursor
Chapter 12: Using System functions
Chapter 13: Security Management
Chapter 14: Database Backup and Recovery
Chapter 15：Performance Monitor
Chapter 16：SQL Profiler
Chapter 17：Monitoring Locks
Chapter 18：Using Index
Chapter 19：T-SQL Optimization
Chapter 20：Jobs/Operators/Alerts
Chapter 21：Windows Scheduled Task
Chapter 22：SQL Server Logs/Event Viewer
Chapter 23: Common windows commands
Chapter 24: Advanced T-SQL Query
Part 2: SSRS (SQL Server Reporting Services)
Chapter 1: SSRS Introduction
Chapter 2: Build table reports and Map Reports
Chapter 3: Build Matrix Reports
Chapter 4: Build Parameterized report
Chapter 5: Build Dashboard Report and Drill through Report
Chapter 6: Creating A Report Template
Chapter 7: Build a Complicated Report--Employee Sales Report
Chapter 8: Move Reports From One Server to Another Server
Chapter 9: SSRS Tip01--Format Report and Control Row Number On one Page
Chapter 10: SSRS Tip02--Control Row Headers and Calculated Fields
Chapter 11: SSRS Tip03--Indicators and Gauges
Chapter 12: Master Reporting Services Configuration Manager
Chapter 13: Create Report Subscription
Chapter 14: Power BI Introduction
Chapter 15: Create Data-Driven Subscriptions
Chapter 16: Use Oracle as Data Source
Part 3: SSIS (SQL Server Integration Services)
Chapter 1: SSIS Introduction
Chapter 2: Export Data From SQL Server to CSV File
Chapter 3: Create A ETL Package
Chapter 4: Introduce Containers
Chapter 5: Introduce Common Control Tasks
Chapter 6: Introduce Data Flow Tasks
Chapter 7: Deploy and Execute SSIS Packages
Chapter 8: Debugging SSIS Packages
Chapter 9: Event Handling and Logging
Chapter 10: Load Data Into Data Warehouse
Part 4: SSAS (SQL Server Analysis Services)
Chapter 1: Introduce SSAS
Chapter 2: Configure Data Source and Data Source View
Chapter 3: Build a cube using wizard
Chapter 4: Create Multidimensional Analysis Solutions
Chapter 5: Cubes and Dimensions
Chapter 6: Measures and Measure Groups
Chapter 7: Build a SSAS Database
Chapter 8: Use MDX (multidimensional expressions)
Chapter 9: Introduce Data Mining
Chapter 10: More Samples
Part 1: Fundamental SQL Server and TSQL
Chapter 1: SQL Server Overview/Installation
Chapter 2: SQL Server Tools
Chapter 3: Introducing System Database
Chapter 4: Create a database
Chapter 5: Basic T-SQL Query
Chapter 6: SQL Server Data types
Chapter 7: Constraints
Chapter 8: Create Table/Views
Chapter 9: Design ER-Diagram
Chapter 10: Create Stored Procedures/UDF
Chapter 11: Create Triggers/Cursor
Chapter 12: Using System functions
Chapter 13: Security Management
Chapter 14: Database Backup and Recovery
Chapter 15：Performance Monitor
Chapter 16：SQL Profiler
Chapter 17：Monitoring Locks
Chapter 18：Using Index
Chapter 19：T-SQL Optimization
Chapter 20：Jobs/Operators/Alerts
Chapter 21：Windows Scheduled Task
Chapter 22：SQL Server Logs/Event Viewer
Chapter 23: Common windows commands
Chapter 24: Advanced T-SQL Query
Part 2: SSRS (SQL Server Reporting Services)
Chapter 1: SSRS Introduction
Chapter 2: Build table reports and Map Reports
Chapter 3: Build Matrix Reports
Chapter 4: Build Parameterized report
Chapter 5: Build Dashboard Report and Drill through Report
Chapter 6: Creating A Report Template
Chapter 7: Build a Complicated Report--Employee Sales Report
Chapter 8: Move Reports From One Server to Another Server
Chapter 9: SSRS Tip01--Format Report and Control Row Number On one Page
Chapter 10: SSRS Tip02--Control Row Headers and Calculated Fields
Chapter 11: SSRS Tip03--Indicators and Gauges
Chapter 12: Master Reporting Services Configuration Manager
Chapter 13: Create Report Subscription
Chapter 14: Power BI Introduction
Chapter 15: Create Data-Driven Subscriptions
Chapter 16: Use Oracle as Data Source
Part 3: SSIS (SQL Server Integration Services)
Chapter 1: SSIS Introduction
Chapter 2: Export Data From SQL Server to CSV File
Chapter 3: Create A ETL Package
Chapter 4: Introduce Containers
Chapter 5: Introduce Common Control Tasks
Chapter 6: Introduce Data Flow Tasks
Chapter 7: Deploy and Execute SSIS Packages
Chapter 8: Debugging SSIS Packages
Chapter 9: Event Handling and Logging
Chapter 10: Load Data Into Data Warehouse
Part 4: SSAS (SQL Server Analysis Services)
Chapter 1: Introduce SSAS
Chapter 2: Configure Data Source and Data Source View
Chapter 3: Build a cube using wizard
Chapter 4: Create Multidimensional Analysis Solutions
Chapter 5: Cubes and Dimensions
Chapter 6: Measures and Measure Groups
Chapter 7: Build a SSAS Database
Chapter 8: Use MDX (multidimensional expressions)
Chapter 9: Introduce Data Mining
Chapter 10: More Samples