2395 Design courses in Cardiff delivered Online

Defining Corporate Priorities for Smarter Sustainability What does sustainability mean for your organization? During this session, Fulya Kocak will discuss varying levels of sustainability and define how they differ based on an organization's priorities. Using examples from the construction industry, Ms. Kocak will show participants - from project managers to Chief Executive Officers - how they can take action and apply smart strategies to further their company's sustainability goals. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Defining Corporate Priorities for Smarter Sustainability What does sustainability mean for your organization? During this session, Fulya Kocak will discuss varying levels of sustainability and define how they differ based on an organization's priorities. Using examples from the construction industry, Ms. Kocak will show participants - from project managers to Chief Executive Officers - how they can take action and apply smart strategies to further their company's sustainability goals. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Overview of Teaching Assistant Level 3 Video content is booming. With easy access to smartphones, everyone can be a videographer today. However, editing videos that captivate audiences requires skills. This Editing on CapCut – A Crash Course teaches you professional editing techniques using CapCut to create stunning videos for social media and online platforms. Learn industry best practices from an experienced instructor. Unleash your creativity and find opportunities as a video creator, editor or influencer. Export high-quality videos after Editing. Employ advanced techniques to edit videos creatively. This Editing on CapCut - A Crash Course will help you to learn: Edit videos using CapCut software tools. Arrange clips and add visual effects in videos. Sync motions to audio using keyframes in CapCut. Generate automatic captions for videos. Insert music and sound effects into videos skillfully. Export high-quality videos after Editing. Employ advanced techniques to edit videos creatively. This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Editing on CapCut – A Crash Course. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online — Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. 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 Editing on CapCut – A Crash Course course, you can order your CPD Accredited Digital/ PDF Certificate for £5.99. Certificate of Completion – Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? Aspiring video editors and content creators. Social media influencers and marketers want to create engaging videos. Small business owners looking to promote their brand through videos. Students interested in video production and Editing. Requirements There is no prerequisite to enrol in this course. You don’t need any educational qualification or experience to enrol in the Editing on CapCut – A Crash Course 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 course. Career Path Video Editor - £18K to £35K per year Social Media Manager - £21K to £45K per year Digital Marketer - £19K to £50K per year Content Creator - £15K to £40K per year Videographer - £20K to £50K per year

Discover the latest advancements and features in SQL 2021, the powerful database management system. Stay ahead with enhanced performance, security, and functionality for your data management needs.

Are you passionate about creating breathtaking floral designs that leave lasting impressions? Do you dream of transforming ordinary spaces into extraordinary experiences with the beauty of flowers? Our Events Floral Arrangement & Design course is the perfect opportunity to turn your floral aspirations into reality! Key Features: CPD Certified Free Certificate Developed by Specialist Lifetime Access In the Events Floral Arrangement & Design course, learners will explore the fundamentals of design, including essential elements and principles. They will gain hands-on experience in creating a variety of floral arrangements, starting from basic techniques and progressing to more advanced designs. The course covers a range of styles and themes, ensuring students can craft beautiful and unique arrangements for different occasions. Special focus is given to wedding floristry, teaching how to design elegant bouquets and decorations tailored for weddings. Additionally, the course includes training on creating respectful and tasteful funeral flower arrangements. Throughout, students will develop their creativity, learn to use different flowers and materials effectively, and master the skills needed for professional floral design. This comprehensive course equips learners with the knowledge and practical expertise to excel in the floral arrangement industry. Course Curriculum Module 01: Elements and Principles of Design part 1 Module 02: Elements and Principles of Design part 2 Module 03: How to Make Floral Arrangements- part 1 Module 04: How to Make Floral Arrangements- part 2 Module 05: Beautiful Floral Designs part 1 Module 06: Beautiful Floral Designs part 2 Module 07: Wedding Floristry- part 1 Module 08: Wedding Floristry- part 2 Module 09: Making Funeral Flower Arrangements Learning Outcomes Master the foundational elements and principles of floral design. Create stunning floral arrangements with expert techniques and tools. Design beautiful, impactful floral displays for various events. Develop exquisite floral arrangements tailored for weddings. Craft meaningful and elegant funeral flower arrangements. Integrate advanced floral design principles into your creative process. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring florists seeking design knowledge. Event planners enhancing their floral skills. Hobbyists passionate about floral arrangement. Wedding coordinators specializing in floristry. Funeral directors offering personalised flower arrangements. Career path Event Florist Wedding Florist Floral Designer Funeral Florist Floral Design Instructor Floral Shop Owner Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Are you passionate about creating breathtaking floral designs that leave lasting impressions? Do you dream of transforming ordinary spaces into extraordinary experiences with the beauty of flowers? Our Events Floral Arrangement & Design course is the perfect opportunity to turn your floral aspirations into reality! Key Features: CPD Certified Developed by Specialist Lifetime Access In the Events Floral Arrangement & Design course, learners will explore the fundamentals of design, including essential elements and principles. They will gain hands-on experience in creating a variety of floral arrangements, starting from basic techniques and progressing to more advanced designs. The course covers a range of styles and themes, ensuring students can craft beautiful and unique arrangements for different occasions. Special focus is given to wedding floristry, teaching how to design elegant bouquets and decorations tailored for weddings. Additionally, the course includes training on creating respectful and tasteful funeral flower arrangements. Throughout, students will develop their creativity, learn to use different flowers and materials effectively, and master the skills needed for professional floral design. This comprehensive course equips learners with the knowledge and practical expertise to excel in the floral arrangement industry. Course Curriculum Module 01: Elements and Principles of Design part 1 Module 02: Elements and Principles of Design part 2 Module 03: How to Make Floral Arrangements- part 1 Module 04: How to Make Floral Arrangements- part 2 Module 05: Beautiful Floral Designs part 1 Module 06: Beautiful Floral Designs part 2 Module 07: Wedding Floristry- part 1 Module 08: Wedding Floristry- part 2 Module 09: Making Funeral Flower Arrangements Learning Outcomes Master the foundational elements and principles of floral design. Create stunning floral arrangements with expert techniques and tools. Design beautiful, impactful floral displays for various events. Develop exquisite floral arrangements tailored for weddings. Craft meaningful and elegant funeral flower arrangements. Integrate advanced floral design principles into your creative process. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring florists seeking design knowledge. Event planners enhancing their floral skills. Hobbyists passionate about floral arrangement. Wedding coordinators specializing in floristry. Funeral directors offering personalised flower arrangements. Career path Event Florist Wedding Florist Floral Designer Funeral Florist Floral Design Instructor Floral Shop Owner Certificates Digital certificate Digital certificate - Included Will be downloadable when all lectures have been completed.

Electrical Training If you are interested in a rewarding and challenging career, then becoming an electrician could be the right choice for you. Our comprehensive Electrical Training Course will teach you everything you need to know to build a career in this field. Electricians play a vital role in our society, ensuring that our homes and businesses have safe and reliable access to electricity. Electricians with proper Electrical Training are in high demand in the UK, with job prospects expected to grow by 9% over the next five years. This Electrical Training Course covers everything from the basics, such as introduction and tools, to more advanced topics like electronic components and troubleshooting. Moreover, having theoretical knowledge in this electrical domain can bolster your professional credibility. Imagine being able to discuss, understand, and ideate on electrical concepts with ease. Electrical Training Course Learning Outcomes: Understand the foundations of electrical systems. Differentiate between electronic and electrical maintenance repair. Identify essential tools for electrical tasks. Recognise and understand various electronic components. Master the techniques of electrical testing. Develop problem-solving skills for troubleshooting. Acquire knowledge on introducing electronic components systematically. Electrical Training The "Electrical Training Course" offers an in-depth theoretical exploration into the vast world of electronics and electrical systems. The modules are meticulously curated to provide learners with a comprehensive understanding, beginning with introductory concepts, moving through the nuances of electronic and electrical maintenance repair, and concluding with a detailed step-by-step guide to electronic components. This Electrical Training Course provides a foundational understanding that can be applied to various real-world scenarios, enabling learners to make informed decisions, communicate effectively on related topics, and build a robust theoretical base for further studies or professional pursuits. Electrical Training Curriculum Breakdown of the Electrical Training Course Module 01: Introduction & Getting Started Module 02: Electronic and Electrical maintenance Repair Module 03: Tools Needed in Electrical Training Module 04: Electronic Components in Electrical Training Module 05: Testing Module 06: Troubleshooting in Electrical Training Module 07: Introduction to Electronic Components: A Step by Step Guide CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Electrical Training The Electrical Training course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Electrical Training. It is also great for professionals who are already working in Electrical Training and want to get promoted at work. Requirements Electrical Training To enrol in this Electrical Training course, all you need is a basic understanding of the English Language and an internet connection. Career path Electrical Training This Electrical Training Course can be helpful for learners to explore different career paths, such as: Electrical System Analyst: £35,000 - £50,000 per year. Electronic Product Designer: £28,000 - £48,000 per year. Maintenance and Repair Coordinator: £26,000 - £42,000 per year. Electronic Components Researcher: £33,000 - £57,000 per year. Certificates CPD Accredited Certificate of Completion Free Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Certificate of Completion Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Power electronics is the beating heart behind modern electrical systems, from electric vehicles to renewable energy grids. This course dives into the essential concepts that drive the conversion and control of electrical power using solid-state electronics. Whether you're fascinated by inverters, rectifiers, or converters, this course will help demystify the magic that keeps today’s energy systems running smoothly. No waffling or fluff—just straight-to-the-point content that explains the “how” and “why” behind each component and circuit. Designed with clarity and purpose, the content is perfect for learners aiming to sharpen their understanding of power electronic systems without digging through pages of jargon. You’ll get clear, structured explanations of switching devices, modulation techniques, control strategies, and more—all framed within the context of modern electrical engineering. If you've ever wondered what goes on behind the scenes in power supply systems, this course will connect the dots in a no-nonsense, straight-talking format. Why People Love And Enrol The Power Electronics for Electrical Engineering Course From One Education Eligibility for a CPD -accredited certificate on successful completion of course Learning materials of our course contains engaging voiceover and visual elements for your comfort Freedom to study at your own pace 24/7 access to the course materials for 12 months Full Tutor support on weekdays (Monday - Friday) This masterclass Power Electronics for Electrical Engineering online training course is designed by industry experts and will give you an in-depth understanding of this topic. The course features easy-to-digest modules that break down each topic and ensure all our students receive an unrivalled and thorough learning experience. If you want to work in this rapidly growing sector and stand out from the competition, then our Power Electronics for Electrical Engineering is the perfect place to kickstart your dream career. On the course, we guarantee that you will gain relevant skills and acquire tremendous knowledge on the subject. The certificate you'll achieve after completing the Power Electronics for Electrical Engineering course will help you land the job you want in a related field. Enjoy a pleasant and professional 100% online learning experience and enrol in our course and take control of your career! Course Curriculum: Here is a curriculum breakdown of the course: ***Power Electronics for Electrical Engineering*** Unit 1- Introduction to Power Electronics Components Module 1- Introduction to Power Electronics Module 2- Uncontrolled Switches Module 3- What is the Benefit of Diode Module 4- Semi-Controlled Switches Part 1 Module 5- Semi-Controlled Switches Part 2 Module 6- Semi-Controlled Switches Part 3 Module 7- What is the Benefit of Thyristor Module 8- Fully Controlled Switches Part 1 Module 9- Fully Controlled Switches Part 2 Module 10- Fully Controlled Switches Part 3 Unit 2- Fundamentals of Rectifier Circuits Module 1- Overview on Rectifiers Module 2- Rectifier Definition Module 3- Half Wave Uncontrolled Rectifier with R Load Module 4- Example on Half Wave Uncontrolled Rectifier with R Load Part 1 Module 5- Example on Half Wave Uncontrolled Rectifier with R Load Part 2 Module 6- Half Wave Uncontrolled Rectifier with RL Load Module 7- Derivation of the Discontinuous Current in R-L Load Module 8- Freewheeling Diode (Commutation Diode) Module 9- Half Wave R-L Load with FWD Module 10- Difference Between Continuous and Discontinuous Mode in RL Load Module 11- Half Wave RL Load with FWD Continuous Mode Module 12- Example on Half Wave Rectifier with FWD Module 13- Bridge Full Wave Uncontrolled Rectifier Part 1 Module 14- Bridge Full Wave Uncontrolled Rectifier Part 2 Module 15- Quick Revision on Bridge Full Wave Uncontrolled Rectifier Module 16- Firing Angle Module 17- Half Wave Controlled Rectifier R Load Module 18- Half Wave Controlled Rectifier R-L Load Module 19- Half Controlled R-L Load with FWD Module 20- Example 1 Module 21- Example 2 Module 22- Example 3 Module 23- Example 4 Module 24- Example 5 Module 25- Fully Controlled Bridge Rectifier Part 1 Module 26- Fully Controlled Bridge Rectifier Part 2 Module 27- Quick Revision on Bridge Full Wave Controlled Rectifier Module 28- Example 6 Module 29- Half Controlled Bridge Rectifier Module 30- Half Controlled Bridge Rectifier with FWD Module 31- Example 7 Module 32- Example 8 Module 33- Performance Parameters Module 34- Power Factor Unit 3- Fundamentals of AC Choppers Module 1- Introduction to AC Choppers Module 2- Definition of AC Choppers Module 3- Switching Techniques in AC Choppers Module 4- Applications on AC Choppers Module 5- Types of AC Choppers Module 6- AC Chopper with R Load Module 7- Example 1 on AC Chopper with R Load Module 8- Example 2 on AC Chopper with R Load Module 9- AC Chopper with L Load Part 1 Module 10- AC Chopper with L Load Part 2 Module 11- Example on AC Chopper with L Load Module 12- AC Chopper with RL Series Load Module 13- Example on AC Chopper with RL Series Load Module 14- AC Chopper with RL Parallel Load Module 15- Example on AC Chopper with RL Parallel Load Module 16- AC Chopper with Pure Capacitive Load Module 17- Example on AC Chopper with Pure Capacitive Load Module 18- AC Chopper Loaded by Heavy Rectifier Module 19- AC Chopper Loaded by an AC Motor with Sinusoidal Back Emf Module 20- Example on AC Chopper Loaded by an AC Motor with Sinusoidal Back Emf Module 21- Integral Cycle Control Module 22- Example on Integral Cycle Control Unit 4- Fundamentals of DC Choppers Module 1- Introduction to DC Choppers Module 2- Definition and Application of DC Choppers Module 3- Step down DC Chopper with R Load Module 4- Example on Step Dwon DC Chopper with R Load Module 5- Generation of Duty Cycle Module 6- Switching Techniques Module 7- Step Down DC Chopper with RLE Load Part 1 Module 8- Step Down DC Chopper with RLE Load Part 2 Module 9- Example 1 on Step Down DC Chopper with RLE Load Module 10- Example 2 on Step Down DC Chopper with RLE Load Module 11- Step Up DC Chopper with R or RL Load Module 12- Step Up DC Chopper with RE Load Module 13- Example on Step Up DC Chopper with RE Load Module 14- Buck Regulator Part 1 Module 15- Buck Regulator Part 2 Module 16- Example on Buck Regulator Module 17- Boost Regulator Module 18- Example on Boost Regulator Module 19- Buck Boost Converter Module 20- Example on Buck-Boost Converter Unit 5- Fundamentals of Inverters Module 1- Introduction to Inverters Module 2- Definition of Inverters Module 3- Importance and Applications of Inverters Module 4- Single Phase Half Bridge R-Load Module 5- Single Phase Half Bridge RL- Load Module 6- Performance Parameters of an Inverter Module 7- Example on Single Phase Half Bridge Module 8- Single Phase Bridge Inverter R- Load Module 9- Single Phase Bridge Inverter RL- Load Module 10- Example on Single Phase Bridge Inverter Module 11- Three Phase Inverters and Obtaining the Line Voltages Module 12- Threee Phase Inverters and Obtaining The Phase Voltages Module 13- Example on Three Phase Inverters Module 14- Single Pulse Width Modulation Module 15- Multiple Pulse Width Modulation Module 16- Example on Multiple Pulse Width Modulation Module 17- Sinusoidal Pulse Width Modulation Module 18- Industrial Inverter 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). CPD 15 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Power Electronics for Electrical Engineering training course is ideal for highly motivated individuals who want to enhance their professional skills and train for the job they want! This course also suits people aspiring for some in-depth knowledge on this topic and keep up to date with the latest information. Study the Power Electronics for Electrical Engineering course today and increase your professional skillset from the comfort of your home! Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Anyone and everyone with a knack for learning can enrol this course without any hesitation. Learn online from any internet device, including your computer, tablet or smartphone. Study when it suits you and complete the course at your own pace. All students must have a passion for learning and literacy, as well as being over the age of 16. Career path Studying the course is designed to help you get the job of your dreams, or even that promotion you've been waiting for a long time. Learn the essential skills and knowledge you need to exceed in your professional life with the help & guidance from our course.

This comprehensive course, 'SQL for Data Science, Data Analytics, and Data Visualization,' covers essential SQL concepts and tools for working with data. Participants will learn to manipulate, analyze, and visualize data using SQL Server, Azure Data Studio, and other relevant tools. The course also delves into advanced SQL commands, stored procedures, and data import/export, making it ideal for aspiring data professionals. Learning Outcomes: Set up and configure SQL Server and SQL Azure Data Studio for data analysis. Master SQL statements for data manipulation, data structure, and user management. Utilize SQL queries, joins, and aggregate functions for efficient data analysis. Understand SQL constraints, views, and advanced commands for in-depth data exploration. Create and implement SQL stored procedures to automate tasks. Leverage Azure Data Studio for data visualization and perform data analysis with SQL. Why buy this SQL for Data Science, Data Analytics and Data Visualization? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the SQL for Data Science, Data Analytics and Data Visualization there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This SQL for Data Science, Data Analytics and Data Visualization course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This SQL for Data Science, Data Analytics and Data Visualization does not require you to have any prior qualifications or experience. You can just enrol and start learning.This SQL for Data Science, Data Analytics and Data Visualization was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This SQL for Data Science, Data Analytics and Data Visualization is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Getting Started Introduction 00:03:00 How to get course requirements 00:03:00 Getting started on Windows, Linux or Docker 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 Section 02: SQL Server setting up Section Introduction 00:02:00 Microsoft SQL Server Installation 00:19:00 SQL Server Management Studio (SSMS) Installation 00:08:00 How to connect MS SQL (Windows Authentication) 00:04:00 How to connect MS SQL (SQL Server Authentication) 00:03:00 Download and Restore Sample Database 00:07:00 Section 03: SQL Azure Data Studio What is Azure Data Studio 00:06:00 Azure Data Studio Installation steps 00:07:00 Azure Data Studio to Connect SQL Server 00:09:00 Create a Database 00:07:00 Create a Table 00:09:00 Insert Data rows 00:07:00 View the Data returned by Query 00:03:00 Section 04: SQL Database basic SSMS Section Introduction 00:01:00 Overview of Databases8 00:11:00 Creating Database 00:05:00 SQL Data Types 00:03:00 Column Data Types on SSMS 00:04:00 Creating Table 00:09:00 Overview of Primary Key and Foreign Key 00:04:00 Primary Key 00:04:00 Foreign Key 00:07:00 Creating Temporary tables 00:06:00 Section 05: SQL Statements for DATA Section Introduction 00:01:00 Insert statement 00:08:00 Update statement 00:05:00 Delete statement 00:03:00 Section 06: SQL Data Structure statements Section Introduction 00:01:00 CREATE table statement 00:03:00 DROP statement 00:02:00 ALTER statement 00:05:00 TRUNCATE statement 00:04:00 COMMENT in query 00:01:00 RENAME 00:02:00 Section 07: SQL User Management Create Database user 00:04:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 08: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:07:00 SELECT DISTINCT 00:03:00 SELECT with column headings 00:03:00 Column AS statement 00:02:00 Section 09: Filtering Data rows SELECT WHERE Clause - theory 00:04:00 SELECT WHERE Clause - practical 00:07:00 Section 10: Aggregate functions Sum() 00:08:00 Min()-Max() 00:06:00 Section 11: SQL Query statements Order By statement 00:05:00 SELECT TOP clause in SQL 00:04:00 BETWEEN command 00:08:00 IN operator 00:04:00 Wildcard Characters and LIKE 00:05:00 Section 12: SQL Group by statement Section Introduction 00:01:00 Group by - theory8 00:03:00 Group by - practical 00:05:00 HAVING statement 00:04:00 Section 13: JOINS for Multiple table Data Analysis Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:08:00 Left outer join 00:03:00 Right outer join 00:02:00 Full outer join 00:01:00 Union 00:03:00 Cartesian Product with the Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 14: SQL Constraints Section introduction 00:01:00 Check constraint 00:07:00 NOT NULL constraint 00:08:00 UNIQUE constraint 00:05:00 Section 15: Views Creating Views 00:04:00 Reporting with multiple tables 00:03:00 Section 16: Advanced SQL commands Section Introduction 00:01:00 Timestamp 00:04:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:04:00 String functions 00:05:00 Sub Query 00:03:00 SELECT with calculations 00:06:00 Section 17: SQL Stored procedures Create stored procedure 00:05:00 Stored procedure with parameter 00:04:00 Section 18: Azure Data Studio Visualization Installing SandDance Extension 00:03:00 Visualization Charts 00:05:00 Multiple Table Data Charts 00:06:00 Section 19: Azure Studio SQL for Data Analysis Type Decision for Data Analysis 00:13:00 Data Analysis with Case Statement and String Text 00:09:00 Section 20: Import & Export data Section Introduction 00:01:00 Import Flat File 00:05:00 Import .csv or excel file 00:03:00 Export Data to Excel or any format 00:06:00 Section 21: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:04:00 Restoring Database backup 00:04:00

Dive into the world of structured data manipulation and management with the SQL course. Explore database fundamentals, constraints, functions, clauses, and advanced concepts such as joins and wild cards. From creating to altering databases, this course empowers you with a versatile skill set to navigate and manipulate data efficiently using SQL. Learning Outcomes: Acquire a foundational understanding of SQL, its role, and importance in database management. Master the creation, organization, and manipulation of databases. Implement constraints to ensure data integrity and enforce business rules. Utilize SQL functions to transform and manipulate data effectively. Employ SQL clauses to filter, sort, and analyze data for specific purposes. Perform alterations on databases and tables to accommodate evolving data needs. Explore the intricacies of joins and relationships to retrieve and consolidate data from multiple tables. Harness the power of wild cards to perform flexible and dynamic data searches. Why buy this SQL Database Management? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the SQL Database Management there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This SQL Database Management does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Aspiring Database Administrators and SQL Developers. Software Engineers Seeking Proficiency in SQL for Application Development. Data Analysts and Business Intelligence Professionals. IT Professionals Looking to Enhance Their Database Management Skills. Prerequisites This SQL Database Management was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path SQL Developer - $70,000 to $110,000/year. Database Administrator - $60,000 to $100,000/year. Data Analyst - $60,000 to $90,000/year. Business Intelligence Developer - $70,000 to $120,000/year. Database Manager - $80,000 to $130,000/year. Course Curriculum Unit 01: Introduction Module 01: Introduction 00:09:00 Module 02: Xampp (PHPmyadmin) installation 00:05:00 Unit 02: Getting Started With Databases Module 01: Creating a database 00:02:00 Module 02: Creating Tables 00:03:00 Module 03: More about Tables 00:01:00 Module 04: Inserting into Tables 00:03:00 Module 05: Updating and Deleting 00:04:00 Module 06: Data Types 00:03:00 Module 07: Conditional and comparison operators 00:04:00 Unit 03: Constraints Module 01: Primary Keys 00:05:00 Module 02: Foreign Keys 00:07:00 Module 03: Indexes 00:03:00 Module 04: Unique Indexes 00:03:00 Unit 04: SQL Functions Module 01: Functions (Part: 01) 00:02:00 Module 02: Functions (Part: 02) 00:03:00 Unit 05: SQL Clauses Module 01: Basic Queries and Where Claueses 00:04:00 Module 02: Order by 00:03:00 Module 03: Distinct 00:05:00 Module 04: In 00:04:00 Module 05: Group by 00:07:00 Unit 06: Alters Module 01: Alters (Part: 01) 00:03:00 Module 02: Alters (Part: 02) 00:05:00 Module 03: Alters (Part: 03) 00:05:00 Unit 07: All about Joins and SQL Relations Module 01: Aliases 00:04:00 Module 02: Inner joins 00:07:00 Module 03: Left and right joins 00:06:00 Module 04: Unions 00:06:00 Unit 08: Wild Cards Module 01: Wild Cards (Part: 01) 00:07:00 Module 02: Wild cards (Part: 02) 00:05:00 Unit 09: More Advanced Areas of SQL Module 01: Views 00:09:00 Module 02: Creating Functions 00:07:00 Module 03: Triggers 00:09:00 Assignment Assignment - SQL 00:00:00