710 Courses in Bradford delivered Online

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.

Advance your data skills by mastering Spark programming in Python. This beginner's level course will help you understand the core concepts related to Apache Spark 3 and provide you with knowledge of applying those concepts to build data engineering solutions.

This video course takes you through the basic and advanced concepts of penetration testing. From setting up your own virtual lab to developing brute force attacking tools using Python, you'll learn it all with the help of engaging activities.

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.

Duration 1 Days 6 CPD hours This course is intended for Software developers, system administrators, and IT professionals who are focused on Microsoft Windows Overview Configuring Microsoft Windows and Microsoft SQL Server in Google Compute Engine. Deploying ASP.NET MVC applications to Google Compute Engine. Deploying .NET Core applications to Google Compute Engine, Google Compute Engine, and Google Container Engine Learn how to create Windows virtual machines on Google Cloud so that you can deploy and run Microsoft Windows applications. In this course, you'll learn how to run SQL Server in Compute Engine, how to deploy instances across Google Cloud zones, and how to get more out of ASP.NET on Compute Engine, Google Container Engine, and App Engine. Introduction to Google Cloud Platform Scope and structure of GCP. Options for Windows deployment on GCP. GCP interfaces. Windows Workloads on Google Compute Engine Google Compute Engine virtual machine options. Integrating Active Directory with Google Compute Engine virtual machines. Options for running SQL Server in Google Compute Engine. Configuring SQL Server for high availability. Developing ASP.NET MVC applications Model-view-controller structure. Using Microsoft Visual Studio?s Web Project template to develop in ASP.NET. Deploying applications to Microsoft Internet Information Server (IIS) in GCE. Configuring Resilient Workloads Deploying instances across GCP zones. Using instance groups to create pools of virtual machines. Load balancing Windows applications. Delivering Next-Generation ASP.NET Core on GCP Understanding .NET Core and EF Core. Options for deploying ASP.NET Core applications on Google Cloud Platform. Deploying ASP.NET Core applications on Google Compute Engine. Deploying ASP.NET Core applications on Google Container Engine. Deploying ASP.NET Core applications on Google App Engine. Additional course details: Nexus Humans Develop and Deploy Windows Applications on Google Cloud Platform 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 Develop and Deploy Windows Applications on Google Cloud Platform 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.

Level-7 QLS Endorsed | 22-in-1 Diploma Bundle| Free CPD PDF+ Transcript Certificate| Lifetime Access| Learner Support

SQL for Data Science, Data Analytics and Data Visualization Course Overview: This course offers a comprehensive introduction to SQL, designed for those looking to enhance their skills in data science, data analytics, and data visualisation. Learners will develop the ability to work with SQL databases, efficiently query and manage data, and apply these techniques for data analysis in both SQL Server and Azure Data Studio. By mastering SQL statements, aggregation, filtering, and advanced commands, learners will be equipped with the technical skills required to manage large datasets and extract meaningful insights. The course provides a solid foundation in data structures, user management, and working with multiple tables, culminating in the ability to perform complex data analysis and visualisation tasks. Course Description: This course covers a broad range of topics essential for anyone working with data in a professional capacity. From setting up SQL servers to mastering database management tools like SQL Server Management Studio (SSMS) and SQL Azure Data Studio, the course provides a thorough grounding in SQL. Learners will gain expertise in data structure statements, filtering data, and applying aggregate functions, as well as building complex SQL queries for data analysis. The course also includes instruction on SQL user management, group by statements, and JOINs for multi-table analysis. Key topics such as SQL constraints, views, stored procedures, and database backup and restore are also explored. The course incorporates SQL visualisation tools in Azure Data Studio, empowering learners to visualise data effectively. By the end of the course, learners will be proficient in SQL queries, data manipulation, and using Azure for data analysis. SQL for Data Science, Data Analytics and Data Visualization Curriculum: Module 01: Getting Started Module 02: SQL Server Setting Up Module 03: SQL Azure Data Studio Module 04: SQL Database Basic SSMS Module 05: SQL Statements for DATA Module 06: SQL Data Structure Statements Module 07: SQL User Management Module 08: SQL Statement Basic Module 09: Filtering Data Rows Module 10: Aggregate Functions Module 11: SQL Query Statements Module 12: SQL Group By Statement Module 13: JOINS for Multiple Table Data Analysis Module 14: SQL Constraints Module 15: Views Module 16: Advanced SQL Commands Module 17: SQL Stored Procedures Module 18: Azure Data Studio Visualisation Module 19: Azure Studio SQL for Data Analysis Module 20: Import & Export Data Module 21: Backup and Restore Database (See full curriculum) Who is this course for? Individuals seeking to enhance their data management and analysis skills. Professionals aiming to progress in data science, data analytics, or database administration. Beginners with an interest in data analysis and SQL databases. Anyone looking to gain expertise in SQL for Azure and SQL Server environments. Career Path: Data Analyst Data Scientist Database Administrator SQL Developer Business Intelligence Analyst Data Visualisation Specialist

This course provides complete coverage of C# programming fundamentals and how to create an executable windows form project. You will be digging into the structures of Windows Forms to gain a detailed understanding and then sharpen your skills with the help of a variety of projects.

Unlock your potential as a Business Intelligence Analyst! Master data analysis, reporting, and visualisation skills to drive informed business decisions.

