A company’s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases – with little room for error. When databases aren’t built or maintained correctly, it’s easy to mishandle or lose valuable data.
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.
You’ll leave this course equipped with a firm understanding of SQL and its real-world application, helping you better organize, analyze, and manipulate data in your professional role. You’ll be ready to contribute to improving data management processes, enhancing efficiency, and providing actionable insights within your organization. You will be able to streamline data-related tasks, improve data quality, and contribute to data-driven decision-making processes.
NOTE: This course uses SQL Developer. SQL Developer is not the focus of the course, but rather the platform for learning the SQL querying skills. Students are NOT required to have prior experience with SQL Developer. All tools are provided in our easy-access, no-install required, cloud-based environment.
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:
Audience
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.
Introduction: Quick Tools Review
Using the SQL SELECT Statement
Restricting and Sorting Data
Single-Row Functions
Conversion Functions and Expressions
Using the Group Functions and Aggregated Data
SQL Joins and Join Types
Using 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.
Using the SET Operators
Using Data Manipulation Language (DML) statements
Using Data Definition Language (DDL)
Data Dictionary Views
None
Course Comments
NOTE: This training is NOT Official Oracle University training. This is independent, adjustable content that aligns with current topics, skills and tools that participants need to excel in these areas.
Upcoming Classes
September 09, 2024
October 28, 2024
December 09, 2024