Description
IBM course code:CE031G
Delivery:Online, classroom or onsite
Duration:2 days (16 hours)
Platform:Cross-platform (z/OS, VM, Linux, UNIX, Windows, iSeries)
Who it is for:Non-technical profiles and developers who work with Db2 without administering it, and anyone needing the groundwork before an advanced Db2 z/OS or LUW course.
Recommended background:Basic data processing knowledge.
Delivery:Online, classroom or onsite
Duration:2 days (16 hours)
Platform:Cross-platform (z/OS, VM, Linux, UNIX, Windows, iSeries)
Who it is for:Non-technical profiles and developers who work with Db2 without administering it, and anyone needing the groundwork before an advanced Db2 z/OS or LUW course.
Recommended background:Basic data processing knowledge.
Who this course fits
- Project managers, presales and functional analysts who need to speak the same language as the DBA team.
- Developers who will work with Db2 without administering it.
- Onboarding before an advanced Db2 z/OS or LUW course.
Course content
- Relational databases: what a relation is, column data types, primary and foreign keys, referential integrity and triggers
- Data modelling and database design: business model, ERD diagrams
- How a Db2 user works: generating SQL statements, adding, removing and changing rows, reading data and reporting
- How a Db2 programmer works: SQL delimiters, SQLCA, program preparation, static versus dynamic SQL
- What a Db2 administrator does: installation, subsystems and instances, databases, tablespaces, authorisation and monitoring
- Distributed information management: remote and distributed unit of work, security and products that interoperate with Db2
Course agenda
- Day 1: understanding a table, data modelling, use from the user side
- Day 2: use from the programmer side, administrator tasks and distributed management
Training with SIXE, IBM Business Partner
- Labs on Db2 z/OS, LUW or iSeries, depending on where your team will write the SQL.
- Taught directly by IBM Champion instructors from the SIXE team.
- Credly badges available: credly.com/organizations/sixe/badges
- Flexible format — online, classroom or onsite — in closed groups, priced per attendee, in the language of your choice (ES / EN / FR).
Instructors specialised in IBM Db2
Engineers from the SIXE team with hands-on Db2 administration experience on z/OS and LUW. Several recognised as IBM Champion.
Frequently asked questions
Is it technical or business oriented?
Introductory but technical. Relational database concepts, basic SQL and what each role does — user, developer, DBA, architect. Nothing is installed or configured.
Does it work as groundwork for CV844G or CLA90G?
Yes. It covers the conceptual prerequisites of most Db2 courses, on z/OS and on LUW.
Can you deliver it at our premises?
Yes, and remotely with a live instructor too. Closed groups of four to ten people, in Spanish, English or French.
Related courses
- CE121G — Db2 SQL Workshop (the next step, to start writing SQL)
- CLA90G — Db2 12.1 Essentials for Relational DBAs (if the role is LUW administration)
- CV844G — Db2 12 for z/OS Basic DBA (if the role is mainframe administration)
