Introduction to SQL Programming Basics (Oracle Edition) (TTSQL002) Training in Spain

  • Learn via: Online Instructor-Led / Classroom Based / Onsite
  • Duration: 3 Days
  • Price: From €2,600+VAT
  • Upcoming Date:
  • UK Based Global Training Provider
Explore RDBMS Basics, SQL Language and Tools Essentials, Querying Basics, ASNI Joins, Functions & More

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. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases.

SQL Programming Basics is a hands-on, essentials-level course that provides you with basic practical experience with Relational Databases (Oracle), SQL essentials, basic querying, working with regular expressions and basic analytics.  In order to be successful in the hands-on portion of the training, it would be helpful to have some prior scripting or exposure and a high-level understanding of databases.  We can tailor this agenda to suit your incoming skill level and needs. Please inquire for details.



Who Should Attend?

Business Analysts, End Users, Developers, DBAs

We can organize this training at your preferred date and location. Contact Us!

Prerequisites

This is an introductory- level SQL course, appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators. Basic computer and IT skills are required, as well as basic knowledge of databases.

What You Will Learn

Working in a hands-on learning environment led by our expert practitioner, attendees will explore:

  • Basic RDBMS Principles
  • The SQL Language and Tools
  • Using SQL Developer
  • SQL Query Basics
  • WHERE and ORDER BY
  • Functions
  • ANSI 92 Joins
  • ANSI 99 Joins
  • GROUP BY and HAVING
  • Subqueries
  • Regular Expressions
  • Analytics

Training Outline

  1. Basic RDBMS Principles
  • Relational design principles
  • Accessing data through a structured query language
  • Entity relationship diagrams
  • Data Domains
  • Null values
  • Indexes
  • Views
  • Denormalization
  • Data Model Review
  1. The SQL Language and Tools
  • Using SQL*Plus
  • Why Use SQL*Plus When Other Tools Are Available?
  • Starting SQL*Plus
  • EZConnect
  • SQL Commands
  • PL/SQL Commands
  • SQL*Plus Commands
  • The COLUMN Command
  • The HEADING Clause
  • The FORMAT Clause
  • The NOPRINT Clause
  • The NULL Clause
  • The CLEAR Clause
  • Predefined define variables
  • SQL
  • Command history
  • Copy and paste in SQL*Plus
  • Entering SQL commands
  • Entering PL/SQL commands
  • Entering SQL*Plus commands
  • Default output from SQL*Plus
  • Entering Queries
  • What about PL/SQL?
  1. Using SQL Developer
  • Choosing a SQL Developer version
  • Configuring connections
  • Creating A Basic Connection
  • Creating A TNS Connection
  • Connecting
  • Configuring preferences
  • Using SQL Developer
  • The Columns Tab
  • The Data Tab
  • The Constraints Tab
  • The Grants Tab
  • The Statistics Tab
  • Other Tabs
  • Queries In SQL Developer
  • Query Builder
  • Accessing Objects Owned By Other Users
  • The Actions Pulldown Menu
  • Differences between SQL Developer and SQL*Plus
  • Reporting Commands Missing In SQL Developer
  • General Commands Missing In SQL Developer
  • Data Dictionary report
  • User Defined reports
  • Using scripts in SQL Developer
  1. SQL Query Basics
  • Understanding the data dictionary
  • Exporting Key Data Dictionary Information
  • The Dictionary View
  • Components of a SELECT Statement
  • The SELECT Clause
  • The FROM Clause
  • The WHERE Clause
  • The GROUP BY Clause
  • The HAVING Clause
  • The ORDER BY Clause
  • The START WITH And CONNECT BY Clauses
  • The FOR UPDATE Clause
  • Set Operators
  • Column Aliases
  • Fully Qualifying Tables and Columns
  • Table Aliases
  • Using DISTINCT and ALL in SELECT statements
  1. WHERE and ORDER BY
  • WHERE clause basics
  • Comparison operators
  • Literals and Constants in SQL
  • Simple pattern matching
  • Logical operations
  • The DUAL table
  • Arithmetic operations
  • Expressions in SQL
  • Character operators
  • Pseudo columns
  • Order by clause basics
  • Ordering Nulls
  • Accent and case sensitive sorts
  • Sampling data
  • WHERE and ORDER BY in SQL Developer
  • All, Any, Some
  1. Functions
  • The basics of Oracle functions
  • Number functions
  • Character functions
  • Date functions
  • Conversion functions
  • Other functions
  • Large object functions
  • Error functions
  • The RR format mode;
  • Leveraging your knowledge
  1. ANSI 92 JOINS
  • Basics of ANSI 92 Joins
  • Using Query Builder with multiple tables
  • Table Aliases
  • Outer joins
  • Outer Joins In Query Builder
  • Set operators
  • Self-referential joins
  • Non-Equijoins
  1. ANSI 99 Joins
  • Changes with ANSI99
  • CROSS Join
  • NATURAL Join
  • JOIN USING
  • JOIN ON
  • LEFT / RIGHT OUTER JOIN
  • FULL OUTER JOIN
  1. GROUP BY and HAVING
  • Introduction to GROUP functions Limiting Rows
  • Including NULL
  • Using DISTINCT With Group Functions
  • GROUP function requirements
  • The HAVING clause
  • Other GROUP function rules
  • Using Query Builder with GROUP clauses
  • ROLLUP and CUBE
  • The Grouping function
  • Grouping Sets
  1. Subqueries
  • Why use subqueries?
  • WHERE clause subqueries
  • FROM clause subqueries
  • HAVING clause subqueries
  • CORRELATED subqueries
  • SCALAR subqueries
  • DML and subqueries
  • EXISTS subqueries
  • Hierarchical queries
  • TOP N AND BOTTOM N queries
  • Creating subqueries using Query Builder
  • Lab: Subqueries
  1. Regular Expressions
  • Available Regular Expressions
  • Regular Expression Operators
  • Character Classes
  • Pattern matching options
  • REGEX_LIKE
  • REGEXP_SUBSTR
  • REGEXP_INSTR
  • REGEXP_REPLACE
  • REGEXP_COUNT
  1. Analytics
  • The WITH clause
  • Reporting aggregate functions
  • Analytical functions
  • User-Defined bucket histograms
  • The MODEL clause
  • PIVOT and UNPIVOT
  • Temporal validity
  1. More Analytics
  • RANKING functions
  • RANK
  • DENSE_RANK
  • CUME_DIST
  • PERCENT_RANK
  • ROW_NUMBER
  • Windowing aggregate functions
  • RATIO_TO_REPORT
  • LAG / LEAD
  • Linear Regression functions
  • Inverse Percentile functions
  • Hypothetical ranking functions
  • Pattern Matching

Why Choose Us

Experience Introduction to SQL Programming Basics (Oracle Edition) (TTSQL002) in Spain through Bilginç IT Academy's live and interactive virtual classroom environment, accessible from your home, office, or any location. Connect with expert trainers in real time and bring the energy of classroom learning into the digital experience.

  • Live Instructor-Led Sessions: Join scheduled training sessions with your instructor and fellow delegates in real time.
  • Interactive Learning Experience: Take part in discussions, practical exercises, group activities, and Q&A sessions throughout the course.
  • Expert Trainer Network: Learn from experienced trainers with strong industry backgrounds and practical field expertise.
  • Over 30 Years of Training Expertise: Benefit from Bilginç IT Academy's long-standing experience in delivering professional training since 1995.
  • Flexible and Scalable Delivery: Access live virtual classrooms from Spain and worldwide, with flexible planning options for individual and corporate training needs.

Experience Introduction to SQL Programming Basics (Oracle Edition) (TTSQL002) in a focused classroom environment in Spain. Bilginç IT Academy's carefully selected training venues provide a professional setting where delegates can interact directly with expert trainers and peers.

  • Experienced Trainers: Learn from specialists with extensive field experience and real-world knowledge.
  • Professional Training Venues: Attend courses in comfortable, well-equipped classrooms designed to support effective learning.
  • Focused Classroom Experience: Benefit from limited class sizes that encourage discussion, interaction, and personalized support.
  • Quality-Driven Learning: Develop practical skills through structured, up-to-date, and professionally designed training content.

Meet your team's training needs with Bilginç IT Academy's onsite Introduction to SQL Programming Basics (Oracle Edition) (TTSQL002) in Spain solution, delivered at your office or preferred location. Align your team's development with your business goals through a training experience tailored to your organization.

  • Tailored Course Content: Adapt the training program to your organization's projects, team structure, and specific business requirements.
  • Time and Cost Efficiency: Reduce travel, accommodation, and operational costs while maximizing the value of your training investment.
  • Team-Focused Learning: Help your employees develop around the same knowledge base and strengthen collaboration across your organization.
  • Simplified Planning and Tracking: Manage the training process, participant development, and organizational requirements with greater control.


Contact us for more detail about our trainings and for all other enquiries!

Introduction to SQL Programming Basics (Oracle Edition) (TTSQL002) Training Course in Spain Schedule

Join our public courses in our Spain facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

We can organize this training at your preferred date and location.
09 julio 2026 (3 Days)
Madrid, Barcelona, Valencia, Seville
€2,600 +VAT
11 julio 2026 (3 Days)
Madrid, Barcelona, Valencia, Seville
€2,600 +VAT
15 julio 2026 (3 Days)
Madrid, Barcelona, Valencia, Seville
€2,600 +VAT
26 julio 2026 (3 Days)
Madrid, Barcelona, Valencia, Seville
€2,600 +VAT
06 agosto 2026 (3 Days)
Madrid, Barcelona, Valencia, Seville
€2,600 +VAT
12 agosto 2026 (3 Days)
Madrid, Barcelona, Valencia, Seville
€2,600 +VAT
26 agosto 2026 (3 Days)
Madrid, Barcelona, Valencia, Seville
€2,600 +VAT
02 septiembre 2026 (3 Days)
Madrid, Barcelona, Valencia, Seville
€2,600 +VAT

Spain has rapidly transformed into one of Europe's most vibrant technology ecosystems, with Madrid, Barcelona, and Valencia emerging as major global innovation hubs. The country is home to prestigious institutions like the Polytechnic University of Catalonia and IE Business School, which fuel the growth of sectors ranging from telecommunications to renewable energy tech. As a leading destination for digital nomads and multinational tech headquarters, Spain prioritizes digital literacy and high-level software engineering skills. Our training programs in Spain are designed to support this flourishing market, providing certifications in Cloud Computing, Cybersecurity, and Data Science. We help professionals across the Iberian Peninsula stay ahead of industry trends and drive the digital transformation of Spain’s increasingly diversified and high-tech economy.

By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.