936 Courses in Leicester delivered Online

Everywhere, from tiny businesses to major corporations, needs people skilled in SQL. In light of this, our online training course has been developed to help you succeed by equipping you with all the necessary skills. The importance of mastering SQL increases if you're looking for your first job in the data industry. You will learn about topics such as SQL fundamentals, data wrangling, SQL analysis, AB testing, distributed computing with Apache Spark, Delta Lake, and more through four increasingly more challenging SQL projects with data science applications. These subjects will equip you with the skills necessary to use SQL creatively for data analysis and exploration, write queries quickly, produce datasets for data analysis, conduct feature engineering, integrate SQL with other data analysis and machine learning toolsets, and work with unstructured data. This Specialisation is designed for a learner with little or no prior coding expertise who wants to become proficient with SQL queries. Experts have meticulously planned out the curriculum for the SQL Skills Training course with years of expertise. As a result, you will find it simple to learn the course material. Learning outcome After finishing the course, you'll Learn to utilise the tools for view creation Become familiar with updating columns and indexed views Be able to test and debug Be able to search a database using SQL Become more familiar with inline table-valued functions Learn the fundamentals of transactions and multiple statements Why Prefer US? 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 *** SQL Programming Course Module 01: Course Introduction Introduction Course Curriculum Overview Overview of Databases Module 02: SQL Environment Setup MySQL Installation MySQL Workbench Installation Connecting to MySQL using Console Module 03: SQL Statement Basics Overview of Challenges SQL Statement Basic SELECT Statement SELECT DISTINCT Column AS Statement COUNT built-in Method usage SELECT WHERE Clause - Part One SELECT WHERE Clause - Part Two Statement Basic Limit Clause Statement Using BETWEEN with Same Column Data How to Apply IN Operator Wildcard Characters with LIKE and ILIKE Module 04: GROUP BY Statements Overview of GROUP BY Aggregation function SUM() Aggregation MIN() and MAX() GROUP BY - One GROUP BY - Two HAVING Clause Module 05: JOINS Overview of JOINS Introduction to JOINS AS Statement table INNER Joins FULL Outer Join LEFT Outer JOIN RIGHT JOIN Union Module 06: Advanced SQL Commands / Statements Timestamps EXTRACT from timestamp Mathematical Functions String Functions SUBQUERY Module 07: Creating Database and Tables Basic of Database and Tables Data Types Primary key and Foreign key Create Table in SQL Script Insert Update Delete Alter Table Drop-Table NOT NULL Constraint UNIQUE Constraint Module 08: Databases and Tables Creating a Database backup 10a Overview of Databases and Tables 10c Restoring a Database CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course can be helpful for anyone working in the SQL fields, whether self-employed or employed, regardless of their career level. Requirements You will not need any prior background or expertise to enrol in this course. Career path The vocation of SQL Skills Training moves very quickly but pays well. This position provides unparalleled satisfaction. This is your opportunity to learn more and start changing things. Query Language Developer Server Database Manager Python Developer Technical Consultant Project Implementation Manager Software Developer (SQL) Certificates Certificate of completion Digital certificate - £10

Course Overview How would you like to one day be able to play a game that you yourself designed? If this sounds like the ultimate gamer's dream to you, then enrol in this Online Game Design Course today and turn your vision into a reality! This course is specially designed to teach you the very fundamentals of game creation, complete with training on how to develop games using 2D and 3D software. It covers everything you need to know to become a successful Game Designer, including an overview of the principles of game modification, and the tools you'll need as a game designer. Not only that, but with step-by-step training, you'll learn how to create games for social sites, providing you with a range of in-demand skills to rise to the top of the industry in no time. Learn from the experts and turn your passion for gaming into a full-time profession. Start designing the games you've always dreamed of and learn the principles of game creation from the experts!  What You Will Learn In this Online Game Design Course, you will learn about the principles of designing games, with training in 2D and 3D game creation software. It is designed to help you familiarise with the role of a Game Designer, equipping you with the necessary skills to get a head start in your career. An Introduction to Game Creation An Overview of Essential Tools for Game Design 2D Game Creation Software 3D Game Creation Software How To Create a Game on a Social Site An Overview of the Gaming Industry The Role and Responsibilities of a Game Designer The Principles of Game Modification Why You Should Choose This Course From iStudy Study at your own pace Full Tutor support on weekdays (Monday - Friday) Fully compatible with any device Free Printable PDF Certificate immediately after completion No prior qualifications are needed to take this course No hidden fees or exam charges CPD Qualification Standards and IAO accredited Efficient exam system, assessment, and instant results Our customer support team is always ready to help you Gain professional skills and better earning potential Certification After completing the course you'll receive a free printable CPD accredited PDF certificate. Hard Copy certificate is also available, and you can get one for just £9! Accreditation This course is accredited by Continuing Professional Development (CPD). It is a recognised independent accreditation service. Enrol today and learn something new with iStudy. You'll find a full breakdown of the course curriculum down below, take a look and see just how much this course offers. We're sure you'll be satisfied with this course. Game Development Course Introduction To Game Creation 01:00:00 Essential Tools 01:00:00 Basics of Game Design 01:00:00 2D Game Creation Software 01:00:00 3D Game Creation Software 01:00:00 3D Game Creation 00:30:00 Game Modification 01:00:00 How To Create a Game on a Social Site 00:30:00 Wrapping Up 00:15:00 Additional Study Material 2D Game 00:00:00 Beginning Game Development with Python and Pygame 00:00:00 Game Development XNA GameStudio 00:00:00 Mock Exam Mock Exam-Game Design Course- 2D & 3D 00:20:00 Final Exam Final Exam-Game Design Course- 2D & 3D 00:20:00

Are you ready to embark on an enlightening journey of wisdom with the HTML bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - HTML, Coding, CSS, & Javascript (A-Z). Delve into eight immersive CPD Accredited courses, each a standalone course: Course 01: Basic HTML 5 Course 02: Coding with HTML, CSS, & Javascript Course 03: C++ Programming Certificate Course Course 04: Intermediate Python Coding Course 05: HTML Web Development Crash Course Course 06: Web Design for Beginners: Build Websites in HTML & CSS Course 07: Create a Responsive HTML Email Template Course 08: Coding Essentials - Javascript, ASP. Net, C# - Bonus HTML Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the HTML, Coding, CSS, & Javascript (A-Z) bundle illuminate your path to wisdom. The HTML, Coding, CSS, & Javascript (A-Z) bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the HTML, Coding, CSS, & Javascript (A-Z) package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the HTML bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the HTML, Coding, CSS, & Javascript (A-Z) community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the HTML bundle. Establish robust bases across each course nestled within the HTML bundle. Decipher intricate concepts through the articulate content of the HTML bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the HTML bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The HTML bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the HTML bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The HTML bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the HTML bundle allows learners to make meaningful contributions to their chosen fields. Embark on the HTML journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the HTML bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the HTML bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hard copy Transcript - £9.99

