www.onlc.com Open in urlscan Pro
2606:4700:3108::ac42:286d Public Scan

Back to summary

URL:
https://www.onlc.com/outline.asp?ccode=ADP080&utm_campaign=RR&utm_medium=EB&utm_source=202305
Submission: On April 12 via api (April 12th 2023, 5:02:58 pm UTC) from US — Scanned from DE

Form analysis
8 forms found in the DOM

<form class="navbar-form" role="search">
  <div class="input-group" style="position: relative;">
    <section id="unibox-suggest-box" class="unibox unibox-n-section" role="listbox" aria-label="Search Suggestions" style="min-width: 839px; max-width: 839px; left: -657px; top: 34px;"></section>
    <input type="text" class="form-control" placeholder="Search" name="q" id="searchBox" autocomplete="off" aria-label="Search query" role="combobox" aria-describedby="unibox-controls-description" aria-owns="unibox-suggest-box"
      aria-controls="unibox-suggest-box" aria-expanded="false">
    <div class="input-group-btn">
      <button class="btn btn-default" type="submit" id="searchButton"><i class="glyphicon glyphicon-search"></i></button>
    </div>
    <span id="unibox-controls-description" style="position:absolute;width:1px;height:1px;padding:0;margin:-1px;overflow:hidden;clip:rect(0,0,0,0);border:0" class="unibox-sr-only" tabindex="-1">Use the up and down arrows to select a result. Press
      enter to go to the selected search result. Touch device users can use touch and swipe gestures.</span><span id="unibox-status-message"
      style="position:absolute;width:1px;height:1px;padding:0;margin:-1px;overflow:hidden;clip:rect(0,0,0,0);border:0" tabindex="-1" aria-live="polite" aria-atomic="true" role="status" class="unibox-sr-only"></span>
  </div>
</form>

<form style="margin-top:3px; margin-bottom:3px; clear:both;">
  <input type="hidden" name="def" value="online">
  <input type="hidden" name="company" value="ONLINE">
  <input type="hidden" name="number" value="ADP0800522">
  <input type="hidden" name="st_date" value="5/22/2023">
  <input type="button" value="Enroll" onclick="enrollClick(this.form);" title="Click to sign up for this class."> &nbsp;<input type="button" value="Reminder" onclick="emremind(this.form)" title="Click to get an email reminder for this class.">
</form>

<form style="margin-top:3px; margin-bottom:3px; clear:both;">
  <input type="hidden" name="def" value="online">
  <input type="hidden" name="company" value="ONLINE">
  <input type="hidden" name="number" value="ADP0800615">
  <input type="hidden" name="st_date" value="6/15/2023">
  <input type="button" value="Enroll" onclick="enrollClick(this.form);" title="Click to sign up for this class."> &nbsp;<input type="button" value="Reminder" onclick="emremind(this.form)" title="Click to get an email reminder for this class.">
</form>

<form style="margin-top:3px; margin-bottom:3px; clear:both;">
  <input type="hidden" name="def" value="online">
  <input type="hidden" name="company" value="ONLINE">
  <input type="hidden" name="number" value="ADP0800713">
  <input type="hidden" name="st_date" value="7/13/2023">
  <input type="button" value="Enroll" onclick="enrollClick(this.form);" title="Click to sign up for this class."> &nbsp;<input type="button" value="Reminder" onclick="emremind(this.form)" title="Click to get an email reminder for this class.">
</form>

<form style="margin-top:3px; margin-bottom:3px; clear:both;">
  <input type="hidden" name="def" value="online">
  <input type="hidden" name="company" value="ONLINE">
  <input type="hidden" name="number" value="ADP0800814">
  <input type="hidden" name="st_date" value="8/14/2023">
  <input type="button" value="Enroll" onclick="enrollClick(this.form);" title="Click to sign up for this class."> &nbsp;<input type="button" value="Reminder" onclick="emremind(this.form)" title="Click to get an email reminder for this class.">
</form>

<form style="margin-top:3px; margin-bottom:3px; clear:both;">
  <input type="hidden" name="def" value="online">
  <input type="hidden" name="company" value="ONLINE">
  <input type="hidden" name="number" value="ADP0800911">
  <input type="hidden" name="st_date" value="9/11/2023">
  <input type="button" value="Enroll" onclick="enrollClick(this.form);" title="Click to sign up for this class."> &nbsp;<input type="button" value="Reminder" onclick="emremind(this.form)" title="Click to get an email reminder for this class.">
