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

5974 Courses delivered Online

VMware Horizon 8: Deploy and Manage

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for Operators, administrators, and architects for VMware Horizon should enroll in this course. These individuals are responsible for the creation, maintenance, and or delivery of remote and virtual desktop services. Additional duties can include the implementation, support, and administration of an organization's end-user computing infrastructure. Overview By the end of the course, you should be able to meet the following objectives: Recognize the features and benefits of Horizon Use VMware vSphere to create VMs to be used as desktops for Horizon Create and optimize Windows VMs to create Horizon desktops Install and configure Horizon Agent on Horizon desktop Configure and manage the VMware Horizon Client™ systems and connect the client to a VMware Horizon desktop Configure, manage, and entitle desktop pools of full VMs Configure, manage, and entitle pools of instant-clone desktops Create and use Remote Desktop Services (RDS) desktops and application pools Monitor the Horizon environment using Horizon Console Dashboard and Horizon Help Desk Tool Identify Horizon Connection Server installation, architecture, and requirements. Describe the authentication and certification options for a Horizon environment Recognize the integration process and benefits of VMware Workspace ONE Access™ and Horizon 8 Discuss performance and scalability options available in Horizon 8 Describe different security options for the Horizon environment VMware Horizon 8: Deploy and Manage is a five-day combination course of VMware Horizon 8: Skills for Virtual Desktop Management & VMware Horizon 8: Infrastructure Administration. This training collection gives you the hands-on skills to deliver virtual desktops and applications through a single virtual desktop infrastructure platform. You will build on your skills in configuring and managing VMware Horizon© 8 through a combination of lecture and hands-on labs. You learn how to configure and deploy pools of virtual machines and how to provide a customized desktop environment to end-users. Additionally, you will learn how to install and configure a virtual desktop infrastructure platform. You learn how to install and configure VMware Horizon© Connection Server?, VMware Unified Access Gateway?, how to configure a load balancer for use with Horizon, and how to establish Cloud Pod Architecture. Course Introduction Introductions and course logistics Course objectives Introduction to VMware Horizon Recognize the features and benefits of Horizon Describe the conceptual and logical architecture of Horizon Introduction to Use Case Define a use case for your virtual desktop and application infrastructure Convert customer requirements to use-case attributes vSphere for Horizon 8 Explain basic virtualization concepts Use VMware vSphere© Client? to access your Center Server system and VMware ESXi? hosts Create, provision, and remove a virtual machine VMware Horizon Desktops Create a Windows and a Linux virtual machine using vSphere Optimize and prepare Windows and Linux virtual machines to set up Horizon desktop VMs VMware Horizon Agents Outline the configuration choices when installing Horizon Agent on Windows and Linux virtual machines Create a gold master for Windows Horizon desktops VMware Horizon Pools Identify the steps to set up a template for desktop pool deployment List the steps to add desktops to the VMware Horizon© Connection Server? inventory Compare dedicated-assignment and floating-assignment pools Outline the steps to create an automated pool Define user entitlement Explain the hierarchy of global, pool-level, and user-level policies VMware Horizon Client Options Describe the different clients and their benefits Access Horizon desktop using various Horizon clients and HTML Configure integrated printing, USB redirection, and the shared folders option Configure session collaboration and media optimization for Microsoft Teams Creating and Managing Instant-Clone Desktop Pools List the advantages of instant clones Explain the provisioning technology used for instant clone desktop pools Set up an automated pool of instant clones Push updated images to instant clone desktop pools Creating RDS Desktop and Application Pools Explain the difference between an RDS desktop pool and an automated pool Compare and contrast an RDS session host pool, a farm, and an application pool Create an RDS desktop pool and an application pool Access RDS desktops and application from Horizon Client Use the instant clone technology to automate the build-out of RDSH farms Configure load-balancing for RDSHs on a farm Monitoring VMware Horizon Monitor the status of the Horizon components using the Horizon Administrator console dashboard Monitor desktop sessions using the HelpDesk tool Course Introduction Introductions and course logistics Course objectives Horizon Connection Server Recognize VMware Horizon reference architecture Identify the Horizon Connection Server supported features Identify the recommended system requirements for Horizon Connection Server Configure the Horizon event database Outline the steps for the initial configuration of Horizon Connection Server Discuss the ADAM database as a critical component of Horizon Connection Server installation Authentication and Certificates Compare the authentication options that Horizon Connection Server supports Describe the Smartcard authentication options that Horizon Connection Server supports Outline the steps to create a Horizon administrator and custom roles Describe the roles available in a Horizon environment Explain the role that certificates play for Horizon Connection Server Install and configure certificates for Horizon Connection Server Install and configure True SSO in a Horizon environment Workspace ONE Access & Virtual Application Management Recognize the features and benefits of Workspace ONE Access Recognize the Workspace ONE Access console features Explain identity management in Workspace ONE Access Explain access management in Workspace ONE Access Describe the Workspace ONE Access directory integration Describe the Workspace ONE Access directory integration Deploy virtual applications with Workspace services Horizon Protocols Compare the remote display protocols that are available in VMware Horizon Describe the BLAST Display Protocol Codecs Describe BLAST and PCoIP ADMX GPO common configurations Graphic Cards Describe the 3D rendering options available in Horizon 8 Compare vSGA and vDGA List the steps to configure graphics cards for use in a VMware Horizon environment Horizon Scalability Describe the purpose of a replica connection server Explain how multiple Horizon Connection Server instances in a pod maintain synchronization Explain Horizon Cloud Pod Architecture LDAP replication and VIPA Explain Horizon Cloud Pod Architecture scalability options Horizon Security Explain concepts relevant to secure Horizon connections Describe how to restrict Horizon connections. Discuss the benefits of using Unified Access Gateway List the two-factor authentication options that are supported by Unified Access Gateway List Unified Access Gateway firewall rules Describe the situation in which you might deploy Unified Access Gateway instances with one, two, or three network interfaces Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware Horizon 8: Deploy and Manage 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 VMware Horizon 8: Deploy and Manage 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.

VMware Horizon 8: Deploy and Manage
Delivered OnlineFlexible Dates
Price on Enquiry

Microsoft Office 2016 Advanced

5.0(1)

By Course Gate

Microsoft office is used for documentation, writing, and many other activities. It brings a new dimension to this technology-based competitive world. It has vivid functions and much more use. If you want to learn all its advanced functions, look at our Microsoft Office 2016 Advanced course. This course introduces to the function of ribbon that incorporates many tabs such as Insert, design, animation, slides, show, review, and home. It also guides you step by step how to insert a picture, change design lay order, add a hyperlink, watch video from youtube, create CV, cash memo, payment sleep, many more things. Overall the course teaches you all the efficient use of Microsoft Office to be expert in it. Who is this Course for? Microsoft Office 2016 Advanced is 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. 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. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Microsoft Word 2016 Modify User Information 00:15:00 Share a Document 00:30:00 Work with Comments 00:15:00 Compare Document Changes 00:15:00 Review a Document 00:15:00 Merge Document Changes 00:15:00 Coauthor Documents 00:15:00 Add Captions 00:15:00 Add Cross-References 00:15:00 Add Bookmarks 00:15:00 Add Hyperlinks 00:15:00 Insert Footnotes and Endnotes 00:15:00 Add Citations 00:30:00 Insert a Bibliography 00:15:00 Insert Blank and Cover Pages 00:15:00 Insert an Index 00:30:00 Insert a Table of Contents 00:30:00 Insert an Ancillary Table 00:15:00 Manage Outlines 00:30:00 Create a Master Document 00:30:00 Suppress Information 00:30:00 Set Editing Restrictions 00:30:00 Add a Digital Signature to a Document 00:15:00 Restrict Document Access 00:15:00 Create Forms 00:30:00 Manipulate Forms 00:15:00 Form Data Conversion 00:15:00 Create a New Document Version 00:30:00 Compare Document Versions 00:15:00 Merge Document Versions 00:15:00 Activities - Microsoft Word 2016 Advanced 00:00:00 Microsoft Excel 2016 Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:15:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline 00:05:00 Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View 00:05:00 Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Integrate Excel Data with the Web 00:15:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 Advanced 00:00:00 Microsoft PowerPoint 2016 Customize the User Interface 01:30:00 Set PowerPoint 2016 Options 00:45:00 Create and Manage Sections 01:00:00 Modify Slide Masters and Slide Layouts 01:15:00 Add Headers and Footers 00:30:00 Modify the Notes Master and the Handout Master 00:45:00 Create SmartArt 00:45:00 Modify SmartArt 01:00:00 Add Audio to a Presentation 00:45:00 Add Video to a Presentation 01:00:00 Customize Animations and Transitions 01:00:00 Add Comments to a Presentation 00:45:00 Review a Presentation 00:45:00 Store and Share Presentations on the Web 01:30:00 Annotate a Presentation 00:45:00 Set Up a Slide Show 00:45:00 Create a Custom Slide Show 00:30:00 Add Hyperlinks and Action Buttons 00:45:00 Record a Presentation 00:15:00 Secure a Presentation 01:30:00 Present a Slide Show Online 01:00:00 Create a Video or a CD 00:45:00 Activities - Microsoft PowerPoint 2016 Advanced 00:00:00 Microsoft Outlook 2016 Insert Advanced Characters and Objects 01:30:00 Modify Message Settings, Properties, and Options 01:30:00 Use Automatic Replies 01:30:00 Sort Messages 00:45:00 Filter Messages 01:00:00 Organize Messages 02:00:00 Search Messages 01:30:00 Manage Junk Mail 01:00:00 Manage Your Mailbox 02:00:00 Manage Advanced Calendar Options 00:45:00 Manage Additional Calendars 01:00:00 Manage Meeting Responses 00:45:00 Assign and Manage Tasks 01:00:00 Edit an Electronic Business Card 01:00:00 Manage Advanced Contact Options 01:30:00 Forward Contacts 00:30:00 Export Contacts 01:00:00 Delegate Access to Mail Folders 01:00:00 Share Your Calendar 00:30:00 Share Your Contacts 00:15:00 Back Up Outlook Items 00:45:00 Change Data File Settings 00:45:00 Configure E-mail Message Security Settings 00:30:00 Activities - Microsoft Outlook 2016 Advanced 00:00:00 Microsoft Access 2016 Add Controls to Forms 01:00:00 Set Form Controls 01:00:00 Create Subforms 00:30:00 Organize Information with Tab Pages 00:30:00 Enhance Navigation with Forms 00:30:00 Format a Form 01:00:00 Apply Conditional Formatting 00:30:00 Field Validation 00:30:00 Form and Record Validation 00:30:00 Create a Macro 01:00:00 Restrict Records Using a Condition 00:30:00 Validate Data Using a Macro 00:30:00 Automate Data Entry Using a Macro 00:30:00 Convert a Macro to VBA 00:30:00 Link Tables to External Data Sources 00:30:00 Manage a Database 00:30:00 Determine Object Dependency 00:30:00 Document a Database 00:30:00 Analyze the Performance of a Database 00:30:00 Split a Database for Multiple User Access 00:30:00 Implement Security 00:30:00 Set Passwords 00:30:00 Convert an Access Database to an ACCDE File 00:30:00 Package a Database with a Digital Signature 00:30:00 Create a Database Switchboard 01:00:00 Modify a Database Switchboard 00:30:00 Set Startup Options 00:30:00 Mock Exam Mock Exam - Microsoft Office 2016 Advanced 00:20:00 Final Exam Final Exam - Microsoft Office 2016 Advanced 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Microsoft Office 2016 Advanced
Delivered Online On Demand3 days
£11.99

Digital Marketing - Growth Hacking Techniques

5.0(10)

By Apex Learning

Overview: Are you tired of watching your competitors soar while your Digital Marketing efforts remain stagnant? In today's digital-first world, mastering Digital Marketing and growth hacking techniques is no longer a luxury but a necessity. With the UK's Digital Marketing economy booming, now is the perfect time to equip yourself with the Digital Marketing skills to drive exponential growth. Imagine having the power to strategically leverage Digital Marketing tools like social media, content marketing, and SEO to attract, engage, and convert customers. Our comprehensive Digital Marketing bundle offers you the tools and knowledge to succeed in Digital Marketing and achieve your business goals. This Digital Marketing course dives deep into core Digital Marketing principles and equips you with practical skills to implement growth-hacking strategies. From understanding the Digital Marketing customer journey to mastering advanced SEO, you'll gain a holistic perspective on how to optimize your Digital Marketing presence. Learning Outcomes of this Digital Marketing Bundle: Develop a data-driven approach to Digital Marketing. Master content marketing strategies in Digital Marketing. Optimize your website with advanced Digital Marketing SEO techniques. Leverage Digital Marketing tools on social media platforms. Implement targeted Digital Marketing email campaigns. Analyze and optimize your Digital Marketing performance. Don't let your Digital Marketing efforts fall short. By enrolling in our Digital Marketing bundle, you're investing in your Digital Marketing career and positioning yourself for success in the competitive world of online business. Key Features of the Digital Marketing Course: FREE Digital Marketing CPD-accredited certificate Get a free student ID card with Digital Marketing training (£10 applicable for international delivery) Lifetime access to the Digital Marketing course materials The Digital Marketing program comes with 24/7 tutor support Get instant access to this Digital Marketing course Learn Digital Marketing from anywhere in the world The Digital Marketing training is affordable and simple to understand The Digital Marketing training is entirely online How will I get my certificate? You may have to take a quiz or a written test online during or after the Digital Marketing course. After successfully completing the course, you will be eligible for the certificate. Who is this Digital Marketing course for? There is no experience or previous qualifications required for enrolment in this Digital Marketing - Growth Hacking Techniques. It is available to all students, of all academic backgrounds. Digital Marketing professionals Entrepreneurs focused on Digital Marketing Small business owners looking to improve Digital Marketing skills Marketing students interested in Digital Marketing Anyone seeking expertise in Digital Marketing Requirements Our Digital Marketing bundle is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This Digital Marketing course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as: Digital Marketing Manager (£35,000 - £55,000) SEO Specialist in Digital Marketing (£30,000 - £45,000) Social Media Manager in Digital Marketing (£25,000 - £40,000) Content Marketing Manager in Digital Marketing (£30,000 - £50,000) Email Marketing Specialist in Digital Marketing (£25,000 - £40,000) Course Curriculum 11 sections • 11 lectures • 07:12:00 total length •Fundamentals of Digital Marketing: 00:45:00 •Growth Hacking: 00:34:00 •Customer Journey: 00:35:00 •Content Marketing: 00:36:00 •SEO: 00:40:00 •E-Mail Marketing: 00:45:00 •Facebook Marketing: 00:43:00 •Instagram Marketing: 00:46:00 •Twitter Marketing: 00:37:00 •Youtube Marketing: 00:36:00 •Mobile Marketing: 00:35:00

Digital Marketing - Growth Hacking Techniques
Delivered Online On Demand5 hours
£9.99

Fitness Instructor, Personal Trainer, Gym Instructor & Nutrition - CPD Certified

5.0(3)

By School Of Health Care

