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- Fundamentals of SELECT Statements

Overview of SELECT statement usage
Retrieving all or specific rows from a table
Implementing column aliases for clarity
Utilizing concatenation for data combination
Performing arithmetic operations within queries
Employing the DISTINCT keyword for unique results

Module 2 - Data Filtering and Result Sorting

Applying simple comparison operators (e.g., =, <, >, <>)
Implementing complex operators (e.g., IN, BETWEEN, LIKE)
Combining conditions using
AND and OR logic
Ordering query results with the
ORDER BY clause

Module 3 - Utilizing Scalar Functions

Manipulating strings, numbers, and dates with built-in functions
Converting data types for compatibility
Employing conditional functions for custom data manipulation

Module 4 - Implementing Group Functions

Leveraging aggregate functions (e.g., AVG, SUM, MIN, MAX, COUNT)
Grouping data using the GROUP BY clause
Filtering grouped results with the HAVING clause

Module 5 - Join Techniques for Data Combination

Merging data from multiple sources using INNER JOIN and OUTER JOIN
Implementing SELF JOIN for data comparisons within a single table

Module 6 - Employing Subqueries

Understanding single-row and multi-row subqueries
Nesting subqueries for advanced data analysis

Module 7 - Data Manipulation within Tables

Adding, updating, or deleting data with INSERT, UPDATE, and DELETE commands

Module 8 - Table Creation and Modification

Designing new tables with the CREATE command
Modifying existing tables using ALTER
Removing tables with the DROP command

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.

Popular Courses

Desicion Making with Basic SQL

PL/SQL Programming

Advanced Power BI

Quick Links

Upscale Analytics 2022 © All Rights Reserved