2398 Courses delivered Online

***Want to Unlock the Secrets of Data? Become a Database Mastermind!*** The world runs on data, and Database Administrators (DBAs) are the heroes behind the scenes ensuring its smooth operation. Database administrators in the UK are in high demand, with an average salary of £41,501 per year. The job market is expected to grow by 9% in the next few years, so now is a great time to start a career as a database administrator. As a database administrator, you will be responsible for the design, implementation, and maintenance of databases. You will also be responsible for ensuring the security and integrity of the data. If you are interested in a challenging and rewarding career in technology, then database administration is a great option for you. Our Database Administrator course starts with the basics of Database Administrator and gradually progresses towards advanced topics. Therefore, each lesson of this Database Administrator course is intuitive and easy to understand. Learning Outcomes By the end of this Database Administrator course, you'll be able to: Install and configure MySQL Server and MySQL Workbench. Create, manage, and manipulate databases and tables using SQL. Insert, update, and delete data efficiently. Design and implement database relationships to ensure data integrity. Utilize aggregate functions to summarize and analyze data. Reverse engineer existing databases and forward engineer data models. Why would you choose the Database Administrator course from Compliance Central: Lifetime access to Database Administrator course materials Full tutor support is available from Monday to Friday with the Database Administrator course Learn Database Administrator skills at your own pace from the comfort of your home Gain a complete understanding of Database Administrator course Accessible, informative Database Administrator learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Database Administrator Study Database Administrator in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your Database Administrator Course Database Administrator Curriculum Breakdown of the Database Administrator Course Unit 01: Introduction Gain foundational knowledge of MySQL Server and databases, including installation and initial setup. Module 01: Introduction to MySQL Server and Databases Module 02: Download and Install MySQL Server and MySQL Workbench Unit 02: Manipulating Tables and Data - CRUD Operations Learn to manage databases through creating, reading, updating, and deleting (CRUD) data in SQL and MySQL Workbench. Module 01: Connect and Create a Database Module 02: Drop or Remove Database Module 03: Create an SQL Database Table Module 04: Insert Data into the Table with SQL Script Module 05: Insert Data into the Table with Workbench Module 06: Select Data from the Table with SQL Script Module 07: Select Data with Filters Module 08: Update Data in the Table Module 09: Delete Data from the Table Module 10: Reverse Engineer Database into Model Module 11: Forward Engineer Data Model into Database Unit 03: Relationships and Foreign Keys Understand and implement relationships, foreign keys, and normalization in databases, enhancing data integrity and querying capabilities.ys Module 01: What are Relationships, Foreign Keys and Normalization? Module 02: Create Relationships with Data Modeling Module 03: Create Relationships with Workbench Table Design Tool Module 04: Insert Records in Related Tables Module 05: Run Queries on Related Tables (Inner Joins) Module 06: Left, Right and Cross-Joins Unit 04: Aggregate Functions Explore aggregate functions to perform calculations on data sets, including grouping, averaging, counting, and summing data. Module 01: Grouping Data using SQL GROUP BY Clause Module 02: SQL AVG Aggregate Function Module 03: SQL COUNT Aggregate Function Module 04: SQL MIN & MAX Aggregate Functions Module 05: SQL SUM Aggregate Function Module 06: Splitting Groups using HAVING Clause CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Database Administrator course is ideal for: Individuals with an interest in data management and database systems. IT professionals seeking to expand their skillset and transition into a Database Administrator role. Business analysts who want to gain a deeper understanding of data structures and manipulation techniques. Anyone passionate about building and maintaining robust and efficient databases. Those looking to enhance their career prospects in the ever-growing field of data. Requirements To enrol in this Database Administrator course, all you need is a basic understanding of the English Language and an internet connection. Career path A successful career as a Database Administrator can open doors to exciting opportunities. Here are some potential career paths to consider: Database Administrator Database Analyst Database Architect Data Warehouse Specialist Business Intelligence Analyst Data Scientist (with further specialization) Database Security Specialist Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Overview of Linux Shell Scripting Join our Linux Shell Scripting course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Linux Shell Scripting course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Linux Shell Scripting course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! This Linux Shell Scripting Course will help you to learn: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Linux Shell Scripting. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online — Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion – Digital / PDF Certificate After completing the Linux Shell Scripting course, you can order your CPD Accredited Digital/ PDF Certificate for £5.99. Certificate of Completion – Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Linux Shell Scripting is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand. On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level. This course has been developed with maximum flexibility and accessibility, making it ideal for people who don’t have the time to devote to traditional education. Requirements You don’t need any educational qualification or experience to enrol in the Linux Shell Scripting course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Linux Shell Scripting Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors.

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Analysts, Business Process Owners/Team Leads/Power Users, Data Consultants /Managers, Program/Project Managers, and Solution Architects. Overview Gain hands-on experience in running SAP BusinessObjects BI tools on top of SAP NetWeaver BW data In this course, students are provided with detailed knowledge on the integration for reporting of SAP BusinessObjects BI Platform 4.x with SAP NetWeaver 7.x. Overview of SAP BusinessObjects Business Intelligence(BI) 4.x and SAP NetWeaver Describing SAP BusinessObjects 4.x Semantic Layer in SAP BusinessObjects BI 4.x and Data Connectivity Describing Semantic Layer Technology Creating a Universe with the Information Design Tool SAP BusinessObjects Analysis, Edition for Microsoft Office and SAP NetWeaver BW Creating a Workbook in SAP BusinessObjects Analysis, Edition for Microsoft Office Creating a Workbook with SAP BusinessObjects Analysis, Edition for Microsoft Office and SAP BW SAP BusinessObjects Analysis, Edition for OLAP and SAP NetWeaver BW Creating a Workspace with SAP BusinessObjects Analysis, Edition for OLAP Creating a Workspace in SAP BusinessObjects Analysis, Edition for OLAP Based on a BW Query SAP BusinessObjects Design Studio and SAP NetWeaver BW Creating an Analytical Application in SAP BusinessObjects Design Studio Creating an Analytical Application with Scripting SAP BusinessObjects Dashboards and SAP NetWeaver BW Creating a Dashboard with SAP BusinessObjects Dashboards Creating a Dashboard with BEx Query SAP Crystal Reports and SAP NetWeaver BW Creating a Report with SAP Crystal Reports for Enterprise Creating a Report with SAP Crystal Reports 2013 Creating a Report with SAP Crystal Reports 2013 and SAP NetWeaver BW Differentiating SAP Crystal Reports 2013 and SAP Crystal Reports for Enterprise SAP BusinessObjects Web Intelligence and SAP NetWeaver BW Creating a Web Intelligence Document Creating a Web Intelligence Document for SAP NetWeaver BW SAP BusinessObjects Explorer and SAP NetWeaver BW Creating an SAP BusinessObjects Explorer Information Space Describing Data Connectivity between SAP BusinessObjects Explorer and SAP NetWeaver BW Information Distribution Reporting with Mobile Devices Creating Publications with SAP Crystal Reports and SAP BusinessObjects Web Intelligence Integrating BI Content with SAP NetWeaver Enterprise Portal

