Introduction to SQL Server Database Administration

← Back to document page

Introduction to SQL Server Database AdministrationTribal Data WorkshopApril 10 11, 2018CRITFCPortland, OregonAgenda Exactly what is a DBMS? Security Management Introducing SQL Server Manager System (SSMS) Administrative TasksoAdding a new useroChanging a passwordoRe-enabling a locked out accountoGranting/Denying Access to a DBoGranting/Denying Access to a TableoCreating a New DatabaseoDeleting a DatabaseoCreating a TableoQuick Tutorial on Data TypesoDeleting a TableoSetting the Primary KeyoBacking Up the DatabaseoRestoring a Full BackupoDatabase Indexes TutorialoData EncryptionBuckle Your SeatbeltWe have a lot to cover in a relatively short timeframe Relational databases form the bedrock of western civilization - Bruce Lindsay, IBM ResearchStanford University: CS145 materialsA Little VocabularySchema.

• Tools for performance analysis, tuning, report generation, and trouble shooting • The ability deploy high availability configurations of the DBs • The ability to do data mirroring ... Since this is a basic course in SQL Server, these topics are not covered. Security Management: User, …

  Administration, Database, Introduction, Report, Server, Sql server, Introduction to sql server database administration