课程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. Micorsoft 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