{"product_id":"sql-server-database-administration","title":"SQL Server Database Administration","description":"\u003cdiv\u003e\u003cp\u003eHelp protect your organization by using the knowledge gained in this course to correctly manage business databases. With this training, you learn the essential skills for administering SQL Server databases, and gain extensive experience using SQL Server tools to perform real-world administrative tasks with SQL Server Management Studio and Transact-SQL.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eSQL Server Database Administration Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\u003cp\u003eConfigure and manage SQL Server databases\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eEnsure SQL Server security with logins, roles, users, and permissions\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eDevelop backup strategies and recover from disasters\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eLeverage SQL Server Agent to automate administrative tasks\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eIsolate and repair fragmentation and database corruption\u003c\/p\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eSQL Server Database Administration Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eImportant SQL Server Database Administration Course Information\t\u003c\/h4\u003e\n\u003cp\u003e\u003c\/p\u003e\n\u003cul class=\"accordion\"\u003e\n\u003cli\u003e\n\u003ch3\u003ePrerequisites\u003c\/h3\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eRelational database experience\u003c\/li\u003e\n\u003cli\u003eWorking knowledge of computers and a familiarity with Microsoft Windows\u003c\/li\u003e\n\u003cli\u003eSQL programming experience is helpful, but not required\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003ch3\u003eAudience Profile\u003c\/h3\u003e\n\u003cdiv\u003e\n\u003cp\u003eThis course is helpful to those who are new to SQL Server administration and who will be responsible for administering SQL Server. A basic understanding of SQL Server or experience at the level of Microsoft SQL Server Training Course is required..\u003c\/p\u003e\n\u003c\/div\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003ch3\u003eExam Information\u003c\/h3\u003e\n\u003cdiv\u003e\n\u003cp\u003eOptional Learning Tree exam is available at the end of class.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eSQL Server Database Administration Course Outline\u003c\/h4\u003e\n\u003cp\u003e\u003c\/p\u003e\n\u003cul class=\"accordion\"\u003e\n\u003cli\u003e\n\u003ch3\u003eGetting Started with SQL Server\u003c\/h3\u003e\n\u003cdiv\u003e\n\u003cp\u003eSetting up SQL Server\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSelecting installation options\u003c\/li\u003e\n\u003cli\u003eInstalling a named instance\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eLeveraging essential tools\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSQL Server Management Studio\u003c\/li\u003e\n\u003cli\u003eConfiguration Manager\u003c\/li\u003e\n\u003cli\u003eTransact-SQL\u003c\/li\u003e\n\u003cli\u003esqlcmd\u003c\/li\u003e\n\u003cli\u003ePowerShell\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003ch3\u003eConstructing and Managing Databases\u003c\/h3\u003e\n\u003cdiv\u003e\n\u003cp\u003eInspecting storage structures\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eRelating servers, databases and files\u003c\/li\u003e\n\u003cli\u003eCreating databases and transaction logs\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eDesigning file groups\u003c\/p\u003e\n\u003cp\u003eUpgrading and moving databases\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eMaximizing storage utilization\u003c\/li\u003e\n\u003cli\u003ePlacing tables on file groups\n\u003cul\u003e\n\u003cli\u003eChoosing between upgrade and migration\u003c\/li\u003e\n\u003cli\u003eDetaching and attaching databases\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003ch3\u003eControlling database space\u003c\/h3\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003ePermitting automatic database growth\u003c\/li\u003e\n\u003cli\u003eAdding database files to expand databases\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003ch3\u003eHandling Server and Database Security\u003c\/h3\u003e\n\u003cdiv\u003e\n\u003cp\u003eImplementing server security\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eComparing authentication modes\u003c\/li\u003e\n\u003cli\u003eDefining logins\u003c\/li\u003e\n\u003cli\u003eCreating user-defined server roles\u003c\/li\u003e\n\u003cli\u003eEnforcing password policy\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eGranting database access\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eContrasting users and logins\u003c\/li\u003e\n\u003cli\u003eAdding users\u003c\/li\u003e\n\u003cli\u003eDefining new roles\u003c\/li\u003e\n\u003cli\u003eDelegating privileges with predefined roles\u003c\/li\u003e\n\u003cli\u003eRepairing mis-mapped logins\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003ch3\u003eGranting and Revoking Permissions\u003c\/h3\u003e\n\u003cdiv\u003e\n\u003cp\u003eManaging database-scoped privileges\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePermitting object creation\u003c\/li\u003e\n\u003cli\u003eGiving blanket permissions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eDefining object-level permissions\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLimiting object access\u003c\/li\u003e\n\u003cli\u003eMeeting complex permission requirements with roles\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003ch3\u003eBackup and Recovery\u003c\/h3\u003e\n\u003cdiv\u003e\n\u003cp\u003eBacking up databases\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSelecting a recovery model\u003c\/li\u003e\n\u003cli\u003eInvestigating the transaction log\u003c\/li\u003e\n\u003cli\u003eRunning full, log and differential backups\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eRestoring databases\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePerforming a post-crash log backup\u003c\/li\u003e\n\u003cli\u003eRebuilding the master database\u003c\/li\u003e\n\u003cli\u003eRecovering user and system databases\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003ch3\u003eStreamlining Tasks with Jobs, Alerts and Database Mail\u003c\/h3\u003e\n\u003cdiv\u003e\n\u003cp\u003eConfiguring SQL Server Agent\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSetting agent properties\u003c\/li\u003e\n\u003cli\u003eImplementing database mail\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eDefining jobs to handle routine tasks\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCreating alerts and operators\u003c\/li\u003e\n\u003cli\u003eInitiating multi-step jobs\u003c\/li\u003e\n\u003cli\u003eAssociating alerts with jobs\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003ch3\u003eDatabase Maintenance and Monitoring\u003c\/h3\u003e\n\u003cdiv\u003e\n\u003cp\u003eHandling fragmentation and database corruption\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIdentifying and curing fragmentation\u003c\/li\u003e\n\u003cli\u003eRepairing database corruption\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eBuilding database maintenance plans\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eScheduling plan execution\u003c\/li\u003e\n\u003cli\u003eNotifying operators of success or failure\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eResolving contention problems\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIdentifying blocked processes\u003c\/li\u003e\n\u003cli\u003eKilling blockers\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"268D03US \/ 2026-08-04T09:00:00 \/ New York","offer_id":48216575639771,"sku":"US-2108-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"269A86CN \/ 2026-09-08T09:00:00 \/ Ottawa","offer_id":48216575672539,"sku":"US-2108-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26AC20US \/ 2026-10-13T09:00:00 \/ Herndon, VA","offer_id":48216575705307,"sku":"US-2108-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26BC29US \/ 2026-11-03T09:00:00 \/ Austin","offer_id":48216575869147,"sku":"US-2108-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26CB71US \/ 2026-12-08T09:00:00 \/ New York","offer_id":48216575901915,"sku":"US-2108-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"271A39CN \/ 2027-01-26T09:00:00 \/ Ottawa","offer_id":48216575934683,"sku":"US-2108-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"273C07US \/ 2027-03-09T09:00:00 \/ Herndon, VA","offer_id":48331763187931,"sku":"US-2108-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"274C17US \/ 2027-04-06T09:00:00 \/ Austin","offer_id":48567539728603,"sku":"US-2108-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"275C57US \/ 2027-05-11T09:00:00 \/ New York","offer_id":48759291642075,"sku":"US-2108-IL","price":2512.0,"currency_code":"USD","in_stock":true}],"url":"https:\/\/learningtreeinternational-dirinfosec-hhs.myshopify.com\/products\/sql-server-database-administration","provider":"Learning Tree International","version":"1.0","type":"link"}