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

59576 Courses

Paediatrician

5.0(10)

By Apex Learning

Overview This comprehensive course on 'Paediatrician' will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This 'Paediatrician' comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this 'Paediatrician'. It is available to all students, of all academic backgrounds. Requirements Our 'Paediatrician' is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 9 sections • 9 lectures • 05:12:00 total length •Introduction to Paediatrician: 00:37:00 •Paediatric Nutrition and Nutritional Disorders: 00:22:00 •Neonatology: 00:38:00 •Gastroenterology: 00:47:00 •Haematology: 00:31:00 •Neurology: 00:37:00 •Immunology and Allergy: 00:32:00 •Oncology: 00:47:00 •Paediatrics, ethics, and the law: 00:21:00

Paediatrician
Delivered Online On Demand5 hours 12 minutes
£12

Nursery Nurse and Childcare Complete Bundle

5.0(10)

By Apex Learning

Overview Explore the colourful world of taking care of children with the Nursery Nurse and Childcare Complete Bundlecourse. This comprehensive Nursery Nurse and Childcare Complete Bundle  will teach you the fundamentals of developmental psychology and the different growth stages in infants you need to know to excel in this field. With this comprehensive course, you will learn how to look after, guide, and safeguard children, playing a crucial role in their development.Develop the most in-demand skills to boost your career by enrolling in Nursery Nurse and Childcare Complete Bundle course. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Nursery Nurse and Childcare Complete Bundle. It is available to all students, of all academic backgrounds. Requirements Our Nursery Nurse and Childcare Complete Bundle is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 8 sections • 8 lectures • 03:31:00 total length •Understanding Child Development: 00:24:00 •Caring for Children: 00:25:00 •Healthy Food, Healthy Living: 00:24:00 •Keeping Children Healthy and Safe: 00:31:00 •Child Protection: 00:23:00 •Play, Imagination and Creativity: 00:26:00 •Early Years Provision: 00:19:00 •Children with Special Needs: 00:39:00

Nursery Nurse and Childcare Complete Bundle
Delivered Online On Demand3 hours 31 minutes
£12

Nurse Prescribing & Medicine Management

5.0(10)

By Apex Learning

Overview This comprehensive course on Nurse Prescribing & Medicine Management will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Nurse Prescribing & Medicine Management comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Nurse Prescribing & Medicine Management. It is available to all students, of all academic backgrounds. Requirements Our Nurse Prescribing & Medicine Management is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 15 sections • 15 lectures • 06:13:00 total length •Introduction to Nurse Prescribing: 00:16:00 •Legal and Ethical Aspects of Prescribing: 00:32:00 •Medicine Management: 00:36:00 •Anxiety Disorders in Adults: 00:15:00 •Liver Diseases Diagnoses Prescribing: 00:46:00 •Common Problems: Pharmacological Management: 01:06:00 •Anti-Microbial Prescribing: 00:28:00 •Cardiac Problems and Prescribing: 00:21:00 •Neurological Problems and Prescribing: 00:16:00 •Palliative Care: 00:09:00 •Prescribing in Pregnancy and Lactation: 00:31:00 •Prescribing for Older People: 00:12:00 •Prescribing for Children: 00:17:00 •Common Medicines in Use: 00:14:00 •Challenges and Future of Nurse Prescribing: 00:14:00

Nurse Prescribing & Medicine Management
Delivered Online On Demand6 hours 13 minutes
£12

Night Photography

5.0(10)

By Apex Learning

