4315 Courses delivered Online

Duration 3 Days 18 CPD hours This course is intended for The ideal audience for this course includes database enthusiasts, IT professionals, and developers who are eager to expand their knowledge and skill set in database management and optimization. Roles that would greatly benefit from attending this course include: Database Developers: Those who design, implement, and maintain databases as part of their primary responsibilities and want to improve their expertise in schema design, query optimization, and advanced database features. Backend Developers: Professionals who work on server-side application logic and require a strong understanding of database management to integrate data storage and retrieval processes into their applications. Overview Upon completing this course, database developers will be able to: Design and implement efficient database schemas by employing normalization techniques, appropriate indexing strategies, and partitioning methods to optimize data storage and retrieval processes. Develop advanced SQL queries, including joining multiple tables, utilizing subqueries, and aggregating data, to extract valuable insights and facilitate decision-making processes. Implement stored procedures, functions, and triggers to automate common database tasks, enforce data integrity, and improve overall application performance. Apply database performance tuning techniques, such as query optimization, index management, and transaction control, to ensure optimal resource usage and enhanced system responsiveness. Integrate databases with various programming languages and platforms, enabling seamless data access and manipulation for web, mobile, and desktop applications. PostgreSQL is a powerful, open-source object-relational database management system that emphasizes extensibility, data integrity, and high performance. Its versatility and robust feature set make it an ideal choice for developers working on projects of all sizes, from small-scale applications to enterprise-level systems. By learning PostgreSQL, developers can tap into its advanced capabilities, such as full-text search, spatial data support, and customizable data types, allowing them to create efficient and scalable solutions tailored to their unique needs. PostgreSQL for Database Developers is a three-day hands-on course that explores the fundamentals of database management, covering everything from installation and management to advanced SQL functions. Designed for beginners and enthusiasts alike, this course will equip you with the knowledge and skills required to effectively harness the power of PostgreSQL in today's data-driven landscape. Throughout the course you?ll be immersed in a variety of essential topics, such as understanding data types, creating and managing indexes, working with array values, and optimizing queries for improved performance. You?ll gain valuable hands-on experience with real-world exercises, including the use of the psql client, writing triggers and stored procedures with PL/pgSQL, and exploring advanced SQL functions like Common Table Expressions (CTE), Window Functions, and Recursive Queries. You?ll exit this course with a solid foundation in PostgreSQL, enabling you to confidently navigate and manage your databases with ease and efficiency. Installing & Managing PostgreSQL PostgreSQL installation process Optimal configuration settings User and role management Database backup and restoration Overview of PostgreSQL Database PostgreSQL architecture overview Understanding database objects Efficient data storage Transaction management basics Using the psql client Introduction to psql Essential psql commands Executing queries effectively Managing databases with psql Understanding PostgreSQL data types Numeric data types explored Character and binary types Date, time, and boolean values Array and other types Understanding sequences Sequence creation and usage Customizing sequence behavior Implementing auto-increment columns Sequence manipulation and control Creating & managing indexes PostgreSQL index fundamentals Designing partial indexes Utilizing expression-based indexes Index management techniques Using COPY to load data COPY command overview Importing and exporting data Handling CSV and binary formats Performance considerations Working with Array Values Array value basics Array manipulation functions Querying arrays efficiently Multidimensional array handling Advanced SQL Functions Mastering Common Table Expressions Utilizing Window Functions Regular Expressions in SQL Crafting Recursive Queries Writing triggers & stored procedures with PL/pgSQL PL/pgSQL variables usage Implementing loop operations PERFORM and EXECUTE statements Developing PostgreSQL triggers Using the PostgreSQL query optimizer Query analysis and optimization EXPLAIN command insights PostgreSQL query operators Identifying performance bottlenecks Improving query performance Query performance tuning Index optimization strategies Efficient database partitioning Connection and resource management Wrap Up & Additional Resources Further learning opportunities Staying up-to-date with PostgreSQL Community engagement and support Additional course details: Nexus Humans PostgreSQL for Database Developers (TTDB7024) 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 PostgreSQL for Database Developers (TTDB7024) 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 5 Days 30 CPD hours This course is intended for This course is intended for an IT person wanting to learn about administrating SharePoint 2016. Overview After completing this course, you will be able to: The Installation and configure a SharePoint 2016 Farm How to manage a SharePoint 2016 Farm through the GUI and PowerShell How to create site collections via GUI and PowerShell How to create and configure the all the required service applications for SharePoint 2016 How to backup and restore in SharePoint 2016 This SharePoint 2016 Administrator course is design for Administrators who are new to SharePoint Server Administration or who are upgrading from previous versions of SharePoint.This course covers content that was in retired Microsoft Course 20339-1. Module 1: Hardware, Installation and Patching How to build a Min Role Farm How to View ULS Logs How to document and check IIS Settings for SharePoint 2016 Module 2: Farm Management How to manage the SharePoint Farm Administors group How to configure Outgoing Email How to configure Incoming Email How to Configure Diagnostic and Usage Log Options Module 3: Web Applications How to define a new Managed Account How to add new IP Addresses to a SharePoint Server How to create a claims based web application in SharePoint Central Administration How to create a claims based web application in PowerShell How to create a hosting web application in PowerShell Module 4: Site Collections How to create a managed path How to create a site collection using SharePoint Central Administration How to create a site collection using PowerShell How to create a site collection in its own database using SharePoint Central Administration How to create a site collection in its own database using PowerShell How to create a host named site collection using PowerShell Module 5: Service Applications How to create a State Service Application How to create a Search Service Application How to create the Managed Metadate Service Module 6: Application Management How to add a new IP and Certificate to a SharePoint Web Application How to configure DNS for SharePoint Web Application How to Create a Subscription Settings Service Application How to create the Application Management Application Service How to configure the application URLs How to create the App Catalog Site Colleciton How to Add Apps to the catalog Module 7: Managing the User Profile Service How to create the My Site Web Application How to create the User Profile Service Application How to Configure the User Profile Synchronization Permissions How to create the Active Directory Import Connection How to assign permissions for the AD Group to create a My Site How to create a My Site Module 8: Search How to view the currenty Search Topology How to create an Enterprise Search Centre How to configure a new search schema property How to create a site collection-level result source How to create a new content source Module 9: Office Online Server How to install the pre-requisites for Office Online Server How to install the Office Online Server Binaries How to create the Office Online Server SSL Certifcate How to create the Office Online Server Farm How to connect to the farm from SharePoint How to test the connectivity Module 10: Enterprise Content Management How to create and Apply a site policy How to create discovery sets How to configure In Place records management How to configure the records centre How to configure DLP Module 11: Web Content Management How to configure cross-site publication How to configure content deployment Module 12: Workflow Server How to install Workflow Manger server and Client Binaires How to configure the workflow farm How to patch the workflow farm manager and clients How to register the workflow service in SharePoint How to test Workflow creation Module 13: Business Connectity Services and Secure Store How to configure the secure store service How to create the BCS service Application How to setup the products database How to import the BCS Definition How to use the BDC file in a list web part Module 14: Hybrid SharePoint Shown and Demonstrated the Hybrid features of SharePoint 2016 Module 15: Backup and Restore How to backup SharePoint 2016 Content How to delete SharePoint 2016 Content How to restore SharePoint 2016 Content via PowerShell How to recover a unattached content database Module 16: Upgrade How to restore and attach a SharePoint 2013 Database How to upgrade a SharePoint 2013 MMS Service Application Additional course details: Nexus Humans 55355 SharePoint 2016 Administration 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 55355 SharePoint 2016 Administration 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.

