Udemy - IBM DB2 9 - SQL and Database Administration Workshop
MP4 | Video: 1280x720 | 106 kbps | 44 KHz | Duration: 35 Hours | 2.64 GB
Genre: eLearning | Language: English
A complete course on becoming a highly paid DB2 Professional. Earn $70k+ in the IT Industry. Get loaded, Get Hired !
Why Learn DB2 ?
Better paid jobs and a great career choice !
An average DB2 DBA salary is $72,000 p.a. --(source-indeed dot com)
What are the chances of landing up with a DB2 Job?
Most people go for Oracle, MS SQL and other DBA jobs.
There are a good number of DB2 DBA jobs too (for freshers and exp.), but it's hard to find good DB2 Professionals.
Take the advantage, get hired by Big Companies and get a Better Compensation.
What companies use DB2?
To name a few
Dominos Pizza, Morgan Stanley, PricewaterhouseCoopers(PwC), American Express, Coca Cola, IBM, Deloitte, McDonald's, VISA, Mastech, Conexess Group, Accenture, Kforce, Open Systems Technologies , Walmart , TCS, Infosys, CSC, XEROX, HP, Guardian Life, CapGemini, WIPRO
and many more. (source - indeed dot com and glassdoor dot com)
What's the future of being associated with DB2?
DB2 is high competition to other databases and being IBM's biggest selling software in databases, its here to stay for ages.
With it's Oracle compatibility features in DB2 9.7, it's getting harder for competitors.
Is this course sufficient to get a DB2 DBA Job?
This course provides a strong conceptual knowledge (that most interviewers look for) backed by practical learning (that adds to your employment chances).
After completing the course, you will have the knowledge of DB2, equivalent to a 0.5-1.5 Years exp professional.
Will I be able to learn DB2?
You just need to have the zeal to learn. I've put in best of my efforts to make this course as simple as i could (from a beginners perspective) , by explaining concepts that should be easy to understand and the step-by-step tutorials (demos) will be really easy to follow.
The course has Quizzes, Exercises and Resources to back you up with your learning.
I am here to share my knowledge and experience on DB2, connect with you guys, participate in the discussion forums, answer questions you ask and make sure you learn DB2 like nobody else can do.
You'll be a pro at DB2 !
What about the Professional IBM DB2 Certification?
A professional DB2 certification ensures that you have been tested on the skills by the giant itself (IBM).
I have trained 12000+ students on DB2 and the certification success ratio has been over 95%.
This course covers all concepts and practicals that will help you clear the certification (if you choose to go for it) with atleast 80% marks. There is a section dedicated completely towards clearing the DB2 Certification. It also has got some questions that may most likely come in the main exam.
It's good to have a basic understanding of DBMS concepts and SQL. Although, i've covered these concepts too during the lectures.
What are the requirements?
Basic concepts of DBMS i.e. what's a database used for, what are tables in relational databases etc.
Basic knowledge of SQL i.e. what are DDL and DML statements and how to write basic SQL Queries (Although it's covered in the course)
What am I going to get from this course?
Over 120 lectures and 35 hours of content!
Understand the Architecture of DB2
Install & Configure DB2 on Windows and Linux platforms
Work on various GUI and Command Line Tools of DB2
Create and Manage various database objects in DB2
Understand and Execute SQL statements in DB2
Create and Manage DB2 Instances & Databases
Administer and Manage Database Storage
Perform Import/Export/Load operations on Databases
Administer DB2 Security
Administer and Manage Data Concurrency
Perform Backup and Recovery operations
Fine Tune Instances and Databases for better performance
Prepare for Professional IBM DB2 Certification Exams
What is the target audience?
This course is for people wanting to be Database Administrators for DB2
Students, who are not comfortable with programming, can choose this course for a highly paid career in the field of databases
People looking for careers in Database Development
Already experienced DBAs (from other databases), can take up the course to increase their horizon for better paid DBA jobs