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

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 ]
(BTT) Business And Technical Training College Logo

Database Analysis

The course introduces students to Excel features and commands that are needed to analyze large datasets in order to make informed business decisions. It teaches how to gather and organize data for operational analysis. And, learn various analysis terminologies for effective communications.

by (BTT) Business And Technical Training College
Concordia University Logo

Intro to SQL

his course serves as the foundation for further studies in programming. And if you're reading this on the web, someone, maybe someone like you, took a course just like this and now has a pretty cool job.

by Concordia University [Claim Listing ]
Formation SETC Logo

PLSQL Training

Our training covers basic and advanced PLSQL, PLSQL programming, triggers, cursors, sequences, packages, stored procedures and functions, date and time management, string manipulation and more Again. 

by Formation SETC [Claim Listing ]
Doussou Formation Logo

Oracle SQLTuning Training

Oracle is a relational database management system that optimizes the management and security of data sets by creating structured database schemas that are accessible only to administrators with permissions.

by Doussou Formation [Claim Listing ]

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