SQL

by Promaxis Claim Listing

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.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Promaxis Logo

img Duration

2 Days

Course Details

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, SQL Querying: Fundamentals, will teach you to use SQL as a tool to retrieve the information you need from databases.

 

Executing A Simple Query

  • Connect to the SQL Database

  • Query a Database

  • Save a Query Modify and Execute a Saved Query

 

Performing A Conditional Search

  • Search Using One or More Conditions

  • Search for a Range of Values and NULL Values

  • Search Data Based on Patterns

 

Working With Functions

  • Perform Date Calculations

  • Calculate Data

  • Using Aggregate Functions

  • Manipulate String Values

 

Organizing Data

  • Sort Data

  • Rank Data

  • Group Data

  • Filter Grouped Data

  • Summarize Grouped Data

  • Use PIVOT and UNPIVOT Operators

 

Retrieving Data From Multiple Tables

  • Combine the Results of Two Queries

  • Compare the Results of Two Queries

  • Retrieve Data by Joining Tables

 

Exporting Query Results

  • Generate a Text File

  • Generate an XML File

  • Ottawa Branch

    2385 St Laurent Boulevard, Ottawa

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy