1636 Database courses in Haslemere delivered Online

Course Information Our comprehensive course is used as a gateway to those stepping into the world of auditing clinical studies. Tailored for those already acquainted with Good Clinical Practice (GCP) and those transitioning from other audit disciplines, this programme stands as a pivotal guide. Pre-existing knowledge of GCP will significantly enhance your learning experience in auditing against these guidelines. How is this course run? Engage in immersive workshops providing hands-on practice with auditing techniques in a GCP context. Our seasoned tutors, boasting extensive audit experience, intertwine theory with practical insights drawn from their own professional journeys. What will I learn? A comprehensive understanding of the historical backdrop and objectives driving Good Clinical Practice, incorporating the latest industry developments Solid grounding in quality assurance activities aligned with regulatory standards Insight into potential pitfalls within clinical trials and the pivotal role of auditors in addressing these issues Clarity on the roles and responsibilities inherent to clinical trials auditing Exposure to a diverse range of audit techniques complemented by illustrative examples and supportive documents A nuanced understanding of regulatory inspectors' activities Expanded professional networks to propel your auditing career forward. Benefits include: A clear understanding of the role of the auditor under Good Clinical Practice improved audits Improved Good Clinical Practice compliance for your clinical trials. This course is structured to encourage delegates to: Discuss and develop ideas Solve specific problems Examine particular aspects of Good Clinical Practice. Tutors Tutors will be comprised of (click the photos for biographies): Rosemarie Corrigan EVP Global Quality, Worldwide Clinical Trials Cathy Dove Director and Owner, Dove Quality Solutions Julie Kelly Associate Director, Clinical Quality Assurance, Corcept Therapeutics Susana Tavares Director of Research Quality Assurance, - Programme Please note timings may be subject to alteration. Day 1 12:30 Registration 13:00 Welcome and Objectives for the first day of the course 13:30 Laying the Foundations Introduction to the clinical development process, the concepts of quality assurance, quality control and audit. 14:30 Break 15:00 Patient Protection Requirements for informed consent and ethics committee. Access to source documentation. Including a patient protection exercise. 16:05 Workshop 1 - Case Study on Informed Consent 16:45 End of Day Questions and Answers 17:00 Close of Day Day 2 08:50 Questions and Answers from Day 1 09:00 Effective Site Audits The procedures involved in selecting and setting up audits at investigator sites. 09:40 Workshop 1 - Planning the Effective Audit 10:30 Break 10:45 Source Data Verification The need for and purpose of verifying data. 11:25 Workshop 2 - Source Data Verification 12:30 Lunch 13:30 IMP Management The requirements surrounding the distribution of investigational medicinal products. Accountability from release to destruction. 14:15 Critical Document Audits The conduct of other study specific audits including protocols, databases and reports. 15:00 Break 15:15 Non-compliance Determining the acceptability of data. 16:00 Fraud - Fact or Fiction? How to identify fraud and its consequences 16:45 End of Day Questions and Answers 17:00 Close of Day Day 3 08:50 Questions and Answers from Days 1 and 2 09:00 Auditing Third Parties A review of audits of contract research organisations. 10:00 System Audits The concept of auditing processes across many clinical trials, including a practical exercise in process mapping. 10:45 Break 11:00 Workshop 3 - Process Mapping 11:45 Effective Audits Where theory meets reality. 12:30 Lunch 13:20 Audit Reports - Closing the Loop An examination of the processes which follow the evidence gathering phase of the audit. 14:20 Workshop 4 - Audit Reports Audit reports, corrective and preventive action. 15:00 Break 15:10 Regulatory Inspection Auditors and regulatory inspections -how the QA team can help the organisation to perform during a regulatory inspection. 15:55 Final Questions and Answers 16:10 Close of Course Extra Information Face-to-face course Course Material Course material will be available in PDF format for delegates attending this course. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course. The material will be emailed in advance of the course and RQA will not be providing any printed copies of the course notes during the training itself. Delegates wishing to have a hard copy of the notes should print these in advance to bring with them. Alternatively delegates are welcome to bring along their own portable devices to view the material during the training sessions. Remote course Course Material This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event. Please note this course will run in UK timezone. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course Access to an online course group to enhance networking. You will need a stable internet connection, a microphone and a webcam. CPD Points 17 Points Development Level Develop

Get ready for an exceptional online learning experience with the C ++, Javascript, HTML, SQL, PHP & Web Development bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The C ++, Javascript, HTML, SQL, PHP & Web Development is a dynamic package, that blends the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the C ++, Javascript, HTML, SQL, PHP & Web Development package has something for everyone. As part of the C ++, Javascript, HTML, SQL, PHP & Web Development package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the C ++, Javascript, HTML, SQL, PHP & Web Development bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following CPD Accredited Courses: C++ Programming for Absolute Beginners Computer Vision By Using C++ and OpenCV with GPU support Basic C# Coding Refactor Javascript Basic Asynchronous JavaScript Javascript for Data Structures Basic HTML 5 HTML Web Development Crash Course Microsoft SQL Server Development for Everyone Learn to Build a Complete CMS Blog in PHP MySQL Bootstrap & PDO PHP and MySQL Training 2022: Build 5 Real-World Projects PHP for Beginners 2023 Guide: Develop an ECommerce Store PHP and MySQL Training Masterclass 2023 Easy to Advanced Data Structures jQuery: JavaScript and AJAX Coding Bible Career Development Plan Fundamentals CV Writing and Job Searching Learn to Level Up Your Leadership Networking Skills for Personal Success Ace Your Presentations: Public Speaking Masterclass Learning Outcome: Gain comprehensive insights into multiple fields. Foster critical thinking and problem-solving skills across various disciplines. Understand industry trends and best practices through the C ++, Javascript, HTML, SQL, PHP & Web Development Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with C ++, Javascript, HTML, SQL, PHP & Web Development Bundle. Build a strong knowledge base in your chosen course via C ++, Javascript, HTML, SQL, PHP & Web Development Bundle. Benefit from the flexibility and convenience of online learning. With the C ++, Javascript, HTML, SQL, PHP & Web Development packages, validate your learning with a CPD certificate. Each course in this bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with C ++, Javascript, HTML, SQL, PHP & Web Development, a rich anthology of 15 diverse courses. Each course in the C ++, Javascript, HTML, SQL, PHP & Web Development bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. ThisC ++, Javascript, HTML, SQL, PHP & Web Development bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the C ++, Javascript, HTML, SQL, PHP & Web Development bundle offers you the flexibility and convenience to learn at your own pace. Make the C ++, Javascript, HTML, SQL, PHP & Web Development package your trusted companion in your lifelong learning journey. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The C ++, Javascript, HTML, SQL, PHP & Web Development bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Career path Unleash your potential with the C ++, Javascript, HTML, SQL, PHP & Web Development bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the C ++, Javascript, HTML, SQL, PHP & Web Developmentbundle package. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

Microsoft Office 2016 Essentials is one of our best selling and most popular course. This course is suitable for anyone aspiring to or already working in Microsoft Office and looks at skills needed to improve in relevant industry or Microsoft Office. By taking this course you will gain the necessary skills to perform effectively in this field. The Microsoft Office 2016 Essentials is organised into 97 modules and includes everything you need to become successful in this profession. To make this course more accessible for you, we have designed it for both part-time and full-time students. You can study at your own pace or become an expert in just 16 hours! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. Course Content Excel 2016 Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Word 2016 Getting Started with Word Navigate in Microsoft Word 00:12:00 Create and Save Word Documents 00:24:00 Manage Your Workspace 00:06:00 Edit Documents 00:16:00 Preview and Print Documents 00:04:00 Customize the Word Environment 00:08:00 Formatting Text and Paragraphs Apply Character Formatting 00:17:00 Control Paragraph Layout 00:19:00 Align Text Using Tabs 00:07:00 Display Text in Bulleted or Numbered Lists 00:03:00 Apply Borders and Shading 00:04:00 Working More Efficiently Make Repetitive Edits 00:06:00 Apply Repetitive Formatting 00:10:00 Use Styles to Streamline Repetitive Formatting Tasks 00:14:00 Managing Lists Sort a List 00:05:00 Format a List 00:06:00 Adding Tables Insert a Table 00:07:00 Modify a Table 00:06:00 Format a Table 00:03:00 Convert Text to a Table 00:04:00 Inserting Graphic Objects Insert Symbols and Special Characters 00:04:00 Add Images to a Document 00:11:00 Controlling Page Appearance Apply a Page Border and Color 00:03:00 Add Headers and Footers 00:06:00 Control Page Layout 00:05:00 Add a Watermark 00:04:00 Preparing to Publish a Document Check Spelling Grammar and Readability 00:07:00 Use Research Tools 00:06:00 Check Accessibility 00:03:00 Save a Document to Other Formats 00:04:00 Workbooks - Microsoft Word 2016 (Beginner) Workbooks - Microsoft Word 2019 00:00:00 PowerPoint 2016 PowerPoint Interface Navigate the PowerPoint Environment 00:28:00 View and Navigate a Presentation 00:15:00 Create and Save a PowerPoint Presentation 00:13:00 Use PowerPoint Help 00:10:00 Presentation Basics Select a Presentation Type 00:08:00 Edit Text 00:13:00 Build a Presentation 00:27:00 Formatting Format Characters 00:11:00 Format Paragraphs 00:16:00 Format Text Boxes 00:09:00 Inserting Options Insert Images 00:10:00 Insert Shapes 00:15:00 Working with Objects Edit Objects 00:16:00 Format Objects 00:06:00 Group Objects 00:04:00 Arrange Objects 00:07:00 Animate Objects 00:07:00 Table Create a Table 00:09:00 Format a Table 00:03:00 Insert a Table from Other Microsoft Office Applications 00:06:00 Charts Create a Chart 00:10:00 Format a Chart 00:10:00 Insert a Chart from Microsoft Excel 00:05:00 Review and Presentatin Review Your Presentation 00:11:00 Apply Transitions 00:05:00 Print Your Presentation 00:05:00 Deliver Your Presentation 00:08:00 Access 2016 Introduction to Access Orientation to Microsoft Access 00:39:00 Create a Simple Access Database 00:10:00 Get Help and Configure Options in Microsoft Access 00:06:00 Modify Data Modify Table Data 00:17:00 Sort and Filter Records 00:05:00 Working with Queries Create Basic Queries 00:15:00 Sort and Filter Data in a Query 00:14:00 Perform Calculations in a Query 00:08:00 Access Forms Create Basic Access Forms 00:07:00 Work with Data on Access Forms 00:23:00 Working with Reports Create a Report 00:23:00 Add Controls to a Report 00:12:00 Enhance the Appearance of a Report 00:05:00 Prepare a Report for Print 00:03:00 Organize Report Information 00:15:00 Format Reports 00:12:00 Assignment Assignment - Microsoft Office 2016 Essentials 3 weeks, 3 days Order Your Certificate Order your Certificate QLS 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Description Microsoft Excel is a powerful and easy to use spreadsheet program that almost all businesses use on a day-to-day basis. It is used to store and retrieve numerical data and it is ideal for entering, calculating and analysing company data such as sales figures, sales taxes or commissions. This Level 3 Diploma in Microsoft Excel 2016 is a course which will help you learn the various features incorporated in the software. This course has been specially designed to cover everything from the basic concepts to the advanced levels. This course allows you to take advantage of the online aspect of training by learning at your own pace. As long as you have access to an eligible device, such as a laptop, or smartphone, and an internet connection, you can access this Level 3 Diploma in Microsoft Excel 2016 from anywhere, and anytime. Learning Outcomes: Familiarize the excel user interface, creating basic worksheet and using the help system How to create formulas, reuse them and insert functions in a worksheet Managing cells, columns and rows and ways to manipulate data Utilizing the 'Search and replace' data options and spell checking Modifying fonts, adding borders and colours to cells, using number formats, aligning cell contents and applying cell styles Define and refine page layouts for printing options Managing large workbooks through worksheet tab formatting and using different views Options for general customization, language, formula, proofing and saving Customizing Quick Access toolbar, ribbon, advanced and Trust Center options Utilize Excel's version control features and enabling add-ins Best ways to utilize Macro Recorder, how to edit and debug a macro, and setting up macro security Customizing the Quick Access toolbar and hotkeys Utilizing Macros to insert and format texts, sort and duplicate data, and generate reports Determine appropriate dialog box types to use Using variety of techniques to capture user input Managing worksheets using macros Creating user-defined functions and ways to automate SUM functions with macros Explore PowerPivot applications Importing data from different sources Creating linked tables Organizing and formatting tables Creating calculated columns PowerPivot data filtering and sorting Creating PivotTables and PivotCharts, and filtering data using slicers Presenting Visual data through visual outlets Utilizing DAX functions for manipulating PowerPivot data Extracting data from tables using functions, and working with time-dependent data Saving data in different formats and protecting reports Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. 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? Level 3 Diploma in Microsoft Excel 2016 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 Level 3 Diploma in Microsoft Excel 2016 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. Module : 1 Identify the Elements of the Excel Interface 00:30:00 Activity - Identify the Elements of the Excel Interface 00:05:00 Create a Basic Worksheet 01:00:00 Activity - Create a Basic Worksheet 00:05:00 Use the Help System 00:30:00 Activity - Use the Help System 00:05:00 Create Formulas in a Worksheet 01:00:00 Activity - Create Formulas in a Worksheet 00:05:00 Insert Functions in a Worksheet 00:30:00 Activity - Insert Functions in a Worksheet 00:05:00 Reuse Formulas 00:30:00 Activity - Reuse Formulas 00:05:00 Manipulate Data 00:30:00 Activity - Manipulate Data 00:05:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:30:00 Activity - Insert, Manipulate, and Delete Cells, Columns, and Rows 00:05:00 Search For and Replace Data 00:30:00 Activity - Search For and Replace Data 00:05:00 Spell Check a Worksheet 00:30:00 Activity - Spell Check a Worksheet 00:05:00 Modify Fonts 00:30:00 Activity - Modify Fonts 00:05:00 Add Borders and Colors to Cells 01:00:00 Activity - Add Borders and Colors to Cells 00:05:00 Apply Number Formats 00:30:00 Activity - Apply Number Formats 00:05:00 Align Cell Contents 00:30:00 Activity - Align Cell Contents 00:05:00 Apply Cell Styles 00:30:00 Activity - Apply Cell Styles 00:05:00 Define the Basic Page Layout for a Workbook 01:00:00 Activity - Define the Basic Page Layout for a Workbook 00:05:00 Refine the Page Layout and Apply Print Options 00:30:00 Activity - Refine the Page Layout and Apply Print Options 00:05:00 Format Worksheet Tabs 00:30:00 Activity - Format Worksheet Tabs 00:05:00 Manage Worksheets 00:30:00 Activity - Manage Worksheets 00:05:00 Manage the View of Worksheets and Workbooks 00:30:00 Activity - Manage the View of Worksheets and Workbooks 00:05:00 Customize General and Language Options 00:30:00 Activity - Customize General and Language Options 00:05:00 Customize Formula Options 00:30:00 Activity - Customize Formula Options 00:05:00 Customize Proofing and Save Options 01:00:00 Activity - Customize Proofing and Save Options 00:05:00 Customize the Ribbon and Quick Access Toolbar 00:30:00 Activity - Customize the Ribbon and Quick Access Toolbar 00:05:00 Customize the Functionality of Excel by Enabling Add-Ins 00:30:00 Activity - Customize the Functionality of Excel by Enabling Add-Ins 00:05:00 Customize Advanced and Trust Center Options 00:30:00 Activity - Customize Advanced and Trust Center Options 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 for Beginners 00:00:00 Module : 2 Apply Range Names 00:30:00 Use Specialized Functions 00:30:00 Use Text Functions 00:30:00 Use Logical Functions 00:30:00 Use Lookup Functions 00:30:00 Use Date Functions 00:30:00 Use Financial Functions 00:30:00 Create and Modify Tables 00:30:00 Sort and Filter Data 00:30:00 Use Subtotal and Database Functions to Calculate Data 00:30:00 Create Charts 00:30:00 Modify and Format Charts 00:30:00 Create a Trendline 00:30:00 Create Advanced Charts 00:30:00 Create a PivotTable 00:30:00 Filter Data by Using Slicers 00:30:00 Analyze Data with PivotCharts 00:30:00 Insert and Modify Graphic Objects 00:30:00 Layer and Group Graphic Objects 00:30:00 Incorporate SmartArt 00:30:00 Customize Workbooks 00:30:00 Manage Themes 00:30:00 Create and Use Templates 00:30:00 Protect Files 00:30:00 Preparing a Workbook for Multiple Audiences 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 Intermediate 00:00:00 Module : 3 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 Activity-Integrate Excel Data with the Web 00:05: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 Module : 4 Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 and VBA 00:00:00 Module : 5 Enable and Navigate 00:30:00 Import Data from Various Data Sources 01:00:00 Refresh Data from a Data Source 00:30:00 Create Linked Tables 00:30:00 Organize and Format Tables 00:30:00 Create Calculated Columns 00:30:00 Sort and Filter PowerPivot Data 00:30:00 Create and Manage Table Relationships 01:00:00 Create PivotTables 01:00:00 Create PivotCharts 00:30:00 Create Power Views 01:00:00 Filter Data Using Slicers 00:30:00 Present PivotTable Data Visually 01:00:00 Manipulate PowerPivot Data Using DAX Functions 01:00:00 Extract Data from Tables Using Functions 00:30:00 Save Reports in Different File Formats 01:00:00 Work with Time Dependent Data 00:30:00 Protect Reports 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 PowerPivot 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Level 3 Diploma in Microsoft Excel 2016 00:30:00 Final Exam Final Exam- Level 3 Diploma in Microsoft Excel 2016 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Are you ready to embark on an enlightening journey of wisdom with the Big Data bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - Big Data : Data Science, Data Analytics & Data Visualisation. Delve into eight immersive CPD Accredited courses, each a standalone course: Big Data Analytics with PySpark Power BI and MongoDB Big Data Analytics with PySpark Tableau Desktop and MongoDB Building Big Data Pipelines with PySpark MongoDB and Bokeh Develop Big Data Pipelines with R & Sparklyr & Tableau Develop Big Data Pipelines with R, Sparklyr & Power BI Basic Data Analysis SQL for Data Science, Data Analytics and Data Visualization Complete Python Machine Learning & Data Science Fundamentals Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Big Data : Data Science, Data Analytics & Data Visualisation bundle illuminate your path to wisdom. The Big Data : Data Science, Data Analytics & Data Visualisation bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Big Data : Data Science, Data Analytics & Data Visualisation package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Big Data bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Big Data : Data Science, Data Analytics & Data Visualisation community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the Big Data bundle. Establish robust bases across each course nestled within the Big Data bundle. Decipher intricate concepts through the articulate content of the Big Data bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Big Data bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Big Data bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Big Data bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Big Data bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Big Data bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Big Data journey and let knowledge guide you towards a brighter future. CPD 85 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the Big Data bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Big Data bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript - £9.99

