This course is designed for anyone who wants to quickly become a proficient user of SQL Server, especially the tools integrated into SQL Server Management Studio (SSMS).

Perform a core set of job-related tasks, with a focus on the tools of SSMS. Topics covered include automatically generating queries for most actions that can be accomplished using the tools in SSMS; setting up a remote connection; managing security permissions; monitoring transactions and transaction locking; creating and moving a database; controlling the operation of services in SQL Server; and creating, scheduling and monitoring jobs.

Created to support the development of practical skills, this course can help prepare students to participate in on-the-job training (OJT).

• Basic Relational Database Essentials or familiarity with a database product or equivalent knowledge

Perform basic tasks using the Object Explorer window in SQL Server Management Studio (SSMS).

• Generate scripts using the automatic scripting feature to create, alter and drop objects on SQL Server
• Manipulate data in a SQL Server table
• Alter properties of a database on SQL Server
• Create a database diagram
• Set up a remote connection to another SQL Server to perform tasks

Manage security permissions on databases.

• Manage logins by creating, altering and dropping logins
• Manage login permissions by granting, denying and revoking permissions

Create an explicit transaction that blocks out another explicit transaction with an exclusive lock.

• Create a shared lock on a table
• Create an exclusive lock on a table
• Use the Activity Monitor to determine which currently running process is blocked by another running process

Manipulate the files of a database using the features of SQL Server.

• Create a database with multiple data files, specifying the location where they are to be stored
• Move database files to a different location on the hard drive

Manage the operation of SQL Server services using tools inside and outside of SQL Server.

• Manage SQL Server services using the SQL Server Configuration Manager tool
• Manage SQL Server services using the Windows Services Microsoft Management Console (MMC) tool
• Manage SQL Server services using the Command window (CMD)

Create a SQL Server job that runs at a specific time.

• Create a SQL Server job to run immediately
• Schedule a SQL Server job to run at a specific time
• Monitor a SQL Server job using the Job Activity Monitor