www.protechtraining.com Open in urlscan Pro
98.111.240.196  Public Scan

Form analysis
1 forms found in the DOM

/training/search

<form action="/training/search" id="header-search-form">
  <input id="terms" name="terms" type="text" placeholder="SEARCH" class="search-input">
  <i class="fa fa-search search-icon" style="cursor: pointer;" onclick="document.getElementById('header-search-form').submit();"></i>
</form>

Text Content

Skip to main content
 

  Login
Contact Us

 




HEADER MAIN

 * Training
   ProTech Training Virtual Classroom Schedule Browse Full Catalog (3000+) View
   Courses By Location Guaranteed To Run Courses Recently Added Courses
   Multi-Week Bootcamp Courses Voucher Eligible Courses Course Delivery Options
   Digital Badge Program Government Training Solutions
   BROWSE OUR COURSE CATALOG
   ITIL & Governance Project & Portfolio Management Communication & Business
   Skills Business Analysis, Agile & DevOps Software Testing & Quality Assurance
   Java & Open-Source IBM Mainframes & ISV Products Databases, Data Science &
   Automation
   Unix & Linux Front-End Web & Mobile Development Microsoft Infrastructure,
   Development & Business Applications Cloud & Virtualization CompTIA, Help
   Desk, Apple & Multimedia Networking and Wireless Cybersecurity & IT Auditing
   
 * Consulting
   * ProTech Consulting
   * Automation Assessment
   * Automation Consulting
   * Automation Outsourcing
   * Operations Processing Assessment
   * Performance Availability Engineering
   * Scheduling Assessment
   * Scheduling Conversion
 * Software
   * ProTech Software
   * Free Downloads
 * About Us
   * About Us
   * Our Clients
   * Partners
   * Blog
   * Careers
   * Contact Us
   * News
 * Resources
   * Upcoming Webinars
   * Past Webinars
   * Articles and Blogs
   * Video Resources

 1. Home
 2. Training
 3. Databases, Data Science & Automation
 4. SQL


SQL BASIC TO ADVANCED


LOADING COURSE SCHEDULE...



Add To Watch List Request In Your Area Request Private Class View PDF
PT27354
Training Summary
Come prepared to learn the Structured Query Language (SQL) across multiple
database platforms in this fast paced and hands-on course. The course begins
with a discussion of relational concepts and terminology and quickly moves into
a very practical discussion of data retrieval and manipulation using SQL. Each
topic is reinforced with hands-on workshops. Examples and workshops are provided
for multiple platforms such as Db2 for z/OS, Db2 for Linux, Unix & Windows,
Oracle Database, Microsoft SQL Server, and PostgreSQL. Differences between the
RDBMSs are highlighted throughout the material and especially the SQL workshops.
Students will leave with the ability to code queries involving simple to
intermediate complexity. Get ready to go to the next level with the Structured
Query Language (SQL) and become a power user. Whether you are being asked to
solve complicated problems with SQL or you need to read and understand complex
SQL that is already written, this course is for you. Come prepared to master the
Structured Query Language (SQL) across multiple database platforms in this fast
paced and hands-on course. We begin with a review of joins and move quickly to
more complex operations involving set processing, advanced grouping, table
expressions, recursion and more. Each topic is reinforced with hands-on
workshops. Examples and workshops are provided for multiple platforms, such as
Db2 for z/OS, Db2 for Linux, Unix & Windows, Oracle, SQL Server or PostgreSQL,
with discussion of the relevant differences.
Prerequisites
There are no prerequisites for this course.
Duration
5 Days/Lecture & Lab
Audience
Programmers, Analysts, Database Administrators, End Users and IT Managers who
are exposed to, or are required to perform the activities associated with data
stored in a relational database.
Course Topics
 * SQL and Relational Databases Overview
 * SELECT Statements
 * SELECT WHERE Clause Operators
 * SELECT ORDER BY Clause
 * SQL Case Logic
 * SQL Built-in/Supplied Functions
 * SQL Aggregate Functions/Group By, Having Clauses
 * Insert, Update, Delete, Merge, Truncate Statements
 * Inner/Outer Joins
 * Basic Subqueries
 * Review Inner/Outer Joins
 * Subquery Table Expressions
 * Set Operations
 * Advanced Grouping with the CUBE, ROLLUP and GROUPING SETS Extensions
 * Solving Complex Problems with SQL
 * PIVOT and UNPIVOT Operations
 * Using Temporary Tables and Views


RELATED SCHEDULED COURSES

ADVANCED POSTGRESQL ADMINISTRATION AND PERFORMANCE

Almost GTR

ADVANCED SQL

POSTGRESQL ADMINISTRATION

SQL BASICS

‌ ‌ ‌ ‌

ProTech Professional Technical Services, Inc.
EMAIL: INFO@PROTECHTRAINING.COM
Toll Free: 866-358-1727
GSA #GS-35F-0486W

Join Our Mailing List

 

Copyright © 2023 ProTech Professional Technical Services, Inc. All Rights
Reserved.