Description
At Sixe Ingeniería we have been providing official IBM training around the world for more than 15 years. Get the best training from our specialists worldwide.
Course data
| IBM code: CE121GES / CE121G | Category / Subcategory: DB2 / SQL DB2 |
| Modality: Online and face-to-face | Duration in days: 2 |
Target Audience
This basic course is intended for anyone who needs to write, manage or understand SQL queries.
Intended participants include, but are not limited to, end users, programmers, application designers, database administrators and system administrators who do not yet have experience with SQL Data Manipulation Language (DML).
This course is operating system independent, you can use DB2 or Informix on z/OS, Windows, AIX or Linux.
Desired prerequisites:
To get the most out of this workshop, it is recommended that participants have:
- Basic computer skills: Familiarity with the use of operating systems and common applications.
- Basic editing skills: Ability to handle text editors.
- No previous database skills are required: This course is designed for those new to SQL and IBM DB2 or Informix.
Instructors
The vast majority of the IBM courses we offer are taught directly by our expert engineers.
This practice allows us to guarantee the highest quality of instruction.
We complement all training with internally developed materials and labs, based on our vast experience in deployments, migrations and courses over the years.
Value added
Our courses are deeply oriented to the specific role that each participant will play.
We recognize that the needs of a team of developers differ from those who deploy and manage the infrastructure.
Therefore, beyond teaching commands and tasks, we focus on solving the day-to-day problems of each team, providing them with the knowledge, competencies and skills necessary for their projects.
In addition, our documentation is updated and based on the latest version of each product.
Course agenda and syllabus
- Introduction: Fundamentals of DB2 and SQL language.
- Simple SQL queries: Creation and execution of basic queries.
- Retrieving data from multiple tables: Use of JOINs and table combinations.
- Scalar and Arithmetic Functions: Application of mathematical and text functions.
- Column and Grouping Functions: Data analysis and aggregation.
- UNION and UNION ALL statements: Combining results from multiple queries.
- Use of subqueries: Nesting of queries for complex tasks.
- Data maintenance: Inserting, updating and deleting data in the database.
This workshop offers a balanced combination of theory and practice, ensuring that participants gain a solid and applicable understanding of using SQL on IBM DB2 or Informix.
Sign up and take your IBM database skills to the next level!
Do you need to tailor this agenda to your needs? Interested in other courses? Contact us without obligation.
Locations for on-site delivery
- Austria: Vienna
- Belgium: Brussels, Ghent
- Denmark: Cophenhagen
- Estonia: Tallinn
- Finland: Helsinki
- France: Paris, Marseille, Lyon
- Germany: Berlin, Munich, Cologne, Hamburg
- Greece: Athens, Thessaloniki
- Italy: Rome
- Louxemburg: Louxembourg (city)
- Netherlands: Amsterdam
- Norway: Oslo
- Portugal: Lisbon, Braga, Porto, Coimbra
- Slovakia: Bratislava
- Slovenia: Bratislava
- Spain: Madrid, Sevilla, Valencia, Barcelona, Bilbao, Málaga
- Sweden: Stockholm
- Turkey: Ankara
- United Kingdom: London
- Asia: Singapore and Kuala Lumpur
