1663 Database courses

Have you ever wondered how businesses transform raw data into actionable insights or how financial analysts accurately pinpoint market trends? Microsoft Excel stands tall as the fulcrum that balances numerous sectors of the business world. This 8-course Microsoft Excel Mastery: AutoCAD, SQL, Data Analysis, Financial Modelling & Marketing bundle dives deep into the myriad applications of Microsoft Excel, from interfacing with AutoCAD to crafting marketing strategies and comprehensive financial models. In an era defined by data-driven decisions, this 8-course Microsoft Excel Mastery: AutoCAD, SQL, Data Analysis, Financial Modelling & Marketing bundle is tailored to equip learners with the multifaceted applications of Microsoft Excel. Ranging from foundational Excel operations to advanced integrations with tools like AutoCAD and MySQL, the course bundle aims to foster expertise in data management, analysis, and visualisation. Whether you're venturing into financial modelling, HR analytics, or design integration, this bundle serves as a comprehensive guide to mastering Excel in diverse professional realms, ensuring you are well-prepared to leverage its capabilities in the modern workplace. Ready to excel in your career? Embrace the transformative power of data and design by mastering Microsoft Excel with our comprehensive course bundle. Dive in now and shape your future with unparalleled proficiency! The Eight CPD Accredited courses that the bundle includes are: Course 1: Microsoft Excel Course for Everyone - Complete Excel Course Course 2: Excel VBA/Macros Foundations Course 3: Dynamic Excel Gantt Chart and Timelines Course 4: Hands on Programming on AutoCAD to Excel Using VB.NET Course 5: Learn MySQL from Scratch for Data Science and Analytics Course 6: Data Analytics Course 7: Build HR Dashboard using Excel Course 8: Financial Modelling Using Excel Learning Outcomes: Gain comprehensive knowledge and understanding of Microsoft Excel and its vast capabilities. Understand the seamless integration between Excel and tools like AutoCAD and MySQL. Develop proficiency in creating intricate financial models and marketing strategies. Acquire skills to analyse data, forecast trends, and build informative dashboards. Learn the principles of personal finance management using Excel. Master the art of crafting Gantt charts and timelines for effective project management. Microsoft Excel Course for Everyone - Complete Excel Course: Acquaint yourself with the foundational and advanced facets of Microsoft Excel, fostering data management expertise. Excel VBA/Macros Foundations: Dive into the transformative world of VBA, unlocking Excel's programming potentials. Dynamic Excel Gantt Chart and Timelines: Grasp the essentials of project management by designing insightful Gantt charts and timelines in Excel. Hands on Programming on AutoCAD to Excel Using VB.NET: Bridge the realms of design and data by merging AutoCAD functionalities with Microsoft Excel's prowess. Learn MySQL from Scratch for Data Science and Analytics: Understand the confluence of Excel and MySQL, anchoring data science and analytics. Data Analytics: Master the techniques of transforming raw numbers into actionable insights using Microsoft Excel. Build HR Dashboard using Excel: Curate informative HR dashboards, offering a snapshot of organisational metrics, all within Excel. Financial Modelling Using Excel: Unravel the intricacies of financial markets, crafting accurate models in Microsoft Excel. CPD 90 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on enhancing their Microsoft Excel skills for professional or personal reasons. Marketing professionals aiming to refine their strategic planning with Excel. Financial analysts and enthusiasts looking to build and understand models in Excel. Data scientists and analysts desire to integrate Excel with tools like MySQL. Design engineers and architects keen on integrating AutoCAD designs with Excel data. Career path Data Analyst Financial Modeller Marketing Strategist HR Dashboard Specialist Database Administrator (with Excel integration knowledge) Project Manager (familiar with Gantt and timelines in Excel) Design Engineer using Excel with AutoCAD Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript: £9.99

CSCS is the leading Construction Skills Certification Scheme within the UK construction industry to ensure safety standards are high and maintained within the construction industry in the UK. CSCS cards provide proof that individuals working on construction sites have the required training in Construction Health and Safety awareness for the type of work they carry out.

