35824 Design courses in Whickham delivered Online

Overview Horticulture is a combination of practices such as gardening, landscaping, plant propagation etc. Therefore, those who are working in the farming industry or wish to do so in the future, learning horticulture will be highly beneficial. Dive deep into the world of horticulture with our Horticulture Training course.  In this course, you will learn the ins and outs of this farming process. The course will first introduce you to the structure and functions of horticulture plants. Then, you will learn about plant propagation, nutrition, the impact of different elements on plants and much more. The course will also include lessons on harvesting, pruning, landscaping, weed control etc. So, if you wish to learn the essentials of horticulture in one place, join our course today! Course Preview Learning Outcomes Introduce yourself to the concepts of horticulture Learn about the structure and function of horticulture Understand how light, soil and water impact the plants Enhance your knowledge of plant nutrition Grasp the process of harvesting and pruning Learn about plant pathology, entomology and weed control Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Plant propagation Harvesting Permaculture Arboriculture Who Should Take This Horticulture Training? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Horticulture Training is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Horticulture Training Certification After completing and passing the Horticulture Training course successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path​ This exclusive Horticulture Training course will equip you with effective skills and abilities and help you explore career paths such as  Farmers Gardeners Landscapers Module 01: Introduction To Horticulture Introduction to Horticulture 00:31:00 Module 02: Structure And Function Of Horticulture Plants Structure and Function of Horticulture Plants 00:43:00 Module 03: Growth Of Horticulture Plants Growth of Horticulture Plants 00:33:00 Module 04: Impact Of Temperature Impact of Temperature 00:34:00 Module 05: Impact Of Light Impact of Light 00:38:00 Module 06: Impact Of Soil And Water Impact of Soil and Water 00:36:00 Module 07: Plant Propagation Plant Propagation 00:32:00 Module 08: Plant Nutrition Plant Nutrition 00:36:00 Module 09: Harvesting, Training And Pruning Harvesting, Training and Pruning 00:42:00 Module 10: Growing Plant Indoors Growing Plant Indoors 00:39:00 Module 11: Ornamental Horticulture And Garden Design Ornamental Horticulture and Garden Design 00:43:00 Module 12: Cut Floral Design And Landscaping Cut Floral Design and Landscaping 00:30:00 Module 13: Plant Pathology, Entomology And Weed Control Plant Pathology, Entomology and Weed Control 00:25:00 Module 14: Permaculture And Arboriculture Permaculture and Arboriculture 00:36:00 Module 15: Professional Opportunities In Horticulture Professional Opportunities in Horticulture 00:37:00 Module 16: Biotechnology Applications In Horticulture Biotechnology Applications in Horticulture 00:52:00 Assignment Assignment - Horticulture 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

GDPR Practitioner

Duration 1 Days 6 CPD hours This course is intended for Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases. Overview Upon successful completion of this course, students will be able to: - connect to the SQL Server database and execute a simple query. - include a search condition in a simple query. - use various functions to perform calculations on data. - organize data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, and generate a report. In this course, students will compose SQL queries to retrieve desired information from a database. 1 - Executing a Simple Query Connect to the SQL Database Query a Database Save a Query Modify a Query Execute a Saved Query 2 - Performing a Conditional Search Search Using a Simple Condition Compare Column Values Search Using Multiple Conditions Search for a Range of Values and Null Values Retrieve Data Based on Patterns 3 - Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values 4 - Organizing Data Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators 5 - Retrieving Data from Tables Combine Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Check for Unmatched Records Retrieve Information from a Single Table Using Joins 6 - Presenting Query Results Save the Query Result Generate an XML Report

