Beginning SQL Server
Use SQL Management Studio to perform a core set of job-related tasks.
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
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
- Basic Relational Database Essentials or familiarity with a database product or equivalent knowledge
Syllabus
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 — Evenings
Beginning SQL Server
Total classroom hours
18 hours
Schedule
Online
Evenings, 6:00 PM - 9:00 PM, 6 T, Th - 3/9/2021 - 3/25/2021
Quarter: Winter
Total cost
$649
Instructor: Victor Leal
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.
Online — Weekends
Beginning SQL Server
Total classroom hours
18 hours
Schedule
Online
Weekends, 12:00 PM - 3:00 PM, 6 S - 4/10/2021 - 5/15/2021
Quarter: Spring
Total cost
$649
Instructor: Murray Law
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