840 Numbers courses delivered Online

Are you looking to enhance your Python Programming skills? If yes, then you have come to the right place. Our comprehensive course on Python Programming will assist you in producing the best possible outcome by mastering the Python Programming skills. The Python Programming course is for those who want to be successful. In the Python Programming course, you will learn the essential knowledge needed to become well versed in Python Programming. Our Python Programming course starts with the basics of Python Programming and gradually progresses towards advanced topics. Therefore, each lesson of this Python Programming course is intuitive and easy to understand. Why would you choose the Python Programming course from Compliance Central: Lifetime access to Python Programming course materials Full tutor support is available from Monday to Friday with the Python Programming course Learn Python Programming skills at your own pace from the comfort of your home Gain a complete understanding of Python Programming course Accessible, informative Python Programming learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Python Programming bundle Study Python Programming in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Python Programming Course Improve your chance of gaining in demand skills and better earning potential by completing the Python Programming Python Programming Curriculum Breakdown of the Python Programming Course Unit 01: Course Overview and Downloads Unit 02: Python Setup Unit 03: Strings and Variables Unit 04: Numbers and Math Unit 05: Booleans and Conditionals Unit 06: Functions Unit 07: Lists Unit 08: Dictionaries Unit 09: Tuples Unit 10: Files Unit 11: Modules CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Python Programming course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Python Programming. It is also great for professionals who are already working in Python Programming and want to get promoted at work. Requirements To enrol in this Python Programming course, all you need is a basic understanding of the English Language and an internet connection. Career path The Python Programming course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Python Programming. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Overview Gain efficient budget analysis skills and enhance the financial processing of your business by taking the all-inclusive Budget Analysis and Financial Reports Diploma course.This Budget Analysis and Financial Reports Diploma course aims to provide you with all the in-demand skills of a finance manager to make you an expert in budget analysis and financial reports. You'll learn about finance and budget planning fundamentals, comparing investment opportunities, ISO 9001:2008, and many more. By completing the expert-instructed course, you'll gain excellence in managing and monitoring budget reports, taking with you top budget approving tactics. Expand your business with no financial issues by enrolling today! 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 Budget Analysis and Financial Reports Diploma. It is available to all students, of all academic backgrounds. Requirements Our Budget Analysis and Financial Reports Diploma 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 3 sections • 23 lectures • 10:00:00 total length •Module One - Getting Started: 00:15:00 •Module Two - Glossary: 00:30:00 •Module Three - Understanding Financial Statements: 00:30:00 •Module Four - Analyzing Financial Statements (I): 01:00:00 •Module Five - Analyzing Financial Statements (II): 00:30:00 •Module Six - Understanding Budgets: 00:30:00 •Module Seven - Budgeting Made Easy: 00:30:00 •Module Eight - Advanced Forecasting Techniques: 00:30:00 •Module Nine - Managing the Budget: 00:30:00 •Module Ten - Making Smart Purchasing Decisions: 01:00:00 •Module Eleven - A Glimpse into the Legal World: 01:00:00 •Finance Jeopardy: 00:15:00 •The Fundamentals of Finance: 00:15:00 •The Basics of Budgeting: 00:15:00 •Parts of a Budget: 00:15:00 •The Budgeting Process: 00:15:00 •Budgeting Tips and Tricks: 00:15:00 •Monitoring and Managing Budgets: 00:15:00 •Crunching the Numbers: 00:15:00 •Getting Your Budget Approved: 00:15:00 •Comparing Investment Opportunities: 00:15:00 •ISO 9001:2008: 00:15:00 •Directing the Peerless Data Corporation: 00:30:00

Description: Budgets help organizations make financial plans and understand where money needs to be spent. It is a necessary skill all managers must possess in today's business world. Now with the help of this Budgets and Money Management Diploma Level 3 course, you can develop said skills. Through this course, you will be able to understand the fundamentals of finance and build a strong base. This is achieved by studying financial terminology, budgets of different types and sizes, budget approval process, ratio analysis and financial decisions. So get this course to learn all of these and keep your team out of the red. Learning Outcomes: Provide a definition of financial terminology Make a budget of any kind or size Have your budget approved Execute fundamental ratio analysis Take smarter financial decisions Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Budgets and Money Management Diploma Level 3 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 Budgets and Money Management Diploma Level 3 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. Modules Course Overview 00:15:00 Finance Jeopardy 00:15:00 The Fundamentals of Finance 00:15:00 The Basics of Budgeting 00:15:00 Parts of a Budget 00:15:00 The Budgeting Process 00:30:00 Budgeting Tips and Tricks 00:15:00 Monitoring and Managing Budgets 00:15:00 Crunching the Numbers 00:15:00 Getting Your Budget Approved 00:15:00 Comparing Investment Opportunities 00:15:00 ISO 9001:2008 00:15:00 Directing the Peerless Data Corporation 00:30:00 Mock Exam Mock Exam- Budgets and Money Management Diploma Level 3 00:20:00 Final Exam Final Exam- Budgets and Money Management Diploma Level 3 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview This comprehensive course on QuickBooks Desktop: 25 Must-Know Tips will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This QuickBooks Desktop: 25 Must-Know Tips 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 QuickBooks Desktop: 25 Must-Know Tips. It is available to all students, of all academic backgrounds. Requirements Our QuickBooks Desktop: 25 Must-Know Tips 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 • 25 lectures • 02:04:00 total length •Chart of Accounts: 00:05:00 •Adding a bank account: 00:01:00 •Adding a credit card account: 00:02:00 •Adding Account Numbers: 00:04:00 •Merging Accounts: 00:03:00 •Subaccounts: 00:03:00 •Show Balances: 00:02:00 •Adding Items: 00:06:00 •Turning on Inventory: 00:05:00 •Adding Vendors: 00:05:00 •Adding Customers: 00:05:00 •Adding Employees: 00:06:00 •Adding Mileage: 00:03:00 •The AR cycle: 00:16:00 •Estimate: 00:02:00 •Sales Tax: 00:07:00 •Applying A Credit: 00:03:00 •The AP Cycle: 00:06:00 •Purchase Order: 00:07:00 •Memorized Transactions: 00:03:00 •Adding manual Entries: 00:02:00 •Setting Up 1099's: 00:05:00 •Reports: 00:09:00 •Customizing Reports: 00:05:00 •Setting Passwords and Adding Users: 00:09:00

Face to face training customised and bespoke. Online or Face to Face

Start your career as a Data Analyst and earn upto £35,000/ Month Have you ever imagined commanding a six-figure salary with the power of Python? Welcome to the "Data Analyst with Python - Job Ready Program with Career Support", where the world of big data is at your fingertips, and the only limit is your own curiosity. Explore the revolutionary journey that is geared towards turning raw data into insightful decisions. Our comprehensive program paves the way to becoming a sought-after Data Analyst, unlocking the door to a thriving career field as Python continues to spearhead the data revolution. Our mission is simple - to be your trusted partner every step of the way, from training to employment. In addition to teaching you the technical skills you need, we will also provide you with career mentoring and support. We will help you build your resume, prepare for interviews, and land your dream job. We also have partnerships with many companies that are hiring Data Analysts with Python expertise, so we can help you get your foot in the door. If you are not happy with our service, we also offer a 100% money-back guarantee. So what are you waiting for? Enrol in our Data Analyst with Python - Job Ready Program today and start your journey to becoming a successful Data Analyst! Why Choose Us? So, what sets us apart from other programs? Let's dive into the exceptional benefits you'll experience when you join our Data Analyst with Python Job Ready Program: Personalised Guidance: Our experienced mentors will provide one-on-one counselling sessions tailored to your specific needs. Whether you're a beginner or have some experience, we will guide you towards honing your skills and developing a strong foundation in Data Analysis with Python. One-On-One Consultation Sessions with Experts: Gain invaluable insights and guidance from seasoned professionals who have thrived in the Data Analyst field. Our consultation sessions provide you with insider tips, tricks, and advice, empowering you to navigate the industry with confidence and expertise. Extensive Job Opportunities: We have established partnerships with numerous companies actively seeking IT Helpdesk Support. Through our network, we'll connect you with exclusive job openings that are not easily accessible elsewhere. Interview Preparation: We provide you with access to a comprehensive database of potential interview questions curated over years of industry experience. Walk into your interviews confident, well-prepared, and ready to impress. Money-Back Guarantee: Your satisfaction is our top priority. We are confident in the quality of our training and support, which is why we offer a 100% money-back guarantee. Continuous Career Support: Our commitment doesn't end when you secure a job. We'll be there for you throughout your career journey, offering continued support and guidance. . If you have any questions, you can contact us. We will be happy to provide you with all the information you need. Here are the courses we will provide once you enrol in the program: Course 01: Business and Data Analytics for Beginners Course 02: Quick Data Science Approach from Scratch Course 03: Learn MySQL from Scratch for Data Science and Analytics Course 04: SQL for Data Science, Data Analytics and Data Visualization Course 05: Statistics & Probability for Data Science & Machine Learning Course 06: R Programming for Data Science Course 07: Python Data Science with Numpy, Pandas and Matplotlib Course 08: Complete Python Machine Learning & Data Science Fundamentals Course 09: 2021 Data Science & Machine Learning with R from A-Z Course 10: Python from Scratch Course 11: Level 2 Python Course Course 12: Machine Learning for Predictive Maps in Python and Leaflet Course 13: Python Programming Bible | Networking, GUI, Email, XML, CGI Course 14: Python for Spatial Analysis in ArcGIS Course 15: Ultimate Python Training for Beginners Course 16: Python Level 1 Crash Course Course 17: Python Programming from Scratch with My SQL Database These courses will help you to develop your knowledge and skills to become a successful Data Analyst. How Can We Offer Job Guarantees? HF Online provides consultancy, professional and educational services to many of the companies in the UK. During our intense exclusive training program, you will not just gain and complete the industry valuable certification but will gain industry experience as well, which is imperative to get your 1st job in the sector. The Data Analyst with Python Program is completed in 9 easy steps: Step 1: Enrol in the Programme Begin your exciting journey with us by enrolling in the Data Analyst with Python program. Complete your registration and make a secure online payment. Remember, we offer a 14-day money-back guarantee if you're not completely satisfied. After you enrol in the Program, you will get lifetime access to 17 premium courses related to Data Analysis with Python. These courses will teach you the knowledge and skills required to become a successful Data Analyst with Python Programmer. Our customer service team will help you and keep in contact with you every step of the way. So you won't have to worry about a thing! Step 2: Initial One-On-One Counselling Session Once enrolled, you will be paired with a dedicated career mentor. Schedule your first one-on-one session to discuss your career aspirations, skills, experience, and any areas for potential growth. This conversation will shape your learning and development path. Step 3: Certification upon Course Completion After learning from the courses, you must obtain certificates for each course. There will be exams for every course, and you have to pass them to get your certificate. To pass successfully, you must get 90% marks. Once you pass the exams, you will receive hardcopy certificates. These certificates will prove that you're an expert in the subject. Step 4: CV Revamping Our team of professionals will build you a compelling CV and LinkedIn profile. We'll ensure it presents your skills and qualifications effectively and is tailored to the needs and expectations of the Finance industry. With these powerful tools in hand, you'll be fully prepared to tackle job interviews confidently. Step 5: Building Network and Submitting CV We understand the power of casting a wide net. We'll strategically submit your CV to various platforms and networks, expanding your reach and connecting you with valuable opportunities that align with your career goals. We will also make connections with many high-profile individuals and companies through your LinkedIn profile. Step 6: Interview Preparation With your CV ready, we'll move on to interview preparation. Gain exclusive access to our database of potential interview questions. Through simulated interviews with your mentor, you'll practice your responses and receive valuable feedback to further refine your skills. Step 7: Securing Job Interviews Leveraging our partnerships with leading companies, we'll secure job interviews for you. We'll ensure you get the opportunity to showcase your skills to potential employers and get the dream job you want. Step 8: Post-Interview Support Post-interview, we'll provide a debriefing session to reflect on your performance and identify areas of improvement for future interviews if necessary. Remember, our commitment extends until you land your dream job. Step 9: Celebrate Your New Job! Once you've secured your dream job in Data Analysis with Python, it's time to celebrate! However, our support doesn't end there. We'll provide you with ongoing career advice to ensure you continue to thrive in your new role. We're excited to accompany you on this journey to success. Enrol today, and let's get started! Your path to a successful career in Data Analysis with Python begins with us. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is tailored to suit a broad spectrum of learners, including: Aspiring Data Analysts who want to launch a new career in data analytics. Current analysts or professionals from similar fields looking to hone their Python skills and modernise their toolset. Business and IT students or recent graduates desiring a competitive edge in the job market. Career shifters interested in a more dynamic and high-paying field. Any individual who loves working with numbers, solving problems, and has a curiosity for uncovering insights in data. Requirements No experience required. Just enrol & start learning. Career path Data Analyst: £27,000 - £60,000 Senior Data Analyst: £40,000 - £75,000 Data Scientist: £50,000 - £100,000 Data Engineer: £45,000 - £90,000 Analytics Manager: £60,000 - £120,000 Director of Data Science: £90,000 - £150,000 Certificates CPD Accredited e-Certificate Digital certificate - Included CPD Accredited Framed (Hardcopy) Certificate Hard copy certificate - Included Enrolment Letter Digital certificate - Included QLS Endorsed Hard Copy Certificate Hard copy certificate - Included Student ID Card Digital certificate - Included

Description:  Microsoft Project 2007 is developed to help in creating budgets based on assignment work and resource rates. Through this course, you will learn the necessary skills, knowledge, and information about the Microsoft Project 2007 Essential and why Project is the world's premier spreadsheet software. You will learn how to use Project in analysing numbers, keeping track of data, and presenting your information graphically which will make your job easier. Who is the course for? Professionals who want to learn about the Microsoft Project 2007 People who have an interest in the basics and features of the Project 2007 Entry Requirement: This course is available to all learners, of all academic backgrounds. However, an education and experience in accounting is an advantage. 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 hardcopy 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 hardcopy 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 recognised 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 Microsoft Project 2007 for Beginners course would be beneficial for you to become: Project Director Project Manager Project Management Officer Project Assistant. Microsoft Project 2007 for Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing Project 01:00:00 Module Three - Your First Project 01:00:00 Module Four - Adding Tasks 01:00:00 Module Five - Advanced Task Operations 01:00:00 Module Six - Scheduling your Tasks 01:00:00 Module Seven - Adding Resources 01:00:00 Module Eight - Assigning Resources 01:00:00 Module Nine - Customizing Your Project View 01:00:00 Module Ten - Creating Project Reports 01:00:00 Module Eleven - Finishing Your Project 01:00:00 Module Twelve - Wrapping Up 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Consultants have seen a sudden rise in their business due to the constant changes in the business world. They usually specialize in one field and help other businesses grow into that. Obviously, there is more to that and if you want to find out what, you can do so with this Business Consulting Certificate Course course. This course will help you understand what is meant by consultants and explain their everyday role in today's business world. It further helps you identify consulting opportunities, create strategies, utilize social media and so much more. So getting this course will certainly help with your desires. Learning Outcomes: Allot a definition of the term 'consultants' as well as clarify their role for the current business world Recognise consulting opportunities Promote a business formula including a business plan, budget, marketing vision, fee structure, and above all resources, Exploit social media and networking abilities to boost your consulting business Preserve your work with contracts Find out means to get to the top of trends as well as changes Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Business Consulting Certificate Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Business Consulting Certificate Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Business Consulting Certificate Course Course Overview 00:05:00 What It's All About 00:15:00 Business Building Blocks 00:30:00 Crunching the Numbers 00:30:00 Planning Your Business 00:30:00 Creating a Sales and Marketing Strategy 00:30:00 Getting the Work Done 00:30:00 Mock Exam Mock Exam- Business Consulting Certificate Course 00:20:00 Final Exam Final Exam- Business Consulting Certificate Course 00:20:00

British Sign Language (BSL) Do you want to master an interpreter course to achieve a handsome job for a better career? Come enrol our interpreter course for a broad interpreter introduction. This interpreter course helps to develop language skills. You will gain mastery over interpreting modes and methods through the interpreter course. Our interpreter course covers cultural competency and sensitivity. Specific interpreting abilities are taught in the interpreter course. The interpreter course will teach you how to apply ethnology in interpretation. Professional growth and ethics are aided by this interpreter course. If you want to meet your requirements you must take the interpreter course assistance! Industry Experts Designed this British Sign Language course into 15 detailed modules. Course Curriculum of (BSL) British Sign Language Course Module 1: Introduction to BSL Module 2: Fingerspelling Module 3: Basic Vocabulary and Phrases Module 4: Numbers Module 5: Family and Relationships Module 6: Colours, Animals, and Food Module 7: Advanced Vocabulary Module 8: Grammar and Syntax Module 9: Conversational Skills Module 10: Deaf Culture Module 11: Storytelling and Narration Module 12: Poetry and Literature Module 13: Regional Variations Module 14: Interpreting Module 15: Legal and Medical Sign Language Course Curriculum of Interpreter: Interpreter Course Module 01: Introduction to Interpreting Module 02: Language Skills Mastery Module 03: Interpreting Techniques and Modes Module 04: Cultural Competence and Sensitivity Module 05: Specialized Interpreting Skills Module 06: Technology in Interpreting Module 07: Professional Development and Ethics Who is this course for? Interpreter Online Training Professionals, students, career changers, and beginners in interpreting can all benefit from this interpreter course. Career path Interpreter Online Training Following your completion of the interpreter course, you might choose to work as an educator, researcher, or interpreter specialist.

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction Course Overview! 00:04:00 Installation And Getting Started The Final Milestone! 00:01:00 Installing and setting up PostgreSQL 00:09:00 Case Study : Demo Case Study Part 1 00:04:00 Case Study Part 2 00:06:00 Fundamental SQL statements CREATE 00:11:00 Exercise 1: Create DB and Table 00:01:00 INSERT 00:09:00 Import data from File 00:05:00 Exercise 2: Inserting and Importing 00:01:00 SELECT statement 00:03:00 SELECT DISTINCT 00:06:00 WHERE 00:04:00 Logical Operators 00:06:00 Exercise 3: SELECT & WHERE 00:01:00 UPDATE 00:05:00 DELETE 00:04:00 ALTER 00:17:00 Exercise 4: Updating Table 00:01:00 Restore And Back-Up Restore and Back-up 00:07:00 Exercise 5: Restore and Back-up 00:01:00 Selection Commands: Filtering IN 00:04:00 BETWEEN 00:05:00 LIKE 00:08:00 Exercise 6: In, Like & Between 00:01:00 Selection Commands: Ordering Side Lecture: Commenting in SQL 00:01:00 ORDER BY 00:07:00 LIMIT 00:03:00 Exercise 7: Sorting 00:01:00 Alias AS 00:03:00 Aggregate Commands COUNT 00:05:00 SUM 00:03:00 AVERAGE 00:03:00 MIN & MAX 00:04:00 Exercise 8: Aggregate functions 00:01:00 Group By Commands GROUP BY 00:12:00 HAVING 00:05:00 Exercise 9: Group By 00:01:00 Conditional Statement CASE WHEN 00:05:00 Joins Introduction to Joins 00:02:00 Inner Join 00:08:00 Left Join 00:07:00 Right Join 00:06:00 Full Outer Join 00:05:00 Cross Join 00:04:00 Except 00:03:00 Union 00:03:00 Exercise 10: Joins 00:01:00 Subqueries Subqueries 00:14:00 Exercise 11: Subqueries 00:01:00 Views And Indexes VIEWS 00:07:00 INDEX 00:06:00 Exercise 12: Views 00:01:00 String Functions LENGTH 00:03:00 Upper Lower 00:02:00 REPLACE 00:04:00 TRIM, LTRIM, RTRIM 00:07:00 CONCATENATION 00:03:00 SUBSTRING 00:06:00 LIST AGGREGATION 00:05:00 Exercise 13: String Functions 00:02:00 Mathematical Functions CEIL & FLOOR 00:03:00 RANDOM 00:05:00 SETSEED 00:04:00 ROUND 00:02:00 POWER 00:02:00 Exercise 14: Mathematical Functions 00:01:00 Date-Time Functions CURRENT DATE & TIME 00:04:00 AGE 00:03:00 EXTRACT 00:08:00 Exercise 15: Date-time functions 00:01:00 Pattern (String) Matching PATTERN MATCHING BASICS 00:07:00 ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS) 00:15:00 Exercise 16: Pattern Matching 00:01:00 Data Type Conversion Functions Converting Numbers/ Date to String 00:11:00 Converting String to Numbers/ Date 00:06:00 User Access Control Functions User Access Control 00:13:00 Bonus Section: Nail That Interview! Tablespace 00:05:00 PRIMARY KEY & FOREIGN KEY 00:05:00 ACID compliance 00:06:00 Truncate 00:04:00 Performance Tuning Tips TIP 1 (EXPLAIN) 00:04:00 TIP 2 00:01:00 TIP 3 00:02:00 TIP 4 (VACCUM) 00:01:00 TIP 5 00:02:00 TIP 6 (STRING FUNCTIONS) 00:02:00 TIP 7 (JOINS) 00:02:00 TIP 8 (SCHEMAS) 00:04:00 Bonus Section : Database Basics What is SQL 00:02:00 Tables and DBMS 00:03:00 Types of SQL commands 00:04:00 PostgreSQL 00:02:00 The Final Milestone! 00:01:00 Supplementary Resources Supplementary Resources - SQL Masterclass 00:00:00 Assessment Assessment - SQL Masterclass 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00