Get Free Certificates (PDF + Hard Copy) +Transcript + Student ID as a Gift. Enrol Mechatronics & Mechanical Engineering Today!! Mechanical engineers are known for building the world we live in. From creating the world's smallest nanotechnology to building immense structures like cars, societies, space stations, etc., Mechanical Engineering professionals have the ultimate power to give a required shape to any structure or machine kept in front of them. A career in mechanical engineering is lucrative as it offers high salaries and innovation at every step. If you are dedicatedly passionate about Physics and Mathematics, you should choose Mechanical Engineering as a career option. Furthermore, to help you showcase your expertise in Mechatronics & Mechanical Engineering, we have prepared a special gift of One Hardcopy and One PDF Certificate for the Car Mechanic and Repair Training course completely free of cost. This Mechatronics & Mechanical Engineering Bundle Consists of the following Premium courses: Course 01: Mechanical Engineering Course 02: Car Mechanic and Repair Training Course 03: Motorbike Repairing and Maintenance Diploma Course 04: Large Goods Vehicle (LGV) Course 05: Basic Automotive Engineering: Onboard Diagnostics Course 06: Engine Lubricant System Training - Level 4 Course 07: Supercharger Automobile Engineering Course 08: Hybrid Vehicle Expert Training Course 09: Digital Electric Circuits & Intelligent Electrical Devices Course 10: Electrical Engineering DC Circuit Analysis Course 11: Energy Saving in Electric Motors Course 12: Car Restoration Course 13: PUWER Course 14: Electrical and Fire Safety Training - Level 2 Key features of this Mechatronics & Mechanical Engineering course: This Mechatronics & Mechanical Engineering bundle is CPD QS Accredited Learn from anywhere in the world Entirely online Lifetime access So, enrol Mechatronics & Mechanical Engineering now to advance your career! Mechatronics & Mechanical Engineering The Mechatronics & Mechanical Engineering bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Mechatronics & Mechanical Engineering Training expertise and essential knowledge, which will assist you in reaching your goal. Ccurriculum of the Mechatronics & Mechanical Engineering Bundle Course 01: Mechanical Engineering Module 01: Introduction Module 02: Engineering Mechanics - I Module 03: Engineering Mechanics - II Module 04: Heat and Thermodynamics Module 05: Work, Force and Energy Module 06: Fluid Mechanics Module 07: Structural Mechanics Module 08: Machines - I Module 09: Machines - II Module 10: Machine Dynamics Module 11: Mechanical Design Module 12: Hydraulic Machines Module 13: Strain Hardening Processes Module 14: Application of Solidification Module 15: Welding Module 16: Engineering Drawing ---------- 10 more courses--------- How will I get my Mechatronics & Mechanical Engineering Certificates? After successfully completing the Mechanical Engineering course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) So, enrol Mechatronics & Mechanical Engineering now to advance your career! CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Mechatronics & Mechanical Engineering. Requirements Our Mechatronics & Mechanical Engineering course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Mechatronics & Mechanical Engineering Upon completion of Mechanical Engineering course, various career opportunities include: Graduate Mechanical Engineer: £24,000 - £30,000 Mechanical Design Engineer: £32,000 - £45,000 Mechanical Systems Engineer: £38,000 - £55,000 Senior Mechanical Engineer: £45,000 - £65,000 So, enrol Mechatronics & Mechanical Engineering now to advance your career! Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (Car Mechanic and Repair Training) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Car Mechanic and Repair Training) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Duration 3 Days 18 CPD hours This course is intended for The ideal audience for this course includes database enthusiasts, IT professionals, and developers who are eager to expand their knowledge and skill set in database management and optimization. Roles that would greatly benefit from attending this course include: Database Developers: Those who design, implement, and maintain databases as part of their primary responsibilities and want to improve their expertise in schema design, query optimization, and advanced database features. Backend Developers: Professionals who work on server-side application logic and require a strong understanding of database management to integrate data storage and retrieval processes into their applications. Overview Upon completing this course, database developers will be able to: Design and implement efficient database schemas by employing normalization techniques, appropriate indexing strategies, and partitioning methods to optimize data storage and retrieval processes. Develop advanced SQL queries, including joining multiple tables, utilizing subqueries, and aggregating data, to extract valuable insights and facilitate decision-making processes. Implement stored procedures, functions, and triggers to automate common database tasks, enforce data integrity, and improve overall application performance. Apply database performance tuning techniques, such as query optimization, index management, and transaction control, to ensure optimal resource usage and enhanced system responsiveness. Integrate databases with various programming languages and platforms, enabling seamless data access and manipulation for web, mobile, and desktop applications. PostgreSQL is a powerful, open-source object-relational database management system that emphasizes extensibility, data integrity, and high performance. Its versatility and robust feature set make it an ideal choice for developers working on projects of all sizes, from small-scale applications to enterprise-level systems. By learning PostgreSQL, developers can tap into its advanced capabilities, such as full-text search, spatial data support, and customizable data types, allowing them to create efficient and scalable solutions tailored to their unique needs. PostgreSQL for Database Developers is a three-day hands-on course that explores the fundamentals of database management, covering everything from installation and management to advanced SQL functions. Designed for beginners and enthusiasts alike, this course will equip you with the knowledge and skills required to effectively harness the power of PostgreSQL in today's data-driven landscape. Throughout the course you?ll be immersed in a variety of essential topics, such as understanding data types, creating and managing indexes, working with array values, and optimizing queries for improved performance. You?ll gain valuable hands-on experience with real-world exercises, including the use of the psql client, writing triggers and stored procedures with PL/pgSQL, and exploring advanced SQL functions like Common Table Expressions (CTE), Window Functions, and Recursive Queries. You?ll exit this course with a solid foundation in PostgreSQL, enabling you to confidently navigate and manage your databases with ease and efficiency. Installing & Managing PostgreSQL PostgreSQL installation process Optimal configuration settings User and role management Database backup and restoration Overview of PostgreSQL Database PostgreSQL architecture overview Understanding database objects Efficient data storage Transaction management basics Using the psql client Introduction to psql Essential psql commands Executing queries effectively Managing databases with psql Understanding PostgreSQL data types Numeric data types explored Character and binary types Date, time, and boolean values Array and other types Understanding sequences Sequence creation and usage Customizing sequence behavior Implementing auto-increment columns Sequence manipulation and control Creating & managing indexes PostgreSQL index fundamentals Designing partial indexes Utilizing expression-based indexes Index management techniques Using COPY to load data COPY command overview Importing and exporting data Handling CSV and binary formats Performance considerations Working with Array Values Array value basics Array manipulation functions Querying arrays efficiently Multidimensional array handling Advanced SQL Functions Mastering Common Table Expressions Utilizing Window Functions Regular Expressions in SQL Crafting Recursive Queries Writing triggers & stored procedures with PL/pgSQL PL/pgSQL variables usage Implementing loop operations PERFORM and EXECUTE statements Developing PostgreSQL triggers Using the PostgreSQL query optimizer Query analysis and optimization EXPLAIN command insights PostgreSQL query operators Identifying performance bottlenecks Improving query performance Query performance tuning Index optimization strategies Efficient database partitioning Connection and resource management Wrap Up & Additional Resources Further learning opportunities Staying up-to-date with PostgreSQL Community engagement and support Additional course details: Nexus Humans PostgreSQL for Database Developers (TTDB7024) 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 PostgreSQL for Database Developers (TTDB7024) 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.

