2985 Code courses

Embark on a comprehensive journey into the world of MySQL with a focus on its applications in Data Science and Analytics. This course is structured to take you from the fundamentals to advanced topics in MySQL Server. Covering SQL basics, data manipulation and definition, control and analytic functions, and database management, you'll acquire the essential skills for harnessing MySQL's power in data-driven decision-making. Learning Outcomes: Establish a strong foundation in SQL and MySQL. Set up and configure SQL Server for efficient data handling. Master SQL's Data Manipulation, Definition, and Control Language. Create and optimize SQL queries for data analysis. Perform advanced data analytics using SQL. Understand the power of GROUP BY and JOIN statements. Implement data constraints and views for data integrity and security. Develop proficiency in stored procedures, data import/export, and database backup/restore. Why buy this Learn MySQL from Scratch for Data Science and Analytics?  Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on 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 Learn MySQL from Scratch for Data Science and Analytics you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Learn MySQL from Scratch for Data Science and Analytics course is ideal for Aspiring Data Scientists and Analysts. Database Administrators and Developers. Students and professionals seeking to enter the field of Data Science. Anyone looking to enhance their SQL and MySQL skills for data-related roles. Prerequisites This Learn MySQL from Scratch for Data Science and Analytics was made by professionals and it is compatible with all PC's, Mac's, 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 Data Analyst: £25,000 - £50,000 per year. Database Administrator: £30,000 - £60,000 per year. SQL Developer: £30,000 - £60,000 per year. Data Scientist: £40,000 - £80,000 per year. Business Intelligence Analyst: £35,000 - £65,000 per year. Course Curriculum Learn MySQL from Scratch for Data Science and Analytics Section 01: Getting Started Introduction 00:02:00 How to get course requirements 00:01:00 Getting started on Windows, Linux or Mac 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 What is Source Code? 00:09:00 Section 02: SQL Server setting up Section Introduction 00:01:00 MySQL Server Installation 00:14:00 Connect MySQL Server Instance 00:06:00 MySQL Workbench overview 00:11:00 Download and Restore Sample Database 00:08:00 Section 03: SQL Database basics Section Introduction 00:01:00 Overview of Databases 00:09:00 Creating Database 00:07:00 SQL Data Types 00:04:00 Column Data Types on Workbench 00:07:00 Creating Table 00:04:00 Overview of Primary and Foreign Key 00:03:00 Primary Key 00:06:00 Foreign Key 00:12:00 Creating Temporary tables 00:12:00 EER - Enhanced Entity Relationship Diagrams 00:04:00 Section 04: SQL DML (Data Manipulation Language) Section Introduction 00:01:00 Insert statement 00:07:00 Update statement 00:06:00 Delete statement 00:03:00 Section 05: SQL DDL (Data Definition Language) Section Introduction 00:01:00 CREATE table statement 00:08:00 DROP statement 00:03:00 ALTER statement 00:05:00 TRUNCATE statement 00:03:00 COMMENT in query 00:02:00 RENAME table 00:03:00 Section 06: SQL DCL (Data Control Language) Create Database user 00:03:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 07: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:03:00 SELECT DISTINCT 00:02:00 SELECT with column headings 00:01:00 Column AS statement 00:02:00 DASHBOARD Analytics 00:06:00 Section 08: Filtering Data rows SELECT WHERE Clause - theory 00:03:00 SELECT WHERE Clause - practical 00:06:00 Section 09: Aggregate functions for Data Analysis Sum() 00:06:00 Min()-Max() 00:03:00 Section 10: SQL Data Analyticstatements Order By statement 00:05:00 SELECT TOP 3 records 00:02:00 BETWEEN command 00:06:00 IN operator 00:03:00 Search Data usingLIKE cards 00:05:00 Section 11: SQL Group by statement Section Introduction 00:01:00 Group by - theory 00:04:00 Data Analytics with Group By 00:04:00 HAVING statement 00:03:00 Section 12: JOINS Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:07:00 Left outer join 00:02:00 Right outer join 00:02:00 Union 00:03:00 CERTESIAN Product or Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 13: SQL Constraints Section introduction 00:01:00 Check constraint 00:09:00 NOT NULL constraint 00:03:00 UNIQUE constraint 00:06:00 Section 14: Views Creating Views 00:03:00 Data Analytic Views from multiple tables 00:03:00 Section 15: Advanced SQL Functions Section Introduction 00:01:00 Timestamp 00:03:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:03:00 String functions3 00:07:00 Advanced functions 00:04:00 Sub Queries 00:03:00 SELECT with calculations 00:05:00 Section 16: SQL Stored procedures Create stored procedure 00:06:00 Stored procedure with parameter 00:03:00 Drop Procedure 00:01:00 Section 17: Import & Export data Section Introduction 00:01:00 Import .csv file 00:04:00 Export Data to .csv file 00:02:00 Section 18: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:02:00 Restoring Database backup 00:02:00