🚀 Unlock Your Problem-Solving Potential with 'Tackling Problems in 12 Simple Steps' Online Course! 🌟 Are you tired of feeling overwhelmed by problems, unsure where to start or how to find solutions? Say goodbye to frustration and hello to effective problem-solving skills with our revolutionary online course! Introducing 'Tackling Problems in 12 Simple Steps' - your ultimate guide to conquering challenges effortlessly. Whether it's personal hurdles, professional roadblocks, or academic puzzles, this course equips you with a proven framework to tackle any problem head-on. 🎯 What You'll Gain:     A Strategic Blueprint: Master a systematic approach to dissecting and solving problems with ease. 12 Proven Steps: Learn practical, actionable steps designed to simplify even the most complex issues. Adaptability Skills: Gain the confidence to address diverse problems across various aspects of life. Problem-solving Mindset: Develop a resilient mindset to embrace challenges as opportunities for growth. Real-Life Applications: Apply these techniques immediately for instant results in your personal and professional life. 💡 Course Highlights: Engaging video modules led by industry experts. Interactive exercises to reinforce learning. Case studies illustrating the steps in action. Access to a supportive community for discussions and networking. Downloadable resources and tools for practical implementation.   🌟 Join thousands of satisfied learners who have transformed their problem-solving abilities with our course! Don't let obstacles hold you back - empower yourself to face challenges confidently. 🔥 Limited Time Offer: Enroll now and gain exclusive access to bonus materials and a special discount! Don't miss this opportunity to supercharge your problem-solving skills! 👉 Ready to take charge of your problem-solving journey? Enroll now in 'Tackling Problems in 12 Simple Steps' and start overcoming challenges like a pro! 💪 Course Curriculum

Duration 5 Days 30 CPD hours This course is intended for System Administrator Administrator Java EE Developer Web Administrator Technical Consultant Security Administrators Technical Administrator Overview Configure WebLogic features including domain templates, system start up, crash recovery, work managers, multi data sources, security policies, and automatic JTA migration Configure Coherence features Perform a rolling upgrade of WebLogic Server Write and run WLST scripts Deploy shared libraries and applications using deployment plans and versioning Configure SSL for WebLogic Server This Oracle WebLogic Server 12c: Administration II is a continuation of the Oracle WebLogic Server 12c: Administration I course. This Oracle WebLogic Server 12c: Administration II is a continuation of the Oracle WebLogic Server 12c: Administration I course.

Gain essential knowledge and practical skills related to nebuliser therapy with our comprehensive e-learning course. Designed for healthcare professionals, students, caregivers, and individuals interested in medical care. Join now!

Course Overview Ethical hacking, (or penetration testing) involves exploiting computer networks and systems to detect vulnerabilities that could be exposed to dangerous hackers. Many organisations use ethical hackers to test the security of their website or web applications, which is where the role of the Penetration Tester comes in. If you're looking to become a certified Penetration Tester or Ethical Hacker, then this is the course for you. It covers everything you need to know about security testing, including how to use Linux operating systems and SQL programming language.  Learn how to reduce the risk of a cyber attack with this step-by-step training course, designed to equip you with the skills to detect weaknesses in computer systems quickly and easily. It will familiarise you with a range of cyber attacks and techniques for securing systems, from how to create a fake WiFi network and even spy on your clients. Learn ethical hacking from scratch and enrol in this introductory training course today! What You Will Learn In this Ethical Hacking training course, you will learn how to exploit IT systems to detect vulnerabilities that attackers could take advantage of. It will provide you with the fundamental skills to become a qualified Penetration Tester. How to Hack a Windows 10 Computer & Access Their Webcam Installing Kali 2019 As a Virtual Machine A Basic Overview of Kali Linux and Linux Commands An Introduction to Network Penetration Testing Network Hacking - Pre Connection Attacks Website Hacking and Information Gathering Tips & Tricks An Introduction to SQL and SQLmap What is XSS or Cross-Site Scripting? How to Scan a Target Website For Vulnerabilities Extracting Sensitive Data Such As Passwords Why You Should Choose This Course From iStudy Study at your own pace Full Tutor support on weekdays (Monday - Friday) Fully compatible with any device Free Printable PDF Certificate immediately after completion No prior qualifications are needed to take this course No hidden fees or exam charges CPD Qualification Standards and IAO accredited Efficient exam system, assessment, and instant results Our customer support team is always ready to help you Gain professional skills and better earning potential Certification After completing the course you'll receive a free printable CPD accredited PDF certificate. Hard Copy certificate is also available, and you can get one for just £9! Accreditation This course is accredited by Continuing Professional Development (CPD). It is a recognised independent accreditation service. Enrol today and learn something new with iStudy. You'll find a full breakdown of the course curriculum down below, take a look and see just how much this course offers. We're sure you'll be satisfied with this course.

Diploma in Child Psychology | 15-in-1 CPD Certified Bundle | Free PDF Certificates | 24/7 Learner Support

Description Learn how to provision Azure SQL with the intensive course MS Azure - SQL. Microsoft Azure SQL is Microsoft's cloud database service, based on SQL Server database technology. It enables organizations to store relational data in the cloud and helps to quickly scale the size of their databases up or down as business needs change. Using Azure SQL, you can create, scale and extend applications into the cloud. Throughout the course, you will understand various databases that are available in Azure. The course teaches you how to provision, configure and manage Azure SQL. You will learn the procedures for working with SQL security metrics. You will know how to connect to Azure SQL DB and how to migrate DB to SQL. The course also shows you how to copy and export a database, and also how to manage data recovery and availability using DB Self-Service Restore. The system of configuring SQL DB auditing will also be discussed in the course. Lastly, the course focuses on SQL DB Geo-Replication. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? MS Azure - SQL is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our MS Azure - SQL is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:02:00 Azure SQL Azure SQL 00:02:00 Provisioning Azure SQL 00:06:00 Connecting to Azure SQL DB 00:08:00 Migrating to Azure DB 00:06:00 Understanding SQL Security 00:03:00 Understanding SQL DB Metrics and Auditing 00:05:00 Backing Up and Protecting your Database 00:05:00 Using SQL DB Geo-Replication 00:03:00 Conclusion Course Recap 00:02:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description A certificate program in customer service helps students gain entry-level customer service positions by teaching them how to use basic office computer applications, such as word processors, spreadsheets, and email programs. Students also learn how to study the product and give adequate information to customers. They also learn how to analyze basic behavioral patterns of different customer personalities and the right ways to deal with them. Who is the course for? Managers, supervisors and customer service staff, as well as staff in departments, directly deal with customers on daily basis in any kind of job or business. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Customer Service Basics course helps students to work as a company's client interaction and conflict-resolution representatives. Together with experience, you will stand high chances of promotion and ultimately gain the title of manager. Customer Service Basics Customer Service and Retention Templates 01:00:00 Customer Service & Retention Checklist 01:00:00 Customer Service Checklist 01:00:00 Mock Exam Mock Exam- Customer Service Basics 00:20:00 Final Exam Final Exam- Customer Service Basics 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Join us on a thought-provoking trip into the core of technology with our 'Embedded Systems with 8051 Microcontroller' course. Picture yourself unraveling the mysteries of embedded systems and delving into the intricacies of the 8051 microcontroller. This course is not just a series of modules; it's an odyssey into the world of programming, interfacing, and innovation. From the foundational concepts of embedded systems to the nitty-gritty of program creation for the 8051, each module is a stepping stone towards mastery. Imagine crafting projects that involve LED alternations, switch interfacing, and even the precise control of DC motors and relays. Join us, and let the 8051 microcontroller be your passport to unlocking a realm where circuits come to life, timers dictate precision, and serial communication is your language of control. As you progress through units on LCD and ADC interfacing, envision yourself creating schematics, writing code, and connecting with the essence of each concept. This course transcends theoretical knowledge, offering hands-on experience in program downloading using Nuvoton ICSP programmer and FlashMagic. The journey concludes not just with a module on conclusions but with a sense of empowerment, equipped with the skills to conquer the intricate world of embedded systems. Learning Outcomes Master the fundamentals of embedded systems, from the basics to the intricate workings of the 8051 microcontroller. Acquire proficiency in software installation, including the setup of the Keil IDE and the creation of initial projects. Develop expertise in input and output interfacing, covering LED concepts, for loops, and switch interfacing with the 8051. Explore advanced concepts, such as DC motor and relay interfacing, LCD concepts, and serial communication principles. Gain hands-on experience in timer concepts, timer as a counter, and analog-to-digital conversion with the LM35 temperature sensor, along with the practical skills of program downloading. Why choose this Embedded Systems with 8051 Microcontroller course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the 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. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Embedded Systems with 8051 Microcontroller course for? Electronics enthusiasts eager to delve into embedded systems and microcontroller programming. Students and beginners seeking a comprehensive understanding of 8051 microcontroller applications. Hobbyists with a keen interest in hands-on projects involving LEDs, switches, motors, and more. Aspiring engineers looking to enhance their skills in the field of embedded systems. DIY enthusiasts interested in crafting innovative projects with practical applications. Career path Embedded Systems Engineer: £40,000 - £60,000 Electronics Design Engineer: £35,000 - £55,000 Control Systems Engineer: £40,000 - £65,000 Microcontroller Programmer: £30,000 - £50,000 Hardware Development Engineer: £35,000 - £60,000 Automation Specialist: £45,000 - £70,000 Prerequisites This Embedded Systems with 8051 Microcontroller does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Embedded Systems with 8051 Microcontroller 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 Unit 01: Introduction Module 01: Introduction to the Course 00:03:00 Module 02: Introduction to Embedded Systems 00:20:00 Module 03: Introduction to 8051 Controller 00:15:00 Module 04: Program for 8051 00:13:00 Unit 02: Software Installation Module 01: Installation of Keil IDE 00:05:00 Module 02: First Project creation on Keil 00:05:00 Unit 03: Input And Output Interfacing Module 01: Concepts on LED 00:12:00 Module 02: Project based on Led Alternate on off 00:04:00 Module 03: Using For Loop 00:05:00 Unit 04: 8051 Interfaces Module 01: Switch Interfacing with 8051 00:13:00 Unit 05: Interfacing With DC Motor And Relay Module 01: Relay Interfacing 00:11:00 Module 02: Relay Interfacing Part 2 00:03:00 Module 03: Introduction to DC Motor 00:09:00 Module 04: DC Motor Interfacing Part 2 00:07:00 Unit 06: Concepts On LCD Module 01: Introduction to LCD 00:09:00 Module 02: Creating Schematics for LCD 00:07:00 Module 03: First Program on LCD 00:07:00 Module 04: LCD Interfacing - 4 00:08:00 Unit 07: Concepts On Serial Module 01: Serial Part-01 00:07:00 Module 02: Serial Part-02 00:13:00 Module 03: Serial Part-03 00:08:00 Module 04: Serial Part-04 00:08:00 Unit 08: Timer Concepts Module 01: Timer Part-01 00:08:00 Module 02: Timer Part-02 00:07:00 Module 03: Timer Part-03 00:06:00 Unit 09: Timer As Counter Module 01: Timer as Counter 00:08:00 Unit 10: ADC With LM35 Module 01: Analog to Digital Converter with 8051 - Part 1 00:10:00 Module 02: Analog to Digital Converter with 8051 - Part 2 00:07:00 Module 03: Analog to Digital Converter with 8051 - Part 3 00:10:00 Module 04: Analog to Digital Converter with 8051 use LM35 Temperature Sensor 00:11:00 Unit 11: Stepper Motor And Program For Stepper Motor Module 01: Concepts around Stepper Motor [34] 00:15:00 Unit 12: Program Downloading Module 01: Program Downloading Using Nuvoton ICSP Programmer 00:09:00 Module 02: Program (Hex File) Downloading using FlashMagic to P89v51RD2 Controller 00:16:00 Unit 13: Conclusion Conclusion 00:01:00