The importance of building services to the success of an organisation has never been greater and continues to grow. Developers and occupiers are becoming more aware of the contribution that building services make to the well being of occupants and hence their perception of the quality of the working environment. Those involved with the design, construction, maintenance and operation will increasingly be required to deliver building services that demonstrable contribution to the occupier's business. Energy efficiency, carbon management and occupant satisfaction depend substantially on the way building services are designed, managed and operated. To optimise these aspects, an informed strategic approach is essential. Tried and tested techniques and processes are available that, when applied holistically, will deliver substantial benefits. This course reviews best practice in the area and inspires participants to ensure that building services perform at their optimal level. To provide a better understanding of how building services can be designed, managed and operated to: Maximise occupant comfort, satisfaction and wellbeing Add value and contribute to the success of the business of the occupier Improve health safety Reduce operating cost, energy use, carbon emissions and environmental impact Optimise cost and value Provide strategies for continuous improvement and sustainable operation 1 Building services fundamentals The function of services in commercial buildings and their importance to the core business 2 Techniques and processes for optimising cost and value Programmed operation evaluation Continuous commissioning Lifetime product management Performance-based service Energy efficiency and the scope for environmental improvement 3 Making the business case and preparing the strategy Motivating decision-makers Empowering those who have to deliver the results Managing business risk 4 Strategy implementation and monitoring results Ensuring that rich and robust feedback is available to support continuous improvement and strategy enhancementWhen to get feedbackWhyHowWhat to do with it 5 Case histories and 'air time' Sharing experience and addressing specific issues of interest to participants Course review Close

