Office Software - Excel Software - Microsoft Software - QuickBooks Software - Visual Software - Comptuer Software - Web Software - Sharepoint Software - Photoshop Software - Mac Software - QuarkXPress Software - management Software - Project Software - Learn Software - email Software - Network Software - Linux Software - Unix Software - Work Software - Net Software - ASP Software - PHP Software - HTML Software - CMS Software - XML Software - Mobile Software -
Software PC Instruction Software Programming Instruction Tutoring Laptop Lessons Learning Graphics Support Support IT Advice Tutoring Design Instruction Help Webmaster Advice
Microsoft SQL Server 2005 Administration |
| Product Description : |
Microsoft SQL Server 2005 AdministrationWelcome/IntroductionIntroductionSQL Server Overview SQL Server History Course Objeectives Transact SQL Course Overview SQL Server Mystique Installing SQL Server 2005SQL Server 2005 EditionsPreparing To Install SQL Server 2005 Hardware Requirements Working With Previous Versions SQL Server 2005 Installation Installing SQL Server 2005 Pt.1 Installing SQL Server 2005 Pt.2 Changing & Deleting SQL Server Default & Named Instances Getting Assistance Administrative ToolsManagement Studio OverviewRegistering Servers Object Explorer Executing TSQL Queries Management Studio Solutions Server Configuration Manager SQLCMD SQLCMD Variables Dedicated Administrator Connection SQL Server SecuritySecuring SQL Server 2005Authentication Modes Pt.1 Authentication Modes Pt.2 Principles Permissions Securables Managing Logins Managing Users Schemas Managing Schemas Managing Permissions Managing Server Permissions Managing Database Permissions TSQL Permissions System DatabasesSystem DatabasesSystem Database Concerns Sample Database DatabasesCreating A Database Pt.1Creating A Database Pt.2 Database Properties & Options Generating Scripts Shrinking Database Files Creating Tables Pt.1 Creating Tables Pt.2 Datatypes Pt.1 Datatypes Pt.2 Primary & Foreign Keys Diagrams Transaction LogsHow Transaction Logs WorkTransactions Explained Explicit & Implicit Transactions Location, Location, Location Advantages Of Using Transactions Logs Transaction Log Options Data StorageHow SQL Server Stores DataFillfactor DBCC Showcontig SQL ProfilerProfilerUsing SQL Profiler Part1 Using SQL Profiler Part2 Automating SQL ServerAutomation OverviewSQL Server Agent Service Creating Operators Creating Jobs Pt.1 Creating Jobs Pt.2 Creating Alerts Alert Considerations Database BackupsBackup StrategyDatabase Recovery Models Which Files and When Performing A Backup SQL Backup Statement Transaction Log Backups Backup Types Restoring DataSQL Server Recovery ProcessRestoring A Database The Restore Statement High AvailabilitySQL Server High AvailabilityClustering Standby Servers Log Shipping Database Mirroring Database MaintenanceMemory Management BasicsMaintenance Plan Creation Course Wrap-UpCourse Wrap-UpCreditsAbout The Author |







