7912 Courses in Birmingham delivered On Demand

Learn essential skills for teaching Phonics with the Teaching Phonics Level 3 Certification. The teaching method of reading and writing by developing learners' phonemic awareness is known as phonics. The course is designed for the teachers who want to teach phonics to the kids to guide them to read and write. The course starts by explaining the definition of phonics which will be followed by the discussion on English Phonics and the techniques of teaching the phonics named Jollyphonics to the young learners. You will learn how to motivate your students and how to deal with the students with Dyslexia. The course also covers the techniques of teaching phonics to the parents. By the end of the course, you will be able to teach phonics to the kids, other teachers and parents and able to work confidently in the area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Teaching Phonics Level 3 Certification is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Teaching Phonics Level 3 Certification. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Teaching Phonics Level 3 Certification will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Module 01 - Introduction to Phonics Education Introduction to Phonics Education 00:12:00 Module 02 - Role of Early Phonics Teaching Role of Early Phonics Teaching 00:17:00 Module 03 - Career as Phonics Teacher Career as Phonics Teacher 00:09:00 Module 04 - Teaching Phonics Teaching Phonics 00:19:00 Module 05 - Jolly Phonics Jolly Phonics 00:17:00 Module 06 - Involving Parents and Carers Involving Parents and Carers 00:15:00 Module 07 - Speaking and Phonological Awareness Speaking and Phonological Awareness 00:24:00 Module 08 - Systematic Assessment and Record Keeping Systematic Assessment and Record Keeping 00:24:00 Module 09 - Meeting Individual Needs Meeting Individual Needs 00:29:00 Module 10 - Cognitive Approaches in Dyslexia Cognitive Approaches in Dyslexia 00:14:00 Module 11 - Phonics for Deaf Children Phonics for Deaf Children 00:23:00 Module 12 - Teaching Higher Level of Phonics Teaching Higher Level of Phonics 00:13:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Proofreading and Copyediting will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Proofreading and Copyediting will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Proofreading and Copyediting and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Proofreading and Copyediting is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Proofreading and Copyediting. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Proofreading and Copyediting will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Module 01: Proofreading Basics Proofreading Basics 00:25:00 Module 02: Applying The Style Guide Applying The Style Guide 00:20:00 Module 03: Spelling And Grammar Spelling And Grammar 00:15:00 Module 04: Proofreading On Paper Proofreading On Paper 00:25:00 Module 05: Proofreading On-Screen Proofreading On-Screen 01:00:00 Module 06: Copy-Editing Basics Copy-Editing Basics 01:00:00 Module 07: Copy-Editing - The Use Of Language Copy-Editing - The Use Of Language 00:45:00 Module 08: Copy-Editing - Checking Accuracy And Fact Copy-Editing - Checking Accuracy And Facts 00:15:00 Module 09: Copy-Editing - The Beginning And The End Copy-Editing - The Beginning And The End 00:15:00 Module 10: Copy-Editing - Legal Checks Copy-Editing - Legal Checks 00:30:00 Module 11: Finding Work And Developing Your Career Finding Work And Developing Your Career 00:00:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This SEO Optimised Content Writing will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The SEO Optimised Content Writing will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to SEO Optimised Content Writing and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited SEO Optimised Content Writing is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this SEO Optimised Content Writing. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The SEO Optimised Content Writing will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum SEO Optimised Content Writing Module 01: What Is Content Writing? 00:18:00 Module 02: How To Write Saleable Content 00:20:00 Module 03: The Importance of SEO Based Content Writing 00:20:00 Module 04: Basics of SEO 00:30:00 Module 05: Essential SEO Skills for Content Writers 00:20:00 Module 06: How to Engage the Reader? 00:20:00 Module 07: Search Engine Optimization Process 00:30:00 Module 08: Off Page SEO 00:24:00 Module 09: Meta Tags Optimization 00:25:00 Module 10: The Importance of Keyword Research 00:30:00 Module 11: Keyword Strategy 00:25:00 Module 12: How to Make Any Content SEO-Friendly 00:30:00 Module 13: The Process of Good Writing 00:20:00 Module 14: Text Objectives 00:20:00 Module 15: How to Rewrite an Article 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Create Videos, Motion Graphics and Animation Using Canva will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Create Videos, Motion Graphics and Animation Using Canva will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Create Videos, Motion Graphics and Animation Using Canva and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Create Videos, Motion Graphics and Animation Using Canva is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Create Videos, Motion Graphics and Animation Using Canva. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Create Videos, Motion Graphics and Animation Using Canva will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Create Videos, Motion Graphics and Animation Using Canva How to Make Videos on Canva Intro 00:04:00 2023 Additional Updates Canva Video Editor Tutorial for Beginners 2023 00:20:00 17 Canva Video Hacks for Faster Professional Videos 00:23:00 Create Instagram Reels on Canva (Part 1) 00:12:00 Create Instagram Reels on Canva (Part 2) 00:14:00 Start Using the Canva Video Editor How to Use Canva Video Editor (Basic) 00:34:00 How to Add Soundtrack and Audios 00:08:00 How to Make Videos in Canva (Intermediate) 00:39:00 How to Make (Advanced) Videos in Canva 00:30:00 How to Compress Your Videos without Losing Quality (Mobile App) 00:05:00 How to Split Videos on Canva 00:04:00 Final Tasks Video 1 Simple Start 00:01:00 Video 2 Intermediate 00:01:00 Video 3 Advanced 00:01:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Elevate your real estate wholesaling game with this comprehensive masterclass. From property acquisition and analysis to negotiating with sellers and reducing risk, this course is a step-by-step guide to mastering every facet of the wholesaling business.

Our course will guide you to become a great teacher and teach like a champion.

Elevate your brand with compelling copywriting and advertising strategies. Unlock the power of persuasive language and strategic messaging to captivate your audience and drive engagement. From crafting irresistible headlines to creating impactful ad campaigns, discover the art and science of effective communication for business success. Explore proven techniques and expert insights to master the dynamic world of copywriting and advertising. Transform your brand's narrative and leave a lasting impression with our comprehensive guide.

🌟 Unleash the Power of Your Imagination with the Narrative Mastery Certification Course! 🌟 Are you ready to embark on a transformative journey that will elevate your storytelling skills to new heights? Introducing the Narrative Mastery Certification Course - your gateway to becoming a master storyteller!   🚀 Why Choose Narrative Mastery Certification? ✨ Craft Compelling Narratives: Learn the art and science behind creating narratives that captivate, inspire, and resonate with your audience. From gripping beginnings to unforgettable endings, discover the secrets to crafting stories that leave a lasting impact. ✨ Unlock Your Creative Potential: Unleash the power of your imagination! Our course provides a dynamic blend of theory and hands-on exercises designed to fuel your creativity and push the boundaries of your storytelling capabilities. ✨ Versatility Across Mediums: Whether you're a writer, filmmaker, content creator, or business professional, our comprehensive curriculum is tailored to suit various mediums. Adapt your storytelling skills to excel in any platform or industry. ✨ Guidance from Industry Experts: Benefit from the wisdom of seasoned storytellers who have excelled in their respective fields. Gain insights, tips, and tricks that will set you apart and accelerate your journey towards narrative excellence. ✨ Interactive Learning Experience: Engage in interactive sessions, peer reviews, and real-world projects that bring the learning to life. Our community-driven approach ensures you not only learn from the best but also grow alongside a network of like-minded individuals. ✨ Earn Your Narrative Mastery Certification: Upon completion of the course, you'll receive a prestigious certification that validates your expertise in narrative storytelling. Showcase your skills proudly and open doors to new opportunities in your chosen field.   🔥 Don't Miss Out - Join the Narrative Mastery Revolution Today! Invest in your future, invest in your narrative mastery! 🚀📖✨ Course Curriculum Introduction to Storytelling Programme Overview - Storytelling 00:00 Introduction to Story and Storytelling 00:00 Foundations of Practical Storytelling Storytelling Styles 00:00 The Five Natural Storytelling Style 00:00 Understanding Audience 00:00 Deciding Which Story to Tell the Audience 00:00 Core of a Story 00:00 Setting Up Perspective 00:00 The Stories of the Audience's Potential Future 00:00 Scripting a Story The Elements and Structure of Stories 00:00 Step-by-Step Process of Weaving a Story 00:00 Techniques to Create a Breath-taking Plot 00:00 Techniques to Create a Vivid Setting 00:00 Using Anecdote 00:00 Using Analogy and Allegory 00:00 Scenic Details and Narrative Summary 00:00 Techniques to Create Characters 00:00 Storytelling - The Show Time Techniques to Start a Story 00:00 Techniques to Engage the Audience in a Story 00:00 Audience Participation 00:00 Techniques to put twists_ suspense_ and surprises in a story 00:00 Techniques to create and release tension 00:00 The World-building 00:00 Creating body details 00:00 Creating sights_ taste_ and smells in storytelling 00:00 Techniques to add humour 00:00 Making Fun of Yourself 00:00 Techniques to finish a story 00:00 Voice modulation during storytelling 00:00 Body language during storytelling 00:00 Using the Stanislavsky System 00:00 Specialized Storytelling Storytelling with data and statistics 00:00 Storytelling for Influencing People 00:00 Storytelling for Entrepreneurship and Business 00:00 Storytelling for Marketing 00:00 Brand Storytelling 00:00 Storytelling for Kids 00:00 Digital Storytelling 00:00 Visual Storytelling 00:00 Video Storytelling 00:00