Enhance your knowledge on methane emissions mitigation and management in the oil and gas industry with EnergyEdge's virtual instructor-led training course.

Introducing the 'Python Programming Bible | Networking, GUI, Email, XML, CGI' - your comprehensive, all-in-one resource for mastering Python! Are you an aspiring developer looking to dive into the ocean of Python programming or a seasoned coder seeking to level up your Python game? Look no further! Our course is expertly designed to take you from the basics to the complexities of Python, including Networking, GUI, Email, XML, and CGI. If you've ever dreamt of not just learning Python but truly mastering it, this is the course for you. This program is designed to provide a solid foundation and sharpen your skills in one of the most in-demand programming languages, while also introducing you to its many applications. This course starts with the basics of Python, providing a gentle yet thorough introduction and setup that caters to beginners as well as those looking to refresh their Python knowledge. As we study deeper into the heart of Python, we dive into objects, classes, and the power of regular expressions. But it doesn't stop there! You'll also become comfortable with concepts like CGI programming, which is an important building block for creating dynamic web pages. Navigating from core programming, we transition into the intricacies of managing databases and executing multithreading in Python. You'll gain the confidence to handle complex data management tasks, understand how Python interacts with databases, and efficiently manages multiple tasks simultaneously. The XML section allows you to get hands-on with parsing, data extraction, and manipulation, while the GUI section unveils the art of creating beautiful, user-friendly interfaces using Python. The course is enriched with a diverse set of resources, including real-world projects, quizzes, and interactive coding exercises. This is more than just a course, it's your passport to a new realm of opportunities, unlocking a world where Python programming is your strength, not just a skill.  So whether you're a student aiming to get a head start on your peers, a professional looking to diversify your skills, or an enthusiast wanting to dive deeper into the Python universe, the Python Programming Bible is the starting point for your journey to becoming a Python expert. Enrol today and step into a future of endless opportunities with Python! Learning Outcomes: Upon completion of the Python Programming Bible course, you should be able to: Understand and implement Python basics and advanced concepts. Build object-oriented programs with Python. Utilise regular expressions for pattern-matching tasks. Develop dynamic web pages using CGI programming. Interact with databases efficiently using Python. Apply multithreading for better utilisation of resources. Process and manipulate data using XML in Python. Design and create user-friendly GUIs with Python. Who is this course for? This Python Programming Bible course is ideal for the following: Beginners aiming to learn Python from scratch. Professionals looking to broaden their programming skills. Students pursuing a degree in Computer Science. Web developers looking to integrate Python into their toolkit. Data enthusiasts aiming to handle data with Python. Career Path: This Python Programming Bible course will help you to develop your knowledge and skills to pursue different careers, such as: Python Developer: (£35,000 - £70,000). Data Analyst: (£27,000 - £55,000). Web Developer: (£24,000 - £60,000). Data Scientist: (£45,000 - £90,000). Machine Learning Engineer: (£50,000 - £90,000). Software Developer: (£30,000 - £70,000). Certification After studying the course materials of the Python Programming Bible | Networking, GUI, Email, XML, CGI 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. Prerequisites This Python Programming Bible | Networking, GUI, Email, XML, CGI does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Python Programming Bible | Networking, GUI, Email, XML, CGI was made by professionals and it is compatible with all PC's, Mac's, 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. Course Curriculum Section 01: Introduction & Setup Introduction 00:02:00 Setup on Mac OS X 00:03:00 Setup On Linux/Ubuntu 00:03:00 Setup On Windows 00:03:00 Run Code Online 00:03:00 Section 02: Basics Comments 00:02:00 Variables & Variable Types 00:05:00 Lists 00:04:00 Tuples 00:03:00 Dictionary 00:06:00 Data Type Conversion 00:02:00 Arithmetic Operators 00:05:00 Comparison Operators 00:03:00 Assignment Operators 00:03:00 Bitwise Operators 00:10:00 Logical Operators 00:07:00 Membership Operators 00:02:00 Identity Operators 00:02:00 Operator Precedence 00:03:00 Decision Making 00:09:00 Loops 00:06:00 Loop Control Statements 00:05:00 Numbers 00:05:00 Strings 00:12:00 Lists In Depth 00:05:00 Tuples In Depth 00:06:00 Dictionary In Depth 00:08:00 Date & Time 00:07:00 Functions 00:11:00 Modules 00:05:00 File Inputs & Outputs 00:13:00 Handling Exceptions 00:07:00 Section 03: Classes/Objects Simple Example 00:04:00 Creating Instance Objects 00:01:00 Accessing Attributes 00:04:00 Constructor New & Init Method 00:06:00 Destroying Objects 00:02:00 Class Inheritance 00:04:00 Overriding Methods 00:03:00 Overloading Methods 00:01:00 Overloading Operators 00:04:00 Data Hiding 00:03:00 Section 04: Regular Expressions Match Function 00:05:00 Search Function 00:02:00 Advanced Expressions 00:05:00 Search & Replace 00:03:00 Section 05: CGI Programming Basic CGI Programming 00:08:00 Get Method 00:06:00 Post Method 00:05:00 Cookies 00:05:00 Section 06: Database Setup Database 00:02:00 Connect To Database 00:05:00 Create Table 00:03:00 INSERT Operation 00:04:00 READ Operation 00:06:00 UPDATE Operation 00:02:00 DELETE Operation 00:02:00 Simple Network Example 00:04:00 Simple Client 00:04:00 Section 07: Multithreading Initiate a New Thread 00:07:00 Create Thread 00:06:00 Synchronise Threads 00:03:00 Multithreaded Priority Queue 00:09:00 Section 08: XML Parse an XML File 00:10:00 Section 09: GUI Introduction 00:02:00 Button Preview 00:03:00 Canvas 00:04:00 Checkbutton 00:02:00 Entry 00:02:00 Frame 00:04:00 Label 00:02:00 List Box 00:02:00 Menu button 00:03:00 Menu 00:08:00 Message 00:02:00 Radio button 00:05:00 Scale 00:03:00 Scrollbar 00:04:00 Text 00:03:00 Top-level 00:02:00 Spinbox 00:02:00 Paned Window 00:03:00 Message Box 00:02:00 Label Frame 00:02:00 Section 10: Resource Resource 00:00:00 Assignment Assignment - Python Programming Bible | Networking, GUI, Email, XML, CGI 00:00:00

REFERENCE CODE 603/5285/1 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview Who is this qualification for? This is a work-based learning qualification for those involved in laying floorcoverings in a Construction related working environment. Although many of the skills and knowledge across floorcovering occupations are generic, not all those employed to fit floorcoverings will be fitting the same product. The group of optional units will allow specialisms of timber based, textile and resilient floorcoverings. What is required from candidates? To achieve this pathway unit the survey work must be carried out in ways that will minimise the risk of damage to the work and surrounding area and using and maintaining equipment effectively. This qualification is made up of 9 mandatory units and a group of optional units. The minimum credit value of this qualification is 127 credits. Qualifications are now required to indicate the total qualification time (TQT), this is to show the typical time it will take someone to attain the required skills and knowledge to meet the qualification criteria, this qualification has a TQT of 1,270 hours. Qualifications are also required to indicate the number of hours of teaching someone would normally need to gain the skills and knowledge to achieve the qualification. These are referred to as Guided Learning Hours (GLH). The GLH for this qualification is 543 Mandatory units Level Credit Conforming to General Health, Safety and Welfare in the Workplace Conforming to Productive Working Practices in the Workplace Moving, Handling and Storing Resources in the Workplace Surface preparation to receive floorcoverings in the workplace Setting out for laying floorcoverings in the workplace Preparing and fitting underlays for floorcoverings in the workplace Develop customer relationships Assessing and preparing background surfaces for floor-covering in the workplace Assessing and evaluating conditions for floorcoverings in the workplace Optional Units (Minimum of 18 credits) Installing timber–based floorcoverings in the workplace Summary of the: GQA NVQ LEVEL 2 DIPLOMA IN FLOORCOVERING OCCUPATIONS (CONSTRUCTION) Installing textile floorcoverings in the workplace Installing resilient floorcoverings in the workplace Types of evidence: Evidence of knowledge is required. Evidence of knowledge through performance can contribute and if applicable should be demonstrated by completing projects and reports, by responding to questions or through Professional/Guided Discussions. Quantity of evidence: Evidence should show that you can meet the requirements of the units consistently over an appropriate period of time. Potential sources of evidence: Suggested sources of evidence are shown above, these can be supplemented by physical or documentary evidence, e.g.: Accident book/reporting system Notes and memos Safety record Telephone/e-mail records Training record Customer and colleague feedback Audio evidence Records of equipment and materials Witness testimonies Work records Photographic/ video evidence Please Note that photocopied or downloaded documents such as manufacturers or industry guidance, H&S policies, Risk Assessments etc, are not normally acceptable evidence for GQA qualifications unless accompanied by a record of a professional discussion or assessor statement confirming candidate knowledge of the subject. If you are in any doubt about the validity of evidence, please contact Oscar Onsite Academy

