3918 Computing & IT courses in Rhondda delivered On Demand

Deal Price is Active; Save Now- £405! Offer Ends Soon; Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique Cloud Computing / CompTIA Cloud+ (CV0-002) Course might help you get there! Expand your expertise with high-quality training - study the Cloud Computing / CompTIA Cloud+ (CV0-002) and get an expertly designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the online training course. This Cloud Computing / CompTIA Cloud+ (CV0-002) online training course is accredited by CPD with 15 CPD points for professional development. Students can expect to complete this training course in around 11 hours. You'll also get dedicated expert assistance from us to answer any queries you may have while studying our course. The course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the course, you will receive an instant e-certificate as proof of the comprehensive skill development and competency. Add these amazing new skills to your resume and boost your employability by simply enrolling on this course. With this comprehensive Cloud Computing / CompTIA Cloud+ (CV0-002) course, you can achieve your dreams and train for your ideal career. The course provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development. You'll get a Free Student ID card by enrolling in this Cloud Computing / CompTIA Cloud+ (CV0-002) course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. Enrolling on the Cloud Computing / CompTIA Cloud+ (CV0-002) course will ensure that you land your dream career faster than you thought possible. Stand out from the crowd and train for the job you want with the program. Experts created the Cloud Computing / CompTIA Cloud+ (CV0-002) course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you. Start your learning journey straight away with this Cloud Computing / CompTIA Cloud+ (CV0-002) course and take a step toward a brighter future! Why Prefer this course? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standards-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support *** Course Curriculum *** Cloud Computing / CompTIA Cloud+ (CV0-002) Course Section 01: What You Need to Know Section 02: Introducing the Cloud Section 03: System Requirements for Cloud Deployments Section 04: Cloud Storage Section 05: Cloud Compute Section 06: Cloud Networking Section 07: Cloud Security Section 08: Migrating to the Cloud Section 09: Maintaining Cloud Solutions Section 10: Troubleshooting Cloud Solutions Assessment Process Once you have completed all the modules in the Cloud Computing / CompTIA Cloud+ (CV0-002) course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. Show off Your New Skills with a Certificate of Completion The learners have to complete the assessment of this Cloud Computing / CompTIA Cloud+ (CV0-002) course to achieve the CPD accredited certificate. Digital certificates can be ordered for only £10. The learner can purchase printed hard copies inside the UK for £29, and international students can purchase printed hard copies for £39. CPD 15 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career.

Overview This comprehensive course on ITIL Practitioner will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This ITIL Practitioner comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this ITIL Practitioner. It is available to all students, of all academic backgrounds. Requirements Our ITIL Practitioner is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 9 sections • 52 lectures • 07:37:00 total length •Course Introduction!: 00:14:00 •Learning Objectives: 00:06:00 •Selecting a Management System: 00:11:00 •Systems Thinking: 00:13:00 •The 4Ps: 00:14:00 •Communication & Management Systems: 00:14:00 •Organizational Capabilities: 00:10:00 •Adopt, Adapt & Realize: 00:15:00 •Outside-in vs Inside-out Thinking: 00:11:00 •Defining a Service: 00:05:00 •Metrics & Measurement: 00:07:00 •Improvement, the Practitioner & CSI: 00:10:00 •Driving IT Service Management Summary: 00:15:00 •Checkpoint: 00:16:00 •Learning Objectives: 00:04:00 •Principles: 00:24:00 •Themes: 00:09:00 •Principles & Themes in Practice: 00:08:00 •Principles & Themes Summary: 00:03:00 •Checkpoint: 00:07:00 •Learning Objectives: 00:02:00 •Role & Impact of OCM on Improvement: 00:07:00 •OCM Activities: 00:16:00 •OCM & Systems Thinking: 00:06:00 •OCM Summary: 00:05:00 •Checkpoint: 00:10:00 •Learning Objectives: 00:01:00 •Value, Importance & Benefit of Good Communication: 00:05:00 •Principles of Communication: 00:11:00 •Role of Influence: 00:07:00 •Communication Summary: 00:05:00 •Checkpoint: 00:09:00 •Learning Objectives: 00:02:00 •CSFs, KPIs & Improvement: 00:18:00 •Analyze CSFs & KPIs in Context: 00:09:00 •Assessments: 00:04:00 •Use Metrics & Measurement Summary: 00:05:00 •Design a Report: 00:07:00 •Checkpoint: 00:08:00 •Learning Objectives: 00:02:00 •It Depends: 00:09:00 •Approach Deconstructed: 00:25:00 •Goal Question Metric (GQM) Approach Introduction: 00:08:00 •CSI Approach Summary: 00:05:00 •Checkpoint: 00:07:00 •Learning Objectives: 00:01:00 •CSI Approach for the ITIL Practitioner: 00:07:00 •CSI Approach in ITIL: 00:25:00 •CSI Approach, PRINCE2 & RESILIA: 00:06:00 •Integrating CSI with ITIL & Beyond Summary: 00:03:00 •Checkpoint: 00:06:00 •Workbooks - ITIL Practitioner - Video Training Course: 00:00:00

