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

2004 Design courses delivered On Demand

SQL Programming Masterclass

4.9(27)

By Apex Learning

Course Overview: Are you ready to embark on a journey into SQL Programming? Unlock the power of data manipulation and database management with the SQL Programming Masterclass. This comprehensive course is meticulously designed throughout this masterclass to provide you with an in-depth understanding of SQL, starting from the basics and progressing to advanced topics. You will explore SQL data types, filtering and sorting data, working with functions, handle NULL values, and even diving into complex SQL concepts like joins, unions, etc. With a course duration of carefully crafted lessons, this Masterclass ensures you grasp SQL's nuances and develop the proficiency to apply these skills effectively.By the end of the SQL Programming Masterclass, you will be prepared to navigate the world of databases confidently. Enrol in this course today and start your journey! Key Features of the Course: CPD certificate upon completion 24/7 learning assistance and support Who is This Course For? This course is perfect for individuals seeking to enhance their data management and analysis skills. Whether you're a data analyst, database administrator, software developer, or professional looking to upskill, this course will empower you to harness the power of SQL programming. Prior programming experience is not mandatory, making it accessible to beginners and intermediate learners. What You Will Learn: Foundations of SQL programming: Learn the basics of SQL, database management systems, and the tools used in this course, such as PostgreSQL and SQLectron. Data manipulation: Master the art of extracting, filtering, and sorting data based on specific requirements using various SQL keywords and operators. Advanced querying techniques: Dive deeper into SQL programming by exploring functions, grouping and aggregating data, and using advanced query techniques. Data conversion and manipulation: Discover how to convert data types, concatenate strings, manipulate characters and numbers, and utilise case statements for more sophisticated queries. Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Data modification: Learn how to insert, update, and delete records in a database, as well as manage table structures and constraints.Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Views and schemas: Explore the concepts of views and schemas, and learn how to create and use them to organise and present data effectively. Why Enrol in This Course: Top-reviewed course: Join thousands of satisfied learners who have praised this course for its clear explanations, comprehensive content, and examples. Recently updated curriculum: Benefit from the most up-to-date information and industry best practices in SQL programming. In-demand skills: SQL programming is a highly sought-after skill in today's job market, opening up numerous career opportunities across industries. Requirements: No prior programming experience is required. All you need is a computer with an internet connection and a willingness to learn. Career Path: Upon completing the SQL Programming Masterclass, you'll have the knowledge and skills for various career paths, including: Data Analyst - Average UK salary: £35,000 per year Database Administrator - Average UK salary: £40,000 per year Business Intelligence Analyst - Average UK salary: £45,000 per year SQL Developer - Average UK salary: £40,000 per year Data Engineer - Average UK salary: £55,000 per year Software Developer - Average UK salary: £45,000 per year Data Scientist - Average UK salary: £60,000 per year Certification: Upon completing the Hygiene and Infection Control CPD Level 4 course, you will receive a CPD certificate. It demonstrates your commitment to maintaining the highest standards of hygiene and infection control. Course Curriculum 17 sections • 117 lectures • 10:47:00 total length •Introduction: 00:01:00 •Tools Used in This Course: 00:01:00 •Download PostgreSQL: 00:02:00 •Install PostgreSQL: 00:03:00 •Download SQLectron: 00:02:00 •Install SQLectron: 00:01:00 •Connect to PostgreSQL - Credentials: 00:01:00 •Connect to PostgreSQL Using SQLectron: 00:02:00 •Import Course Data Using SQLectron: 00:02:00 •FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data: 00:08:00 •Check Imported Data: 00:06:00 •What is a Database?: 00:01:00 •SQL Data Types: 00:02:00 •Finally Some Fun! Extracting Data Based on Requirements: 00:01:00 •Filtering Data using WHERE Keyword: 00:08:00 •Filter Data by Range Using BETWEEN: 00:03:00 •Filter Data by Set of Values Using IN: 00:03:00 •Filter Data by Date: 00:05:00 •More Filtering by Date: 00:03:00 •Another Query Filtering by Date: 00:01:00 •Filter Data by Strings: 00:04:00 •More Filtering by Strings: 00:05:00 •More Filtering by Strings 2: 00:10:00 •More Filtering by Strings 3: 00:02:00 •How to Ignore Caps when Filtering by String: 00:04:00 •AND Operator: 00:10:00 •OR Operator: 00:12:00 •NOT Operator: 00:09:00 •AND, OR & NOT Operators: Which Has the Highest Priority?: 00:06:00 •Basic Math Operations: 00:06:00 •Modulo Operator: 00:04:00 •Calculate The Net Salary for Employees: 00:06:00 •Filter Data with Math Equations: 00:03:00 •Concatenate Strings with '||' Operator: 00:06:00 •Concatenate Strings with Numbers: 00:02:00 •Give Your Report Fields A Cool Name: 00:04:00 •A Report for Payroll: 00:07:00 •Order Records by Column: 00:06:00 •Order Records by Multiple Columns: 00:12:00 •How Alias Names Cannot Be Used with WHERE: 00:02:00 •LIMIT Record Count Fetched by Your Query: 00:08:00 •Fetch A Field's Unique Values Using DISTINCT: 00:03:00 •Using DISTINCT Keyword with Multiple Columns: 00:06:00 •What is a NULL Value Anyway?: 00:05:00 •Build More Sophisticated Queries with CASE Statements: 00:10:00 •Your Knowledge So Far Under A Great Test: 00:09:00 •Let Me Introduce You to Functions: 00:04:00 •SUM Function: 00:04:00 •AVG (Average) Function: 00:04:00 •COUNT Function: 00:07:00 •MIN & MAX Functions: 00:04:00 •How To Count Your Field's Unique Values: 00:04:00 •GROUP BY Clause: Use Functions with Dimensions: 00:06:00 •GROUP BY More Than One Dimension: 00:05:00 •Now For Some Tough Workout: 00:09:00 •Filter By Aggregate Functions with HAVING Clause: 00:08:00 •Character Functions - UPPER, LOWER & INITCAP: 00:08:00 •Character Functions - CONCAT & LENGTH: 00:10:00 •Character Functions - LPAD & RPAD: 00:13:00 •Character Functions - TRIM: 00:04:00 •Character Functions - REPLACE: 00:09:00 •Character Functions - SUBSTR: 00:10:00 •Number Functions - MOD & ROUND: 00:11:00 •Number Functions - TRUNC: 00:07:00 •Selectception: A Select Query inside another Select Query!: 00:06:00 •Auto Data Conversion in SQL: 00:11:00 •Cast Date to Character: 00:10:00 •Cast Number to Character: 00:09:00 •Cast Timestamp to Character: 00:07:00 •Cast Character to Number: 00:08:00 •Cast Character to Date & Timestamp: 00:09:00 •UNION: 00:03:00 •UNION ALL: 00:02:00 •Important Note about Combining Queries: 00:02:00 •INTERSECT: 00:01:00 •EXCEPT: 00:01:00 •Employees & Departments Tables Revised: 00:03:00 •Entity Relationship Diagram (ERD): 00:09:00 •Cartesian Join: 00:09:00 •Table Aliases with Joins: 00:07:00 •Why I Don't Recommend Cartesian Joins: 00:08:00 •Inner Join: 00:06:00 •In-Depth Look into Join Types in SQL: 00:03:00 •Outer Join - Right, Left & Full: 00:08:00 •INSERT a New Record to a Table: 00:09:00 •Insert Without Specifying Column Names: 00:09:00 •UPDATE a Record's Field Values: 00:07:00 •CAUTION! How an UPDATE Query Can Go Wrong: 00:04:00 •Update a Record Using Single-Row Functions: 00:04:00 •A Good Exercise: Extract Employee's Email Address: 00:02:00 •Solution: Extract Employee's Email Address: 00:13:00 •DELETE a Table's Record: 00:06:00 •Insert Records with Nested Select Queries: 00:06:00 •SQL Data Types Revised: 00:13:00 •Bookstore Data Set: Let's Move It to Database: 00:04:00 •Create Your First Table!: 00:08:00 •Insert Data to Your New Table: 00:08:00 •Change Column Data Type: 00:07:00 •Rename Column: 00:04:00 •Add a New Column to Table: 00:04:00 •Constraints in SQL: 00:01:00 •Primary Keys: 00:14:00 •NOT NULL Constraint: 00:05:00 •UNIQUE Constraint: 00:04:00 •DEFAULT Constraint: 00:04:00 •Foreign Keys: 00:08:00 •Use Foreign Keys with Joins - Books & Publishers: 00:06:00 •Foreign Keys - Properties: 00:06:00 •Drop Column: 00:01:00 •DROP Table: 00:01:00 •Create a New Table with Select Statement: 00:05:00 •A Trick to Create an Empty Table with Select Statement: 00:03:00 •Insert New Records Using Select Statement: 00:06:00 •Views: 00:03:00 •Schemas: 00:02:00 •Create & Use Schemas: 00:04:00 •Resources - SQL Programming Masterclass: 00:00:00

SQL Programming Masterclass
Delivered Online On Demand10 hours 47 minutes
£12

Photoshop CC Masterclass - Beginner to Advanced

4.3(43)

By John Academy

Description Do you want to master the world's best photo editing software? Or are you new to Adobe Photoshop CC? Then enrol the Adobe Photoshop CC Foundation course and begin your acquaintance with the course. The course is for the learners who have little or no knowledge about the photo editor. You will start your journey from the beginning. You will be familiar with the user interface and know how to open and create an image in Adobe Photoshop. The course introduces you to the essential tools, brushes and other features so that you can able to decide which tools to select while editing. Additionally, the course illustrates the concepts of colour schemes and guides you on how to use the colors efficiently. The procedures of adding text and text styles, working with Layers, adjusting Layers, customizing the workspace, moving and transforming Pixels, cropping images, etc. will be covered in the course. Finally, the course shows you how to print, convert and export files from Photoshop. Shortly, the course gives you a general understanding of the application so that you can proceed with the advanced skills. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Photoshop CC Masterclass - Beginner to Advanced is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Photoshop CC Masterclass - Beginner to Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Adobe Photoshop CC Beginner Introduction Introduction FREE 00:03:00 Introduction to Photoshop Introduction to Photoshop 00:05:00 Understanding Types of Documents 00:04:00 Understanding Resolution 00:04:00 Creating New Documents 00:06:00 Using Artboards 00:05:00 Using CC Templates 00:03:00 Utilizing the Search Feature 00:02:00 Customizing the Workspace Using Workspace Presets 00:02:00 Moving, Closing, and Opening Panels 00:06:00 Understanding Document Views 00:06:00 Using the History Panel 00:06:00 Working with Layers Why Layers 00:02:00 Using Layers 00:07:00 Creating Fill Layers 00:05:00 Applying Blending Modes 00:04:00 Using Layer Styles 00:09:00 Discovering the Properties Panel 00:08:00 Understanding Selections Creating Basic Selections 00:09:00 Using the Lasso Tools 00:08:00 Understanding the Quick Select Tools 00:07:00 Editing the Quick Mask 00:04:00 Saving Selectionsv 00:04:00 Moving Selections to Layers.mp 00:03:00 Understanding and Using Color Understanding Color Modes 00:10:00 Creating Swatches 00:06:00 Using Masks and Advanced Layers Applying Layer Masks 00:00:00 Deleting Layer Masks 00:01:00 Organizing Layers 00:03:00 Merging Layers 00:02:00 Flattening Layers 00:02:00 Working with Layer Comps 00:06:00 Using Adjustment Layers Using Image Adjustments 00:07:00 Understanding Adjustment Layers 00:10:00 Using Layer Masks with Adjustment Layers 00:03:00 Cropping Images Using the Crop Tool 00:05:00 Using the Crop Tool to Add Canvas 00:02:00 Moving and Transforming Pixels Using Free Transform 00:04:00 Working with Other Transform Options 00:03:00 Flipping Pixels 00:01:00 Adding Text and Text Styles Using the Type Tool 00:10:00 Discovering Typesetting 00:08:00 Formatting Text 00:09:00 Creating Type on a Path 00:03:00 Warping Type 00:03:00 Using Styles on Type 00:08:00 Applying Special Effects Using Layer Styles 00:05:00 Working with Patterns 00:03:00 Applying Filters 00:04:00 Creating Pixels with Filters 00:06:00 Exporting from Photoshop Printing in Photoshop 00:03:00 Converting to CMYK 00:04:00 Converting to Other File Types 00:13:00 Using File Info 00:09:00 Conclusion Course Recap 00:03:00 Adobe Photoshop CC Intermediate Start Here Introduction FREE 00:03:00 Painting and Using Brushes Painting with Brushes 00:09:00 Using the Brushes Panel 00:06:00 Defining Custom Brushes 00:04:00 Saving Tool Presets 00:02:00 Using the History Brush 00:03:00 Using Vector Tools Working with Vector Shapes 00:10:00 Creating Custom Shapes 00:02:00 Using the Pen Tool 00:07:00 Discovering Paths 00:04:00 Understanding Vector Masks 00:03:00 Using Vector Objects and Spot Colors 00:06:00 Using Libraries What is the CC Library 00:02:00 Adding and Deleting Assets in the Library 00:03:00 Sharing Assets 00:02:00 Creating New Libraries 00:03:00 Sharing a Library 00:02:00 Advanced Special Effects Using the Blur Filters 00:06:00 Applying the Distort Filters 00:03:00 Creating a Pixelated Look 00:02:00 Stylizing Effects 00:02:00 Using Liquify 00:05:00 Using Smart Filters 00:04:00 Working with Smart Objects 00:03:00 Loading a Texture into Type 00:04:00 Working with RAW Images What is a Raw Image 00:05:00 Processing Raw Images 00:12:00 Opening a JPEG File in Raw 00:06:00 Retouching Basics Developing a Strategy for Retouching 00:04:00 Using Retouching Tools 00:10:00 Using the Dust and Scratches Filter 00:04:00 Applying Sharpening 00:08:00 Working with Face Aware Liquify 00:06:00 Automating Tasks Using Actions 00:03:00 Creating Actions 00:07:00 Using Droplets 00:05:00 Using the Image Processor 00:05:00 Creating an HDR Image 00:07:00 Creating a Panoramic Image 00:07:00 Integration with other Adobe Software Using PSD Files in InDesign 00:04:00 Using PSD Files in Illustrator 00:03:00 Using PSD Files in Dreamweaver 00:04:00 Understanding Color Management Why Color Management 00:03:00 Calibrating a Monitor 00:04:00 Calibrating a Printer 00:03:00 Loading Profiles into PSDs 00:02:00 Conclusion Course Recap 00:03:00 Adobe Photoshop CC Advanced Introduction Introduction FREE 00:03:00 Processing Raw Images What is the RAW Format 00:04:00 Understanding White Balance 00:05:00 Setting Exposure 00:07:00 Working with Color and Clarity 00:03:00 Working with Adobe Camera Raw Updating Adobe Camera Raw 00:01:00 Using the Before and After Views 00:05:00 Resetting the Sliders 00:01:00 Understanding the Workflow Options 00:04:00 Setting the Camera Raw Preferences 00:03:00 Working with the Tools Understanding the White Board Tool 00:03:00 Using the Color Sampler 00:01:00 Working with the Targeted Adjustment Tool 00:02:00 Cropping Images 00:03:00 Applying Straightening 00:01:00 Using the Spot Removal Tool 00:05:00 Applying the Red Eye Tool 00:03:00 Understanding the Adjustment Brush 00:04:00 Using the Graduated Filter 00:02:00 Applying the Radial Filter 00:02:00 Rotating Images 00:01:00 Using Advanced Exposure Settings and Sharpening Using Curves 00:03:00 Understanding Sharpening and Noise 00:03:00 Creating Grayscale Images 00:03:00 Using Split Toning 00:03:00 Managing Corrections and Effects Enabling Lens Profiles 00:03:00 Using Effects 00:02:00 Adding Grain 00:02:00 Applying Post Crop Vignette 00:02:00 Using Camera Calibration 00:03:00 Saving Presets 00:02:00 Applying Snapshots 00:02:00 Creating Image Adjustments Using Adjustment Layers 00:02:00 Painting Layer Masks 00:05:00 Discovering Plugins for Photoshop What are Plugins 00:04:00 Using the Nik Collection 00:08:00 Using HDR Pro Effex 00:06:00 Using On1 Effects 00:04:00 Exploring Workflows Introudcing the Workshop Videos 00:04:00 Processing a Landscape Image 00:13:00 Processing a Macro Image 00:09:00 Processing a City 00:11:00 Conclusion Course Recap 00:02:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Photoshop CC Masterclass - Beginner to Advanced
Delivered Online On Demand10 hours 52 minutes
£12

Business Ethics Course

4.3(43)

By John Academy

Do you know what business ethics are? Want to learn how to have a good business reputation? Want to learn the details about business ethics? Want to find out how to apply them in your business? If yes, then this is the ideal course for you, enroll now and get the required knowledge of this course. Description: Every companies reputation is determined by its ethics. For a long term success maintaining good values is essential. Developing good ethics might be time-consuming, but by doing so you will help your business to improve in a unexpectable manner, and it will also change lives. Ethical obligations should be applied to employees, shareholders and investors and a list of other individuals related to the company. In this course you will learn about how can you deal equally with working in the enterprise at different posts, how can you provide their basic rights and how to handle conflict social responsibilities. Running an ethical organization or business has many rewards. Through this course, you will learn about the benefits of managing ethics within your business in details and reasons behind them. Implementing ethics at workplace might be difficult at first but and the end of the day, your business will be the one benefiting from it. In this course, you will learn about the different methods that will make it easier for you to implement ethics within the workplace. Organizations are legally bound to give a protected workplace to the majority of their employees as the primary concern of any employer is to have a safe working place, where there is no gender, religion, age and nationality discrimination and much more. In this course, you will also learn about how to keep your workplace safe for all the employees by issuing anti-harassment policies and also how to provide harassment training. You will learn much more through this course with our expert and well-experienced tutors. Who is the course for? Employees. Business owners. Individuals who have an interest in learning about business ethics. Individuals who desire to get acquainted with the ethical aspects of running a business. Managers. Corporate Trainers. Organizational Leaders. 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 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 hard copy 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 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: Business Ethics is a useful qualification to possess, and would be beneficial for the following professionals: Business manager. Business consultant. Director, Ethics, and Compliance. Business operation and analyst. Strategy analyst, business strategy. Business Ethics Course Module One- Getting Started 00:30:00 Module Two - What is Ethics 01:00:00 Module Three - Implementing Ethics in the Workplace 00:30:00 Module Four- Employer/Employee Rights 00:30:00 Module Five- Business & Social Responsibilities 00:15:00 Module Six- Ethical Decisions 00:30:00 Module Seven Whistle Blowing 00:30:00 Module Eight Managerial Ethics 00:30:00 Module Nine Unethical Behavior 00:30:00 Module Ten - Ethics in Business (I) 01:00:00 Module Eleven Ethics in Business (II) 00:30:00 Module Twelve - Wrapping Up 00:30:00 Mock Exam Mock Exam- Business Ethics Course 00:20:00 Final Exam Final Exam- Business Ethics Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Business Ethics Course
Delivered Online On Demand7 hours 25 minutes
£11.99

Adobe Photoshop CS for Beginners

4.3(43)

By John Academy

Description: Adobe Photoshop has become a household name these days. Editing photos has never been easier thanks to this beautiful piece of software. Well thanks to this Adobe Photoshop CS for Beginners course, you can now master the software as well. This course is designed to help you learn Photoshop in an easy to understand manner. As the name suggests, this course will help you develop a strong foundation within this community. This course will help you get familiar with the different tools and provide plenty of examples along the way. So get this course immediately and build a strong foundation in Adobe Photoshop CS for Beginners. Learning Outcomes: Understanding Photoshop CS, new features, how to get started and sources of help Utilizing Photoshop CS screen, menu bar, toolbox, status bar, palettes and windows Browsing through Photoshop files; opening, creating and saving files; text and audio saving options with image files; reverting to saved files; and different file formats Managing Photoshop layout by arranging screen components, workspace presets, working with multiple documents and hiding and displaying windows Introduction to selection, retouch, painting, vector, navigation, notation and colour tools Pallets of various different types including navigation, info, colour, swatches, styles, history and more Managing short cut keys, tools presets, option bar, alignment tools, grids, rulers and guides Selecting a complete image, working with marquee and lasso tools, utilizing magic wand and colour range Managing selections through adding, moving, resizing, saving, deselect options, cropping and more Understanding pixels, bitmap images, vector graphics, image re-sampling, pixel information with info palette Understanding Image resolution and constraints, changing size of image in pixels and image document, and auto resolution Understanding what is meant by Canvas and Document Window, and how to work with each of them Working with colours through the colour settings, understanding RGB and CMYK colours, using colour palette and ramp, and working with colour modes Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Adobe Photoshop CS for Beginners is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Adobe Photoshop CS for Beginners is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction 00:15:00 The Photoshop CS Screen Components 00:30:00 File Management Basics 00:30:00 Modifying your Photoshop Layout 00:30:00 Introduction to the Photoshop Toolbox 00:30:00 Introduction to Photoshop Palettes 01:00:00 More Photoshop Features 01:00:00 Making Selections 01:00:00 Manipulating Selections 01:00:00 Editing With Selections 00:30:00 Understanding Digital Images 00:30:00 Image Size and Resolution 01:00:00 Working with Your Canvas and Document Window 01:00:00 Working with Colour 01:00:00 Mock Exam Mock Exam- Adobe Photoshop CS for Beginners 00:20:00 Final Exam Final Exam- Adobe Photoshop CS for Beginners 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Adobe Photoshop CS for Beginners
Delivered Online On Demand10 hours 55 minutes
£11.99