</form>

<form style="margin-top:3px; margin-bottom:3px; clear:both;">
  <input type="hidden" name="def" value="online">
  <input type="hidden" name="company" value="ONLINE">
  <input type="hidden" name="number" value="ADP0801009">
  <input type="hidden" name="st_date" value="10/9/2023">
  <input type="button" value="Enroll" onclick="enrollClick(this.form);" title="Click to sign up for this class."> &nbsp;<input type="button" value="Reminder" onclick="emremind(this.form)" title="Click to get an email reminder for this class.">
</form>

Name: alert — POST /scripts/getname.asp

<form style="margin-top:0px;margin-bottom:0px;" name="alert" method="post" action="/scripts/getname.asp" onsubmit="return validateForm(this)">
  <input type="hidden" name="dbfName" value="web">
  <input type="hidden" name="urlGoto" value=".">
  <input type="hidden" name="referer" value="">
  <input type="hidden" name="begindate" value="4/12/2023">
  <input type="hidden" name="em_to" value="inforeq@onlc.com">
  <input type="hidden" name="em_from" value="www@onlc.com">
  <input type="hidden" name="em_subj" value="More Info Req">
  <input type="hidden" name="em_fields" value="fname lname co_name phoneb emailaddr comment location referer urlGoto eof">
  <p class="leftcol" style="margin-top:0px;line-height:15px;">
    <b>HAVE QUESTIONS?</b><br>
    <span><b>First Name</b></span><br>
    <input type="text" size="10" maxlength="25" name="fname" style="width:120px">
    <br>
    <span><b>Last Name</b></span><br>
    <input type="text" size="10" maxlength="25" name="lname" style="width:120px">
    <br>
    <span><b>Company</b></span><br>
    <input type="text" size="10" maxlength="25" name="co_name" style="width:120px">
    <br>
    <span><b>Phone</b></span><br>
    <input type="text" size="10" maxlength="25" name="phoneb" style="width:120px">
    <br>
    <span><b>Email</b></span><br>
    <input type="text" size="10" maxlength="50" name="emailaddr" style="width:120px">
    <br>
    <span><b>Location</b></span><br>
    <input type="text" size="10" maxlength="100" name="location" style="width:120px">
    <br>
    <span><b>Question/Comment</b></span><br>
    <input type="text" size="10" maxlength="200" name="comment" style="width:120px">
    <br>
    <input type="SUBMIT" value="Submit"><br>
  </p>
</form>

Text Content

 800-288-8221     Contact Us     
Toggle navigation 800-288-8221
 * Home
 * Courses
   * * Desktop Applications
     * Adobe
     * Adobe On-Demand
     * Alteryx
     * AutoCAD
     * AutoCAD On-Demand
     * Canva
     * Crystal Reports
     * Data Visualization
     * Dynamics
     * Excel Analytics
     * Google Classroom
     * Google Ads & Analytics
     * Google Workspace (multiple)
     * Microsoft Office / Office 365
     * Microsoft Office Specialist (MOS)
     * Office 365 Collaboration
     * Power BI
     * QuickBooks
     * SAS
     * Salesforce.com
     * SketchUp
     * Splunk
     * Tableau
     * Web Design
     * WordPress
   * * Microsoft Technical
     * Active Directory
     * Azure
     * BizTalk Server
     * Exchange Server
     * Microsoft 365
     * Microsoft On-Demand (multiple)
     * Office 365
     * Power Platform (multiple)
     * PowerShell
     * Role-based Certifications
     * Security
     * SharePoint
     * SQL Server
     * System Center
     * Visual Studio
     * Windows Client / 10
     * Windows Server
   * * Server & Cybersecurity
     * Cisco
     * CompTIA
     * CompTIA On-Demand
     * Cybersecurity
     * Docker
     * Ethical Hacking / EC-Council
     * Linux
     * Oracle
     * RPA
     * VMware
   * * Process & Programming
     * AWS
     * Business Intelligence (BI)
     * Business Process
     * Java Programming
     * Low-Code/No-Code
     * Open Source
     * Programming (multiple)
     * Project Management (multiple)
     * Web Development
     * 
     * 
     * All Courses
 * Certifications
   * Microsoft Office Certification (MOS)
   * Microsoft Technical Certification (Role-based)
   * Adobe Certification
   * AWS Certification
   * AutoCAD Certification
   * CareerPath Certification Programs
   * Cisco Certification
   * CompTIA Certification
   * EC Council Certification
   * ITIL® Certification
   * Oracle Certification
   * Project Mgmt. Certification
   * Python Certification
   * QuickBooks Certification
   * Security Certification
   * Scrum Master Certification
   * Splunk Certification
   * Tableau Certification
   * VMware Certification
   * 
   * All Certifications
 * Savings
 * Schedule
 * Locations
 * Info
   * Class Format
   * Registration
   * Payment
   * Invoice/Receipt
   * Cancel/Reschedule
   * What is RCI?
   * Why ONLC?
 * Blog
 * RCI Login