Step into the future with our 'Level 4 Diploma in Information Management', a beacon of guidance in the digital age. As information becomes the currency of our era, understanding how to efficiently manage, strategise, and safeguard it has never been more pivotal. From the foundational principles to the complexities of Management Information Systems, this course tailors a journey that unveils the marvels of contemporary data handling. Unlock the magic behind databases, audit processes, and the ethical concerns enveloping information - all curated meticulously for the modern learner. Learning Outcomes Understand the foundational principles of Information Management. Formulate and implement effective Information Management strategies. Gain proficiency in the workings of Management Information Systems (MIS). Acquire the skills to conduct an information systems audit. Grasp the ethical considerations and data protection measures in the realm of information. Why choose this Level 4 Diploma in Information Management course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Level 4 Diploma in Information Management Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Level 4 Diploma in Information Management course for? Aspiring data strategists keen to mould the future. Information officers aiming to upgrade their knowledge landscape. Database enthusiasts eager to dive deeper. Managers looking to enhance their organisational data systems. Ethical hackers and cybersecurity buffs aiming for a broader perspective. Career path Information Strategist - £45,000 - £70,000 Data Protection Officer - £40,000 - £60,000 MIS Analyst - £50,000 - £75,000 Systems Audit Specialist - £55,000 - £80,000 Information Management Consultant - £48,000 - £73,000 Database Administrator - £42,000 - £68,000 Prerequisites This Level 4 Diploma in Information Management does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Level 4 Diploma in Information Management was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Introduction to Information Management Introduction to Information Management 00:32:00 Module 02: Information Management Strategy Information Management Strategy 00:17:00 Module 03: Databases and Information Management Databases and Information Management 00:29:00 Module 04: Management Information Systems (MIS) Management Information Systems (MIS) 00:16:00 Module 05: Auditing Information Systems Auditing Information Systems 00:16:00 Module 06: Ethical and Social Issues and Data Protection Ethical and Social Issues and Data Protection 00:27:00 Assignment Assignment - Level 4 Diploma in Information Management 00:00:00

Duration 4.5 Days 27 CPD hours This course is intended for This intermediate course is for people who are new to the RACF component of the z/OS Security Server, and responsible for security administration. This includes people who are planning to implement RACF for the first time, and people who are security administrators in installations where RACF is already implemented. Those inexperienced z/OS users may find the course Basics of z/OS RACF Administration (ES19) more appropriate Overview Identify the security requirements of a system Evaluate the facilities and options of RACF Define users to RACF Set up a RACF group structure Use RACF to protect resources Select options to tailor RACF Evaluate and implement RACF database and performance options Identify tools available for auditing Administer the system so that it is consistent with the installation's security goals Be a more effective security administrator using the RACF component of the z/OS Security Server to define users, set up group structures, define general resources, protect z/OS data sets, & use several RACF utilities. Security and RACF overview . Administering groups and users . Protecting z/OS data sets . Introduction to user administration and delegation and general resources . RACF database, tables, and performance options . RACF utilities and exits . RACF options . Auditing the RACF environment . Storage management and RACF . Security for JES facilities . Security classification .

Limited Time Sales: CPD Certified | 37 Video Lessons | Free PDF Certificate | Lifetime Access

