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: anunderlyingorganizationalpatternorstruc ture.

• Integration with reporting, BI, and analytic tools • Integration of R procedures into DB stored procedures • The ability to cluster multiple DBMSs • And still more depending on the version and brand of the DBMS Since this is a basic course in SQL Server, these topics are not covered.

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