A comprehensive web development course that will help you understand 'why' things work and not just 'how'. Learn to write better code to boost your website traffic; know how to precision fix and tweak behavior and performance; improve your market penetration and your margins. Everything you need to know about the Critical Rendering Path, AJAX, and HTTP is right here at your fingertips.

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Analysts, Business Process Owners/Team Leads/Power Users, Program/Project Managers, Technology Consultants, and Users. In this course, students will gain SAP Netweaver Business Warehouse knowledge necessary for successful implementation and administration within a heterogeneous SAP NetWeaver BW system landscape. Data Warehousing Describing Data Warehouse Systems Describing Data Warehouse Architecture Using the Data Warehousing Workbench Master Data Modeling in SAP BW Describing InfoObjects Creating Characteristic InfoObjects The Loading of Master Data from SAP Data Sources Describing Data Flow Modeling a Master Data Flow Loading a Master Data Flow Modeling with the Graphical Data Flow Tool Loading of Transaction Data from SAP DataSources Describing the Core InfoProviders Creating a Key Figure InfoObject Creating a DataStore Object (DSO) Loading Transaction Data into a Data Store Object Describing the Extended Star Schema of an InfoCube Creating InfoCubes Loading Transaction Data into an InfoCube Master Data Loading from Flat File Data Sources Loading Data From a Flat File Describing the Data Flow in Detail Describing the Data Loading Process in Detail InfoProviders in SAP BW Explaining the InfoProviders Used in SAP BW ? Introduction Creating MultiProviders Usage of SAP BI Content Using BI Content Query Performance Optimization Optimizing Query Performance Monitoring Performance Creating and Filling Aggregates The SAP BW Administration Describing Administrative Tasks and Tools Administrating the InfoCubes Administrating the DataStore Objects Creating Process Chains