Duration 3.5 Days 21 CPD hours This course is intended for This course is for AWS Cloud Architects with expertise in designing and implementing solutions running on AWS who now want to design for Microsoft Azure. Overview After completing this course, students will be able to: Secure identities with Azure Active Directory and users and groups. Implement identity solutions spanning on-premises and cloud-based capabilities Apply monitoring solutions for collecting, combining, and analyzing data from different sources. Manage subscriptions, accounts, Azure policies, and Role-Based Access Control. Administer Azure using the Resource Manager, Azure portal, Cloud Shell, and CLI. Configure intersite connectivity solutions like VNet Peering, and virtual network gateways. Administer Azure App Service, Azure Container Instances, and Kubernetes. This course teaches Solutions Architects who have previously designed for Amazon Web Services how to translate business requirements into secure, scalable, and reliable solutions for Azure. Introduction to Azure Subscriptions and accounts Resource groups and templates in Azure Resource Manager Azure global infrastructure Azure regions Azure Availability Zones Comparison with AWS Implement Azure Active Directory Introduction to Azure Active Directory Domains and custom domains Safety features Guest users in Azure Active Directory Manage multiple directories Comparison with AWS Implement and manage hybrid identities Introduction to Azure AD Connect Comparison with AWS Implement virtual networking Azure Virtual Network and VNet peering VPN and ExpressRoute connections Comparison with AWS Implement VMs for Windows and Linux Configure high availability Comparison with AWS Implement load balancing and network security Implement Azure Load Balancer Implement an Azure Application Gateway Implement Azure Firewall Implement network security groups and application security groups Comparison with AWS Implement container-based applications Configure Azure Kubernetes Service Publish a solution on an Azure Container Instance Comparison with AWS Implement an application infrastructure Create an App Service plan Create and configure Azure App Service Configure networking for an App Service Introduction to Logic Apps and Azure Functions Comparison with AWS Implement storage accounts Azure Storage core concepts Managing the Azure Blob storage lifecycle Working with Azure Blob storage Comparison with AWS Implement NoSQL databases Introduction to Azure Cosmos DB Consistency Select appropriate CosmosDB APIs Set up replicas in CosmosDB Comparison with AWS DynamoDB Implement Azure SQL databases Configure Azure SQL database settings Implement Azure SQL Database managed instances Configure high availability for an Azure SQL database Comparison with AWS Implement cloud infrastructure monitoring Monitor security Monitor cost Configure a Log Analytics workspace Comparison with AWS Implement and manage Azure governance solutions Assign RBAC roles Configure management access to Azure Implement and configure an Azure Policy Comparison with AWS Manage security for applications Implement Azure Key Vault Implement and configure Azure AD Managed Identities Register and manage applications in Azure AD Comparison with AWS Migration, backup, and disaster recovery management Migrate workloads Implement Azure Backup for VMs Implement disaster recovery Comparison with AWS

On this course we go into far greater detail on understanding the dog’s needs, behaviour, state of mind, language, and improving your leadership skills.

The course is a four hour refresher session for those who have completed the Mental Health First Aid two or one day course. Just like physical first aid, we recommend you refresh your skills regularly and keep up-to-date. The four-hour MHFA Refresher course will support MHFAiders® by:  Renewing their skills Updating their knowledge of mental health supports Giving them the chance to practice applying the Mental Health First Aid action plan Providing them access to three years of MHFAider® support and benefits Please note the MHFA Refresher is only for people who have previously complete the MHFA course.Format This is a half day course delivered online Learning takes place through a mix of presentations, group discussions and workshop activities We limit numbers to 25 people per course so that the instructor can keep people safe and supported while they learn What are the MHFAider support & benefits? With access to MHFAider® support and benefits, training doesn't stop when the course comes to an end. We provide continuous support for MHFAiders® – well beyond initial certification – so they are confident, empowered and motivated to carry out their role.  MHFAiders® get automatic 24/7 digital support through the MHFAider Support App®. From there they will find exclusive resources, ongoing learning opportunities and the benefit of joining England’s largest community of trained MHFAiders®.  Access includes:  A resource library of toolkits, guidance, animations and core mental health concepts to support them in their role as an MHFAider® A signposting database through Hub of Hope to find local and national mental health services for additional support Secure conversation journalling to make reflective notes while protecting confidentiality Reminders for wellbeing check ins with the people MHFAiders® are supporting 24/7 text support services through Shout for advice and reassurance on a mental health conversation or to support wellbeing after a difficult conversation Exclusive quarterly webinars to embed and broaden mental health knowledge The benefit of joining England’s largest community of trained MHFAiders®

Getting Started The qualifications are designed to empower individuals with the opportunity to establish a promising career in the field of Information Technology Networking (IT) by fostering a deeper understanding and knowledge of the industry. They are tailored to support individuals in their journey towards technical roles within the IT sector. The overarching objectives include: Empowering learners to apply analytical and evaluative techniques effectively in both private and public sector business environments. Strengthening analytical and evaluative skills relevant to a diverse range of industries, fostering adaptability and versatility. Cultivating the learner's capacity to identify and contemplate their personal learning and development process, thereby facilitating the growth of essential personal, interpersonal, and transferable skills. Promoting self-reflection and enhancing intellectual and transferable skills among learners. Key Benefits Comprehend the ethical considerations within the realm of information technology. Gain a fundamental understanding of the statistical principles that underlie information technology. Gain a comprehensive understanding of both Windows and Linux operating systems. Create a database system. Acquire a deep understanding of the principles and concepts of logical networking. Utilise the various components of physical networking effectively. Key Highlights Are you a practicing IT professional seeking greater knowledge and understanding of the industry to support your development into senior positions? Then, the Qualifi Level 4 Diploma in Information Technology- Networking is the ideal starting point for your career journey. This course is designed to pave the way for a career and to help individuals prepare for roles as professional staff and future managers in the health and social care sector. Remember, the assessment for this qualification is based solely on assignments, so there's no need to worry about taking exams. With the School of Business and Technology London, you can complete the qualification at your own pace, choosing between online or blended learning from the comfort of your home. Access learning materials, pathway materials, and study guides developed by our Qualifi-approved tutors, available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we provide comprehensive tutor support through our dedicated support desk. If you opt for blended learning, you'll also have the opportunity to participate in live sessions with an assigned tutor, which you can schedule at your convenience. Career Pathways Upon completion of the Level 4 Diploma in Information Technology- Networking, graduates may pursue various career paths in education and training, such as: Network Administrator; with an estimated average salary of £38,641 per annum Network Engineer; with an estimated average salary of £48,297 per annum Cloud Network Engineer; with an estimated average salary of between £55,000 per annum System Administrator; with an estimated average salary of £37,768 per annum About Awarding Body QUALIFI, recognised by Ofqual awarding organisation has assembled a reputation for maintaining significant skills in a wide range of job roles and industries which comprises Leadership, Hospitality & Catering, Health and Social Care, Enterprise and Management, Process Outsourcing and Public Services. They are liable for awarding organisations and thereby ensuring quality assurance in Wales and Northern Ireland. Assessment Assignment based Assessment No exam Entry Requirements The qualification has been intentionally designed to ensure accessibility without unnecessary obstacles hindering entry and advancement. To enrol in the qualification: You should have a certain level of proficiency and hold a Qualification at Level 3, such as an 'A' Level or any vocational certificate. You are actively pursuing additional professional development to acquire job-related skills and practical knowledge. For international students whose first language is not English, they will need to have a score of 6 or above in IELTS (International English Language Testing System). Progression Learners who successfully complete any of the corresponding QUALIFI Level 4 Diplomas in IT-Networking have various advancement options, including: Transitioning to the QUALIFI Level 5 Diplomas in IT-Networking. Moving on to the second year of undergraduate programs in fields such as Computer Science, Information Technology, or related disciplines. Entering the workforce directly in a relevant professional capacity. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Information Technology and IT Ethics. Reference No : L/617/6692 Credit : 20 || TQT : 200 The objective of this unit is to enhance learners' understanding and utilization of information technology, including the use of standard office applications for creating documents and presentations. UNIT2- Mathematics and Statistics for IT Reference No : R/617/6693 Credit : 20 || TQT : 200 The primary goal of this unit is to offer learners the opportunity to acquire proficiency in mathematics and statistics, equipping them with the mathematical capabilities necessary to analyse and resolve problems, preparing them for roles within the IT field. UNIT3- PC Maintenance and Operating Systems Reference No : Y/617/6694 Credit : 20 || TQT : 200 The objective of this unit is to impart knowledge regarding personal computer hardware. Successfully completing this unit will empower learners to perform tasks such as installing a computer system unit and operating system, as well as conducting troubleshooting procedures. UNIT4- Computer Graphics Editing and Database Concepts Reference No : D/617/6695 Credit : 20 || TQT : 200 The purpose of this unit is to elucidate the concepts of photo editing. This knowledge will empower learners to seamlessly integrate photos into documents, such as user manuals and the IT infrastructure documentation of an organization. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing