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

5134 Courses

Professional Certificate Course in Project Cost Estimation in London 2024

4.9(261)

By Metropolitan School of Business & Management UK

The course aims to provide an overview of cost control, including the meaning and features of cost control, the cost breakdown structure and cost estimation, various techniques and types of cost estimation, and the meaning and techniques of contingency estimation. Students will learn about the importance of cost control, how to create a cost breakdown structure, different methods of cost estimation, and how to use contingency estimation to manage unexpected costs. This course provides an overview of cost control, including its meaning, features, and importance. Participants will understand the cost breakdown structure and cost estimation, various techniques and types of cost estimation, and contingency estimation. The course covers different methods of cost estimation, how to create a cost breakdown structure, and the importance of regularly monitoring and controlling costs. After the successful completion of the course, you will be able to learn about the following; The meaning and features of cost control. The cost breakdown structure and cost estimation. The various techniques and types of cost estimation. The meaning and techniques of contingency estimation. Effective cost control is crucial for organizations seeking to achieve their goals while managing their financial resources effectively. This course aims to provide participants with an overview of cost control, including its meaning, features, and importance. Participants will learn about the cost breakdown structure and cost estimation, including various techniques and types of cost estimation. The course will cover the use of contingency estimation to manage unexpected costs and the importance of regularly monitoring and controlling costs.Moreover, the course will delve into the different methods of cost estimation, including top-down, bottom-up, and parametric cost estimation. Participants will learn how to create a cost breakdown structure and how to estimate costs accurately based on the scope of the project. The course will be delivered through a mix of theoretical content, practical case studies, and interactive exercises. Participants will work individually and in groups to develop their understanding of cost control and apply their learning to real-life scenarios.By the end of this course, participants will have gained valuable knowledge and skills to become effective cost controllers. They will have a comprehensive understanding of the meaning and features of cost control, the ability to create a cost breakdown structure, accurately estimate costs using different techniques, and use contingency estimation to manage unexpected costs. Participants will be equipped with the knowledge and skills needed to manage their costs effectively and ensure the success of their projects. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Project Cost Estimation - N Self-paced pre-recorded learning content on this topic. Project Cost Estimation Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor Project Managers Project Coordinators Project Analysts Business Analysts Team Leaders Department Managers Executives overseeing projects Consultants Engineers IT Professionals Marketing Managers Human Resources Managers Financial Analysts Operations Managers Supply Chain Managers Product Managers. Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Professional Certificate Course in Project Cost Estimation in London 2024
Delivered Online On Demand14 days
£32

Microsoft Project 2007 for Beginners

4.3(43)

By John Academy

Description:  Microsoft Project 2007 is developed to help in creating budgets based on assignment work and resource rates. Through this course, you will learn the necessary skills, knowledge, and information about the Microsoft Project 2007 Essential and why Project is the world's premier spreadsheet software. You will learn how to use Project in analysing numbers, keeping track of data, and presenting your information graphically which will make your job easier. Who is the course for? Professionals who want to learn about the Microsoft Project 2007 People who have an interest in the basics and features of the Project 2007 Entry Requirement: This course is available to all learners, of all academic backgrounds. However, an education and experience in accounting is an advantage. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Microsoft Project 2007 for Beginners course would be beneficial for you to become: Project Director Project Manager Project Management Officer Project Assistant. Microsoft Project 2007 for Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing Project 01:00:00 Module Three - Your First Project 01:00:00 Module Four - Adding Tasks 01:00:00 Module Five - Advanced Task Operations 01:00:00 Module Six - Scheduling your Tasks 01:00:00 Module Seven - Adding Resources 01:00:00 Module Eight - Assigning Resources 01:00:00 Module Nine - Customizing Your Project View 01:00:00 Module Ten - Creating Project Reports 01:00:00 Module Eleven - Finishing Your Project 01:00:00 Module Twelve - Wrapping Up 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Project 2007 for Beginners
Delivered Online On Demand11 hours
£21

Forklift Training, Delivery Driver, Train Driver, HVG / LGV & Safety - 20 Courses Bundle

By NextGen Learning

Get ready for an exceptional online learning experience with the Forklift Training, Delivery Driver, Train Driver & Safety 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 Forklift Training, Delivery Driver, Train Driver & Safety is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. This Forklift Training 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 Forklift Training package has something for everyone. As part of the Forklift Training, Delivery Driver, Train Driver & Safety package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Forklift Training bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Forklift Training Bundle Comprises the Following CPD Accredited Courses: Forklift Training - Online Course Large Goods Vehicle (LGV) Transport Manager Port Management Diploma Airport Management Course Import/Export Trainee Train Driver Course Delivery Driver Training Delivery Manager Driver Safety Awareness Safeguarding for Taxi Drivers Operations and Warehouse Management with Transport Management Warehouse Safety Engine Lubrication Systems Online Course Power Tools and How to Use Them Manual Handling Training LOLER Training Health and Safety at Workplace Career Development Plan Fundamentals CV Writing and Job Searching 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 Forklift Training Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with Forklift Training. Build a strong knowledge base in your chosen course via Forklift Training. Benefit from the flexibility and convenience of online learning. With the Forklift Training package, validate your learning with a CPD certificate. Each course of this Forklift Training bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This Forklift Training 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 the Forklift Training, Delivery Driver, Train Driver & Safety, a rich anthology of 15 diverse courses. Each course in the Forklift Training bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. ThisForklift Training, Delivery Driver, Train Driver & Safety bundle will take you on a unique and enriching educational journey. The Forklift Training 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 Forklift Training, Delivery Driver, Train Driver & Safety bundle offers you the flexibility and convenience to learn at your own pace. Make the Forklift Training package your trusted companion in your lifelong learning journey. CPD 210 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Forklift Training, Delivery Driver, Train Driver & Safety 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 Forklift Training, Delivery Driver, Train Driver & Safety 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 Forklift Training bundle package. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

Forklift Training, Delivery Driver, Train Driver, HVG / LGV  & Safety - 20 Courses Bundle
Delivered Online On Demand4 days
£79

VMware Carbon Black EDR Advanced Administrator

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for System administrators and security operations personnel, including analysts and managers Overview By the end of the course, you should be able to meet the following objectives: Describe the components and capabilities of the Carbon Black EDR server Identify the architecture and data flows for Carbon Black EDR communication Identify the architecture for a cluster configuration and Carbon Black EDR cluster communication Describe the Carbon Black EDR server data types and data locations Use the API to interact with the Carbon Black EDR server without using the UI Create custom threat feeds for use in the Carbon Black EDR server Perform the integration with a syslog server Use different server-side scripts for troubleshooting Troubleshoot sensor-side configurations and communication This course teaches you how to use the advanced features of the VMware Carbon Black© EDR? product. This usage includes gaining access to the Linux server for management and troubleshooting in addition to configuring integrations and using the API. This course provides an in-depth, technical understanding of the Carbon Black EDR product through comprehensive coursework and hands-on scenario-based labs. This class focuses exclusively on advanced technical topics related to the technical back-end configuration and maintenance Course Introduction Introductions and course logistics Course objectives Architecture Data flows and channels Sizing considerations Communication channels and ports Server Datastores SOLR database Storage configurations and data aging Partition states Postgres Modulestore EDR API CBAPI overview Viewing API calls in the browser Utilizing the API to access data Threat Intelligence Feeds Feed structure Report indicator types Custom threat feed creation and addition Syslog Integration SIEM support Configuration Troubleshooting Server-side scripts Server logs Sensor operations Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware Carbon Black EDR Advanced Administrator 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 Carbon Black EDR Advanced Administrator 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 Carbon Black EDR Advanced Administrator
Delivered OnlineFlexible Dates
Price on Enquiry

Accounts Assistant Training - Sage 50, QuickBooks and Xero

4.8(9)

By Skill Up

CPDQS Accredited | 11-in-1 Premium Bundle | +Gifts: 5 Free PDF | Expert Tutor Support

