Introduction to SQL

Introduction to Structured Query Language Programming

The Introduction to SQL training course explores key concepts, techniques, and commands necessary for developers and system administrators to effectively write queries against common SQL databases, like MySQL.

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.

Course Summary

Purpose: 
Learn the core concepts of SQL.
Audience: 
Developers, System Administrators, and DevOps engineers needing to understand the core SQL concepts required to write database queries.
Skill Level: 
Learning Style: 

Hands-on training is customized, instructor-led training with an in-depth presentation of a technology and its concepts, featuring such topics as Java, OOAD, and Open Source.

Hands On help
Duration: 
3 Days
Productivity Objectives: 

Upon completion of this course, you should be able to:

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

Introduction to SQL is part of the MySQL Training curriculum.

What 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
    • Database design process
    • Overview of Database Normalization
  • Introduction to MySQL
    • Downloading & Installing MySQL
    • Configuring MySQL
    • Basic MySQL administration
    • Connecting to MySQL
    • Quick introduction to SELECT
  • Working with Tables
    • 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
  • Q/A

Meet Your Instructor

Steve Photo
Steve

Steve, a consultant and database administrator, has over 20 years of practical experience with Oracle, Sybase and SQL Server. He is certified in Oracle version 8 through 11g and is a charter member of the Nebraska Oracle User Group. He also holds a MCITP SQL Server DBA/Developer certification, Linux certification and a Real Application Clusters (RAC) certification.

Steve has...

Meet Steve »
Peter picture
Peter

Peter started programming before he learned how to use a keyboard properly, after messing around with a Commodore 64, BASIC, and a few cassette tapes.

Starting in the late 1990’s Peter became a passionate contributor to the open source community. As an active participant he has submitted bug fixes and new features to several projects and has released many of his own software packages as open source.

In 2006 Peter left upper management and became a freelance software...

Meet Peter »

Contact us to learn more

Not all training courses are created equal. Let the customization process begin! We'll work with you to design a custom Introduction to SQL training course that meets your specific needs.

DevelopIntelligence has been in the technical/software development learning and training industry for nearly 20 years. We’ve provided learning solutions to more than 48,000 engineers, across 220 organizations worldwide.

About Develop Intelligence
Di Clients

surveyask

Need help finding the right learning solution?   Call us: 877-629-5631