Web Development Complete Course

4.3(43)

By John Academy

Description: In today's world websites are a basic necessity for everyone. All businesses have a website to advertise their products and services to existing and new customers. This course is what you need to understand web development basics as it will help you discover niche, identify platforms, select web host, use SEO & social sites and more. You do not want to fall behind everyone else, which is why you should consider taking this accredited Web Development Complete Course. You will be able to find out website design terminologies, discover new techniques to build your website for free, creating your site layout and a lot more. This is all geared towards helping you build your desired websites. In the next section, you focus on programming languages including HTML, CSS and PHP to see if these intrigue you enough to take the challenging yet unique road to web development. If you decide against that though, this course is prepared to teach you to use Joomla in order to get started in creating your first ever website. Who is the course for? People who want to learn PHP, HTML and CSS programming People interested in website development Entrepreneurs or business owners wanting to develop a website for their business 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 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 the cost of £39 or in PDF format at the 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 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: Web Development Complete Course is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: Web developers Entrepreneurs Website designers Programmers Basic Coding for Web Development HTML Basics 00:30:00 CSS Basics 01:00:00 Web Design & Development: HTML5, CSS3 and JavaScript 02:00:00 Web Development Basics What Are Niche Website? 01:00:00 The Role Of Visualization In Education 00:15:00 Identify Your Best Platform Or Software 01:00:00 Select A Web Host 01:00:00 Collect Your Site 00:15:00 Building A Content Rich Website 00:15:00 Build Backlinks 00:30:00 Use SEO, Multimedia And Social Sites 01:30:00 Use Analytics 01:00:00 Wrapping Up 00:15:00 Web Designing The Best Website Design for Your Business 01:00:00 What's in a Domain Suffixes 00:31:00 Website Design Terminology 01:00:00 CSS Explanation 01:00:00 Website Designs & Power Stations 01:00:00 How Can I Build my Website for Free 01:00:00 Six Steps to Website Design for Beginners 01:00:00 Dreamweaver or CoffeeCup for Website Design 01:00:00 Using Dreamweaver to Create your Site Layout 00:30:00 Three Crucial Steps to Creating Your Website 01:00:00 Dos and Don'ts of Website Creation9 01:00:00 SEO Basics for Effective Website Design 01:30:00 Ideas for Your Internet Business Website Design 01:00:00 Immediately Applicable Design Tips for a User-Friendly Website 01:00:00 6 Best Reasons to Create a Website 01:00:00 Common Mistakes in Website Design 01:00:00 Too Much or Too Little 00:30:00 Why Successful Website Development is Committed to Design 01:00:00 Ideas for Your Personal Website Design 01:00:00 How to Create a Social Networking Website to Enhance your Business 01:00:00 Tips for Designing an Affiliate Website 01:00:00 How to Use WordPress for your Website 01:30:00 Top 14 Reasons to Create a Blog 00:30:00 Tips for Designing a Successful Blog 00:30:00 More Tips Ahead 00:30:00 PHP Programming Welcome to the world of programming! 00:30:00 Getting Started 01:00:00 Let's Start Coding! 01:00:00 PHP Strings 01:00:00 PHP Variables 01:00:00 Useful Variables 00:30:00 PHP Includes & Problem Solving 01:00:00 Tip When Creating Inc Pages 00:30:00 Redirecting Using PHP 00:30:00 Multiple Conditions 01:00:00 PHP Arrays 01:00:00 PHP Loops 01:00:00 Note on PHP Math Functions: 00:30:00 Functions 01:00:00 PHP Sessions 00:30:00 Cookies 01:00:00 Introduction to MySQL 01:00:00 Making The Connection 01:00:00 Inserting Data 01:00:00 Deleting / Removing Data 00:15:00 Using Joomla INTRODUCTION TO JOOMLA 00:30:00 SCOPE OF JOOMLA 00:30:00 BENEFITS OF JOOMLA 00:30:00 COMPARISON WITH OTHER CONTENT MANAGEMENT SYSTEMS 01:00:00 WHY DEVELOPERS DRAWS TO JOOMLA? 00:30:00 How do I in install Joomla? 03:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Web Development Complete Course 00:30:00 Final Exam Final Exam- Web Development Complete Course 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Web Development Complete Course
Delivered Online On Demand48 hours
£11.99

