Microsoft SQL Server 2005 Administration
文章类别:
- 24 10 月, 2022
- 0 条评论
你必须注册后才能投票!
快捷索引
转自:TLF
介质:CD-ROM
数量:1CD
主页:http://www.vtc.com/modules/products/titleDetails.php?sku=33682
SQL Server 2005 是 Microsoft的企业数据库解决方案产品的最新版本。SQL Server 2005 是最近5年来网罗管理员和开发者建议和希望来研究和开发的结果。 Microsoft 继续引领数据库市场。 Microsoft Certified Database Adminis trator and Certified Trainer Mark Long 概述了SQL Server 2005 管理的基础知识。
引用(包含内容)
Welcome/Introduction
Introduction (02:08)
SQL Server Overview (03:24)
SQL Server History (04:46)
Course Objeectives (01:56)
Transact SQL (03:58)
Course Overview (03:52)
SQL Server Mystique (02:51)
Installing SQL Server 2005
SQL Server 2005 Editions (04:27)
Preparing To Install SQL Server 2005 (03:25)
Hardware Requirements (04:27)
Working With Previous Versions (04:10)
SQL Server 2005 Installation (02:19)
Installing SQL Server 2005 Pt.1 (05:09)
Installing SQL Server 2005 Pt.2 (03:40)
Changing & Deleting SQL Server (02:52)
Default & Named Instances (05:13)
Getting Assistance (05:20)
Administrative Tools
Management Studio Overview (04:41)
Registering Servers (03:46)
Object Explorer (03:21)
Executing TSQL Queries (03:00)
Management Studio Solutions (04:12)
Server Configuration Manager (02:59)
SQLCMD (02:35)
SQLCMD Variables (04:03)
Dedicated Administrator Connection (03:25)
SQL Server Security
Securing SQL Server 2005 (03:05)
Authentication Modes Pt.1 (04:30)
Authentication Modes Pt.2 (04:43)
Principles (03:10)
Permissions (03:31)
Securables (02:45)
Managing Logins (05:05)
Managing Users (03:24)
Schemas (03:33)
Managing Schemas (04:07)
Managing Permissions (04:15)
Managing Server Permissions (02:37)
Managing Database Permissions (02:23)
TSQL Permissions (01:28)
System Databases
System Databases (06:00)
System Database Concerns (02:29)
Sample Database (04:05)
Databases
Creating A Database Pt.1 (04:41)
Creating A Database Pt.2 (03:05)
Database Properties & Options (05:27)
Generating Scripts (05:06)
Shrinking Database Files (04:31)
Creating Tables Pt.1 (05:48)
Creating Tables Pt.2 (03:03)
Datatypes Pt.1 (05:20)
Datatypes Pt.2 (05:51)
Primary & Foreign Keys (04:10)
Diagrams (05:44)
Transaction Logs
How Transaction Logs Work (03:45)
Transactions Explained (05:14)
Explicit & Implicit Transactions (05:28)
Location, Location, Location (03:27)
Advantages Of Using Transactions Logs (03:40)
Transaction Log Options (04:45)
Data Storage
How SQL Server Stores Data (05:03)
Fillfactor (05:12)
DBCC Showcontig (06:05)
SQL Profiler
Profiler (04:06)
Using SQL Profiler Part1 (04:24)
Using SQL Profiler Part2 (05:08)
Automating SQL Server
Automation Overview (04:34)
SQL Server Agent Service (02:57)
Creating Operators (03:22)
Creating Jobs Pt.1 (05:33)
Creating Jobs Pt.2 (05:45)
Creating Alerts (06:05)
Alert Considerations (03:57)
Database Backups
Backup Strategy (03:35)
Database Recovery Models (05:48)
Which Files and When (02:41)
Performing A Backup (03:47)
SQL Backup Statement (03:36)
Transaction Log Backups (02:45)
Backup Types (05:39)
Restoring Data
SQL Server Recovery Process (04:46)
Restoring A Database (03:13)
The Restore Statement (03:29)
High Availability
SQL Server High Availability (02:53)
Clustering (02:21)
Standby Servers (05:13)
Log Shipping (05:58)
Database Mirroring (03:08)
Database Maintenance
Memory Management Basics (04:37)
Maintenance Plan Creation (06:14)
Course Wrap-Up
Course Wrap-Up (02:41)
Credits
About The Author (01:48)
会员福利
同类文章
文章类别:
本文链接: https://www.books51.com/157354.html
【点击下方链接,复制 & 分享文章网址】
Microsoft SQL Server 2005 Administration → https://www.books51.com/157354.html |
上一篇: 数据库修复工具
你必须注册后才能投票!
最新评论