Fitness Instructor, Personal Trainer, Gym Instructor & Nutrition *** Close Out Sale, don’t delay *** Do you want to start a career as a personal trainer or fitness instructor, or do you want to advance your skills? Then this Fitness Instructor, Personal Trainer, Gym Instructor & Nutrition course will provide you with a solid foundation for becoming a confident personal trainer or fitness instructor, as well as assist you in developing your expertise as a personal trainer or fitness instructor. Learning Outcomes After completing this Fitness Instructor, Personal Trainer, Gym Instructor & Nutrition course, the learner will be able to Gain a range of core skills needed to become a successful personal trainer/ fitness instructor. Gain in-depth knowledge of the science of losing weight and gaining muscle. Understand how to warm up safely before exercising and monitor heart rate. Understand how to perform a range of cardio, endurance and resistance exercises. Know how to build stamina and lean muscle. Understand how to perform a range of stretches safely to increase flexibility. Why choose this Fitness Instructor, Personal Trainer, Gym Instructor & Nutrition course from the School of Health Care? Unlimited access to the Fitness Instructor + Personal Trainer + Gym Instructor course. Instant e-certificate and hard copy dispatch by next working day. Fitness Instructor Course material developed by qualified professionals. Self-paced learning is accessible via laptop, tablet and smartphone. 24/7 Learning assistance and tutor support. No hidden fees or exam charges. Discounts on bulk purchases. Courses including with this Fitness Instructor, Personal Trainer, Gym Instructor & Nutrition bundle Course 01: Fitness Instructor Course 02: Personal Trainer Course 03: GYM Instructor Course 04: Diet and Nutrition (Diploma Level 5) Course 05: Food Allergen Awareness Training Course 06: Nutritional Level 5 Course 07: Sports Nutrition Others Benefits included with Fitness Instructor: Fitness Instructor Course Free 7 PDF Certificate Lifetime Access Exam Fee - Totally Free Offer Free Retake Exam [ Note: Free PDF certificate as soon as completing the Fitness Instructor, Personal Trainer, Gym Instructor & Nutrition course] Fitness Instructor, Personal Trainer, Gym Instructor & Nutrition After completing this Fitness Instructor, Personal Trainer, Gym Instructor & Nutrition course, you will have gained the knowledge and skills necessary to launch your own training business and turn your passion for fitness into a full-time career, working in gyms, clients' homes, fitness centres, and other professional settings. Course Curriculum of Fitness Instructor Module 01: Advances in Functional Training Module 02: Mobility and Flexibility Module 03: Injuries Module 04: The Core Module 05: The Hips Course Curriculum of Personal Trainer Module 1: Professionalism and Presentation Module 2: Planning a Personal Training Session Module 3: Delivering a Personal Training Session Module 4: Skeletal Articulations and Joint Movement Module 5: Injury Prevention Module 6: Muscular System Module 7: Energy Systems Module 8: Cardiorespiratory System Module 9: Nervous System Module 10: Hormonal Responses to Exercise Module 11: Health and Fitness Assessment Module 12: Psychological Aspects of Personal Training Module 13: Nutrition Module 14: Training Adaptations Module 15: Exercise Planning and Programming Course Curriculum of GYM Instructor Module 1: Introduction Module 2: Exercises Module 3: Workout Plan Module 4: Diet Plan Module 5: Sleep Module 6: Supplements Detailed course curriculum of Sports Nutrition Module 1: A Quick Overview of Sports Nutrition Module 2: Diet and Nutrition: Dietary Guidelines Module 3: Nutrition and Athlete Health Module 4: Diet Planning Module 5: Healthy Dieting Module 6: The Digestive System Module 7: Water Module 8: Weight Control and Weight Loss Management Module 9: The Role of the Vegetarian/Vegan in Sports Nutrition Module 10: Myth and Misinformation Module 11: Performance Boosters Course Curriculum of Food Allergen: Food Allergen Awareness Course Module 01: Introduction Module 02: Consequences of Food Allergies Module 03: Food Allergies and Intolerance Module 04: Providing Allergen Information to Consumers Module 05: Food Allergen Law and the Food Labelling Regulations Module 06: Preventing Allergenic Cross Contamination Assessment Method of Fitness Instructor, Personal Trainer, Gym Instructor & Nutrition After completing Fitness Instructor, Personal Trainer, Gym Instructor & Nutrition Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Certification of Fitness Instructor, Personal Trainer, Gym Instructor & Nutrition After completing the Fitness Instructor, Personal Trainer, Gym Instructor & Nutrition course, you can instantly download your certificate for FREE. Who is this course for? Fitness Instructor, Personal Trainer, Gym Instructor & Nutrition This Fitness Instructor, Personal Trainer, Gym Instructor & Nutrition course is ideal for those who want to learn the skills needed to start a successful career in the fitness industry. Requirements Fitness Instructor, Personal Trainer, Gym Instructor & Nutrition To enrol in this Fitness Instructor, Personal Trainer, Gym Instructor & Nutrition Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Fitness Instructor Course. Be energetic and self-motivated to complete our Fitness Instructor Course. Basic computer Skill is required to complete our Fitness Instructor Course. If you want to enrol in our Fitness Instructor Course, you must be at least 15 years old. Career path Fitness Instructor, Personal Trainer, Gym Instructor & Nutrition Upon completing this Fitness Instructor, Personal Trainer, Gym Instructor & Nutrition course, you will have the necessary knowledge and skillset to start your training business. You can also make it a full-time job by working in gyms, clients' homes and other professional settings. Such as: Personal Trainer Fitness instructor

Fitness Instructor, Personal Trainer, Gym Instructor & Nutrition - CPD Certified
Delivered Online On Demand45 hours
£12

Oracle 12c SQL Fundamentals

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for The target audience for this textbook is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this textbook will be helpful are: ? Business and non-IT professionals ? Application designers and database developers ? Business Intelligence (BI) analysts and consumers ? Database administrators ? Web server administrators Overview The first portion of this textbook considers the logical models upon which a relational database is based and the various configurations and environments in which you may work with the Oracle database. The next segment focuses on the actual SQL syntax for writing database queries. You will begin with the simplest of queries and then proceed onto moderately complex query scenarios. Finally, this textbook covers the DDL, DML and transaction control portions of the SQL language that allow one to create, maintain and manipulate application database objects and application data. This textbook takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle. Relational Databases & Data Models About Data Models About the Relational Model The Electronics Data Model About the Relational DBMS Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL*Plus Setup Jdeveloper Using the Database Interface About Bind & Substitution Variables Using SQL Developer Using SQL*Plus Introduction to the SQL Language About the SQL Language Characteristics of SQL Introducing SQL Using Select SQL Rules The Select Statement The Select Statement Distinct/Unique Keyword Using Alias Names Restricting Results with the Where Clause About Logical Operators Equality Operator Boolean Operators REGEXP_LIKE() In Operator Sorting Data with the Order By Clause About the Order by Clause Multiple Column Sorts Specify the Sort Sequence About Null Values within Sorts Using Column Aliases Pseudo Columns, Functions & Top-N Queries Rowid Pseudo Column ORA_ROWSCN PSEUDO Column ROWNUM Pseudo Column About the Built-In Functions SYSDATE User & UID SESSIONTIMEZONE Function Using the Dual Table Row Limiting & Top-N Queries FETCH First x Rows Only Clause OFFSET x Rows Clause FETCH?PERCENT Clause The WITH TIES Option Joining Tables About Joins Inner Joins Reflexive Join Non-Key Join Outer Join Using the Set Operators About the Set Operators SQL Set Operator Examples UNION Example INTERECT Example MINUS Example UNION All Summary Functions Using Sub-Queries Finding Data with Sub-Queries Standard Sub-Queries Correlated Sub-Queries The EXISTS Operator Aggregating Data within Groups About Summary Groups Find Groups within the Tables Select Data From the Base Tables Select Groups from the Results Use DDL to Create & Manage Tables Create Table Statement Column Data Types Not Null Default Describe Alter Table Statement Drop Table Statement Table DDL Using SQL Developer Alter User Statement Alter Session Statement NLS_Language NLS_Date Use DML to Manipulate Data The Insert Statement The Delete Statement The Update Statement About Transactions Transaction Rollback Transaction Commit Transaction Savepoint The Set Transaction Statement Set Transaction Read Only Statement Rules Understanding the Data Models The Company Data Model The Electronics Data Model About the SQL-99 Standard SQL-92 & SQL-99 Cross Joins Natural Joins Inner Joins Implicit Inner Join Outer Joins Anti Joins Named Sub-Queries Enhancing Groups with Rollup & Cube Using Rollup The Grouping() Function Using Cube SQL Functions: Character Handling What are the SQL Functions? String Formatting Functions UPPER(), LOWER() Example INITCAP() Example Character Codes Functions CHR((), ASCII() Examples PAD & TRIM Functions RPAD() Example RTRIM() Example TRIM() Example String Manipulation Functions DECODE () Example SUBSTR() Example INSTR() Example TRANSLATE() Example REPLACE() Example String Comparison Functions LEAST() Example Phonetic Search Function SOUNDEX() Example SQL Functions: Numeric Handling About the Numeric Data Functions GREATEST() Example ABS() Example ROUND() Example TRUNC() Example SIGN() Example TO_NUMBER() Example & Data ype Conversions NULL VALUES FUNCTIONS NVL() & NVL2() Function NVL() Example (Character) NVL() Example (Numeric Loss of Data) NVL() Example (Numeric Output) NVL2() Example COALESCE() Function NULLIF() Function SQL Functions: Date Handling Date Formatting Functions TO_CHAR() & TO_DATE() Format Patterns TO_CHAR() Examples TO_DATE() Examples EXTRACT() Example Date Arithmetic Functions MONTHS_BETWEEN() Example ADD_MONTHS() Example LAST_DAY() Example NEXT_DAY() Example TRUNC(), ROUND() Dates Example NEW_ TIME() Example About V$TIMEZONE_NAMES CAST() FUNCTION & TIME ZONES Database Objects: About Database Objects About Database Objects About Schemas Making Object References Database Objects: Relational Views About Relations Views The Create View Statement Why Use Views? Accessing Views with DML Maintaining View Definitions Alter View Drop View DDL Using SQL Developer Database Objects: Indexes About Indexes Create & Drop Index Statements Indexes & Performance Data Dictionary Storage Database Objects: Creating Other Objects About Sequences Referencing NEXTVAL Referencing CURRVAL Within the DEFAULT Clause Alter Sequence & Drop Sequence ALTER SEQUENCE DROP SEQUENCE About Identity Columns CREATE TABLE?GENERATED AS IDENTITY ALTER TABLE?GENERATED AS IDENTITY Start With Limit Value ALTER TABLE...DROP IDENTITY About Synonyms CREATE & DROP SYNONYM Statements CREATE SYNONYM DROP SYNONYM Public Vs Private Synonyms CREATE SCHEMA AUTHORIZATION Database Objects: Object Management Using DDL The RENAME Statement TABLESPACE Placement CREATE TABLE?TABLESPACE The Comment Statement The TRUNCATE TABLE Statement Database Objects: Security About Object Security Grant Object Privileges Revoke Object Privileges Object Privileges & SQL Developer Data Integrity Using Constraints About Constraints NOT NULL Constraint NOT NULL Example CHECK Constraint UNIQUE Constraint PRIMARY KEY Constraint REFERENCES Constraint ON DELETE CASCADE Example ON DELETE SET NULL Example Constraints on Existing Tables Constraints & SQL Developer Managing Constraint Definitions RENAMING & DROPPING Constraints ENABLING & DISABLING Constraints DEFERRED Constraint Enforcement SET CONSTRAINTS Handling Constraint Exceptions Constraints with Views DATA Dictionary Storage The Data Dictionary Structure More About the Data Dictionary OBJECT-SPECIFIC Dictionary Views USER_UPDATABLE_COLUMNS The Dictionary Structure METADATA & SQL Developer Additional course details: Nexus Humans Oracle 12c SQL Fundamentals training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Oracle 12c SQL Fundamentals course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Oracle 12c SQL Fundamentals
Delivered OnlineFlexible Dates
Price on Enquiry

Remote Management Skills for Virtual Assistants

By Writewow Solutions

Sharpen Your Virtual Management Skills, Enhance Your Productivity and Collaborate Effectively to Drive Results.

Remote Management Skills for Virtual Assistants
Delivered Online On Demand3 hours
£15

Conquer Your Deadlines: Top Assignment Help Tips for Busy Students

By Jack Walker

Discover how to conquer your assignment deadlines with ease. Packed with valuable tips and strategies, this article explores the importance of effective deadline management for busy students. Learn how to prioritise tasks, plan your schedule wisely, and utilise assignment help services to achieve academic success.

Conquer Your Deadlines: Top Assignment Help Tips for Busy Students
Delivered Online On Demand
FREE

VMware Cloud Foundation: Planning, Management, Operations [V4.3]

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for Experienced system administrators, system integrators, and consultants responsible for implementing and managing VMware Cloud Foundation Overview By the end of the course, you should be able to meet the following objectives: Describe design implications of VMware Cloud Foundation standard or consolidated architecture List requirements for VMware Cloud Foundation deployment Describe the VMware Cloud Foundation bring-up process and the VMware Cloud Foundation architecture Perform VMware Cloud Foundation bring-up Describe physical and virtual networking considerations Outline VMware Cloud Foundation storage options Use the VMware Imaging Appliance to image ESXi hosts Describe VMware Cloud Foundation multi-instance federation Use VMware Cloud Foundation™ SDDC Manager™ to perform operational tasks Describe user roles in VMware Cloud Foundation and VMware vSphere Manage users and passwords using VMware Cloud Foundation Manage certificate rotation for VMware Cloud Foundation components Use Active Directory integration to automate certificate generation and rotation Describe workload domains Manage workload domains in VMware Cloud Foundation Manage VMware NSX-T™ for VMware Cloud Foundation Describe use cases for Application Virtual Networks (AVNs) Meet vSphere with VMware Tanzu™ requirements Deploy a vSphere with Tanzu enabled workload domain Manage VMware vSAN™ storage in a workload domain Create vSAN storage policies Describe Cloud Native storage Describe the importance of business continuity measures in VMware Cloud Foundation Plan appropriate backup and restore workflows for VMware Cloud Foundation components Implement stretched clusters in VMware Cloud Foundation workload domains This five-day course includes instruction on the capabilities of VMware Cloud Foundation? and how to successfully plan, deploy, manage, and operate hybrid and cloud infrastructures, including customization. The course explains the architecture of VMware Cloud Foundation and explains licensing, certificates, and storage and network management. The course also covers workload domains, availability, life cycle management, and troubleshooting. Course Introduction Introductions and course logistics Course objectives VMware Cloud Foundation Overview Describe the VMware Cloud Foundation solution Describe VMware Cloud Foundation architecture Identify VMware Cloud Foundation components Describe VMware Cloud Foundation topology Define VMware Cloud Foundation terminology Day Zero Tasks Identify the requirements for deploying VMware Cloud Foundation Identify management domain sizing considerations Identify workload domain sizing considerations Detail design considerations for ESXi in management and VI workload domains Detail design considerations for vCenter in management and VI workload domains Detail the VMware Cloud Foundation bring-up process Identify information required for the Planning and Preparation Workbook Identify information required for the Deployment Parameter Workbook Describe how VMware Cloud Builder automates the deployment process Explain how the Deployment Parameter Workbook is imported into VMware Cloud Builder Recognize the configuration validation process performed by VMware Cloud Builder Detail the deployment of the management domain Recognize the options to image a host Identify the key capabilities of VIA Recognize how to use VIA for imaging the ESXi Nodes Post Deployment Operations Understand VMware Cloud Foundation integration with VMware Single Sign-On Configure user access to VMware Cloud Foundation Describe the importance of user roles in vSphere Configure identity sources in vSphere to use with VMware Cloud Foundation Manage passwords in VMware Cloud Foundation Explain the importance of using VMware Cloud Foundation to manage passwords for vSphere components Detail the best practices for password management for VMware Cloud Foundation Retrieve and secure the password list Describe the process for rotating passwords not managed by VMware Cloud Foundation VMware Cloud Foundation License Management Describe how to add license keys to the VMware Cloud Foundation inventory Describe how to view license keys in SDDC Manager Describe how to assign license keys Describe how to remove license keys Describe how to replace expiring licenses VMware Cloud Foundation Networking with NSX-T Describe NSX Management plane and Control planes Detail design considerations for workload domains with shared NSX Manager instances Detail design considerations for workload domains with dedicated NSX Manager instances Describe the spine-and-leaf design Describe the addressing scheme for the underlay Recognize possible variations of the spine-and-leaf design Describe the multi-NIC design Describe NSX Edge node design and BGP peering with the physical network Describe cluster design and rack design Explain dynamic routing with BGP Explain virtual IP addressing Describe logical switching Detail NSX Edge functions Define application virtual networks Describe management domain rack options List NSX Edge cluster requirements for vSphere with Tanzu Discuss NSX Edge cluster placement considerations Describe NSX-T Data Center deployment in VMware Cloud Foundation Explain how logical routing works in NSX-T Data Center Identify NSX Edge functions Describe data plane preparation for NSX-T Data Center Edge nodes in a workload domain Recognize Tier-0 and Tier-1 gateway topologies Recognize features of NSX distributed firewalls Describe the benefits of NSX Federation in VMware Cloud Foundation Identify NSX Federation Use Cases Explain NSX Federation Components and Architecture Discuss NSX Federation configuration basics Managing Workload Domains Define workload domains Detail design considerations for vSphere networking in management and VI workload domains Detail design considerations for storage in management and VI workload domains Recognize design choices for a consolidated design or standard design List the types of workload domains State scale limits for workload domains Identify use cases for multiple clusters in a workload domain List workload domain prerequisites Explain how to create a workload domain Describe how to scale a workload domain Explain how to delete a workload domain Describe host decommissioning vSphere with Tanzu in VMware Could Foundation Discuss the vSphere with Tanzu solution Define the role of Spherelet Describe the supervisor cluster control plane Define vSphere with Tanzu namespaces Describe the role of NSX-T networking components Discuss vSphere with Tanzu networking topology Describe VMware Container Networking with Antrea Describe control plane VM management networking requirements Plan appropriate IP address CIDR ranges for pod, ingress, and egress networking Describe prerequisites for vSphere with Tanzu cluster compatibility Deploy vSphere with Kubernetes Create a vSphere namespace Configure limits and permissions for a vSphere namespace Enabling Harbor Image Registry VMware Cloud Foundation Storage Management Identify vSAN architecture and components Recognize storage options for VMware Cloud Foundation Recognize the connectivity options for supplemental storage Explain why vSAN is the best option for VMware Cloud Foundation storage Recognize vSAN design considerations Identify sizing and performance considerations that impact the storage design Describe vSAN requirements for the management and workload domains Define deduplication and compression Discuss how to scale vSAN clusters in VMware Cloud Foundation Explain how storage policies work with VMware Cloud Foundation vSAN clusters Explain storage policy failure tolerance rules Identify a VM storage policy compliance status Relate storage policies to Kubernetes storage classes Describe persistent volumes Monitor Cloud Native Storage in the vSphere Client Availability and Business Continuity Identify steps in the SDDC Manager backup and restore process Recognize the importance of external service availability Describe native vSphere availability options Identify steps in the NSX backup and restore process Identify stretched cluster use cases Identify stretched cluster components Recognize stretched cluster requirements in VMware Cloud Foundation Prepare and deploy a vSAN stretched cluster using APIs VMware Cloud Foundation Certificate Management Describe public key infrastructure (PKI) Explain the purpose of certificate signing requests (CSRs) List the available CA options in SDDC Manager Describe how to view certificates Explain how to generate a CSR Describe how to replace and install certificates for VMware Cloud Foundation components List the available CA options in SDDC Manager Explain how to configure the Microsoft CA server Describe how to install certificates issued by the Microsoft CA server Explain how to add OpenSSL CA in SDDC Manager Describe how to install certificates issued by OpenSSL CA Explain how to install certificates issued by third-party CAs

VMware Cloud Foundation: Planning, Management, Operations [V4.3]
Delivered OnlineFlexible Dates
Price on Enquiry

ChatGPT: Expert Guide & Complete Course

4.8(9)

By Skill Up

Master ChatGPT with our comprehensive course. Learn how to use keywords & optimize performance. Start now!

ChatGPT: Expert Guide & Complete Course
Delivered Online On Demand1 hour 5 minutes
£25

Mini MBA

3.0(2)

By Alpha Academy

Whether you want to become a leader in managing a business or even start your own business, this Mini MBA will be ideally suited for you. The course can be an outstanding preparation for you before stepping into full MBA studies as this course assists you by providing comprehensive essential business teachings. This course also includes different topics that are conclusive to fill your present business information gap. If you're hoping to enhance your business management skills for taking your career to the correct path and becoming more profitable in this profession, then welcome to join this course. Course Highlights The price is for the whole course including final exam - no hidden fees Accredited Certificate upon successful completion at an additional cost Efficient exam system with instant results Track progress within own personal learning portal 24/7 customer support via live chat Mini MBA has been given CPD accreditation and is one of the best-selling courses available to students worldwide. This valuable course is suitable for anyone interested in working in this sector or who simply wants to learn more about the topic. If you're an individual looking to excel within this field then Mini MBA is for you. We've taken this comprehensive course and broken it down into several manageable modules which we believe will assist you to easily grasp each concept - from the fundamental to the most advanced aspects of the course. It really is a sure pathway to success. All our courses offer 12 months access and are designed to be studied at your own pace so you can take as much or as little time as you need to complete and gain the full CPD accredited qualification. And, there are no hidden fees or exam charges. We pride ourselves on having friendly and experienced instructors who provide full weekday support and are ready to help with any of your queries. So, if you need help, just drop them an email and await a speedy response. Furthermore, you can check the validity of your qualification and verify your certification on our website at anytime. So, why not improve your chances of gaining professional skills and better earning potential. Assessment and Certification 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. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39. Career Path Not only does our CPD and CiQ accredited course look good on your CV, setting you apart from the competition, it can be used as a stepping stone to greater things. Further advance your learning, launch a new career or reinvigorate an existing one. On successful completion of this course, you have the potential to achieve an estimated salary of £82,000. The sky really is the limit. Course Curriculum Module 1:- Business Planning and Analysis Business Planning Basics 01:00:00 Market Evaluation 01:00:00 Analyze Competition 01:00:00 Determine A Marketing Strategy 01:00:00 Decide What Extras You May Need Like Staff etc 00:30:00 The Dangers In Not Making A Business Plan 00:15:00 Module 2: -Business Administration and Branding Introduction 00:15:00 Make Yourself Well Recognised Before Your Customers 00:30:00 Wow Your Customers 00:30:00 Develop a Personal Style 00:30:00 Use Creative Imageries to Catch the Attention 00:30:00 Be a Traditionalist, Not a Fad Chaser 00:15:00 Bringing Out the Purple Cow in Your Business 00:30:00 Conclusion 00:15:00 Module 3: - Business Succession Planning Getting Started 00:30:00 Succession Planning Vs. Replacement Planning 01:00:00 Preparing for the Planning Process 01:00:00 Initiating Process 00:00:00 The SWOT Analysis 01:00:00 Developing the Succession Plan 01:00:00 Executing the Plan 00:30:00 Gaining Support 00:30:00 Managing the Change 01:00:00 Overcoming Roadblocks 01:00:00 Reaching the End 01:00:00 Wrapping Up 00:15:00 Module 4: -Business Development Budgeting Businesses Budgeting Basics 00:15:00 Steps To Better Business Budgeting 00:15:00 How And What To Consider When Preparing A Business Plan And Budget 01:00:00 The Ins And Outs Of Corporate Budgeting 00:15:00 Including Social Business Budgets In The Plan 00:15:00 Impacts Of Debts On Business Budgets 00:15:00 Managing Business Budgets And Finances Together 01:00:00 Module 5: -Management Introduction to Management 01:00:00 How to Build Trust and Confidence 01:00:00 A Manager's Pitfalls 01:00:00 How to Build Team Spirit 01:00:00 Dealing with Problem Employees 01:00:00 Using Your Emotional Intelligence 00:30:00 Conclusion to Management 00:15:00 Module 6:- Business Management Skills Business Plan Basics 00:30:00 The Executive Summary 01:00:00 The Mission Statement 00:30:00 Exploring Financial Needs 00:30:00 Evaluating Competition 01:00:00 The Troubles You Can Run Into Without The Proper Business Plan 00:30:00 Wrapping Up 00:15:00 Module 7: Project Management Introduction 01:00:00 Can You Manage Yourself Out Of A Paper Bag? 00:30:00 Setting the Stage for a Successful Project 01:00:00 The Importance of Developing and Managing A Budget 00:30:00 Taking Action - Execution of the Plan 01:00:00 Rules to Manage The Projects 01:00:00 Your Personality and Project Management Style 01:00:00 The Cycle of Decision Making 01:00:00 Getting Your Project Back On Track 01:30:00 Keeping It Moving Forward 01:00:00 Problems and Solutions in Project Management 01:00:00 Module 8: HR and Leadership Management Leader and HR Management 00:30:00 Commitment and HR Management 01:00:00 Team Management 00:30:00 Build A Mastermind Group 02:00:00 People Recognition in HR Management 00:30:00 Performance, Goals and Management 00:30:00 Think Outside The Box 00:30:00 Be Passionate about Your Work 00:30:00 The Importance Of A Good Team Leader 00:30:00 Module 9: Business Systemization Introduction 00:30:00 The Idea of Systemizing Your Business 01:00:00 Why You Should Systemize Your Business 01:00:00 A Lesson Learned From The Book 'The E-Myth' 01:00:00 So, How Do I Create This Wonderful Business System? 01:00:00 Outsourcing As a Way of Systemizing Your Business 00:30:00 How to Keep It Growing: The Systemized Business 01:00:00 Some General Ideas To Consider As You Systemize Your Business 00:30:00 Conclusion 00:15:00 Module 10: - Business Ethics Fundamentals Getting Started To Business Ethics 00:15:00 What is Ethics? 01:00:00 Implementing Ethics in the Workplace 00:30:00 Employer/Employee Rights 01:00:00 Business & Social Responsibilities 01:00:00 Ethical Decisions 01:00:00 Whistle Blowing 00:30:00 Managerial Ethics 00:30:00 Unethical Behavior 00:30:00 Ethics in Business (I) 01:00:00 Ethics in Business (II) 00:30:00 Wrapping Up 00:15:00 Module 11: Sales Analysis and Sales What Is A Sales Funnel? 00:30:00 What is Internet Commerce 00:30:00 What Can I Sell 00:30:00 Clickbank 00:30:00 Drop Shipping 00:30:00 Affiliate Marketing 00:30:00 The Link Between Products, Key Words and Prospects 00:15:00 The Front-end and Back-end of Sales Funnels 00:30:00 Sales Funnel Success 00:30:00 Sales Funnel Planning 00:30:00 Putting Your Theory to Practice 00:30:00 Content Marketing 00:30:00 Article Marketing 01:00:00 Google's Adwords Program 00:30:00 Marketing Offline 00:30:00 Blogs 00:30:00 Social Media 00:30:00 Auto Responders 00:30:00 The Joint Venture 00:30:00 Measuring Success 00:30:00 Top Sales Funnel Products 00:30:00 Mock Exam Mock Exam- Mini MBA 00:30:00 Final Exam Final Exam- Mini MBA 00:30:00

Mini MBA
Delivered Online On Demand
£10.99