Use the up and down arrows to select a result. Press enter to go to the selected
search result. Touch device users can use touch and swipe gestures.

DP-080: Transact-SQL Querying

Class Dates
(click date for class times)
(click Enroll for locations)
5/22-5/23

Class Dates and Times 05/22/2023Monday 10:00-4:45 EDT   9:00-3:45 CDT
  8:00-2:45 MDT   7:00-1:45 PDT 05/23/2023Tuesday 10:00-4:45 EDT   9:00-3:45 CDT
  8:00-2:45 MDT   7:00-1:45 PDT

Ready to Run Class
A Ready to Run date will not cancel due to low enrollments. Seats are still
available but filling fast - Register soon!


Last Reg Date5/17

 
6/15-6/16

Class Dates and Times 06/15/2023Thursday 10:00-4:45 EDT   9:00-3:45 CDT
  8:00-2:45 MDT   7:00-1:45 PDT 06/16/2023Friday 10:00-4:45 EDT   9:00-3:45 CDT
  8:00-2:45 MDT   7:00-1:45 PDT

 
7/13-7/14

Class Dates and Times 07/13/2023Thursday 10:00-4:45 EDT   9:00-3:45 CDT
  8:00-2:45 MDT   7:00-1:45 PDT 07/14/2023Friday 10:00-4:45 EDT   9:00-3:45 CDT
  8:00-2:45 MDT   7:00-1:45 PDT

 
8/14-8/15

Class Dates and Times 08/14/2023Monday 10:00-4:45 EDT   9:00-3:45 CDT
  8:00-2:45 MDT   7:00-1:45 PDT 08/15/2023Tuesday 10:00-4:45 EDT   9:00-3:45 CDT
  8:00-2:45 MDT   7:00-1:45 PDT

 
9/11-9/12

Class Dates and Times 09/11/2023Monday 10:00-4:45 EDT   9:00-3:45 CDT
  8:00-2:45 MDT   7:00-1:45 PDT 09/12/2023Tuesday 10:00-4:45 EDT   9:00-3:45 CDT
  8:00-2:45 MDT   7:00-1:45 PDT

 
10/9-10/10

Class Dates and Times 10/09/2023Monday 10:00-4:45 EDT   9:00-3:45 CDT
  8:00-2:45 MDT   7:00-1:45 PDT 10/10/2023Tuesday 10:00-4:45 EDT   9:00-3:45 CDT
  8:00-2:45 MDT   7:00-1:45 PDT

 

--------------------------------------------------------------------------------

Fee:  $1195


Savings options:

 Learning Credits

Need a price quote?

Follow the link to our self-service price quote form to generate an email with a
price quote.

Need a class for a group?

We can deliver this class for your group. Follow the link to request more
information.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early
Notice" status.

Train from your home or office

If you have high-speed internet and a computer you can likely take this class
from your home or office.






DP-080: TRANSACT-SQL QUERYING COURSE OUTLINE

Overview
This two-day course will teach the basics of Microsoft's dialect of the standard
SQL language: Transact-SQL. Topics include both querying and modifying data in
relational databases that are hosted in Microsoft SQL Server-based database
systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse
Analytics.

Audience Profile
This course can be valuable for anyone who needs to write basic SQL or
Transact-SQL queries. This includes anyone working with data as a data analyst,
a data engineer, a data scientist, a database administrator or a database
developer. It can also be useful for others peripherally involved with data, or
wanting to learn more about working with data such as solution architects,
students and technology managers.

Job role
Database Administrator

