5977 Productivity courses

The Oracle 11g PL/SQL Part 1 course will focus on giving you the best knowledge of coding and designing PL/SQL and SQL scripts. Initially, you'll learn how to start programming in Oracle PL/SQL. You'll understand the history of PL/SQL, installing Oracle Express Edition, connecting to Database, Relational Database, Oracle SQL in an easy-to-grasp method. This course includes mostly practical examples with explanations which makes it more valuable. Upon successful completion of this course, you can have the pleasure to code in PL/SQL which further help to boost your career. From beginners to expert learner can benefit from this course. So enrol today and see what else is in the Oracle 11g PL/SQL Part 1 course. What Will I Learn? Prepare your environment Work with Oracle database tools Understand and work with language features Work with the DECLARE clause Work with the BEGIN clause Work with the EXCEPTION clause Use explicit cursors Understand and use nested blocks Understand the difference between nested blocks and subprograms 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 FREE 00:03:00 Preparing Your Environment Course Setup 00:37:00 Working with Oracle Database Tools Selecting the Appropriate Database Tool 00:31:00 Language Features Understanding PL/SQL 00:18:00 PL/SQL Blocks 00:15:00 Working with SQL Plus 00:11:00 The DECLARE Clause DECLARE Clause Objects 00:16:00 PL/SQL Available Data Types 00:17:00 Declaring Simple Data Types and Assignments 00:12:00 Declaring Complex Data Types and Assignments 00:11:00 Declaring Complex RowTypes and Assignments 00:07:00 Declaring Complex Tables 00:08:00 Declaring Complex Records 00:08:00 Creating and Declaring User-Defined Types 00:09:00 The BEGIN Clause What Can Be Included in the BEGIN Clause 00:07:00 Working with CHAR and VARCHAR2 Variables 00:08:00 Handling String Literals 00:08:00 Working with Numeric Variables 00:07:00 Working with Date Variables 00:06:00 Assigning and Using Boolean Variables 00:08:00 Using Comparison Operators 00:07:00 Using SQL Functions 00:06:00 SQL DML within PL/SQL 00:15:00 Using SELECT 00:07:00 Exceptions and Embedded SQL 00:11:00 Using Sequences 00:14:00 Logic Control and Branching 00:07:00 Using GOTO 00:06:00 Working with LOOPS 00:19:00 Creating and Using the Indefinite Loop 00:07:00 Creating and Using the Conditional Loop 00:08:00 Using Nested Loops 00:12:00 Using the If-Then-Else 00:19:00 Using the CASE Statement 00:18:00 The EXCEPTION Clause What Are the Types of Exceptions 00:06:00 Trapping Exceptions 00:06:00 Identify Exception Details 00:11:00 Creating User-Defined Exceptions 00:11:00 Using SQLCODE and SQLERRM Objects 00:09:00 Understand the Implicit Cursor 00:15:00 Creating User-Defined Events 00:12:00 Explicit Cursors Understanding the Concept and Purpose of Explicit Cursors 00:18:00 Learn about Cursor Attributes 00:10:00 Using the Continue Statement 00:06:00 Working with Updateable Cursors 00:19:00 Creating and Using Cursor Parameters 00:15:00 FOR...LOOP Cursors 00:07:00 Nested Blocks Understanding Nested Blocks 00:11:00 Difference between Global vs Local Objects and Exceptions 00:13:00 Declared Subprograms Subprograms: How They Differ from Nested Blocks 00:18:00 Conclusion Conclusion 00:04:00 Course Certification

