5478 Software courses delivered Online

Overview Acquire the language of databases with this SQL Programming Complete Bundlecourse. In this data-driven world, data is used to make strategies, find solutions and do a thousand other tasks. Businesses across the world are using big and related data, which makes a basic knowledge of SQL a remarkable skill not only for data scientists but for everyone. This SQL Programming Complete Bundlecourse will teach you the language of databases, SQL, and help you gain proficiency in SQL tools. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this SQL Programming Complete Bundle. It is available to all students, of all academic backgrounds. Requirements Our SQL Programming Complete Bundle is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 9 sections • 53 lectures • 07:50:00 total length •Introduction: 00:04:00 •Course Curriculum Overview: 00:05:00 •Overview of Databases: 00:10:00 •MySQL Installation: 00:16:00 •MySQL Workbench Installation: 00:09:00 •Connecting to MySQL using Console: 00:09:00 •Overview of Challenges: 00:04:00 •SQL Statement Basic: 00:16:00 •SELECT Statement: 00:09:00 •SELECT DISTINCT: 00:05:00 •Column AS Statement: 00:12:00 •COUNT built-in Method usage: 00:11:00 •SELECT WHERE Clause - Part One: 00:05:00 •SELECT WHERE Clause - Part Two: 00:11:00 •SQL Statement Basic: 00:16:00 •SQL Limit Clause Statement: 00:09:00 •SQL Using BETWEEN with Same Column Data: 00:11:00 •How to Apply IN Operator: 00:11:00 •Wildcard Characters with LIKE and ILIKE: 00:11:00 •Overview of GROUP BY: 00:06:00 •Aggregation function SUM(): 00:09:00 •Aggregation MIN() and MAX(): 00:05:00 •GROUP BY - One: 00:09:00 •GROUP BY - Two: 00:12:00 •HAVING Clause: 00:05:00 •Overview of JOINS: 00:04:00 •Introduction to JOINS: 00:04:00 •AS Statement table: 00:03:00 •INNER Joins: 00:14:00 •FULL Outer Join: 00:11:00 •LEFT Outer JOIN: 00:08:00 •RIGHT JOIN: 00:08:00 •Union: 00:07:00 •Timestamps: 00:12:00 •EXTRACT from timestamp: 00:10:00 •Mathematical Functions: 00:12:00 •String Functions: 00:22:00 •SUBQUERY: 00:13:00 •Basic of Database and Tables: 00:06:00 •DataTypes: 00:10:00 •Primarykey and Foreignkey: 00:06:00 •Create Table in SQL Script: 00:13:00 •Insert: 00:11:00 •Update: 00:07:00 •Delete: 00:04:00 •Alter Table: 00:09:00 •Drop Table: 00:05:00 •NOT NULL Constraint: 00:08:00 •UNIQUE Constraint: 00:09:00 •Creating a Database backup: 00:12:00 •10a Overview of Databases and Tables: 00:05:00 •10c Restoring a Database: 00:07:00 •Assignment - SQL Programming Complete Bundle: 00:00:00

Overview This comprehensive course on Machine Learning with Python will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Machine Learning with Python comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Machine Learning with Python. It is available to all students, of all academic backgrounds. Requirements Our Machine Learning with Python is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 4 sections • 21 lectures • 01:34:00 total length •Introduction to types of ML algorithm: 00:02:00 •SVM - Python Implementation: 00:06:00 •Introduction to types of ML algorithm: 00:02:00 •Importing a dataset in python: 00:02:00 •Resolving Missing Values: 00:06:00 •Managing Category Variables: 00:04:00 •Training and Testing Datasets: 00:07:00 •Normalizing Variables: 00:02:00 •Normalizing Variables - Python Code: 00:03:00 •Summary: 00:01:00 •Simple Linear Regression - How it works?: 00:04:00 •Simple Linear Regreesion - Python Implementation: 00:07:00 •Multiple Linear Regression - How it works?: 00:01:00 •Multiple Linear Regression - Python Implementation: 00:09:00 •Decision Trees - How it works?: 00:05:00 •Random Forest - How it works?: 00:03:00 •Decision Trees and Random Forest - Python Implementation: 00:04:00 •kNN - How it works?: 00:02:00 •kNN - Python Implementation: 00:10:00 •Decision Tree Classifier and Random Forest Classifier in Python: 00:10:00 •SVM - How it works?: 00:04:00

