735 SQL courses delivered Online

Discover Microsoft Fabric's architecture, master Data Engineering with OneLake and Spark, and elevate your skills in data warehousing and real-time processing. Compare SQL and KQL for better insights, and improve storytelling using Power BI. Finally, you will end with practical data science techniques and data management methods.

Duration 5 Days 30 CPD hours This course is intended for This hands-on course is geared for experienced DBAs with basic Oracle 19c skills. Overview This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs andexercises. Working in a hands-on learning environment led by our expert facilitator, students will explore: Creating CDBs and Regular PDBs Managing CDBs and PDBs Backup and Duplicate Upgrading and Transporting CDBs and Regular PDBs Backup Strategies and Terminology Restore and Recovery Concepts Using Flashback Technologies Duplicating a Database Installing Grid Infrastructure and Oracle Database Patching Grid Infrastructure and Oracle Database Upgrading to Oracle Grid Infrastructure Using General Overall Database Enhancements Monitoring and Tuning Database Performance Managing Application PDBs Managing Security in Multitenant databases Recovery and Flashback Configuring and Using RMAN Diagnosing Failures Performing Recovery Transporting Data RMAN Troubleshooting and Tuning Creating an Oracle Database by using DBCA Oracle Restart Upgrading the Oracle Database Installing Grid Infrastructure for a Standalone server Using Availability Enhancements Tuning SQL Statements Geared for participants experienced with Oracle 19c DBA essentials Oracle 19c Database Administration II (Oracle DBA II) expands their understanding of Oracle database administration. Throughout the course students will explore coverage of Multitenant (CDB/PDB), database tuning, SQL tuning, and backup and recovery: the skills needed to keep a database running reliably and efficiently. The current release of the database is used for exercises and demonstrations, and the content back-ported as necessary for previous releases. Creating CDBs and Regular PDBs Configure and create a CDB Create a new PDB from the CDB seed Explore the structure of PDBs Manage CDBs and PDBs Manage PDB service names and connections Manage startup, shutdown and availability of CDBs and PDBs Change the different modes and settings of PDBs Evaluate the impact of parameter value changes Performance management in CDBs and PDBs Control CDB and PDB resource usage with the Oracle Resource Manager Backup and Duplicate Perform Backup and Recover CDBs and PDBs Duplicate an active PDB Duplicate a Database Upgrading and Transporting CDBs and Regular PDBs Upgrade an Oracle Database Transport Data Backup Strategies and Terminology Perform Full and Incremental Backups and Recoveries Compress and Encrypt RMAN Backups Use a media manager Create multi-section backups of exceptionally large files Create duplexed backup sets Create archival backups Backup of recovery files Backup non database files Back up ASM meta data Restore and Recovery Concepts Employ the best Oracle Database recovery technology for your failure situation Describe and use Recovery technology for Crash, Complete, and Point-in-time recovery Using Flashback Technologies Configure your Database to support Flashback Perform flashback operations Duplicating a Database Duplicate Databases Install Grid Infrastructure and Oracle Database Install Grid Infrastructure for a Standalone server Install Oracle Database software Patching Grid Infrastructure and Oracle Database Patch Grid Infrastructure and Oracle Database Upgrading to Oracle Grid Infrastructure Upgrade Oracle Grid Infrastructure Using General Overall Database Enhancements Install Oracle Database software Create, Delete and Configure Databases using DBCA Creating CDBs and Regular PDBs Use Miscellaneous 19c New Features Monitoring and Tuning Database Performance Managing Memory Components Understanding the Automatic Workload Repository (AWR) Understanding the Advisory Framework Monitoring Wait Events, Sessions, and Services Managing Metric Thresholds and Alerts Understanding and Using the Performance Tuning Methodology Performing Performance Planning Understanding the Automatic Database Diagnostic Monitor (ADDM) Manage Application PDBs Explain the purpose of application root and application seed Define and create application PDBs Install, upgrade and Patch applications Create and administer Application PDBS Clone PDBs and Application containers Plug and unplug operations with PDBs and application containers Comparing Local Undo Mode and Shared Undo Mode Manage Security in Multitenant databases Manage Security in Multitenant databases Manage PDB lockdown profiles Audit Users in CDBs and PDBs Manage other types of policies in application containers Recovery and Flashback Restore and Recovering Databases with RMAN Perform CDB and PDB flashback Configuring and Using RMAN Configure RMAN and the Database for Recoverability Configure and Using an RMAN recovery catalog Diagnosing Failures Detect and repair database and database block corruption Diagnosing Database Issues Performing Recovery Restore and Recovering Databases with RMAN Perform Non RMAN database recovery Transporting Data Transport Data RMAN Troubleshooting and Tuning Interpret the RMAN message output Diagnose RMAN performance issues Creating an Oracle Database by using DBCA Create, Delete and Configure Databases using DBCA Oracle Restart Configure and use Oracle Restart to manage components Upgrade the Oracle Database Plan for Upgrading an Oracle Database Upgrade an Oracle Database Perform Post-Upgrade tasks Install Grid Infrastructure for a Standalone server Rapid Home Provisioning Using Availability Enhancements Use an RMAN recovery catalog Use Flashback Database Tuning SQL Statements Understanding the Oracle Optimizer Using the SQL Tuning Advisor Managing Optimizer Statistics Using the SQL Access Advisor Understanding the SQL Tuning Process Additional course details: Nexus Humans Oracle 19c Database Administration II (DBA II) (TTOR20619) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Oracle 19c Database Administration II (DBA II) (TTOR20619) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Recent developments in data analytics and statistics underscore the critical importance of understanding both data structure and analytics methodologies in today's data-driven world. With the exponential growth of data, businesses are increasingly relying on skilled professionals who can harness the power of data to drive informed decision-making. Our comprehensive Data Structure, Data Analytics with Statistics & Data Science QLS Endorsed Diploma bundle, endorsed by the Quality Licence Scheme (QLS) and accredited by the CPD Quality Standards (QS), offers a holistic approach to mastering data structure, data analytics, and statistical techniques. In an era where data reigns supreme, organisations seek individuals who can navigate complex datasets with confidence and precision. This Data Structure, Data Analytics bundle equips learners with the essential skills and knowledge needed to excel in the field of data science and analytics. By delving into topics such as data manipulation, statistical analysis, and database management, participants gain a deep understanding of how to extract valuable insights from raw data. Moreover, our guided courses in career development and communication empower learners to effectively communicate their findings and advance their professional journey. Bundle Include includes: QLS Endorsed Courses: Course 01: Certificate in Data Analytics with Tableau at QLS Level 3 Course 02: Diploma in Data Structure at QLS Level 5 Course 03: Advanced Diploma in Statistics & Probability for Data Science & Machine Learning at QLS Level 7 CPD QS Accredited Courses: Course 04: Business and Data Analytics for Beginners Course 05: Learn Financial Analytics and Statistical Tools Course 06: SQL For Data Analytics & Database Development Course 07: Big Data Analytics with PySpark Power BI and MongoDB Course 08: Google Data Studio: Data Analytics Course 09: Business Intelligence Analyst Course 10: Spatial Data Visualization and Machine Learning in Python Course 11: Data Analysis In Excel Take your career to the next level with our Data Structure, Data Analytics bundle that includes technical courses and five guided courses focused on personal development and career growth. Course 12: Career Development Plan Fundamentals Course 13: CV Writing and Job Searching Course 14: Networking Skills for Personal Success Course 15: Ace Your Presentations: Public Speaking Masterclass Course 16: Decision Making and Critical Thinking Seize this opportunity to elevate your career with our comprehensive Data Structure, Data Analytics bundle, endorsed by the prestigious QLS and accredited by CPD.Data Structure, Data Analytics with Statistics & Data Science QLS Endorsed Diploma. Learning Outcomes: Upon completion of this Data Structure, Data Analytics bundle, participants will be able to: Demonstrate proficiency in data analytics tools such as Tableau, SQL, and Google Data Studio through Data Structure, Data Analytics courses. Apply statistical techniques to analyse and interpret data for informed decision-making. Design and implement data structures to efficiently store and retrieve information. Utilise machine learning algorithms for predictive analysis and pattern recognition. Develop effective communication and presentation skills to convey insights to stakeholders. Navigate career development pathways in the field of data science and analytics. This Data Structure, Data Analytics course bundle provides a deep dive into the foundational principles of data structure, data analytics, and statistical methodologies. Participants will explore the fundamental concepts of data manipulation, including sorting, searching, and storing data efficiently. Through hands-on exercises and theoretical discussions, learners will gain a solid understanding of various data structures such as arrays, linked lists, trees, and graphs, along with their applications in real-world scenarios. Moreover, the Data Structure, Data Analytics bundle encompasses a comprehensive exploration of data analytics techniques, equipping participants with the skills to extract actionable insights from complex datasets. From descriptive and inferential statistics to predictive modelling and machine learning algorithms, learners will discover how to uncover patterns, trends, and correlations within data, enabling informed decision-making and strategic planning. Throughout the Data Structure, Data Analytics course, emphasis is placed on practical applications and case studies, allowing participants to apply their knowledge to solve real-world problems in diverse domains. CPD 160 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Data Structure, Data Analytics course is perfect for: Aspiring data analysts seeking to enhance their analytical skills acrod Data Structure, Data Analytics courses. Professionals transitioning into roles requiring proficiency in data analytics. Students pursuing careers in data science, statistics, or related fields. Business professionals looking to leverage data for strategic decision-making. Individuals interested in advancing their career prospects in the field of data analytics. Anyone seeking to gain a comprehensive understanding of data structure, analytics, and statistics. Requirements You are warmly invited to register for this bundle. Please be aware that there are no formal entry requirements or qualifications necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Upon completion of the Data Structure, Data Analytics courses, you will be able to: Data Analyst Business Intelligence Analyst Data Scientist Statistician Database Administrator Machine Learning Engineer Data Engineer Certificates 13 CPD Quality Standard Certificates Digital certificate - Included 3 QLS Endorsed Certificates Hard copy certificate - Included

