Beginning SQL Server

Use SQL Management Studio to perform a core set of job-related tasks.

course image

Course details

ceus icon CEUs 1.8

schedule icon Schedule Evenings

location icon Location Online

cost icon Cost

Registration details

Beginning SQL Server

Use SQL Management Studio to perform a core set of job-related tasks.

What you’ll be able to do — competencies

  • Perform basic tasks using the Object Explorer window in SQL Server Management Studio (SSMS)
  • Manage security permissions on databases
  • Create an explicit transaction that blocks out another explicit transaction with an exclusive lock
  • Manipulate the files of a database using the features of SQL Server
  • Manage the operation of SQL Server services using tools inside and outside of SQL Server
  • Create a SQL job that runs at a specific time

Course description

expand drawer icon collaspe drawer icon

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).

Prerequisites

expand drawer icon collaspe drawer icon
  • Basic Relational Database Essentials or familiarity with a database product or equivalent knowledge

Syllabus

expand drawer icon collaspe drawer icon

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

Next available start dates

Online — Weekends

Registration closed expand drawer icon collaspe drawer icon
Beginning SQL Server
hours icon

Total classroom hours

18 hours

schedule icon

Schedule

Online

Weekends, 9:00 AM - 12:00 PM, 6 S - 9/12/2020-10/17/2020

cost icon

Total cost

$649

instructor icon

Instructor: Murray Law

notes icon

Notes

Online courses require an internet connection and the ability to interact both through audio and video using either a web cam/microphone, speakers/headset using a computer or via a mobile phone connection. Any costs associated with connectivity or equipment are the responsibility of the student.

Interested in custom learning solutions for your team?

Tombolo Institute Corporate Solutions offers tailor-made professional development programs to meet your organization’s goals.

Get started