Introduction to Writing SQL Queries (TTSQL003)

Introduction to Writing SQL Queries is a three-day, hands-on course that provides you with the skills and experienced required to use SQL to efficiently organize, retrieve, analyze, and manipulate data to deliver insightful reports, inform strategic decisions, and optimize various aspects of any business. Each module introduces critical concepts and practices, providing you with the knowledge to streamline your data management tasks.SQL is the cornerstone of all relational database operations. In this hands-on course, you learn to exploit the full potential of the SELECT statement to write robust queries using the best query method for your application, test your queries, and avoid common errors and pitfalls.  Mastering the art of restricting and sorting data enables you to customize your queries, displaying only what’s essential and presenting it in a meaningful order. Understanding single-row functions and conversion functions helps optimize data handling by transforming and converting data types as needed. Lastly, by unraveling the mysteries of SQL joins, group functions, and subqueries, you’ll acquire the ability to aggregate data, combine data from multiple tables, and conduct complex queries with ease.

  • Price: $1,995.00
  • Duration: 3 days
  • Delivery Methods: Virtual
DateTimePriceOption
04/14/202509:00 AM - 05:00 PM CT$1,995.00
06/16/202509:00 AM - 05:00 PM CT$1,995.00
08/18/202509:00 AM - 05:00 PM CT$1,995.00
10/20/202509:00 AM - 05:00 PM CT$1,995.00
12/08/202509:00 AM - 05:00 PM CT$1,995.00
For questions call: (469) 721-6100
Find More Training

Why choose TOPTALENT?

  • Get assistance every step of the way from our Texas-based team, ensuring your training experience is hassle-free and aligned with your goals.
  • Access an expansive range of over 3,000 training courses with a strong focus on Information Technology, Business Applications, and Leadership Development.
  • Have confidence in an exceptional 95% approval rating from our students, reflecting outstanding satisfaction with our course content, program support, and overall customer service.
  • Benefit from being taught by Professionally Certified Instructors with expertise in their fields and a strong commitment to making sure you learn and succeed.

Please note that this list of topics is based on our standard course offering, evolved from typical industry uses and trends. We’ll work with you to tune this course and level of coverage to target the skills you need most. Topics, agenda and labs are subject to change, and may adjust during live delivery based on audience needs, participation and skill-level.

  1. Introduction: Quick Tools Review
  • Introduction to SQL and its development environments
  • Using SQL*PLUS
  • Using SQL Developer
  1. Using the SQL SELECT Statement
  • Capabilities of the SELECT statement
  • Arithmetic expressions and NULL values in the SELECT statement
  • Column aliases
  • Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
  • Use of the DESCRIBE command
  1. Restricting and Sorting Data
  • Limiting the Rows
  • Rules of precedence for operators in an expression
  • Substitution Variables
  • Using the DEFINE and VERIFY command
  1. Single-Row Functions
  • Describe the differences between single row and multiple row functions
  • Manipulate strings with character function in the SELECT and WHERE clauses
  • Manipulate numbers with the ROUND, TRUNC and MOD functions
  • Perform arithmetic with date data
  • Manipulate dates with the date functions
  1. Conversion Functions and Expressions
  • Describe implicit and explicit data type conversion
  • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  • Nest multiple functions
  • Apply the NVL, NULLIF, and COALESCE functions to data
  • Decode/Case Statements
  1. Using the Group Functions and Aggregated Data
  • Group Functions
  • Creating Groups of Data
  • Having Clause
  • Cube/Rollup Clause
  1. SQL Joins and Join Types
  • Introduction to JOINS
  • Types of Joins
  • Natural join
  • Self-join
  • Non equijoins
  • OUTER join
  1. Using Subqueries
  • Introduction to Subqueries
  • Single Row Subqueries
  • Multiple Row Subqueries

OPTIONAL / TIME-PERMITTING

The following chapters are included in your course materials, and will be covered time-permitting, depending on the skill level and interests of the attendees.

  1. Using the SET Operators
  • Set Operators
  • UNION and UNION ALL operator
  • INTERSECT operator
  • MINUS operator
  • Matching the SELECT statements
  1. Using Data Manipulation Language (DML) statements
  • Data Manipulation Language
  • Database Transactions
  • Insert
  • Update
  • Delete
  • Merge
  1. Using Data Definition Language (DDL)
  • Data Definition Language
  • Create
  • Alter
  • Drop
  1. Data Dictionary Views
  • Introduction to Data Dictionary
  • Describe the Data Dictionary Structure
  • Using the Data Dictionary views
  • Querying the Data Dictionary Views
  • Dynamic Performance Views

Learning Objectives

This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises.  Working in a hands-on learning environment led by our expert practitioner, you’ll learn to:

  • Maximize the potential of SQL to build powerful, complex and robust SQL queries
  • Query multiple tables with inner joins, outer joins and self joins
  • Learn the art of data conversion and manipulation:
  • Delve into SQL joins, group functions, and subqueries: Construct recursive common table expressions
  • Summarize data using aggregation and grouping
  • Execute analytic functions to calculate ranks
  • Build simple and correlated subqueries
  • Thoroughly test SQL queries to avoid common errors
  • Select the most efficient solution to complex SQL problems

This is an introductory- level course appropriate for those who are developing applications using relational databases, or who are using SQL to extract and analyze data from databases and need to use the full power of SQL queries. In order to benefit from the hands-on labs, attendees should have prior experience in scripting or programming languages.

This is an introductory- level course appropriate for those who are developing applications using relational databases, or who are using SQL to extract and analyze data from databases and need to use the full power of SQL queries. In order to benefit from the hands-on labs, attendees should have prior experience in scripting or programming languages.

Ten (10) business days’ notice is required to reschedule a class with no additional fees. Notify TOPTALENT LEARNING as soon as possible at 469-721-6100 or by written notification to info@toptalentlearning.com to avoid rescheduling penalties.

Please contact our team at 469-721-6100; we will gladly guide you through the online purchasing process.

You will receive a receipt and an enrollment confirmation sent to the email you submitted at purchase. Your enrollment email will have instructions on how to access the class. Any additional questions our team is here to support you. Please call us at 469-721-6100.

If a student is 15 minutes late, they risk losing their seat to a standby student. If a student is 30 minutes late or more, they will need to reschedule. A no-show fee will apply. Retakes are enrolled on a stand-by basis. The student must supply previously issued courseware. Additional fees may apply.

You will receive a ‘Certificate of Completion’ once you complete the class. If you purchased an exam voucher for the class, a team member from TOPTALENT LEARNING will reach out to discuss your readiness for the voucher and make arrangements to send it.