Overview Learn about Medical Coding Inpatient Training: DRG-PCS from industry experts and boost your professional skill. This Medical Coding Inpatient Training: DRG-PCS course will enhance your skill and make you ready for the job market. You'll get expert opinions about the best practices and problems of Medical Coding Inpatient Training: DRG-PCS. You'll also gain the skills of Medical Coding Inpatient Training: DRG-PCS to excel in your job and tips to master professional skills in no time.  You'll be connected with the community of Medical Coding Inpatient Training: DRG-PCS professionals and gain first-hand experience of Medical Coding Inpatient Training: DRG-PCS problem-solving. The Medical Coding Inpatient Training: DRG-PCS is self-paced. You can complete your course and submit the written assignment in your suitable schedule. After completing the Medical Coding Inpatient Training: DRG-PCS, you'll be provided with a CPD accredited certificate which will boost your CV and help you get your dream job.  This Medical Coding Inpatient Training: DRG-PCS will provide you with the latest information and updates of Medical Coding Inpatient Training: DRG-PCS. It will keep you one step ahead of others and increase your chances of growth. Why buy this Medical Coding Inpatient Training: DRG-PCS? 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 Medical Coding Inpatient Training: DRG-PCS 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 Medical Coding Inpatient Training: DRG-PCS course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Medical Coding Inpatient Training: DRG-PCS does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Medical Coding Inpatient Training: DRG-PCS 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 As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Medical Coding Inpatient Training: DRG-PCS is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Unit 01: PCS Introduction What is PCS? 00:08:00 PCS Reasons and Modifications 00:07:00 PCS step by step 00:10:00 Quick UNLEARNING before learning IP DRG 00:03:00 Quick Learning 00:06:00 Unit 02: Section Relates to Type of Procedure Character 1 Section Relates to Type of Procedure 00:10:00 Unit 03: Body System Refers to General Body System Character 2 Body System Refers to General Body System 00:10:00 Unit 04: Root Operation Part-1 Root Operations Introduction 00:06:00 ALTERATION 00:03:00 BYPASS 00:03:00 CHANGE 00:03:00 CONTROL 00:02:00 CREATION 00:02:00 DESTRUCTION 00:02:00 DETACHMENT 00:02:00 DILATION 00:03:00 DIVISION 00:01:00 Unit 05: Root Operation Part-2 DRAINAGE 00:02:00 EXCISION 00:03:00 EXTIRPATION 00:01:00 EXTRACTION 00:02:00 FRAGMENTATION 00:01:00 FUSION 00:03:00 INSERTION 00:02:00 INSPECTION 00:02:00 MAP 00:01:00 OCCLUSION 00:01:00 REATTACHMENT 00:02:00 Unit 06: Root Operation Part-3 RELEASE 00:02:00 REMOVAL 00:01:00 REPAIR 00:00:00 REPLACEMENT 00:00:00 REPOSITION 00:02:00 RESECTION 00:02:00 RESTRICTION 00:01:00 REVISION 00:02:00 SUPPLEMENT 00:02:00 TRANSFER 00:01:00 TRANSPLANTATION 00:03:00 Unit 07: Body Part Character 4 Body Part 00:04:00 Unit 08: Approach Open 00:02:00 Percutaneous 00:02:00 Percutaneous Endoscopic 00:02:00 Via Natural or Artificial Opening 00:01:00 Via Natural or Artificial Opening Endoscopic 00:01:00 Via Natural or Artificial Opening with percutaneous endoscopic assistance 00:02:00 External 00:02:00 Unit 09: Device Character 6 Device 00:04:00 Unit 10: Qualifier Character 7 Qualifier 00:02:00 Unit 11: Other PCS Root Operations Obstetrics 00:04:00 Placement 00:04:00 Measurements and Monitoring 00:02:00 Extracorporeal Assistance and Performance 00:04:00 Extracorporeal Therapies 00:03:00 Osteopathic, Other Procedures & Chiropractic 00:04:00 Unit 12: Conclusion 3T Technique 00:02:00 IP DRG PCS 00:01:00 Assignment Assignment - Medical Coding Inpatient Training: DRG-PCS 00:00:00

