779 Courses in Cardiff delivered On Demand

Master SQL Database Queries with our comprehensive course. Learn SQL fundamentals, advanced techniques, and data analysis skills for efficient database management.

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

SQL Azure is Microsoft's cloud database service. Based on SQL Server database technology and built on Microsoft's Windows Azure cloud computing platform, SQL Azure enables organizations to store relational data in the cloud and quickly scale the size of their databases up or down as business needs change.  This Azure - SQL focuses primarily on Azure SQL Database as a database service that can quickly and efficiently scale to meet demand, is automatically highly available, and supports a variety of third party software. Learn how to deploy relational and non-relational databases in the cloud and explore the breadth of Azure's data services, from a single database instance to a massive scale data warehouse for working with Big data. You'll gain an understanding of how to configure firewall rules, manage log-ins and users, as well as roles and permissions, perform a database restore, and generally secure an Azure SQL database. Finally, you'll be introduced to Azure SQL Data Warehouse, a fully managed and scalable cloud service, that is compatible with other Azure offerings, such as Machine Learning and Data Factory, as well as existing SQL Server tools. What Will I Learn? Overview and provision Azure SQL Connect to Azure SQL DB and Migrate DB to Azure Work with SQL security and metrics Configure SQL DB auditing Copy and export a database Use DB Self-Service Restore and SQL DB Geo-Replication Who is the target audience? Students wanting an understanding of Azure SQL and to build their skills. Requirements Basic understanding of Azure and SQL concepts Introduction Introduction FREE 00:02:00 Azure SQL Azure SQL 00:02:00 Provisioning Azure SQL 00:06:00 Connecting to Azure SQL DB 00:08:00 Migrating to Azure DB 00:06:00 Understanding SQL Security 00:03:00 Understanding SQL DB Metrics and Auditing 00:05:00 Backing Up and Protecting your Database 00:05:00 Using SQL DB Geo-Replication 00:03:00 Conclusion Course Recap 00:02:00 Course Certification

Give a compliment to your career and take it to the next level. This Supply Chain Management bundle 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 Supply Chain Management bundle will help you stay ahead of the pack. Throughout the Supply Chain Management programme, 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 Supply Chain Management course, you will get 10 premium courses, an originalhardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Supply Chain Management Bundle Consists of the following Premium courses: Course 01: Supply Chain Management Course 02: Operations Management Course 03: Import/Export Processing Course 04: Logistic Management Course 05: Purchasing & Procurement Course - Level 3 Course 06: SAP S4HANA Controlling Level 2 Course 07: Commercial Law 2021 Course 08: Warehouse Course 09: Transport Management Diploma Course 10: Diploma in Lean Process and Six Sigma Course 11: People Management Skills Level 3 Enrol now in Supply Chain Management to advance your career, and use the premium study materials from Apex Learning. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Supply Chain Management expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Curriculum of Supply Chain Management Bundle Course 01: Supply Chain Management An overview of Supply Chain Management Role of logistics of Supply Chain Customer Response Principles and Systems Supply Chain System and Principles Global Supply Chain Operations Inventory Strategies for Supply Chain Warehouse Management and Operations Supply Chain Design and Monitoring Supply Chain Network and Evaluating Supply Chain Planning and New Business Concepts Aligning your supply chain process with your business Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Supply Chain Management bundle. Requirements This Supply Chain Management 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 (Supply Chain Management) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The de.livery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost

Course Overview Master multi-track digital audio editing, with Adobe Audition. The Complete Adobe Audition Masterclass is the ultimate training program for learners of all levels. It will teach you how to perform a wide range of basic and advanced tasks, with tips on how to save time on editing and improve audio quality on your mobile recordings. You will learn how to apply effects, export MP3, work with multiple audio files, cut, copy, split, paste, and edit with skills and precision. By the end of this course, you will be able to create, edit and mix audio like a pro, and will be fully familiar with industry standards and tools to start creating high-quality projects in no time. This best selling Complete Adobe Audition Masterclass has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Complete Adobe Audition Masterclass is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Complete Adobe Audition Masterclass 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 Complete Adobe Audition Masterclass 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 Complete Adobe Audition Masterclass, 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 Complete Adobe Audition Masterclass 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 Complete Adobe Audition Masterclass 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.

Course Overview The Professional After Effect for Photography course is suitable for photographers, graphic designers, artists and creative professionals looking to master Adobe After Effects. Through instructor-led guidance, you will learn how to use After Effects' basic and advanced tools and features to produce stunning imagery for your professional portfolio. You will start by familiarising with the After Effects interface, and learning how to import and export files from Photoshop. Next, you will move on to creating special effects, colouring techniques, and making and editing patterns and textures. Through high-quality audiovisual training, you will gain the most in-demand skills to edit and enhance your photos digitally. Start building your portfolio and take your creative work to the next level, by enrolling in this complete step-by-step training course today. This best selling Professional After Effect for Photography has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Professional After Effect for Photography is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Professional After Effect for Photography 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 Professional After Effect for Photography 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 Professional After Effect for Photography, 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 Professional After Effect for Photography 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 Professional After Effect for Photography 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.

If you are looking forward to advance your skills with Microsoft Excel 2016 and want to learn more advanced skills or want to learn the topics covered in this course in the 2016 interface, this Excel 2016 Advanced will be the perfect choice for you! Through the course you will gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. Additionally, you will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in your worksheets and workbooks. You will also learn about Excel's many collaboration features, as well as how to import and export data to and from your workbooks. What Will I Learn? Use Advanced IF Statements Use Advanced Lookup Functions Use Complex Logical and Text Functions Auditing Formulas Working with What-If Analysis Tools Protecting Worksheet and Workbook Use Advanced PivotTables and PowerPivot Tools Automate with Macros Work with Form Controls Ensure Data Integrity Collaborate in Excel Import and Export Data to a Text File Requirements Excel Introduction and Intermediate courses or equivalent experience. Who is the target audience? Students who want to expand their Excel knowledge. Introduction Introduction FREE 00:01:00 Using Advanced IF Statements Summarize Data with SUMIF FREE 00:04:00 Summarize Data with AVERAGIF 00:03:00 Summarize Data with COUNTIF 00:02:00 Using Advanced Lookup Functions Using VLOOKUP with TRUE to find an Approximate Match 00:04:00 Using HLOOKUP TRUE to find an Approximate Match 00:01:00 Using the Index Function 00:03:00 Using the Match Function 00:02:00 Creating a Combined Index and Match Formula 00:04:00 Comparing Two Lists with VLOOKUP 00:02:00 Comparing Two Lists with VLOOKUP and ISNA 00:04:00 Using Complex Logical and Text Functions Creating a Nested IF Function 00:03:00 Using the IFERROR Function 00:02:00 Using the LEN Function 00:02:00 Using the TRIM Function 00:01:00 Using the Substitute Function 00:02:00 Formula Auditing Showing Formulas 00:01:00 Tracing Cell Precedents and Dependents 00:03:00 Adding a watch Window 00:02:00 Error Checking 00:02:00 What-If Analysis Tools Using the Scenario Manager 00:03:00 Using Goal Seek 00:02:00 Analyzing with Data Tables 00:02:00 Worksheet and Workbook Protection Protection Overview 00:02:00 Excel File Password Encryption 00:03:00 Allowing Specific Worksheet Changes 00:01:00 Adding Protection to only Certain Cells in a Worksheet 00:03:00 Additional Protection Features 00:02:00 Advanced Use of PivotTables and PowerPivot Using the Pivot Tables Charts Wizard 00:02:00 Adding a Calculated Field 00:02:00 Adding a Caculated Item 00:02:00 Apply Conditional Formatting to a Pivot Table 00:03:00 Using Filters in the Pivot Table Fields Pane 00:02:00 Creating Filter Pages for a Pivot Table 00:01:00 Enabling a Power Pivot Add In 00:04:00 Automating with Macros What are Macros 00:03:00 Displaying the Developer Tab and Enabling Macros in Excel 00:03:00 Creating a Basic Formatting Macro 00:03:00 Running a Macro 00:02:00 Assigning a Macro to a Button 00:02:00 Creating a More Complex Macro 00:02:00 Viewing and Editing the VBA Code for an Existing Macro 00:03:00 Adding a Macro to the Quick Access Toolbar 00:02:00 Working with Form Controls What are Form Controls 00:02:00 Adding Spin Buttons and Check Boxes to a Spreadsheet 00:02:00 Adding a Combo Box to a Spreadsheet 00:02:00 Ensuring Data Integrity What is Data Validation 00:01:00 Restricting Data Entries to Whole Numbers 00:02:00 Data Validation Restricting Data Entry to a List 00:01:00 Data Validation Restricting Data Entry to a Date 00:01:00 Data Validation Restricting Data Entry to Different Text Lengths 00:01:00 Composing Input Messages 00:02:00 Composing Error Alters 00:02:00 Finding Invalid Data 00:02:00 Editing and Deleting Data Validation Rules 00:01:00 Collaborating in Excel Working with Comments 00:03:00 Printing Comments and Errors 00:02:00 Sharing a Workbook 00:03:00 Tracking Changes in a Workbook 00:03:00 Working with Versions 00:02:00 Sharing Files via Email 00:02:00 Importing and Exporting Data to a Text File Importing a Text File 00:03:00 Exporting a Text File 00:01:00 Conclusion Course Recap 00:01:00 Course Certification

The aim of the International Business Operations course is to provide students with a comprehensive understanding of the key concepts and practices involved in conducting business on a global scale.After the successful completion of the course, you will be able to learn about the following, International Business Operations. Factors Impacting Production. Make or Buy Decisions. Supply Chain Issues. Global Supply Chain Optimisation. Global Marketing Mix. Financing In International Business. Foreign Exchange Risks. Conflict Management. International Negotiations. Ethical Issues In International Business. The aim of the International Business Operations course is to provide students with a comprehensive understanding of the key concepts and practices involved in conducting business on a global scale. By the end of the course, students should be able to analyze and evaluate the challenges and opportunities presented by international business operations and develop strategies to navigate these complexities in a competitive global marketplace. The International Business Operations course is designed to equip students with the knowledge and skills needed to navigate the complexities of conducting business across national borders. Topics covered may include international trade laws, cultural differences, global supply chain management, and multinational business strategy. Students will gain an understanding of the challenges and opportunities presented by operating in a global marketplace. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. International Business Operations Self-paced pre-recorded learning content on this topic. International Business Operations Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor International Business Manager Global Operations Manager International Trade Specialist Supply Chain Manager International Marketing Manager Global Business Analyst International Finance Manager International Business Consultant Export Manager Foreign Market Analyst Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Elevate your SQL skills with our Microsoft SQL Server Bootcamp 2024. Master SQL Server administration and development for data-driven decision-making and analysis.

24 Hour Flash Deal **25-in-1 Professional Train Driver Mega Bundle** Professional Train Driver Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Professional Train Driver package online with Studyhub through our online learning platform. The Professional Train Driver bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Professional Train Driver course provides complete 360-degree training on Professional Train Driver. You'll get not one, not two, not three, but twenty-five Professional Train Driver courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Professional Train Driver courses are yours for as long as you want them once you enrol in this course This Professional Train Driver Bundle consists the following career oriented courses: Course 01: Trainee Train Driver Course Course 02: Driving Theory Test Preparation Course 03: Driver Safety and Vehicle Maintenance Course 04: Driving Instructor Training Course 05: Manual Handling Training Course 06: Portable Appliance Testing and Risk Assessment Training Course 07: Fire Risk Assessment Course 08: Emergency First Aid at Work Course 09: Electronic Device Maintenance and Troubleshooting Course Course 10: Engine Lubrication Systems Online Course Course 11: Transport Manager Course 12: Facilities Management Course 13: Transport & Logistic Management Course 14: Supply Chain Management Course 15: Logistic Management Course 16: Lean Production, Logistics and Supply Chain Management Training Course 17: Import/Export (International Trade) Management & Processing Course 18: Port Management Course 19: FMCG Training for Operator Manager Course 20: CSR Policies & Supply Chain Management Course 21: Quality Management and Strategic Training - ISO 9001 Course 22: Professional Crisis Management Certificate Course 23: Conflict Management Course 24: Project and Operation Management Course 25: Time Management The Professional Train Driver course has been prepared by focusing largely on Professional Train Driver career readiness. It has been designed by our Professional Train Driver specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Professional Train Driver Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Professional Train Driver bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Professional Train Driver Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Professional Train Driver Elementary modules, allowing our students to grasp each lesson quickly. The Professional Train Driver course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive Professional Train Driver bundle, you really hit the jackpot. Here's what you get: Step by step Professional Train Driver lessons One to one assistance from Professional Train Driverprofessionals if you need it Innovative exams to test your knowledge after the Professional Train Drivercourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Professional Train Driver courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Professional Train Driver certificate and transcript on the next working day Easily learn the Professional Train Driver skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Professional Train Driver training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Professional Train Driver Requirements To participate in this Professional Train Driver course, all you need is - A smart device A secure internet connection And a keen interest in Professional Train Driver Career path You will be able to kickstart your Professional Train Driver career because this course includes various courses as a bonus. This Professional Train Driver is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Professional Train Driver career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free