Description The Modern Web Design Diploma course teaches you to develop and design a responsive website that will work on every device covering mobile, tablet to extra large desktop monitor. The number of mobile users is enormous and increasing day by day. Therefore, it is a must to make your websites responsive. The old website owners spend a lot to make their site responsive; some go for redesigning and remaking their sites. Throughout the course, you will learn to create the responsive webpage using Balsamiq Mockups, Photoshop, Zeplin and Invision App. You will learn how to design for the developers. Topics covered in the course are the system of building Prototypes for showing website flows and interactions, designing Wireframes using Balsamiq Mockups, design and develop a coded Style Guide for Developers, creating Online Style Guide using Zeplin, creating grid system for different screens, e.g. PC, Tablet or Smart Phones. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Modern Web Design Diploma is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Modern Web Design Diploma is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction 0.1 promo-workflow 00:03:00 0.2 what we will cover in this course 00:03:00 Requirements to take this course 1.1 skills-and-apps-you-need-to-take-this-courseautogenerated 00:02:00 1.2. Photoshop extensions We Need 00:07:00 Organizing your Web Design Project 2.1.how To Organize A Design Project 00:05:00 2.2 client's Sketches 00:04:00 2.2 naming psd layers and groups 00:06:00 2.3.naming Conventions To Help Developers 00:03:00 Gathering project information from client 3.1.design Briefs 00:10:00 3.3 getting More Info On Project 00:05:00 3.4.content_template for gathering information 00:03:00 Sketching, Wireframing, Atomic Design & 8point Grid system 4.1.moodboards 00:06:00 4.2.ideation Phase 00:05:00 4.3.introduction To Balsamiq 00:10:00 4.4desining Wireframes Part 1 00:08:00 4.5.desining Wireframes Part 2 00:14:00 4.6.atomic Design 00:08:00 4.7.8pt Grid 00:09:00 Style Guides, colors and typographics scales 5.1.typeface And Color Combinations 00:04:00 5.2.ui Style Guides 00:08:00 5.3.examples Of Ui Style Guides 00:03:00 5.4.how I Created My Style Guide 00:07:00 5.5.styleguide-typescale Explained 00:03:00 5.6.Styleguide-assignment 00:01:00 Designing for Desktop/Large View (Wstudio Web Design Project) 6.1.online tools for grid calcuations 00:13:00 6.2.planning your grid 00:05:00 6.3.whitespace-plan 00:06:00 6.4.setting Up Artboard For Desktop Design 00:07:00 6.5.designing Header And Hero Part 1 00:12:00 6.6 designing Header And Hero Part 2 00:09:00 6.7.designing Steps Area Part 1 00:10:00 6.8.designing Step Area Part 2 00:09:00 6.9.userreviews Area Design 00:09:00 6.10.adjusting White Space And Vertical Rhythem 00:06:00 6.11.desining Team Part1 00:11:00 6.12.desining Team Part2 00:07:00 6.13.footer Design Part1 00:08:00 6.14.footer Design Part2 00:11:00 Planning Responsive Web Design 7.1.Responsive Design Considerations Part 1 00:07:00 7.2.Responsive Design Considerations Part 2 00:06:00 Designing for Tablet/Medium View (Wstudio Web Design Project) 7.3.Establishing Grid For Tablets 00:07:00 7.4.Header Area For Tablet View 00:11:00 7.5.Section how it work - steps 00:10:00 7.6.Section team Tablet View 00:09:00 7.7 footer Design 00:09:00 Designing for Mobile/Small View (Wstudio Web Design Project) 8.1.mobile Artboard And Grids 00:04:00 8.2.header Mobile View 00:11:00 8.3.steps Section-mobile 00:09:00 8.4.section 2 Team Members For Mobile 00:09:00 8.5.footer And Final Adjustments 00:08:00 Designing for Developers 9.1.what Developes Needs To Know 00:05:00 9.2.Red Line Document with Ink 1 00:10:00 9.3.Red Line Document with Ink 2 00:06:00 9.4.which layer styles you can use photoshop 00:08:00 9.5.installing Using Zeplin 00:10:00 9.6.style Guides With Zeplin 00:14:00 9.7.tools-zeplin-avocode-1 00:04:00 9.8.avocode And Sympli 00:06:00 Prototyping with Invision app 10.1. What Are Prototypes 00:04:00 10.2.getting Familiar With Invision App For Prototyping 00:07:00 10.3.creating First Prototype With Invision App 00:06:00 SVGs and Icon Fonts in Web Design 11.1 using iconmoon app to create custom icon fonts set 00:08:00 11.2 Using SVG in Web design 00:10:00 Assignment Assignment - Modern Web Design Diploma 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

[vc_row][vc_column][vc_column_text] Description If you want to learn about game creation and understand game theory, this course will give you the practical skills required to kickstart your career in game development. The Game Design Canvas is a powerful tool to evaluate your games industry knowledge, with an insight into how computer games and video games are designed and developed. The aim of this game design course is to provide a powerful analytical and planning tool for developers and BA Hons gamed design students looking for a way into creative industries. You will become familiar with game engines, games art and 3d modelling. You will also learn elements of real-world interactive and immersive game level design. Through practical exercises, you will be able to create projects from scratch and develop them using project management tools and brainstorming techniques. On successful completion, you will know how to design games that are user-friendly and in line with creative media trends. The course teaches many aspects of game design, with examples and step-by-step guidance that will help you to develop your creative, problem-solving, critical thinking, and user-centric skills. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Game Design Canvas is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Game Design Canvas is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.[/vc_column_text][/vc_column][/vc_row] Introduction Introduction FREE 00:01:00 The Game Design Canvas 00:05:00 Brainstorming 00:04:00 Your First Game 00:04:00 Kanban Trello 00:06:00 Game Purposes 00:05:00 Pre Definitions - Red Sign Platforms 00:07:00 Number Of Players 00:08:00 Target Audience 00:05:00 Duration 00:04:00 Core Gameplay - Yellow Sign Genre 00:07:00 Mechanics 00:04:00 Story And Theme 00:04:00 Green Sign - Gameplay Goals 00:04:00 Interaction 00:05:00 Obstacles 00:05:00 Rules 00:06:00 Ending Thanks and Congratulations 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This course will help you learn about the process of building mobile-friendly and responsive websites using CSS. You will learn about CSS Grid, CSS float, Flexbox, and mobile navigation bars by creating five websites from scratch.

If you want to enhance your problem-solving and decision-making abilities with ChatGPT's predictive capabilities, streamline your communication, and improve efficiency in professional/personal settings, this course is for you. Acquire the skills to train and fine-tune ChatGPT for specific applications and industries.

Overview If you know how to play the game, the stocks and bond investment can bring lucrative profits. Master the knowledge and skills required to thrive in the stock market with our Stock and Bond Investment Essentials course. Whether you are a seasoned player or new in the game, this course will come in handy. First this course will explain the basic fundamentals of stock and bond investment. Then you will learn about different investment types and effective techniques for successful investment. Through this course, you will get a clear understanding of the principles of finance and be able to develop the skills to win at stocks and bond markets. Furthermore, the course will help you develop essential skills for risk and portfolio management. So, if you are ready to embark on the journey of stock and bond investment, enrol now! Course Preview Learning Outcomes Familiarise yourself with the major concepts of stock and bond investment Learn about different types and techniques of investment Enhance your knowledge and understanding of finance Grasp effective strategies of stock and bond market Build your expertise in risk and portfolio management 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? Stock and bond investment Financial management Who Should Take this Stock and Bond Investment Essentials? 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 Stock and Bond Investment Essentials course 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. Stock and Bond Investment Essentials Certification After completing and passing the Stock and Bond Investment Essentials course successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path​ This exclusive Stock and Bond Investment Essentials course will equip you with effective skills and abilities and help you explore career paths such as  Investment banker Finance manager Finance advisor Investment analyst Module 01: Introduction to Investment Introduction to Investment 00:07:00 Module 02: Types and Techniques Types and Techniques 00:10:00 Module 03: Key Concepts in Investment Key Concepts in Investment 00:09:00 Module 04: Understanding the Finance Understanding the Finance 00:10:00 Module 05: Stock Trading Basics Stock Trading Basics 00:18:00 Module 06: Investing in Bond Market Investing in Bond Market 00:08:00 Module 07: Investing in Stock Market Investing in Stock Market 00:10:00 Module 08: Risk and Portfolio Management Risk and Portfolio Management 00:10:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

The Azure Container Service (ACS) is a cloud-based container deployment and management service that supports popular open source tools and technologies for container and container orchestration. ACS allows you to run containers at scale in production and manages the underlying infrastructure for you by configuring the appropriate VMs and clusters for you. This Azure - Containers is designed to instruct you on Azure, and specifically how it pertains to containers. In this course, you will gain a comprehensive overview of containers and spend time understanding what containers are within Azure. You will learn how to use docker host to manage both on-premises and Azure containers. Learn how to use ACS to scale and orchestrate applications using DC/OS, Docker Swarm, or Kubernetes. This course also covers Azure container clustering options. On completion this course, you will be confident enough to use Azure Containers. Finally, you will look at how to install ACS. What Will I Learn? Understand Containers in Azure Deploy Containers Install ACS Understand multi-container applications Requirements Some prior knowledge in Azure is required, or the completion of Introduction to Azure course Introduction Introduction FREE 00:01:00 Introduction to Containers Introduction to Containers 00:04:00 Docker 00:04:00 Deploying Containers 00:08:00 Multi-container Applications 00:02:00 Azure Container Registry 00:03:00 Azure Container Clustering Options 00:02:00 Installing ACS 00:04:00 Conclusion Course Recap 00:02:00 Course Certification

Microsoft Azure is an ever-expanding set of cloud services to help your organization meet your business challenges. It's the freedom to build, manage, and deploy applications on a massive, global network using your favorite tools and frameworks. If you are an administrator, developers, or database administrators then this Azure - Introduction will be beneficial for you. Learn the fundamentals of working in a Microsoft Azure environment to help improve your business. The Azure - Introduction will help you get started with Microsoft Azure technologies such as infrastructure, virtual machines, virtual networking, identity, and storage. You will learn how Microsoft Azure can help you build and manage your business's applications and cloud services and help improve overall business productivity. You will learn the procedures of managing Azure from the Classic, New Portal and Azure PowerShell. You will know the steps of authenticating Azure PowerShell. You will also learn various types of cloud services along with the Microsoft Azure. What Will I Learn? Understand the Cloud Learn about the different types of Cloud services Understand Azure services Learn about Azure PowerShell and authenticating Azure PowerShell Requirements This course is suggested for It-related professionals that possess limited/no knowledge of cloud technologies and would like to become familiar with Microsoft Azure. Basic computer skills are required. Basic computer skills are required. Familiarity with the concept of cloud computing and storage is helpful, but not required. Introduction Introduction FREE 00:03:00 Overview of Cloud Services What is the Cloud 00:03:00 Types of Cloud Services 00:04:00 Azure Data Centers 00:03:00 Setting up a Free Trial 00:04:00 Azure Service Overview Compute Services 00:02:00 Networking 00:02:00 Storage 00:02:00 Data and Analytics 00:02:00 Web and Mobile 00:03:00 Miscellaneous 00:02:00 Azure Deployment Models 00:06:00 Azure Management Interfaces 00:02:00 Azure Portal 00:06:00 Azure Powershell 00:07:00 Conclusion Course Recap 00:02:00 Course Certification

Azure Virtual Network gives you an isolated and highly-secure environment to run your virtual machines and applications. Use your private IP addresses and define subnets, access control policies, and more. Use Virtual Network to treat Azure the same as you would your own datacenter. The Azure - Networking is designed to introduce to virtual network configuration through the Microsoft Azure Portal and network configuration files. You'll also see how to use network services to configure and load balance network traffic using tools such as Azure DNS. Load Balancer, Azure Traffic Manager, and Application Gateway. And because this is about the cloud, you'll see how to connect your on-premises computers to Azure virtual networks as well as establishing connectivity between sites. The course guides you to configure a Point to Site VPN and a Site to Site VPN. On completion this course, you will look at Azure Vnet peering, and how peering between Vnets can reduce the need to build Vnet-to-Vnet VPN gateways. What Will I Learn? Create a Vnet Configure a Point to Site VPN Understand Vnet Peering Understand DNS in Azure Vnets Who is the target audience? People interested in learning Networking Basics in Azure Requirements Some prior knowledge in Azure is required, or the completion of Introduction to Azure course Introduction Introduction FREE 00:02:00 Virtual Networks Virtual Network Overview 00:02:00 IP Address Space 00:03:00 DNS in Azure Vnets 00:03:00 Creating a VNet 00:03:00 VPNs with VNets 00:04:00 Configuring a Point to Site VPN 00:12:00 Configure Site to Site VPN 00:05:00 Azure Vnet Peering 00:02:00 Conclusion Course Recap 00:04:00 Course Certification