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

Web Age Solutions team Logo

Querying Data with Microsoft Transact-SQL Training

This course will teach the basics of Microsoft's dialect of the standard SQL language, Transact-SQL.

by Web Age Solutions team [Claim Listing ]
Versalys Logo

Querying Microsoft SQL Server (2014 20461)

This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014.

by Versalys [Claim Listing ]
  • Price
  • Start Date
  • Duration
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 ]
Global Erp Solutions Brampton Logo

Oracle Admin Training

Students also learn how to create an operational plan. This course is designed to give the Oracle database administrator (DBA) a firm foundation in basic database administrative tasks.

by Global Erp Solutions Brampton [Claim Listing ]
HiTech Institute Logo

Integrating Data Encryption into a Microsoft® SQL Server™ 2005

In this course, you apply guidelines and considerations for securing data using encryption and certificates. You describe various data encryption policies. Finally, you determine a key storage method.

by HiTech Institute [Claim Listing ]

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