This course will introduce you to SQL (Structured Query Language), the standard language for requesting, modifying, and maintaining information in a relational database; you will learn the basics of SQL, such as the syntax (or rules) of using SQL and how to use SQL for database queries to answer business questions. You also will learn how to retrieve, group, filter, and summarize data, including information from multiple tables in a database.
See specific content information below in sections "Expected Outcomes" and "Attend and You Will Learn."
Who Should Attend
This course is designed for business analysts, information specialists, and application developers who need to write SQL data manipulation statements. You will learn ANSI/ISO standard SQL, with examples in SQL Server, Oracle, DB2 LUW and z/OS, MySQL, and Access, with emphasis on SQL Server and Oracle.
Attend and You Will Receive
Upon successful completion of this course, you will receive a certificate of completion from NC State University.
- Experience using the editor in which the class is taught: TSO/ISPF in an IBM mainframe environment, any version of Microsoft Windows, or other editor
- Experience with any programming or query language
- Basic knowledge of databases
Attend and You Will Learn / Expected Outcome
Individuals who successfully complete this course will understand and be able to use the basic functions of SQL.
Attend And You Will Learn
- Relational database concepts
- Overview of SQL: syntax, using editors
- Getting acquainted with the course database
- Selecting columns and expressions, using aliases
- Selecting from various objects, including tables and views
- Using a Where clause to narrow the search: comparisons
- including Between, In, and Like
- Sorting data with the Order By clause
Functions and Expressions
- Functions for handling nulls, character strings, numbers and date/time values
- Miscellaneous operators, including arithmetic and concatenation
- Case logic, using simple and searched variations
- Brief overview of transactions, commit, rollback, locking, column constraints, referential integrity, and identity keys
- Inserting rows
- Updating and merging rows
- Inner joins: traditional and ISO standard
- Outer joins
Subqueries and Unions
- Subqueries as alternatives to certain joins, using In and Exists
- Using Not In and Not Exists to find the difference of two sets of rows
- Set operators, including Union, Union All, Intersect and Minus/Except
- Aggregate functions, including Count, Max, Min, Sum, and Avg
- Using the Group By clause to summarize data
- Filtering groups with the Having clause
Applying SQL to Real-World Problems
- Techniques for understanding and solving the problem: re-wording, diagramming, using other people, using a systematic approach to writing SQL queries
- Final group lab
- Additional exercises for continued learning