• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

7965 Insights courses in London delivered Online

SQL For Data Analytics & Database Development

4.5(3)

By Studyhub UK

In an era awash with data, understanding it is the key to unlocking significant opportunities. Enter the realm of 'SQL For Data Analytics & Database Development'. Dive deep into the heart of data manipulation, exploration, and insight generation. This course unfurls the magic behind SQL, drawing back the curtain on the tools that empower businesses globally. Understanding SQL's profound capabilities opens doors to a world where data-driven decision-making is not just an advantage but an imperative. It isn't simply about data storage. This course unravels the art of analytics, shedding light on how to glean valuable insights from vast data lakes. The path of SQL isn't merely technical; it's the spine of transformative decisions in today's leading industries. Offering a systematic approach to database development, we invite you to embark on this illuminative journey, stitching the threads of raw data into the fabric of meaningful stories. Come harness the power of SQL. Whether your intent is data analytics or the intricate craft of database development, this is your gateway. Let us guide you, from the rudimentary steps to mastering advanced commands, constructing your data narrative, and informing the future. Learning Outcomes: Comprehend the fundamental architecture of SQL and its environment. Acquire proficiency in basic and advanced SQL statements. Understand and implement GROUP BY statements for data aggregation. Master the concepts and applications of JOINS in databases. Cultivate the ability to create and structure databases and tables. Delve into advanced SQL commands, enhancing data manipulation and querying capabilities. Construct efficient database models, fostering optimal data storage and retrieval.   Video Playerhttps://studyhub.org.uk/wp-content/uploads/2021/03/SQL-DATA-ANALYSIS.mp400:0000:0000:00Use Up/Down Arrow keys to increase or decrease volume. Why choose this SQL For Data Analytics & Database Development 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 SQL For Data Analytics & Database Development 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 SQL For Data Analytics & Database Development course for? Aspirants seeking to transition into data-driven roles in various industries. Database administrators aiming to broaden their analytical capabilities. Business analysts eager to enhance their data querying skills. Researchers in need of comprehensive data management tools. Tech enthusiasts wanting to grasp the underpinnings of database systems. Career path Data Analyst - Average salary: £35,000 - £50,000 Per Annum Database Developer - Average salary: £40,000 - £55,000 Per Annum Business Intelligence Analyst - Average salary: £38,000 - £52,000 Per Annum SQL Developer - Average salary: £42,000 - £58,000 Per Annum Database Administrator (DBA) - Average salary: £45,000 - £60,000 Per Annum Data Engineer - Average salary: £47,000 - £63,000 Per Annum Prerequisites This SQL For Data Analytics & Database Development 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 Course Introduction Introduction 00:04:00 Course Curriculum Overview 00:05:00 Overview of Databases 00:10:00 SQL Environment Setup MySQL Installation 00:16:00 MySQL Workbench Installation 00:09:00 Connecting to MySQL using Console 00:09:00 SQL Statement Basics Overview of Challenges 00:04:00 SQL Statement Basic 00:16:00 SELECT Statement 00:09:00 SELECT DISTINCT 00:05:00 Column AS Statement 00:12:00 COUNT built-in Method usage 00:11:00 SELECT WHERE Clause - Part One 00:05:00 SELECT WHERE Clause - Part Two 00:11:00 SQL Statement Basic 00:16:00 SQL Limit Clause Statement 00:09:00 SQL Using BETWEEN with Same Column Data 00:11:00 How to Apply IN Operator 00:11:00 Wildcard Characters with LIKE and ILIKE 00:11:00 GROUP BY Statements Overview of GROUP BY 00:06:00 Aggregation function SUM() 00:09:00 Aggregation MIN() and MAX() 00:05:00 GROUP BY - One 00:09:00 GROUP BY - Two 00:12:00 HAVING Clause 00:05:00 JOINS Overview of JOINS 00:04:00 Introduction to JOINS 00:04:00 AS Statement table 00:03:00 INNER Joins 00:14:00 FULL Outer Join 00:11:00 LEFT Outer JOIN 00:08:00 RIGHT JOIN 00:08:00 Union 00:07:00 Advanced SQL Commands / Statements Timestamps 00:12:00 EXTRACT from timestamp 00:10:00 Mathematical Functions 00:12:00 String Functions 00:22:00 SUBQUERY 00:13:00 Creating Database and Tables Basic of Database and Tables 00:06:00 DataTypes 00:10:00 Primarykey and Foreignkey 00:06:00 Create Table in SQL Script 00:13:00 Insert 00:11:00 Update 00:07:00 Delete 00:04:00 Alter Table 00:09:00 Drop Table 00:05:00 NOT NULL Constraint 00:08:00 UNIQUE Constraint 00:09:00 Databases and Tables Creating a Database backup 00:12:00 10a Overview of Databases and Tables 00:05:00 10c Restoring a Database 00:07:00

SQL For Data Analytics & Database Development
Delivered Online On Demand7 hours 50 minutes
£10.99

Make-up

4.5(3)

By Studyhub UK

The 'Make-up' course offers a comprehensive training program covering various aspects of makeup application and skincare. Participants will learn makeup techniques, beauty tips, and skin care knowledge to enhance their skills and become proficient in the field of makeup artistry. Learning Outcomes: Acquire knowledge and skills to use makeup brushes effectively for different makeup applications. Understand the essentials of building a professional makeup kit and etiquette on set. Learn color correcting techniques for a flawless makeup base. Explore makeup artistry in film, television, and bridal contexts. Master tattoo covering and techniques for natural beauty and glamour makeup. Gain expertise in makeup application for teenagers and sophisticated ladies. Learn airbrush makeup techniques for a seamless finish. Acquire skin nutrition insights and detox your makeup bag for healthier choices. Understand henna hair color application and fast start business training for aspiring beauty professionals. Learn skincare and tanning techniques, facials, and various hair removal options. Explore spa treatments, essential oils, and luxury skincare at home. Master techniques for concealing and correcting under-eye areas and improve overall health routines. Understand the significance of LED light therapy and explore the impact of different cosmetic ingredients. Acquire knowledge about aromatherapy, dry brushing, and earthing practices. Learn about natural teeth whitening, tanning options, and the importance of toxin-free skincare products. Why buy this Make-up? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Make-up you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Make-up does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Prerequisites This Make-up 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. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Make-up is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Make Up Make Up - Course 1 - Beauty Brushes 00:55:00 Make Up - Course 2 - Your Makeup Kit 00:46:00 Make Up - Course 3 - Etiquette On Set 00:36:00 Make Up - Course 4 - How to Use Color Correctors 00:11:00 Make Up - Course 5 - Film & Television Makeup Artistry 00:54:00 Make Up - Course 6 - Tattoo Covering 00:27:00 Make Up - Course 7 - Tips On Natural Beauty Makeup 00:05:00 Make Up - Course 8 - Tips On Glamour Makeup 00:57:00 Make Up - Course 9 - How To Tips for Teenage Makeup 00:55:00 Make Up - Course 10 - Makeup Tips for Sophisticated Ladies 00:28:00 Make Up - Course 11 - Airbrush Makeup 00:26:00 Make Up - Course 12 - Bridal Makeup 01:00:00 Make Up - Course 13 - Eyes and Lips 00:19:00 Make Up - Course 14 - Be Camera Ready 01:12:00 Make Up - Course 15 - Skin Nutrition 00:41:00 Make Up - Course 16 - Detox Your Makeup Bag & Travel Like a Boss 00:31:00 Make Up - Course 17 - Henna Hair Color 00:05:00 Make Up - Course 18 - Fast Start Business Training 00:11:00 Make Up - Course 19 - What Does Bethany do to Stay Fresh 00:23:00 Skin Care Skin Care - Course 1 - Skin Care and Tanning 00:41:00 Skin Care - Course 2 - Facials 01:50:00 Skin Care - Course 3 - Hair Removal Options 00:18:00 Skin Care - Course 4 - Dermaplaning 00:23:00 Skin Care - Course 5 - Esthetician Tools 00:12:00 Skin Care - Course 5 - Know your Toxic ingredients 00:16:00 Skin Care - Course 6 - LED Light Therapy 00:21:00 Skin Care - Course 7 - Microneedling 00:37:00 Skin Care - Course 8 - Natural and Chemical Peels 00:23:00 Skin Care - Course 9 - Skincare Using Spices 00:16:00 Skin Care - Course 10 - Skin Disorder and Diseases 00:08:00 Skin Care - Course 11 - Sugaring 00:15:00 Skin Care - Course 12 - Tinting 00:30:00 Skin Care - Course 13 - How To Be and Get Camera Ready 01:01:00 Skin Care - Course 14 - Why No Microdermabrasion 00:08:00 Skin Care - Course 15 - Food Knowledge 00:13:00 Skin Care - Course 16 - Skincare Using Spices 00:11:00 Things To Know As a Beauty Professional Course 1- Aromatherapy and Essential Oils 00:29:00 Course 2- Detox Your Deodorant 00:11:00 Course 3 - Dry Brushing 00:07:00 Course 4 - Face Masks 00:07:00 Course 5 - Find Your Perfect Color 00:12:00 Course 6 - Go Earthing 00:05:00 Course 7- Good Morning Detox 00:07:00 Course 8- Hot Flashes 00:05:00 Course 9 - Luxury Spa Treatments at Home 00:10:00 Course 10 - How to Conceal and Correct Under Your Eyes 00:16:00 Course 11 - Make-Up Your Health Routine 00:17:00 Course 12- Oil Pulling- Natural Teeth Whitening 00:04:00 Course 13 - Tanning Beds or Spray Tanning 00:09:00 Course 14 - What's in Your Lipstick 00:12:00 Course 15 - What's All the Fuss About LED Light Ther 00:06:00

Make-up
Delivered Online On Demand21 hours 22 minutes
£10.99

Construction Management, Standards & Estimation for Surveyors Course

5.0(2)

By Training Express

Stepping into the world of construction oversight requires more than just understanding bricks and mortar—it’s about knowing what makes a site tick, from budgets to blueprints. This course is designed specifically for surveyors and those interested in project estimation, construction standards, and managerial know-how. It offers structured insights into the planning, coordination, and financial breakdown of construction projects—making it a sharp pick for learners looking to explore the logic behind construction site decisions and development frameworks. With a well-laid foundation in estimation techniques, health and safety considerations, procurement strategies and construction regulations, this training brings clarity to an industry known for its complex layers. Whether you're reviewing quantities or forecasting project costs, the modules are laid out with precision—keeping things informative, digestible, and anything but dry. If your spreadsheet speaks louder than your toolkit, you’re definitely in the right place. Key Features of Construction Management, Standards & Estimation for Surveyors Bundle CPD Accredited Construction Management, Standards & Estimation for Surveyors Course Instant PDF certificate Fully online, interactive Construction Management, Standards & Estimation for Surveyorscourse Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Enrol now in this Construction Management, Standards & Estimation for Surveyors Bundle course to excel! To become successful in your profession, you must have a specific set of Construction Management, Standards & Estimation for Surveyors skills to succeed in today's competitive world. In this in-depth Construction Management, Standards & Estimation for Surveyorstraining course, you will develop the most in-demand Construction Management, Standards & Estimation for Surveyors skills to kickstart your career, as well as upgrade your existing knowledge & skills. Construction Management, Standards & Estimation for Surveyors Curriculum Course 01: Construction Management Course 02: CDM - Construction Design and Management Course 03: Health and Safety Management for Construction (UK) Course 04: Construction Cost Estimation Using Xactimate Course 05: Construction Estimation using RSMeans Course 06: LEED V4: Building Design and Construction Course 07: Land Surveying and Cost Estimation Course 08: Quantity Surveying Course 09: Property Development Diploma Course 10: Level 5 CAD Designer Training Course 11: Manual Handling at Work Course 12: Working at Height Training Course 13: Working in Confined Spaces Training Accreditation This bundle courses are CPD accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). CPD 130 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Construction Management, Standards & Estimation for Surveyors basics. Requirements No prior degree or experience is required to enrol in this course. Career path This Construction Management, Standards & Estimation for Surveyors Course will help you to explore avariety of career paths in the related industry. Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.

Construction Management, Standards & Estimation for Surveyors Course
Delivered Online On Demand1 hour
£74

Cisco Introducing IP Fundamentals of Cisco Fabric for Media v2.0 (IPFMFD)

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This course is designed for broadcast engineers with no previous IP experience. Overview After taking this course, you should be able to: Identify the components of a computer network and describe their basic characteristics. Describe network fundamentals,and explain a simple LAN. Describe hardware and wiring that is used to build a network. Describe the Open Systems Interconnection (OSI) reference model. Explain the datalink layer characteristics, Ethernet protocol, and switch operation. Introduce students to key network layer components, definitions, and standards. Explain the purpose and functions of the transport layer. Describe end-to-end packet delivery. Describe routing. Describe multicast networks, applications, and protocols. Explain data center architecture in each layer and describe new leaf-spine topology approaches. Explain virtualization and software-defined networking (SDN). The Introducing IP Fundamentals of Cisco Fabric for Media(IPFMFD) v2.0 course introduces you to Internet Protocol (IP) technologies. This course covers Ethernet functions and standards, the basic principles of IP, the Transmission Control Protocol/Internet Protocol (TCP/IP) stack, and other technologies used in modern networks. Lab exercises focus on configuring basic IP functionality on switches and servers. Course Outline Course Introduction Ethernet Hardware Describing the OSI and TCP/IP Models Understanding Ethernet and Switch Operation Describing IPv4 Network Layer Addressing Understanding the TCP/IP Transport Layer Packet Delivery Process Describing Routing IP Multicast Describing Data Center Network Architectures Virtualization and Software-Defined Networking Additional course details: Nexus Humans Cisco Introducing IP Fundamentals of Cisco Fabric for Media v2.0 (IPFMFD) 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 Cisco Introducing IP Fundamentals of Cisco Fabric for Media v2.0 (IPFMFD) 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.

Cisco Introducing IP Fundamentals of Cisco Fabric for Media v2.0 (IPFMFD)
Delivered OnlineFlexible Dates
Price on Enquiry

Understanding Cisco SDA Fundamentals (SDAFND)

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for Field engineers Network engineers Network administrators System engineers Overview After taking this course, you should be able to: Describe Cisco SD-Access architecture and its components Explain Cisco DNA Center deployment models, scaling, and high availability Identify Cisco SD-Access fabric protocols and node roles Understand the Cisco SD-Access Wireless deployment models Automate Day 0 device onboarding with Cisco DNA Center LAN Automation and Network PnP Deploy simple Cisco SD-Access fabric networks Monitor health and performance of the network with Cisco DNA Center Assurance Interact with the Cisco DNA Center Platform Intent APIs The Understanding Cisco SDA Fundamentals (SDAFND) v1.0 course introduces you to Cisco© Software-Defined Access and teaches you, through a combination of lectures and labs, how to implement simple, single-site fabric networks.You will learn the benefits of leveraging Software-Defined Access in the Cisco-powered Enterprise Campus network. SDAFND will introduce the solution, its architecture and components, and guide you through labs to design and deploy simple Cisco SD-Access networks.This course will help you Deploy Cisco SD-Access networks. Explain Cisco Software-Designed Access. Operate, manage, and integrate Cisco DNA Center?Prepare for various Cisco certifications Cisco Certified Specialist ? Enterprise Core (ENCOR), and Cisco Certified Specialist ? Enterprise Design (ENSLD) Course Outline Introducing Cisco SD-Access Introducing Cisco DNA Center Exploring Cisco SD-Access Solution Components Exploring Cisco SD-Access Wireless Architecture Automating Network Changes with Cisco DNA Center Deploying Fabric Networks with Cisco DNA Center Exploring Cisco DNA Center Assurance Exploring Cisco DNA Center Programmability Additional course details: Nexus Humans Understanding Cisco SDA Fundamentals (SDAFND) 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 Understanding Cisco SDA Fundamentals (SDAFND) 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.

Understanding Cisco SDA Fundamentals (SDAFND)
Delivered OnlineFlexible Dates
Price on Enquiry

Salesforce Reporting Fundamentals in Lightning Experience (RPX101)

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for Reporting Fundamentals in Lightning Experience is ideal for Sales Rep/Managers, Service Rep/Managers, Beginning Admin, and Business Analyst/Solution Architects. Overview When you complete this course, you will be able to:Work with standard reports.Establish a report building process.Build custom reports using different reporting formats in Lightning.Group and summarize reports in Lightning.Use field filters and filter logic.Add charts and conditional highlighting.Create dashboards in Lightning This course will teach you how to customize existing reports as well as use the Salesforce reporting toolset to create your own reports. Introducing the CourseReports Tab, Folders, and Formats Navigate the Reports Tab to Find Suitable Reports Create Custom Folders in Classic to be Used in Lightning Describe the Different Formats of Reports Run and Modify Existing Reports Using the Report Builder Establish a Report Building Process Navigate the Report Builder Create Custom Reports Using a Standard Report Type Use Filters and Filter Logic Export Your Report Summarizing Your Data Understand the Difference Between a Summary and Matrix Report Use Bucket Fields to Segment Your Data Use Custom Summary Formulas to Perform Calculations on Your Report Data Getting More Insight from Your Data Add Conditional Highlighting to a Report Create Charts to Display Summary Data Schedule and Email a Report to Run Dashboards Articulate What a Dashboard Is Understand the Benefits of Creating Dashboards in Lightning Create a Dashboard Using the Dashboard Builder Additional course details: Nexus Humans Salesforce Reporting Fundamentals in Lightning Experience (RPX101) 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 Salesforce Reporting Fundamentals in Lightning Experience (RPX101) 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.

Salesforce Reporting Fundamentals in Lightning Experience (RPX101)
Delivered OnlineFlexible Dates
Price on Enquiry

Data Wrangling with Python

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for Data Wrangling with Python takes a practical approach to equip beginners with the most essential data analysis tools in the shortest possible time. It contains multiple activities that use real-life business scenarios for you to practice and apply your new skills in a highly relevant context. Overview By the end of this course, you will be confident in using a diverse array of sources to extract, clean, transform, and format your data efficiently. In this course you will start with the absolute basics of Python, focusing mainly on data structures. Then you will delve into the fundamental tools of data wrangling like NumPy and Pandas libraries. You'll explore useful insights into why you should stay away from traditional ways of data cleaning, as done in other languages, and take advantage of the specialized pre-built routines in Python.This combination of Python tips and tricks will also demonstrate how to use the same Python backend and extract/transform data from an array of sources including the Internet, large database vaults, and Excel financial tables. To help you prepare for more challenging scenarios, you'll cover how to handle missing or wrong data, and reformat it based on the requirements from the downstream analytics tool. The course will further help you grasp concepts through real-world examples and datasets. Introduction to Data Structure using Python Python for Data Wrangling Lists, Sets, Strings, Tuples, and Dictionaries Advanced Operations on Built-In Data Structure Advanced Data Structures Basic File Operations in Python Introduction to NumPy, Pandas, and Matplotlib NumPy Arrays Pandas DataFrames Statistics and Visualization with NumPy and Pandas Using NumPy and Pandas to Calculate Basic Descriptive Statistics on the DataFrame Deep Dive into Data Wrangling with Python Subsetting, Filtering, and Grouping Detecting Outliers and Handling Missing Values Concatenating, Merging, and Joining Useful Methods of Pandas Get Comfortable with a Different Kind of Data Sources Reading Data from Different Text-Based (and Non-Text-Based) Sources Introduction to BeautifulSoup4 and Web Page Parsing Learning the Hidden Secrets of Data Wrangling Advanced List Comprehension and the zip Function Data Formatting Advanced Web Scraping and Data Gathering Basics of Web Scraping and BeautifulSoup libraries Reading Data from XML RDBMS and SQL Refresher of RDBMS and SQL Using an RDBMS (MySQL/PostgreSQL/SQLite) Application in real life and Conclusion of course Applying Your Knowledge to a Real-life Data Wrangling Task An Extension to Data Wrangling

Data Wrangling with Python
Delivered OnlineFlexible Dates
Price on Enquiry

Microsoft SharePoint 2016 - Advanced Site Owner with Workflow Administration

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for This course is designed for existing Microsoft SharePoint site owners who will create and manage sites, add advanced features, implement and manage records management, and create and administer workflows. Overview Upon successful completion of this course, existing SharePoint site owners will be able to take on administrative responsibility for implementing and managing advanced features based on business requirements. Students will:?Configure site settings.?Integrate external applications and data.?Configure site metadata.?Manage archiving and compliance.?Implement workflows. In this course, students will learn how to create, configure, and manage a SharePoint site so that your team or organization can collaborate effectively, manage the flow of digital information, automate business processes, and meet records management needs. Configuring Site Settings Configure Site Settings to Meet Team Requirements Configure Site Search Organize the Site and Configure Navigation Configure Site Auditing Integrating External Applications and Data Add an RSS Feed to Your Site Enable Email Connectivity for a Library Configuring Site Metadata Create a Custom Content Type Add Site Columns to Content Types Create and Configure Document Sets Managing Archiving and Compliance Manage Site Closure and Deletion Configure In-place Records Management Manage Records Using the Records Center Manage Content with the Content Organizer Configure Information Management Policies Implementing Workflows Plan a Workflow Create and Publish a Workflow Test Workflows Design and Implement Advanced Workflows Additional course details: Nexus Humans Microsoft SharePoint 2016 - Advanced Site Owner with Workflow 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 Microsoft SharePoint 2016 - Advanced Site Owner with Workflow 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.

Microsoft SharePoint 2016 - Advanced Site Owner with Workflow Administration
Delivered OnlineFlexible Dates
Price on Enquiry

Planning and Designing Databases on AWS

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for Data platform engineers Database administrators Solutions architects IT professionals Overview Apply database concepts, database management, and data modeling techniques Evaluate hosting databases on Amazon EC2 instances Evaluate relational database services (Amazon RDS, Amazon Aurora, and Amazon Redshift) and their features Evaluate nonrelational database services (Amazon DocumentDB, Amazon DynamoDB, Amazon ElastiCache, Amazon Neptune, and Amazon QLDB) and their features Examine how the design criteria apply to each service Apply management principles based on the unique features of each service This course will teach you the process of planning and designing both relational and nonrelational database and the planning and design requirements of all 8 of the AWS databases services, their pros and cons, and how to know which AWS databases service is right for your workloads. Day 1 Module 0: Planning and Designing Databases on AWS Module 1: Database Concepts and General Guidelines Module 2: Database Planning and Design Module 3: Databases on Amazon EC2 Module 4: Purpose-Built Databases Module 5: Databases on Amazon RDS Databases in Amazon Aurora Day 2 Module 6: Databases in Amazon Aurora (continued) Module 7: Databases in Amazon DocumentDB (with MongoDB compatibility) Module 8: Amazon DynamoDB Tables Day 3 Module 9: Databases in Amazon Neptune Module 10: Databases in Amazon Quantum Ledger Database (Amazon QLDB) Module 11: Databases in Amazon ElastiCache Module 12: Data Warehousing in Amazon Redshift Module 13: Course Review Additional course details: Nexus Humans Planning and Designing Databases on AWS 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 Planning and Designing Databases on AWS 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.

Planning and Designing Databases on AWS
Delivered OnlineFlexible Dates
Price on Enquiry

Cisco Network Services Orchestrator Advanced Design (NSO300)

By Nexus Human

Duration 4 Days 24 CPD hours This course is intended for The primary audience for this course is system installers, system integrators, system administrators, network administrators, and solutions designers. Overview At the end of this course, you will be able to: Describe the NSO's transactional application framework and mapping model options Describe the Reactive Fastmap design pattern and the NSO Configuration Database (CDB) subscriber in the NSO Transaction model Simplify packages to remove the need for subscriber applications, scale orchestration solutions, and integrate NSO with external systems (east-west integration)Describe the Cisco ESC architecture and integration with NSO, and how the NSO VNF Orchestration (VNFO) Release 2 bundle interacts with ESC for orchestration This course explores how to create advanced services using the NSO application framework and Python scripting with both new and existing Layer 3 Multiprotocol Label Switching (MPLS) VPN services. Students will also learn how to manage and scale these services, and how to use NSO Network Functions Virtualization (NFV) orchestration features and Cisco Elastic Services Controller (ESC) to manage Virtualized Network Functions (VNFs). Cisco NSO Programmability NSO Application Framework NSO Python Scripting NSO Python and Template-Based Services Resources Augmenting Cisco NSO Service Service Lifecycle and Integration Options Overview Greenfield Layer 3 MPLS VPN Service Brownfield Layer 3 MPLS VPN Service Managed Services Managed Services Overview Stacked Service Design Overview Design-Managed Network Services Scaling Service Orchestration Cisco NSO Network Functions Virtualization (NFV) Orchestration ETSI MANO Cisco ESC Cisco NSO Orchestration Additional course details: Nexus Humans Cisco Network Services Orchestrator Advanced Design (NSO300) 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 Cisco Network Services Orchestrator Advanced Design (NSO300) 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.

Cisco Network Services Orchestrator Advanced Design (NSO300)
Delivered OnlineFlexible Dates
Price on Enquiry