Website Development Diploma

4.3(43)

By John Academy

Description This Website Development Diploma is suitable for anyone wishing to design and develop websites like a professional. This intense course delicately crafted into Four modules in HTML 5, JavaScript, CSS and Bootstrap which are must for developing a responsive web design. You will learn to share header, navigation, and footer HTML code across web pages using PHP. More importantly, learn to choose fonts, a colour scheme, create a header, navigation bar, footer, and make the site responsive, so it looks astonishing and runs well on both smartphones and other devices. Upon successful completion of the course will prepare you for a flourishing career in web development field. This information-packed course also includes an interactive quiz, best practices, and techniques to bypass mistakes so that you can explore the exciting details about web development. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Website Development Diploma is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Website Development Diploma is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Get Started What This is About 00:07:00 Start Building 00:18:00 Choose Your Fonts 00:05:00 Choose Your Color Scheme 00:05:00 Create the Nav Bar 00:11:00 Add a Page Footer 00:08:00 Beyond the Basic Structure Style the Body Content 00:05:00 Make it Responsive 00:10:00 Activate the Hamburger Menu 00:17:00 Make it Professional with Animations 00:04:00 Share Content Across Pages Why Share Content Across Pages? 00:08:00 Install AMPPS - Windows 00:11:00 Install AMPPS - Mac 00:13:00 Break Out the Shared Content 00:10:00 Professional-Grade Touches External JavaScript and Meta Tags 00:07:00 Adding More Pages to the Site 00:07:00 Highlight the Current Page in the Nav Bar 00:14:00 More Body Text Styling 00:10:00 Creating the Media Cards 00:13:00 Styling Lists 00:09:00 Styling Form Controls 00:15:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Website Development Diploma
Delivered Online On Demand3 hours 27 minutes
£11.99

Adobe Photoshop CC Foundation

4.3(43)

By John Academy

Description Do you want to master the world's best photo editing software? Or are you new to Adobe Photoshop CC? Then enrol the Adobe Photoshop CC Foundation course and begin your acquaintance with the course. The course is for the learners who have little or no knowledge about the photo editor. You will start your journey from the beginning. You will be familiar with the user interface and know how to open and create an image in Adobe Photoshop. The course introduces you to the essential tools, brushes and other features so that you can able to decide which tools to select while editing. Additionally, the course illustrates the concepts of colour schemes and guides you on how to use the colors efficiently. The procedures of adding text and text styles, working with Layers, adjusting Layers, customizing the workspace, moving and transforming Pixels, cropping images, etc. will be covered in the course. Finally, the course shows you how to print, convert and export files from Photoshop. Shortly, the course gives you a general understanding of the application so that you can proceed with the advanced skills. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Adobe Photoshop CC Foundation is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Adobe Photoshop CC Foundation is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:03:00 Introduction to Photoshop Introduction to Photoshop 00:05:00 Understanding Types of Documents 00:04:00 Understanding Resolution 00:04:00 Creating New Documents 00:06:00 Using Artboards 00:05:00 Using CC Templates 00:03:00 Utilizing the Search Feature 00:02:00 Customizing the Workspace Using Workspace Presets 00:02:00 Moving, Closing, and Opening Panels 00:06:00 Understanding Document Views 00:06:00 Using the History Panel 00:06:00 Working with Layers Why Layers 00:02:00 Using Layers 00:07:00 Creating Fill Layers 00:05:00 Applying Blending Modes 00:04:00 Using Layer Styles 00:09:00 Discovering the Properties Panel 00:08:00 Understanding Selections Creating Basic Selections 00:09:00 Using the Lasso Tools 00:08:00 Understanding the Quick Select Tools 00:07:00 Editing the Quick Mask 00:04:00 Saving Selectionsv 00:04:00 Moving Selections to Layers.mp 00:03:00 Understanding and Using Color Understanding Color Modes 00:10:00 Creating Swatches 00:06:00 Using Masks and Advanced Layers Applying Layer Masks 00:00:00 Deleting Layer Masks 00:01:00 Organizing Layers 00:03:00 Merging Layers 00:02:00 Flattening Layers 00:02:00 Working with Layer Comps 00:06:00 Using Adjustment Layers Using Image Adjustments 00:07:00 Understanding Adjustment Layers 00:10:00 Using Layer Masks with Adjustment Layers 00:03:00 Cropping Images Using the Crop Tool 00:05:00 Using the Crop Tool to Add Canvas 00:02:00 Moving and Transforming Pixels Using Free Transform 00:04:00 Working with Other Transform Options 00:03:00 Flipping Pixels 00:01:00 Adding Text and Text Styles Using the Type Tool 00:10:00 Discovering Typesetting 00:08:00 Formatting Text 00:09:00 Creating Type on a Path 00:03:00 Warping Type 00:03:00 Using Styles on Type 00:08:00 Applying Special Effects Using Layer Styles 00:05:00 Working with Patterns 00:03:00 Applying Filters 00:04:00 Creating Pixels with Filters 00:06:00 Exporting from Photoshop Printing in Photoshop 00:03:00 Converting to CMYK 00:04:00 Converting to Other File Types 00:13:00 Using File Info 00:09:00 Conclusion Course Recap 00:03:00 Resources Resources - Adobe Photoshop CC Foundation 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Adobe Photoshop CC Foundation
Delivered Online On Demand4 hours 38 minutes
£11.99

