40328 Design courses

If databases were kingdoms, SQL Server would be the crown jewel—and this bootcamp helps you understand why. Whether you're a curious beginner or someone who once dabbled in database queries, this course introduces you to Microsoft SQL Server in a way that feels both structured and digestible. From creating databases to querying data with finesse, you'll gain a clear understanding of how SQL Server works—without needing to download every technical manual Microsoft ever wrote. This course doesn't drown you in jargon or drag you into a tech fog. Instead, it’s paced with clarity, peppered with useful insights, and designed to help you genuinely grasp how to manage data efficiently. You'll learn key SQL concepts, explore table relationships, get to know stored procedures, and understand the logic that powers business intelligence—all while keeping your learning screen-based and refreshingly jargon-free. Let’s face it: data isn’t going anywhere, so you might as well learn to speak its language. Expert Support Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course. Key Benefits Learning materials of the Design course contain engaging voiceover and visual elements for your comfort. Get 24/7 access to all content for a full year. Each of our students gets full tutor support on weekdays (Monday to Friday) Course Curriculum: Microsoft SQL Server Bootcamp 2022 Section 01: Getting Started Section 02: SQL Server setting up Section 03: SQL Database basic Section 04: SQL DML (Data Manipulation Language) Section 05: SQL DDL (Data Definition Language) Section 06: SQL DCL (Data Control Language) Section 07: SQL Statement Basic Section 08: Filtering Data rows Section 09: Aggregate functions Section 10: SQL Query statements Section 11: SQL Group by statement Section 12: JOINS Section 13: SQL Constraints Section 14: Views Section 15: Advanced SQL commands Section 16: SQL Stored procedures Section 17: Import & Export data Section 18: Backup and Restore Database Course Assessment To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%. When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme. Certification Once you have finished the course, you will be eligible to apply for a CPD QS accredited certificate as proof of your new skills and your continued professional development. Certificates are available as PDF for £9, or you can request a hard copy to be sent in the post for £15. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). Who is this course for? This Microsoft SQL Server Bootcamp 2022 course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge. Requirements This Microsoft SQL Server Bootcamp 2022 course is open to all, with no formal entry requirements. Career path Upon successful completion of the Microsoft SQL Server Bootcamp 2022 Course, learners will be equipped with many indispensable skills and have the opportunity to grab.

Learn how to measure, cut and stitch accurate patchwork quilt blocks in this one day workshop. Part of a 4 day quilt course, but suitable as a stand alone class too. This class is a great class to take after the beginners class as the sewing will be mostly straight lines and it will allow you to practice more seams and other skills learned in the beginners class. You will need to know how to handle a sewing machine for this class but it's very much still a class that's achievable for beginners. You will cover design, measuring, cutting, the use of various tools, and stitching.

24 Hours Left! Don't Let Year-End Deals Slip Away - Enrol Now! Step onto any construction site, and you'll see the immense effort that goes into creating a masterpiece. Every little detail matters - from the layout and the materials used to the workers hired. To create an awe-inspiring structure, one needs an arsenal of skills, and that's exactly what our Construction Site Management bundle offers. The bundle comprises eleven courses, each designed to equip you with vital skills that are in demand in the construction industry. The first course is endorsed by the Quality Licence Scheme (QLS) and comes with a hardcopy certificate, proving your proficiency in Site Management. The QLS hardcopy certificate is highly regarded by employers, providing a tangible way to showcase your skills and abilities. The ten other courses in the bundle are CPD-QS accredited, ensuring that you gain the relevant skills and knowledge to excel in your construction career. From Building Quantity Surveying to Workplace Health and Safety, each course offers a unique set of skills that you can apply in your profession. Whether you're looking to upskill or change careers, our Construction Site Management bundle is the perfect solution. Enrol now and join the ranks of construction professionals who are making a difference in the world, one structure at a time. This Construction Site Management Bundle Package includes: Course 01: Diploma in Site Management at QLS Level 5 10 Premium Additional CPD QS Accredited Courses - Course 01: Building Quantity Surveying Course 02: Land Surveying Course 03: Diploma in Construction Industry Scheme (CIS) Course 04: Introduction to Xactimate: Construction Cost Estimation Course 05: Construction Estimation using RSMeans Course Course 06: Professional Interior Design & Construction Course 07: Site Management Safety Training Course 08: Workplace Health and Safety Course 09: Fire Risk Assessment With Health and Safety Training Course 10: Contracts Law UK Why Prefer This Construction Site Management Bundle? You will receive a completely free certificate from the Quality Licence Scheme Option to purchase 10 additional certificates accredited by CPD Get a free Student ID Card - (£10 postal charges will be applicable for international delivery) Free assessments and immediate success results 24/7 Tutor Support After taking this Construction Site Management bundle courses, you will be able to learn: Develop skills in site management, building quantity surveying, land surveying, and construction estimation. Understand the Construction Industry Scheme (CIS) and its implications for contractors and subcontractors. Learn how to estimate construction costs using Xactimate and RSMeans software. Acquire knowledge of workplace health and safety regulations and fire risk assessment. Develop professional interior design and construction skills. Gain expertise in contract law in the UK. ***Curriculum breakdown of Site Management*** Introduction to Construction Management Project Life Cycle and Success Preliminary Site Investigation & Site Organisation Construction Site Layout Planning and Temporary Facilities Management Site Management Planning & Management of Equipment Construction Materials Management Stock Control Quality Assurance and Customer Care Legal Aspects of Contracting Human Resources Management Risk and Value Management Communications, Information and Documentation of Construction Health and Safety in Construction Management How is the Construction Site Management Bundle Assessment Process? You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you successfully pass the exams. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This bundle is for: Individuals seeking to upskill in the construction industry. Professionals looking to advance their career in construction management. People considering a career change to the construction industry. Anyone interested in learning more about construction site management and safety. Career path Our courses will prepare you for a range of careers, including: Site Manager: £25,000 to £75,000 per annum. Building Quantity Surveyor: £25,000 to £75,000 per annum. Land Surveyor: £22,000 to £45,000 per annum. Estimator: £22,000 to £50,000 per annum. Health and Safety Officer: £20,000 to £45,000 per annum. Interior Designer: £20,000 to £60,000 per annum. Certificates CPD QS Accredited Certificate Digital certificate - Included Upon successfully completing the Bundle, you will need to place an order to receive a PDF Certificate for each course within the bundle. These certificates serve as proof of your newly acquired skills, accredited by CPD QS. Also, the certificates are recognised throughout the UK and internationally. CPD QS Accredited Certificate Hard copy certificate - Included International students are subject to a £10 delivery fee for their orders, based on their location. Diploma in Site Management at QLS Level 5 Hard copy certificate - Included

