Perform a core set of job-related tasks, with a focus on the tools of SQL Server Management Studio (SSMS). Topics: automatically generate queries for most actions that can be accomplished using the tools in SSMS; setup a remote connection; manage security permissions; monitor transactions and transaction locking; create and move a database; control the operation of services in SQL Server; and, create, schedule and monitor jobs. Bring a USB flash drive (minimum 2 GB) to class.
Prerequisite: Structured Query Language: (SQL) Level 1 or equivalent.
See our detailed course information including course content, learning objectives, and prerequisites.