"Start your career as a Business Intelligence Analyst and earn up to £70,000 per Year." Looking to capitalise on the 27% surge in demand for Data and Business Intelligence Analysts in the UK? Our 'Data and Business Intelligence Analyst Job Ready Program' packs 5 powerful courses into one complete package, guaranteeing real-world job readiness. With comprehensive career support and a money-back promise, your success isn't just anticipated - it's assured! Our mission is simple - to be your trusted partner every step of the way, from training to employment. In addition to teaching you the technical skills you need, we will also provide you with career mentoring and support. We will help you build your resume, prepare for interviews, and land your dream job. We also have partnerships with many companies that are hiring Data and Business Intelligence Analysts, so we can help you get your foot in the door. If you are not happy with our service, we also offer a 100% money-back guarantee. So what are you waiting for? Enrol in our Data and Business Intelligence Analyst Job Ready Program today and start your journey to becoming a successful Data and Business Intelligence Analyst! If you have any questions, you can contact us. We will be happy to provide you with all the information you need. Learning Outcomes: Master the art of transforming raw data into meaningful insights. Gain proficiency in industry-standard BI and data analysis tools. Develop strong SQL, Python, and data visualisation skills. Understand predictive analytics and machine learning concepts. Learn to create interactive dashboards and reports. Hone critical thinking for effective data-driven decision-making. Gain hands-on experience through real-world projects. Achieve competency in data governance and management best practices. Here are the courses we will provide once you enrol in the program: Course 01: Business Intelligence Analyst Course Course 02: Business Intelligence and Data Mining Course 03: Raising Money & Valuations Course 04: Uniform System of Accounting for Lodging Industries Part 1 Course 05: Business Performance Management Course 06: Business Studies Course 07: Advanced Excel Analytics Course 08: Data Science & Machine Learning with R Course 09: Quick Data Science Approach from Scratch Course 10: SQL for Data Science, Data Analytics and Data Visualization Course 11: Python Data Science with Numpy, Pandas and Matplotlib Course 12: Complete Python Machine Learning & Data Science Fundamentals Course 13: Set Menu Prices for your restaurant using data Course 14: Data Analysis In Excel Course 15: Reporting and Data Course 16: Excel Pivot Tables for Data Reporting How Can We Offer Job Guarantees? HF Online provides consultancy, professional and educational services to many of the companies in the UK. During our intense exclusive training program, you will not just gain and complete the industry valuable certification but will gain industry experience as well, which is imperative to get your 1st job in the sector. The Data and Business Intelligence AnalystJob Ready Program is completed in 9 easy steps: Step 1: Enrol in the Programme Begin your exciting journey with us by enrolling in the Data and Business Intelligence Analyst Job Ready Program. Complete your registration and make a secure online payment. Remember, we offer a 14-day money-back guarantee if you're not completely satisfied. After you enrol in the Program, you will get lifetime access to 6 premium courses related to Web Development. These courses will teach you the knowledge and skills required to become a successful Data and Business Intelligence Analyst. Our customer service team will help you and keep in contact with you every step of the way. So you won't have to worry about a thing! Step 2: Initial One-On-One Counselling Session Once enrolled, you will be paired with a dedicated career mentor. Schedule your first one-on-one session to discuss your career aspirations, skills, experience, and any areas for potential growth. This conversation will shape your learning and development path. Step 3: Certification upon Course Completion After learning from the courses, you must obtain certificates for each course. There will be exams for every course, and you have to pass them to get your certificate. To pass successfully, you must get 90% marks. Once you pass the exams, you will receive hardcopy certificates. These certificates will prove that you're an expert in the subject. Step 4: CV Revamping Our team of professionals will build you a compelling CV and LinkedIn profile. We'll ensure it presents your skills and qualifications effectively and is tailored to the needs and expectations of the finance industry. With these powerful tools in hand, you'll be fully prepared to tackle job interviews confidently. Step 5: Building Network and Submitting CV We understand the power of casting a wide net. We'll strategically submit your CV to various platforms and networks, expanding your reach and connecting you with valuable opportunities that align with your career goals. We will also make connections with many high-profile individuals and companies through your LinkedIn profile. Step 6: Interview Preparation With your CV ready, we'll move on to interview preparation. Gain exclusive access to our database of potential interview questions. Through simulated interviews with your mentor, you'll practice your responses and receive valuable feedback to further refine your skills. Step 7: Securing Job Interviews Leveraging our partnerships with leading companies, we'll secure job interviews for you. We'll ensure you get the opportunity to showcase your skills to potential employers and get the dream job you want. Step 8: Post-Interview Support Post-interview, we'll provide a debriefing session to reflect on your performance and identify areas of improvement for future interviews if necessary. Remember, our commitment extends until you land your dream job. Step 9: Celebrate Your New Job! Once you've secured your dream job in web development, it's time to celebrate! However, our support doesn't end there. We'll provide you with ongoing career advice to ensure you continue to thrive in your new role. We're excited to accompany you on this journey to success. Enrol today, and let's get started! Your path to a successful Data and Business Intelligence Analyst career begins with us. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Data and Business Intelligence Analyst Job Ready Program is ideal for: Aspiring Data and Business Intelligence Analyst seeking comprehensive training and industry-specific career guidance. Individuals looking to transition into a data-based role and require personalised mentorship. Graduates wanting to enhance their employability with tailored CV building and interview preparation. Career changers looking for an all-in-one solution to securing a job in the finance industry. Data Analysis enthusiasts desiring to leverage industry connections for job opportunities in business development. Career path Junior Data Analyst: £26,000 - £35,000 Data Analyst: £35,000 - £50,000 Senior Data Analyst: £50,000 - £70,000 Business Intelligence Analyst: £40,000 - £60,000 Senior Business Intelligence Analyst: £60,000 - £80,000 Data Scientist: £70,000 - £100,000 Certificates CPD Accredited e-Certificate Digital certificate - Included CPD Accredited Framed (Hardcopy) Certificate Hard copy certificate - Included Enrolment Letter Digital certificate - Included QLS Endorsed Hard Copy Certificate Hard copy certificate - Included Student ID Card Digital certificate - Included