2377 Programming courses in Liverpool delivered Online

In this course, you will learn full-stack web development with React JS for the frontend and Python Django for the backend. You will learn and explore various databases such as Microsoft SQL Server, MySQL, MongoDB, PostgreSQL, and SQLite.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for individuals who are Application designers and database developers, database administrators and web server administrators. Overview Upon successful completion of this course, students will be able to work with Oracle database programming using the PL/SQL programming language. They will learn the syntax, structure and features of the language. In this course, students will learn the foundation for the programming series and the use of database-resident stored program units for Oracle 12c. Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL*Plus Setup Jdeveloper About Bind & Substitution Variables Using SQL Developer Using SQL*Plus Choosing a Database Programming Language What is Database Programming? PL?SQL Performance Advantages Integration wth Other Languages PL/SQL Language Fundamentals PL/SQL Program Structure LANGUAGE SYNTAX RULES EMBEDDING SQL WRITING READABLE CODE GENERATING DATABASE OUTPUT SQL*PLUS INPUT OF A PROGRAM BLOCK Declare Section About the Declare Section DECLARE PRIMITIVE TYPES DECLARATION OPTIONS NOT NULL CONSTANT DATA DICTIONARY INTEGRATION %TYPE DECLARE SIMPLE USER---DEFINED TYPES TYPE... TABLE TYPE... RECORD EXTENDED USER---DEFINED TYPES Begin Section About the Begin Section Manipulating Program Data Logic Control & Branching GOTO LOOP IF-THEN-ELSE CASE Exception Section ABOUT THE EXCEPTION SECTION ISOLATING THE SPECIFIC EXCEPTION PRAGMA EXCEPTION_INIT SQLCODE &SQLERRM Example SQL%ROWCOUNT &SELECT...INTO Beyond the Basics: Explicit Cursors ABOUT EXPLICIT CURSORS EXTENDED CURSOR TECHNIQUES FOR UPDATE OF Clause WHERE CURRENT OF Clause Using FOR?LOOP Cursors Beyond the Basics: Nested BlocksBeyond the Basics: Declared Subprograms USING DECLARED SUBPROGRAMS DECLARED PROCEDURE DECLARED FUNCTION Introducing Databse-Resident Program Units ABOUT DATABASE---RESIDENT PROGRAMS PHYSICAL STORAGE & EXECUTION TYPES OF STORED PROGRAM UNITS STORED PROGRAM UNIT ADVANTAGES MODULAR DESIGN PRINCIPLES Creating Stored Procedures & Functions STORED PROCEDURES & FUNCTIONS CREATE PROCEDURE / CREATE FUNCTION CREATING PROCEDURES & FUNCTIONS RAISE_SALARY() Procedure SALARY_VALID() Function THE PARAMETER SPECIFICATION DEFAULT Clause SYSTEM & OBJECT PRIVILEGES USING THE DEVELOPMENT TOOLS Executing Stored Procedures & Functions CALLING PROCEDURES & FUNCTIONS UNIT TESTING WITH EXECUTE ANONYMOUS BLOCK UNIT TESTING SPECIFYING A PARAMETER NOTATION SQL WORKSHEET UNIT TESTING CALLING FUNCTIONS FROM SQL Maintaining Stored Program Units RECOMPILING PROGRAMS Mass Recompilation Using UTL_RECOMP() DROPPING PROCEDURES & FUNCTIONS DROP PROCEDURE / FUNCTION DATA DICTIONARY METADATA Using USER_OBJECTS Using USER_SOURCE Using USER_ERRORS Using USER_OBJECT_SIZE Using USER_DEPENDENCIES Managing Dependencies DEPENDENCY INTERNALS TRACKING DEPENDENCIES THE DEPENDENCY TRACKING UTILITY SQL DEVELOPER DEPENDENCY INFO DEPENDENCY STRATEGY CHECKLISTS Creating & Maintaining Packages ABOUT PACKAGES CREATING PACKAGES MAINTAINING PACKAGES PERFORMANCE CONSIDERATIONS Advanced Package Capabilities DEFINER & INVOKER RIGHTS WHITE LITS & ACCESSIBLE BY PERSISTENT GLOBAL OBJECTS DEFINING INITIALIZATION LOGIC OBJECT ORIENTATION SUPPORT Advanced Cursor Techniques USING CUSROS VARIABLES USING SYS_REFCURSOR USING CURSOR EXPRESSIONS Using System-Supplied Package DBMS_OUTPUT() UTL_FILE() FOPEN() EXAMPLE Database Trigger Concepts ABOUT DATABASE TRIGGERS DML EVENT TRIGGER SUB---TYPES DATABASE TRIGGER SCENARIO TRIGGER EXECUTION MECHANISMS TRIGGERS WITHIN SQL WORKSHEET Creating Database Triggers STATEMENT-LEVEL TRIGGERS Using RAISE_APPLICATION_ERROR() ROW---LEVEL TRIGGERS EXAMPLES OF TRIGGERS EMPLOYEE_SALARY_CHECK Example EMPLOYEE_JOURNAL Example BUDGET_EVENT Example INSTEAD OF TRIGGERS TRIGGERS WITHIN AN APPLICATION Maintaining Database Triggers CALL SYNTAX TRIGGER MAINTENANCE TASKS SHOW ERRORS TRIGGER DROP TRIGGER ALTER TRIGGER MULTIPLE TRIGGERS FOR A TABLE HANDLING MUTATING TABLE ISSUES Implementing System Event Triggers WHAT ARE SYSTEM EVENT TRIGGERS? DEFININGTHE SCOPE AVAILABLE SYSTEM EVENTS SYSTEM EVENT ATTRIBUTES Additional course details: Nexus Humans Oracle 12c PL/SQL Fundamentals 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 Oracle 12c PL/SQL Fundamentals 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.

