Microsoft SQL server Business Intelligence
本课程分为四部分:
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的各种技能.
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
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的各种技能.
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