3519 Courses

If you’ve ever wondered how websites behave the way they do, JavaScript is the engine that brings them to life. This course offers a solid journey through developing interactive web applications using JavaScript—designed for learners keen to understand how functional apps are built from scratch. Whether you're a beginner with some HTML and CSS under your belt or someone looking to sharpen your scripting skills, this course walks you through structured, engaging projects that reflect how things work behind the screen. The lessons are smartly arranged to help you write better code, manage logic efficiently, and shape features that respond smoothly to user interactions. From dynamic interfaces to responsive designs, each module focuses on real applications of JavaScript, avoiding fluff and straightening out confusion with clean, sensible explanations. Think of it as coding with clarity, not chaos. You're not just learning JavaScript—you’re learning how to make it work the way developers use it to build sleek, functional web experiences. Learning outcomes: Gain a thorough understanding of the basics of event-driven programming and the property or style object Learn how to create a login page with validation and implement JavaScript functions Understand the concepts of a shopping cart and how to manage items in it Develop skills to create user-friendly interfaces using JavaScript Gain hands-on experience in creating a web app using JavaScript The JavaScript Project Development - Creating Web Apps course is designed to teach students how to create user-friendly web applications using JavaScript. The course covers a wide range of topics, including event-driven programming, managing a shopping cart, creating a login page with validation, and implementing JavaScript functions. By the end of the course, students will have gained a thorough understanding of JavaScript and how it can be used to create effective and engaging web applications. JavaScript Project Development - Creating Web Apps Course Curriculum Section 01: Introduction Introduction to Java Script Event Driven Programming Property or Style Object Section 02: Shopping Cart Creating Login Page Validation on Login Page Implementing Java Script Example of Shopping Cart Functions in Java Script Adding Items to Cart Removing Items from Cart Terms of Shopping Cart Files in Local Storage Section 03: Shopping Cart GUI Function for Display Cart Function for Deleting Cart Creating Input Id Section 04: Online Examination Developing Application Function for Return Document Function Check Answer How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Beginner web developers who want to learn how to create user-friendly web applications using JavaScript Experienced developers who want to expand their knowledge of JavaScript and its capabilities Freelancers who want to offer their clients high-quality web application development services Employees who want to improve their web development skills and become more valuable to their company Anyone interested in creating engaging and effective web applications using JavaScript. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Junior web developer: £20,000 - £30,000 Web developer: £30,000 - £40,000 Front-end developer: £35,000 - £50,000 Full-stack developer: £40,000 - £60,000 Senior web developer: £50,000 - £70,000 Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Duration 3.5 Days 21 CPD hours This course is intended for This course is aimed at students new to the language who may or may not have experience with other programming languages. Overview Learn how Python works and what it's good for. Understand Python's place in the world of programming languages Learn to work with and manipulate strings in Python. Learn to perform math operations with Python. Learn to work with Python sequences: lists, arrays, dictionaries, and sets. Learn to collect user input and output results. Learn flow control processing in Python. Learn to write to and read from files using Python. Learn to write functions in Python. Learn to handle exceptions in Python. Learn to work with dates and times in Python. In this Python training course by Webucator, Inc, students learn to program in Python. Python Basics Running Python Hello, World! Literals Python Comments Data Types Variables Writing a Python Module print() Function Named Arguments Collecting User Input Getting Help Functions and Modules Defining Functions Variable Scope Global Variables Function Parameters Returning Values Importing Modules Math Arithmetic Operators Modulus and Floor Division Assignment Operators Built-in Math Functions The math Module The random Module Seeding Python Strings Quotation Marks and Special Characters String Indexing Slicing Strings Concatenation and Repetition Common String Methods String Formatting Built-in String Functions Iterables: Sequences, Dictionaries, and Sets Definitions Sequences Unpacking Sequences Dictionaries The len() Function Sets *args and **kwargs Flow Control Conditional Statements The is and is not Operators Python's Ternary Operator Loops in Python The enumerate() Function Generators List Comprehensions File Processing Opening Files The os and os.path Modules Exception Handling Wildcard except Clauses Getting Information on Exceptions The else Clause The finally Clause Using Exceptions for Flow Control Exception Hierarchy Dates and Times Understanding Time The time Module The datetime Module Running Python Scripts from the Command Line The sys Module sys.argv

