Learn Basic DB2 on Mainframe for Beginners
Understand the DDL and DML operations on DB2.
4.46 (1122 reviews)
15,731
students
1.5 hours
content
Apr 2022
last update
FREE
regular price
What you will learn
Students will be able to create tables and views. By the end of the course, students will be able to perform the basic the DDL and DML operations in DB2.
Why take this course?
Note:
This Course is NOT a DB2 DBA COURSE and is not related to Database administration.
The Course provides the basic introduction to DB2 and trains on the DML operations on
Mainframe. Most of the DDL operations on DB2 are carried out by DB2 DBA and this course
gives a brief introduction of DDL operations which Mainframe Developer should be aware of.
Why should I Learn DB2 on Mainframe?
- Most of the projects on IBM Mainframe requires DB2 Knowledge.
- Most of the Projects uses COBOL DB2 Programs.
- If you know DB2 , it adds value to your career and resume.
Is this Course for DB2 DBA?
No, this Course is for Developers who work on IBM Mainframe. This Course covers major DDL operations from developers point of view(not DBA's Point of view). Major DML operations are also covered. Please do not worry, if you do not know what is DDL and what is DML. This is covered in the course.
Which topics are covered in this Course?
- This Course Covers all DML operations for Mainframe Developers.
- Students will get trained on how to create a table, view and index.
- The Course teaches you - How to Insert records into table, update records, select the records from the table
Screenshots
Reviews
Mootoosamy
April 15, 2024
The explanation was simple and easy to follow. However, it's the interface where to run those operations that was confusing. I don't really know the various commands being used. Maybe a quick mention that for mainframe, there is such a command-line interface to interact with the storage group/database.
Chen
March 19, 2024
The most important thing in this tutorial for me is how to get into the DB2 screen and execute those sqls wrote in the input file. I did not mean SQL stuff is not valuable but for some guys who had relevant experience, they could skip this part.
Michael
January 18, 2024
Reference to wiki pages can (imo) not be considered professional. Presentations contains mistakes (e.g. Section Hierarchy where Storagegroup - Database relation is not really correct in naming) and missis slides (e.g. relation table - row - column is explained but slide explaining storage group - database - tablespace is used).
Seems like preparation of videos was done on-demand.
Basically a SQL tutorial, which could have been mentioned in the title. Or SQL could have been explicitely mentioned and explained.
Brian
March 27, 2023
I wish there was more about DB2. It was extremely high level DB2 info. Majority of the training was on basic SQL syntax. Probably should have been called introduction to SQL not Basic DB2.
Terrence
March 17, 2023
So far it's been pretty good. Having worked with Oracle, Sybase and SQL Manager, it's a bit of a refresher in the opening.
Jorge
March 8, 2023
Great course that covers the basics of DB2 in a very complete way! I will recommend this course to others.
NOMNDENI
December 7, 2022
i enjoyed the course and now i have a better understanding of db but i think i need to do more course on db
Mohinuddin
June 20, 2022
The course was very comprehensive and easy to understand. Giving the information in a way that won't make me confused. Thank you so much for this great course.!
Joan
February 14, 2022
Una buena introduccion muy interesante. Conciso, preciso y directo al grano. El profesor explica muy bien. Esta todo lo mas importante de los comandos SQL de DB2 contemplado.
Fernanda
February 1, 2022
I used to work in cobol 25 five years ago and this course started refreshing all that knowledge. very clear and simple
Esvanny
November 19, 2020
Explicación básica y detallada. Se entiende por la sencillez con la que habla el profesor.
Tomaría atención verificar los subtitulos en english ya que existen fallas en lo mostrado y se debería incluir traducción al español.
Hasta este momento cumple mis expectativas básicas.
Leonardo
July 31, 2020
Congratulations on the great course, excellent didactics and mainly the practice you develop in the course, which is fundamental in the course. I learned a lot and I am very satisfied with the result. Thank you. Leonardo Lima.Congratulations on the great course, excellent didactics and mainly the practice you develop in the course, which is fundamental in the course. I learned a lot and I am very satisfied with the result. Thank you. Leonardo Lima.
Raka
June 15, 2020
Terima kasih atas pengetahuan dasar db2, sangat menggambarkan untuk menjadi dasar pembelajaran berikutnya.
Alan
March 26, 2020
There were some errors in the legends. The english speaking of the instructor also dont help. But the content appear to be good to the database begginers. For me, the first 8 chapters where interesting, because I could learn how to operate the emulator.
Anindya
March 16, 2020
Explained nicely. Please update the content regularly because there are not much good content available in DB2 Mainframe.
Charts
Price
Rating
Enrollment distribution
Related Topics
1744036
udemy ID
6/12/2018
course created date
12/22/2019
course indexed date
Bot
course submited by