Introduction to SQL for the Non-Technical Course

Course Summary

The Introduction to SQL for the Non-Technical training course explores key concepts, techniques, and commands necessary for business analysts, data analysts, and technical end-users to effectively interact with, query, and analyze data in existing databases and datastores.

The course begins with an overview of SQL and its functionality and history. Students will then learn about database concepts, data types, and data terms. Hands-on demos and labs will be utilized to enhance learning about accessing MySQL, performing queries, filtering data, and organizing results. Finally, the course will explore complex data querying and SQL functions.

Purpose

Learn how to effectively interact with, query, and analyze data in SQL databases.

Audience

Non-technical managers and employees needing to learn the basics of SQL.

Role

Business Analyst - Project Manager

Skill Level

Introduction

Style

Learning Spikes - Workshops

Duration

2 Days

Related Technologies

MySQL

SQL

Download

Productivity Objectives:

List the databases and tables in your database
Query a table based using variable select data
Order query results
Update and insert data into a table
Create inner and outer joins

Learn About Virtual Training

Request Information

Get your team upskilled or reskilled today. Chat with one of our experts to create a custom training proposal. Fully customized at no additional cost.

If you are not completely satisfied with your training class, we'll give you your money back.

about our training

Real-World Content

Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.
Expert Practitioners

Industry experts with 15+ years of industry experience that bring their battle scars into the classroom.
Experiential Learning

More coding than lecture, coupled with architectural and design discussions.
Fully Customized

One-size-fits-all doesn't apply to training teams. That's where we come in!

What You'll Learn

In the Introduction to SQL for the Non-Technical training course, you'll learn:

Introduction to SQL
- What is SQL?
- How does SQL differ based on database vendor?
- Current SQL ANSI Standards
- Functionality supported by SQL
Database Concepts
- Core database terminologies: tables, rows, columns
- Understanding data in databases: data types, primary keys, foreign keys
Accessing MySQL
- Connecting to MySQL using a command-line tool
- Connecting to MySQL using DBeaver
- Performing a basic query using DBeaver
Performing Queries
- Core SQL syntax
- SELECT concepts
- SELECTing data
  - All data
  - Rows of data
  - Columns of data
  - Sorting results
Filtering Data
- SELECT using WHERE
- Checking for equality and inequality
- Greater than, less than, and NULL
- Multiple filters using Boolean operators: AND and OR
- Multiple filters using logical operators: BETWEEN, IN, LIKE, NOT
Organizing Results
- Ordering results using ORDER BY
- Grouping results using GROUP BY
Complex Data Querying
- Understanding a join
- Querying related rows using INNER JOIN
- Including non-matched rows with OUTER JOIN
- Unions
- Handling JOIN results
SQL Functions
- Math functions: count, avg, sum, round, etc.
- String and Character functions: ucase, lcase, etc.
- Time functions: now, date, etc.