O'Reilly logo
live online training icon Live Online training

SQL Interactive Workshop for Any IT Professional

Master the Basics of SQL and the Relational Database

Topic: Data
Ryan Stephens

The Relational Database is one of the most widely used database models today and has dominated the market for several decades with no end in sight. Every organization, and individual, rely on data, and learning and perfecting the skills to effectively design a database will take you and your organization to the next level. Whether new to the IT field, a seasoned professional, or any stakeholder in an organization who works with data, this course is for you.

You will expand upon the fundamentals of the SQL and the Relational Database, and how to effectively interact with a database to effectively store data, protect the integrity of data, increase functionality and relevancy of data for all users, and improve overall performance. This is a hands-on workshop and you will practice all of the fundamentals of standard SQL with interactive workshops to explore your database, perform basic queries, create database objects, manipulate data, and progress to more advanced queries. The concepts learned and practiced in this class coincide with the SQL for Any IT Professional class, which is a recommended prerequisite, or a basic understanding of SQL. After this interactive class, you will be able to begin applying skills learned immediately to work more effectively with databases and SQL, become more well-rounded as an IT professional, and ultimately contribute to your organization’s overall success. This class focuses on standard SQL and is mostly dependent of any vendor database software products.

What you'll learn-and how you can apply it

  • Review the basic fundamentals of the relational database and its role in today’s organization
  • Review the basic fundamentals of SQL, the standard language used to communicate with any relational database
  • Effectively store and retrieve data in a relational (SQL) database through interactive hands-on exercises
  • Explore advanced features of the SQL language to get more out of your database through interactive exercises

This training course is for you because...

  • Anyone early in their career or role in working with databases will benefit from taking this course.
  • IT professional, functional user, manager, or any user or stakeholder in the business that works with data.
  • While there’s a focus on technical aspects and syntax of SQL, there’s also coverage of the basics, so that professionals who just want a better handle on how relational databases add value will benefit.

Prerequisites

  • Basic understanding or familiarity with SQL database language.
  • SQL experience is a plus, but not required.

Recommended Preparation

  • Complete the setup instructions here

  • Live Online Training: SQL for Any IT Professional by Ryan Stephens (Search the O’Reilly Learning Platform for an upcoming date)

  • Book: SQL in 24 Hours, Sams Teach Yourself, 6th Ed by Ryan Stephens, Arie Jones, Ron Plew

Recommended Follow-up

  • Live Online Training: Database Design for Any IT Professional by Ryan Stephens (Search the O’Reilly Learning Platform for an upcoming date)
  • Book: SQL in 24 Hours, Sams Teach Yourself, 6th Ed by Ryan Stephens, Arie Jones, Ron Plew

About your instructor

  • Ryan Stephens is the President/CEO of Perpetual Technologies, Inc. (PTI) and Indy Data Partners, Inc. (IDP). PTI provides database and IT services to defense and federal government clients, and IDP specializes in database administration and development using mainly Oracle and SQL Server in the private sector. Ryan has been an entrepreneur for more than 21 years, and built his career around the SQL standard language and data management. Ryan has previously authored and taught 20 database-related classes for Indiana University-Purdue University in Indianapolis, and has authored several SQL, database, and Oracle-related books for Pearson Education, some of which are internationally published. The most current book, Teach Yourself SQL in 24 Hours, 6th Edition, was first published in 1998 and has been kept up to date with the evolving standard of SQL. Ryan has been nominated for the Ernst and Young Entrepreneur of the Year twice, and PTI was the first veteran-owned company to receive the Secretary of Defense Freedom Award in 2011. Ryan continues to strive to contribute his expertise to organizations seeking to improve competitive advantage by designing and using data more effectively.

Schedule

The timeframes are only estimates and may vary according to how the class is progressing

Setting the Stage (60 mins)

  • Overview of the Relational Database
  • Overview of SQL and Components Used in this Class
  • Exploring the Database Used in this Class
  • Getting Set Up for Live Examples
  • Exercise
  • Exercise Review
  • Exploring Your Database with Basic SQL Commands
  • Showing Your User Catalog
  • Describing Your Tables
  • Looking at the Data in Your Tables
  • Adding Tables to Your Database
  • Changing the Structure of Existing Tables
  • Exercise
  • Exercise Review

Break (5 minutes)

Manipulating Data in Your Database (60 mins)

  • Transactional Control
  • Joining Multiple Tables in Queries
  • Avoiding the Cartesian Product
  • Equi Joins
  • Non-equi Joins
  • Asking the Right Questions
  • Exercise
  • Exercise Review
  • Getting More Out of Your Data
  • Using Functions Effectively
  • Grouping Data
  • Composite Queries
  • Exercise
  • Exercise Review

Break (5 minutes)

More Advanced Queries (60 mins)

  • Creating Tables from Existing Tables
  • Inserting Data into a Table from Another Table
  • Working with Views
  • Working with Subqueries
  • Using Subqueries in DML
  • Using SQL to Generate SQL
  • Exercise
  • Exercise Review
  • More Challenging Queries and Exercises
  • Exercise
  • Exercise Review
  • Final Q&A
  • Course wrap-up and next steps