Desicion Making with Basic SQL

About This Training

This training is designed to help users understand the basics of SQL, the most popular language for interacting with databases.

This training covers all the major features of SQL: SELECT statements, Filtering and Sorting, Using Functions, Join Methods, SubQueries, Modifying Data, and Designing New Objects (Tables, Indexes, Views, etc.)

In this training, we offer a solid working knowledge of the language, and demonstrate how to retrieve and manage data efficiently. Each module is reinforced with structured hands-on exercises.

Target Audience

This course is mainly intended for Database Administrators, Database Developers, Business Intelligence professionals, QA professionals, Data Analysts, and other roles responsible for querying the database.

Prerequisites

Basic working knowledge of relational databases.
Basic understanding of the Microsoft Windows operating system.

Module 1- Basic select statements

Using the SELECT statement to retrieve all / specific rows
Column aliases
Concatenations
Arithmetic operations
Using the DISTINCT keyword.

Module 2 - Filtering and sorting the results

using simple (=, <, >, <> etc.) and complex (IN, BETWEEN, LIKE etc.) operators
Combining condition using AND and OR,
Sorting the results using ORDER BY.

Module 3 - Scalar Functions

Using functions to manipulate strings, numbers and dates, converting data types, using conditional functions.

Module 4 - Group Functions

Using aggregate functions such as – AVG, SUM, MIN, MAX and COUNT, using the GROUP BY clause, restricting the results using the HAVING clause.

Module 5 - Join methods

Combining data from multiple sources using INNER / OUTER and SELF join.

Module 6 - Sub Queries

Using Single and Multiple row Subqueries

Module 7 - Add, modify, or remove data from a table

Add, modify, or remove data from a table using UPDATE, DELETE and INSERT

Module 8 - Creating new tables

Using CREATE, ALTER and DROP.

Contact Us

Latest courses

About Us

UpScale Analytics specializes in training solutions for organizations and individuals in the fields of data.

UpScale Analytics is also one of the largest platforms in the world for learning SQL by doing.

Desicion Making with Basic SQL

About This Training

Target Audience

Prerequisites

Contact Us

Latest courses

About Us

Popular Courses

Desicion Making with Basic SQL

PL/SQL Programming

Advanced Power BI

Quick Links