Complete Wordpress Web Design Diploma

4.3(43)

By John Academy

Description The Complete WordPress Web Design Diploma is specifically designed for those wishing to learn how to create a business-focused website. Through the course, you will learn everything you need to know about launching your first WordPress blog! Learn how to use WordPress to create your own blog site. You'll learn about designing a site and how to physically create a website. You will know how to design pages, menus, sidebars, footers, and create a professional and modern website. You will learn how to build & do web development for your WordPress website. Also, you will learn how to use the Elementor & WordPress theme to create a beautiful WordPress E-commerce store that attracts your customers and shows your products at it is best design aspect & presentation managing all the store customizations including tax, shipping, sales & even discount coupons. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Complete WordPress Web Design Diploma is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Complete WordPress Web Design Diploma is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction & installing Wordpress Course Outline FREE 00:02:00 Website Online Hosting 00:10:00 Installing wordpress 00:03:00 Installing wordpress theme ocean wp & elementor page builder 00:02:00 Creating website pages & menu 00:07:00 Wordpress page builder Familiarization Quick tour in Elementor 00:04:00 Creative Art directions & layout inspirations for web design 00:08:00 Familiarize with Elementor ( Sections ) 00:16:00 Familiarize with Elementor ( widgets ) & Desiging them 00:04:00 Brain storming & Tips for fast workflow with elementor 00:10:00 Wordpress home page Design & development WordPress website header design & banner ( part 1 ) 00:17:00 WordPress website header design & banner ( part 2 ) 00:13:00 WordPress website header design & banner ( part 3 ) 00:08:00 Features Section Design 00:09:00 Png Section Design 00:04:00 Email opt-in section 00:11:00 Testmonials section design 00:12:00 Image carousel section (slider) design 00:10:00 WordPress Website Footer Design 00:13:00 WordPress Customizer tour & website logo 00:18:00 Finalizing our home page & design hints 00:05:00 Wordpress About Us page Design & development About Us page Design ( part1 ) 00:17:00 About Us page Design ( part2 ) 00:18:00 About Us page Design ( part3 ) 00:12:00 Wordpress Contact Us & blog page design & development Contact Us page & Blog Page Creation 00:23:00 Creating WordPress Blog & Posting with Elementor 00:25:00 Wordpress Responsive website & publishing website WordPress Mobile & Tablet Responsive Website 00:21:00 Publishing wordpress website & creating maintance & coming soon pages 00:09:00 Free Plugins to mimic the Elementor Pro Free plugins to Mimic the Elementor pro 00:14:00 Exporting & importing our Elementor pages Exporting & Importing Elementor pages 00:05:00 Creating Our Wordpress ecommerce store installing woocommerce plugin ( Ecommerce Section ) 00:06:00 Making the first product (simple product) 00:09:00 Making Variable products 00:09:00 Up sells & cross sells Products 00:04:00 Discount coupons 00:06:00 Designing ecommerce store with elementor 00:14:00 Wordpress website customization Converting WordPress Website to https 00:04:00 Google Analytics & webmaster tool (SEO ranking) 00:10:00 Speeding up our wordpress website 00:13:00 Optimizing images & creative images Art directions 00:11:00 Understanding subdomains 00:06:00 Wordpress Website Backup, official email & more Website official email (domain email & device setup) 00:05:00 Site back up & site lock trust seal English 00:09:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Complete Wordpress Web Design Diploma
Delivered Online On Demand7 hours 16 minutes
£11.99

Website for Service Business

By IOMH - Institute of Mental Health

Overview This Website for Service Business course will unlock your full potential and will show you how to excel in a career in Website for Service Business. So upskill now and reach your full potential. Everything you need to get started in Website for Service Business is available in this course. Learning and progressing are the hallmarks of personal development. This Website for Service Business will quickly teach you the must-have skills needed to start in the relevant industry. In This Website for Service Business Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Website for Service Business skills to help you advance your career. Acquire a comprehensive understanding of various Website for Service Business topics and tips from industry experts. Learn in-demand Website for Service Business skills that are in high demand among UK employers, which will help you to kickstart your career. This Website for Service Business course covers everything you must know to stand against the tough competition in the Website for Service Business field.  The future is truly yours to seize with this Website for Service Business. Enrol today and complete the course to achieve a Website for Service Business certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Website for Service Business course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Website for Service Business course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Website for Service Business course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Website for Service Business is suitable for anyone aspiring to start a career in Website for Service Business; even if you are new to this and have no prior knowledge on Website for Service Business, this course is going to be very easy for you to understand.  And if you are already working in the Website for Service Business field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Website for Service Business course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Website for Service Business course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Website for Service Business course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Website for Service Business course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Section 01: Build a Stunning Static Website for Your Accounting Business Using Wix ADI Introduction 00:01:00 Importance of an Online Presence of an Accounting Firm 00:03:00 Multi-Page Accounting Website - Part 1 00:03:00 Multi-Page Accounting Website - Part 2 00:02:00 Single-Page Accounting Website 00:03:00 How to Build a Multi-Page Accounting Website Using WIX 00:04:00 How to Edit the Homepage of an Accounting Website 00:06:00 How to Edit the About Page, Service Page and Contact Page 00:04:00 How to Make an Accounting Website Mobile Friendly 00:03:00 Section 02: Create a Stunning One-Page Accounting Website Using Wix Editor A Brief View 00:01:00 Set Up Wix Editor 00:02:00 Dashboard - Part 1 00:02:00 Dashboard - Part 2 00:03:00 Edit the Header Part 1 00:03:00 Edit the Header Part 2 00:03:00 Edit the Hero Section 00:03:00 Edit the Services Section Part 1 00:05:00 Edit the Services Section Part 2 00:02:00 Edit the Contact Section and Footer 00:01:00 Mobile Version 00:01:00

Website for Service Business
Delivered Online On Demand55 minutes
£11.99

Mastering Colour-Architectural Design & Interior Decoration

By IOMH - Institute of Mental Health

Overview of Mastering Colour-Architectural Design & Interior Decoration The UK interior design industry is worth £3.4 billion and is still growing. Homeowners and businesses now understand how colour can change how a space looks and feels. Mastering Colour – Architectural Design & Interior Decoration helps you learn how to use colour to make rooms more attractive, comfortable, and functional. Whether you're working on a home or a business space, colour can help you make a strong impact. This course gives you the skills to choose and apply colours in smart ways that help your work stand out. With Mastering Colour – Architectural Design & Interior Decoration, you will learn simple and clear colour terms, how colours affect mood, and how to create great colour combinations. You will also learn how to use warm and cool colours, tricks that make spaces look bigger or more balanced, and ways to match colours with current design styles. These lessons are made especially for people working in architecture and interior design. British designers who complete Mastering Colour – Architectural Design & Interior Decoration often get more clients and better results. Colour is not just about looks—it also affects how people feel in a room. By taking Mastering Colour – Architectural Design & Interior Decoration, you'll be ready to make strong design choices that improve spaces and meet client needs. By the end of Mastering Colour – Architectural Design & Interior Decoration, you will be able to: Understand the most important colour terms used in design. See how colour trends and fashion are connected. Use basic colour theory in building and room designs. Build smart and attractive colour plans for decorating spaces. Use the right mix of colours to meet design needs. Change how a space feels and looks by applying colour in smart ways. Who is this course for? This course is great for: Interior designers who want to use colour more confidently and professionally. Architects who want to add colour theory to their designs. Home decorators who want to improve how they use colour in rooms. Students studying design who want to build strong colour skills. Visual merchandisers who want to learn more about colour and space. Process of Evaluation After studying the Mastering Colour-Architectural Design & Interior Decoration, 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 Mastering Colour-Architectural Design & Interior Decoration, 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 There is no prerequisite to enrol in this Mastering Colour-Architectural Design & Interior Decoration course. Career Path This Mastering Colour-Architectural Design & Interior Decoration Course will help the learners to pursue a variety of careers. Such as: Interior Designer - £23K to £45K/year Architectural Visualiser - £25K to £40K/year Colour Consultant - £30K to £55K/year Residential Decorator - £22K to £38K/year Kitchen and Bathroom Designer - £24K to £42K/year Course Curriculum Module 1: Introduction Colour Introduction 00:02:00 Introduction to Chapters 00:05:00 Module 2: The Impact Of Fashion And Colour Trends Colour Fashion & Colour Trends 00:04:00 Module 3: Colour Terminology Colour Terminology 00:04:00 Module 4: Colour Basics And Neutral Colours Colour Basics 00:05:00 Module 5: Warm Vs. Cool Colours Colour Warm & Cool Colours 00:03:00 Module 6: Colour Schemes Colour Schemes 00:11:00 Module 7: Colour Ratios And Applications Colour Ratios 00:05:00 Module 8: Using Colour To Trick The Eye Colours Tricking The Eye 00:04:00 Module 9: Conclusion Colour Conclusion 00:01:00

Mastering Colour-Architectural Design & Interior Decoration
Delivered Online On Demand44 minutes
£11.99