Course Overview Gain the skills to create low poly mobile games, explore the fundamentals of 3D art, and learn how to model complex shapes, and more in this Maya masterclass. The Maya: UV Mapping 3D Knife course will teach you step-by-step how to create a 3D weapon model using Maya, from basic primitives. Through instructor-guided video tutorials, you will learn tips and best practices for using Maya's modelling, rendering and texturing tools, to make high quality AAA game assets from scratch. It will equip you with the skills to utilise the shortest possible pipeline, and master UV mapping in no time. This comprehensive training course is open to learners of all levels. Start building your portfolio and kickstart an exciting career in game development today. This best selling Maya: UV Mapping 3D Knife has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Maya: UV Mapping 3D Knife is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Maya: UV Mapping 3D Knife is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Maya: UV Mapping 3D Knife is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Maya: UV Mapping 3D Knife, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Maya: UV Mapping 3D Knife will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Maya: UV Mapping 3D Knife to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Course Overview Learn how to create an animated 3D cartoon owl in Blender 3D, with our step-by-step guide. The Create a Cartoon Owl with Blender 3D course will walk you through the process of creating a simple low poly owl character from scratch. You will start from the very basics, from downloading and setting up the program, to starting your first project. It will introduce you to Blender's essential tools and features which you will learn about in-depth to create 3D films, animations, applications, and 3D models. By the end of the course, you will have a valuable set of industry skills, from 3D rendering to modelling. You will also be able to work efficiently with the camera view, and use Boolean modifiers. This best selling Create a Cartoon Owl with Blender 3D has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Create a Cartoon Owl with Blender 3D is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Create a Cartoon Owl with Blender 3D is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Create a Cartoon Owl with Blender 3D is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Create a Cartoon Owl with Blender 3D, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Create a Cartoon Owl with Blender 3D will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Create a Cartoon Owl with Blender 3D to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Course Overview Make a dynamic image of a fictional figure from a far-off future by taking this course on how to Create a Character from The Post-Apocalypse. Exploring the years ahead of humanity has never been more popular in the media and provides plenty of artistic potentials. This tutorial will guide you in visually conceptualising a resident from a distant possible reality. By taking this Character Creation coaching, you can follow the steps to produce a drawing of a fictional figure that might be able to survive and thrive in any circumstance. From blank paper to the final image, you will be guided in seeking inspiration and bringing your ideas to the page. By creating this character and producing an eye-catching image, you will learn how to populate a post-apocalypse world with more of your creations. This best selling Create A Character From The Post-Apocalypse has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Create A Character From The Post-Apocalypse is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Create A Character From The Post-Apocalypse is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Create A Character From The Post-Apocalypse is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Create A Character From The Post-Apocalypse, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Create A Character From The Post-Apocalypse will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Create A Character From The Post-Apocalypse to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Course Overview Learn how to create a low poly tree for games in Maya and upload it to Unity for mobile game development, with this complete video-guide course. The Modeling Lowpoly Tree for Mobile Games in Maya & Unity 3D course is a complete walk through masterclass for beginners, starting with familiarising you with the basic tools. Through video training tutorials and instructor-led guidance, it will take you through the necessary steps to create a low poly tree from scratch in less than 10 minutes.  From mastering 3D mapping, to texturing techniques, you will gain the expertise required to create professional low poly trees for video games and apps. This course is ideal for 3D artists and game developers, and there are no specific entry requirements for enrolment. This best selling Modeling Lowpoly Tree for Mobile Games in Maya & Unity 3D has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Modeling Lowpoly Tree for Mobile Games in Maya & Unity 3D is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Modeling Lowpoly Tree for Mobile Games in Maya & Unity 3D is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Modeling Lowpoly Tree for Mobile Games in Maya & Unity 3D is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Modeling Lowpoly Tree for Mobile Games in Maya & Unity 3D, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Modeling Lowpoly Tree for Mobile Games in Maya & Unity 3D will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Modeling Lowpoly Tree for Mobile Games in Maya & Unity 3D to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.