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

Check out more Database Management courses in Canada

Launchpad Learning Logo

SQL

SQL course training is offered by Launchpad Learning for adults. Launchpad Learning has a lot to offer. We have many years of experience helping students from Mount Royal University, University of Calgary and SAIT.

by Launchpad Learning [Claim Listing ]
ProTech Training Logo

Cassandra for Developers

Modern, large-scale applications involve dealing with Big Data, which is often larger than what traditional databases (RDBMS) can handle. The Cassandra (C*) is a massively scalable NoSQL database that provides high availability and fault tolerance.

by ProTech Training [Claim Listing ]
Le Wagon Logo

SQL

Learn how to manage large datasets and analyze real data using the standard data management language.

by Le Wagon [Claim Listing ]
Net Soft College of Technology Logo

Administering a SQL Database Infrastructure

NetSoft’s Cloud Engineer Program trains students in administering a SQL database infrastructure. It enables students to gain the proficiency needed to harness the power of these products and other cloud and DevOps tools.

by Net Soft College of Technology [Claim Listing ]
Ontario College of Technology Logo

Data Analyst and Database Administrator

Data analytics and database management design, develop, and administer data management solutions, as well as develop and implement data administration policies, standards, and models.

by Ontario College of Technology [Claim Listing ]

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