24 Hour Flash Deal **25-in-1 Data Engineering Advanced Diploma Mega Bundle** Data Engineering Advanced Diploma Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Data Engineering Advanced Diploma package online with Studyhub through our online learning platform. The Data Engineering Advanced Diploma bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Data Engineering Advanced Diploma course provides complete 360-degree training on Data Engineering Advanced Diploma. You'll get not one, not two, not three, but twenty-five Data Engineering Advanced Diploma courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Data Engineering Advanced Diploma courses are yours for as long as you want them once you enrol in this course This Data Engineering Advanced Diploma Bundle consists the following career oriented courses: Course 01: Data Analysis Course 02: Data Science & Machine Learning with R Course 03: Data Analytics with Tableau Course 04: SQL Programming Course 05: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Course 06: Data Analytics Course 07: Python Data Science with Numpy, Pandas and Matplotlib Course 08: Google Analytics Course 09: Business Intelligence and Data Mining Course 10: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 11: JavaScript Functions Course 12: Data Protection and Data Security (GDPR) Training Certification Course 13: GDPR Training Course 14: Diploma in Python Programming Course 15: Data Center Training Essentials: General Introduction Course 16: Quick Data Science Approach from Scratch Course 17: Diploma in Statistics & Probability for Data Science & Machine Learning Course 18: Master JavaScript with Data Visualization Course 19: Data Analysis and Forecasting in Excel Course 20: AWS Certified Solutions Architect Associate Preparation Course 21: Statistical Analysis Course Course 22: SQL for Data Science, Data Analytics and Data Visualization Course 23: Learn MySQL from Scratch for Data Science and Analytics Course 24: Data Analysis & Forecasting Course 25: Data Structure The Data Engineering Advanced Diploma course has been prepared by focusing largely on Data Engineering Advanced Diploma career readiness. It has been designed by our Data Engineering Advanced Diploma specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Data Engineering Advanced Diploma Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Data Engineering Advanced Diploma bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Data Engineering Advanced Diploma Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Data Engineering Advanced Diploma Elementary modules, allowing our students to grasp each lesson quickly. The Data Engineering Advanced Diploma course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive Data Engineering Advanced Diploma bundle, you really hit the jackpot. Here's what you get: Step by step Data Engineering Advanced Diploma lessons One to one assistance from Data Engineering Advanced Diplomaprofessionals if you need it Innovative exams to test your knowledge after the Data Engineering Advanced Diplomacourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Data Engineering Advanced Diploma courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Data Engineering Advanced Diploma certificate and transcript on the next working day Easily learn the Data Engineering Advanced Diploma skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Data Engineering Advanced Diploma training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Data Engineering Advanced Diploma Requirements To participate in this Data Engineering Advanced Diploma course, all you need is - A smart device A secure internet connection And a keen interest in Data Engineering Advanced Diploma Career path You will be able to kickstart your Data Engineering Advanced Diploma career because this course includes various courses as a bonus. This Data Engineering Advanced Diploma is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Data Engineering Advanced Diploma career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