Are you in need of help managing your project work? Having trouble managing your finance for a project? Then you should take this course and get rid of all your problem. This is the ultimate course for expert Microsoft Project users. Microsoft Project is used to plan out the work involved to achieve project goals. It helps you create a roadmap to the project goal by breaking down the greater milestones into well defined tasks. This helps you manage the responsibilities of people and coordinate the team. Microsoft Project provides a visualisation of how your project will run over time. It displays a Gantt Chart illustrating when tasks are expected to start and finish and the relationships between other tasks. Using a Planning tool like Microsoft Project is essential to gain clarity and direction over your project. During this course you will study different units and complete each of them. Once you are finished there is nothing on Microsoft Project that you don't know. This course will show you how to manage your resources and finance and be a capable project manager. Course Highlights Accredited Microsoft Project 2007 Advanced Level is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Accredited Microsoft Project 2007 Advanced Level into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Accredited Microsoft Project 2007 Advanced Level Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Accredited Microsoft Project 2007 Advanced Level is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Accredited Microsoft Project 2007 Advanced Level 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Project 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - Viewing the Project 01:00:00 Module Three - Working with Tasks, Part One 01:00:00 Module Four - Working with Tasks, Part Two 01:00:00 Module Five - Working with Resources 01:00:00 Module Six - Working with Costs 01:00:00 Module Seven - Balancing the Project 01:00:00 Module Eight - Updating Project Progress 01:00:00 Module Nine - Checking Project Progress 01:00:00 Module Ten - Working with Reports 01:00:00 Module Eleven - Working with Multiple Projects 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities - Accredited Microsoft Project 2007 Advanced Level 00:00:00 Mock Exam Final Exam

All in One Bundle Special Discount Offer Are you looking to enhance your Office Skills for Admin, Secretarial, PA (Executive PA)? If yes, then you have come to the right place. Our comprehensive courses on Microsoft Excel- Office Skills for Admin, Secretarial, PA (Executive PA) will assist you in producing the best possible outcome by learning the Office Skills for Admin, Secretarial, PA (Executive PA). Course 01: This Microsoft Office Bundle Microsoft Excel 2019 Microsoft Word 2019 Microsoft PowerPoint 2019 Microsoft Access 2019 Course 02: Admin, Secretarial, PA The Office Skills for Admin, Secretarial, PA (Executive PA) bundle is for those who want to be successful. In the Office Skills for Admin, Secretarial, PA (Executive PA) bundle, you will learn the essential knowledge needed to become well versed in Office Skills for Admin, Secretarial, PA (Executive PA). Our Office Skills for Admin, Secretarial, PA (Executive PA) bundle starts with the basics of Office Skills for Admin, Secretarial, PA (Executive PA) and gradually progresses towards advanced topics. Therefore, each lesson of this Microsoft Excel- Office Skills for Admin, Secretarial, PA (Executive PA) is intuitive and easy to understand. Why would you choose the course from Compliance Central: Lifetime access to courses materials Full tutor support is available from Monday to Friday Learn at your own pace from the comfort of your home Accessible, informative learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the bundle Study in your own time through your computer, tablet or mobile device Curriculum Breakdown of the Microsoft Office Skills for Admin, Secretarial, PA (Executive PA) Microsoft Excel 2019 Microsoft Excel 2019 New Features Getting Started with Microsoft Excel Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Microsoft Word 2019 Microsoft Word 2019 New Features Getting Started with Word Formatting Text and Paragraphs Working More Efficiently Managing Lists Adding Tables Inserting Graphic Objects Controlling Page Appearance Preparing to Publish a Document Microsoft PowerPoint 2019 Microsoft PowerPoint 2019 New Features PowerPoint Interface Presentation Basics Formatting Inserting Options Working with Objects Table Charts Review and Presentation Microsoft Access 2019 Microsoft Access 2019 New Features Introduction to Access Modify Data Working with Queries Access Forms Working with Reports CPD 25 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Microsoft Office Skills for Admin, Secretarial, PA (Executive PA) bundle helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Office Skills for Admin, Secretarial, PA (Executive PA). Requirements To enrol in this Microsoft Office Skills for Admin, Secretarial, PA (Executive PA) course, all you need is a basic understanding of the English Language and an internet connection. Career path The Microsoft Office Skills for Admin, Secretarial, PA (Executive PA) bundle will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Microsoft Office Skills for Admin, Secretarial, PA (Executive PA). Certificates 2 CPD Accredited PDF Certificate Digital certificate - Included 2 CPD Accredited PDF Certificate for Free CDP Accerdited Hardcopy Certificate Hard copy certificate - £10.79 Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Description: This Microsoft Office 2007 Access Beginners - Complete Video Course will allow you to get started quickly with prebuilt applications that can modify or adapt to changing business needs. Collect information through form in e-mail or import data from external applications. Create and edit detailed reports that display sorted, filtered, and grouped information in a way that helps you make sense of the data for informed decision-making. Sharing information by moving your Office Access 2007 files to a Windows SharePoint Services Web site, where you can audit revision history, recover deleted information, set data access permission, and back up your information at regular intervals. This series will provide you an overview of the features and functions of Microsoft Office Access 2007. If you are interested to learn all the basics of Microsoft Access 2007, then you should join this course now. So, if you want to learn beginning level Access 2007 Skills. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. 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? Microsoft Office 2007 Access Beginners - Complete Video Course 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 Microsoft Office 2007 Access Beginners - Complete Video Course 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. Getting Started Database Concepts FREE 00:05:00 Indentifying Database Components 00:04:00 Exploring the Access Environment 00:03:00 Starting Access and Examining the Access Window 00:06:00 Opening a Database 00:04:00 Getting Help 00:01:00 Using Help 00:03:00 Databases and Tables Planning and Designing Databases 00:05:00 Creating a Database from a Template 00:01:00 Creating a Blank Database 00:01:00 Exploring Table 00:01:00 Navigating in a Table in Datasheet View 00:05:00 Examining a Table in Design View 00:04:00 Creating Tables 00:05:00 Creating a Table by Using the Table Templates 00:06:00 Creating a Table in Design View 00:02:00 Adding Fields and Descriptions to a Table 00:05:00 Setting the Primary Key 00:01:00 Saving the Table 00:01:00 dding a Record 00:02:00 Copying, Modifying, and Deleting a Table 00:03:00 Creating a Composite Key 00:03:00 Fields and Records Changing the Design of a Table 00:05:00 Modifying Field Names 00:01:00 Deleting and Inserting Fields 00:02:00 Moving a Field 00:01:00 Using the Attachment Data Type 00:04:00 Adding a Total Row 00:03:00 Finding and Editing Records 00:02:00 Finding and Replacing a Value 00:03:00 Undoing Changes 00:01:00 Organizing Records 00:04:00 Sorting Records by a Single Field 00:01:00 Sorting Records by Multiple Fields 00:02:00 Using Filter by Selection 00:02:00 Using Filter by Form 00:02:00 Using Filter Excluding Selection 00:01:00 Using Advanced FilterSort 00:02:00 Deleting a Record 00:02:00 Data Entry Rules Setting Field Properties 00:04:00 Setting the Required Property 00:04:00 Using the Allow Zero Length Property 00:03:00 Setting the Field Size Property 00:02:00 Setting the Append Only Property 00:03:00 Working with Input Masks 00:02:00 Creating an Input Mask 00:03:00 Working with the Input Mask Wizard 00:03:00 Setting Validation Rules 00:01:00 Creating Validation Rules 00:03:00 Setting Validation Text 00:02:00 Basic Queries Creating and Using Queries 00:05:00 Using the Query Wizard 00:04:00 Creating a Query in Design View 00:02:00 Saving and Running the Query 00:01:00 Sorting Query Results 00:01:00 Filtering a Query by Adding Criteria 00:01:00 Creating a Query from a Filter 00:03:00 Modifying Query Results and Queries 00:02:00 Editing Query Results 00:02:00 Adding Fields to a Query 00:01:00 Finding Records with Empty Fields 00:01:00 Performing Operations in Queries 00:04:00 Using Comparison Operators 00:01:00 Using the OR Condition 00:01:00 Using the AND Condition 00:01:00 Using the Wildcard 00:01:00 Using Calculations in a Query 00:03:00 Totaling a Group of Records 00:02:00 Using the Avg and Count Functions 00:01:00 Using Forms Creating Forms 00:05:00 Examining a Form 00:03:00 Creating a Basic Form 00:01:00 Creating a Form Using the Form Wizard 00:02:00 Using Design View 00:04:00 Creating a Form in Design View 00:01:00 Addings Controls 00:03:00 DModifying Properties 00:06:00 Applying Conditional Formatting 00:03:00 Sorting and Filtering Records 00:01:00 Using a Form to Sort Records 00:01:00 Using a Form to Filter Records 00:01:00 Working with Reports Reports 00:03:00 Examining a Report 00:01:00 Creating a Basic Report 00:01:00 Creating a Report Using the Report Wizard 00:02:00 Creating a Report Using Design View 00:04:00 Modifying and Printing Reports 00:05:00 Modifying Reports in Design View 00:03:00 Modifying Reports in Layout View 00:03:00 Grouping, Sorting, and Filtering a Report 00:02:00 Adding Summary Fields Using the Report Wizard 00:02:00 Modifying the Layout and Style of a Report 00:01:00 Mock Exam Mock Exam- Microsoft Office 2007 Access Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 Access Beginners - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

48-Hour Knowledge Knockdown! Prices Reduced Like Never Before! Are you looking to improve your current abilities or make a career move? Our unique Administration Coordinator course might help you get there! Expand your expertise with high-quality training - study the Administration Coordinator course and get an expertly designed, great-value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the Administration Coordinator online training course. The Administration Coordinator course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Administration Coordinator course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this course. This Administration Coordinator training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer Us? Opportunity to earn a certificate accredited by CPDQS. Get a free student ID card!(£10 postal charge will be applicable for international delivery) Innovative and Engaging Content. Free Assessments 24/7 Tutor Support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Administration Coordinator course: >> Coordinator << Module 1: Introduction to Office Administration Module 2: Skills of an Effective Administrator Module 3: Business Etiquette Module 4: Business Telephone Skills Module 5: Mail Services and Shipping Module 6: Travel Arrangements Module 7: Organising Meeting and Conferences Module 8: Record Keeping and Filing Systems Module 9: Effective Planning and Scheduling Module 10: Invoicing/Petty Cash Module 11: Business Writing Skills Module 12: Time Management Module 13: Organisational Skills Module 14: Communication Skills Module 15: Negotiation Techniques Module 16: Conflict Management Assessment Process Once you have completed all the modules in the course, your skills and knowledge will be tested with an automated multiple-choice assessment. You will then receive instant results to let you know if you have successfully passed the Administration Coordinator course. hard copies for £39. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this Administration Coordinator course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career. Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Powerful Discipline Guide course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Powerful Discipline Guide course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Powerful Discipline Guide and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Powerful Discipline Guide course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Powerful Discipline Guide course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path The Powerful Discipline Guide will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Module 1: Introduction Introduction 00:02:00 Module 2: Art of Discipline & Benefits The Art of Discipline 00:08:00 Benefits of Self-Discipline 00:10:00 Module 3: KEY Discipline Skills, Tools & Insights Why Poor Discipline Can Destroy You 00:10:00 7 Strategies to Build Unbreakable Self-Discipline 00:10:00 How to Develop Powerful Self Discipline 00:11:00 Superiority of Discipline over Motivation 00:07:00 Module 4: Conclusion Final Thoughts & Tips 00:01:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Basic Strength Resilience & Drive course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Basic Strength Resilience & Drive course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Basic Strength Resilience & Drive and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Basic Strength Resilience & Drive course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Basic Strength Resilience & Drive course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path The Basic Strength Resilience & Drive will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Section 01: Introduction Introduction 00:02:00 Resilience & the Growth Mindset 00:08:00 Grit & Resilience 00:04:00 Real-Life Examples 00:03:00 Section 02: Fast Resilience Grit & Growth Mindset 00:09:00 Grit in the Workplace 00:08:00 Section 03: Weighing Cultivating Grit 00:03:00 Grit - An Acronym 00:03:00 Section 04: Playing Grit & Risk-Taking 00:04:00 Section 05: Top Grit & Personal Wellness 00:15:00 10 Tips to Increase Resilience 00:07:00 Section 06: Final Thoughts & Tips Final Tips & Ideas 00:02:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

This Microsoft Power BI course will help you become a Power BI expert. It'll enhance your skills by offering you comprehensive knowledge on Power BI Desktop and Power BI Online, and unleash the capabilities of Power BI to perform a comprehensive analysis of data from multiple sources and present the data using the perfect visualization.

Fitting it all in masterclass: How to have the energy to fit in all the things you need and want to do…and then some.

Supercharge your SAS programming skills with our comprehensive advanced course. Dive deep into data analysis and manipulation techniques for maximum efficiency and insights. Enrol now!