26207 Courses delivered Online

Understanding databases and SQL

With this hands-on video course, you'll gain a solid understanding of AWS, DevOps, and deployments at scale using ECS with the help of examples and activities. Throughout the course, you'll get to grips with a wide variety of AWS services.

Build a Portfolio of 12 Machine Learning Projects with Python, SVM, Regression, Unsupervised Machine Learning & More!

Duration 3 Days 18 CPD hours This course is intended for This is an introductory level SQL course, appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators. Overview Working in a hands on learning environment led by our expert practitioner, attendees will explore: Basic RDBMS Principles The SQL Language and Tools Using SQL Developer SQL Query Basics WHERE and ORDER BY Functions ANSI 92 Joins ANSI 99 Joins Subqueries Regular Expressions Analytics A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. A full presentation of the basics of relational databases and their use are also covered. Basic RDBMS Principles Relational design principles Accessing data through a structured query language Entity relationship diagrams Data Domains Null values Indexes Views Denormalization Data Model Review The SQL Language and Tools Using SQL*Plus Why Use SQL*Plus When Other Tools Are Available? Starting SQL*Plus EZConnect SQL Commands PL/SQL Commands SQL*Plus Commands The COLUMN Command The HEADING Clause The FORMAT Clause The NOPRINT Clause The NULL Clause The CLEAR Clause Predefined define variables LOGIN.SQL Command history Copy and paste in SQL*Plus Entering SQL commands Entering PL/SQL commands Entering SQL*Plus commands Default output from SQL*Plus Entering Queries What about PL/SQL? Using SQL Developer Choosing a SQL Developer version Configuring connections Creating A Basic Connection Creating A TNS Connection Connecting Configuring preferences Using SQL Developer The Columns Tab The Data Tab The Constraints Tab The Grants Tab The Statistics Tab Other Tabs Queries In SQL Developer Query Builder Accessing Objects Owned By Other Users The Actions Pulldown Menu Differences between SQL Developer and SQL*Plus Reporting Commands Missing In SQL Developer General Commands Missing In SQL Developer Data Dictionary report User Defined reports Using scripts in SQL Developer WHERE and ORDER BY WHERE clause basics Comparison operators Literals and Constants in SQL Simple pattern matching Logical operations The DUAL table Arithmetic operations Expressions in SQL Character operators Pseudo columns Order by clause basics Ordering Nulls Accent and case sensitive sorts Sampling data WHERE and ORDER BY in SQL Developer All, Any, Some Functions The basics of Oracle functions Number functions Character functions Date functions Conversion functions Other functions Large object functions Error functions The RR format mode; Leveraging your knowledge ANSI 92 JOINS Basics of ANSI 92 Joins Using Query Builder with multiple tables Table Aliases Outer joins Outer Joins In Query Builder Set operators Self-referential joins Non-Equijoins ANSI 99 Joins Changes with ANSI99 CROSS Join NATURAL Join JOIN USING JOIN ON LEFT / RIGHT OUTER JOIN FULL OUTER JOIN Subqueries Why use subqueries? WHERE clause subqueries FROM clause subqueries HAVING clause subqueries CORRELATED subqueries SCALAR subqueries DML and subqueries EXISTS subqueries Hierarchical queries TOP N AND BOTTOM N queries Creating subqueries using Query Builder Regular Expressions Available Regular Expressions Regular Expression Operators Character Classes Pattern matching options REGEX_LIKE REGEXP_SUBSTR REGEXP_INSTR REGEXP_REPLACE REGEXP_COUNT Analytics The WITH clause Reporting aggregate functions Analytical functions User-Defined bucket histograms The MODEL clause PIVOT and UNPIVOT Temporal validity More Analytics RANKING functions RANK DENSE_RANK CUME_DIST PERCENT_RANK ROW_NUMBER Windowing aggregate functions RATIO_TO_REPORT LAG / LEAD Linear Regression functions Inverse Percentile functions Hypothetical ranking functions Pattern Matching Additional course details: Nexus Humans Introduction to SQL Programming Basics (TTSQL002) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Introduction to SQL Programming Basics (TTSQL002) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Elevate your understanding of the business landscape with the "Sales, Marketing and Customer Relationship - Endorsed Certificate" bundle. This bundle combines three QLS-endorsed courses: Sales Training, Marketing Fundamentals, and Customer Relationship Management, offering you a profound theoretical understanding of these essential business pillars. Moreover, five additional CPD QS accredited courses enhance the core subjects. Learn about creating highly profitable sales funnels, sales negotiation, advanced marketing strategies, introduction to CPA Marketing, and strategies for landing a job in sales. Each QLS-endorsed course comes with a hardcopy certificate, confirming your knowledge acquisition in these critical business areas. Grasp this opportunity to understand the theories that underpin successful sales, marketing, and customer relationship management. Begin your journey towards mastering these business essentials today! Key Features of the Sales, Marketing and Customer Relationship - Endorsed Certificate Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Sales, Marketing and Customer Relationship - Endorsed Certificate bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Sales Training QLS Course 02: Marketing Fundamentals QLS Course 03: Customer Relationship Management 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Creating Highly Profitable Sales Funnels Course 02: Sales Negotiation Training Course Course 03: Marketing Strategies for Business Course 04: Introduction To CPA Marketing Course 05: Get a Job in Sales: Your Fast Track to Career Success In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Sales, Marketing and Customer Relationship - Endorsed Certificate courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes of the Sales, Marketing and Customer Relationship - Endorsed Certificate Bundle: Understand the theories behind effective sales techniques. Gain a fundamental understanding of marketing fundamentals. Learn about managing customer relationships effectively. Discover the principles of creating profitable sales funnels. Understand negotiation techniques in sales. Learn about the latest marketing strategies for businesses. Get a theoretical understanding of CPA Marketing. The "Sales, Marketing and Customer Relationship - Endorsed Certificate" bundle is a comprehensive learning package that offers deep theoretical insights into essential business disciplines. This combination of three QLS-endorsed courses and five CPD QS accredited courses offers a robust and well-rounded learning experience. Explore the theoretical foundations of sales, delve into the fundamentals of marketing, and understand the intricacies of managing customer relationships. Additionally, acquire knowledge about sales funnels, negotiation techniques, advanced marketing strategies, CPA Marketing, and strategies for securing a job in sales. Equip yourself with the knowledge to understand and navigate the business world. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen to understand the theoretical basis of sales, marketing, and customer relationship management. Business students seeking a well-rounded understanding of key business disciplines. Professionals wanting to enhance their theoretical knowledge in these areas. Entrepreneurs looking for a comprehensive understanding of essential business operations. Career path Sales Manager: £25,000 - £60,000 per year. Marketing Executive: £20,000 - £35,000 per year. Customer Relationship Manager: £25,000 - £55,000 per year. Sales Funnel Strategist: £30,000 - £60,000 per year. CPA Marketer: £25,000 - £60,000 per year. Sales Negotiator: £18,000 - £40,000 per year. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

***24 Hour Limited Time Flash Sale*** Nutrition (Diet, Body Weight and Sports Nutrition) QLS Endorsed Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Did you know that over 60% of adults in the UK are overweight or obese? Eating a healthy diet plays a crucial role in maintaining a healthy weight and overall well-being. But with so much conflicting information out there, it can be confusing to know what to eat. This Nutrition course bundle equips you with the knowledge and skills to navigate the world of nutrition with confidence. Are you ready to feel better, look better, and have more energy? Our comprehensive bundle offers a variety of courses to empower you on your nutritional journey. Learn about essential dietary principles, explore the science of superfoods, and gain insights into food allergies and intolerances. Discover how to craft personalized meal plans that support your health and fitness goals. Whether you're a fitness enthusiast, a busy professional, or simply looking to improve your diet, this bundle provides the tools and knowledge you need to make informed choices about what you eat. Key Features of the Nutrition (Diet, Body Weight and Sports Nutrition) QLS Endorsed Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Nutrition (Diet, Body Weight and Sports Nutrition) QLS Endorsed bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Diet and Nutrition QLS Course 02: The Complete Body Weight Workout Training QLS Course 03: Sports Coaching: Fitness & Nutrition 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Superfood Nutrition: 60+ Foods For Health & Fitness Course 02: Food Allergen Awareness Level 3 Course 03: Natural Nutrition: Naturopathy Course Course 04: Healthy Nutrition Masterclass: Diet & Meal Plan For Health Course 05: Functional Fitness Training In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Enrich your nutrition insight and prepare for an exciting career in the health and fitness industry with our thoughtfully curated bundle. With the theory-based yet profound lessons, you'll unlock a world of nutrition and fitness wisdom waiting to be discovered! Learning Outcomes of Nutrition (Diet, Body Weight and Sports Nutrition) Understand the fundamentals of diet, nutrition, and their impact on health. Master body weight training techniques for effective fitness routines. Gain insights into sports coaching, nutrition, and performance optimization. Explore the benefits of superfoods and natural nutrition approaches. Develop awareness of food allergens and their management strategies. Learn functional fitness training principles for overall physical conditioning. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Nutrition Get a free student ID card with Nutrition Training program (£10 postal charge will be applicable for international delivery) The Nutrition is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Nutrition course materials The Nutrition comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** QLS Course 01: Diet and Nutrition Module 01: Introduction To Diet And Nutrition Module 02: Macronutrients Module 03: Micronutrients Module 04: Food Consumption Trends In The UK Module 05: Nutrition For Pregnant Women Module 06: Nutrition For Children Module 07: Diet And Nutrition For Adolescence And Adulthood Module 08: Diet And Nutrition For Fitness And Sports- Part 1 Module 09: Diet And Nutrition For Fitness And Sports- Part 2 Module 10: Metabolism, Digestion & Absorption QLS Course 02: The Complete Body Weight Workout Training Unit 01: Introduction What will You Learn in this Course? Calisthenics Mindset Terms and Definitions Safety and Hazard How this Course is Organised Unit 02: Warmups From Top to Bottom Active-static Stretches Shoulders Core Unit 03: Movements Introduction Straight Arm Strength Basics Straight Arm Strength - Advanced Exercise Core Strength Basics Core Strength - Advanced Unit 04: Exercises Introduction Push-ups Dips Pull-ups Squats Unit 05: Conclusion What did We Learn in this Course? Intermediate Level Examination Example Exercises with Resistance Bands QLS Course 03: Sports Coaching: Fitness & Nutrition Module 01: Introduction to Sports Coaching Module 02: Skills and Responsibilities of Sports Coaches Module 03: Principles of Coaching Module 04: The Psychology of Sports Coaching - Part 1 Module 05: The Psychology of Sports Coaching - Part 2 Module 06: Physical Fitness for Athletes - Part 1 Module 07: Physical Fitness for Athletes - Part 2 Module 08: Coaching Football - Techniques Module 09: Coaching Football - Tactics Module 10: Coaching Strategies in Cricket =========>>>>> And 8 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £169) QLS Endorsed Hard Copy Certificate: Free (For The 3 QLS Courses: Previously it was £357) CPD 450 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 bundle. This Mental Health First Aid bundle is Ideal for: Fitness enthusiasts Busy professionals Weight loss seekers Health coaches Personal trainers Requirements You will not need any prior background or expertise to enrol in this Nutrition bundle. Career path After completing this Nutrition bundle, you are to start your career or begin the next phase of your career. Nutritionist Fitness Coach Health and Wellness Advisor Food Allergen Specialist Health Food Advisor Certificates Advanced Diploma in Sports & Fitness Coaching at QLS Level 6 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee. Certificate in Mental Health Through Diet and Nutrition at QLS Level 3 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee. CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free.