This course bundle is ideal for anyone looking to establish their Cisco networking career. It consists of one Cisco Certified Network Associate (CCNA) certification, one Cisco Certified DevNet Associate (CCDA) certification, and four Cisco Certified Networking Professional (CCNP) certifications. Although there are no formal prerequisites to enrol on the CCNA, CCDA, or CCNP certification courses and sit the exams, learners should have a good foundation knowledge in networking. The newly retooled CCNA covers a breadth of topics, including: Network fundamentals Network access IP connectivity IP services Security fundamentals Automation and programmability Achieving CCNA certification is the first step in preparing for a career in networking technologies. To earn your CCNA certification, you only need to pass one exam – which covers a broad range of fundamentals for IT careers, based on the latest networking technologies. The Cisco Certified DevNet Associate certification validates your skills and knowledge in understanding and using APIs, Cisco platforms and development, application development and security, and infrastructure and automation. Ideally, DevNet Associates candidates also have one or more years of experience with software development including Python programming. The CCNP is the next level from the CCNA and CCDA. As with the CCNA, there are no formal prerequisites to enrol on the CCNP certification course and sit for the exams. Learners taking a CCNP course generally have an in-depth knowledge of networking, as well as a good understanding of Cisco technologies. The typical certification path for most learners would begin with either the CCDA or CCNA, then progress onto the CCNP. Learners need to pass two exams (one core exam and one concentration exam) in order to gain one CCNP certification. This course bundle includes the core exam and three concentration exams. Once a learner has passed the core exam, they can choose to specialise in one or all three of the CCNP concentration areas listed in this course. The core exam’s focus is based around implementing and operating Cisco enterprise network core technologies.

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 Big Data Analytics with PySpark Power BI and MongoDB 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 Big Data Analytics with PySpark Power BI and MongoDB Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Big Data Analytics with PySpark Power BI and MongoDB 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 Big Data Analytics with PySpark Power BI and MongoDB 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 Big Data Analytics with PySpark Power BI and MongoDB? 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 Big Data Analytics with PySpark Power BI and MongoDB 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 Big Data Analytics with PySpark Power BI and MongoDB 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 Big Data Analytics with PySpark Power BI and MongoDB does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Big Data Analytics with PySpark Power BI and MongoDB 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 Big Data Analytics with PySpark Power BI and MongoDB is a great way for you to gain multiple skills from the comfort of your home.   Section 01: Introduction Introduction 00:10:00 Section 02: Setup and Installations Python Installation 00:03:00 Installing Apache Spark 00:12:00 Installing Java (Optional) 00:05:00 Testing Apache Spark Installation 00:06:00 Installing MongoDB 00:04:00 Installing NoSQL Booster for MongoDB 00:07:00 Section 03: Data Processing with PySpark and MongoDB Integrating PySpark with Jupyter Notebook 00:05:00 Data Extraction 00:19:00 Data Transformation 00:15:00 Loading Data into MongoDB 00:13:00 Section 04: Machine Learning with PySpark and MLlib Data Pre-processing 00:19:00 Building the Predictive Model 00:12:00 Creating the Prediction Dataset 00:08:00 Section 05: Creating the Data Pipeline Scripts Installing Visual Studio Code 00:03:00 Creating the PySpark ETL Script 00:22:00 Creating the Machine Learning Script 00:24:00 Section 06: Tableau Data Visualization Installing Tableau 00:03:00 Installing MongoDB ODBC Drivers 00:03:00 Creating a System DSN for MongoDB 00:04:00 Loading the Data Sources 00:04:00 Creating a Geo Map 00:11:00 Creating a Bar Chart 00:03:00 Creating a Magnitude Chart 00:07:00 Creating a Table Plot 00:06:00 Creating a Dashboard 00:07:00 Source Code Source Code and Notebook

This course is perfect for the beginner but also delves into building a SAS Model and intermediate topics. Learn SAS Data Step, SQL Step, Macros, SAS Model Building, Predictive Analytics, SAS and ML. If you are using SAS Enterprise Guide and want to learn how to code/program instead of using the point-and-click interface, this course is ideal!

Learn Web Development from Scratch Course Overview This comprehensive course offers a step-by-step journey through web development, starting from the very basics to advanced concepts. Learners will explore core technologies including HTML, CSS, JavaScript, and Python, gaining the skills necessary to build responsive, interactive websites and dynamic web applications. The course emphasises real-world applications, enabling learners to develop their own web projects and publish them online. By the end of the course, participants will confidently navigate the web development process, from setting up their environment to mastering coding principles and deploying live websites. This course is designed to equip individuals with both foundational knowledge and practical abilities that align with current industry standards, preparing them for career advancement or entry into the tech sector. Course Description This detailed web development course covers a broad spectrum of topics essential for anyone looking to build a solid foundation in creating websites and applications. Starting with environment setup, learners will delve deeply into HTML, progressing through beginner to expert levels, before moving on to CSS for styling and layout control. JavaScript modules provide an introduction to programming logic, data handling, and user interaction techniques, including error handling and client-side validations. The course also introduces Python fundamentals, focusing on its applications in web development and data science. Throughout the modules, learners will engage with structured coding tasks and projects designed to reinforce understanding and boost confidence. The final stages focus on publishing and managing live websites, ensuring learners complete the course ready to contribute effectively in web development roles. Learn Web Development from Scratch Curriculum Module 01: Getting Started Module 02: Setting up Development Environment Module 03: HTML Fundamentals Module 04: HTML Intermediate Module 05: HTML Advanced Module 06: HTML Expert Module 07: HTML Website Project Module 08: CSS Fundamentals Module 09: CSS Intermediate Module 10: CSS Advanced Module 11: CSS Expert Module 12: CSS Website Project Module 13: JavaScript Getting Started Module 14: JavaScript Fundamentals Module 15: JavaScript Strings Module 16: JavaScript Operators Module 17: JavaScript Conditional Statements Module 18: JavaScript Control Flow Statements Module 19: JavaScript Functions Module 20: Data Visualisation (Google Charts) Module 21: JavaScript Error Handling Module 22: JavaScript Client-Side Validations Module 23: Python Introduction Module 24: Python Basic Module 25: Python Strings Module 26: Python Operators Module 27: Python Data Structures Module 28: Python Conditional Statements Module 29: Python Control Flow Statements Module 30: Python Core Games Module 31: Python Functions Module 32: Python Args, KW Args for Data Science Module 33: Python Project Module 34: Publish Your Website for Live (See full curriculum) Who is this course for? Individuals seeking to start a career in web development. Professionals aiming to expand their technical skillset for career growth. Beginners with an interest in coding and digital technologies. Those wanting to build and manage their own websites or web applications. Career Path Junior Web Developer Front-End Developer Web Designer Full-Stack Developer Trainee Software Developer Assistant Digital Content Manager Data Visualisation Specialist