Accounts Assistant Training - Sage 50, QuickBooks and Xero
Delivered Online On Demand3 days
£51

Entrepreneurship 101

By Compete High

Unlock Your Entrepreneurial Potential with Entrepreneurship 101! Are you ready to embark on an exhilarating journey into the world of entrepreneurship? 🌟 Welcome to Entrepreneurship 101, your gateway to unleashing your innovative spirit, building successful ventures, and shaping the future of business! What is Entrepreneurship 101? Entrepreneurship 101 is more than just a course; it's your roadmap to mastering the art and science of entrepreneurship. 🚀 Whether you're a budding entrepreneur with a groundbreaking idea or a seasoned professional looking to enhance your business acumen, this course provides you with the tools, strategies, and mindset needed to thrive in today's dynamic business landscape. Why Choose Entrepreneurship 101? 1. Learn from Industry Experts: Gain invaluable insights from seasoned entrepreneurs, industry leaders, and business experts who have navigated the highs and lows of entrepreneurship. 💡 Benefit from their firsthand experiences, success stories, and lessons learned along the way. 2. Practical Knowledge and Skills: Entrepreneurship 101 goes beyond theory, offering practical knowledge and hands-on skills that you can apply immediately to your entrepreneurial endeavors. From business planning and financial management to marketing strategies and customer acquisition, you'll acquire a comprehensive skill set essential for entrepreneurial success. 3. Foster Creativity and Innovation: Explore the power of creativity and innovation as catalysts for entrepreneurial growth and success. 💡 Discover how to identify opportunities, think outside the box, and transform innovative ideas into viable business ventures that disrupt industries and drive change. 4. Build a Robust Network: Connect with like-minded entrepreneurs, mentors, and industry professionals within our vibrant community. 🤝 Forge valuable relationships, collaborate on projects, and leverage your network for support, guidance, and potential partnerships. 5. Gain Confidence and Resilience: Develop the confidence and resilience needed to overcome challenges, adapt to change, and persevere in the face of adversity. 💪 Entrepreneurship 101 equips you with the mindset and mindset and resilience to navigate the unpredictable terrain of entrepreneurship with courage and determination. Who is this for? Entrepreneurship 101 is designed for aspiring entrepreneurs, business owners, professionals, students, and anyone with a passion for innovation and a desire to make a meaningful impact in the world of business. Whether you're launching a startup, expanding an existing venture, or exploring new opportunities, this course provides the guidance and support you need to turn your entrepreneurial dreams into reality. Career Path Upon completing Entrepreneurship 101, you'll be equipped with the knowledge, skills, and confidence to pursue various career paths and opportunities, including: Entrepreneurship: Launch your own startup, venture, or business venture and bring your innovative ideas to life. Business Management: Explore career opportunities in business management, leadership, and strategic planning across industries. Consulting: Offer consulting services to startups, small businesses, and organizations seeking expert guidance and advice. Venture Capital and Investment: Pursue opportunities in venture capital, angel investing, and startup funding as an investor or financial advisor. Social Entrepreneurship: Drive positive social change and impact through entrepreneurship by addressing pressing social, environmental, and economic challenges. Frequently Asked Questions (FAQ) Q: Is Entrepreneurship 101 suitable for beginners? A: Yes! Entrepreneurship 101 is designed to accommodate participants at all levels, from beginners with little to no prior experience in entrepreneurship to seasoned professionals looking to enhance their skills and knowledge. Q: What is the duration of the course? A: The duration of Entrepreneurship 101 may vary depending on the format and structure of the course. Typically, it ranges from several weeks to a few months, allowing participants to delve deep into the subject matter and engage in practical exercises and projects. Q: Can I access course materials online? A: Yes! Many versions of Entrepreneurship 101 offer online access to course materials, lectures, resources, and interactive discussions, allowing participants to learn at their own pace and convenience from anywhere in the world. Q: Will I receive a certificate upon completion? A: Yes! Participants who successfully complete Entrepreneurship 101 will receive a certificate of completion, acknowledging their commitment to advancing their entrepreneurial skills and knowledge. Q: How much does the course cost? A: The cost of Entrepreneurship 101 may vary depending on the institution, format, and additional features included in the course. Some institutions offer scholarships, discounts, or financial assistance programs to eligible participants. Q: What support is available during the course? A: Throughout Entrepreneurship 101, participants have access to dedicated instructors, mentors, and support staff who provide guidance, feedback, and assistance as needed. Additionally, participants can engage with peers, join discussion forums, and attend live Q&A sessions to enhance their learning experience. Unlock Your Entrepreneurial Potential Today! Are you ready to embark on a transformative journey into the exciting world of entrepreneurship? Join us for Entrepreneurship 101 and take the first step towards realizing your entrepreneurial dreams! Enroll now and let's embark on this exhilarating adventure together! 🚀 Course Curriculum Module 1 Entrepreneurship 101. Entrepreneurship 101. 00:00 Module 2 Business Planning and Product Development. Business Planning and Product Development. 00:00 Module 3 Business Development and Marketing Strategies. Business Development and Marketing Strategies. 00:00 Module 4 Customer Experience and Financial Management. Customer Experience and Financial Management. 00:00 Module 5 Operations Management and Compliance. Operations Management and Compliance. 00:00

Entrepreneurship 101
Delivered Online On Demand5 hours
£4.99

Dental Nurse - CPD Accredited Course

By Imperial Academy

Love conquers all things, except poverty and toothache

Dental Nurse - CPD Accredited Course
Delivered Online On Demand
£25

Professional Certificate Course in Project Financing Options in London 2024

4.9(261)

By Metropolitan School of Business & Management UK

This course is designed to provide a comprehensive understanding of finance and international sources of finance. The course will cover different sources of finance, including long-term, medium-term, short-term, and international sources. The course will also discuss the features of each source of finance and how they can be used effectively. This course provides a comprehensive understanding of finance and international sources of finance. The course covers different sources of finance, their features and effective use, financial analysis, forecasting, planning, and decision-making. The course also covers international sources of finance, their advantages, disadvantages, and risk assessment. After the successful completion of the course, you will be able to learn about the following; Understand the different sources of finance and their features Identify the appropriate sources of finance for different business needs Learn about international sources of finance and their implications for business Analyze financial statements and use financial ratios for decision-making Understand risk and return in finance and apply capital budgeting techniques Understand ethical issues in finance and the importance of corporate social responsibility Apply financial decision-making in real-life situations through case studies Understanding finance and international sources of finance is essential for individuals and organizations seeking to manage their financial resources effectively. This course is designed to provide participants with a comprehensive understanding of finance and international sources of finance. Participants will learn about the different sources of finance, including long-term, medium-term, short-term, and international sources. The course will cover the features of each source of finance and how they can be used effectively to meet the financial needs of organizations. The course will also discuss the role of finance in the decision-making process, including the importance of financial analysis, financial forecasting, and financial planning. Participants will learn how to use financial ratios and other tools to analyze financial data and make informed financial decisions. Moreover, the course will delve into international sources of finance, including foreign direct investment, export finance, and international capital markets. Participants will learn about the advantages and disadvantages of each international source of finance and how to assess the risks associated with them. By the end of this course, participants will have gained valuable knowledge and skills to become effective financial managers. They will have a comprehensive understanding of the different sources of finance, the ability to analyze financial data and make informed financial decisions, and the skills to assess the risks associated with international sources of finance. Participants will be equipped with the knowledge and skills needed to manage their financial resources effectively and make informed financial decisions to support the success of their organizations. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Project Financing Options - N Self-paced pre-recorded learning content on this topic. Project Financing Options Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor Project Managers Project Coordinators Project Analysts Business Analysts Team Leaders Department Managers Executives overseeing projects Consultants Engineers IT Professionals Marketing Managers Human Resources Managers Financial Analysts Operations Managers Supply Chain Managers Product Managers. Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Professional Certificate Course in Project Financing Options in London 2024
Delivered Online On Demand14 days
£39

