DB2 Tutorial For Beginners on Mainframe (Crash Course)

This video Covers DB2 for complete Beginners. We explain - What is DB2, Various Data types in DB2, DDL statements like CREATE, ALTER, etc, DML statements like INSERT, SELECT, etc, and there are a lot of DB2 commands with examples. We will also master DB2 SQL commands like DELETE, DROP, and a lot of other commands in this DB2 tutorial for Beginners.
In short, we will master the Basics of DB2 on Mainframe. I will be using IBM DB2 on a real-time Mainframe Server during this entire DB2 training.
Note:
This Course is all about DB2 on Mainframe from a Developer's point of view and not from the DBA point of view. In short, this course is not a DB2 DBA course, rather than DB2 for Mainframe programmers or DB2 for Mainframe Developers.
Link to access the Premium Course -
trainool.com/courses/mainfram...
Coupon Code to make the premium Course Free:
Coming Soon Again...
Note:
Whenever the Coupon Code is provided, the first 50 students will be able to access the premium course for free
🔔 If you like the video, Please Like, Comment, and Subscribe to my KZbin channel
/ tutorialbrain
⌚TimeStamp:
0:00 - Introduction about the Course
01:50 - Introduction to DB2
04:08 - Types of SQL Operations in DB2
09:06 - Hierarchy of DB2
14:16 - Data Types in DB2
21:31 - DDL- Create table
32:56 - DDL- Create views
38:44 - DDL-ALTER
44:13 - DDL-DROP
47:24 - DML - INSERT
01:00:16 - DML - SELECT - Part 1
01:09:16 - DML - SELECT - Part 2
01:16:38 - DML - SELECT - Part 3
01:28:18 - DML - SELECT - Part 4
01:31:01 - DML - SELECT - Part 5
01:33:41 - DML - UPDATE
01:37:57 - DML - DELETE
01:41:03 - Ending the DB2 Course
#DB2 #DB2Tutorial #tutorialbrain
🚩Let’s connect on social:
Website/Articles: www.tutorialbrain.com
Facebook: / tutorialbrain
Twitter: / tutorial_brain
LinkedIn: / tutorialbrain
Microsoft SQL Server Crash course -
• SQL Server Crash cours...

[@pratapsahu7311]

Perfect video for a beginner, thank you so much for this knowledge sharing.

[@siddusmart9348]

Great explanation

[@javaidmogul4053]

Best teacher.

[@sunithapeesu937]

Thank you sir for this. And Please can you explain about joints and remaining concepts

[@TutorialBrain]

Sure, will plan it

[@naveenkumarrai9121]

Sir, please tell brief about DBMATE1.TSMATEKS which you used executing the table.

[@TutorialBrain]

Did not understand your question

[@fromzerotocobol6023]

How do you know the database allocated to you (DBMATE1) ?

[@vineethaoduru6815]

Hi sir,I have assessment on mainframes (JCL,COBOL and DB2).I feel tensed about assessment please help me sir. How to learn mainframes. Please

[@MansoorAli-yr5rc]

Hello Sir. Good Morning. How are you ? Hope you are doing great. I had recently came to know that COBOL is in demand (post-pandemic). Also, by learning COBOL one can have some decent international job exposure as COBOL developer. Is it true ? Is this good time to learn COBOL? Please reply sir. I would like to enroll in TRAINOOL. Please reply?

[@TutorialBrain]

Cobol was always having demand but the answer to this would require time as it's not straight forward

[@MansoorAli-yr5rc]

@@TutorialBrain Thank you for the reply sir. I am glad to hear that COBOL is still in demand now. I feel good that I am choosing the right path. Sir, how can I contact you for more information sir ? I want to get my doubts cleared regarding cobol. Please reply.

[@karunamoorthy4030]

36:43

[@sarika8278]

hello Sir do you also give Mainframe DBA training?

[@siddusmart9348]

I need one information bro

[@b.mahesh3976]

Do more videos mainframe

[@TutorialBrain]

Sure, will do it

[@JXXNU]

DO U KNOW ABOUT DB2 PLZ HELP ME . I NEED TO WORK ON A PROJECT

[@TutorialBrain]

@@JXXNU Hi Naved, I would have loved to help you out. I would not have asked for any payment. The point is that I am extremely tied up nowadays hence not finding much time. Still, if you have any doubts or you need any suggestions, please ask me and I will try my best to help you out.

[@priyavantedhu6293]

Hlo sir..how should I contact U..

[@TutorialBrain]

Please let me know here, no issues

[@JXXNU]

GOOD MORNING SIR , I HAVE AN ASSIGNMNET ON DB2 MAINFRAME , COULD U PLZ HELP ME ON THAT . I CAN PAY U TOO ITS VERY URGENT , IF POSSIBLE PLZ REPLY

[@TutorialBrain]

Hi Naved, I would have loved to help you out. I would not have asked for any payment. The point is that I am extremely tied up nowadays hence not finding much time. Still, if you have any doubts or you need any suggestions, please ask me and I will try my best to help you out.

[@mahkhi7154]

We Might be Able to Nuke Darlik - IBM DB2, with Our Android SQL Lite, Plan.

[@evokeservices5849]

hello Sandeep, I am looking for a DB2 complete course. you can send me information on how we can chat in private