241 Debugging courses

This course comes bundled with basic to advanced level knowledge on Spring and Spring Boot with 200+ questions and answers. With REST API, JPA, Hibernate, and Spring Data JPA, you have the upper hand in your interviews for sure.

Description Nowadays, SQL Developers are in-demand and becoming a SQL developer can be a rewarding and fulfilling profession. This SQL Developer 2014 Beginner is intended for absolute beginners that concentrate on giving the appropriate knowledge of Microsoft SQL Server and help to acquire the skills and abilities to become an SQL Server developer as well as offer many job opportunities in the competitive job market. In this course, you will learn how to create databases, tables, design databases and tables. You will also learn to create flat file database, confidently use SSMS Tool as well as write basic T-SQL Queries. In addition to that, learn to create constraints and views in the most dynamic way possible. Enrol right now and start exploring SQL, the most popular relational database management system. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After 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. 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 recognized 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 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: 01 Introduction FREE 00:16:00 Tools for Creating Views 00:11:00 Examples 00:21:00 Updating Data Using a View 00:13:00 Columns and Indexed Views 00:18:00 Module: 02 Introduction Stored Procedures 00:18:00 Creating Stored Procedures 00:19:00 Returning Data 00:14:00 Module: 03 Testing and Debugging 00:17:00 Execute with Result Sets 00:11:00 Creating Triggers 00:26:00 Module: 04 Overview and Scalar Functions 00:20:00 Inline Table Valued Functions 00:11:00 Multi Statement 00:16:00 Views and Stored Procedures 00:18:00 Module: 05 Transaction Concepts 00:30:00 Applications and Transactions 00:13:00 Creating Explicit Transactions 00:29:00 Structured Error Handling 00:25:00 Module: 06 Introduction to SQL CLR 00:08:00 Writing SQL CLR Code 00:24:00 Using SQL CLR Code 00:22:00 SQL CLR Code 00:13:00 SQL CLR Security 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview This comprehensive course on ChatGPT Masterclass: A Complete ChatGPT Zero to Hero  will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This ChatGPT Masterclass: A Complete ChatGPT Zero to Hero 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 ChatGPT Masterclass: A Complete ChatGPT Zero to Hero. It is available to all students, of all academic backgrounds. Requirements Our ChatGPT Masterclass: A Complete ChatGPT Zero to Hero 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 9 sections • 38 lectures • 02:45:00 total length •Introduction: 00:04:00 •Start on Windows, macOS, and Linux: 00:01:00 •How to ask great questions: 00:02:00 •FAQs: 00:01:00 •What is ChatGPT: 00:05:00 •Create a ChatGPT account@: 00:06:00 •How to use ChatGPT: 00:10:00 •ChatGPT for day-to-day activities: 00:04:00 •Advanced ChatGPT Plus: 00:05:00 •ChatGPT for programmers: 00:12:00 •Improve Problem-solving skills: 00:06:00 •Create an Algorithms: 00:06:00 •How to build a website with ChatGPT: 00:05:00 •Develop a Stunning Landing page for product sales: 00:07:00 •Create a Documentation: 00:03:00 •Code Debugging with ChatGPT: 00:05:00 •The Best Businesses Ideas to start with ChatGPT: 00:05:00 •SEO Basics for your website: 00:06:00 •How to make an online course using ChatGPT: 00:05:00 •Selling Competitive products with ChatGPT: 00:04:00 •Exercise on real-world sales query: 00:01:00 •Solution for an exercise: 00:02:00 •ChatGPT to Prepare Resume: 00:03:00 •Interview preparation with ChatGPT: 00:05:00 •ChatGPT for PowerPoint content: 00:03:00 •Innovative Job Searching using ChatGPT: 00:04:00 •Write a short film with ChatGPT for Creative Fiction and Screenplays: 00:03:00 •Make the best diet plan for a day: 00:03:00 •Suggest a meal plan with seafood as the special ingredient: 00:03:00 •Write a Business Email for the franchise: 00:03:00 •Create Legal documents like sale deeds etc.: 00:03:00 •Sum with ChatGPT: 00:05:00 •VLOOKUP with ChatGPT: 00:05:00 •Introduction to Dall-E 2: 00:04:00 •Dall-E 2 Creating 3D Graphic design: 00:03:00 •Dall-E 2 Deep Dive in Editing your own image: 00:04:00 •How to Make Money with Dall-E 2: 00:03:00 •Integrating ChatGPT with Google Search: 00:06:00