Prepare for the AWS Certified Solutions Architect - Associate (SAA-C03) exam. Learn about the AWS Management Console, S3 buckets, instances, database services, cloud security, costs associated with AWS, Amazon Elastic Compute Cloud (EC2), Amazon Virtual Private Cloud (VPC), Amazon Simple Storage Service (S3), and Amazon Elastic Block Store (EBS).

Learn to build a custom object-oriented PHP MVC framework and application

Duration 4 Days 24 CPD hours This course is intended for DevOps engineers Integration engineers Network and software architects Network engineers Software engineers System administrators Overview After completing this course, you should be able to: Describe network and IT convergence Describe Cisco NSO architecture Describe Linux Configure Cisco NSO Set up access control to Cisco NSO system Describe Cisco NSO Integration Options Explain version control systems and basic git concepts Describe the purpose of continuous integration and continuous delivery Implement Cisco NSO high availability Describe scalable system management Describe software development methodologies Describe service maintenance Perform NED upgrades Use Cisco NSO for managing services and their associated device configurations Describe Cisco NSO change management Explain service problem management Use Cisco NSO for service monitoring and compliance reporting Describe Cisco NSO inventory management Describe Cisco NSO use cases The Cisco Network Services Orchestrator (NSO) Administration and DevOps (NSO303) v4.0 course continues the learning journey of the NSO Essentials for Programmers and Network Architects (NSO201) v4.0 and NSO Advanced for Python Programmers (NSO300) v4.0 courses by introducing you to the system administration and DevOps focusing on NSO; the robust bridge linking network automation and orchestration tools, examining the development, operation, and administration task functions. You will learn how to set up, configure, deploy, and maintain a Cisco Network Services Orchestrator solution, and learn best practices for using DevOps. The examples shown in this course demonstrate real-world scenarios to prepare you for deployment and management of new or existing NSO instances. The course guides you through the setup of a production ready NSO instances using system installation with access control settings, the deployment of NSO in Docker containers, and introduces modern DevOps concepts and tools such as Git and Continuous Delivery/Continuous Deployment (CI/CD). You will learn how to migrate CDM devices, how to build NETCONF NEDs from the NSO CLI, how to handle NSO Alarms, and many more features that benefit you in your journey with Cisco NSO. Course Outline Introducing Network and IT Convergence Introducing Cisco NSO Architecture Introducing Linux Explaining Cisco NSO Setup Exploring Access Control Describing Integration Options Explaining Version Control System Describing Continuous Integration and Continuous Delivery Introducing Scalability and High Availability Describing Scalable System Management Describing Software Development Methodologies Introducing Service Maintenance Performing Network Element Driver (NED) Upgrades Introducing Configuration Management Describing Change Management Explaining Service Problem Management Explaining Service Monitoring and Compliance Reporting Introducing Inventory Management Describing Cisco NSO Use Cases