Course Overview Do you want to familiarize with various programming structure and build your career as a software engineer? Then this course is perfect for you. Learn how you can use HTML CSS my SQL GitHub XAMPP and Heroku from this Modern PHP/MYSQL/ GitHub & Heroku Tutorial course and boost your programming skill in no time. This Modern PHP/MYSQL/ GitHub & Heroku Tutorial course will teach you the function of different platforms of web development. You will learn about PHP, bootstrap, MySQL, GitHub and Heroku. The lessons will help you understand programming structures from scratch and explore different areas of web development. The activities of the course will help you to practice the knowledge you learn and enhance your skill. You'll be able to work and create sample websites with the lectures.  You'll receive certifications after completing the course. This course can be a stepping stone for you to enhance your skill and be a professional web developer. Learning Outcomes Understand how XAMPP works Familiarize with the role of PHP in web-based programs Setup Apache server and PHP environment using XAMPP server Learn how to use GitHub Be able to build data-driven and dynamic web applications Learn how to deploy web applications using Heroku Learn the basics of bootstrap 4 Who is this course for? This course is a complete package of the database, PHP, Bootstrap and GitHub. This is ideal for anyone who wants to learn software designing and its steps. The course will teach you the necessary skills and knowledge you need for software development from scratch. 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. Certification After you have successfully completed the course, 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 the cost of £39 or in PDF format at the 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 recognized 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 Modern PHP/MYSQL/ GitHub & Heroku Tutorial Course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Web Developers Web Designers Software Developers PHP Developers App Designers Unit 01: Introduction Introduction 00:06:00 Unit 02: Environment Configuration Module 01: Setup a PHP Environment using XAMPP 00:16:00 Module 02: Install Composer Package Manager 00:03:00 Module 03: Visual Studio Code - Web Development Add ons 00:12:00 Module 04: Create a GitHub Account 00:13:00 Module 05: Create a Heroku Account 00:08:00 Unit 03: PHP Basics and Syntax Module 01: How PHP Works 00:29:00 Module 02: IFELSE Statements 00:19:00 Module 03: Switch Statements 00:09:00 Module 04: FOR Loop 00:10:00 Module 05: WHILE AND DOWHILE Loops 00:14:00 Module 06: PHP Arrays and Manipulation 00:13:00 Module 07: String Manipulation Functions 00:28:00 Module 08: Date and Time Manipulation Functions 00:15:00 Module 09: User Defined Functions 00:22:00 Module 10: PHP Include and Require 00:22:00 Module 11: PHP Website Layout - With Bootstra 00:23:00 Module 12: Add Project to Github 00:08:00 Module 13: Publish Website to Heroku 00:20:00 Unit 04: PHP Forms and MySQL and User Authentication Module 01: Project and Website Setup 00:21:00 Module 02: Create a Bootstrap 4 Form 00:28:00 Module 03: PHP Form - $_GET Action 00:23:00 Module 04: PHP Form - $_POST Action 00:11:00 Module 05: Design Database with phpMyAdmin 00:19:00 Module 06: Connect to Database using PHP PDO 00:18:00 Module 07: Save Records to Database 00:38:00 Module 08: View Database Records 00:36:00 Module 09: View One Record's Details 00:28:00 Module 10: Update Database Records 00:34:00 Module 11: Delete Database Records 00:11:00 Module 12: Final Touches: Form Validation, Error Messages, Success Messages 00:17:00 Module 13: Create Heroku App and Remote Database 00:21:00 Module 14: Setup Authentication Tables in Database 00:20:00 Module 15: Setup Login and Authentication 00:29:00 Module 16: Control User Access 00:08:00 Module 17: Sending Confirmation Emails 00:31:00 Module 18: Upload Profile Pictures 00:31:00 Module 19: Final Touches 00:14:00 Resources Resources - Modern PHP/MYSQL/ GitHub & Heroku Tutorial 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Welcome to the realm of JavaScript, where functions are the virtuosos orchestrating the code symphony. In our course, 'JavaScript Functions,' we transcend the basics and delve into the intricacies of this programming language's powerhouse. Imagine your code as a musical composition, and functions as the notes that shape it. From the fundamentals explored in the introduction to the intricacies of asynchronous functions, this course is a journey into the artistry of JavaScript. Prepare to redefine your understanding of functions as we navigate through defining, invoking, and understanding their scope. Composing functions is not just about syntax; it's about creating harmonious code that resonates with efficiency. This isn't your ordinary coding class; this is an odyssey into the heart of JavaScript functions, where each unit is a movement in the symphony of programming. Learning Outcomes Master the fundamentals of JavaScript Functions. Skillfully define and invoke functions. Understand the intricacies of function scope. Compose functions to create efficient and elegant code. Dive into the world of asynchronous functions. Why choose this JavaScript functions course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this JavaScript functions course for? Aspiring developers eager to elevate their JavaScript skills. Students pursuing computer science or programming degrees. Professionals looking to enhance their coding expertise. Entrepreneurs wanting to understand the backbone of web development. Anyone with a passion for learning the language that powers the web. Career path Frontend Developer: £25,000 - £45,000 JavaScript Developer: £30,000 - £55,000 Full Stack Developer: £35,000 - £65,000 Software Engineer: £40,000 - £70,000 Web Development Manager: £45,000 - £80,000 Technical Architect: £50,000 - £90,000 Prerequisites This JavaScript Functions does not require you to have any prior qualifications or experience. You can just enrol and start learning.This JavaScript Functions 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Unit 01: Introduction Introduction 00:02:00 Why use JavaScript functions? 00:06:00 Unit 02: Defining and Invoking Functions Defining and Invoking Functions 00:04:00 Demo: Invoking and Defining JavaScript functions 00:07:00 Alternate ways to define functions 00:01:00 Demo: Alternate ways to define functions 00:04:00 Unit 03: Function Scope What is function scope? 00:03:00 Demo: Exploring Function Scope 00:04:00 Child Function Scope 00:02:00 Demo: Child Function Scope 00:06:00 Unit 04: Composing Functions What is function composition? 00:02:00 Demo: Currying Functions 00:05:00 Factory Functions3 00:01:00 Demo: Factory Functions 00:04:00 Unit 05: Asynchronous Functions What are callback functions?3 00:01:00 Demo: Callback Functions3 00:04:00 Promises, Async and Generators3 00:06:00 The 'this' keyword & demo3 00:04:00 Self-Invoking Functions & demo3 00:03:00 Error Catching & demo3 00:04:00 Object Creators & demo3 00:03:00 Course Summary3 00:02:00 Assignment Assignment - JavaScript Functions 00:00:00

A carefully structured advanced-level course on Apache Spark 3 to help you clear your job interviews. This course covers advanced topics and concepts that are part of the Databricks Spark certification exam. Boost your skills in Spark 3 architecture and memory management.

Do you want to learn to code? Are you already on your way, but need a boost? Is the motivation a challenge and you want some external accountability? Do you want deeper technical discussions than you can find elsewhere? Or just want a frank chat about whether you have what it takes to succeed? Come study with me.

Learn the power of Google Script and see how you can connect Google Spreadsheet as a data source for a post board

Why Choose Unity 3D Game Design Training Course? Course Link Unity transforms ideas into reality, offering limitless possibilities for 2D and 3D games, VR, AR, and AI experiences. From films to architecture, training videos, and interactive tutorials, Unity revolutionizes industries with its interactive engagement, making it the top choice for solutions. Duration: 10 hrs Method: 1-on-1, Personalized attention Schedule: Tailor your own hours of your choice, available from Mon to Sat between 9 am and 7 pm Is Unity Good for Beginners? Definitely! Unity is an ideal starting point for beginners in game development. It offers an accessible platform to learn state logic and C# programming, making it popular among new programmers. Whether you choose self-guided or structured learning, Unity provides a strong foundation for 3D game development. Coding in Unity? Coding is optional in Unity, thanks to the visual scripting tool, Bolt. Users can implement ideas without coding using flow graphs and state graphs for low-level and high-level logic. Paid tools like PlayMaker and Adventure Creator offer more advanced gameplay and AI behaviors. How Does Unity's Game Engine Work? Unity operates as a versatile scene player, initializing settings for graphics, audio, and input devices at game start. It loads scenes with assets and game objects, executing a cycle that renders scenes, runs physics simulations, and handles events, providing a seamless and dynamic game experience. Is Unity Good for Beginners? Definitely! Unity is an ideal starting point for beginners in game development. It offers an accessible platform to learn state logic and C# programming, making it popular among new programmers. Whether you choose self-guided or structured learning, Unity provides a strong foundation for 3D game development. 10-hour Unity 3D Game Design Training Course: Module 1: Introduction to Unity 3D (2 hours) - What is Unity 3D and why use it for game design? - Understanding the Unity 3D interface - Creating and managing projects in Unity 3D - Importing and managing assets in Unity 3D - Understanding game objects and components in Unity 3D Module 2: Game Mechanics (2 hours) - Basic game mechanics and concepts - Player movement and camera control - Creating and controlling game objects - Working with physics and collision detection - Creating interactive environments Module 3: Scripting with C# (2 hours) - Introduction to C# scripting language - Understanding variables and data types in C# - Creating and using functions in C# - Controlling game objects with C# - Understanding game loops and events Module 4: User Interfaces and Audio (2 hours) - Designing user interfaces in Unity 3D - Creating and using buttons, sliders, and input fields - Audio import and editing in Unity 3D - Creating and controlling game sound effects and background music Module 5: Optimization and Deployment (2 hours) - Understanding game optimization in Unity 3D - Optimizing game performance with scripting - Building and testing games for desktop and mobile platforms - Publishing games on the web or app stores Introduction to Unity: - Introduction to gaming and the game development process - Unity Basics - Interface - Inspector - Project and Hierarchy Starting Making a Game: - Working with Projects - Creating Projects - Importing Geometry - Importing Textures - Using the terrain generator to make the terrain - Creating basic primitives in Unity Materials: - Working with materials 1 - Working with materials 2 - Finishing materials on all objects Lighting: - Creating lights - Adjusting Lights - Creating Sunlight Animation: - Animating objects - Animating lights - Adjusting Animations Audio: - Adding Sound - Interacting with sound - Modifying sound Programming Tools: - JavaScript - Editor for JavaScript - Variables and functions - Simple programming Testing: - Testing the game - Fixing bugs - Making changes in games Building the Game: - Game authoring Settings - Building the game for windows - Playing the game Utilize Unity Pro, the ultimate real-time development platform, to craft 3D, 2D, VR, and AR experiences across diverse industries. From games to auto, AEC, and film, Unity Pro empowers you to create immersive content with multi-platform support. Visit https://www.unity.com/ to kickstart your journey today, enabling faster iterations and business growth through unparalleled development capabilities.

jQuery is a very powerful framework used by all the big companies like Microsoft, Apple, Google etc. It is cross-platform.

Introduction to AutoCAD Learning with the Introduction to AutoCAD is essential for anybody engaged with the plan and drafting-based enterprises, including producing, designing, visual computerization, engineering and some more. Regardless of whether you need to improve your present range of abilities or are hoping to begin your profession, this is your definitive initial guide. This course gives an extensive manual for AutoCAD, one of the world's best plan and drafting apparatuses, by dissecting the extraordinary highlights and capacities and illustrating the particular uses in different ventures. From its incorporation and similarity capacities with other programming and records, to a full manual for every one of the business explicit variants, this course gives the ideal prologue to AutoCAD. You Will Learn: A full meaning of AutoCAD, its experience and how it works The unique highlights and abilities of AutoCAD How AutoCAD coordinates capacities and offers similarity with outsider programming and information A complete manual for every last one of the business explicit forms, including their highlights and instruments Advantages of Taking This Course: You will improve your general information on Computer-Aided Design (CAD) You will actually want to settle on an educated AutoCAD item decision for your particular necessities You will start your excursion to consolidating AutoCAD aptitude into your resume You will try not to sit around and cash on second rate CAD programming choices