24 Hour Flash Deal **25-in-1 Cloud Solutions Architect Diploma Mega Bundle** Cloud Solutions Architect Diploma Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Cloud Solutions Architect Diploma package online with Studyhub through our online learning platform. The Cloud Solutions Architect Diploma bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Cloud Solutions Architect Diploma course provides complete 360-degree training on Cloud Solutions Architect Diploma. You'll get not one, not two, not three, but twenty-five Cloud Solutions Architect Diploma courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Cloud Solutions Architect Diploma courses are yours for as long as you want them once you enrol in this course This Cloud Solutions Architect Diploma Bundle consists the following career oriented courses: Course 01: AWS Certified Solutions Architect Associate Preparation Course 02: CompTIA Cloud+ (CV0-002) Course 03: IT Administration and Networking Course 04: CompTIA Network+ Certification (N10-007) Course 05: Cyber Security Awareness Training Course 06: Information Governance and Data Management Training Course 07: Internet of Things (IoT) Course 08: Data Center Training Essentials: General Introduction Course 09: Network Security and Risk Management Course 10: SQL for Data Science, Data Analytics and Data Visualization Course 11: Data Science & Machine Learning with R Course 12: Python Basic Programming for Absolute Beginners Course 13: Machine Learning Basics Course 14: Data Analysis & Forecasting Course 15: SQL Database Management Course 16: CompTIA Security+ Course 17: Cyber Security Advanced Training Course 18: Data Analytics with Tableau Course 19: Geospatial Technology, Remote Sensing and Web Mapping Course 20: Digital Forensic Science: Unraveling Cybercrime Mysteries Course Course 21: CompTIA PenTest+ (Ethical Hacking) course Course 22: Microsoft Excel Complete Course 2019 Course 23: Python Data Science with Numpy, Pandas and Matplotlib Course 24: Computer Networks Security from Scratch to Advanced Course 25: Learn Fundamentals of WordPress The Cloud Solutions Architect Diploma course has been prepared by focusing largely on Cloud Solutions Architect Diploma career readiness. It has been designed by our Cloud Solutions Architect Diploma specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Cloud Solutions Architect Diploma Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Cloud Solutions Architect Diploma bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Cloud Solutions Architect Diploma Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Cloud Solutions Architect Diploma Elementary modules, allowing our students to grasp each lesson quickly. The Cloud Solutions Architect Diploma course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive Cloud Solutions Architect Diploma bundle, you really hit the jackpot. Here's what you get: Step by step Cloud Solutions Architect Diploma lessons One to one assistance from Cloud Solutions Architect Diplomaprofessionals if you need it Innovative exams to test your knowledge after the Cloud Solutions Architect Diplomacourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Cloud Solutions Architect Diploma courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Cloud Solutions Architect Diploma certificate and transcript on the next working day Easily learn the Cloud Solutions Architect Diploma skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Cloud Solutions Architect Diploma training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Cloud Solutions Architect Diploma Certified Cloud Professional (CCP) Requirements To participate in this Cloud Solutions Architect Diploma course, all you need is - A smart device A secure internet connection And a keen interest in Cloud Solutions Architect Diploma Career path You will be able to kickstart your Cloud Solutions Architect Diploma career because this course includes various courses as a bonus. This Cloud Solutions Architect Diploma is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Cloud Solutions Architect Diploma career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