Overview This comprehensive course on Electronic Document Management System Step will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Electronic Document Management System Step comes with accredited certification, which will enhance your CV and make you worthy in the job market.So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Electronic Document Management System Step . It is available to all students, of all academic backgrounds Requirements Our Electronic Document Management System Step is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 6 lectures • 00:56:00 total length •Module 01: Introduction: 00:05:00 •Module 02: Role and Important of Document Controller: 00:13:00 •Module 03: Document and Record management: 00:06:00 •Module 04: Document Management Best Practices: 00:04:00 •Module 05: Record Management Best Practices: 00:04:00 •Module 06: Introduction to EDMS (Enterprise Document Management System): 00:24:00

Overview This Management Level 5 course meticulously delves into understanding the complexities and nuances of modern leadership, catering to those keen on mastering the art of effective management. This course has been curated meticulously to offer insights into various facets of management and leadership. From understanding the fundamental theories that govern administration to honing skills like negotiation and communication, the curriculum is a comprehensive voyage through the disciplines that develop a proficient manager. One would also find a detailed exploration of contemporary issues like corporate responsibility and the nuances of navigating office politics, promising a well-rounded educational experience.In addition to managerial theories and practices, the Management Level 5 course is robustly equipped to impart essential technological skills. With extensive modules on Microsoft Word, Excel, and PowerPoint, learners are primed to excel in the modern digital workspace, harnessing the power of these tools to augment their managerial prowess. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Management Level 5. It is available to all students, of all academic backgrounds. Requirements Our Management Level 5 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 22 sections • 23 lectures • 04:37:00 total length •Understanding Management and Leadership: 00:40:00 •Leadership Theories: 00:25:00 •Improving Management and Leadership Performance: 00:15:00 •High Performance Teams: 00:32:00 •Motivating Employees: 00:26:00 •Organisational Skills: 00:26:00 •Talent Management: 00:37:00 •Succession Planning: 00:24:00 •Business Process Management: 00:28:00 •Communication Skills: 00:27:00 •Negotiation Techniques: 00:15:00 •Managing Meetings and Giving Feedback: 00:21:00 •Managing Change: 00:22:00 •Time Management: 00:06:00 •Stress Management: 00:15:00 •Emotional Intelligence in Leadership: 00:32:00 •Managing Conflict: 00:14:00 •Dealing with Office Politics: 00:34:00 •Risk Management: 00:35:00 •Corporate Responsibility and Ethics: 00:14:00 •Microsoft Word: 08:06:00 •Microsoft Excel: 03:59:00 •Microsoft PowerPoint: 08:24:00

Overview This comprehensive course on PAT Trainingwill deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This PAT Training comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this PAT Training . It is available to all students, of all academic backgrounds. Requirements Our PAT Trainingis fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more Course Curriculum 15 sections • 16 lectures • 06:35:00 total length •Introduction to PAT: 00:25:00 •Relevant Statutory Provisions for PAT: 00:25:00 •Safety Responsibilities & Maintenance Provisions: 00:20:00 •Risk Assessment: 00:30:00 •Reducing and Controlling Risks: 00:30:00 •Electrical Units and Appliance Classification: 00:20:00 •Equipment Coverage & Maintenance Needs: 00:25:00 •Initial Visual Examination: 00:25:00 •Initial Visual Examination: 00:25:00 •Instruments for Testing and Equipment Inspection: 00:20:00 •Electrical Installation Testing: 00:35:00 •Lead & RCD Testing: 00:20:00 •Safety Precautions in Electrical Testing: 00:30:00 •Reporting and Record-keeping: 00:25:00 •Testing for New or Used Equipment: 00:15:00 •British Standards and Latest Changes: 00:25:00