Explore offline-first app development with Angular, Ionic, PouchDB, and CouchDB. Sync data effortlessly, design for web and mobile, and deploy with ease for a seamless user experience. Learn data synchronization, advanced features such as RxJS and custom pipes, implement state machines with XState, and build scalable, multi-platform web apps.

Overview The global AI market is projected to reach $190.61 billion by 2025. This Beginner Crash Course on ChatGPT course is designed to equip you with the essential skills and knowledge needed to thrive in this dynamic landscape. This Beginner Crash Course on ChatGPT is your gateway to a world where human-computer interaction is evolving at an unprecedented pace. This course offers a comprehensive exploration of ChatGPT, covering many practical applications. With a curriculum meticulously designed for beginners, you'll gain a deeper understanding of utilising ChatGPT for tasks such as language translation, code generation, content creation, marketing research, and much more.  Grab this opportunity to unlock your potential and stay ahead in AI. Enrol in the Beginner Crash Course on ChatGPT today! 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 Beginner Crash Course on ChatGPT. It is available to all students, of all academic backgrounds. Requirements Our Beginner Crash Course on ChatGPT 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 7 sections • 36 lectures • 03:09:00 total length •Sign up for an OpenAI Account: 00:01:00 •Using ChatGPT for language translation: 00:04:00 •Using ChatGPT for Asking Questions: 00:03:00 •Code generation and code debugging with ChatGPT: 00:02:00 •Creating social media posts with ChatGPT: 00:08:00 •Blogging Articles and Editing: 00:04:00 •Using ChatGPT for Letters and Resumes: 00:05:00 •Generating Business Ideas: 00:05:00 •Do marketing Research: 00:16:00 •Generate Marketing Ideas: 00:04:00 •Provide an agreement for writing service: 00:02:00 •ChatGPT for Teaching (Accounting): 00:03:00 •Solve a Math Question: 00:01:00 •Create Short Story: 00:04:00 •Role Play: 00:02:00 •Write article: 00:07:00 •Write a speech: 00:09:00 •Write a Conversation: 00:02:00 •Suggest Research Ideas and Topics: 00:03:00 •Find creative titles for your article: 00:04:00 •Create an outline or structure for your paper: 00:02:00 •Summarization of Paper: 00:22:00 •Keyword Extraction: 00:02:00 •Plagiarism detection? (actually, not): 00:03:00 •Limitations of ChatGPT part - 01: 00:02:00 •Limitations of ChatGPT part - 02: 00:05:00 •Will ChatGPT generate junk information to flood internet: 00:06:00 •Limitations of ChatGPT-Map function not included: 00:03:00 •List Outline for your book: 00:01:00 •My first Chat with ChatGPT, I love it!: 00:22:00 •Shorten or Summarize an article: 00:01:00 •Suggest a title for your Online publishing: 00:12:00 •Use ChatGPT as a dictionary: 00:07:00 •Using ChatGPT as Your Personal Secretary: 00:06:00 •Using ChatGPT for Buzz Word Explanation: 00:03:00 •Using ChatGPT for Word Definition: 00:03:00