Unleash your potential in the realm of literacy and numeracy mastery. Discover the art and science behind adult learning, delve into the intricacies of teaching and learning literacy, and unlock the secrets of imparting numeracy with finesse. Our comprehensive programme takes you on a journey through the fascinating landscapes of adult education, blending theory with practical insights. Elevate your teaching prowess and redefine your impact on learners with modules that explore inclusive learning, technology integration, and the nuances of policy and practice. Key Features: CPD Certified Free Certificate Developed by Specialist Lifetime Access Immerse yourself in an engaging learning adventure that goes beyond conventional approaches, equipping you with the knowledge and skills to navigate the diverse challenges of adult education. Join us in reshaping the educational landscape, where your passion meets purpose, and your expertise becomes a beacon for adult learners seeking the keys to literacy and numeracy mastery. Course Curriculum Module 1: Overview of Adult Literacy and Numeracy Module 2: Understanding Adult Learning Theories Module 3: Teaching and Learning Literacy Module 4: Teaching and Learning Literacy Writing, Speaking and Listening Module 5: Planning and Assessment Literacy Module 6: Learning Numeracy Module 7: Learning Numeracy Percentage, Statistical Functions and Probabilities Module 8: Teaching Numeracy Module 9: Technology in Learning Module 10: Adult Learning Difficulties Module 11: Inclusive Learning Module 12: Policy and Practice Learning Outcomes: Grasp adult learning theories for effective teaching strategies. Hone literacy teaching skills in writing, speaking, and listening. Demonstrate proficiency in planning and assessing literacy education. Acquire a solid foundation in numeracy, including statistical functions. Develop advanced teaching techniques for imparting numeracy concepts. Cultivate inclusive practices and align teaching with educational policies. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Educators seeking advanced adult teaching expertise. Literacy and numeracy enthusiasts passionate about adult education. Professionals eager to enhance their teaching impact. Individuals committed to fostering inclusive learning environments. Aspiring educators ready to embrace the challenges of adult education. Career path Adult Education Coordinator Literacy Outreach Specialist Numeracy Instructor Inclusive Learning Advocate Educational Policy Analyst Technology Integration Facilitator Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Everywhere, from tiny businesses to major corporations, needs people skilled in SQL. In light of this, our online training course has been developed to help you succeed by equipping you with all the necessary skills. The importance of mastering SQL increases if you're looking for your first job in the data industry. You will learn about topics such as SQL fundamentals, data wrangling, SQL analysis, AB testing, distributed computing with Apache Spark, Delta Lake, and more through four increasingly more challenging SQL projects with data science applications. These subjects will equip you with the skills necessary to use SQL creatively for data analysis and exploration, write queries quickly, produce datasets for data analysis, conduct feature engineering, integrate SQL with other data analysis and machine learning toolsets, and work with unstructured data. This Specialisation is designed for a learner with little or no prior coding expertise who wants to become proficient with SQL queries. Experts have meticulously planned out the curriculum for the SQL Skills Training course with years of expertise. As a result, you will find it simple to learn the course material. Learning outcome After finishing the course, you'll Learn to utilise the tools for view creation Become familiar with updating columns and indexed views Be able to test and debug Be able to search a database using SQL Become more familiar with inline table-valued functions Learn the fundamentals of transactions and multiple statements Why Prefer US? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standards-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support *** Course Curriculum *** SQL Programming Course Module 01: Course Introduction Introduction Course Curriculum Overview Overview of Databases Module 02: SQL Environment Setup MySQL Installation MySQL Workbench Installation Connecting to MySQL using Console Module 03: SQL Statement Basics Overview of Challenges SQL Statement Basic SELECT Statement SELECT DISTINCT Column AS Statement COUNT built-in Method usage SELECT WHERE Clause - Part One SELECT WHERE Clause - Part Two Statement Basic Limit Clause Statement Using BETWEEN with Same Column Data How to Apply IN Operator Wildcard Characters with LIKE and ILIKE Module 04: GROUP BY Statements Overview of GROUP BY Aggregation function SUM() Aggregation MIN() and MAX() GROUP BY - One GROUP BY - Two HAVING Clause Module 05: JOINS Overview of JOINS Introduction to JOINS AS Statement table INNER Joins FULL Outer Join LEFT Outer JOIN RIGHT JOIN Union Module 06: Advanced SQL Commands / Statements Timestamps EXTRACT from timestamp Mathematical Functions String Functions SUBQUERY Module 07: Creating Database and Tables Basic of Database and Tables Data Types Primary key and Foreign key Create Table in SQL Script Insert Update Delete Alter Table Drop-Table NOT NULL Constraint UNIQUE Constraint Module 08: Databases and Tables Creating a Database backup 10a Overview of Databases and Tables 10c Restoring a Database CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course can be helpful for anyone working in the SQL fields, whether self-employed or employed, regardless of their career level. Requirements You will not need any prior background or expertise to enrol in this course. Career path The vocation of SQL Skills Training moves very quickly but pays well. This position provides unparalleled satisfaction. This is your opportunity to learn more and start changing things. Query Language Developer Server Database Manager Python Developer Technical Consultant Project Implementation Manager Software Developer (SQL) Certificates Certificate of completion Digital certificate - £10

Duration 2 Days 12 CPD hours This course is intended for This SQL training course is designed for students new to writing SQL queries. Overview Upon successful completion of this course, students will be able to: - Understand how relational databases work - Use SQL to output reports - Write queries to obtain data from multiple tables. Students will learn SQL to build applications or to generate business reports.The SQL learned in the course is applicable to all major databases. Relational Database Basics Brief History of SQL Relational Databases Popular Databases SQL Statements Simple SELECTs Introduction to the Northwind Database Some Basics SELECTing All Columns in All Rows Exploring the Tables SELECTing Specific Columns Sorting Records The WHERE Clause and Operator Symbols Using the WHERE clause to check for equality or inequality Using the WHERE clause to check for greater or less than Checking for NULL Using WHERE and ORDER BY Together The WHERE Clause and Operator Words More SELECTs with WHERE Checking Multiple Conditions Writing SELECTs with Multiple Conditions Advanced SELECTs Calculated Fields Calculating Fields Aggregate Functions and Grouping Working with Aggregate Functions Built-in Data Manipulation Functions Data Manipulation Functions Subqueries, Joins and Unions Subqueries Joins Using Joins Outer Joins Unions Working with Unions If time allows, one or more of the following may be covered: Conditional Processing with CASE INSERT, UPDATE, DELETE Student Challenges - Design your own reports

Learning Coach Qualification – is it right for me? A Learning Coach plays a vital role in guiding and supporting young people in their educational journey, helping them develop a range of skills and attributes that contribute to successful learning, personal growth, and future success. Pursuing a qualification to become a qualified Learning Coach is beneficial for enhancing skills, credibility, and effectiveness in supporting learners’ development. It provides a foundation of knowledge and expertise that contributes to successful coaching experiences. This qualification consists of three units (two mandatory, 1 optional). Please see the Agored Cymru website for full course information, where you can choose the units to suit the needs of your staff. It will cover the following: Young People’s Development: Factors influencing learning, motivation, and barriers to learning. Learning Styles and Inclusive Planning: Learning styles vs. Universal Design for Learning (UDL), planning for inclusive learning. Reflective Practice: Comparison of reflection models, engaging in reflective practice. Coaching for Learning: Communication and coaching skills, coaching models, functions of Learning Coaching Assessing Young People: Interview skills, communication styles, assessing achievements and barriers to learning. Developing Learning Pathways: Coordinating individualised learning pathways, engaging young people in goal-setting Further Information This course spans six months and covers various aspects of Learning Coaching, including understanding learning processes, personal and emotional factors affecting learning, coaching techniques, reflective practice, communication skills, inclusive planning, assessment, and the coordination of individualised learning pathways. Students will engage in assignments, reflective journals, case studies, and portfolio building to demonstrate their understanding and application of the concepts and skills covered in the course. Learning Outcomes Professional Competence: A formal qualification ensures that Learning Coaches have a solid understanding of best practices, theories, and methodologies in the field of education and coaching. It provides them with the necessary knowledge and skills to effectively support learners in their development. Credibility: Having a recognised qualification enhances the Learning Coach’s credibility and reputation. It demonstrates their commitment to their role and their ability to provide high-quality guidance and support. Improved Effectiveness: Learning Coaches who have undergone formal training are better equipped to assess learners’ needs, design personalised learning plans, and provide targeted support. This leads to more effective coaching outcomes. Personal Growth: Going through a qualification process often involves self-reflection, skill development, and continuous learning. This contributes to the personal growth and professional development of the Learning Coach. Network and Community: Enrolling in a qualification program provides Learning Coaches with the opportunity to connect with other professionals in the field. This network can offer support, resources, and collaboration opportunities.

Overview This comprehensive course on Logistics Management Training: From Beginner to Advanced will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Logistics Management Training: From Beginner to Advanced comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Logistics Management Training: From Beginner to Advanced. It is available to all students, of all academic backgrounds. Requirements Our Logistics Management Training: From Beginner to Advanced is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 17 sections • 75 lectures • 10:48:00 total length •Value Chain Model: 00:06:00 •Logistics Function In An Organisation: 00:09:00 •Logistics and Logistics Functions: 00:09:00 •General Information In Logistics: 00:12:00 •Logistics Functions Explanation: 00:09:00 •Logistic Functions Explanation Continues: 00:09:00 •General Introduction Of Logistics: 00:13:00 •How Logistics Can Be Applied To Business: 00:03:00 •Business EXCELLENCE Through Logistics Management: 00:08:00 •Role Of Outsourcing: 00:07:00 •Logistics Management For Business Excellence: 00:10:00 •Understanding Transportation Strategy: 00:12:00 •Objectives of Transportation: 00:02:00 •Transportation Functionality: 00:07:00 •Factors Influencing Transportation Cos: 00:11:00 •Containerization and Its Role: 00:06:00 •Understanding Role Of Inventory: 00:09:00 •Inventory Functions: 00:05:00 •Cost of Inventory: 00:06:00 •Other Types Of Inventory: 00:11:00 •Basics Of Inventory Management: 00:12:00 •Basics Of Inventory Management Continues: 00:08:00 •KANBAN: 00:02:00 •Inventory Policy Guidelines: 00:05:00 •Warehouse Management Introduction: 00:04:00 •Warehouse And Its Design: 00:05:00 •Warehouse And Its Design Continues: 00:08:00 •Warehouse Operating Principle: 00:05:00 •Strategic Decisions In Warehousing: 00:10:00 •Warehousing Strategies: 00:09:00 •Warehousing Performance Measures: 00:11:00 •Logistics Information System Introduction: 00:04:00 •Need For Logistics Information System: 00:03:00 •Information Functionality: 00:04:00 •Evaluating Logistics Information System: 00:06:00 •Application of Logistics Information System: 00:10:00 •Designing of Logistics Information System: 00:08:00 •Designing of Logistics Information System Continues: 00:07:00 •Benefits of Logistics Outsourcing: 00:18:00 •Types of Logistics Providers: 00:07:00 •Outsourcing Value Proposition: 00:07:00 •Outsourcing Management Selection Criteria: 00:07:00 •Contract Terms and Conditions: 00:04:00 •Material Handling Part 1: 00:07:00 •Material Handling Part 1 Continued: 00:08:00 •Material Handling Part 2: 00:09:00 •Material Handling Part 2 Continued: 00:05:00 •Material Storage Principles: 00:03:00 •Material Storage Methods: 00:10:00 •Material Storage System Unit Load Storage: 00:11:00 •Design of Storage system: 00:09:00 •Storage System Design Continued: 00:05:00 •Scope and Objectives Of Reverse Logistics: 00:15:00 •Design Considerations: 00:13:00 •Automatic Identification Technology: 00:15:00 •EDI standards Application and Benefits: 00:04:00 •Automated Material Handling System: 00:14:00 •Satellite Tracking ERPDRP and AITS: 00:15:00 •Objectives of E-commerce: 00:05:00 •Classes of E-commerce Applications: 00:10:00 •E-logistics In E-commerce: 00:11:00 •E-Logistics Structure and Operations: 00:04:00 •Logistics Performance Measures and Controls: 00:08:00 •Logistics Performance Measures and Controls Continued: 00:14:00 •Characteristics Of A Successful Logistical Organization: 00:14:00 •Evolution Of Logistics And Organization: 00:06:00 •Learning Approaches To Logistical Organization: 00:11:00 •Drivers Of Logistical Organization: 00:09:00 •Drivers Of Logistical Organization Continued: 00:09:00 •Scope and Scale of Global Logi: 00:10:00 •Operational Factors and Challenges in Global Logistics: 00:16:00 •CrossBorder Goods Movement: 00:12:00 •Logistics Competitive Framework: 00:16:00 •Logistics strategies Across The Product Life Cycle: 00:17:00 •Conclusion: 00:05:00

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups

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

Course Objectives At the end of this course you will be able to: Manage project costs Consolidate and reuse project plan information Exchange project plan data with other applications Update a project plan Customise Project to meet specific requirements ' 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further Jenny Price - Acer ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Exchanging Project Plan Data with Other Applications Import a list of tasks from Outlook Import a Task List from an Excel File Create a Custom Import Map Export Project Plan Cost Data into Excel Save Project Plan Information as a Web Page Updating a Project Plan Enter Task Progress Information View Task Progress Split a Task Reschedule a Task Creating Custom Fields Text fields Lookup fields Calculated fields with the use of formulas and functions Inserting Graphical Indicators Customizing how you look at data Filter Tasks in a Project Plan Create a Custom Table Create a Custom View Copy custom Views and Tables between projects Earned value analysis Understanding Earned Value Fields View Multiple Baselines in a Single Project Tracking progress between interim plans Creating Custom Reports Create a Custom Report Modify a Custom Report's Header and Footer Add a Picture to a Report Modify a Custom Report's Margins Print a Custom Report Re-using Project Plan Information Create a Project Plan Template Create a Custom Combination View Make Custom Views Available to Other Project Plans Share Resources between Projects, Create a Master Project Plan with sub projects Who is this course for? Who is this course for? This course is designed for those that who already have the skills to create and modify project plans and would like to acquire a more in depth and thorough knowledge of more advanced functionalities in project planning and tracking. Requirements Requirements Preferably, delegates would have attended the MS Project Introduction course. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills