Enroll yourself in the SQL Querying Fundamentals course to gain hands-on expertise on SQL fundamentals. This SQL training course is intended for individuals with basic computer skills who are familiar with concepts related to database structure and terminology and want to use SQL to query databases. The SQL tutorial covers the topics of SQL including data organization, simple Query, performing conditional searches, exporting Query results, and retrieving data from multiple tables.

starstarstarstarstar_half

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

Gain the foundational knowledge you need to take the first stesp on this topic.

1

  • Executing a Simple Query

  • Lesson Objectives
    Lesson Introduction
    TOPIC A: Connect to the SQL Database
    TOPIC B: Query a Database
    TOPIC C: Save a Query
    TOPIC D: Modify and Execute a Saved Query
    Summary
2

  • Performing a Conditional Search

  • Lesson Objectives
    Lesson Introduction
    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
    Summary
3

  • Working with Functions

  • Lesson Objectives
    Lesson Introduction
    TOPIC A: Perform Date Calculations
    TOPIC B: Calculate Data Using Aggregate Functions
    TOPIC C: Manipulate String Values
    Summary
4

  • Organizing Data

  • Lesson Objectives
    Lesson Introduction
    TOPIC A: Sort Data
    TOPIC B: Rank Data
    TOPIC C: Group Data
    TOPIC D: Filter Grouped Data
    TOPIC E: Summarize Grouped Data
    TOPIC F: Use PIVOT and UNPIVOT Operators
    Summary
5

  • Retrieving Data from Multiple Tables

  • Lesson Objectives
    Lesson Introduction
    TOPIC A: Combine the Results of Two Queries
    TOPIC B: Compare the Results of Two Queries
    TOPIC C: Retrieve Data by Joining Tables
    Summary
6

  • Exporting Query Results

  • Lesson Objectives
    Lesson Introduction
    TOPIC A: Generate a Text File
    TOPIC B: Generate an XML File
    Summary
7

  • Appendix A

  • The FullerAckerman Database
    Schema

Audience

Anyone interested in learning the foundational concepts of SQL querying will benefit.

Language

English

Prerequisites

There are no rerequisites for this course.

Length: 365.0 days ( hours)

Level:

Not Your Location? Change

Course Schedule:

To request a custom delivery, please chat with an expert.

Loading...