• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

5519 Productivity courses delivered Online

WordPress for Beginners

4.7(160)

By Janets

Get started with WordPress hassle-free! Our beginner-friendly guide covers everything you need to know about creating, managing, and customizing your WordPress website. Learn the basics, master essential tools, and launch your online presence confidently with expert tips and step-by-step tutorials.

WordPress for Beginners
Delivered Online On Demand3 days
£25

Hotel Receptionist Diploma

4.3(43)

By John Academy

Description: Do you have a passion for customer service? Or want to upgrade your skills as a Hotel receptionist? Enrol the Hotel Receptionist Diploma course and master the strategies for becoming a successful hotel receptionist. The course is divided into several sections. Throughout these step by step sections, you will master the strategies of managing and handling the duties and responsibilities of a hotel receptionist. At first, you will gain an overall understanding about hotel reception process that will be followed by the discussion on standard hotel reception procedures and customer service. Then, you will know how to handle the difficult customers and how to manage their problems and complain. The course also covers the essential communication skill, computer skills, telephone etiquette, handling telephone calls and respond to customer's queries over phone and face-to-face conversation. Next, the course illustrates the essential administrative skills for a Hotel receptionist. Finally, the course explains the safety and security issues, legal issues in hospitality, future of Hotel receptionists and more. Shortly, you will learn almost all the essential skills and information for becoming an efficient Hotel receptionist. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. 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? Hotel Receptionist Diploma 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 Hotel Receptionist Diploma 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. Hotel Receptionist Diploma An Overview of Hotel Reception 01:00:00 Hotel Reception Standard Procedures 00:30:00 Communication Skills Required for Hotel Reception 01:00:00 Customer Service in Hotel Reception 00:30:00 Telephone Handling in a Hotel 01:00:00 How to Handle Difficult Hotel Guests 00:30:00 Administrative Skills as a Hotel Receptionist 00:30:00 Computer Skills and Programs 00:15:00 Brand Standards in the Hospitality World 00:15:00 Being a Team Player: Working with Other Hotel Departments 00:15:00 Safety and Security in the Hotel 01:00:00 Sales and Marketing as a Hotel Receptionist 00:30:00 Dressing the Part: Creating the Professional Look in Hospitality 00:15:00 Keeping Stress Under Control on the Job 00:30:00 Legal Issues in Hospitality 00:30:00 The Future for Hotel Receptionists 00:30:00 Assessment Assignment - Hotel Receptionist Diploma 00:00:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Hotel Receptionist Diploma
Delivered Online On Demand9 hours
£18

Level 5 Administration, Secretarial & Shorthand + Executive PA

By Wise Campus

Level 5 Administration, Secretarial & Shorthand + Executive PA Do you want to improve your understanding of business studies? If so, we have developed a highly unique Level 5 Business Administration course just for you to help you advance your abilities and learn about current business operations. You will learn the abilities necessary for the profession at Level 5 Business Administration, including administration and business communication. The Level 5 Business Administration course also includes courses on giving presentations and presenting corporate data. The Level 5 Business Administration course addresses the function of administration in both big and small organisations and teaches a range of administrative systems. This Level 5 Business Administration course will teach you how to lead a team in a professional context. So why are you still waiting? Learn the core ideas and various administrative skills needed to operate a firm by enrolling in our Level 5 Business Administration course! Learning Objectives Of Level 5 Business Administration After completing this Level 5 Business Administration course successfully, you will be able to: Learn a variety of management and business types from this Level 5 Business Administration course. Level 5 Business Administration teaches how to carry out many important functions and tasks for HR management. Level 5 Business Administration helps to extract maximum value from performance appraisals and interviews. You can develop and implement an effective marketing plan for your organisation through this Level 3 Business Administration course. Level 5 Business Administration helps to explore financial management objectives and functions. You can create business reports and delegate responsibilities to other employees, which helps build an efficient workforce with the help of this Level 5 Business Administration course. Level 5 Business Administration describes how to supervise and monitor teams and workforces of various sizes and types. Special Offers of this Business Administration: Business Administration Course This Business Administration: Business Administration Course includes a FREE PDF Certificate Lifetime access to this Business Administration: Business Administration Course. Instant access to this Business Administration: Business Administration Course. Get FREE Tutor Support to this Business Administration: Business Administration Course Level 5 Administration, Secretarial & Shorthand + Executive PA Elevate your career with our Level 5 Administration, Secretarial & Shorthand + Executive PA course, designed to equip you with essential business communication and administration skills. This Level 5 Administration, Secretarial & Shorthand + Executive PA program includes modules on delivering impactful presentations, managing corporate data, and understanding administration's role in both large and small organizations. Gain expertise in a variety of administrative systems and develop the leadership skills needed to manage a team effectively. With our Level 5 Administration, Secretarial & Shorthand + Executive PA course, you’ll be well-prepared for a dynamic career in professional administration. Who is this course for? Level 5 Administration, Secretarial & Shorthand + Executive PA This Level 5 Business Administration course is ideal for anybody in any business or office environment seeking to reach the top of the ladder. Requirements Level 5 Administration, Secretarial & Shorthand + Executive PA To enrol in this Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Business Administration: Business Administration Course. Be energetic and self-motivated to complete our Business Administration: Business Administration Course. Basic computer Skill is required to complete our Business Administration: Business Administration Course. If you want to enrol in our Business Administration: Business Administration Course, you must be at least 15 years old. Career path Level 5 Administration, Secretarial & Shorthand + Executive PA The following roles are appropriate for someone with this Level 5 Business Administration qualification: Business Administration Apprentice Business Administration Tutor Business and Administration Manager Business Administration – Trainer/Assessor Business Administration Manager

Level 5 Administration, Secretarial & Shorthand + Executive PA
Delivered Online On Demand4 hours 36 minutes
£12

Medical Transcription Training - CPD Certified

By Wise Campus

Medical Transcription: Medical Transcription Training Course Online Do you want a course on Medical Transcription to keep you better prepared for your Medical Transcription profession? our course will help you on that case. On the very first module of the Medical Transcription course, you can get ideas of medical transcription from this introduction to Medical Transcription. Then the Medical Transcription course will teach all the WH questions of the Medical Transcription subject. This Medical Transcription also explains medical languages boot camp with other documentation preparation. Moreover, the Medical Transcription course will explain the communicate style and data protection tecniques as a medical transcription expert. Take the initial steps toward a successful long-term career by studying the Medical Transcription course. Special Offers of this Medical Transcription: Medical Transcription Training Course This Medical Transcription: Medical Transcription Training Course includes a FREE PDF Certificate. Lifetime access to this Medical Transcription: Medical Transcription Training Course Instant access to this Medical Transcription: Medical Transcription Training Course Get FREE Tutor Support to this Medical Transcription: Medical Transcription Training Course Medical Transcription: Medical Transcription Training Course Online An engaging introduction to medical transcription can be found in the Medical Transcription: Medical Transcription Course. You can learn how to create medical reports and the purpose of medical transcription from the Medical Transcription course. Along with other documentation preparation skills, this medical transcription program teaches medical languages. In addition, the Medical Transcription course will cover data protection and communication protocols for medical clients. Who is this course for? Medical Transcription: Medical Transcription Training Course Online Anyone may benefit from this Medical Transcription: Medical Transcription Training Course, including new grads, job seekers, and students. Requirements Medical Transcription: Medical Transcription Training Course Online To enrol in this Medical Transcription: Medical Transcription Training Course, students must fulfil the following requirements. To join in our Medical Transcription Training Course, you must have a strong command of the English language. To successfully complete our Medical Transcription Training Course, you must be vivacious and self driven. To complete our Medical Transcription: Medical Transcription Training Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Medical Transcription Course. Career path Medical Transcription: Medical Transcription Training Course Online You may work as a medical transcriptionist, audio typist, medical office manager, and many other positions after finishing this course on Medical Transcription: Medical Transcription Training Course!

Medical Transcription Training - CPD Certified
Delivered Online On Demand1 hour 18 minutes
£12

Bookkeeping Tool : Google Sheets

By The Teachers Training