Register on the Python from Scratch today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of several easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Python from Scratch is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With Python from Scratch Receive an e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements The online training is open to all students and has no formal entry requirements. To study the Python from Scratch, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. 

Throughout this course, you will learn how to operate and maintain laboratory equipment and perform laboratory technician tasks.

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants and Business Process Owners/Team Leads/Power Users. Overview This course is organized in a fashion that mimics the step by step process planners will undergo in executing production planning tasks on a daily basis. We start with setup up alert profiles to manage the day to day exceptions. Participants will walk through a detailed analysis of the net requirements calculation process that is executed during product heuristics. Gain an understanding of how scheduling is performed as new orders are created. This will include analyzing source determination rules as well as scheduling strategies. Participants will analyze the pegging functionality and the master data parameters that can control the outcome of pegging. Additionally, we will perform an analysis of process, service and REM heuristics. Lastly, perform an overview of the detailed scheduling activities involved in developing an execution schedule. In this course, students gain an in-depth understanding of the advanced topics required to implement production planning in SAP SCM APO. Introduction to Production Planning in SAP Advanced Planning and Optimization (SAP APO) Planning Demand in the Supply Chain Using Production Planning and Detailed Scheduling (PP/DS) Production Planning Results Evaluation Evaluating the Planning Run Results with Alerts Evaluating the Planning Results Evaluating the Planning Run with Advanced Tools Planning Procedure Configuring Basic Parameters for Planning Executing the Production Planning Run Planning a Product Using the Planning Procedure Order Creation with Product Heuristics Using Demand Management in PP/DS Planning Make-to-Order Production Using PP/DS Using Firming in PP/DS Configuring Product Heuristics Managing the Reuse of Procurement Proposals Using the Lot-Size Calculation In Production Planning Scheduling in Production Planning Determining the Source of Supply of the Order Scheduling Operations with the Strategy Profile Scheduling a Planned Order for Production Pegging in Production Planning Configuring Dynamic and Fixed Pegging Additional Heuristics in Production Planning Planning Production Using Process Heuristics Planning Production Using Service Heuristics Configuring Bottom-Up Heuristics Planning Production Using Repetitive Manufacturing (REM) Heuristics Outlining the Integration of Supply Network Planning (SNP) in PP/DS Detailed Scheduling Scheduling Operations with the Detailed Scheduling Planning Board Planning Production with Detailed Scheduling Strategies and Heuristics Managing Setup Times with the Setup Matrix Managing Scheduling with the PP/DS Optimizer Using MRP-Based Detailed Scheduling Additional course details: Nexus Humans SCM250 SAP Production Planning in SAP APO 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 SCM250 SAP Production Planning in SAP APO 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 4 Days 24 CPD hours This course is intended for Application Consultants, Developers, System Administrators, and System Architects Overview Understand the need for an enterprise portalLog on to, navigate, and personalize the portalDescribe the components of SAP Enterprise PortalBuild-up a portal navigation structureAdapt the portal user interface to company specificationsExplain and use the main functions of the SAP Enterprise Portal, Knowledge Management and CollaborationExplain and use the community features of the portal add-ons Forums and WikisExplain and use the SAP Fiori Launchpad on Portal' In this course, students will gain knowledge of the basic fundamentals surrounding the SAP Enterprise Portal. Enterprise Portal Explaining Business Motivations for Portals Describing SAP NetWeaver Explaining the Basics of SAP Enterprise Portal The End User's Perspective Logging On and Navigating in SAP Enterprise Portal Personalizing SAP Enterprise Portal Technical Infrastructure Determining System Requirements Outlining SAP Enterprise Portal's Architecture Portal Platform Content Explaining the Object Model for Portal Content Managing iViews Managing Portal Pages Managing Worksets and Portal Roles Explaining Business Packages Outlining Portal Content Development Tools Translating Portal Content Look and Feel of the Portal Managing Portal Themes Managing Framework Pages Managing Portal Desktops Managing Portal Rules (Rule Collections) Security Aspects Identifying Security Aspects Managing Users and Authentication Options Describing Authorization Concepts Describing Single Sign-On (SSO) Evaluating Network Security Knowledge Management (KM) Outlining Knowledge Management (KM) Describing Content Management (CM) Functions Using Web Page Composer (WPC) Describing Search and Classification (TREX) Enterprise Workspaces Explaining Enterprise Workspaces Managing Personal Workspaces Managing Shared Workspaces Collaboration Outlining Collaboration Functions Using Forums Using Wikis Fiori Launchpad on the Portal Outlining SAP Fiori Launchpad on Portal Additional course details: Nexus Humans SAPEP SAP Enterprise Portal - Fundamentals 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 SAPEP SAP Enterprise Portal - Fundamentals 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 3 Days 18 CPD hours This course is intended for Technology Consultant System Administrator Application Consultant Overview This course will prepare you to: Set up SLT configurations, replicate data into different targets (such as SAP HANA, SAP BW or Central Finance) and monitor the data replication. In this course, you will learn how to use the trigger based real time data replication technology of the SAP LT Replication Server (SLT). SAP Landscape Replication Server Overview Explaining Positioning and Key Concepts Identifying Use Cases Understanding SLT as Part of the DMIS Product Family SAP Landscape Transformation Server Introduction Understanding the Architectural Concept Explaining the Landscape Strategy and Sizing Aspects Outlining the SLT Installation Procedure Replication to SAP HANA Setting Up Data Replication Executing Data Replication Understanding Advanced Replication Settings Outlining Operations and Monitoring Describing SLT Handling in Special Cases Replication to SAP BW Providing a Scenario Overview Explaining Open Data Provisioning (ODP) Describing Table-Based Replication Comparing Table-Based Replication and ODP Replication to SAP Data Services Explaining SAP Data Services and Architecture Describing the Setup of Replication to SAP Data Services Replication to ABAP Systems Describing the Architecture for Replication into an ABAP System Outlining the Setup for Replication into an ABAP System Replication to Non-SAP Databases Describing the Architecture for Replication to Non-SAP Databases Understanding the Setup of ABAP to Non-ABAP Replication Replication to Central Finance Describing the Architecture for Replication to Central Finance Understanding the Setup and Configuration of Replication to Central Finance SAP Landscape Transformation Replication Server Summary Providing a Summary of the SAP Landscape Transformation Replication Server SAP Landscape Transformation Replication Server 3.0 and Recent Updates Outlining SAP Landscape Transformation Replication Server 3 Updates Additional course details: Nexus Humans SAP Real-time Replication with SAP LT Replication Server (SLT100) 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 SAP Real-time Replication with SAP LT Replication Server (SLT100) 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.