Enhance your expertise in electrical power failure analysis and investigations with EnergyEdge's insightful course for precision resolutions. Enroll now!

CompTIA Advanced Security Practitioner (CASP): Learn cutting-edge security protocols, risk management, and incident response. Elevate your cybersecurity career. Suitable for IT professionals.

2 QLS Endorsed Course | CPD Certified | Free PDF + QLS Hardcopy Certificates | 180 CPD Points | Lifetime Access

Course Overview Discover practical ways and techniques for organising business practices with his training for Resource & Workout Layout. Companies that do not structure or maintain workflows and supplies are destined to have chaotic procedures that are ineffective. You can use this training to avoid that possibility and ensure that activities meet operational plans that satisfy customer demands and organisational objectives.  This Operations Management tutorial delivers a masterclass for practical task planning and processing design, ensuring that workforce and resources are placed evenly across an operational structure. You will be shown how capacity management and workflow organisation is best achieved, alongside human resourcing and health and safety protocols. Enrol now and work in the most professional way possible, leading your company to new levels of productivity. This best selling Resource & Workout Layout has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Resource & Workout Layout is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Resource & Workout Layout 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 Resource & Workout Layout 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 Resource & Workout Layout, 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 Resource & Workout Layout 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 Resource & Workout Layout 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.

Adobe authorised live online course with study materials and certificate of completion included Our advanced Adobe Photoshop course has been developed especially for Photoshop users who want to harness the full potential of the programme. You will learn advanced techniques for replacing colour, professional image retouching methods and complex blending techniques for integrating textures. You will also discover power user keyboard shortcuts and the advantages of different techniques for masking complex objects, plus much more. Description Completing this course will enable you to do the following and more: Use advanced image retouching Use advanced image restoration techniques Work with Smart Objects Learn Quick and effective techniques for masking complex objects Use Advanced retouching techniques using blending layers Work with Textures Use Texture integration using advanced blending techniques Implement Non-destructive transformations using smart objects Work with Advanced sharpening and noise reduction techniques Record, import and execute actions Make Selections from colour and alpha channels Improve your workflow Use Power Shortcuts Access Repousse and 3D layers For the full course content please download the course information pdf listed above. Who is this course for? This course is perfect for existing Photoshop users who want to learn how to make use of more of the applications powerful features and improve their workflow. Requirements Attendees should have a good working knowledge of Photoshop. You will need a broadband internet connection to participate in this live online course. Certificates Certificate of completion Digital certificate - Included

Adobe Authorised Training. Live online course with study materials and certificate of completion included Adobe Photoshop has long been the go-to application for image editing of all kinds. It’s used for everything from enhancing or manipulating photographs for print to formatting images for social media and website use. During this beginners course at our central London studios you will learn how to utilise Photoshop's powerful image editing capabilities. You will receive expert training in using tools for resizing, retouching and enhancing images with selections and layers. Resources Introduction to Adobe Photoshop Course Information Description Completing this course will enable you to do the following and more: Understand the concepts of non-destructive image editing Understand differences between image file types Re-size, crop and export images Create special effects using filters Confidently work with multiple Photoshop layers Perform substantial image corrections and enhancements Format and optimise images for web & social media use Add text to your images Produce banner ads for web advertising For the full course content please download the course information pdf listed above. Who is this course for? This workshop is suitable for anyone who wishes to learn Photoshop from scratch or wants to improve their existing knowledge of the program. Requirements Attendees should have basic PC or Mac skills. You will need a broadband internet connection to participate in this live online course. Certificates Certificate of completion Digital certificate - Included

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included