Immerse yourself in the realm of database administration with the SQL Database Administrator at QLS Level 5 course. Gain mastery over SQL environment setup, statement fundamentals, advanced commands, and database creation. From optimizing queries to managing databases and tables, this course equips you with the skills to excel as a proficient SQL Database Administrator. Learning Outcomes Establish a strong foundation in SQL database administration, covering setup and configuration. Master SQL statement basics, including querying, filtering, and sorting data effectively. Utilize GROUP BY statements for data aggregation and summarization. Navigate the intricacies of table joins to extract meaningful insights from complex datasets. Demonstrate proficiency in advanced SQL commands and statements for enhanced database management. Why choose this SQL Database Administrator at QLS Level 5 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are 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. Who is this SQL Database Administrator at QLS Level 5 course for? Aspiring Database Administrators and SQL Professionals. Software Developers Seeking to Expand Their Database Management Skills. IT Professionals Interested in Database Administration. Data Analysts and Data Engineers Looking to Enhance Their SQL Knowledge Career path SQL Database Administrator - $60,000 to $110,000/year. Database Developer - $70,000 to $120,000/year. Data Engineer - $80,000 to $130,000/year. Database Manager - $90,000 to $150,000/year. Database Architect - $100,000 to $160,000/year Prerequisites This SQL Database Administrator at QLS Level 5 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £115 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Course Introduction Introduction 00:04:00 Course Curriculum Overview 00:05:00 Overview of Databases 00:10:00 SQL Environment Setup MySQL Installation 00:16:00 MySQL Workbench Installation 00:09:00 Connecting to MySQL using Console 00:09:00 SQL Statement Basics 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 GROUP BY Statements 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 JOINS 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 Advanced SQL Commands / Statements Timestamps 00:12:00 EXTRACT from timestamp 00:10:00 Mathematical Functions 00:12:00 String Functions 00:22:00 SUBQUERY 00:13:00 Creating Database and Tables 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 Databases and Tables Creating a Database backup 00:12:00 10a Overview of Databases and Tables 00:05:00 10c Restoring a Database 00:07:00 Assignment Assignment - SQL Database Administrator at QLS Level 5 04:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00