Overview of MySql Masterclass The digital world has changed how businesses work in the UK, and database management is now a key part of every successful company. MySQL is one of the most popular tools for this job, used by over 40% of websites around the world. In the UK, big names like BBC, Sky, and many tech startups in London’s Silicon Roundabout rely on MySQL. The MySql Masterclass is designed to help people learn the skills needed to build a strong career in this growing field. Database experts in the UK earn an average salary of £45,000 each year, making it a smart career choice. The MySql Masterclass has 41 helpful modules that start with the basics and move up to more advanced topics. Students will learn how to create databases, write MySQL commands, use joins, and manage stored procedures. The course also teaches how to make systems run faster and safer with performance and security tools. Other important topics include handling JSON data, using full-text search, and working with replication. These are all things that modern companies look for in a database specialist. This MySql Masterclass is made for beginners and gives them the knowledge they need to handle real business databases. It helps students build strong skills in design, optimisation, and administration. The UK’s tech industry is worth £150 billion a year, and the MySql Masterclass helps learners get ready for job opportunities in many areas like retail, health, and finance. Learning Outcomes By the end of the MySql Masterclass, learners will be able to: Build and manage MySQL databases from the ground up Use SELECT, INSERT, UPDATE, and DELETE commands with confidence Work with advanced joins, unions, and stored procedures Design and use indexes, views, and full-text search for better performance Set up MySQL replication, backups, and basic system administration Handle JSON data and manage time zone settings within databases Who is this course for? Aspiring Database Administrators who want full MySQL training to manage databases, user access, and backups in organisations needing strong data systems. Software Developers who want to improve their backend development by learning MySQL queries, stored procedures, and database performance skills. Data Analysts who need advanced SQL to pull useful data from complex tables using joins, group functions, and reporting tools. IT Professionals looking to build database knowledge, including how to configure, tune, and fix issues in MySQL systems. Career Changers with little or no tech background who want to start in database roles, learning from the basics to advanced MySQL tasks. Process of Evaluation After studying the MySql Masterclass Course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the MySql Masterclass Course, you can order your CPD Accredited Digital / PDF Certificate for £5.99. (Each) Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. (Each) Shipping Charges: Inside the UK: £3.99 International: £10.99 Requirements You don’t need any educational qualification or experience to enrol in the MySql Masterclass course. Career Path Completing this MySql Masterclass course could lead to rewarding jobs like: Database Administrator – £35K to £65K per year MySQL Developer – £30K to £55K per year Data Analyst – £25K to £45K per year Backend Developer – £35K to £60K per year Database Consultant – £40K to £70K per year Course Curriculum: MySql Masterclass Module 1: Introduction on MySQL 01:00:00 Module 2: Data Types 00:51:00 Module 3: SELECT Statements 00:59:00 Module 4: Backticks 00:15:00 Module 5: NULL 00:18:00 Module 6: Limit and Offset 00:13:00 Module 7: Creating databases 00:18:00 Module 8: Using Variables 00:25:00 Module 9: Comment MySQL 00:14:00 Module 10: INSERT Statements 00:29:00 Module 11: DELETE Statements 00:21:00 Module 12: UPDATE Statements 00:20:00 Module 13: ORDER BY Clause 00:08:00 Module 14: Group By 00:18:00 Module 15: Errors in MySQL 00:10:00 Module 16: Joins 00:37:00 Module 17: Joins continued 00:11:00 Module 18: UNION 00:18:00 Module 19: Arithmetic 00:20:00 Module 20: String operations 00:33:00 Module 21: Date and Time Operations 00:08:00 Module 22: Handling Time Zones 00:07:00 Module 23: Regular Expressions 00:19:00 Module 24: VIEWS 00:20:00 Module 25: Table Creation 00:23:00 Module 26: ALTER TABLE 00:23:00 Module 27: Drop Table 00:05:00 Module 28: MySQL LOCK TABLE 00:10:00 Module 29: Error codes 00:08:00 Module 30: Stored routines (procedures and functions) 00:29:00 Module 31: Indexes and Keys 00:24:00 Module 32: Full-Text search 00:18:00 Module 33: PREPARE Statements 00:09:00 Module 34: JSON 00:11:00 Module 35: Extract values from JSON type 00:05:00 Module 36: MySQL Admin 00:08:00 Module 37: TRIGGERS 00:12:00 Module 38: Configuration and tuning 00:07:00 Module 39: Events 00:08:00 Module 40: ENUM 00:09:00 Module 41: Collations, Transactions, Log files, Replication, Backup 00:41:00

MySql Masterclass
Delivered Online On Demand13 hours 22 minutes
£11.99

Cloudera Data Analyst Training - Using Pig, Hive, and Impala with Hadoop

By Nexus Human

Duration 4 Days 24 CPD hours This course is intended for This course is designed for data analysts, business intelligence specialists, developers, system architects, and database administrators. Overview Skills gained in this training include:The features that Pig, Hive, and Impala offer for data acquisition, storage, and analysisThe fundamentals of Apache Hadoop and data ETL (extract, transform, load), ingestion, and processing with HadoopHow Pig, Hive, and Impala improve productivity for typical analysis tasksJoining diverse datasets to gain valuable business insightPerforming real-time, complex queries on datasets Cloudera University?s four-day data analyst training course focusing on Apache Pig and Hive and Cloudera Impala will teach you to apply traditional data analytics and business intelligence skills to big data. Hadoop Fundamentals The Motivation for Hadoop Hadoop Overview Data Storage: HDFS Distributed Data Processing: YARN, MapReduce, and Spark Data Processing and Analysis: Pig, Hive, and Impala Data Integration: Sqoop Other Hadoop Data Tools Exercise Scenarios Explanation Introduction to Pig What Is Pig? Pig?s Features Pig Use Cases Interacting with Pig Basic Data Analysis with Pig Pig Latin Syntax Loading Data Simple Data Types Field Definitions Data Output Viewing the Schema Filtering and Sorting Data Commonly-Used Functions Processing Complex Data with Pig Storage Formats Complex/Nested Data Types Grouping Built-In Functions for Complex Data Iterating Grouped Data Multi-Dataset Operations with Pig Techniques for Combining Data Sets Joining Data Sets in Pig Set Operations Splitting Data Sets Pig Troubleshoot & Optimization Troubleshooting Pig Logging Using Hadoop?s Web UI Data Sampling and Debugging Performance Overview Understanding the Execution Plan Tips for Improving the Performance of Your Pig Jobs Introduction to Hive & Impala What Is Hive? What Is Impala? Schema and Data Storage Comparing Hive to Traditional Databases Hive Use Cases Querying with Hive & Impala Databases and Tables Basic Hive and Impala Query Language Syntax Data Types Differences Between Hive and Impala Query Syntax Using Hue to Execute Queries Using the Impala Shell Data Management Data Storage Creating Databases and Tables Loading Data Altering Databases and Tables Simplifying Queries with Views Storing Query Results Data Storage & Performance Partitioning Tables Choosing a File Format Managing Metadata Controlling Access to Data Relational Data Analysis with Hive & Impala Joining Datasets Common Built-In Functions Aggregation and Windowing Working with Impala How Impala Executes Queries Extending Impala with User-Defined Functions Improving Impala Performance Analyzing Text and Complex Data with Hive Complex Values in Hive Using Regular Expressions in Hive Sentiment Analysis and N-Grams Conclusion Hive Optimization Understanding Query Performance Controlling Job Execution Plan Bucketing Indexing Data Extending Hive SerDes Data Transformation with Custom Scripts User-Defined Functions Parameterized Queries Choosing the Best Tool for the Job Comparing MapReduce, Pig, Hive, Impala, and Relational Databases Which to Choose?

Cloudera Data Analyst Training - Using Pig, Hive, and Impala with Hadoop
Delivered OnlineFlexible Dates
Price on Enquiry