Data speaks volumes—if you know how to listen. This course offers a clever route into the world of MySQL, showing you how structured data can turn into smart decisions. Whether you're sifting through figures, building dashboards, or deciphering patterns, understanding SQL isn’t just helpful—it’s essential. You’ll be guided through the foundations of MySQL with clarity and precision, making sense of tables, queries, joins, and more—all without the fluff or confusion. Designed with the analytical mind in focus, this course shines a light on how MySQL powers insights behind the scenes in data science and analytics. It's tailored for learners who prefer clarity over jargon and structure over noise. If you're curious about how databases work and how data fuels smart outcomes, this course is your ideal stepping stone—organised, engaging and purposefully built for those who appreciate logic and clean learning paths. Expert Support Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course. Key Benefits Learning materials of the Design course contain engaging voiceover and visual elements for your comfort. Get 24/7 access to all content for a full year. Each of our students gets full tutor support on weekdays (Monday to Friday) Course Curriculum: Section 01: Getting Started Introduction How to get course requirements Getting started on Windows, Linux or Mac How to ask great questions FAQ's What is Source Code? Section 02: SQL Server setting up Section Introduction MySQL Server Installation Connect MySQL Server Instance MySQL Workbench overview Download and Restore Sample Database Section 03: SQL Database basics Section Introduction Overview of Databases Creating Database SQL Data Types Column Data Types on Workbench Creating Table Overview of Primary and Foreign Key Primary Key Foreign Key Creating Temporary tables EER - Enhanced Entity Relationship Diagrams Section 04: SQL DML (Data Manipulation Language) Section Introduction Insert statement Update statement Delete statement Section 05: SQL DDL (Data Definition Language) Section Introduction CREATE table statement DROP statement ALTER statement TRUNCATE statement COMMENT in query RENAME table Section 06: SQL DCL (Data Control Language) Create Database user GRANT permissions REVOKE permissions Section 07: SQL Statement Basic Section Introduction SQL Statement basic SELECT Statement SELECT DISTINCT SELECT with column headings Column AS statement DASHBOARD Analytics Section 08: Filtering Data rows SELECT WHERE Clause - theory SELECT WHERE Clause - practical Section 09: Aggregate functions for Data Analysis Sum() Min()-Max() Section 10: SQL Data Analyticstatements Order By statement SELECT TOP 3 records BETWEEN command IN operator Search Data usingLIKE cards Section 11: SQL Group by statement Section Introduction Group by - theory Data Analytics with Group By HAVING statement Section 12: JOINS Overview of Joins What are Joins Inner join Left outer join Right outer join Union CERTESIAN Product or Cross Join Query Exercise Solution for Query Exercise Section 13: SQL Constraints Section introduction Check constraint NOT NULL constraint UNIQUE constraint Section 14: Views Creating Views Data Analytic Viewsfrom multiple tables Section 15: Advanced SQL Functions Section Introduction Timestamp Extract from timestamp Mathematical scalar functions String functions Advanced functions Sub Queries SELECT with calculations Section 16: SQL Stored procedures Create stored procedure Stored procedure with parameter Drop Procedure Section 17: Import & Export data Section Introduction Import .csv file Export Data to .csv file Section 18: Backup and Restore Database Section Introduction Creating Database backup Restoring Database backup Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). Who is this course for? This Learn MySQL from Scratch for Data Science and Analytics course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge. Requirements This Learn MySQL from Scratch for Data Science and Analytics course is open to all, with no formal entry requirements. Career path Upon successful completion of The Learn MySQL from Scratch for Data Science and Analytics Course, learners will be equipped with many indispensable skills and have the opportunity to grab.
This course is designed to help you master the concepts of JavaScript needed to create interactive web games. You will create five interesting word games that will teach you how to write and test the game code in JavaScript.
Advanced Tutorial to Learn essential skills needed to transform your career from QA Engineer to SDET/Test Architect
Duration 3 Days 18 CPD hours Overview VMware vSphere: What's New [V8] https://lms.nhcms.neYou will learn essential Terraform concepts including: Writing Terraform HCL code Deploying into common clouds such as AWS, Azure, Docker, Kubernetes, and VMWare Where Terraform fits in the Enterprise CI/CD model Differences between Terraform and Ansible As enterprises seek to deploy and maintain increasingly complex cloud infrastructure, there is a necessity to use ?Infrastructure as Code? (IaC) tools, like Terraform. An open-source, state management tool developed by HashiCorp, Terraform allows developers to use a common coding interface to work through their various clouds safely and efficiently. Attendees will leave being able to write and understand Terraform code (HCL), have a clear understanding of Terraform?s various components and supporting tools, as well as when to reach for Terraform over another IaC tool, such as Ansible. This class prepares you for Terraform Certifcation. Up and Running with Terraform Terraform Overview Defining ?declarative? How to think about Terraform (versus Ansible) Reviewing the Terraform Configuration Running the Terraform Configuration Provisioners Syntax Low Level? HCL syntax Style Conventions Comments Blocks Arguments JSON Configuration Syntax Resources Meta-Arguments depends_on count for_each provider lifecycle Data Sources Variables and Output Input Variables Output Values Local Values Functions String Collection Numeric Encoding Filesystem Date and Time Hash and Crypto IP Network Type Conversion Modules Module Blocks Module Sources Meta Arguments Terraform Templates templatefile Function Template Demonstration Introducing Data Sources Creating an External Data Source Building tftpl template files Expressions Types and Values Strings and Templates Reference to Values Operators Function Calls Conditionals For Expressions Splat Expressions Dynamic Blocks Type Constraints Version Constraints State Understanding the importants of states state storage and locking importing existing resources Remote State What to do when local state is lost CICD Piplines with Terraform Terraform and GitLab pipelines Terraform and Jenkins pipelines Enterprise Case Studies Terraform and Docker Terraform and Kubernetes Terraform and Amazon AWS Terraform and Azure Terraform and VMWare Understanding how to apply Terraform to your unique infrastructure Beyond Basics Intro to Go Programming Terraform Cloud Additional HashiCorp Offerings Backends Secrets Additional course details: Nexus Humans Terraform 101 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 Terraform 101 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.
Overview This comprehensive course on C++ Complete Coding Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This C++ Complete Coding Course comes with accredited certification from CPD, 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 C++ Complete Coding Course. It is available to all students, of all academic backgrounds. Requirements Our C++ Complete Coding Course 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 14 sections • 79 lectures • 05:33:00 total length •Introduction: 00:04:00 •What Is C++?: 00:03:00 •Setting up A Project: 00:07:00 •Console Out: 00:04:00 •Data Types: 00:03:00 •Variables: 00:04:00 •Console In: 00:03:00 •Strings: 00:04:00 •Constants: 00:05:00 •Assignment Operator: 00:03:00 •Arithmetic Operators: 00:04:00 •Compound Assignment Operator: 00:03:00 •Increment & Decrement Operators: 00:04:00 •Relation & Comparison Operators: 00:06:00 •Logical Operators: 00:07:00 •Conditional Ternary Operator: 00:04:00 •Comma Operator: 00:03:00 •Type Casting Operator: 00:02:00 •Bitwise Operators: 00:12:00 •Size of Operator: 00:03:00 •Operator Precedence: 00:05:00 •String Streams: 00:04:00 •Conditional Statements: 00:07:00 •For Loop: 00:04:00 •While Loop: 00:03:00 •Do While Loop: 00:04:00 •Range-Based For Loop: 00:03:00 •GoTo Statement: 00:04:00 •Switch Statement: 00:05:00 •Functions: 00:03:00 •Function Return Statement: 00:04:00 •Function Arguments Passed By Value: 00:05:00 •Function Arguments Passed By Reference: 00:05:00 •Function Parameter Default Values: 00:03:00 •Overloaded Functions: 00:04:00 •Function Templates: 00:04:00 •Namespaces: 00:06:00 •Arrays: 00:03:00 •Multidimensional Arrays: 00:03:00 •References: 00:02:00 •Pointers: 00:04:00 •Delete Operator: 00:02:00 •Struct: 00:04:00 •Type Aliasing: 00:03:00 •Unions: 00:04:00 •Enumerators: 00:04:00 •Introduction to Classes: 00:05:00 •Class Access: 00:04:00 •Class Constructor: 00:05:00 •Class Pointers: 00:04:00 •Overloading Operators: 00:06:00 •This Keyword: 00:04:00 •Constant Objects: 00:03:00 •Getters and Setters: 00:05:00 •Static Variables: 00:04:00 •Static Functions: 00:06:00 •Template Classes: 00:05:00 •Class Destructor: 00:04:00 •Class Copy Constructor: 00:03:00 •Friend Function: 00:06:00 •Friend Class: 00:06:00 •Class Inheritance: 00:07:00 •Multiple Class Inheritance: 00:05:00 •Virtual Methods: 00:04:00 •Abstract Base Class: 00:03:00 •Error Handling: 00:04:00 •Preprocessor Macro Definitions: 00:04:00 •Preprocessor Conditional Directives: 00:05:00 •Preprocessor Line Directive: 00:04:00 •Preprocessor Error Directive: 00:03:00 •Preprocessor Source File Inclusion: 00:02:00 •Opening A File: 00:06:00 •Writing to a File: 00:04:00 •Commenting: 00:04:00 •Class Header and Implementation: 00:09:00 •Lists: 00:04:00 •Vectors: 00:05:00 •Resource - C++ Complete Coding Course: 00:00:00 •Assignment - C++ Complete Coding Course: 00:00:00
Overview This comprehensive course on C++ Development: The Complete Coding Guide will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This C++ Development: The Complete Coding Guide comes with accredited certification from CPD, 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 C++ Development: The Complete Coding Guide. It is available to all students, of all academic backgrounds. Requirements Our C++ Development: The Complete Coding Guide 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 14 sections • 79 lectures • 05:35:00 total length •Introduction: 00:04:00 •What Is C++?: 00:03:00 •Setting up A Project: 00:07:00 •Console Out: 00:04:00 •Data Types: 00:03:00 •Variables: 00:04:00 •Console In: 00:03:00 •Strings: 00:04:00 •Constants: 00:05:00 •Assignment Operator: 00:03:00 •Arithmetic Operators: 00:04:00 •Compound Assignment Operator: 00:03:00 •Increment & Decrement Operators: 00:04:00 •Relation & Comparison Operators: 00:06:00 •Logical Operators: 00:07:00 •Conditional Ternary Operator: 00:04:00 •Comma Operator: 00:03:00 •Type Casting Operator: 00:02:00 •Bitwise Operators: 00:12:00 •Size of Operator: 00:03:00 •Operator Precedence: 00:05:00 •String Streams: 00:04:00 •Conditional Statements: 00:07:00 •For Loop: 00:04:00 •While Loop: 00:03:00 •Do While Loop: 00:04:00 •Range-Based For Loop: 00:03:00 •GoTo Statement: 00:04:00 •Switch Statement: 00:05:00 •Switch Statement: 00:05:00 •Functions: 00:03:00 •Function Return Statement: 00:04:00 •Function Arguments Passed By Value: 00:05:00 •Function Arguments Passed By Reference: 00:05:00 •Function Parameter Default Values: 00:03:00 •Overloaded Functions: 00:04:00 •Function Templates: 00:04:00 •Namespaces: 00:06:00 •Arrays: 00:03:00 •Multidimensional Arrays: 00:03:00 •References: 00:02:00 •Pointers: 00:04:00 •Delete Operator: 00:02:00 •Struct: 00:04:00 •Type Aliasing: 00:03:00 •Unions: 00:04:00 •Enumerators: 00:04:00 •Introduction to Classes: 00:05:00 •Class Access: 00:04:00 •Class Constructor: 00:05:00 •Class Pointers: 00:04:00 •Overloading Operators: 00:06:00 •This Keyword: 00:04:00 •Constant Objects: 00:03:00 •Getters and Setters: 00:05:00 •Static Variables: 00:04:00 •Static Functions: 00:06:00 •Template Classes: 00:05:00 •Class Destructor: 00:04:00 •Class Copy Constructor: 00:03:00 •Friend Function: 00:06:00 •Friend Class: 00:06:00 •Class Inheritance: 00:07:00 •Multiple Class Inheritance: 00:05:00 •Virtual Methods: 00:04:00 •Abstract Base Class: 00:03:00 •Error Handling: 00:04:00 •Preprocessor Macro Definitions: 00:04:00 •Preprocessor Conditional Directives: 00:05:00 •Preprocessor Line Directive: 00:04:00 •Preprocessor Source File Inclusion: 00:02:00 •Opening A File: 00:06:00 •Writing to a File: 00:04:00 •Commenting: 00:04:00 •Class Header and Implementation: 00:09:00 •Lists: 00:04:00 •Vectors: 00:05:00 •Resource: 00:00:00 •Assignment - C++ Development: The Complete Coding Guide: 00:00:00
Learn about automated software testing with Python, BDD, Selenium WebDriver, and Postman, focusing on web applications