Overview This comprehensive course on AutoCAD Programming Using C#.NET Level 7 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This AutoCAD Programming Using C#.NET Level 7 comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this AutoCAD Programming Using C#.NET Level 7. It is available to all students, of all academic backgrounds. Requirements Our AutoCAD Programming Using C#.NET Level 7 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This 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 Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 12 sections • 193 lectures • 16:44:00 total length •Module 01: Introduction: 00:01:00 •Module 02: Who is this course for?: 00:01:00 •Module 03: What Will I Learn from this Course?: 00:01:00 •Module 04: What is CSharp (C#)?: 00:01:00 •Module 05: What is AutoCAD .NET API?: 00:01:00 •Module 06: What are the advantages of programming in AutoCAD .NET API?: 00:02:00 •Module 01: Section Overview: 00:01:00 •Module 02:.NET Framework Architecture Overview: 00:03:00 •Module 03: .NET Framework Class Library, Common Type System, Common Language Runtime: 00:03:00 •Module 04: More about.NET Framework Common Language Runtime (CLR): 00:02:00 •Module 05: Visual Studio 2017 Integrated Development Environment (IDE): 00:03:00 •Module 06: Visual Studio 2017 IDE Demo: 00:07:00 •Module 01: Section Overview: 00:03:00 •Module 02: DataTypes and Variables - Value Types (signed/unsigned integers): 00:04:00 •Module 03: DataTypes and Variables - Signed and Unsigned Integer Demo: 00:06:00 •Module 04: DataTypes and Variables - Floating Point and Decimal: 00:02:00 •Module 05: DataTypes and Variables - Floating Point and Decimal Demo: 00:04:00 •Module 06: DataTypes and Variables - Boolean: 00:03:00 •Module 07: DataTypes and Variables - Reference Types: 00:03:00 •Module 08: DataTypes and Variables - Class Type: 00:03:00 •Module 09: DataTypes and Variables - Class Type - Demo: 00:11:00 •Module 10: DataTypes and Variables - Interface Type: 00:01:00 •Module 11: DataTypes and Variables - Array Type: 00:02:00 •Module 12: DataTypes and Variables - Array Type - Demo (Single Dimension): 00:08:00 •Module 13: DataTypes and Variables - Array Type - Demo (Multi Dimension): 00:10:00 •Module 14: C# Operators Overview: 00:02:00 •Module 15: C# Assignment Operators: 00:03:00 •Module 16: C# Assignment Operators - Demo: 00:06:00 •Module 17: C# Unary Operators: 00:02:00 •Module 18: C# Unary Operators - Demo: 00:02:00 •Module 19: C# Primary Operators: 00:03:00 •Module 20: C# Primary Operators - Demo: 00:07:00 •Module 21: C# Equality Operators: 00:01:00 •Module 22: C# Equality Operators - Demo: 00:02:00 •Module 23: C# Additive Operators: 00:02:00 •Module 24: C# Additive Operators - Demo: 00:01:00 •Module 25: C# Multiplicative Operators: 00:01:00 •Module 26: C# Multiplicative Operators - Demo: 00:01:00 •Module 27: C# - Relational and Type Operators: 00:04:00 •Module 28: C# - Logical, Conditional and Null Operators: 00:04:00 •Module 29: C# - Logical, Conditional and Null Operators - Demo: 00:07:00 •Module 30: C# Keywords (Reserved Words): 00:04:00 •Module 31: C# - Conditionals Overview: 00:01:00 •Module 32: C# Conditionals - If-Then-Else Statement: 00:03:00 •Module 33: C# Conditionals - If-Then-Else Statement - Demo: 00:07:00 •Module 34: C# Conditionals - Switch Statement: 00:03:00 •Module 35: C# Conditionals - Switch Statement - Demo: 00:00:00 •Module 36: C# - Loops Overview: 00:04:00 •Module 37: C# Loops - For Loop: 00:02:00 •Module 38: C# Loops - For Loop - Demo: 00:02:00 •Module 39: C# Loops - Foreach Loop: 00:02:00 •Module 40: C# Loops - Foreach Loop - Demo: 00:05:00 •Module 41: C# Loops - While Loop: 00:02:00 •Module 42: C# Loops - While Loop - Demo: 00:02:00 •Module 43: C# Loops - Do While Loop: 00:02:00 •Module 44: C# Loops - Do While Loop - Demo: 00:03:00 •Module 45: Modifiers Overview: 00:04:00 •Module 46: Debugging Overview: 00:03:00 •Module 47: Debugging - Demo 1: 00:05:00 •Module 48: Debugging - Demo 2: 00:12:00 •Module 49: Debugging - Demo 3: 00:06:00 •Module 50: Error and Exception Handling - Overview: 00:02:00 •Module 51: ExceptionHandling - Demo 1: 00:07:00 •Module 52: ExceptionHandling - Demo 2: 00:07:00 •Module 53: ExceptionHandling - Demo 3: 00:13:00 •Module 54: Introduction to Object Oriented Programming (OOP): 00:04:00 •Module 55: OOP - Encapsulation - Demo (Part 1): 00:11:00 •Module 56: OOP - Encapsulation - Demo (Part 2): 00:12:00 •Module 57: OOP - Inheritance - Demo (Part 1): 00:07:00 •Module 58: OOP - Inheritance - Demo (Part 2): 00:05:00 •Module 59: OOP - Polymorphism - Demo (Part 1): 00:10:00 •Module 60: OOP - Polymorphism - Demo (Part 2): 00:03:00 •Module 01: AutoCAD .NET API - Overview: 00:01:00 •Module 02: AutoCAD .NET API Assemblies: 00:02:00 •Module 03: Using AutoCAD .NET API in C# - Hello AutoCAD Demo Part 1: 00:12:00 •Module 04: Using AutoCAD .NET API in C# - Hello AutoCAD Demo - Part 2: 00:04:00 •Module 05: AutoCAD .NET API Object Hierarchy: 00:03:00 •Module 06: AutoCAD .NET API - Application Object Overview: 00:03:00 •Module 07: AutoCAD .NET API - Document Object Overview: 00:03:00 •Module 08: AutoCAD .NET API - Database Object Overview: 00:03:00 •Module 01: Creating AutoCAD Objects using AutoCAD .NET API - Overview: 00:01:00 •Module 02: Creating a Line Object - Lab (Part 1): 00:14:00 •Module 03: Creating a Line Object - Lab (Part 2): 00:03:00 •Module 04: Creating a MText Object - Lab: 00:10:00 •Module 05: Creating a Circle Object - Lab: 00:07:00 •Module 06: Creating an Arc Object - Lab: 00:05:00 •Module 07: Creating a LWPolyline Object - Lab: 00:05:00 •Module 01: Manipulate AutoCAD Objects - Overview: 00:01:00 •Module 02: Copy Object using C# - Theory: 00:01:00 •Module 03: Copy Object using C# - Lab (Part 1): 00:11:00 •Module 04: Copy Object using C# - Lab (Part 2): 00:02:00 •Module 05: Copy multiple objects using C# - Lab (Part 1): 00:09:00 •Module 06: Copy multiple objects using C# - Lab (Part 2): 00:01:00 •Module 07: Erase Object using C# - Lab (Part 1): 00:06:00 •Module 08: Erase Object using C# - Lab (Part 2): 00:05:00 •Module 09: Move Object using C# - Lab (Part 1): 00:06:00 •Module 10: Move Object using C# - Lab (Part 2): 00:02:00 •Module 11: Mirror Object using C# - Lab (Part 1): 00:10:00 •Module 12: Mirror Object using C# - Lab (Part 2): 00:02:00 •Module 13: Rotate Object using C# - Lab (Part 1): 00:07:00 •Module 14: Rotate Object using C# - Lab (Part 2): 00:03:00 •Module 15: Scale Object using C# - Lab: 00:05:00 •Module 16: Copy Object Exercise: 00:02:00 •Module 17: Copy Object Solution: 00:06:00 •Module 18: Erase Object Exercise: 00:02:00 •Module 19: Erase Object Solution: 00:07:00 •Module 20: Move Object Exercise: 00:02:00 •Module 21: Move Object Solution: 00:06:00 •Module 22: Mirror Object Exercise: 00:02:00 •Module 23: Mirror Object Solution: 00:06:00 •Module 24: Rotate Object Exercise: 00:02:00 •Module 25: Rotate Object Solution: 00:06:00 •Module 26: Scale Object Exercise: 00:01:00 •Module 27: Scale Object Solution: 00:05:00 •Module 01: Exploring AutoCAD Dictionaries - Layers Overview: 00:03:00 •Module 02: Listing all the Layers in the drawing using C#: 00:11:00 •Module 03: Creating a Layer in AutoCAD using C#: 00:09:00 •Module 04: Updating a Layer in AutoCAD using C#: 00:09:00 •Module 05: Turning the Layer On/Off in AutoCAD using C#: 00:05:00 •Module 06: Thawing/Freezing Layer in AutoCAD using C#: 00:04:00 •Module 07: Deleting a Layer in AutoCAD using C#: 00:03:00 •Module 08: Locking/UnLocking a Layer in AutoCAD using C#: 00:05:00 •Module 09: Assigning a Layer to an AutoCAD object using C#: 00:03:00 •Module 10: Exploring AutoCAD Dictionaries - LineTypes Overview: 00:01:00 •Module 11: Listing all the LineTypes in the drawing using C#: 00:07:00 •Module 12: Loading a LineType in the drawing using C#: 00:07:00 •Module 13: Setting the Current LineType in AutoCAD using C#: 00:03:00 •Module 14: Deleting a LineType in AutoCAD using C#: 00:03:00 •Module 15: Setting a LineType to an object using C#: 00:04:00 •Module 16: Exploring AutoCAD Dictionaries - TextStyles Overview: 00:01:00 •Module 17: Listing all the TextStyles in the drawing using C#: 00:08:00 •Module 18: Updating current TextStyle Font in AutoCAD using C#: 00:10:00 •Module 19: Setting the Current TextStyle in AutoCAD using C#: 00:08:00 •Module 20: Setting a TextStyle to an object using C#: 00:04:00 •Module 01: User Input Functions Overview: 00:01:00 •Module 02: Using GetString Method - Lab (Part 1): 00:13:00 •Module 03: Using GetString Method - Lab (Part 2): 00:10:00 •Module 04: Using GetPoint Method - Lab: 00:12:00 •Module 05: Using GetDistance Method - Lab: 00:04:00 •Module 06: Using GetKeyWords Method - Lab (Part 1): 00:12:00 •Module 07: Using GetKeyWords Method - Lab (Part 2): 00:02:00 •Module 01: Selection Sets and Filters - Overview: 00:02:00 •Module 01: Selection Sets and Filters - Overview: 00:02:00 •Module 03: Using SelectAll Method - Lab (Part 2): 00:02:00 •Module 04: Using SelectOnScreen Method - Lab (Part 1): 00:06:00 •Module 05: Using SelectOnScreen Method - Lab (Part 2): 00:01:00 •Module 06: Using SelectWindow Method - Lab: 00:08:00 •Module 07: Using SelectCrossingWindow Method - Lab: 00:08:00 •Module 08: Using SelectFence Method - Lab: 00:08:00 •Module 09: Using PickFirstSelection Method - Lab: 00:11:00 •Module 10: Using SelectionSet Filters - Overview: 00:01:00 •Module 11: Using SelectionSet Filters - Selecting Lines: 00:09:00 •Module 12: Using SelectionSet Filters - Selecting MTexts Lab: 00:07:00 •Module 13: Using SelectionSet Filters - Selecting Polylines Lab: 00:03:00 •Module 14: Using SelectionSet Filters - Selecting Blocks (FrenchDoors) Lab: 00:07:00 •Module 15: Using SelectionSet Filters - Selecting Blocks (BiFoldDoors) Lab: 00:04:00 •Module 16: Using SelectionSet Filters - Selecting objects in a Layer (Walls) Lab: 00:07:00 •Module 17: Using SelectionSet Filters - Selecting all objects in a Layer (Stairs) Lab: 00:05:00 •Module 18: Using SelectionSets and Filters - Exercises: 00:02:00 •Module 01: TitleBlock Project - Overview: 00:05:00 •Module 02: Creating Project and TBlock Class - Lab: 00:14:00 •Module 03: Creating Classes for each Paper Sizes - Lab: 00:07:00 •Module 04: Creating TitleBlock Class - Lab: 00:14:00 •Module 05: Handling User Selected Paper Size - Lab: 00:05:00 •Module 06: Creating the TitleBlock Border Lines - Lab: 00:06:00 •Module 07: Creating the Horizontal Partition Lines - Lab (Part 1): 00:11:00 •Module 08: Creating the Horizontal Partition Lines - Lab (Part 2): 00:05:00 •Module 09: Creating Vertical Partition Lines - Lab: 00:11:00 •Module 10: Project Check on the Partition Lines - Lab: 00:07:00 •Module 11: Creating the TitleBlock Labels - Lab (Part 1): 00:10:00 •Module 12: Creating the TitleBlock Labels - Lab (Part 2): 00:09:00 •Module 13: Creating the TitleBlock Labels - Lab (Part 3): 00:11:00 •Module 14: Project Check on the Labels: 00:07:00 •Module 15: Creating Drawing Information Texts: 00:08:00 •Module 16: Debugging the TitleBlock Project - Lab: 00:10:00 •Module 17: Completing and Running the TitleBlock Plugin: 00:05:00 •Module 18: Audit Drawing Project - Overview: 00:02:00 •Module 19: Audit Drawing Project - Demo: 00:07:00 •Module 20: Creating the AuditDrawing Project: 00:11:00 •Module 21: Creating the AuditDrawing DisplayOnScreen Method: 00:14:00 •Module 22: Creating the AuditDrawing Write to TXT File Method: 00:08:00 •Module 23: Creating the AuditDrawing Write to CSV File Method: 00:06:00 •Module 24: Creating the AuditDrawing Write to HTML File Method: 00:14:00 •Module 25: AuditDrawing Plugin Demo: 00:04:00 •Module 26: Creating the AuditBlock Method: 00:05:00 •Module 27: Creating the AuditBlock GatherBlocksAndCount Method: 00:16:00 •Module 28: Creating the AuditBlock DisplayOnScreen Method: 00:06:00 •Module 29: Creating the AuditBlock WriteToTXTFile Method: 00:05:00 •Module 30: Creating the AuditBlock WriteToCSVFile Method: 00:05:00 •Module 31: Creating the AuditBlock WriteToHTMLFile Method: 00:07:00 •Module 32: AuditBlock Completed Component - Demo: 00:12:00 •Module 01: Conclusion: 00:01:00 •Assignment - AutoCAD Programming Using C#.NET Level 7: 00:00:00

Duration 5 Days 30 CPD hours This course is intended for In order to be successful in this course you should have incoming hands-on experience with another programming language. This course is not for non-developers or new developers. Possible roles that may attend this course include: Software Developers: Professionals who have been working with other programming languages and want to expand their skillset by learning Java and its object-oriented features. Web Developers: Those who work on web applications and want to enhance their back-end development capabilities with Java. Mobile App Developers: Developers who wish to enter the world of Android app development, where Java is a widely used language for creating mobile applications. Overview This 'skills-centric' course is about 50% hands-on lab and 50% lecture, designed to train attendees in core OO coding and Java development skills, coupling the most current, effective techniques with the soundest industry practices. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment, guided by our expert team, attendees will learn to: Understand what OO programming is and what the advantages of OO are in today's world Work with objects, classes, and OO implementations Understand the basic concepts of OO such as encapsulation, inheritance, polymorphism, and abstraction Understand not only the fundamentals of the Java language, but also its importance, uses, strengths and weaknesses Understand the basics of the Java language and how?it relates to OO programming and the Object Model Learn to use Java exception handling Understand and use classes, inheritance and polymorphism Understand and use collections, generics, autoboxing, and enumerations Become familiar with the concept of functional programming using Lambda Expressions Process large amounts of data using the Stream API introduced in Java 8 Discover the new Date/Time API Use the JDBC API for database access Work with annotations Take advantage of the Java tooling that is available with the programming environment being used in the class Java 8 Features: Lambda Expressions, Method and Constructor references, The Streams API, Collectors, The Optional class Geared for experienced developers, Basic Java Programming for Developers New to OO, this hands-on, workshop-style course will provide you with an immersive learning experience that will expand your skillset and open doors to new opportunities within the ever-growing technology landscape. Mastering Java and its powerful capabilities will provide you with the competitive edge you need to stand out in today's fast-paced development world. Working in a hands-on learning environment led by our expert coach, you?ll thoroughly explore the foundations of the Java platform, essential programming concepts, and advanced topics, ensuring you acquire a strong understanding of the language and its ecosystem. The object-oriented programming principles taught in this course promote code reusability and maintainability, enabling you to streamline development processes and reduce long-term costs. As you progress through the course, you will also gain familiarity with using an IDE, enhancing your development workflow and collaboration with other Java developers, enabling you to integrate seamlessly into new projects and teams. You?ll also gain practical experience in applying the concepts and techniques learned, solidifying your newly acquired skills and facilitating their direct application in real-world scenarios. You?ll exit this course empowered to create robust, scalable, and efficient Java-based applications that drive innovation and growth for your organization The Java Platform The Java Platform Lifecycle of a Java Program Responsibilities of JVM Documentation and Code Reuse Using the JDK Explain the JDK?s file structure Use the command line compiler to compile a Java class Use the command line Java interpreter to run a Java application class The IntelliJ Paradigm Introduce the IntelliJ IDE The Basics of the IntelliJ interface IntelliJ Projects and Modules Creating and running Java applications Writing a Simple Class Write a Java class that does not explicitly extend another class Define instance variables for a Java class Create object instances Primitives vs Object References Implement a main method to create an instance of the defined class Adding Methods to the Class Write a class with accessor methods to read and write instance variables Write a constructor to initialize an instance with data Write a constructor that calls other constructors of the class to benefit from code reuse Use the this keyword to distinguish local variables from instance variables Object-Oriented Programming Real-World Objects Classes and Objects Object Behavior Methods and Messages Inheritance, Abstraction, and Polymorphism Encapsulation Inheritance Method Overriding Polymorphism Essential Java Programming Essential Java Programming Language Statements Arithmetic operators Operators to increment and decrement numbers Comparison operators Logical operators Return type of comparison and logical operators Use for loops Switch Expressions Switch Expressions and yield Using Strings and Text Blocks Create an instance of the String class Test if two strings are equal Get the length of a string Parse a string for its token components Perform a case-insensitive equality test Build up a string using StringBuffer Contrast String, StringBuffer,and StringBuilder Compact Strings Text Blocks Specializing in a Subclass Constructing a class that extends another class Implementing equals and toString Writing constructors that pass initialization data to parent constructor Using instanceof to verify type of an object reference Pattern matching for instanceof Overriding subclass methods Safely casting references to a more refined type Fields and Variables Discuss Block Scoping Rules Distinguish between instance variables and method variables within a method Explain the difference between the terms field and variable List the default values for instance variables Final and Static fields and methods Local Variable type inference Using Arrays Declaring an array reference Allocating an array Initializing the entries in an array Writing methods with a variable number of arguments Records Data Objects in Java Introduce records as carrier of immutable data Defining records Java Packages and Visibility Use the package keyword to define a class within a specific package Discuss levels of accessibility/visibility Using the import keyword to declare references to classes in a specific package Using the standard type naming conventions Visibility in the Java Modular System Correctly executing a Java application class The Java modular system Defining Modules Inheritance and Polymorphism Write a subclass with a method that overrides a method in the superclass Group objects by their common supertype Utilize polymorphism Cast a supertype reference to a valid subtype reference Use the final keyword on methods and classes to prevent overriding Interfaces and Abstract Classes Define supertype contracts using abstract classes Implement concrete classes based on abstract classes Define supertype contracts using interfaces Implement concrete classes based on interfaces Explain advantage of interfaces over abstract classes Explain advantage of abstract classes over interfaces Static, default and private methods in interfaces Sealed classes Introduce Sealed classes The sealed and permits modifiers Sealed Interfaces Exception Handling Introduction to Exception Handling Introduce the Exception architecture Defining a try/catch blocks Checked vs Unchecked exceptions Exceptions Defining your own application exceptions Automatic closure of resources Suppressed exceptions Handling multiple exceptions in one catch Helpful Nullpointers Enhanced try-with-resources Java Developer's Toolbox Developing applications Introduce the wrapper classes Explain Autoboxing and Unboxing Converting String representations of primitive numbers into their primitive types Defining Enumerations Using static imports Deprecating methods Advanced Java Programming Introduction to Generics Generics and Subtyping Bounded Wildcards Generic Methods Legacy Calls To Generics When Generics Should Be Used Lambda Expressions and Functional Interface Understanding the concept of functional programming Writing lambda expressions Understanding functional interfaces Collections Provide an overview of the Collection API Review the different collection implementations (Set, List and Queue) Explore how generics are used with collections Examine iterators for working with collections Using Collections Collection Sorting Comparators Using the Right Collection Lambda expressions in Collections Bonus Topics: Time Permitting Streams Understanding the problem with collections in Java Thinking of program solutions in a declarative way Use the Stream API to process collections of data Understand the difference between intermediate and terminal stream operations Filtering elements from a Stream Finding element(s) within a Stream Collecting the elements from a Stream into a List takeWhile and dropWhile intermediate operations Collectors Using different ways to collect the items from a Stream Grouping elements within a stream Gathering statistics about numeric property of elements in a stream

Microsoft Office

Duration 4 Days 24 CPD hours This course is intended for This is an intermediate course for individuals responsible for developing and implementing effective storage management techniques. Overview Establish a DFSMS configuration to automatically enforce your installation's storage management policies Convert service level requirements into appropriate parameters for data class, storage class, management class, and storage groups Create and test Automatic Class Selection (ACS) routines Convert volumes and move data to system-managed volumes with DFSMS Data Set Services (DFSMSdss) Specify appropriate management class and storage group parameters for DFSMS Hierarchical Storage Management (DFSMShsm) processing of system-managed data sets Plan to maintain your DFSMS environment using Naviquest Establish procedures to control, manage, and recover the storage management subsystem with ISMF and operator commands Develop a DFSMS implementation plan In this course you will learn how to plan and implement DFSMS and learn how to manage temporary and permanent data sets with an emphasis on disk storage. Course introduction and DFSMS overview Specify the storage administration functions that can be automatically performed by the system Identify the types of data set services that need to be established by negotiating service level agreements Correlate data set service requirements to the SMS configuration components: data class, storage class, management class, storage group, and automatic class selection routines Activating SMS Identify the functions eligible for exploitation with the installation of DFSMS Data Facility Product (DFSMSdfp) and the activation of SMS Create SMS control data sets Code SYS1.PARMLIB operands necessary to bring up SMS Create a minimal configuration Activate a configuration Writing ACS routines Identify the purpose of the ACS routines Develop an understanding of the statements Differentiate between literals and masks Describe the read variables available in the ACS routines Managing temporary data sets Create/alter storage classes and storage groups Identify steps to install and use the starter set Write ACS routines to handle temporary data sets Activate a system to manage temporary data sets Code commands to change volume/group SMS status Issue operator commands to display current status Exploiting DFSMS Describe the purpose of the data class Identify the features that the data class can exploit Create data sets using the space parameter Define Virtual Storage Access Method (VSAM) and volume attributes for data class Identify special data sets and their exploitation through the data class Managing permanent data sets Create/alter data classes, storage classes, management classes, and storage groups Translate current (DFSMShsm) service level agreements to management class parameters Identify alternatives and concerns for standard naming conventions Establish the controls for automatic backup of data sets Establish the controls for automatic volume dump Write ACS routines to manage permanent data Create a configuration that manages permanent data sets Create a new managed data set Identify function of storage class exit provided by Custom-Built Installation Process Offering (CBIPO) and resulting System Management Facility (SMF) records Using Naviquest Create test cases using Naviquest Perform storage administration tasks in batch Create online DFSMS reports Create model commands using Naviquest Use the COPYFILT macro Device preparation and data movement Initialize volumes as system-managed Move data into/out from system-managed control Convert volumes to/from system-managed Move data to utilize new hardware capabilities Controlling DFSMS Code commands to change SMS volume/group status Issue commands to save configurations and use alternate Active Control Data Set (ACDS) Issue command to use alternate Communication Data Set (COMMDS) Issue VARY SMS commands Communicate with the security administrator about storage management requirements Additional considerations Establish a plan for implementing SMS Locate sources of implementation planning checklists Identify the tools available to document the current system Identify multiple site considerations for recovery and exploitation Additional course details: Nexus Humans SS84 IBM DFSMS Implementation 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 SS84 IBM DFSMS Implementation 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 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.