Overview This comprehensive course on Night Photography will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Night Photography comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Night Photography. It is available to all students, of all academic backgrounds. Requirements Our Night Photography is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 10 sections • 60 lectures • 04:21:00 total length •Module 1: Introduction to the Course: 00:02:00 •Module 2: What is Night Photography: 00:01:00 •Module 1: Photography Equipment Introduction: 00:01:00 •Module 2: Camera: 00:02:00 •Module 3: Sensor Size: 00:03:00 •Module 4: Lenses: 00:03:00 •Module 5: Prime VS Zoom: 00:02:00 •Module 6: Tripods: 00:02:00 •Module 7: Filters: 00:02:00 •Module 8: Accessories: 00:05:00 •Module 1: Introduction to Basics: 00:01:00 •Module 2: What is ISO: 00:02:00 •Module 3: ISO Practical: 00:02:00 •Module 4: What is Aperture: 00:02:00 •Module 5: What is Shutter Speed: 00:03:00 •Module 6: Shutter Speed Practical: 00:04:00 •Module 7: Exposure Triangle: 00:03:00 •Module 1: Introduction to Advanced Basics: 00:01:00 •Module 2: Histogram: 00:03:00 •Module 3: RAW vs JPEG: 00:03:00 •Module 4: What is RAW: 00:02:00 •Module 5: Dynamic Range: 00:03:00 •Module 6: Kelvin Temp: 00:03:00 •Module 1: Introduction - How to Plan: 00:02:00 •Module 2: Light Pollution: 00:03:00 •Module 3: Weather App: 00:03:00 •Module 4: PhotoPills: 00:06:00 •Module 5: Feature of PhotoPills: 00:07:00 •Module 6: PRO Tip for Night Sky Planning: 00:03:00 •Module 1: How to Focus: 00:07:00 •Module 2: Base Settings: 00:02:00 •Module 3: Practical Base Setting: 00:02:00 •Module 4: Underexposed: 00:02:00 •Module 5: Overexposed Part 1: 00:02:00 •Module 6: Overexposed Part 2: 00:03:00 •Module 7: Pro Tip to Find Composition Fast: 00:02:00 •Module 1: Introduction to Composition: 00:02:00 •Module 2: Foreground: 00:03:00 •Module 3: Scale: 00:03:00 •Module 4: Reflection: 00:03:00 •Module 5: Low Light Cityscape Photography: 00:04:00 •Module 6: Creating Simple Light Trails: 00:03:00 •Module 1: Light Pollution Filter: 00:02:00 •Module 2: Exposure Blending: 00:03:00 •Module 3: Artificial Light: 00:03:00 •Module 4: Focus Stacking: 00:04:00 •Module 5: Time Lapse: 00:05:00 •Module 6: Star Trails: 00:03:00 •Module 1: Editing - Introduction: 00:02:00 •Module 2: Basic Overview: 00:19:00 •Module 3: Global VS Local Adjustment: 00:09:00 •Module 4: Editing Night Photography Images: 00:22:00 •Module 5: Proper Artificial Light: 00:15:00 •Module 6: Blending Multiple Exposure: 00:13:00 •Module 7: Focus Stack- Photoshop: 00:07:00 •Module 8: Focus Stack- Helicon: 00:06:00 •Module 9: Time Lapse: 00:06:00 •Module 10: Star Trails: 00:11:00 •Module 11: Adobe Lightroom Pro Tips: 00:14:00 •Assignment - Night Photography: 00:00:00

Night Photography
Delivered Online On Demand4 hours 21 minutes
£12

Street Photography

5.0(10)

By Apex Learning

Overview This comprehensive course on Street Photography will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Street Photography comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Street Photography. It is available to all students, of all academic backgrounds. Requirements Our Street Photography is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 5 sections • 29 lectures • 01:34:00 total length •Introduction: 00:02:00 •What is Street Photography: 00:03:00 •Equipment Recommendations: 00:02:00 •Basic Settings : 00:04:00 •Intro to Strongest I'II Ever Be: 00:15:00 •Where Shoot Photos: 00:04:00 •How to Take Photos of Strangers : 00:14:00 •Composing Better Photos: 00:09:00 •Portrait - Face in the Shadows: 00:02:00 •Portrait - Capturing Raw Emotions : 00:05:00 •Portrait - When Life Gives You Lemons: 00:02:00 •Portrait - Get Up Close and Personal: 00:01:00 •Portrait - Silhouettes and the Power of RAW : 00:02:00 •Portrait - When You Can't Take a Portrait: 00:03:00 •Portrait - Can I Take Your Photograph While We're Talking: 00:02:00 •Portrait - Ease Your Way Into the Shot: 00:01:00 •Portrait - Wait for the Right Moment : 00:02:00 •Lighting - Drama and Lens Flares: 00:02:00 •Architecture - Seeing the Beauty in the Small Things: 00:01:00 •Lighting - Taking Photos at High Noon: 00:02:00 •Lighting - Photographing the Sun: 00:01:00 •Silhouette - Walking Away: 00:01:00 •Lighting - Back Lighting and Shadows: 00:02:00 •Be Ready for Any Moment: 00:01:00 •Find Your Frame and Be Patient: 00:01:00 •When Your Subject Walk on By: 00:01:00 •Where Preparation and Luck Meet: 00:01:00 •Sharing Your Work: 00:06:00 •Thank You: 00:02:00

Street Photography
Delivered Online On Demand1 hour 34 minutes
£12

Store Assistant

5.0(10)

By Apex Learning

Overview This comprehensive course on Store Assistant will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Store Assistant comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Store Assistant. It is available to all students, of all academic backgrounds. Requirements Our Store Assistant is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 10 sections • 10 lectures • 02:45:00 total length •Introduction to Store Assistant: 00:18:00 •Roles and Responsibilities of a Store Assistant: 00:17:00 •Introduction to Retail Management: 00:13:00 •Managing a Retail Store: 00:15:00 •Visual Merchandising: 00:17:00 •Consumer Behaviour: 00:17:00 •Dealing with Customers a: 00:28:00 •Dealing with Suppliers: 00:14:00 •Store Psychology: 00:13:00 •Legislations Related to Retail: 00:13:00

Store Assistant
Delivered Online On Demand2 hours 45 minutes
£12

Statistics

5.0(10)

By Apex Learning

Overview This comprehensive course on Statistics will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Statistics comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Statistics. It is available to all students, of all academic backgrounds. Requirements Our Statistics is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 10 sections • 10 lectures • 03:19:00 total length •Introduction to Statistics: 00:19:00 •Measuring Central Tendency: 00:19:00 •Measures of Dispersion: 00:12:00 •Correlation and Regression Analysis: 00:35:00 •Probability: 00:17:00 •Sampling: 00:20:00 •Charts and Graphs: 00:22:00 •Hypothesis Testing: 00:25:00 •Ten Common Statistical Mistakes: 00:30:00 •Assignment - Statistics: 00:00:00

Statistics
Delivered Online On Demand3 hours 19 minutes
£12

Start Your Own Business - Level 2 Certificate

5.0(10)

By Apex Learning

Overview This comprehensive course on Start Your Own Business - Level 2 Certificate will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Start Your Own Business - Level 2 Certificate comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Start Your Own Business - Level 2 Certificate. It is available to all students, of all academic backgrounds. Requirements Our Start Your Own Business - Level 2 Certificate is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 1 sections • 6 lectures • 01:24:00 total length •Prepare to Market Your Business: 00:17:00 •Prepare to Market Your Business: 00:17:00 •Set Up Your Business: 00:11:00 •Run Your Business: 00:20:00 •Your Business Plan: 00:08:00 •Launch Your Business: 00:11:00

Start Your Own Business - Level 2 Certificate
Delivered Online On Demand1 hour 24 minutes
£12

Start A T-Shirt Business

5.0(10)

By Apex Learning

Overview This comprehensive course on Start A T-Shirt Business will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Start A T-Shirt Business comes with accredited certification, which will enhance your CV and make you worthy in the job market.So enrol in this course today to fast track your career ladder. How will I get my certificate? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Start A T-Shirt Business. It is available to all students, of all academic backgrounds. Requirements Our Start A T-Shirt Business is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 12 sections • 61 lectures • 05:07:00 total length •Welcome to the Course!: 00:05:00 •Start A T-Shirt Business | Course Overview: 00:04:00 •Purchasing T-Shirt Designs | Section Overview: 00:02:00 •The Cheapest & Fastest Place to Purchase Shirt Designs!: 00:08:00 •Get Pre-Vetted Freelancers to Create Your Shirt Designs: 00:04:00 •Hold a Contest for Freelancers to Create Your T-Shirt Design: 00:05:00 •How to Create T-Shirt Designs | Section Overview: 00:02:00 •Download This FREE Photo Editor to Create & Edit Designs: 00:04:00 •Get Text & Font For Your DesignsFor Free!: 00:04:00 •My Favorite Place to Get Royalty Free Images: 00:02:00 •Become a Member Here to Access Thousands of Images for Your Designs: 00:03:00 •Create & Export Your First Completed T-Shirt Design!: 00:05:00 •Placeit T-shirt Design Maker | Access 5000+ Design Templates: 00:08:00 •Canva T-shirt Designer | Access T-Shirt Design Templates, Images, Fonts & More!: 00:07:00 •Market Research, Keywords & Trademarks | Section Overview: 00:02:00 •Selecting A Niche | Create Your Niche List: 00:02:00 •Market Research | Check Market Trends & Demand: 00:04:00 •Market Research | What Is Already Selling?: 00:06:00 •Create A Keyword List | Keyword Research for SEO: 00:04:00 •Spy on Your Competitors Keywords | What Is Already Working?: 00:03:00 •How to Search 'Buyer' Keywords from Amazon: 00:02:00 •Trademarks & Copyright Research | Avoid Future Issues: 00:05:00 •Getting Started on Merch by Amazon: 00:02:00 •Merch by Amazon | Platform Overview: 00:04:00 •Applying For Merch by Amazon | Request Invitation: 00:09:00 •Uploading Designs to Merch by Amazon: 00:08:00 •GIMP 2.10 for Merch by Amazon (Updated 2021): 00:09:00 •Tiering Up on Merch by Amazon: 00:10:00 •Getting Started on Teespring | Section Overview: 00:02:00 •Create Your Teespring Account | Signup & Settings: 00:04:00 •Teespring Dashboard | Platform Overview: 00:04:00 •Build Your Teespring Storefront | Banner, Avatar & More: 00:12:00 •Upload Designs to Teespring | Edit Products & Publish Listings: 00:06:00 •6 Ways to Optimize Your Product Listings on Teespring: 00:16:00 •Teespring Analytics Tracking | Connect Google Analytics: 00:06:00 •Teespring Conversion Tracking | Facebook Pixel Example: 00:10:00 •Create Discount Codes | Teespring Promotions: 00:08:00 •Getting Started on Redbubble | Section Overview: 00:02:00 •Build Your Redbubble Shop | Banner, Avatar & Artist Bio: 00:06:00 •Redbubble | Upload Your First Design & Publish Your Product Listing: 00:06:00 •Tags & Keywords | Optimize Your Redbubble Listings: 00:06:00 •Create Collections | Organize Your Redbubble Shop: 00:04:00 •How to Select Default Product Views On Redbubble: 00:07:00 •Redbubble Markups | Edit Your Product Pricing: 00:04:00 •Connect Google Analytics to Redbubble: 00:05:00 •CafePress | Getting Started on CafePress: 00:05:00 •TeePublic | Getting Started on TeePublic: 00:02:00 •Zazzle | Getting Started on Zazzle: 00:03:00 •Spreadshirt | Getting Started on Spreadshirt: 00:03:00 •FunnyShirts | Getting Started on FunnyShirts: 00:03:00 •Free Marketing Strategies | Section Overview: 00:01:00 •Listing Optimization | SEO, Keywords & Quality: 00:01:00 •Facebook Marketing | Strategies to Promote for Free on Facebook: 00:08:00 •Instagram Marketing | Building Your Instagram Brand Page: 00:04:00 •Pinterest Marketing | Marketing Your Brand with Pinterest: 00:03:00 •Paid Promotion Strategies | Section Overview: 00:02:00 •Create Mock-Ups for Your Ads | Get High Quality Photo or Video Mockups: 00:06:00 •Facebook Post Boost | Boost Your Facebook Post to Increase Engagement: 00:04:00 •Facebook Targeted Ads | Custom Audience & Targeted Ads: 00:13:00 •Google Ads | Create Targeted Ads on Google & YouTube: 00:05:00 •Bonus Lecture: 00:03:00

Start A T-Shirt Business
Delivered Online On Demand5 hours 7 minutes
£12

SQL Programming Complete Bundle

5.0(10)

By Apex Learning

Overview Acquire the language of databases with this SQL Programming Complete Bundlecourse. In this data-driven world, data is used to make strategies, find solutions and do a thousand other tasks. Businesses across the world are using big and related data, which makes a basic knowledge of SQL a remarkable skill not only for data scientists but for everyone. This SQL Programming Complete Bundlecourse will teach you the language of databases, SQL, and help you gain proficiency in SQL tools. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this SQL Programming Complete Bundle. It is available to all students, of all academic backgrounds. Requirements Our SQL Programming Complete Bundle is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 9 sections • 53 lectures • 07:50:00 total length •Introduction: 00:04:00 •Course Curriculum Overview: 00:05:00 •Overview of Databases: 00:10:00 •MySQL Installation: 00:16:00 •MySQL Workbench Installation: 00:09:00 •Connecting to MySQL using Console: 00:09:00 •Overview of Challenges: 00:04:00 •SQL Statement Basic: 00:16:00 •SELECT Statement: 00:09:00 •SELECT DISTINCT: 00:05:00 •Column AS Statement: 00:12:00 •COUNT built-in Method usage: 00:11:00 •SELECT WHERE Clause - Part One: 00:05:00 •SELECT WHERE Clause - Part Two: 00:11:00 •SQL Statement Basic: 00:16:00 •SQL Limit Clause Statement: 00:09:00 •SQL Using BETWEEN with Same Column Data: 00:11:00 •How to Apply IN Operator: 00:11:00 •Wildcard Characters with LIKE and ILIKE: 00:11:00 •Overview of GROUP BY: 00:06:00 •Aggregation function SUM(): 00:09:00 •Aggregation MIN() and MAX(): 00:05:00 •GROUP BY - One: 00:09:00 •GROUP BY - Two: 00:12:00 •HAVING Clause: 00:05:00 •Overview of JOINS: 00:04:00 •Introduction to JOINS: 00:04:00 •AS Statement table: 00:03:00 •INNER Joins: 00:14:00 •FULL Outer Join: 00:11:00 •LEFT Outer JOIN: 00:08:00 •RIGHT JOIN: 00:08:00 •Union: 00:07:00 •Timestamps: 00:12:00 •EXTRACT from timestamp: 00:10:00 •Mathematical Functions: 00:12:00 •String Functions: 00:22:00 •SUBQUERY: 00:13:00 •Basic of Database and Tables: 00:06:00 •DataTypes: 00:10:00 •Primarykey and Foreignkey: 00:06:00 •Create Table in SQL Script: 00:13:00 •Insert: 00:11:00 •Update: 00:07:00 •Delete: 00:04:00 •Alter Table: 00:09:00 •Drop Table: 00:05:00 •NOT NULL Constraint: 00:08:00 •UNIQUE Constraint: 00:09:00 •Creating a Database backup: 00:12:00 •10a Overview of Databases and Tables: 00:05:00 •10c Restoring a Database: 00:07:00 •Assignment - SQL Programming Complete Bundle: 00:00:00

SQL Programming Complete Bundle
Delivered Online On Demand7 hours 50 minutes
£12