2439 Courses

***24 Hour Limited Time Flash Sale*** Advanced Computer Science Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive Advanced Computer Science Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Advanced Computer Science bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Advanced Computer Science Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Advanced Computer Science Career Bundle: Course 01: Computer Science With Python Course 02: Python Programming for Everybody Course 03: C++ Development: The Complete Coding Guide Course 04: Coding with HTML, CSS, & Javascript Course 05: JavaScript Foundations for Everyone Course 06: SQL Programming Masterclass Course 07: SQL for Data Science, Data Analytics and Data Visualization Course 08: Ionic & Angular JS: Mobile and Web Development Course 09: Secure Programming of Web Applications - Developers and TPMs Course 10: Web Application Penetration Testing Course 11: Diploma in CompTIA Network+ Training Level 7 Course 12: CompTIA PenTest+ (Ethical Hacking) Course 13: Cloud Computing / CompTIA Cloud+ (CV0-002) Course 14: R Programming for Data Science Course 15: Quick Data Science Approach from Scratch Course 16: Ionic & Angular JS: Mobile and Web Development Course 17: Machine Learning with Python Course Course 18: Spatial Data Visualization and Machine Learning in Python Course 19: Azure Machine Learning Course 20: Hands on Machine Learning Project - Auto Image Captioning for Social Media Course 21: JavaScript Project - Game Development with JS Course 22: Ultimate PHP & MySQL Web Development & OOP Coding Course 23: Masterclass Bootstrap 5 Course - Responsive Web Design Course 24: Diploma in User Experience UI/UX Design (Advanced) Course 25: Foundations of Artificial Intelligence Course 26: Project on Deep Learning - Artificial Neural Network Course 27: Encryption Course 28: Advanced Training on Windows 10 Course 29: Advance Windows 10 Troubleshooting for IT HelpDesk Course 30: Linux With Advanced Computer Science, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Don't let this opportunity pass you by. Enrol in Advanced Computer Science today and take the first step towards achieving your goals and dreams. Why buy this Advanced Computer Science? Free CPD Accredited Certificate upon completion of Advanced Computer Science Get a free student ID card with Advanced Computer Science Lifetime access to the Advanced Computer Science course materials Get instant access to this Advanced Computer Science course Learn Advanced Computer Science from anywhere in the world 24/7 tutor support with the Advanced Computer Science course. Start your learning journey straightaway with our Advanced Computer Science Training! Advanced Computer Science premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of Advanced Computer Science is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Advanced Computer Science course. After passing the Advanced Computer Science exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Advanced Computer Science course is ideal for: Students seeking mastery in Advanced Computer Science Professionals seeking to enhance Advanced Computer Science skills Individuals looking for a Advanced Computer Science-related career. Anyone passionate about Advanced Computer Science Requirements This Advanced Computer Science doesn't require prior experience and is suitable for diverse learners. Career path This Advanced Computer Science bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

This course will help you master Spring, Spring Boot, Spring Modules - JDBC, AOP, and Data JPA through a hands-on, step-by-step approach. You will also be introduced to unit testing with JUnit and Mockito and learn how to communicate with the database using the Spring framework.

Earn up to 75k as a 'IT Technician' or Your 100% Money Back Thinking about a career in IT? The UK tech sector is booming, with over 2 million IT professionals employed and a projected growth of 12% in the next five years! The average IT Technician salary is £35,000, making it a lucrative and rewarding career choice. But where do you start? Our IT Technician Courses Including Job Opportunity Programme is here to guide you all the way until you get the job you want. Our IT Technician Courses Including Job Opportunity Programme is your all-in-one solution to learn 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 a IT technician. By choosing our IT Technician Courses Including Job Opportunity 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 Technician Courses Including Job Opportunity today and start your journey to becoming a successful IT Technician! 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 Technician Courses: 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 experience, we will guide you towards honing your skills and developing a strong foundation in IT. One-On-One Consultation: Gain invaluable insights and guidance from seasoned professionals who have thrived in the IT Technician 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 Technicians. 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 Technician Course 02: Functional Skills IT Course 03: Data Center Training Essentials: General Introduction Course 04: Understanding Data Protection and Data Security Course 05: CompTIA Network Course 06: CompTIA IT Fundamentals ITF+ (FCO-U61) Course 07: CompTIA A+ (220-1001) Course 08: CompTIA A+ (220-1002) Course 09: CompTIA Network+ Certification (N10-007) Course 10: CompTIA Security+ (SY0-601) Course 11: Cloud Computing / CompTIA Cloud+ (CV0-002) Course 12: CompTIA CySA+ Cybersecurity Analyst (CS0-002) Course 13: CompTIA PenTest+ (Ethical Hacking) Course 14: Secure Programming of Web Applications Course 15: Document Control Course 16: Information Management Course 17: Cyber Security Law Course 18: 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 completed in 9 easy steps: Step 1: Enrol in the Programme Begin your exciting journey with us by enrolling in the IT Technician Courses. 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 18 Premium Courses related to T Technician. These courses will teach you the knowledge and skills required to become a successful T Technician. 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 IT , 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 as an IT Technician begins with us. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This IT Technician Course Including the Job Opportunity 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's extensive usage. IT professionals are seeking to diversify their skill sets and stay relevant in today's tech-driven market. Data analysts and scientists who want to leverage IT's powerful libraries for their data processing needs. Students and recent graduates are looking to enhance their employability in the thriving tech industry. Entrepreneurs who wish to understand and utilise IT to automate tasks and analyse data for their businesses. Anyone with a keen interest in IT 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 Technician: £20,000 - £50,000 annually Network Administrator: £25,000 - £70,000 annually Cyber Security Analyst: £35,000 - £85,000 annually Data Center Technician: £30,000 - £75,000 annually Cloud Solutions Architect: £40,000 - £100,000 annually Ethical Hacker/Penetration Tester: £35,000 - £90,000 annually Information Security Manager: £45,000 - £110,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

