2431 Courses in Leeds delivered On Demand

Learn Flutter - Google's mobile development framework - and build Flutter iOS and Android apps using a single codebase

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost

Learning Smartsheet doesn't need any prior coding experience. This complete hands-on course helps you get familiar with the concepts of working on a Smartsheet from scratch. You will be able to manage projects and track progress in an organized manner. This course is specifically designed for beginners.

This Oracle 11g PL/SQL Part 2 course will be very advantageous for you to learn about developing database server-side PL/SQL program units within an Oracle database. This course covers a variety of topics which include understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. In addition to that, you'll take the support of advanced programming techniques such as cursor variables and cursor expressions, which broadly discussed in the course. This course is ideal to prepare yourself for the Oracle certification exams (OCP). Upon successful completion of this course, you'll stand out from your competition while you're chasing your dream job! What Will I Learn? Prepare your environment Introducing Database Program Units Creating and Maintaining Stored Procedures & Functions Creating and Maintaining Packages Advanced Cursor Techniques Using System-Supplied Packages Creating and Maintaining Database Triggers Implementing System Event Triggers Requirements Familiarity with database and programming principles Who is the target audience? Application designers and developers Database administrators Business users and non-technical senior end users Introduction Introduction 00:03:00 Install Oracle XE 00:11:00 SQL Developer Installation 00:00:00 Workstation Setup 00:12:00 Database Program Units Introducing the Database Program Unit 00:19:00 Working with Stored Procedures and Functions Creating Stored Procedures and Functions 00:19:00 Understanding the Parameter Specification 00:23:00 Executing Procedures and Functions 00:26:00 Calling Functions from within SQL 00:13:00 Handling Compilation Errors 00:08:00 Maintaining Stored Procedures and Functions Recompiling and Dropping Programs 00:16:00 Data Dictionary Storage 00:25:00 Managing Dependencies 00:13:00 Tracking Dependencies 00:08:00 Using the Dependency Tracking Utility 00:09:00 Creating and Maintaining Packages What Is a Package? 00:10:00 Creating a Package 00:19:00 Package Definition Information 00:08:00 Advanced Programming Techniques 00:06:00 Using Persistent Global Objects 00:04:00 Including Initialization Logic 00:15:00 Object Oriented Support within Packages 00:14:00 Package Maintenance 00:18:00 Advanced Cursor Techniques Learning to Use Cursor Variables 00:24:00 Advanced Cursor Techniques Weak Cursor Definitions 00:16:00 REFCURSOR Cursor Definition 00:05:00 Using Cursor Expression 00:14:00 Using System Supplied Packages Using the DBMS OUTPUT() Package 00:12:00 Using the UTL FILE() Package 00:30:00 Creating Database Triggers Understanding the Database Trigger 00:23:00 Statement-Level Triggers 00:23:00 Row-Level Triggers 00:12:00 Row Level Trigger Example 1 00:11:00 Row Level Trigger Example 2 00:07:00 Row Level Trigger Example 3 00:08:00 Working with the INSTEAD OF Trigger 00:11:00 Using Triggers within an Application 00:09:00 Trigger Maintenance Using the CALL Statement 00:09:00 Trigger Maintenance Tasks 00:12:00 Work with Multiple Triggers for a Single Table 00:11:00 Handling Mutating Table Issues 00:22:00 Using the Compound Trigger 00:06:00 Working with System Event Triggers What Is a System Event Trigger 00:05:00 Defining Scope 00:04:00 Identifying Available System Events 00:12:00 Conclusion Conclusion 00:02:00 Course Certification

This course will show you how to create simple, intermediate, and advanced REST APIs for authentication, deployment, caching, and much more. You will also cover essential technologies such as Flask and popular extensions such as Flask-Smorest, Flask-JWT-Extended, and Flask-SQLAlchemy; we will dive right into developing complete, solid, production-ready REST APIs.

Learn how to use Microsoft Excel like a pro with our comprehensive Microsoft Excel Complete Diploma course. You will discover the latest features and functions, from basic calculations to advanced data analysis and visualization techniques. Whether you are an office worker, a business professional, or a student, this course will provide you with flexible learning options and expert guidance to help you excel in your career. Earn your certification and enhance your credentials with this course.

3 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | 10 CPD Courses | Lifetime Access | 24/7 Tutor Support

Description Microsoft Excel has hundreds, if not thousands, of functions and features. This course aims to cover some of the best – that is the ones I find most useful. In “Adventures in Excel”, I cover the simple-to-use but powerful functions that I use most often: Basic features including products and powers Key date functions including the calculation of due dates and days past due Generating random numbers and random dates The new IFS functions (new to Office365) Text functions The most useful logical functions and IS functions How to create a drop-down list The new XLOOKUP function Pivot tables   These functions are easy to use, and, unless your role is extremely specialised, they are probably the ones you’ll use 90% of the time. I hope you find the course helpful.   Learning Outcomes Participants in this course will learn: Basic Excel functions including SUM, AVERAGE, MIN, MAX, PRODUCT, POWER and SQRT Useful date functions including TODAY, EOMONTH, EDATE, and DAYS Generating random numbers using RAND and RANDBETWEEN; generating random dates; and randomly picking an item from a list or table The new RANDARRAY function in Office365 The new IFS functions in Office365 including AVERAGEIFS, MAXIFS, MINIFS, COUNTIFS, and SUMIFS Text functions including TRIM, LOWER, UPPER, PROPER, LEFT, MID, RIGHT, FIND, TEXTJOIN and CONCATENATE Logical functions AND, OR, and NOT and IS functions ISTEXT, ISNUMBER, ISBLANK and ISERROR How to create a drop-down list The new SORT and FILTER functions in Office365 VLOOKUP and the new XLOOKUP function How to create a Pivot table and analyse data with one     Course Requirements There are no pre-course requirements.   Additional Resources Course Spreadsheet with the examples covered.     About Ross Ross Maynard is a Fellow of the Chartered Institute of Management Accountants in the UK. He is director of Ideas2Action Process Excellence Ltd and has 30 years’ experience as a process improvement consultant and facilitator. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

This course introduces you to SQL and Microsoft SQL Server in a practical way. You'll be able to learn the basics of SQL quickly and understand how to use SQL queries and statements with Microsoft SQL Server to extract data and analyze it for making productive marketing decisions.

Welcome to this dual-phase course. In the first segment, we delve into neural networks and deep learning. In the second, ascend to mastering Generative Adversarial Networks (GANs). No programming experience required. Begin with the fundamentals and progress to an advanced level.