Duration 4 Days 24 CPD hours This course is intended for Security-operations (SecOps), or security, orchestration, automation, and response (SOAR) engineers, managed security service providers (MSSPs), service delivery partners, system integrators, and professional services engineers Overview This training is designed to enable a SOC, CERT, CSIRT, or SOAR engineer to start working with Cortex XSOAR integrations, playbooks, incident-page layouts, and other system features to facilitate resource orchestration, process automation, case management, and analyst workflow. The course includes coverage of a complete playbook-development process for automating a typical analyst workflow to address phishing incidents. This end-to-end view of the development process provides a framework for more focused discussions of individual topics that are covered in the course. The Cortex? XSOAR 6.8: Automation and Orchestration (EDU-380) course is four days of instructor-led training that will help you: Configure integrations, create tasks, and develop playbooks Build incident layouts that enable analysts to triage and investigate incidents efficiently Identify how to categorize event information and map that information to display fields Develop automations, manage content, indicator data, and artifact stores, schedule jobs, organize users and user roles, oversee case management, and foster collaboration This class is powered by Cloud Harmonics. Course Outline Module 1 - Core Functionality and Feature Sets Module 2 - Enabling and Configuring Integrations Module 3 - Playbook Development Module 4 - Classification and Mapping Module 5 - Layout Builder Module 6 - Solution Architecture Module 7 - Docker Module 8 - Automation Development and Debugging Module 9 - The Marketplace and Content Management Module 10 - Indicators and Threat Intelligence Management Module 11 - Jobs and Job Scheduling Module 12 - Users and Role-Based Access Controls (RBAC) Module 13 - Integration Development Additional course details: Nexus Humans Palo Alto Networks: Cortex XSOAR 6.8: Automation and Orchestration(EDU-380) 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 Palo Alto Networks: Cortex XSOAR 6.8: Automation and Orchestration(EDU-380) 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.

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before The construction industry in the United Kingdom is a vital sector, contributing significantly to the nation's economy and infrastructure development. According to the Office for National Statistics, the construction industry accounts for approximately 6% of the UK's total economic output. However, the industry faces challenges such as skilled labor shortages, stringent regulations, and the need for sustainable and innovative design solutions. Are you ready to pursue a career path that combines technical expertise, creative design, and a deep understanding of the construction industry's complexities? This comprehensive bundle offers a complete education in Computer-Aided Design (CAD) training, equipping you with the knowledge and skills necessary to excel in the construction, architectural, and design industries. You will gain advanced proficiency in CAD software, including AutoCAD and its programming capabilities, enabling you to create precise and detailed designs for various projects. Additionally, you will explore building design and construction requirements, construction industry schemes, interior design principles, architectural studies, and LEED certification for sustainable building practices. Our Bundle contains 11 of our premium courses for one discounted price: Course 01: Diploma in CAD Designer Course 02: Minimum Requirements of Building Design and Construction Course 03: AutoCAD VBA Programming - Beginner Course Course 04: LEED V4 - Building Design and Construction Course 05: Construction Industry Scheme (CIS) Course 06: Interior Design Professional Diploma Course 07: Architectural Studies Course 08: Rendering AutoCAD Drawings in Photoshop Course 09: Professional Interior Design & Construction Course 10: LOLER Training Course 11: Workplace Health and Safety This comprehensive training empowers you to launch a fulfilling career in construction or interior design. Take the first step towards your design goals. Enrol today! Learning Outcomes of CAD Training Master foundational design principles for building and construction. Confidently utilize AutoCAD software for creating technical drawings. Apply sustainable design practices with LEED certification knowledge. Demonstrate expertise in interior design concepts and software. Ensure workplace safety by adhering to health and safety regulations. Obtain industry-recognized certifications to enhance your employability. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of CAD Training Get a free student ID card with CAD Training program (£10 postal charge will be applicable for international delivery) The CAD Training is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the CAD Training course materials The CAD Training comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Diploma in CAD Designer Module 01: Introduction to CAD Design Module 02: CAD Designer Career in the United Kingdom Module 03: Basics for CAD Design - Part 1 Module 04: Basics for CAD Design - Part 2 Module 05: 2D Shape in CAD Module 06: 3D Shape in CAD Module 07: Geometry and Modelling Module 08: Assemblies in CAD Design Module 09: Extrusion and Rotations Module 10: Blending Operations in CAD Module 11: Grids and Regular Polygons Module 12: Parameters in Civil Drawings Module 13: Introduction to AutoCAD Module 14: Introduction to T-Flex CAD Module 15: Introduction to SolidWorks Module 16: Introduction to FreeCAD Course 02: Minimum Requirements of Building Design and Construction Unit 01: Introduction Unit 02: Integrative Process Unit 03: Location & Transportation Unit 04: Sustainable Sites Unit 05: Water Efficiency Unit 06: Energy & Atmosphere Unit 07: Materials & Resources Unit 08: Indoor Environment Quality Unit 09: Innovation Unit 10: Regional Priority Unit 11: Completion Course 03: AutoCAD VBA Programming - Beginner Course Unit 01: Introduction Unit 02: VBA Integrated Development Environment (IDE) Unit 03: Understanding AutoCAD Object Model In VBA Unit 04: Using Variables In VBA Unit 05: User Forms And Controls Unit 06: Conditionals And Decisions In VBA Unit 07: Looping And Iterations In VBA Unit 08: Drawings Objects In VBA Unit 09: Code Debugging In VBA Unit 10: Error Handling In VBA Unit 11: Conclusion =========>>>>> And 8 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) CPD Hard Copy Certificate: £29.99 CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Individuals interested in pursuing a career in CAD design Students studying engineering, architecture, or related fields Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. CAD Technician Architectural Technologist Building Surveyor Interior Designer Project Manager Design Consultant Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29.99 Please note that International students have to pay an additional £10 as a shipment fee. Advanced Diploma in CAD Designer Training at QLS Level 7 Hard copy certificate - £129 Please note that International students have to pay an additional £10 as a shipment fee.

This Microsoft Office 2016 Excel VBA is designed to introduce you to VBA in as non-threatening a manner as possible. Beginning with wizards and macros, you will get through the methods and syntax of simple programming in VB, culminating in writing custom code, customizing Excel elements and debugging. In this course you will learn automation, styles, version tracking and mail merge, macros, customizing and tailor Word to suit your workflow, and more. You will gain confidence in using the more esoteric features of Word to create efficient long documents. Course Highlights Microsoft Office 2016 Excel VBA is an award-winning and the best selling course that has been given the CPD Qualification Standards & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Microsoft Office 2016 Excel VBA into 19 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours, 30 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Microsoft Office 2016 Excel VBA Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Microsoft Office 2016 Excel VBA is CPD Qualification Standards and IAO accredited. 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 backgrounds. Requirements Our Microsoft Office 2016 Excel VBA 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD Qualification Standards and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Developing Macros Create a Macro Using the Macro Recorder FREE 01:00:00 Edit a Macro FREE 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 Formatting Worksheets Using Macros 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 Creating an Interactive Worksheet Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Working with Multiple Worksheets 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 Performing Calculations Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Office 2016 Excel VBA 00:00:00 Mock Exam Final Exam

Duration 1 Days 6 CPD hours This course is intended for Individuals planning to deploy applications and create application environments on Google Cloud. Developers, systems operations professionals, and solution architects getting started with Google Cloud. Executives and business decision makers evaluating the potential of Google Cloud to address their business needs. Overview Identify the purpose and value of Google Cloud products and services. Interact with Google Cloud services. Describe ways in which customers have used Google Cloud. Choose among and use application deployment environments on Google Cloud: App Engine, Google Kubernetes Engine, and Compute Engine. Choose among and use Google Cloud storage options: Cloud Storage, Cloud SQL, Cloud Bigtable, and Firestore. Make basic use of BigQuery, Google's managed data warehouse for analytics. This course uses lectures, demos, and hands-on labs to give you an overview of Google Cloud products and services so that you can learn the value of Google Cloud and how to incorporate cloud-based solutions into your business strategies. Introducing Google Cloud Platform Explain the advantages of Google Cloud Platform. Define the components of Google's network infrastructure, including: Points of presence, data centers, regions, and zones. Understand the difference between Infrastructure-as-a-Service (IaaS) and Platform-as-a-Service (PaaS). Getting Started with Google Cloud Platform Identify the purpose of projects on Google Cloud Platform. Understand the purpose of and use cases for Identity and Access Management. List the methods of interacting with Google Cloud Platform. Lab: Getting Started with Google Cloud Platform. Google Compute Engine and Networking Identify the purpose of and use cases for Google Compute Engine. Understand the basics of networking in Google Cloud Platform. Lab: Deploying Applications Using Google Compute Engine. Google Cloud Platform Storage Options Understand the purpose of and use cases for: Google Cloud Storage, Google Cloud SQL, and Google Cloud Bigtable. Learn how to choose between the various storage options on Google Cloud Platform. Lab: Integrating Applications with Google Cloud Storage. Google Container Engine Define the concept of a container and identify uses for containers. Identify the purpose of and use cases for Google Container Engine and Kubernetes. Introduction to Hybrid and Multi-Cloud computing (Anthos). Lab: Deploying Applications Using Google Container Engine. Google App Engine and Google Cloud Datastore Understand the purpose of and use cases for Google App Engine and Google Cloud Datastore. Contrast the App Engine Standard environment with the App Engine Flexible environment. Understand the purpose of and use cases for Google Cloud Endpoints. Lab: Deploying Applications Using App Engine and Cloud Datastore. Deployment and Monitoring Understand the purpose of template-based creation and management of resources. Understand the purpose of integrated monitoring, alerting, and debugging. Lab: Getting Started with Stackdriver and Deployment Manager. Big Data and Machine Learning Understand the purpose of and use cases for the products and services in the Google Cloud big data and machine learning platforms. Lab: Getting Started with BigQuery. Summary and Review Summary and Review. What's Next?.

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?