Skip to content

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.

Introduction to SQL

Course Summary

The Introduction to SQL training course is designed to explore key concepts, techniques, and commands necessary for developers and system administrators to write effective queries against common Structured Query Language (SQL) databases, like MySQL.

The course begins with an introduction to SQL, database concepts, and MySQL. The course then dives into working with data and tables and then focuses on queries. The course concludes with an overview of SQL functions and how to write a Simple Java Database Connectivity (JDBC) application.

This course is not intended to be a DBA-level course; rather, it focuses on building a practical, hands-on knowledge for engineers writing queries to support application development.

Purpose
 Learn the core concepts of SQL.
Audience
 Developers and system administrators with a desire to query SQL databases.
Role
Business Analyst - Data Engineer - Data Scientist - Project Manager - Software Developer - System Administrator - Technical Manager - Web Developer
Skill Level
Introduction
Style
Targeted Topic - Workshops
Duration
3 Days
Related Technologies
SQL

 

Productivity Objectives
  • Describe the history of SQL, and current support in your database.
  • List the databases and tables in your database.
  • Create new databases, tables, and add data to tables.
  • Query a table using variable select data.
  • Order query results.
  • Update and insert data into a table.
  • Create inner and outer joins.

What You'll Learn:

In the Introduction to SQL training course, you'll learn:
  • Introduction to SQL
    • What is SQL?
    • How does SQL differ based on database vendor?
    • Current SQL American National Standards Institute (ANSI) Standards
    • Functionality supported by SQL
  • Database Concepts
    • Core database terminologies
    • Database design process
    • Overview of Database Normalization
  • Introduction to MySQL
    • Downloading & Installing MySQL
    • Configuring MySQL
    • Basic MySQL administration
    • Connecting to MySQL
  • Working with Tables
    • Quick introduction to SELECT
    • Creating tables and columns
    • Identifying current tables and databases
    • Working with tables using CREATE, ALTER, DROP TABLE
    • Loading a database tables from a data file
    • Creating data integrity through relationships (primary keys, foreign key constraints, etc.)
    • Understanding indexes
  • Working with Data
    • Adding data using INSERT
    • Modifying data using UPDATE
    • Deleting data with DELETE
    • Understanding transactions and impacts of transactions on data manipulation
  • Simple Data Querying
    • Review of SELECT concepts
    • SELECTing rows of data
    • SELECTing columns of data
    • Filtering SELECT using WHERE
    • 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.
    • Character functions: ucase, lcase, etc.
    • Time functions: now, date, etc.
    • Other functions
  • Writing a Simple JDBC Application
    • What is JDBC?
    • Configuring Java to support JDBC
    • Writing a simple database query application
real world content

Real-World Content

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

Expert Practitioners

Industry experts that bring their battle scars into the classroom.
experiential learning

Experiential Learning

More coding than lecture, coupled with architectural and design discussions.
tailored outlines

Tailored Outlines

One-size-fits-all doesn't apply to training teams. That's where we come in!
“I appreciated the instructor's technique of writing live code examples rather than using fixed slide decks to present the material.”

VMware

Dive in and learn more

When transforming your workforce, it's important to have expert advice and tailored solutions. We can help. Tell us your unique needs and we'll explore ways to address them.

Let's chat

By filling out this form and clicking submit, you acknowledge our privacy policy.