Sales and Marketing: Sales and Marketing Training Do you wish to master the sales and marketing diploma abilities to deliver the greatest potential outcome? We have prepared a very special sales and marketing diploma that can meet your interest. Multi-level marketing foundations are covered in this sales and marketing diploma, along with an overview. Sales tactics, team motivation, and sales concepts are all covered in this sales and marketing diploma. In addition, the sales and marketing diploma covers lead generation and prospecting techniques as well as training in face-to-face sales techniques. As a sales manager, this sales and marketing diploma also helps you develop your basic soft skills and body language. This sales and marketing diploma goes into detail about communication strategies, negotiation tactics, and internet marketing. So, without further delay, unlock your potential with our sales and marketing diploma! Main Course: Sales and Marketing Free Courses are included in this Sales and Marketing: Sales and Marketing Course Course 01: CRM Course 02: Negotiation Skills Special Offers of this Sales and Marketing: Sales and Marketing Course This Sales and Marketing Course includes a FREE PDF Certificate. Lifetime access to this Sales and Marketing Course Instant access to this Sales and Marketing: Sales and Marketing Course Get FREE Tutor Support from Monday to Friday in this Sales and Marketing: Sales and Marketing Course [ Note: Free PDF certificate as soon as completing the Sales and Marketing: Sales and Marketing course] Sales and Marketing: Sales and Marketing Training Industry Experts Designed this Sales and Marketing: Sales and Marketing Course into 14 detailed modules. Detailed course curriculum of the Sales and Marketing: Sales and Marketing Course: Module 1: Marketing Basics Module 2: Multi-level Marketing Module 3: Sales Fundamental Module 4: 10 Sales Secrets Module 5: Motivating Sales Team Module 6: In-person Sales Module 7: Prospecting and Lead Generation Module 8: Coaching Salespeople Module 9: Basic Soft Skills Module 10: Basics of Body Language as Sales Manager Module 11: Communication Strategies Module 12: Internet Marketing Module 13: Negotiation Skills Module 14: Social Media Marketing Assessment Method Sales and Marketing: Sales and Marketing After completing each module of the Sales and Marketing: Sales and Marketing, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Sales and Marketing: Sales and Marketing After completing the MCQ/Assignment assessment for this Sales and Marketing: Sales and Marketing course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Sales and Marketing: Sales and Marketing Training The Sales and Marketing: Sales and Marketing is open to anyone with a strong desire to study sales and marketing. Requirements Sales and Marketing: Sales and Marketing Training Students who intend to enrol in this Sales and Marketing: Sales and Marketing course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path Sales and Marketing: Sales and Marketing Training This Sales and Marketing: Sales and Marketing will enable you to confidently grasp knowledge and abilities to advance your career in the appropriate field of work. Certificates Certificate of completion Digital certificate - Included

Are you looking to enhance your Sales and Marketing Diploma skills? If yes, then you have come to the right place. Our comprehensive course on Sales and Marketing Diploma will assist you in producing the best possible outcome by mastering the Sales and Marketing Diploma skills. The Sales and Marketing Diploma is for those who want to be successful. In the Sales and Marketing Diploma, you will learn the essential knowledge needed to become well versed in Sales and Marketing Diploma. Our Sales and Marketing Diploma starts with the basics of Sales and Marketing Diploma and gradually progresses towards advanced topics. Therefore, each lesson of this Sales and Marketing Diploma is intuitive and easy to understand. Why would you choose the Sales and Marketing Diploma from Compliance Central: Lifetime access to Sales and Marketing Diploma materials Full tutor support is available from Monday to Friday with the Sales and Marketing Diploma Learn Sales and Marketing Diploma skills at your own pace from the comfort of your home Gain a complete understanding of Sales and Marketing Diploma Accessible, informative Sales and Marketing Diploma learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Sales and Marketing Diploma bundle Study Sales and Marketing Diploma in your own time through your computer, tablet or mobile device. Learn at your own pace from the comfort of your home, as the rich learning materials of Sales and Marketing course are accessible from any place at any time. The curriculums are divided into tiny, bite-sized modules by industry specialists. And you will get answers to all your queries from our experts. So, enrol and excel in your career with Compliance Central. Curriculum Summary: Sales and Marketing Strategic Planning and Development Marketing Plan and Analysis Marketing Internal & External Analysis Market Segmentation, Targeting and Positioning Approach to Customer and Competitor Analysis CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Sales and Marketing Diploma helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Sales and Marketing Diploma. It is also great for professionals who are already working in Sales and Marketing Diploma and want to get promoted at work. Requirements To enrol in this Sales and Marketing Diploma, all you need is a basic understanding of the English Language and an internet connection. Career path The Sales and Marketing Diploma will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Sales and Marketing Diploma. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Master React and Redux with our comprehensive App Development Training course. Learn to build dynamic web applications, manage state, and integrate with backend services like Firebase. Ideal for aspiring UI/UX developers and frontend developers. Enroll now to start your journey in app development!

Embark on a transformative journey into the realm of emotional mastery with our course, 'Dialectical Behaviour Therapy (DBT) for Emotional Well-being'. This enlightening voyage through the intricacies of DBT will not only illuminate the path to personal emotional regulation but also equip you with the skills to facilitate others in their journey towards emotional well-being. Your exploration begins with an in-depth introduction to DBT, guiding you through its foundational principles and establishing a robust platform upon which to build your therapeutic skills. As you traverse through the carefully crafted modules, you'll delve into the core skills of mindfulness, emotion regulation, interpersonal effectiveness, and distress tolerance, each a vital beacon in the DBT landscape. These pillars of DBT are not merely theoretical constructs but practical tools, designed to be applied in real-world scenarios, ensuring that individuals can navigate through the emotional tumult of life with grace and resilience. Your journey will also guide you through the application of DBT across various populations, ensuring a versatile and adaptable therapeutic skill set. Learning Outcomes Understand and apply the foundational principles and techniques of dialectical behaviour therapy. Utilise mindfulness, emotion regulation, interpersonal effectiveness, and distress tolerance skills in therapeutic contexts. Implement DBT strategies effectively across various populations and diverse emotional challenges. Apply DBT in clinical settings, ensuring therapeutic interventions are both relevant and impactful. Navigate through ethical and professional considerations, ensuring DBT practice is conducted with integrity and adheres to professional standards. Why buy this Dialectical Behaviour Therapy (DBT) for Emotional Well-being? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success Who is this Dialectical Behaviour Therapy (DBT) for Emotional Well-being for? Individuals seeking personal emotional mastery and well-being through DBT. Mental health professionals aspiring to expand their therapeutic toolkit with DBT. Social workers desiring to provide enhanced emotional support to their clients. Counsellors looking to diversify their therapeutic approaches with validated techniques. Psychology students wishing to deepen their understanding and application of therapeutic modalities. Career path DBT Therapist: £30,000 - £45,000 Mental Health Counsellor: £23,000 - £40,000 Clinical Psychologist: £39,000 - £82,000 Social Worker: £25,000 - £40,000 Psychotherapist: £26,000 - £48,000 Mental Health Nurse: £25,000 - £35,000 Prerequisites This Dialectical Behaviour Therapy (DBT) for Emotional Well-being does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 1: Introduction to DBT Introduction to DBT 00:19:00 Module 2: Mindfulness Skills Training Mindfulness Skills Training 00:20:00 Module 3: Emotion Regulation Skills Emotion Regulation Skills 00:19:00 Module 4: Interpersonal Effectiveness Skills Interpersonal Effectiveness Skills 00:16:00 Module 5: Distress Tolerance Skills Distress Tolerance Skills 00:26:00 Module 6: Application of DBT in Specific Populations Application of DBT in Specific Populations 00:29:00 Module 7: Implementation of DBT in Clinical Settings Implementation of DBT in Clinical Settings 00:28:00 Module 8: Ethical and Professional Considerations in DBT Practice Ethical and Professional Considerations in DBT Practice 00:19:00

In an era awash with data, understanding it is the key to unlocking significant opportunities. Enter the realm of 'SQL For Data Analytics & Database Development'. Dive deep into the heart of data manipulation, exploration, and insight generation. This course unfurls the magic behind SQL, drawing back the curtain on the tools that empower businesses globally. Understanding SQL's profound capabilities opens doors to a world where data-driven decision-making is not just an advantage but an imperative. It isn't simply about data storage. This course unravels the art of analytics, shedding light on how to glean valuable insights from vast data lakes. The path of SQL isn't merely technical; it's the spine of transformative decisions in today's leading industries. Offering a systematic approach to database development, we invite you to embark on this illuminative journey, stitching the threads of raw data into the fabric of meaningful stories. Come harness the power of SQL. Whether your intent is data analytics or the intricate craft of database development, this is your gateway. Let us guide you, from the rudimentary steps to mastering advanced commands, constructing your data narrative, and informing the future. Learning Outcomes: Comprehend the fundamental architecture of SQL and its environment. Acquire proficiency in basic and advanced SQL statements. Understand and implement GROUP BY statements for data aggregation. Master the concepts and applications of JOINS in databases. Cultivate the ability to create and structure databases and tables. Delve into advanced SQL commands, enhancing data manipulation and querying capabilities. Construct efficient database models, fostering optimal data storage and retrieval.   Video Playerhttps://studyhub.org.uk/wp-content/uploads/2021/03/SQL-DATA-ANALYSIS.mp400:0000:0000:00Use Up/Down Arrow keys to increase or decrease volume. Why choose this SQL For Data Analytics & Database Development course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the SQL For Data Analytics & Database Development Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this SQL For Data Analytics & Database Development course for? Aspirants seeking to transition into data-driven roles in various industries. Database administrators aiming to broaden their analytical capabilities. Business analysts eager to enhance their data querying skills. Researchers in need of comprehensive data management tools. Tech enthusiasts wanting to grasp the underpinnings of database systems. Career path Data Analyst - Average salary: £35,000 - £50,000 Per Annum Database Developer - Average salary: £40,000 - £55,000 Per Annum Business Intelligence Analyst - Average salary: £38,000 - £52,000 Per Annum SQL Developer - Average salary: £42,000 - £58,000 Per Annum Database Administrator (DBA) - Average salary: £45,000 - £60,000 Per Annum Data Engineer - Average salary: £47,000 - £63,000 Per Annum Prerequisites This SQL For Data Analytics & Database Development 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Course Introduction Introduction 00:04:00 Course Curriculum Overview 00:05:00 Overview of Databases 00:10:00 SQL Environment Setup MySQL Installation 00:16:00 MySQL Workbench Installation 00:09:00 Connecting to MySQL using Console 00:09:00 SQL Statement Basics Overview of Challenges 00:04:00 SQL Statement Basic 00:16:00 SELECT Statement 00:09:00 SELECT DISTINCT 00:05:00 Column AS Statement 00:12:00 COUNT built-in Method usage 00:11:00 SELECT WHERE Clause - Part One 00:05:00 SELECT WHERE Clause - Part Two 00:11:00 SQL Statement Basic 00:16:00 SQL Limit Clause Statement 00:09:00 SQL Using BETWEEN with Same Column Data 00:11:00 How to Apply IN Operator 00:11:00 Wildcard Characters with LIKE and ILIKE 00:11:00 GROUP BY Statements Overview of GROUP BY 00:06:00 Aggregation function SUM() 00:09:00 Aggregation MIN() and MAX() 00:05:00 GROUP BY - One 00:09:00 GROUP BY - Two 00:12:00 HAVING Clause 00:05:00 JOINS Overview of JOINS 00:04:00 Introduction to JOINS 00:04:00 AS Statement table 00:03:00 INNER Joins 00:14:00 FULL Outer Join 00:11:00 LEFT Outer JOIN 00:08:00 RIGHT JOIN 00:08:00 Union 00:07:00 Advanced SQL Commands / Statements Timestamps 00:12:00 EXTRACT from timestamp 00:10:00 Mathematical Functions 00:12:00 String Functions 00:22:00 SUBQUERY 00:13:00 Creating Database and Tables Basic of Database and Tables 00:06:00 DataTypes 00:10:00 Primarykey and Foreignkey 00:06:00 Create Table in SQL Script 00:13:00 Insert 00:11:00 Update 00:07:00 Delete 00:04:00 Alter Table 00:09:00 Drop Table 00:05:00 NOT NULL Constraint 00:08:00 UNIQUE Constraint 00:09:00 Databases and Tables Creating a Database backup 00:12:00 10a Overview of Databases and Tables 00:05:00 10c Restoring a Database 00:07:00