O'Reilly logo
live online training icon Live Online training

SQL for Any IT Professional

Ryan Stephens

SQL is the standard language used to communicate with any relational database. In this fast-paced introductory course, any IT professional needing to learn SQL will be exposed to all of its basic components. This course touches on database design basics, and all of the major elements of SQL, and is packed with practical examples of commands and uses. Like the language of any country and its importance to navigate within a community, a practical knowledge of SQL will help most any IT professional work effectively within the database community, work better together, provide better customer support, and communicate more effectively within an organization, whether an application developer, database administrator, business analyst, data analyst, or any other professional working with relational databases. After participating in this course, the IT professional should be able to quickly apply SQL concepts to the database implementation and information systems at use in their organization. This class will provide an overall understanding of standard SQL capabilities for both technical and non-technical professionals in the database community.

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

  • Understand the basics of relational database and their applications in today’s world
  • Understand the roles and relationships between various users in the database community
  • Learn the basics of database design
  • Explore how SQL is used in today’s organizations and applications
  • Learn all of the basic components of SQL
  • Learn how to create basic tables and indexes
  • Use SQL commands to insert and manipulate data in tables
  • Understand transactional control
  • Learn the basics of the database query
  • Scratch the surface of several advanced features of queries
  • Ensure effective use of data, pulling clean, accurate, and complete data from the database

This training course is for you because...

Anyone IT professional who is early in his or her career, or anyone finding themselves working with databases will benefit from taking this course. This course will be beneficial for an IT professional or a business analyst responsible for maintaining/reporting business data and needing to use SQL to perform their role. This course is also valuable for professionals who are not technical, but seek a better understanding of databases, so that they can maximize their value within their organization.

Prerequisites

  • A general understanding of what SQL is, and/or in general how companies might use SQL.

Recommended Preparation:

Recommended Follow-up

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

Understanding the basics (20 minutes) - Understanding user communities of data, their relations, and database interaction - Introduction to today’s relational database and applications - SQL in all types of applications - SQL: the standard database language - Popular vendor implementations of SQL - Overview of standard SQL components - Basic relational database design principles

Practical application of basic SQL concepts (25 minutes)
- SQL: Database design language (DDL) basics - Thinking through a simple database design - Normalizing your design - Creating your tables - Creating indexes

Q&A (10 minutes)

Break (5 minutes)

Transactions: overview of managing data (20 minutes) - SQL: Data manipulation language (DML) - Inserting data into tables - Updating table data - Deleting table data - Transactional control commands

Getting data out of a database (25 minutes)
- Introduction to the query - “Asking” for information: SQL language in plain English - SQL: Data query language (DQL) - SELECT: Writing the simplest SQL query - Querying the database using specific criteria - Ordering the data set returned by your query

Q&A (10 minutes)

Break (5 minutes)

Getting more out of your SQL queries (15 minutes) - Comparison operators - Logical operators - Conjunctive operators - Negative operators - Arithmetic operators

Scratching the surface of advanced queries (30 minutes) - Selecting data from multiple tables using joins - Functions: looking at data from different perspectives - Using subqueries to define unknown criteria - Creating views to build subsets of data and increase performance - Summarizing and grouping data

Final tips (5 minutes) - Knowing how to ask the right questions - Making sure your data is accurate, clean, and complete - Managing a growing database

Q&A (10 minutes)