SQL: Querying

Unlock the power of your organizational data with our comprehensive SQL: Querying course, tailored for analysts and database professionals seeking to enhance their querying skills using SQL for efficient data retrieval and manipulation.

Course Thumbnail

Essential Skills Gained

Checkmark

Connect to SQL Server databases and execute queries efficiently.

Checkmark

Implement conditional searches and leverage SQL functions for data manipulation.

Checkmark

Create and manage table structures and views for optimized data interaction.

Checkmark

Execute complex transactions with skills in rollback and commit operations.

Format

  • Instructor-led
  • 2 days with lectures and hands-on labs.

Audience

  • Database Administrators
  • Data Analysts
  • IT Professionals
  • Students learning SQL

Description

Many organizations use databases to store their most critical information: the information that manages their day-to-day operations. After the data is stored in databases, however, it is useless unless you can retrieve it for further business analysis. This 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. You will also create transactions so that you can choose to save or cancel data entry process.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

SQL: Fundamentals (Book 1)

  1. Lesson 1: Executing a Simple Query

    • Connect to the SQL Database

    • Query a Database

  2. Lesson 2: Performing a Conditional Search

    • Search Using One or More Conditions

    • Search for a Range of Values and NULL Values

    • Search Data Based on Patterns

  3. Lesson 3: Working with Functions

    • Perform Date Calculations

    • Calculate Data Using Aggregate Functions

    • Manipulate String Values

  4. Lesson 4: Organizing Data

    • Sort Data

    • Rank Data

    • Group Data

    • Filter Grouped Data

    • Summarize Grouped Data

  5. Lesson 5: Retrieving Data from Multiple Tables

    • Combine the Results of Two Queries

    • Compare the Results of Two Queries

    • Retrieve Data by Joining Tables

SQL: Advanced (Book 2)

  1. Lesson 1: Using Subqueries to Perform Advanced Querying

    • Search Based on Unknown Values

    • Compare a Value with Unknown Values

    • Search Based on the Existence of Records

    • Generate Output Using Correlated Subqueries

  2. Lesson 2: Manipulating Table Data

    • Insert Data

    • Modify and Delete Data

  3. Lesson 3: Manipulating the Table Structure

    • Create a Table

    • Create a Table with Constraints

    • Modify a Table's Structure

    • Back Up Tables

    • Delete Tables

  4. Lesson 4: Working with Views

    • Create a View

    • Manipulate Data in Views

    • Create Aliases

    • Modify and Delete Views

  5. Lesson 5: Managing Transactions

    • Create Transactions

    • Commit Transactions

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.