Search For Courses
Shopping Cart
Your cart is empty.
Your cart is empty.
Transform raw data into insights. Learn to query Microsoft SQL Server like a pro in just two days.
The DP-080: Transact-SQL Querying course introduces students to the foundational skills needed to query and manipulate data using Microsofts Transact-SQL language.
The class will cover the following topics:This course is ideal for data professionals such as analysts, engineers, scientists, developers, and administrators, as well as anyone seeking a foundational understanding of querying data in Microsoft SQL Server environments.
Learn from Professional Instructors and move forward in your field with industry-aligned SQL Server training.
All of our Public Classes are taught by a virtual live instructor. How it works is a live instructor conducts the class from a remote location regardless if you attend at one of the local training centers or if you attend remotely.
For of Private Group Training classes we can arrange to have the instructor conduct the class live at your location. Need Group Training?
Module 1
Introducing Active Directory® Domain Services
Contents:
Lesson 1: Overview of Active Directory, Identity, and Access 1-3
Lesson 2: Active Directory Components and Concepts 1-17
Lesson 3: Install Active Directory Domain Services 1-34
Lab: Install an AD DS Domain Controller to Create a Single Domain Forest 1-38
Module 2
Administering Active Directory Securely and Efficiently
Contents:
Lesson 1: Work with Active Directory Administration Tools 2-3
Lesson 2: Custom Consoles and Least Privilege 2-11
Lab A: Administering Active Directory by Using Administrative Tools 2-16
Lesson 3: Find Objects in Active Directory 2-22
Lab B: Find Objects in Active Directory 2-35
Module 3
Managing Users and Service Accounts
Contents:
Lesson 1: Create and Administer User Accounts 3-4
Lab A: Create and Administer User Accounts 3-15
Lesson 2: Configure User Object Attributes 3-18
Lab B: Configure User Object Attributes 3-28
Module 4
Managing Groups
Contents:
Lesson 1: Overview of Groups 4-3
Lesson 2: Administer Groups 4-23
Lab A: Administer Groups 4-35
Lesson 3: Best Practices for Group Management 4-40
Lab B: Best Practices for Group Management 4-48
Module 5
Managing Computer Accounts
Contents:
Lesson 1: Create Computers and Join the Domain 5-4
Lab A: Create Computers and Join the Domain 5-24
Lesson 2: Administer Computer Objects and Accounts 5-31
Lab B: Administer Computer Objects and Accounts 5-45
Module 6
Implementing a Group Policy Infrastructure
Contents:
Lesson 1: Understand Group Policy 6-4
Lesson 2: Implement GPOs 6-20
Lab A: Implement Group Policy 6-29
Lesson 3: Manage Group Policy Scope 6-33
Lab B: Manage Group Policy Scope 6-54
Lesson 4: Group Policy Processing 6-59
Lesson 5: Troubleshoot Policy Application 6-67
Lab C: Troubleshoot Policy Application 6-75
Module 7
Managing User Desktop with Group Policy
Contents:
Lesson 1: Implement Administrative Templates 7-3
Lab A: Manage Administrative Templates and Central Store 7-15
Lesson 2: Configure Group Policy Preferences 7-19
Lab B: Manage Group Policy Preferences 7-26
Lesson 3: Manage Software with GPSI 7-29
Lab C: Manage Software with GPSI 7-42
Module 8
Managing Enterprise Security and Configuration with Group
Policy Settings
Contents:
Lesson 1: Manage Group Membership by Using Group Policy Settings 8-3
Lab A: Use Group Policy to Manage Group Membership 8-11
Lesson 2: Manage Security Settings 8-14
Lab B: Manage Security Settings 8-29
Lesson 4: Software Restriction Policy and AppLocker 8-50
Lab D: Configure Application Control Policies 8-58
Please check the course description to find prerequisite information.
| Click Class Title for Dates and Details | Days | Course Fee |
|---|---|---|
| 20764-Administering a SQL Database Infrastructure | 5 | $2795 |
| PostgreSQL Basics | 2 | $1595 |
| SQL Querying: Fundamentals | 1 | $395 |
| SQL for Data Analytics | 5 | $1795 |
| SQL Querying: Advanced | 1 | $395 |
As part of our commitment to supporting learners at every stage, we’re working to develop a library of free SQL Server tutorials designed to help you tackle common tasks and workflows. We understand that not every situation calls for a full course, so these resources offer quick, practical guidance to help you get the job done efficiently.
| Course Title (Click For Details) | Course Fee | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| No courses available | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Learn with experienced professionally certified trainers that are subject matter experts.
You have the option to retake this class one time within a year of your original class date.
Our courses are all designed for the students to have hands-on interaction throughout the course.
Learn a local training center, or as a Remote Attendee from your home or office.
We use Official Training Materials and Labs when available to ensure you have the most up to date training.
You are busy, we get it. Our classes are regularly scheduled to give you a number of convenience training options.
We offer affordable financing options for all of our courses to make sure cost is not a barrier to your progress.
Have a team to train? We offer On-Site, Blended and Online Private Group Training services.
Getting professional training is one of the fastest ways to improve your skills and marketability.
Benefits of Virtual Live-Instructor Training Include:
DP-080: Transact-SQL Querying
SAVE 10% FOR A LIMITED TIME
| Course Title | Dates | Times | Location | Fee | |
|---|---|---|---|---|---|
| No active classes found | |||||
| Click Class Title for Dates and Details | Days | Course Fee |
|---|---|---|
| 20764-Administering a SQL Database Infrastructure | 5 | $2795 |
| PostgreSQL Basics | 2 | $1595 |
| SQL Querying: Fundamentals | 1 | $395 |
| SQL for Data Analytics | 5 | $1795 |
| SQL Querying: Advanced | 1 | $395 |
As part of our commitment to supporting learners at every stage, we’re working to develop a library of free SQL Server tutorials designed to help you tackle common tasks and workflows. We understand that not every situation calls for a full course, so these resources offer quick, practical guidance to help you get the job done efficiently.
| Course Title (Click For Details) | Course Fee | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| No courses available | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Benefits of Group Training Include:
SQL Server certifications are a powerful way to validate your SQL Server skills, and gain recognition as a trusted expert in the field. Whether you're an individual looking to boost your career or an organization investing in team development, our courses are designed to help you earn these industry-recognized credentials.
» View All SQL Server CertificationsLet us help you or your team get certified and stay competitive.
Certification Overview CompTIA A+ (Core 1 & Core 2) – V15 equips students with the practical skills required to install, configure, secure, and troubleshoot today’s devices and operating systems in business environments.
Topics Include:
Target Audience Aspiring IT Support Specialists & Help Desk Technicians Field/Service Desk Technicians & Desktop Support Staff Junior Systems/Network Support roles and Career Changers entering IT
learn more →Certification Overview CompTIA A+ (Core 1 & Core 2) – V15 equips students with the practical skills required to install, configure, secure, and troubleshoot today’s devices and operating systems in business environments.
Topics Include:
Target Audience Aspiring IT Support Specialists & Help Desk Technicians Field/Service Desk Technicians & Desktop Support Staff Junior Systems/Network Support roles and Career Changers entering IT
learn more →This certification is aimed at professionals who have advanced skills in AutoCAD and have experience working on more complex projects. It is typically recommended for those with around 400 hours of real-world experience.
Key areas covered:
Autodesk introduced an expert-level certification to cater to professionals who are highly skilled in AutoCAD and involved in more specialized, complex tasks like 3D modeling, parametric design, and custom workflows.
Key areas covered:
These certifications help individuals and professionals stand out in the job market by proving their expertise in AutoCAD to employers. Autodesk often updates its certification paths, so it’s always a good idea to check their official site or authorized training centers for the most current information.
learn more →Here’s what professionals and teams across the country are saying about their experience with Business Computer Skills
This was the class I needed. The instructor Jeff took his time and made sure we understood each topic before moving to the next. He answered all of our questions, and I don’t know about the rest of the students, but was very pleased with this experience.
Amanda T.,
Yale New Haven Hospital