Skills gained
Use SQL Server query tools
Write SELECT statements to retrieve columns from one or more tables
Sort and filter selected data

Course outline

Module 1: Getting Started with Transact-SQL
In this module you will learn about the basics of the Transact-SQL (T-SQL)
language, as well as general properties and terminology of relational databases.
This module will also introduce the basic SELECT statement for retrieving data
from a table.
Lessons
Introduction to Transact-SQL
Using the SELECT statement
Lab : Get started with SQL Server query tools and writing queries in T-SQL

Module 2: Sorting and Filtering Query Results
In the module you will learn how to control what data is returned, the order in
which it is returned. You will use the ORDER BY clause, with and without paging.
You will learn about various kinds of filters that can be used in the WHERE
clause to control which data rows are returned. You will also learn how to
manage the results by removing duplicates with DISTINCT.
Lessons
Sorting query results
Filtering the data
Lab : Sort and filter data returned by SELECT queries

Module 3: Using Joins and Subqueries
In this module, you will explore T-SQL queries which access data from multiple
tables with various kinds of JOIN operations and simple subqueries.
Lessons
Using JOIN operations
Using subqueries
Lab : Write queries with JOIN operations
Lab : Write SELECT statements using subqueries

Module 4: Using Built-in Functions
In the module you will explore the use of built-in functions for returning
computed or special values in the SELECT list or in the WHERE clause. Functions
include math functions, string functions and system functions. There are other
types of functions that will be mentioned, but not discussed in detail. You will
also learn how to combine rows of data into a single group, providing summary
information for the group such as SUM, MIN or MAX.
Lessons
Getting started with scalar functions
Grouping aggregated results
Lab : Built-in functions

Module 5: Modifying Data
In this module, you will learn the T-SQL statements for modifying table data
including UPDATE, DELETE and MERGE as well as various options for INSERT
including creating a new table with data from an existing table. You will also
look at how to have the system automatically supply values for columns as the
data is inserted.
Lessons
Inserting data into tables
Modifying and deleting data
Lab : Modify data
View outline in Word

ADP080

Attend hands-on, instructor-led DP-080: Transact-SQL Querying training classes
at ONLC's more than 300 locations. Not near one of our locations? Attend these
same live classes from your home/office PC via our Remote Classroom Instruction
(RCI) technology.

For additional training options, check out our list of Courses and select the
one that's right for you.

GENERAL INFO

Class Format
Class Policies
Student Reviews



--------------------------------------------------------------------------------

HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment




--------------------------------------------------------------------------------

×



Loading...


×

BUSINESS TO BUSINESS ONLY

In Virginia, ONLC is only licensed to serve students who are sponsored by their
employer. We cannot accept registrations from individuals.

If you are being sponsored by your company, click Ok to continue to register.

Ok Close
×

NEW HAMPSHIRE RESIDENTS

This course has not yet been approved by the New Hampshire Department of
Education. Please contact us for an update on when the class will be available
in New Hampshire.

Close
ONLC TRAINING CENTERS
800-288-8221
www.onlc.com
Our Classes
 * Instructor-led Schedule (all titles)
 * On-Demand / self-study courses
 * Payment & Registration Policies

Why Register with ONLC
 * Why ONLC
 * Fewest Class Cancellations
 * Reasons to Register Early

Other Information
 * Hundreds of ONLC Centers
 * Our Instructors
 * Class Credits (CEU/CPE/PDU)

For Companies
 * Savings Options & Plans
 * Custom & Private Training
 * Extra Value Adds

For Professionals
 * Certification Programs
 * Savings Plans
 * Money Back Guarantee

For Government
 * GSA / Federal, State, Military
 * DoD 8140 / 8570.1
 * Private & Custom Classes

Live Classes from Home or Office
 * RCI Overview
 * RCI from Destinations
 * Setup Overview (videos)

About ONLC
 * About Us
 * Business IDs
 * Job Openings

Other Details
 * Certification Exams
 * Partnering Opportunities
 * Contact Us

Connect
 *    Facebook
 * LinkedIn






Live Chat

www.onlc.com Open in urlscan Pro 2606:4700:3108::ac42:286d Public Scan

Form analysis 8 forms found in the DOM

Name: alert — POST /scripts/getname.asp

Text Content

www.onlc.com Open in urlscan Pro
2606:4700:3108::ac42:286d Public Scan

Form analysis
8 forms found in the DOM