Skill Up Card - Course Bundles

Save up to €4,145 per delegate.

skill up card logo - Nexus Human

Introduction to Writing SQL Queries (TTSQL003)

4.6 out of 5 rating Last updated 23/07/2024   English

Jump to outline

Global Schedule

GTR = Guaranteed to Run

09 Sep 24 Enquire Book
15:00 - 23:00 Live Online 1,795
09 Dec 24 Enquire Book
15:00 - 23:00 Live Online 1,795

22 Jul 24 Enquire Book
15:00 - 23:00 Live Online 1,795
28 Oct 24 Enquire Book
14:00 - 22:00 Live Online 1,795

Find out more about this course

Interested in alternative dates? Would like to book a private session of this course for your company? Or for any other queries please simply fill out the form below.

Duration

3 Days

18 CPD hours

Overview

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

Description

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.

Prerequisites

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 Introduction to SQL and its development environments Using SQL*PLUS Using SQL Developer 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 Restricting and Sorting Data Limiting the Rows Rules of precedence for operators in an expression Substitution Variables Using the DEFINE and VERIFY command 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 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 Using the Group Functions and Aggregated Data Group Functions Creating Groups of Data Having Clause Cube/Rollup Clause SQL Joins and Join Types Introduction to JOINS Types of Joins Natural join Self-join Non equijoins OUTER join 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. Using the SET Operators Set Operators UNION and UNION ALL operator INTERSECT operator MINUS operator Matching the SELECT statements Using Data Manipulation Language (DML) statements Data Manipulation Language Database Transactions Insert Update Delete Merge Using Data Definition Language (DDL) Data Definition Language Create Alter Drop 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
Additional course details:

Nexus Humans Introduction to Writing SQL Queries (TTSQL003) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward.

This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.

Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.

While we feel this is the best course for the ITS Data Analytics course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

FAQ for the Introduction to Writing SQL Queries (TTSQL003) Course

Available Delivery Options for the Introduction to Writing SQL Queries (TTSQL003) training.
  • Live Instructor Led Classroom Online (Live Online)
  • Traditional Instructor Led Classroom (TILT/ILT)
  • Delivery at your offices in London or anywhere in the UK
  • Private dedicated course as works for your staff.
How many CPD hours does the Introduction to Writing SQL Queries (TTSQL003) training provide?

The 3 day. Introduction to Writing SQL Queries (TTSQL003) training course give you up to 18 CPD hours/structured learning hours. If you need a letter or certificate in a particular format for your association, organisation or professional body please just ask.

Which exam does the Introduction to Writing SQL Queries (TTSQL003) training course prepare you for?

The Introduction to Writing SQL Queries (TTSQL003) prepares you for the Yes official exam. You can take this exam at any exam center across Ireland including, Dublin, Cork, Galway, Northern Ireland or live online where ever you are. Exams vary in duration and if required you can request with the provider for any accommodations appropriate for you.

What is the correct audience for the Introduction to Writing SQL Queries (TTSQL003) training?

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.

Do you provide training for the Introduction to Writing SQL Queries (TTSQL003).

Yes we provide corporate training, dedicated training and closed classes for the Introduction to Writing SQL Queries (TTSQL003). This can take place anywhere in Ireland including, Dublin, Cork, Galway, Northern Ireland or live online allowing you to have your teams from across Ireland or further afield to attend a single training event saving travel and delivery expenses.

What is the duration of the Introduction to Writing SQL Queries (TTSQL003) program.

The Introduction to Writing SQL Queries (TTSQL003) training takes place over 3 day(s), with each day lasting approximately 8 hours including small and lunch breaks to ensure that the delegates get the most out of the day.

What other terms do people search for when looking for this course?

Popular related searched include SQL Querying.

Why are Nexus Human the best provider for the Introduction to Writing SQL Queries (TTSQL003)?
Nexus Human are recognised as one of the best training companies as they and their trainers have won and hold many awards and titles including having previously won the Small Firms Best Trainer award, national training partner of the year for Ireland on multiple occasions, having trainers in the global top 30 instructor awards in 2012, 2019 and 2021. Nexus Human has also been nominated for the Tech Excellence awards multiple times. Learning Performance institute (LPI) external training provider sponsor 2024.
Is there a discount code for the Introduction to Writing SQL Queries (TTSQL003) training.

Yes, the discount code PENPAL5 is currently available for the Introduction to Writing SQL Queries (TTSQL003) training. Other discount codes may also be available but only one discount code or special offer can be used for each booking. This discount code is available for companies and individuals.

Jump to dates

Training Insurance Included!

When you organise training, we understand that there is a risk that some people may fall ill, become unavailable. To mitigate the risk we include training insurance for each delegate enrolled on our public schedule, they are welcome to sit on the same Public class within 6 months at no charge, if the case arises.

What people say about us


Top