Master LINQ to entities, LINQ to objects, LINQ to XML, functional programming relying on LINQ

Earn up to 60k as a 'IT Security Analyst' or Your 100% Money Back The field of IT security is constantly developing, with the UK experiencing a considerable increase in cyber threats, emphasising the necessity for effective IT security measures. With over 800,000 IT security job openings expected by 2024 and an average salary of around £55,000 for IT Security professionals, the field is not just lucrative but also in high demand. This spike in demand highlights the critical need for qualified professionals capable of protecting digital infrastructures. Are you ready to tackle the complexity of IT security and make a difference? This IT Security Job Guarantee Programme is your all-in-one solution to learn IT Security from scratch and also secure a job in this exciting industry. With our unique blend of comprehensive courses and career support, your dream job is within reach. We understand the challenges of transitioning into a new field, which is why our program is tailored to guide you every step of the way - from mastering core skills to landing your first job as an IT security specialist. By choosing our IT Security Job Guarantee Programme, you're not just gaining skills; you're gaining a lifelong career partner. Our mission is simple - to be your trusted partner every step of the way, from training to employment. In addition to teaching you the technical skills you need, we will also provide you with career mentoring and support. We will help you build your resume, prepare for interviews, and land your dream job. We also have partnerships with many companies that are hiring Programmers, so we can help you get your foot in the door. If you are not happy with our service, we also offer a 100% money-back guarantee. So what are you waiting for? Enrol in our IT Security Job Guarantee Programme today and start your journey to become successful in the IT Security field! Why Choose Us? So, what sets us apart from other programs? Let's dive into the exceptional benefits you'll experience when you join our Certified IT Security Job Guarantee Programme: Personalised Guidance: We believe in the power of individual attention. Our experienced mentors will provide one-on-one counselling sessions tailored to your specific needs. Whether you're a beginner or have some IT Security experience, we will guide you towards honing your skills and developing a strong foundation in the IT Security field. One-On-One Consultation: Gain invaluable insights and guidance from seasoned professionals who have thrived in the IT Security field. Our consultation sessions provide you with insider tips, tricks, and advice, empowering you to navigate the industry with confidence and expertise. Extensive Job Opportunities: We have established partnerships with numerous companies actively seeking Certified IT Security Professional field. Through our network, we'll connect you with exclusive job openings that are not easily accessible elsewhere. Interview Preparation: No more stress over unexpected interview questions. We provide you with access to a comprehensive database of potential interview questions curated over years of industry experience. Walk into your interviews confident, well-prepared, and ready to impress. Courses we will provide once you enrol in the program: Course 01: IT Support Technician Course 02: Functional Skills IT Course 03: IT Administration and Networking Course 04: Cyber Security Programming Course 05: Cyber Security Advanced Training Course 06: Cyber Security Incident Handling and Incident Response Course 07: General Data Protection Regulation (GDPR) & Cyber Security Management Course 08: Data Center Training Essentials: General Introduction Course 09: Understanding Data Protection and Data Security Course 10: CompTIA Network Course 11: CompTIA IT Fundamentals ITF+ (FCO-U61) Course 12: CompTIA A+ (220-1001) Course 13: CompTIA A+ (220-1002) Course 14: CompTIA Network+ Certification (N10-007) Course 15: CompTIA Security+ (SY0-601) Course 16: Cloud Computing / CompTIA Cloud+ (CV0-002) Course 17: CompTIA CySA+ Cybersecurity Analyst (CS0-002) Course 18: CompTIA PenTest+ (Ethical Hacking) Course 19: Secure Programming of Web Applications Course 20: Cisco ASA Firewall Training Course 21: IGCSE ICT: Network Essentials Course 22: Information Management Course 23: Cyber Security Law Course 24: Cyber Security Incident Handling and Incident Response How Can We Offer Job Guarantees? HF Online provides consultancy, professional and educational services to many of the companies in the UK. During our intense exclusive training program, you will not just gain and complete the industry valuable certification but will gain industry experience as well, which is imperative to get your 1st job in the sector. The is IT Security Job Guarantee Programme completed in 9 easy steps: Step 1: Enrol in the Programme Begin your exciting journey with us by enrolling in the IT Security Job Guarantee Programme. Complete your registration and make a secure online payment. Remember, we offer a 14-day money-back guarantee if you're not completely satisfied. After you enrol in the Program, you will get lifetime access to 24 Premium Courses related to IT Security field. These courses will teach you the knowledge and skills required to become a successful IT Security Professional. Our customer service team will help you and keep in contact with you every step of the way. So you won't have to worry about a thing! Step 2: Initial One-On-One Counselling Session Once enrolled, you will be paired with a dedicated career mentor. Schedule your first one-on-one session to discuss your career aspirations, skills, experience, and any areas for potential growth. This conversation will shape your learning and development path. Step 3 - Certification upon Course Completion After learning from the courses, you must obtain certificates for each course. There will be exams for every course, and you have to pass them to get your certificate. To pass successfully, you must get 90% marks. Once you pass the exams, you will receive hardcopy certificates. These certificates will prove that you're an expert in the subject. Step 4: CV Revamping Our team of professionals will build you a compelling CV and LinkedIn profile. We'll ensure it presents your skills and qualifications effectively and is tailored to the needs and expectations of the programming/development industry. With these powerful tools in hand, you'll be fully prepared to tackle job interviews confidently. Step 5: Building Network and Submitting CV We understand the power of casting a wide net. We'll strategically submit your CV to various platforms and networks, expanding your reach and connecting you with valuable opportunities that align with your career goals. We will also make connections with many high-profile individuals and companies through your LinkedIn profile. Step 6: Interview Preparation With your CV ready, we'll move on to interview preparation. Gain exclusive access to our database of potential interview questions. Through simulated interviews with your mentor, you'll practice your responses and receive valuable feedback to further refine your skills. Step 7: Securing Job Interviews Leveraging our partnerships with leading companies, we'll secure job interviews for you. We'll ensure you get the opportunity to showcase your skills to potential employers and get the dream job you want. Step 8: Post-Interview Support Post-interview, we'll provide a debriefing session to reflect on your performance and identify areas of improvement for future interviews if necessary. Remember, our commitment extends until you land your dream job. Step 9: Celebrate Your New Job! Once you've secured your dream job in the IT Security field, it's time to celebrate! However, our support doesn't end there. We'll provide you with ongoing career advice to ensure you continue to thrive in your new role. We're excited to accompany you on this journey to success. Enrol today, and let's get started! Your path to a successful career in IT Security field begins with us. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This IT Security Job Guarantee Programme Course is suitable for: Beginners with no prior programming experience who are looking to enter the world of coding. Intermediate programmers who wish to expand their skills and explore IT Security's extensive usage. IT professionals seeking to diversify their skill sets and stay relevant in today's tech-driven market. Data analysts and scientists who want to leverage IT Security's powerful libraries for their data processing needs. Students and recent graduates looking to enhance their employability in the thriving tech industry. Entrepreneurs who wish to understand and utilise IT Security to automate tasks and analyse data for their businesses. Anyone with a keen interest in IT Security programming and a desire to delve into its applications in diverse fields like web development, data science, machine learning, and more. Requirements No experience required. Just enrol & start learning. Career path IT Support Specialist: £25,000 - £55,000 annually Network Administrator: £30,000 - £70,000 annually Cyber Security Consultant: £40,000 - £90,000 annually GDPR Compliance Officer: £35,000 - £75,000 annually Cloud Security Engineer: £45,000 - £100,000 annually Penetration Tester: £35,000 - £95,000 annually Cyber Security Incident Responder: £40,000 - £85,000 annually Certificates CPD Accredited e-Certificate Digital certificate - Included CPD Accredited Framed (Hardcopy) Certificate Hard copy certificate - Included Enrolment Letter Digital certificate - Included QLS Endorsed Hard Copy Certificate Hard copy certificate - Included Student ID Card Digital certificate - Included

Premium Bundle of all Time | Ofqual Regulation + ATHE Awards + CPD Accreditation | Assessment & Tutor Support Included

Premium Bundle of all Time | Ofqual Regulation + ATHE Awards + CPD Accreditation | Assessment & Tutor Support Included