Centriq Training Print Logo

Monday

July 6 04:15 AM

See our response to COVID-19: Safe Social Distancing with Centriq’s Live Virtual Training.

MS-SQL

SQL: Querying Training Class:

  • Ways to Train:
  • Live Classroom
    Class is delivered at a Centriq location with a live instructor actually in the classroom.
  • Live Virtual Class
    Class is delivered live online via Centriq's Virtual Remote technology. Student may attend class from home or office or other location with internet access.
  • HD Class
    Class is delivered via award winning HD-ILT at Centriq's facility. Students view the live instructor utilizing a 60'' HD monitor.
  • Ways to Buy:
  • Retail
    Class can be purchased directly via check, credit card, or PO.
  • CV Centriq Vouchers
    Class is available for students using Centriq Vouchers.
  • CP Centriq Choice Pass Eligible
    Class is available to students utilizing Centriq Choice Pass program.
  • SA SATV Eligible
    Class is available for students utilizing Microsoft Software Assurance Training Vouchers.
  • CLC Cisco Learning Credit
    Class is available for students using Cisco Learning Credits.
Start Date End Date Duration Days Start Time End Time Time Zone Location Ways to Train Ways to Buy Price
10.22.20 10.23.20 2 Days TH-F 8:30AM 4:00PM Central Kansas City Live Classroom Live Virtual Classroom Cash CV Centriq Vouchers $1100.00
 
 
3.0 CV
Enroll Now

This two-day course will teach you to use SQL as a tool to retrieve the information you need from databases. You will work with queries to manipulate and index tables.

Audience

Students should have basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.

Prerequisites

  • Access 2007, 2010, and 2013
  • Basic understanding of Relational Database Design

Course Completion

Upon successful completion of this course, students will be able to:

  • Connect to the SQL Server database and execute a simple query
  • Include a search condition in a simple query
  • Use various functions to perform calculations on data
  • Format an output, save a result, and generate a report
  • Use subqueries to generate query output.
  • Manipulate table data by inserting and updating records in a table and deleting records from a table.
  • Manipulate the table structure.
  • Create views, manipulate data through views, modify the view structure, and drop views.
  • Create indices on table columns and drop inefficient indices.
  • Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction.

View the SQL: Querying Training Course Outline

Executing a Simple Query

  • Topic A: Connect to the SQL Database
  • Topic B: Query a Database

Performing a Conditional Search

  • Topic A: Search Using One or More Conditions
  • Topic B: Search for a Range of Values and NULL Values
  • Topic C: Search Data Based on Patterns

Retrieving Data from Multiple Tables

  • Topic A: Combine the Results of Two Queries
  • Topic B: Compare the Results of Two Queries
  • Topic C: Retrieve Data by Joining Tables

Organizing Data

  • Topic A: Sort Data
  • Topic B: Rank Data
  • Topic C: Group Data
  • Topic D: Filter Grouped Data
  • Topic E: Summarize Grouped Data

Working with Functions

  • Topic A: Perform Date Calculations
  • Topic B: Calculate Data Using Aggregate Functions
  • Topic C: Manipulate String Values

Working with Views

  • Topic A: Create a View
  • Topic B: Manipulate Data in Views
  • Topic C: Create Aliases
  • Topic D: Modify and Delete Views

Manipulating the Table Structure

  • Topic A: Create a Table
  • Topic B: Create a Table with Constraints
  • Topic C: Modify a Table's Structure
  • Topic D: Back Up Tables
  • Topic E: Delete Tables

Using Subqueries to Perform Advanced Querying

  • Topic A: Search Based on Unknown Values
  • Topic B: Compare a Value with Unknown Values
  • Topic C: Search Based on the Existence of Records
  • Topic D: Generate Output Using Correlated Subqueries

Manipulating Table Data

  • Topic A: Insert Data
  • Topic B: Modify and Delete Data

Optional Topics:

Managing Transactions

  • A: Create Transactions
  • B: Commit Transactions

 

Enroll Now!