Overview Bookkeeping Tool : Google Sheets Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Bookkeeping Tool : Google Sheets Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Bookkeeping Tool: Google Sheets Unit 1: Introduction 00:03:00 Unit 2: Google Sheets Users 00:03:00 Unit 3: Cash Bookkeeping 00:04:00 Unit 4: Advantages of Google Sheets in Bookkeeping 00:02:00 Unit 5: Chart of Accounts 00:03:00 Unit 6: Templates view 00:02:00 Unit 7: Invoice Template 00:02:00 Unit 8: Creating an Expense Book 00:03:00 Unit 9: Creating the Profit and Loss Statement 00:06:00 Unit 10: Making Records in the Revenue Book 00:03:00 Unit 11: Making Records in the Expense book 00:04:00 Unit 12: How the Profit and Loss Statement Updates 00:03:00

Bookkeeping Tool : Google Sheets
Delivered Online On Demand38 minutes
£27.99

Microsoft Word Masterclass

By The Teachers Training

Microsoft Word Masterclass is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Microsoft Word Masterclass and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 3 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Manipulating Images Integrate Pictures and Text 00:15:00 Adjust Image Appearance 00:09:00 Insert Other Media Elements 00:02:00 Using Custom Graphic Elements Create Text Boxes and Pull Quotes 00:06:00 Add WordArt and Other Text Effects 00:05:00 Draw Shapes 00:07:00 Create Complex Illustrations with SmartArt 00:08:00 Collaborating on Documents Prepare a Document for Collaboration 00:09:00 Mark Up a Document 00:06:00 Review Markups 00:04:00 Merge Changes from Other Documents 00:06:00 Adding Document References and Links Add Captions 00:06:00 Add Cross References 00:08:00 Add Bookmarks 00:05:00 Add Hyperlinks 00:06:00 Insert Footnotes and Endnotes 00:05:00 Add Citations and a Bibliography 00:12:00 Securing a Document Suppress Information 00:08:00 Set Formatting and Editing Restrictions 00:06:00 Restrict Document Access 00:02:00 Add a Digital Signature to a Document 00:04:00 Using Forms to Manage Content Create Forms 00:09:00 Modify Forms 00:03:00 Automating Repetitive Tasks with Macros Automate Tasks by Using Macros 00:10:00 Create a Macro 00:19:00

Microsoft Word Masterclass
Delivered Online On Demand3 hours
£27.99

Corporate Receptionist

4.5(3)

By Studyhub UK

Receptionist jobs near me is one of the most searched jobs in the job listing sites. In the fast-paced corporate world of London, a corporate receptionist is a beacon of professionalism and efficiency. Imagine being the first point of contact, the welcoming face that sets the tone for esteemed businesses. Corporate receptionist jobs in London offer an exciting blend of challenges and opportunities, where every interaction is a chance to make a lasting impression. From managing phone calls to orchestrating travel arrangements, the responsibilities are diverse, making this career path both dynamic and rewarding. Stepping into the shoes of a corporate receptionist means embracing a multifaceted role encompassing various modules. From mastering business telephone etiquette to efficiently managing mail services, each course module equips learners with essential skills tailored for success in this field. Whether representing your boss and company with finesse or honing impeccable communication skills, the journey of becoming a corporate receptionist in London is filled with growth and development. Corporate receptionist vacancies are not just about answering calls or scheduling meetings; they are about embodying the essence of professionalism and organisational prowess. Through this course, learners delve into the intricacies of time management, customer service, and effective planning, ensuring they are well-prepared to navigate the demands of the corporate world. Joining this course isn't just about securing a job; it's about embarking on a journey towards becoming an indispensable asset in corporate reception and administration. Learning Outcomes: Master business telephone skills for effective communication. Develop proficiency in representing both boss and company with professionalism. Acquire knowledge in managing mail services and shipping efficiently. Demonstrate expertise in organising meetings, conferences, and travel arrangements. Cultivate essential skills in time management, record-keeping, and customer service. Why buy this Corporate Receptionist 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. Certification After studying the course materials of the Corporate Receptionist you will be able to take the MCQ test that will assess your knowledge. 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 Corporate Receptionist course for? Individuals seeking corporate receptionist jobs in London. Aspiring receptionists interested in honing their skills. Professionals aiming to enhance their administrative capabilities. Graduates looking to enter the corporate world. Anyone interested in pursuing a career in customer-facing roles. Prerequisites This Corporate Receptionist 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 Corporate Receptionist: £20,000 - £25,000 per annum Dental Receptionist Jobs: £21,000 - £27,000 per annum Hotel Receptionist: £18,000 - £23,000 per annum Vet Receptionist Jobs: £19,000 - £24,000 per annum Course Curriculum Module 01: Introduction to Reception and Receptionist Introduction to Reception and Receptionist 00:29:00 Module 02: Business Telephone Skills Business Telephone Skills 00:21:00 Module 03: Representing Your Boss and Company Representing Your Boss and Company 00:25:00 Module 04: Mail Services and Shipping Mail Services and Shipping 00:26:00 Module 05: Travel Arrangements Travel Arrangements 00:22:00 Module 06: Organising Meeting and Conferences Organising Meeting and Conferences 00:19:00 Module 07: Time Management Time Management 00:25:00 Module 08: Record Keeping and Filing Systems Record Keeping and Filing Systems 00:24:00 Module 09: Business Writing Skills Business Writing Skills 00:25:00 Module 10: Communication Skills Communication Skills 00:19:00 Module 11: Customer Service Customer Service 00:22:00 Module 12: Effective Planning and Scheduling Effective Planning and Scheduling 00:39:00 Module 13: Invoicing/Petty Cash Invoicing/Petty Cash 00:20:00

Corporate Receptionist
Delivered Online On Demand5 hours 16 minutes
£10.99

Transcription Skills Beginner Level

4.5(3)

By Studyhub UK

The 'Transcription Skills Beginner Level' course is a comprehensive program designed to introduce learners to the fundamentals of transcription. It covers essential topics such as transcription techniques, grammar and punctuation, and specialized transcription fields. Students will gain the skills needed to start a successful transcription career. Learning Outcomes: Understand the basics of transcription and its importance. Develop proficiency in basic transcription techniques. Master advanced transcription techniques for accuracy and efficiency. Apply proper grammar and punctuation rules in transcription. Explore various transcription specializations, such as medical or legal transcription. Build the foundation for a successful career in transcription. Enhance listening skills for improved transcription accuracy. Learn to use transcription tools and software effectively. Why buy this Transcription Skills Beginner Level? 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 Transcription Skills Beginner Level 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 Transcription Skills Beginner Level does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Individuals looking to enter the transcription field. Freelancers seeking to expand their skill set and career opportunities. Students pursuing a career in transcription, journalism, or related fields. Professionals aiming to add transcription skills to their resume. Prerequisites This Transcription Skills Beginner Level 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 Entry-Level Transcriptionist - Potential earning of £15,000 - £25,000 per year. Medical Transcriptionist - Median earning of £20,000 - £30,000 per year. Legal Transcriptionist - Median earning of £20,000 - £35,000 per year. Freelance Transcriptionist - Earnings vary based on workload and clients. Transcription Quality Assurance Specialist - Potential earning of £25,000 - £40,000 per year. Course Curriculum Module 01: Introduction to Transcription Introduction to Transcription 00:08:00 Module 02: Basic Transcription Techniques Basic Transcription Techniques 00:07:00 Module 03: Advanced Transcription Techniques Advanced Transcription Techniques 00:07:00 Module 04: Grammar and Punctuation in Transcription Grammar and Punctuation in Transcription 00:06:00 Module 05: Transcription Specializations Transcription Specializations 00:07:00 Module 06: Building a Successful Transcription Career Building a Successful Transcription Career 00:06:00

Transcription Skills Beginner Level
Delivered Online On Demand41 minutes
£10.99

Accredited Microsoft Project 2007 Advanced Level

By iStudy UK

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

Accredited Microsoft Project 2007 Advanced Level
Delivered Online On Demand11 hours
£25

Oracle 11g PL/SQL Part 1

By iStudy UK

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

Oracle 11g PL/SQL Part 1
Delivered Online On Demand9 hours 54 minutes
£25