Give a compliment to your career and take it to the next level. This Data Science will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Data Sciencebundle will help you stay ahead of the pack. Throughout the Data Scienceprogramme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Data Science course, you will get 10 premium courses, an originalHardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This Data Science Bundle Consists of the following Premium courses: Course 01: Data Science with Python Course 02: Data Science & Machine Learning with Python Course 03: R Programming for Data Science Course 04: Python for Data Analysis Course 05: Machine Learning for Predictive Maps in Python and Leaflet Course 06: Learn to Use Python for Spatial Analysis in ArcGIS Course 07: Python Programming for Everybody Course 08: Encryption Course 09: GDPR Data Protection Level 5 Course 10: Decision Making and Critical Thinking Course 11: Time Management Enrol now in Data Science to advance your career, and use the premium study materials from Apex Learning. Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Data Scienceexpertise and essential knowledge, which will assist you in reaching your goal. Curriculum: Course 01: R Programming for Data Science Unit 01: Data Science Overview Unit 02: R and RStudio Unit 03: Introduction to Basics Unit 04: Vectors Unit 05: Matrices Unit 06: Factors Unit 07: Data Frames Unit 08: Lists Unit 09: Relational Operators Unit 10: Logical Operators Unit 11: Conditional Statements Unit 12: Loops Unit 13: Functions Unit 14: R Packages Unit 15: The Apply Family - lapply Unit 16: The apply Family - sapply & vapply Unit 17: Useful Functions Unit 18: Regular Expressions Unit 19: Dates and Times Unit 20: Getting and Cleaning Data Unit 21: Plotting Data in R Unit 22: Data Manipulation with dplyr And much more... CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Data Science bundle. Requirements This Data Science course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (R Programming for Data Science) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Learn Database Driven Web Development With Django and Python!

Course Overview Discover the best way to learn about programming skills and Start Your Coding Journey with Scratch. Scratch is the simplified block-based visual programming language and website for children between 8 and 16 years of age. In effect, these 'Scratchers' are tomorrow's leading coders and IT technicians. Whether you are an educator or a student, this introductory course displays the advantages of this innovative tool and what it can bring to computer studies. This clever Coding tutorial delivers a masterclass on Scratch's broad range of functions and uses. The entire learning curve is provided, from manipulating sprites to creating sounds. Alongside this, the tuition consists of sample activity to ensure gained skills are in line with the full potential of Scratch itself. All in all, this is excellent to be introduced or learn about the capabilities of this platform. This best selling Start Your Coding Journey with Scratch has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Start Your Coding Journey with Scratch is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Start Your Coding Journey with Scratch is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Start Your Coding Journey with Scratch is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Start Your Coding Journey with Scratch, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Start Your Coding Journey with Scratch will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Start Your Coding Journey with Scratch to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Duration 3 Days 18 CPD hours This course is intended for This course is designed for software developers, testers, and architects who design and develop software in various programming languages and platforms, including desktop, web, cloud, and mobile, and who want to improve their ability to deliver software that is of high quality, particularly regarding security and privacy. This course is also designed for students who are seeking the CertNexus Cyber Secure Coder (CSC) Exam CSC-210 certification Overview In this course, you will employ best practices in software development to develop secure software.You will: Identify the need for security in your software projects. Eliminate vulnerabilities within software. Use a Security by Design approach to design a secure architecture for your software. Implement common protections to protect users and data. Apply various testing methods to find and correct security defects in your software. Maintain deployed software to ensure ongoing security... The stakes for software security are very high, and yet many development teams deal with software security only after the code has been developed and the software is being prepared for delivery. As with any aspect of software quality, to ensure successful implementation, security and privacy issues should be managed throughout the entire software development lifecycle. This course presents an approach for dealing with security and privacy throughout the entire software development lifecycle. You will learn about vulnerabilities that undermine security, and how to identify and remediate them in your own projects. You will learn general strategies for dealing with security defects and misconfiguration, how to design software to deal with the human element in security, and how to incorporate security into all phases of development. Identifying the Need for Security in Your Software Projects Identify Security Requirements and Expectations Identify Factors That Undermine Software Security Find Vulnerabilities in Your Software Gather Intelligence on Vulnerabilities and Exploits Handling Vulnerabilities Handle Vulnerabilities Due to Software Defects and Misconfiguration Handle Vulnerabilities Due to Human Factors Handle Vulnerabilities Due to Process Shortcomings Designing for Security Apply General Principles for Secure Design Design Software to Counter Specific Threats Developing Secure Code Follow Best Practices for Secure Coding Prevent Platform Vulnerabilities Prevent Privacy Vulnerabilities Implementing Common Protections Limit Access Using Login and User Roles Protect Data in Transit and At Rest Implement Error Handling and Logging Protect Sensitive Data and Functions Protect Database Access Testing Software Security Perform Security Testing Analyze Code to find Security Problems Use Automated Testing Tools to Find Security Problems Maintaining Security in Deployed Software Monitor and Log Applications to Support Security Maintain Security after Deployment

Are you interested in pursuing a career in the AutoCAD Draughtsperson industry or learning more about it? If yes, then you have come to the right place. Our comprehensive courses on AutoCAD Draughtsperson will assist you in producing the best possible outcome by learning the AutoCAD Draughtsperson skills. The AutoCAD Draughtsperson bundle is for those who want to be successful. In the AutoCAD Draughtsperson bundle, you will learn the essential knowledge needed to become well versed in AutoCAD Draughtsperson. Why would you choose the AutoCAD Draughtsperson course from Compliance Central: Lifetime access to AutoCAD Draughtsperson courses materials Full tutor support is available from Monday to Friday with the AutoCAD Draughtsperson course Learn AutoCAD Draughtsperson skills at your own pace from the comfort of your home Gain a complete understanding of AutoCAD Draughtsperson course Accessible, informative AutoCAD Draughtsperson learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the AutoCAD Draughtsperson bundle Study AutoCAD Draughtsperson in your own time through your computer, tablet or mobile device Our AutoCAD Draughtsperson bundle starts with the basics of AutoCAD Draughtsperson and gradually progresses towards advanced topics. Therefore, each lesson of this AutoCAD Draughtsperson is intuitive and easy to understand. Courses in this AutoCAD Draughtsperson Bundle: Course 01: CAD Course 02: CAD Design Course: Assemblies, Modelling And Civil Drawings Course 03: AutoCAD VBA Programming Course 04: AutoCAD to Excel - VBA Programming Hands-On! Course 05: Read Construction & Structural Drawing Like Expert Course 06: Learn AutoCAD Programming using VB.NET - Hands-On! Course 07: Architectural & Interior Design: Modern and International Design Course 08: Structural Design: LEED V4.1 Building Design and Construction Course 09: Revit Architecture Ultimate Interior Design Course Course 10: Revit Architecture Ultimate Exterior Design for Beginners Course 11: Solidworks Foundation Training Course 12: Architectural Studies CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The AutoCAD Draughtsperson bundle helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in AutoCAD Draughtsperson. Requirements To enrol in this AutoCAD Draughtsperson course, all you need is a basic understanding of the English Language and an internet connection. Career path The AutoCAD Draughtsperson bundle will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to AutoCAD Draughtsperson. Certificates 12 CPD Accredited PDF Certificate Digital certificate - Included Each CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD accredited hard copy certificates are available for £10.79 each Delivery Charge for Each Hard Copy Certificates: Inside the UK: Free Outside of the UK: £9.99 each

This course will take you from the basic structure of ASP.Net Core 5 to building and enhancing a functional website. You will deep dive into the concepts by creating a product catalog, connecting your application to a database, sending emails from your application, integrating a secure payment system into your application, and a lot 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.