3906 Computing & IT courses in Dunfermline delivered On Demand

This course is the ultimate resource for developers of all levels looking to master Express Framework, SQL, and the powerful combination of Passport.js and Auth0. Whether you are starting out with web development or working in the field for years, this course will provide you with the skills and knowledge you need in order to build robust, dynamic web applications.

Do you want to learn how to install and configure Microsoft Windows Server 2019? Do you prefer learning hands-on as opposed to just a lecture and quiz? Then you are in the right place. This course teaches you the administration skills for installing and configuring a Microsoft Windows Server 2019 domain.

This is a hands-on training course with practical learning; know how to install, configure, and maintain Windows 10 in a Windows environment. Individuals who want to learn how to troubleshoot and diagnose Windows 10 and add Windows 10 to a Windows network will be highly beneficial.

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Get up to speed with effectively securing your cloud systems

Learn bash programming for Linux, Unix, & Mac. Learn how to write bash scripts like a pro & solve real-world problems!

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction Course Overview! 00:04:00 Installation And Getting Started The Final Milestone! 00:01:00 Installing and setting up PostgreSQL 00:09:00 Case Study : Demo Case Study Part 1 00:04:00 Case Study Part 2 00:06:00 Fundamental SQL statements CREATE 00:11:00 Exercise 1: Create DB and Table 00:01:00 INSERT 00:09:00 Import data from File 00:05:00 Exercise 2: Inserting and Importing 00:01:00 SELECT statement 00:03:00 SELECT DISTINCT 00:06:00 WHERE 00:04:00 Logical Operators 00:06:00 Exercise 3: SELECT & WHERE 00:01:00 UPDATE 00:05:00 DELETE 00:04:00 ALTER 00:17:00 Exercise 4: Updating Table 00:01:00 Restore And Back-Up Restore and Back-up 00:07:00 Exercise 5: Restore and Back-up 00:01:00 Selection Commands: Filtering IN 00:04:00 BETWEEN 00:05:00 LIKE 00:08:00 Exercise 6: In, Like & Between 00:01:00 Selection Commands: Ordering Side Lecture: Commenting in SQL 00:01:00 ORDER BY 00:07:00 LIMIT 00:03:00 Exercise 7: Sorting 00:01:00 Alias AS 00:03:00 Aggregate Commands COUNT 00:05:00 SUM 00:03:00 AVERAGE 00:03:00 MIN & MAX 00:04:00 Exercise 8: Aggregate functions 00:01:00 Group By Commands GROUP BY 00:12:00 HAVING 00:05:00 Exercise 9: Group By 00:01:00 Conditional Statement CASE WHEN 00:05:00 Joins Introduction to Joins 00:02:00 Inner Join 00:08:00 Left Join 00:07:00 Right Join 00:06:00 Full Outer Join 00:05:00 Cross Join 00:04:00 Except 00:03:00 Union 00:03:00 Exercise 10: Joins 00:01:00 Subqueries Subqueries 00:14:00 Exercise 11: Subqueries 00:01:00 Views And Indexes VIEWS 00:07:00 INDEX 00:06:00 Exercise 12: Views 00:01:00 String Functions LENGTH 00:03:00 Upper Lower 00:02:00 REPLACE 00:04:00 TRIM, LTRIM, RTRIM 00:07:00 CONCATENATION 00:03:00 SUBSTRING 00:06:00 LIST AGGREGATION 00:05:00 Exercise 13: String Functions 00:02:00 Mathematical Functions CEIL & FLOOR 00:03:00 RANDOM 00:05:00 SETSEED 00:04:00 ROUND 00:02:00 POWER 00:02:00 Exercise 14: Mathematical Functions 00:01:00 Date-Time Functions CURRENT DATE & TIME 00:04:00 AGE 00:03:00 EXTRACT 00:08:00 Exercise 15: Date-time functions 00:01:00 Pattern (String) Matching PATTERN MATCHING BASICS 00:07:00 ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS) 00:15:00 Exercise 16: Pattern Matching 00:01:00 Data Type Conversion Functions Converting Numbers/ Date to String 00:11:00 Converting String to Numbers/ Date 00:06:00 User Access Control Functions User Access Control 00:13:00 Bonus Section: Nail That Interview! Tablespace 00:05:00 PRIMARY KEY & FOREIGN KEY 00:05:00 ACID compliance 00:06:00 Truncate 00:04:00 Performance Tuning Tips TIP 1 (EXPLAIN) 00:04:00 TIP 2 00:01:00 TIP 3 00:02:00 TIP 4 (VACCUM) 00:01:00 TIP 5 00:02:00 TIP 6 (STRING FUNCTIONS) 00:02:00 TIP 7 (JOINS) 00:02:00 TIP 8 (SCHEMAS) 00:04:00 Bonus Section : Database Basics What is SQL 00:02:00 Tables and DBMS 00:03:00 Types of SQL commands 00:04:00 PostgreSQL 00:02:00 The Final Milestone! 00:01:00 Supplementary Resources Supplementary Resources - SQL Masterclass 00:00:00 Assessment Assessment - SQL Masterclass 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

This course will teach you the fundamentals of Jenkins and how to continually implement and deploy codes in a DevOps environment. You will also learn how to integrate automated tests to verify the build pipelines and set up code quality reporting.

Description: Video games are no longer only an entertainment, as there is a growing industry where video games are being considered as professional sports. They are influencing the modern culture so much, that some universities are now even offering scholarships to professional gamers. But in order to gamers to showcase their talents, there needs to be innovation at the basic level through the games developers. This Game Development Course can help you fill up that role by helping you to learn how to develop your own games. This course, like all good materials starts with an introduction to game creation, where you will also learn about the essential tools you will need for that endeavour. You will also understand the basics of game design and take a look at different 2D & 3D game creation softwares in the market. Next you focus a bit more on 3D game creation and learn about game modification. Furthermore you also learn about how to create a game on a social site as well. In the supporting materials section, you will find plenty of materials that will help you create your own game, and make a splash in the green. Who is the course for? Game makers or developers who want to improve their game development skills. People who have an interest in game development and software. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Game Development Course is a useful qualification to possess, and would be beneficial for the following careers: Animator Assistant Producer Audio Engineer Creative Director Game Designer Game Developer Game Programmer Games Artist Product Manager Software Developer. Game Development Course Introduction To Game Creation 00:30: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 Supporting Materials 2D Game 00:00:00 Game Development XNA GameStudio 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam-Game Development Course 00:20:00 Final Exam Final Exam-Game Development Course 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Description Perfect for beginners who want to pursue a career in the video games industry, this Introduction to Game Design Course covers the primary skills and opportunities in gaming development. You will explore game design and game design concepts: familiarising with essential tools, paper and digital game prototyping, design iteration, and user testing.  Learn how to make computer games with no coding skills. Understand how to analyse the mechanics of paper and digital games, how they affect gameplay and player experiences. You'll also be able to design, develop, and test paper and digital prototype games using an iterative design process and incorporating user feedback. By the end of this game design course, you will have a solid knowledge of the game design process and will have created a 2D computer game that can be played on a desktop computer and mobile device.  Are you interested in a career in creative media? Enrol in this game production course today and take steps to become a fully qualified game developer. 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? Introduction to Game Design 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 Introduction to Game Design 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. Game Structure Introduction FREE 00:01:00 What Is A Game 00:06:00 Game Types 00:06:00 Game Loops 00:06:00 Game Arcs 00:04:00 Game Industry Game Roles - Part 1 00:07:00 Game Roles - Part 2 00:07:00 Game Industry 00:06:00 Game Purposes 00:05:00 Game Layers Game Layers - How to separate elements 00:06:00 Tutorials - How to teach the player 00:06:00 Licensing - How to get free assets 00:06:00 Development Game Design Document and Game Design Canvas 00:06:00 Crowdfunding 00:05:00 Publishing 00:04:00 Top 10 Game Designer Mistakes 00:06:00 Thank You And Congratulations 00:01:00 Resources Resources - Introduction to Game Design 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00