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

57818 Courses

Professional Certificate Course in Understanding the Marketing Mix in London 2024

4.9(261)

By Metropolitan School of Business & Management UK

This course offers a deep dive into the marketing mix, dissecting each of the Four P's and their interconnectedness with product life cycles. Participants will analyze how marketing decisions influence product features, pricing strategies, supply chain management, and integrated marketing communication, gaining a holistic understanding of modern marketing dynamics. After the successful completion of the course, you will be able to learn about the following, Define and explain the concept of the marketing mix. Define and elaborate on each of the Four P's: Product, Price, Place, and Promotion. Explore how the Four P's relate to different stages of the product life cycle. Examine how marketing decisions impact the product itself, including features, design, and branding. Evaluate how marketing strategies affect pricing decisions, such as setting initial prices, discounts, and pricing adjustments. Define the concept of the supply chain and its significance in marketing. Analyze how efficient supply chain management can impact product availability, distribution, and customer satisfaction. Define integrated marketing communication (IMC) and its role in modern marketing. Examine the components of IMC, including advertising, public relations, sales promotion, personal selling, and digital marketing. From defining the marketing mix to exploring supply chain significance and integrated marketing communication, this course covers the essentials. Participants will examine pricing decisions, product life cycle stages, and the components of integrated marketing communication, preparing them to navigate complex marketing landscapes strategically.   Dive into the intricacies of the marketing mix with this course, dissecting each Four P - Product, Price, Place, and Promotion - and understanding their impact on product life cycles. Participants will gain insights into supply chain management and integrated marketing communication, emerging equipped to make strategic marketing decisions across diverse aspects of the field. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Understanding The Marketing Mix Self-paced pre-recorded learning content on this topic. Understanding the Marketing Mix Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course.The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. Product Manager Pricing Strategist Distribution Coordinator Promotion Specialist Supply Chain Analyst Marketing Communication Manager Branding Consultant Digital Marketing Coordinator Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Professional Certificate Course in Understanding the Marketing Mix in London 2024
Delivered Online On Demand14 days
£38

Sales Management Advanced Diploma - CPD Certified

4.5(3)

By Studyhub UK

24 Hour Flash Deal **25-in-1 Sales Management Advanced Diploma Mega Bundle** Sales Management Advanced Diploma Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Sales Management Advanced Diploma package online with Studyhub through our online learning platform. The Sales Management Advanced Diploma bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Sales Management Advanced Diploma course provides complete 360-degree training on Sales Management Advanced Diploma. You'll get not one, not two, not three, but twenty-five Sales Management Advanced Diploma courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Sales Management courses are yours for as long as you want them once you enrol in this course This Sales Management Advanced Diploma Bundle consists the following career oriented courses: Course 01: Sales Training: Practical Sales Techniques Course 02: Sales and Marketing Course 03: Advanced Sales and Selling Management Techniques Course 04: Sales and Marketing: Email Marketing Course 05: B2B Sales & Marketing Strategies: Winning in Business-to-Business Sales Course 06: B2B Business Development: Strategies for Sustainable Growth Course 07: Learn to Create A Selling Strategy that Drives Sales Course 08: NLP For Sales, Persuasion & Influence Course 09: Increase Your Sales Through a Profitable Pricing Strategy Course 10: Product Management for Maximum Sales: Boosting Business Success Course 11: Sales Analysis in Excel Course 12: Residential Property Sales Course 13: Basic Training for Real Estate Agents Course 14: Retail Management Course 15: Retail Associate Certificate Course 16: Telemarketing Course 17: Diploma in Sales and Strategic Marketing Certificate Course 18: ETSY Marketing and Business Course 19: Affiliate Marketing Course 20: Content Writing & Copywriting For SEO and Sales Course 21: Marketing Strategies for Business Course 22: Learn to Drive Traffic into Sales through Digital Marketing Course 23: Step-by-Step Guide to Defining and Sizing Your Market Course 24: Corporate Relationship Goals for Success Course 25: Get a Job in Sales: Your Fast Track to Career Success In this exclusive Sales Management Advanced Diploma bundle, you really hit the jackpot. Here's what you get: Step by step Sales Management Advanced Diploma lessons One to one assistance from Sales Management Advanced Diploma professionals if you need it Innovative exams to test your knowledge after the Sales Management Advanced Diploma course 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Sales Management Advanced Diploma courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Sales Management Advanced Diploma certificate and transcript on the next working day Easily learn the Sales Management Advanced Diploma skills and knowledge you want from the comfort of your home The Sales Management Advanced Diploma course has been prepared by focusing largely on Sales Management Advanced Diploma career readiness. It has been designed by our Sales Management specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Sales Management Advanced Diploma Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Sales Management bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Sales Management Advanced Diploma Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Sales Management Advanced Diploma Elementary modules, allowing our students to grasp each lesson quickly. The Sales Management Advanced Diploma course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Sales Management Advanced Diploma training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Sales Management Advanced Diploma Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Requirements To participate in this Sales Management Advanced Diploma course, all you need is - A smart device A secure internet connection And a keen interest in Sales Management Advanced Diploma Career path You will be able to kickstart your Sales Management Advanced Diploma career because this course includes various courses as a bonus. This Sales Management Advanced Diploma is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Sales Management Advanced Diploma career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

Sales Management Advanced Diploma - CPD Certified
Delivered Online On Demand6 days
£279

Self Confidence Training Course

By Compete High

Overview   With the ever-increasing demand for Confidence in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Confidence may be.   Learning about Confidence or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Confidence. That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Confidence is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates.   The self-paced online learning methodology by compete high in this Self Confidence Training course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course!   Instead of searching for hours, enrol right away on this Self Confidence Training course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run.   Who is this course for?   While we refrain from discouraging anyone wanting to do this Self Confidence Training course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Confidence, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Confidence, Anyone looking for a certificate of completion on doing an online training on this topic, Students of Confidence, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity   Career Path   This Self Confidence Training course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.    Course Curriculum Module 1- The Basics of Confidence The Basics of Confidence 00:00 Module 2-Common Barriers to Confidence Common Barriers to Confidence 00:00 Module 3- Assessing Your Confidence Level Assessing Your Confidence Level 00:00 Module 4-Finding Your Motivation Finding Your Motivation 00:00 Module 5-Building Your Confident Self Building Your Confident Self 00:00 Module 6-Communicating Your Confidence Communicating Your Confidence 00:00 Module 7-Confident Decision Making And Problem Solving Confident Decision Making And Problem Solving 00:00 Module 8-Demonstrating Confidence in the Workplace Demonstrating Confidence in the Workplace 00:00

Self Confidence Training Course
Delivered Online On Demand8 hours
£25

Advanced UNIX shell programming

5.0(3)

By Systems & Network Training

Advanced UNIX shell scripting training course description A follow on hands on course from the Introduction to shell programming course covering the powerful sed and awk tools along with the extra Korn shell programming features. What will you learn Use regular expressions within grep, ed and many other utilities. Use awk and sed. Integrate sed and awk into shell scripts. Recognise the role of shell scripts within the UNIX system. Write shell scripts using new Korn shell features including: The select construct Arrays Arithmetic evaluation Advanced UNIX shell scripting training course details Who will benefit: Programmers developing applications under UNIX. Administrators who need time saving utilities. Technical personnel who wish to make the most out of the Korn Shell. Prerequisites: UNIX shell scripting Duration 3 days Advanced UNIX shell scripting training course contents Regular Expressions What are REs? How can they be used? How to write REs More REs e REs Tagging, matching words, repetitions. The sed editor Basic usage: Saving output, options. sed script files, sed commands, Specifying lines to edit, Hold space and pattern space, advanced commands Awk Basic usage, nawk script files, Patterns, Records and fields, Actions if, while, do, for... System variables NF, NR, RS... Arrays Functions length, printf, cos, user defined... Using nawk in shell scripts Korn shell scripts Review of Bourne shell scripts functions... Variables typeset, manipulating strings Arrays Arithmetic evaluation the let command, (( )), typeset -i The select construct Syntax, workings, REPLY, PS3 Miscellaneous Enhanced I/O, ${10}

Advanced UNIX shell programming
Delivered in Internationally or OnlineFlexible Dates
£1,697

(PTTLS) Level 3 Award in Education and Training (RQF) & SEN Course - Train the Trainer

4.5(212)

By The Learning College Group

The Learning College Group offers this Teaching Assistant qualification that is fully Regulated and accepted in all schools across the UK. It enables you to work with children between the ages of 5-18 years. This Level 3 Teaching Assistant course is a recognised (RQF) qualification that can be studied in your own time from home. 1-2-1 Tutor support is provided with this Teaching Assistant course. OFSTED accepted and regulated by OFQUAL this qualification will be the required course to secure your job as a Teaching Assistant.

(PTTLS) Level 3 Award in Education and Training (RQF) & SEN Course - Train the Trainer
Delivered Online On Demand
£49 to £299

An Understanding of Gastrostomy Tube Care and Safe Use

By Guardian Angels Training

Gain comprehensive knowledge and practical skills for safe gastrostomy tube care with our course. Learn techniques, considerations, and patient care.

An Understanding of Gastrostomy Tube Care and Safe Use
Delivered In-Person in InternationallyFlexible Dates
£1,175

Professional Personal Finance Course

By The Teachers Training

Overview Professional Personal Finance 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 Professional Personal Finance 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. Section 01: Introduction Introduction 00:01:00 Section 02: Personal Finance Personal Finance 00:03:00 Areas of Personal Finance 00:03:00 Net Worth 00:01:00 Net Worth - Example 00:02:00 Section 03: Personal Expenses and Income Housing Expenses 00:02:00 Utility Expenses 00:02:00 Credit Debts 00:01:00 Food Expenses 00:01:00 Clothing Expenses 00:02:00 Gift Expenses 00:01:00 Travel Expenses 00:01:00 Extra Income - Part 1 00:01:00 Extra Income - Part 2 00:02:00 Section 04: Savings Emergency Fund 00:03:00 Savings on Retirement 00:05:00 Health Insurance 00:03:00 Section 05: How to Manage Your Personal Finance Using Free Budgeting Software Introduction to the Budgeting Software 00:02:00 Setting Up - Part 1 00:01:00 Setting Up - Part 2 00:02:00 Dashboard 00:03:00 Budget Analysis 00:03:00 Assignment Assignment - Professional Personal Finance Course 00:00:00

Professional Personal Finance Course
Delivered Online On Demand45 minutes
£27.99

Operations, Maintenance and Testing of Power Transformer & Electric Motors

By EnergyEdge - Training for a Sustainable Energy Future

About this Virtual Instructor Led Training (VILT)  Electrical machines, mainly power transformers and electric motors are critical equipment that run production, and it must operate without any abnormalities. A wide variety of tests and standards have been developed to assist manufacturers and users of motors and transformer winding, assess the condition of the electrical insulation. The objective of this training course is to provide an understanding of power transformers and electric motors, their materials, components, and how they operate. It will also emphasize the importance of transformer life management, especially for those transformers and electric motors which have been in operation for than 10 years. The course will address in detail all aspects related to transformer principles, calculations, operation, testing and maintenance. Training Objectives This course aims to provide participants with the understanding of the fundamentals and constructional features of power transformers and electric motors, with particular reference to the design, testing, operation and maintenance of transformers in power systems. Delegates will gain a detailed appreciation of the following: Practical solutions for specifying, operating and maintaining power transformers and electric motors in a utility or plant environment Comprehensive understanding of principles, protection, maintenance and troubleshooting of power transformers and electric motors The necessary safe procedures relating to transformer operation and related circuitry Understand the principles of operation of the transformer and electric motors Identify the different features of power transformers and electric motors Appreciate the principles of transformer design, ratings, winding, core structure and materials, insulation and cooling methods, insulation and lifetime Utilize thermal limits and loading guides of transformers Analyze transformer and electric motors failure modes Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Course Level Basic or Foundation Training Methods The VILT will be delivered online in 4 half-day sessions comprising 4 hours per day, with 1 x 10 minutes break per day, including time for lectures, discussion, quizzes and short classroom exercises. Additionally, some self-study will be requested. Participants are invited but not obliged to bring a short presentation (10 mins max) on a practical problem they encountered in their work. This will then be explained and discussed during the VILT. A short test or quiz will be held at the end the course. Trainer Our key expert is actively involved in electrical inspections, energy audits, energy efficiency and technical consultation for M&E activities for industrial and commercial sectors. He is involved in testing and commissioning works of factory substations of up to 132kV system. He previously worked for Jimah coal-fired power plant in Port Dickson for 9 years with his last position being Electrical Maintenance Section Head. He was involved in the commissioning of coal-fired power plant mainly with 500kV generator transformer, 934 MVA generator, and up to 33kV MV motors and switchgear panels. Our key expert has managed the maintenance team to perform routine maintenance activities (together with supporting tools such as motor lube oil analysis, infrared thermography analysis, transformer oil analysis) & electrical troubleshooting and plant outages for critical and non-critical equipment. Besides that, our key expert has published several IEEE conference papers and journals such as: (2009). Effectiveness of auxiliary system monitoring & continuous hydrogen scavenging operation on hydrogen-cooled generator at power plant. In Energy and Environment, 2009. ICEE 2009. 3rd International Conference on (pp. 151-160). IEEE. (2010). Study on electric motor mass unbalance based on vibration monitoring analysis technique. In Mechanical and Electrical Technology (ICMET), 2010 2nd International Conference on (pp. 539-542). IEEE. (2012). Re-Design of AC Excitation Busduct based on Infrared (IR) Thermography: Condition-Based Monitoring (CBM) data analysis. eMaintenance, 101. (2016). Energy Saving Studies for a University Campus: An Educational-Based Approach, 3rd International Conference on Language, Education, Humanities and Innovation 2016. 'Grid-tied photovoltaic and battery storage systems with Malaysian electrcity tariff - A review on maximum demand shaving.' Energies 10.11 (2017): 1884 'Techno-Economic Optimization of Grid-Connected Photovoltaic (PV) and Battery Systems Based on Maximum Demand Reduction (MDRed) Modelling in Malaysia.' Energies 12.18 (2019): 3531 POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

Operations, Maintenance and Testing of Power Transformer & Electric Motors
Delivered in Internationally or OnlineFlexible Dates
£1,238 to £2,336

Customer Relations & Dealing Course

4.3(43)

By John Academy

Are you aware of the importance of communication and its usage to customer relations dealings? Do you want to know how to improve yourself to be able to communicate well with your cients? If yes, then you should take an initiative to be able to develop your communicate techniques to be able to communicate well with your customers. Description: When you in a customer relations line of job, you will find at first that handling a difficult customer may seem like a worthless job and does not need so much. However, it does but fortunately, you can develop skills to be able to adapt the challenges that difficult customers pose. This course will be able to help you extend your communication skills to handling difficult people and situations throughout your daily life. Moreover, improving the focus of your thoughts and feelings, stress management, and the way you listen to and empathize with others, you will be better able to meet the challenges other people pose in both your professional and personal life. Implementing the guidelines in this module is the first step in a process towards forever changing how you interact with others. There are particular methodologies and techniques that may help you upgrading your relational abilities and these will disclose to you where you are deficient. In this course, you will clearly get individuals to react with the right communication and approaches to doing it effectively. Who is the course for? Professionals who work in the communications industry or part of the communications department. This will also be helpful to those people who are struggling with communication that can affect their customer relations dealing People who are interested in learning more about communication Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hard copy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Customer Relations & Dealing Course is a useful qualification to possess, and would be beneficial for the following careers: Call Center Agent Concierge Client Relations Associate Customer Service Representative Front Desk Associate/Receptionist Member Service Specialist Patient Care Coordinator. Customer Relations & Dealing Module One - Getting Started 00:30:00 Module Two - The Right Attitude Starts with You 01:00:00 Module Three - Stress Management (Internal Stressors) 01:00:00 Module Four - Stress Management (External Stressors) 00:30:00 Module Five - Transactional Analysis 01:00:00 Module Six - Why are Some Customers Difficult 01:00:00 Module Seven - Dealing with the Customer Over the Phone 01:00:00 Module Eight - Dealing with the Customer In Person 01:00:00 Module Nine - Sensitivity in Dealing with Customers 01:00:00 Module Ten - Scenarios of Dealing with a Difficult Customer 01:00:00 Module Eleven - Following up With a Customer Once You Have Addressed Their Issue 01:00:00 Module Twelve - Wrapping Up 00:30:00 Customer Relationship Management Customer Relationship Management 00:10:00 What CRM Is and Who It Serves 00:15:00 Checklist for Success 00:15:00 Requirement Driven Product Selection 00:15:00 Considerations in Tool Selection 00:15:00 Strategies for Customer Retention 00:15:00 Building the Future 00:15:00 Homegrown vs. Application Service Provider 00:15:00 Evaluating and Reviewing Your Program 00:15:00 The Development Team 00:15:00 Mock Exam Mock Exam- Customer Relations & Dealing Course 00:20:00 Final Exam Final Exam- Customer Relations & Dealing Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Customer Relations & Dealing Course
Delivered Online On Demand13 hours 35 minutes
£22

Oracle SQL Advanced

5.0(3)

By Systems & Network Training

Oracle SQL Advanced training course description The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features. What will you learn Retrieve data using correlated subqueries, in-line views and multi-column subqueries. Use the WITH Clause. Inserting and Updating Rows Using Complex Subqueries Create Hierarchical Queries. Use ROLLUP, CUBE and GROUPING SETS group by enhancements. Implement the GROUPING and GROUPING_ID functions. Manage large data sets. Insert data conditionally and unconditionally. Merge Rows in a Table. Create TIMESTAMP and INTERVAL Datatypes. Use TIMESTAMP, TIMEZONE and INTERVAL functions and literals. Use regular expressions and implement related functions. Manage objects with the data dictionary. Manage schema objects. Perform flashback operations. Create and using external tables. Control user access to database objects. Oracle SQL Advanced training course details Who will benefit: Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database. Prerequisites: Delegates should have attended the Oracle SQL course or have a similar level of experience. Duration 2 days Oracle SQL Advanced training course contents Retrieve data using subqueries ANY, ALL or SOME operators, Correlated subqueries, In-Line views, The Exists operator, The WITH clause, Multi-Column subqueries, Insert and update using a query, Correlated update and delete. Hierarchical queries Hierarchical data, The START WITH and CONNECT BY clauses, The LEVEL pseudo-column, Sequencing the output, Eliminating nodes and branches. Enhanced grouping features Review of basic grouping concepts, The ROLLUP and CUBE extensions, The GROUPING SETS extension, Using the GROUPING and GROUPING_ID functions. Manage large data sets Multi-table Inserts, Conditional and unconditional Inserts, Merging data into a table, Table and view based merge, A sub query based merge. Flashback technology Flashback query, The AS clause, Flashback table, Flashback drop. Date, time and time zone support Date, Timestamp and Interval datatypes, Handling dates and times, Handling intervals, Date, timestamp and interval functions and literals, Related NLS parameters. Regular expression support Regular expression notation, Character matching, Repetition operators, Sub expression grouping, Regular expression functions. Manage objects with the Data Dictionary The Data Dictionary, Useful Data Dictionary tables, Using the Data Dictionary. Manage schema objects Column operations, Constraint operations, Creating and dropping Indexes, B-Tree indexes, Function based indexes, Descending indexes, Creating and using external tables. Access control System privileges and roles, Create users, Alter user details, Grant and revoke object privileges.

Oracle SQL Advanced
Delivered in Internationally or OnlineFlexible Dates
£1,727