2216 Developer courses delivered Online

Python Programming from Scratch with MySQL Database is a beginner-friendly course designed to teach you everything you need to know to start with Python programming and MySQL databases. Using these powerful tools, you'll learn how to build dynamic web applications and websites.

OCA Prep Included

Oracle SQL training course description The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create SQL statements to query database tables. Use standard aggregate functions and related SELECT statement clauses. Join Tables. Use basic subqueries and the set operators. Use numeric, character and date functions. Use conversion and other miscellaneous functions. Use SQL parameters. Use complex subqueries. Create and alter tables and views. Insert, update and delete rows in database tables. Manage sequences and synonyms. Oracle SQL training course details Who will benefit: Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database. Prerequisites: None. Duration 3 days Oracle SQL training course contents Retrieving data with the SELECT statement The SELECT statement, The SELECT and FROM clauses, Conditions and the WHERE clause, Other conditional operators, Logical operators, The ORDER BY clause, Column aliases, Arithmetic expressions, Precedence of operators. Aggregate functions Overview of built In aggregate functions, The GROUP BY clause, The HAVING clause. Joining tables Overview of table joins, Inner joins, Table aliases, Outer joins, Self joins, ANSI standard joins. Basic subqueries and set operators Overview of subqueries, Basic subqueries, Set operators, The union, intersect and ,minus operators. Numeric, character and data functions Function types, Using the table dual to try out functions, Numeric functions, Character functions, String concatenation, Date arithmetic and date functions. Conversion and miscellaneous functions Conversion functions, The NVL and NVL2 functions, The DECODE function, CASE expressions, The COALESCE and NULLIF functions. SQL parameters Command line substitution parameters, The accept command, The define and undefine commands. Complex subqueries Subqueries usage, In-line views, Top-N queries, Subqueries with joins, Multi column subqueries, Correlated subqueries, Subquery rules, Using the ANY, ALL and SOME operators. Managing data Inserting rows, Updating rows, Deleting rows, Verifying updates, Transaction control, Commit and rollback, Savepoints, Commits and constraints, Amending data in SQL developer. Managing tables Creating tables, Specifying constraints, Altering tables, columns and constraints, Dropping tables, columns and constraints, Recovering dropped tables, Copying tables. Managing indexes and views Creating indexes, Dropping indexes, Listing indexes, Creating and using views, Dropping views, Listing views. Managing sequences and synonyms Create a sequence, View sequence details, Create a synonym, List synonyms.

Build 9 projects to master 2 essential and modern technologies: Python and PostgreSQL

A course by Sekhar Metla IT Industry Expert RequirementsNo prior technical experience is required! All you need a computer!No SQL experience needed. You will learn everything you need to knowNo software is required in advance of the course (all software used in the course is free) Audience Beginner SQL, Data Science and Analytics - developers curious about SQL Career Anyone who wants to generate new income streams Anyone who works with data analytics, or databases! Anyone who wants to become Business intelligence developer Anyone who wants to start their own business or become freelance Anyone who wants to become a Data Science developer If you work in: marketing, finance, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects information Someone who wants to learn skills that give them the potential to earn near SIX figures! Audience Beginner SQL, Data Science and Analytics - developers curious about SQL Career Anyone who wants to generate new income streams Anyone who works with data analytics, or databases! Anyone who wants to become Business intelligence developer Anyone who wants to start their own business or become freelance Anyone who wants to become a Data Science developer If you work in: marketing, finance, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects information Someone who wants to learn skills that give them the potential to earn near SIX figures!

Unlock the secrets of PHP and MySQL web development with this comprehensive course. Learn the basics of PHP and MySQL and object-oriented programming (OOP) concepts to create dynamic and interactive websites and web applications.

Overview In an era dominated by the digital realm, creating seamless mobile and web applications is more essential than ever. Introducing our 'Mobile and Web Development with Ionic & Angular JS' course. This comprehensive course not only introduces you to the riveting domain of web development but also delves deep into the intricacies of Ionic & Angular JS, two of the most sought-after technologies in the industry. Whether you're an aspiring developer or a technophile keen on understanding the digital fabric that shapes our online experiences, this course will enlighten, inspire, and equip you with the requisite skills to craft intuitive applications. You'll be guided through every step across the extensive curriculum, beginning with a brief introduction, from initial setup to rigorous testing. But the crux of this course lies in its focus on CSS components - a vital aspect ensuring that the aesthetics and functionality of your applications remain top-notch. By the end, you'll not only grasp the fundamentals but will also be poised to harness the power of Ionic & Angular JS in innovating and redefining web landscapes. Learning Outcomes Comprehend the foundational principles of mobile and web development. Gain proficiency in setting up Ionic & Angular JS environments. Master the art of effective testing for robust application development. Delve deep into the nuances of CSS components to enhance application aesthetics. Understand the integration of Ionic & Angular JS for seamless development. Innovate and design solutions tailored to specific web and mobile challenges. Elevate your coding prowess to produce high-quality, user-friendly applications. Why buy this Mobile and Web Development with Ionic & Angular JS? 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 Mobile and Web Development with Ionic & Angular JS 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 £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Mobile and Web Development with Ionic & Angular JS course is ideal for Aspiring web and mobile application developers. Digital enthusiasts eager to unravel the workings of Ionic & Angular JS. Individuals keen on enhancing their digital portfolio with advanced tools. Web designers aiming to integrate coding into their skill set. Entrepreneurs looking to understand the technicalities behind mobile and web applications. Prerequisites This Mobile and Web Development with Ionic & Angular JS does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Mobile and Web Development with Ionic & Angular JS 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 Web Developer: Average UK salary of £30,000 - £45,000 Annually Mobile Application Developer: Average UK salary of £28,000 - £42,000 Annually UI/UX Designer: Average UK salary of £32,000 - £47,000 Annually Front-end Developer: Average UK salary of £27,000 - £40,000 Annually Back-end Developer: Average UK salary of £31,000 - £50,000 Annually Full Stack Developer: Average UK salary of £35,000 - £55,000 Annually Course Curriculum Section 01: Introduction Introduction to the Course 00:04:00 Section 02: Setup & Testing Setup 00:13:00 iOS Debug 00:05:00 Section 03: CSS Components Header & Sub Header 00:05:00 Footer 00:06:00 Buttons 00:15:00 List 00:14:00 Cards 00:10:00 Forms 00:15:00 Toggle 00:08:00 Checkbox 00:06:00 Radio Button List 00:04:00 Range/Slider 00:09:00 Select/Dropdown 00:03:00 Tabs 00:15:00 Grid 00:16:00 Section 04: Resource Resource 00:00:00 Assignment Assignment - Mobile and Web Development with Ionic & Angular JS 00:00:00 Testing For Desktop & Android 00:11:00

This course will enable you to master Node.js fundamentals in line with MERN stack development. You will learn the essential concepts that you need to know in order to create Node.js applications using Express, MongoDB, Mongoose, Docker, React, and much more.

Ever dreamt of creating your own video game? Did you know the UK games industry is booming, generating over £7 billion in 2023? Are you ready to be part of this exciting world? This Unreal Engine 4: Game Design & Game Development bundle provides essential knowledge and hands-on practice for mastering game development. It covers industry-standard tools like Cocos2d-x and Unreal Engine, crafting captivating 2D and 3D games, using Blender 3D for character life, and exploring game monetization. The goal is to take game ideas from concept to reality. This Gaming & Game Development Bundle Contains 6 of Our Premium Courses for One Discounted Price: Course 01: Game Development using Cocos2d-x v3 C++ Course 02: Modern OpenGL 3D Game Course 03: Unreal Engine 4 for Beginners Course 04: Blender 3D - Create a Cartoon Character Course 05: Monetize Your Mobile Game or App Course 06: Make Cinematics Using Unreal Engine 5 Don't wait any longer to turn your dream of making games into reality. Enrol in the Game Design & Game Development Bundle today! Learning Outcomes of Unreal Engine 4: Game Design & Game Development: Create captivating games with Cocos2d-x v3 C++. Master 3D game development using Modern OpenGL. Craft engaging characters with Blender 3D. Monetise mobile games and apps effectively. Dive into game development with Unreal Engine 4. Produce cinematic experiences with Unreal Engine 5. Develop a comprehensive skill set for game creation. Why Choose Our Game Design & Game Development bundle? Get a free Game Design & Game Development CPD accredited certificate Get a free student ID card with Game Design & Game Development Training Get instant access to this Game Design & Game Development course. Learn Game Design & Game Development from anywhere in the world The Game Design & Game Development is affordable and simple to understand The Game Design & Game Development is an entirely online, interactive lesson with voiceover audio Lifetime access to the Game Design & Game Development course materials The Game Design & Game Development comes with 24/7 tutor support Embark on an immersive journey into the world of Gaming & Game Development with our all-encompassing 6-course bundle. Designed to equip you with hands-on skills and insights, this bundle covers everything from game creation with C++ to 3D game development and character design. Whether you're a beginner or an aspiring developer, our courses will enable you to bring your gaming dreams to life. Unlock the secrets to crafting captivating games and monetising your creations effectively. Game Development using Cocos2d-x v3 C++: Dive into the world of Cocos2d-x v3 C++ and build mesmerising games for multiple platforms. Modern OpenGL 3D Game: Master the art of 3D game development using Modern OpenGL, from graphics fundamentals to game mechanics. Blender 3D - Create a Cartoon Character: Unleash your creativity by designing unique cartoon characters using Blender 3D. Monetise Your Mobile Game or App: Discover the strategies and techniques to turn your mobile games and apps into profitable ventures. Unreal Engine 4 for Beginners: Dive into game development with Unreal Engine 4, learning the tools and techniques used by industry professionals. Make Cinematics Using Unreal Engine 5: Elevate your game storytelling with Unreal Engine 5 and create stunning cinematic experiences. CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring Game Developers Creative Enthusiasts Mobile App Developers Beginners in Game Development Requirements You will not need any prior background or expertise. Career path Game Developer: £25,000 - £80,000 3D Artist/Animator: £20,000 - £60,000 Mobile App Developer: £25,000 - £70,000 Game Designer: £25,000 - £70,000 Unity Developer: £25,000 - £75,000 Cinematic Designer: £30,000 - £75,000 Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

We will follow a hands-on approach in this course to learn how to use and apply HTML5 and CSS3 concepts to the front-end page of your projects. A carefully structured beginner-level course that will help you level up your web development skills. You need not have any prior experience in HTML and CSS to take up this course.