5598 Computing & IT courses in Leeds delivered Online

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

PAT Testing: PAT Testing Training Online Do you want to prevent workplace hazards? If so then join our PAT Testing: PAT Testing Training Training course to learn about electrical fires, electrical shocks or other hazards and be aware of how to perform maintenance check-ups. This PAT Testing: PAT Testing Training course is designed to help you familiarize yourself with testing technical appliances. Also, this PAT Testing: PAT Testing Training course teaches you to be able to know how to assess and minimize risks. Throughout the PAT Testing: PAT Testing (Portable Appliance Testing) course, you can learn to carry out inspections by using a PAT Testing: PAT Testing device. Overall, the PAT Testing: PAT Testing (Portable Appliance Testing) course helps to understand the safety procedures that need to be in place when using portable appliances at work. Enrol the PAT Testing: PAT Testing Training course to ensure a low-risk and healthy workplace. Special Offers of this PAT Testing: PAT Testing Training Course: This PAT Testing: PAT Testing Training Course includes a FREE PDF Certificate. Lifetime access to this PAT Testing: PAT Testing Training Course Instant access to this PAT Testing: PAT Testing Training Course 24/7 Support Available to this PAT Testing: PAT Testing Training Course PAT Testing: PAT Testing Training Online This PAT Testing: PAT Testing Training (Portable Appliance Testing) course is designed to help you familiarise yourself with testing technical appliances. Also, this PAT Testing: PAT Testing Training (Portable Appliance Testing) course teaches you to be able to know how to assess and minimise risks. Throughout the PAT Testing: PAT Testing Training (Portable Appliance Testing) course, you can learn to carry out inspections by using a PAT Testing: PAT Testing device. Overall, the PAT Testing: PAT Testing Training (Portable Appliance Testing) course helps to understand the safety procedures that need to be in place when using portable appliances at work. Course Completion Certificate After Completing this PAT Testing: PAT Testing Training Course, you will receive a CPD Certified PAT Testing: PAT Testing Training Course from School of Health Care. You will also obtain a PAT Testing: PAT Testing Training Course completion certificate from Reed. Who is this course for? PAT Testing: PAT Testing Training Online Electricians, appliance servicers, equipment testers or any inspiring individual can take this PAT Testing: PAT Testing Training course. Requirements PAT Testing: PAT Testing Training Online To enrol in this PAT Testing: PAT Testing Training Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our PAT Testing: PAT Testing Training Course. Be energetic and self-motivated to complete our PAT Testing: PAT Testing Training Course. Basic computer Skill is required to complete our PAT Testing: PAT Testing Training Course. If you want to enrol in our PAT Testing: PAT Testing Training Course, you must be at least 15 years old. Career path PAT Testing: PAT Testing Training Online This PAT Testing: PAT Testing Training course helps to explore opportunities such as PAT Tester Appliance Tester Appliance Servicer Appliance Repairer Electrician Equipment Tester

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special C# Programming Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The C# Programming Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This C# Programming Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This C# Programming Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this C# Programming? Unlimited access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance 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 C# Programming 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 free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This C# Programming 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 skills. Prerequisites This C# Programming does not require you to have any prior qualifications or experience. You can just enroll and start learning. This C# Programming was made by professionals and it is compatible with all PCs, Macs, 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 a bonus, you will be able to pursue multiple occupations. This C# Programming is a great way for you to gain multiple skills from the comfort of your home.  

Boost your medical career! Master clinical coding, ace medical administration. Enhance patient care, be a healthcare ace. Start your transformative journey now!

Understand how Docker works and learn its core features with this hands-on course. This is 90% practice without any useless demos! Learn how to create different containers such as Node.js, Python, WordPress, MongoDB, MySQL, Redis, Elasticsearch, and much more.

Our Aim Is Your Satisfaction! Offer Ends Soon; Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique Data Analytics with Tableau course might help you get there! Expand your expertise with high-quality training - study the Data Analytics with Tableau course 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 theonline training course. The Data Analytics with Tableau 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 Data Analytics with Tableau course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this course. This Data Analytics with Tableau training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer Us? Opportunity to earn a certificate accredited by CPDQS. Get a free student ID card!(£10 postal charge will be applicable for international delivery) Innovative and Engaging Content. Free Assessments 24/7 Tutor Support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Data Analytics with Tableau course: Data Analytics with Tableau Module 01: Introduction to the Course Module 02: Project 1: Discount Mart (Sales and Profit Analytics) Module 03: Project 2: Green Destinations (HR Analytics) Module 04: Project 3: Superstore (Sales Agent Tracker) Module 05: Northwind Trade (Shipping Analytics) Module 06: Project 5: Tesla (Stock Price Analytics) Module 07: Bonus: Introduction to Database Concepts Module 08: Tableau Stories Assessment Process Once you have completed all the modules in the Data Analytics with Tableau course, you can assess your skills and knowledge with an optional assignment. Certificate of Completion The learners have to complete the assessment of this Data Analytics with Tableau course to achieve the CPDQS accredited certificate. Digital Certificate: £10 Hard Copy Certificate: £29 (Inside UK) Hard Copy Certificate: £39 (for international students) CPD 150 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 Data Analytics with Tableau 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 With the advancement of AI technologies NLP or Natural Language Processing has become a highly valuable skill in the IT industry. Learn the fundamentals of NLP and get a step closer to building your dream career in the AI industry with our Online NLP Practitioner Training course. The course will help you develop a solid foundation in NLP. The course will provide you with detailed lessons on the pillars and principles of NLP. You will be able to learn about the communication and coaching models of NLP. In addition, you will get the chance to learn advanced techniques used in the communication and application process. At the end of the course, you will receive a certificate of achievement. This certificate will demonstrate your expertise in this area and increase your career potential. Join now! Course Preview Learning Outcomes Learn about the key principles of NLP Familairse yourself with NLP communication model Understand the different stages of NLP coaching model Grasp effective strategies for NLP communication Build your expertise in NLP application Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? NLP communication NLP application Who Should Take This Online NLP Practitioner Training? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Online NLP Practitioner Training is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99. Career Path​ This exclusive Online NLP Practitioner Training will equip you with effective skills and abilities and help you explore career paths such as  NLP Engineer Data Scientist NLP Product Manager Consultant Module 1: Introduction to NLP Introduction to NLP 00:17:00 Module 2: NLP Communication Model NLP Communication Model 00:20:00 Module 3: NLP Coaching Model NLP Coaching Model 00:26:00 Module 4: NLP Presuppositions and Beliefs NLP Presuppositions and Beliefs 00:21:00 Module 5: NLP Techniques for Personal Change NLP Techniques for Personal Change 00:26:00 Module 6: NLP Strategies for Effective Communication NLP Strategies for Effective Communication 00:28:00 Module 7: Advanced NLP Techniques Advanced NLP Techniques 00:21:00 Module 8: NLP Applications NLP Applications 00:17:00 Module 9: NLP Practitioner Certification NLP Practitioner Certification 00:15:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Cyber Security: Level 5 Diploma in Cyber Security Open up your Cyber Security passion by unlocking our Cyber Security course! Do you want to begin a career as a professional in Cyber Security? Do you want to expand your knowledge about Cyber Security? With the help of this Cyber Security course, you'll be more determined than ever to advance your professional career and broaden your knowledge in this Cyber Security area. Although they sound similar, information security and Cyber Security refer to different types of security. Information security refers to the practices and tools used to prevent unauthorised access to sensitive corporate data, whereas Cyber Security is the protection of digital data through computer network security. Even though maintaining Cyber Security may be expensive, a significant breach may cost a company far more. This Cyber Security Course will provide you with a solid foundation so that you can develop the confidence to become an expert in Cyber Security and acquire more sophisticated skills to fill in the gaps for increased effectiveness and productivity. If you think you have what it takes to enter this Cyber Security field, an Cyber Security course can help you with your initial training and job preparation. Cyber Security is ready with all the necessary data that is meant to instruct and direct people in the requirements for this position. Don't wait any longer. Enrol in our Cyber Security course to become a certified Cyber Security professional. Special Offers of this Cyber Security: Cyber Security Course This Cyber Security: Cyber Security Course includes a FREE PDF Certificate. Lifetime access to this Cyber Security: Cyber Security Course Instant access to this Cyber Security: Cyber Security Course Get FREE Tutor Support to this Cyber Security: Cyber Security Course Cyber Security: Level 5 Diploma in Cyber Security Understanding the nuances between Cyber Security and IT Security is essential for safeguarding your business. Our Cyber Security course dives into these critical distinctions—equipping you with the tools to prevent unauthorized access to sensitive data through best practices in Cyber Security and network defense. While investing in Cyber Security measures might seem costly, the price of a data breach can be exponentially higher, affecting finances, reputation, and trust. Join our Cyber Security training to strengthen your defenses and ensure comprehensive protection for your digital assets, enabling your company to thrive in today’s digital-first landscape. Who is this course for? Cyber Security: Level 5 Diploma in Cyber Security Anyone who wants to work in the Cyber industry can take our Cyber Security: Cyber Security course. Requirements Cyber Security: Level 5 Diploma in Cyber Security To enrol in this Cyber Security: Cyber Security Course, students must fulfil the following requirements. To join in our Cyber Security: Cyber Security Course, you must have a strong command of the English language. To successfully complete our Cyber Security: Cyber Security Course, you must be vivacious and self driven. To complete our Cyber Security: Cyber Security Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Cyber Security: Cyber Security Course. Career path Cyber Security: Level 5 Diploma in Cyber Security Many doors in the job market will be made available by the IT Security course. For instance, an IT technician, a cyber security analyst, or a penetration tester.The average salary for Cyber Security professionals in the UK ranges between £60,000 and £100,000 per annum.

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access