This module aims to develop knowledge from research activities to gain an understanding of international trade theory, global economic development and growth, currency and exchange rates, trade policies and their impact on an organisation, free trade agreements, direct investment from financial sources outside the UK, tariffs and no trade barriers, supply chain and logistics, intercultural management and international law and treaties.

This course will help you learn the fundamentals of OpenShift with the help of interesting assignments. In no time, you will be able to develop, deploy, and manage multi-services applications using OpenShift.

The purpose of this course is to teach you how to use Python for machine learning to create real-world algorithms. You will gain an in-depth understanding of the fundamentals of deep learning. This course will help you explore different frameworks in Python to solve real-world problems using the core concepts of deep learning and artificial intelligence.

This course primarily focuses on explaining the concepts of Python and PySpark. It will help you enhance your data analysis skills using structured Spark DataFrames APIs.

The course will provide a comprehensive overview of Consul and its capabilities, including deploying a single data center, registering services using service discovery, and accessing Consul Key/Value (KV). It is designed for individuals who possess basic terminal skills and have an understanding of application and data center/cloud networking architectures for running applications.

Fraud Prevention: A Guide for Small and Medium Sized Enterprises   Course Description   Copyright Ross Maynard 2021   Course Description Business fraud is a significant, and growing problem. Hardly a day goes by without news reports of organisations being hacked or having their data hijacked. Phishing scams and ID theft are also serious threats to businesses. According to data produced by Accenture, 43% of cyber attacks are aimed at small or medium sized organisations, but only 14% of those organisations are well protected. Around 60% of successful internet fraud cases are the result of phishing emails, and  30% of cases result from ID theft. These two approaches are increasingly being combined in business internet fraud. The aim of this course is to help managers in small or medium sized organisations understand the fraud risk that they face, and to take action to mitigate the risk. The course covers frauds risks, creating an anti-fraud culture and developing an fraud risk management strategy. The course comes with a fraud risk mini-audit and sample anti-fraud policies, and related policy documents. The best way to prevent fraud is to have clear anti-fraud policies and procedures which all staff understand, and which are rigorously enforced; coupled with an open, communicative environment, where staff feel safe and supported to question actions and raise concerns. To help your organisation put these elements in place, this course has five parts: Part 1: What is Fraud and Who Commits it? Part 2: Creating an Anti-Fraud Culture Part 3: Fraud Risk Management Part 4: Managing Bribery Risk Part 5: Appendices with sample anti-fraud policies, fraud response plans, a whistleblowing policy and anti-bribery policy.   I hope you find the course helpful.     Key Learning Points  On completion of the course, delegates will be able to: Define meaning and nature of business fraud Appreciate the variable nature of people’s honesty and how that can tip into fraud Understand the personality types of people who commit business fraud Identify the elements of an anti-fraud culture Explain the steps required to guard against internet fraud Understand the elements of a fraud risk management strategy Outline the sanctions available for those committing fraud Develop an Anti-Fraud Policy, Fraud Response Plan, Whistleblowing Policy and Anti-Bribery Policy for their organisation Begin to audit the level of fraud risk and bribery risk in their organisation     Curriculum Part 1: What is Fraud and Who Commits it? L1: What is Fraud? L2: The Variable Nature of Honesty Part 2: Creating an Anti-Fraud Culture L3: Creating an Anti-Fraud Culture L4: Internet Fraud and Cybercrime  Part 3: Fraud Risk Management L5: The Fraud Risk Management Strategy Part 1 L6: The Fraud Risk Management Strategy Part 2 L7: Sanctions for Fraud  L8: Tips to Help Prevent Fraud L9: The Fraud Risk Mini-Audit L10: Fraud Prevention Exercises Part 4: Managing Bribery Risk L11: The Bribery Act 2010 L12: The Bribery Risk Mini-Audit Part 5: Appendices Sample Anti-Fraud Policy 1 Sample Anti-Fraud Policy 2 Sample Fraud Response Plan 1 Sample Fraud Response Plan 2 Sample Whistleblowing Policy Sample Anti-Bribery Policy     Pre-Course Requirements There are no pre-course requirements     Additional Resources PDF copies of the following documents are provided with the course: Sample Anti-Fraud Policy 1 Sample Anti-Fraud Policy 2 Sample Fraud Response Plan 1 Sample Fraud Response Plan 2 Sample Whistleblowing Policy Sample Anti-Bribery Policy Sample Code of Ethics CIMA Fraud Risk Management Guide 2016 The Honesty Questionnaire The Fraud Risk Mini-Audit The Bribery Risk Mini Audit     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel