Microsoft SQL Server DBA
本课程包括47章:
每个chapter约半小时至一小时,内容翔实,讲解清晰明了,只要你有颗上进的心,付出行动,跟着老师的视频step by step地学习,反复练习,数月之内 让你从零基础到完全掌握Microsoft 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
本课程包括47章:
每个chapter约半小时至一小时,内容翔实,讲解清晰明了,只要你有颗上进的心,付出行动,跟着老师的视频step by step地学习,反复练习,数月之内 让你从零基础到完全掌握Microsoft 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