24 Hour Flash Deal **25-in-1 IT Security Specialist Diploma Mega Bundle** IT Security Specialist Diploma Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the IT Security Specialist Diploma package online with Studyhub through our online learning platform. The IT Security Specialist Diploma bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This IT Security Specialist Diploma course provides complete 360-degree training on IT Security Specialist Diploma. You'll get not one, not two, not three, but twenty-five IT Security Specialist Diploma courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these IT Security Specialist Diploma courses are yours for as long as you want them once you enrol in this course This IT Security Specialist Diploma Bundle consists the following career oriented courses: Course 01: Foundations of IT Security: Protecting Digital Assets Course 02: IT Support Technician Training Course 03: Network Security and Risk Management Course 04: CompTIA Network Course 05: Information Management Course 06: Diploma in Front-End Web Development Course 07: Data Science and Visualisation with Machine Learning Course 08: SQL for Data Science, Data Analytics and Data Visualization Course 09: PLC Programming Diploma Course 10: Masterclass Bootstrap 5 Course - Responsive Web Design Course 11: Web Application Penetration Testing Course 12: CompTIA Cloud+ (CV0-002) Course 13: CompTIA PenTest+ (Ethical Hacking) course Course 14: Computer Operating System and Troubleshooting Course 15: Learn How to Build a Computer Course from Scratch Course 16: CEH: Learn Ethical Hacking From A-Z: Beginner To Expert Course 17: SQL Database Administrator Course 18: Data Protection and Data Security (GDPR) Training Certification Course 19: Website Hacking Course 20: Cyber Security Incident Handling and Incident Response Course 21: Ransomware Uncovered Specialist Certificate Course 22: Digital Product Management Course 23: Computer Workstation Safety Training Course 24: Service Helpdesk & Technical Support Course Course 25: Microsoft Office course The IT Security Specialist Diploma course has been prepared by focusing largely on IT Security Specialist Diploma career readiness. It has been designed by our IT Security Specialist Diploma specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The IT Security Specialist Diploma Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This IT Security Specialist Diploma bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This IT Security Specialist Diploma Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into IT Security Specialist Diploma Elementary modules, allowing our students to grasp each lesson quickly. The IT Security Specialist Diploma course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive IT Security Specialist Diploma bundle, you really hit the jackpot. Here's what you get: Step by step IT Security Specialist Diploma lessons One to one assistance from IT Security Specialist Diplomaprofessionals if you need it Innovative exams to test your knowledge after the IT Security Specialist Diplomacourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five IT Security Specialist Diploma courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your IT Security Specialist Diploma certificate and transcript on the next working day Easily learn the IT Security Specialist Diploma skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This IT Security Specialist Diploma training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in IT Security Specialist Diploma Requirements To participate in this IT Security Specialist Diploma course, all you need is - A smart device A secure internet connection And a keen interest in IT Security Specialist Diploma Career path You will be able to kickstart your IT Security Specialist Diploma career because this course includes various courses as a bonus. This IT Security Specialist Diploma is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore IT Security Specialist Diploma career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

Duration 5 Days 30 CPD hours This course is intended for This beginning DB2 basic course is for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database in a z/OS environment. Overview Describe several services provided in a z/OS environmentExplain workloads in the batch environmentExplain workloads in the online environmentDescribe job roles in a z/OS environmentLog On to TSO/ENavigate TSO/E and ISPFUse TSO commandsSetup and utilize JCL (Job Control Language)Utilize SDSFDescribe the different types of data sets in a z/OS environmentAllocate data sets and list data set information and contentCreate and modify data set contentGive an overview of the DB2 9 environmentDescribe and utilize DB2 ObjectsDescribe and utilize several DB2 UtilitiesDescribe the DB2I (DB2 Interactive Facility) environmentUse SPUFI (SQL Processing Using File Input) to compose and execute SQLSetup and execute DB2 CommandsUnderstand DB2 LoggingDescribe DB2 program preparation processUnderstand DB2 startup and shutdownUnderstand and utilize DB2 recovery strategies This course is intended for students looking to develop fundamental skills or recognition through lectures and hands-on exercises of TSO/E and ISPF, data sets, DB2 objects, Structured Query Language, DB2 commands, JCL and SDSF. Day 1 Welcome Unit 1: Introduction Unit 2: TSO/E and ISPF Exercise 1: TSO and ISPF Exercise 1 Review Unit 3: Data Sets (Data Sets and Sequential Data Sets) Exercise 2: Sequential Data Sets Exercise 2 Review Day 2 Unit 3: Data Sets (Partitioned Data Sets) Exercise 3: Partitioned Data Sets Exercise 3 Review Unit 3: Data Sets (VSAM Data Sets) Exercise 4: VSAM Data Sets Exercise 4 Review Unit 4: JCL and SDSF Exercise 5: JCL and SDSF Exercise 5 Review Day 3 Unit 5: DB2 Relational Database Concepts Unit 6: Structured Query Language (SQL) and SPUFI Exercise 6: SQL and SPUFI Exercise 6 Review Unit 7: DB2 Objects (Databases and Table Spaces) Exercise 7: Databases and Table Spaces Exercise 7 Review Unit 7: DB2 Objects (Tables, Indexes, and Views) Exercise 8: Tables, Indexes, and Views Exercise 8 Review Day 4 Unit 7: DB2 Objects (Qualified Names, Implicit Object Creation, and SQL Statements) Exercise 9: Qualified Names, Implicit Object Creation, and SQL Statements Exercise 9 Review Unit 8: The DB2 System Exercise 10: The DB2 System Exercise 10 Review Unit 9: DB2 Commands and Program Preparation Exercise 11: DB2 Commands Exercise 11 Review Day 5 Unit 10: DB2 Utilities Exercise 12: DB2 Utilities Exercise 12 Review Unit 11: DB2 Shutdown, Startup, and Recovery Exercise 13: DB2 Recovery Exercise 13 Review Unit 12: Course Summary Additional course details: Nexus Humans CV041 IBM z/OS and DB2 Basics for DB2 for z/OS DBA Beginners training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the CV041 IBM z/OS and DB2 Basics for DB2 for z/OS DBA Beginners course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

This is an intermediate to advanced ASP.NET Core (.NET 6) course that will take you from the basics to the advanced mode. This course is for anyone who has a basic understanding of ASP.NET Core and wants to learn how to architect and build real-world ASP.NET Core apps.

Learning AWS VPC would be your stepping stone into an AWS career. A good understanding of VPC and its components is a MUST going into any AWS certification. Get started with Amazon VPC and prepare for certification with the help of this comprehensive course. There are no prerequisite requirements for this course.

This video course takes a step-by-step and systematic approach to make you familiar with the bash shell scripting. You'll learn how to use the Linux command-line and commands to write and execute shell scripts for automating repetitive computing tasks.