3 Bootcamp courses in Nottingham

C++ Bootcamp is for coding beginners: You want all the basic stuff, all the advanced stuff and practical experience and get a fantastic job in C++

PYTHON BOOTCAMP: This 12-week Python Data Analytics Data Boot Camp is designed to give you a complete skill set required by data analysts . You will be fully fluent and confident as a Python data analyst, with full understanding of Python Programming. From Data, databases, datasets, importing, cleaning, transforming, analysing to visualisation and creating awesome dashboards The course is a practical, instructor-lead program.

Duration 5 Days 30 CPD hours This course is intended for Candidates for this course design, develop, secure, and troubleshoot Power Platform solutions. Candidates implement components of a solution that include application enhancements, custom user experience, system integrations, data conversions, custom process automation, and custom visualizations. Candidates will gain applied knowledge of Power Platform services, including in-depth understanding of capabilities, boundaries, and constraints. Overview After completing this course, students will be able to: Create a technical design Configure Common Data Service Create and configure Power Apps Configure business process automation Extend the user experience Extend the platform Develop Integrations The Microsoft Power Platform helps organizations optimize their operations by simplifying, automating and transforming business tasks and processes. In this course, students will learn how to build Power Apps, Automate Flows and extend the platform to complete business requirements and solve complex business problems. Create a model-driven application in Power Apps This module introduces you to creating a model-driven app in Power Apps that uses Common Data Service. Get started using Common Data Service This module will explain the concepts behind and benefits of Common Data Service. Creating an environment, entities, fields and options sets are also discussed. Create a canvas app in Power Apps This module introduces you to Power Apps, helps you create and customize an app, and then manage and distribute it. It will also show you how to provide the best app navigation, and build the best UI using themes, icons, images, personalization, different form factors, and controls. Automate a business process using Power Automate This module introduces you to Power Automate, teaches you how to build workflows, and how to administer flows. Create a business process flow in Power Automate This module introduces you to creating business process flows in Power Automate Introduction to developing with Power Platform This module is the first step in learning about platform, tools, and the ecosystem of the Power Platform Extending the Power Platform user experience Model Driven apps This module describes how to create client scripting, perform common actions with client script, and automate business process flow with client scrip. Learn about what client script can do, rules, and maintaining scripts. Discover when to use client script as well as when not to use client script. Create components with Power Apps Component Framework This module describes how to get started with Power Apps Component Framework with an introductory module on the core concepts and components. Then it shows you how to build a component and work with advanced Power Apps Component Framework features. Extending the Power Platform Common Data Service This module looks at the tools and resources needed for extending the Power Platform. We'll start with looking at the SDKs, the extensibility model, and event framework. This learning path also covers when to use plug-ins. Configuration of plug-ins as well as registering and deploying plug-ins. Integrate with Power Platform and Common Data Service This module describes how to integrate with Common Data Service using code by learning about Common Data Service API. Get an in-depth overview of options available with Common Data Service to integrate data and events to Azure. Extend Power Apps portals This module describes how to transform a content portal into a full web app interacting with Common Data Service. We will also cover the options available to customizers and developers to extend the portal functionality and integrate with Office 365, Power Platform, and Azure components. Additional course details: Nexus Humans PL-400T00 Microsoft Power Platform Developer training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the PL-400T00 Microsoft Power Platform Developer course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for This course is designed for IT professionals who wish to develop cloud computing skills to enable them to move IT workloads to the cloud and integrate products and services from different providers and industries. Their focus is to ensure that cloud deployments are secure, that automation and orchestration are used effectively to bring business value from the cloud, and that costs are controlled through effective management of cloud vendors. This course is also designed for students who are preparing to take the CompTIA Cloud+ certification exam CV0-003, or who plan to use Cloud+ as the foundation for more advanced cloud certifications or career roles. Overview In this course, you will deploy, test, secure, manage, optimize, and troubleshoot a cloud solution. You will: - Prepare to deploy cloud solutions - Deploy a pilot project - Test a pilot project deployment - Design a secure network for cloud deployment - Determine CPU and memory sizing for cloud deployments - Determine storage requirements for cloud deployments - Plan Identity and Access Management for cloud deployments - Analyze workload characteristics to ensure successful migration to the cloud - Secure systems to meet access requirements - Maintain cloud systems - Implement backup, restore, and business continuity measures - Analyze cloud systems for required performance - Analyze cloud systems for anomalies and growth forecasting - Troubleshoot deployment, capacity, automation, and orchestration issues - Troubleshoot connectivity issues - Troubleshoot security issues In this course, you will learn how to implement, maintain, and deliver cloud technologies including network, storage, and virtualization technologies to create cloud solutions. 1 - PREPARING TO DEPLOY CLOUD SOLUTIONS Describe Interaction of Cloud Components and Services Describe Interaction of Non-cloud Components and Services Evaluate Existing Components and Services for Cloud Deployment Evaluate Automation and Orchestration Options Prepare for Cloud Deployment 2 - DEPLOYING A PILOT PROJECT Manage Change in a Pilot Project Execute Cloud Deployment Workflow Complete Post-Deployment Configuration 3 - TESTING PILOT PROJECT DEPLOYMENTS Identify Cloud Service Components for Testing Test for High Availability and Accessibility Perform Deployment Load Testing Analyze Test Results 4 - DESIGNING A SECURE AND COMPLIANT CLOUD INFRASTRUCTURE Design Cloud Infrastructure for Security Determine Organizational Compliance Needs 5 - DESIGNING AND IMPLEMENTING A SECURE CLOUD ENVIRONMENT Design Virtual Network for Cloud Deployment Determine Network Access Requirements Secure Networks for Cloud Interaction Manage Cloud Component Security Implement Security Technologies 6 - PLANNING IDENTITY AND ACCESS MANAGEMENT FOR CLOUD DEPLOYMENTS Determine Identity Management and Authentication Technologies Plan Account Management Policies for the Network and Systems Control Access to Cloud Objects Provision Accounts 7 - DETERMINING CPU AND MEMORY SIZING FOR CLOUD DEPLOYMENTS Determine CPU Size for Cloud Deployment Determine Memory Size for Cloud Deployment 8 - DETERMINING STORAGE REQUIREMENTS FOR CLOUD DEPLOYMENTS Determine Storage Technology Requirements Select Storage Options for Deployment Determine Storage Access and Provisioning Requirements Determine Storage Security Options 9 - ANALYZING WORKLOAD CHARACTERISTICS TO ENSURE SUCCESSFUL MIGRATION Determine the Type of Cloud Deployment to Perform Manage Virtual Machine and Container Migration Manage Network, Storage, and Data Migration 10 - MAINTAINING CLOUD SYSTEMS Patch Cloud Systems Design and Implement Automation and Orchestration for Maintenance 11 - IMPLEMENTING BACKUP, RESTORE, DISASTER RECOVERY, AND BUSINESS CONTINUITY MEASURES Back Up and Restore Cloud Data Implement Disaster Recovery Plans Implement Business Continuity Plans 12 - ANALYZING CLOUD SYSTEMS FOR PERFORMANCE Monitor Cloud Systems to Measure Performance Optimize Cloud Systems to Meet Performance Criteria 13 - ANALYZING CLOUD SYSTEMS FOR ANOMALIES AND GROWTH FORECASTING Monitor for Anomalies and Resource Needs Plan for Capacity Create Reports on Cloud System Metrics 14 - TROUBLESHOOTING DEPLOYMENT, CAPACITY, AUTOMATION, AND ORCHESTRATION ISSUES Troubleshoot Deployment Issues Troubleshoot Capacity Issues Troubleshoot Automation and Orchestration Issues 15 - TROUBLESHOOTING CONNECTIVITY ISSUES Identify Connectivity Issues Troubleshoot Connectivity Issues 16 - TROUBLESHOOTING SECURITY ISSUES Troubleshoot Identity and Access Issues Troubleshoot Attacks Troubleshoot Other Security Issues Additional course details: Nexus Humans CompTIA Cloud Plus Certification (Exam CV0-003) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the CompTIA Cloud Plus Certification (Exam CV0-003) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

The Forensic Analysis Bootcamp is an 8-week deep-dive into forensic equity analysis, featuring a 90-minute Zoom workshop each week. The content includes extensive use of real-life case studies and covers stocks spanning a wide range of sectors and regions. You will learn how companies manipulate expenses and inflate profits, how to spot balance sheet issues, weaknesses of the cash flow statement and issues and more.

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified IT Support Technical Skills Bootcamp bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 40 course mega bundle that will exceed your expectations within your budget. The IT Support Technical Skills Bootcamp related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive IT Support Technical Skills Bootcamp bundle will help you build a solid foundation to become a proficient worker in the sector. This IT Support Technical Skills Bootcamp Bundle consists of the following 30 CPD Accredited Premium courses - Course 01 :IT Support Technician Course 02 :Network Security and Risk Management Course 03 :CompTIA Network Course 04 :Information Management Course 05 :Web Application Penetration Testing Course Course 06 :CompTIA Cloud+ (CV0-002) Course 07 :Learn Ethical Hacking with Kali Linux Course 08 :Web Design (HTML, CSS, Bootstrap) Complete Course Course 09 :Python Course Course 10 :JavaScript Course 11 :ASP.Net MVC and Entity Framework Course Course 12 :Learn Spring & Angular Material with a Full Web Application Course 13 :Typescript Course 14 :U&P AI - Natural Language Processing (NLP) with Python Course 15 :Ruby on Rails Web Application Framework Course 16 :Data Science and Visualisation with Machine Learning Course 17 :SQL For Data Analytics & Database Development Course 18 :PLC Programming Diploma Course 19 :Cisco ASA Firewall Training Course Course 20 :Create Your First Responsive Website Course 21 :C# (C-Sharp) Course 22 :Computer Operating System and Troubleshooting Course 23 :Building Your Own Computer Course Course 24 :It: Ethical Hacking, IT Security and IT Cyber Attacking Course 25: SQL Database Administrator Course 26: MS Word Essentials - The Complete Word Course - Level 3 Course 27: Data Protection (GDPR) Practitioner Course 28: Website Hacking From Scratch Course 29: Diploma in Front-End Web Development (HTML, CSS, & Bootstrap) Course 30: SQL Server 101 : Microsoft SQL Server for Absolute Beginners 10 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01 :Career Development Plan Fundamentals Course 02 :CV Writing and Job Searching Course 03 :Interview Skills: Ace the Interview Course 04 :Video Job Interview for Job Seekers Course 05 :Create a Professional LinkedIn Profile Course 06 :Business English Perfection Course Course 07 :Networking Skills for Personal Success Course 08 :Boost Your Confidence and Self-Esteem Course 09 :Public Speaking Training Course 10 :Learn to Fight Procrastination Learning Outcome This tailor-made IT Support Technical Skills Bootcamp bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This IT Support Technical Skills Bootcamp Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the IT Support Technical Skills Bootcamp bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in IT Support Technical Skills Bootcamp Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

***24 Hour Limited Time Flash Sale*** IT Support Technical Skills Bootcamp Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter As digital transformation accelerates, demand for qualified IT support technicians surges in the UK. The IT industry is booming, with an expected growth of 12% by 2027, creating over 1 million new jobs. Do you have an interest in maintaining networks, securing systems, and providing technical support? This IT Support Technical Skills Bootcamp bundle delivers the well-rounded expertise today's IT teams need. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our IT Support Technical Skills Bootcamp bundle is a comprehensive programme that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in IT Support Technical Skills Bootcamp Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this IT Support Technical Skills Bootcamp Career Bundle: Course 01: Advanced Diploma in IT Support Technician at QLS Level 7 Course 02: Network Security and Risk Management Course 03: CompTIA Network Course 04: Information Management Course 05: Web Application Penetration Testing Course Course 06: CompTIA Cloud+ (CV0-002) Course 07: ASP.Net MVC and Entity Framework Course Course 08: Computer Operating System and Troubleshooting Course 09: PLC Programming Diploma Course 10: Learn Spring & Angular Material with a Full Web Application Course 11: SQL Server 101: Microsoft SQL Server for Absolute Beginners Course 12: JavaScript Course 13: Python Course Course 14: Learn Ethical Hacking with Kali Linux Course 15: Building Your Own Computer Course Course 16: Ruby on Rails Web Application Framework Course 17: Create Your First Responsive Website Course 18: Data Science and Visualisation with Machine Learning Course 19: Cisco ASA Firewall Training Course Course 20: SQL For Data Analytics & Database Development Course 21: TypescriptU&P AI - Natural Language Processing (NLP) with Python Course 22:C# (C-Sharp) Course 23:MS Word Essentials - The Complete Word Course - Level 3 Course 24: Web Design (HTML, CSS, Bootstrap) Complete Course Course 25: Website Hacking From Scratch Course 26: Diploma in Front-End Web Development (HTML, CSS, & Bootstrap) Course 27: Data Protection (GDPR) Practitioner Course 28: SQL Database Administrator Course 29: Cisco ASA Firewall Training Course Course 30: IT: Ethical Hacking & IT Security With IT Support Technical Skills Bootcamp, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. Learning Outcomes of IT Support Technical Skills Diagnose and troubleshoot IT hardware and software issues. Implement network security best practices and manage risks. Gain industry-recognized CompTIA certifications. Develop web applications using popular frameworks and languages. Automate tasks with scripting and programming skills. Build a strong foundation for further specialization in IT. Enrol in IT Support Technical Skills Bootcamp today and take the first step towards achieving your goals and dreams. Why buy this IT Support Technical Skills Bootcamp? Get a Free CPD Accredited Certificate upon completion of the course Get a free student ID card with this training program The course is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Lifetime access to the course materials The training program comes with 24/7 tutor support Start your learning journey straightaway with our IT Support Technical Skills Bootcamp Training! IT Support Technical Skills Bootcamp premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of IT Support Technical Skills Bootcamp is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the IT Support Technical Skills Bootcamp course. After passing the course exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 480 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This IT Support Technical Skills Bootcamp course is ideal for: Students seeking mastery in IT Support Technical Skills Bootcamp Professionals seeking to enhance IT Support Technical Skills Bootcamp skills Individuals looking for an IT Support Technical Skills Bootcamp-related career. Requirements This IT Support Technical Skills Bootcamp doesn't require prior experience and is suitable for diverse learners. Career path This IT Support Technical Skills Bootcamp bundle will allow you to kickstart or take your career in the related sector to the next stage. IT Support Specialist Network Administrator Cloud Engineer Web Developer Security Analyst Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Raspberry Pi Bootcamp Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Raspberry Pi Bootcamp Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Raspberry Pi Bootcamp Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Raspberry Pi Bootcamp Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Raspberry Pi Bootcamp? 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 Raspberry Pi Bootcamp 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 Raspberry Pi Bootcamp 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 Raspberry Pi Bootcamp does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Raspberry Pi Bootcamp 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 Raspberry Pi Bootcamp is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum The Complete Raspberry Pi Bootcamp 1 Introduction 00:01:00 2 Basic Input and Output using Console Methods 00:10:00 3 Create Your First App 00:07:00 4 Coding Your First App 00:09:00 5 String Args Part1 00:08:00 6 Syntax Basics 00:06:00 7 Data Types 00:10:00 8 Type Conversion 00:08:00 9 Operators 00:14:00 10 Operator Example 00:08:00 11 example my age 00:08:00 12 Decision Making using If statement 00:05:00 13 If else and nested if statements 00:10:00 14 SwitchCase 00:10:00 15 While and do While Loops 00:12:00 16 For Loop 00:07:00 17 Download and Install 00:04:00 Assignment Assignment - Raspberry Pi Bootcamp 00:00:00

Overview This The Complete SQL : Bootcamp course will unlock your full potential and will show you how to excel in a career in The Complete SQL : Bootcamp. So upskill now and reach your full potential. Everything you need to get started in The Complete SQL : Bootcamp is available in this course. Learning and progressing are the hallmarks of personal development. This The Complete SQL : Bootcamp will quickly teach you the must-have skills needed to start in the relevant industry. In This The Complete SQL : Bootcamp Course, You Will: Learn strategies to boost your workplace efficiency. Hone your The Complete SQL : Bootcamp skills to help you advance your career. Acquire a comprehensive understanding of various The Complete SQL : Bootcamp topics and tips from industry experts. Learn in-demand The Complete SQL : Bootcamp skills that are in high demand among UK employers, which will help you to kickstart your career. This The Complete SQL : Bootcamp course covers everything you must know to stand against the tough competition in the The Complete SQL : Bootcamp field.  The future is truly yours to seize with this The Complete SQL : Bootcamp. Enrol today and complete the course to achieve a The Complete SQL : Bootcamp certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the The Complete SQL : Bootcamp course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the The Complete SQL : Bootcamp course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the The Complete SQL : Bootcamp course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This The Complete SQL : Bootcamp is suitable for anyone aspiring to start a career in The Complete SQL : Bootcamp; even if you are new to this and have no prior knowledge on The Complete SQL : Bootcamp, this course is going to be very easy for you to understand.  And if you are already working in the The Complete SQL : Bootcamp field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this The Complete SQL : Bootcamp course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This The Complete SQL : Bootcamp course has no prerequisite.  You don't need any educational qualification or experience to enrol in the The Complete SQL : Bootcamp course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online The Complete SQL : Bootcamp course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Course Introduction Introduction 00:04:00 Course Curriculum overview 00:04:00 Overview of Databases 00:08:00 SQL Environment Setup PostgreSQL Installation 00:13:00 Connecting to PostgreSQL using psql 00:04:00 Connecting to PostgreSQL using PgAdmin 00:07:00 Creating Database and Tables Basic of Database and Tables 00:06:00 Data Types 00:07:00 Primary Keys and Foreign Keys 00:04:00 Create Table in SQL Script 00:17:00 Insert 00:05:00 Update 00:05:00 Delete 00:03:00 Alter Table 00:05:00 Drop Table 00:02:00 Check Constraint 00:12:00 NOT NULL Constraint 00:04:00 UNIQUE Constraint 00:06:00 SQL Statement Basics Overview of Challenges 00:04:00 SQL Statement Basic 00:07:00 SELECT Statement 00:12:00 SELECT DISTINCT 00:10:00 Column AS Statement 00:07:00 COUNT 00:07:00 SELECT WHERE Clause - One 00:06:00 SELECT WHERE Clause - Two 00:11:00 ORDER 00:05:00 LIMIT 00:04:00 BETWEEN keyword usage on real time 00:08:00 IN Operator 00:06:00 LIKE and ILIKE 00:10:00 GROUP BY Statements Overview of GROUP BY 00:03:00 Aggregation Function 00:12:00 GROUP BY - One 00:05:00 GROUP BY - Two 00:06:00 HAVING on SQL Statement 00:04:00 JOINS Overview of JOINS 00:07:00 Introduction to JOINS 00:06:00 AS Statement table 00:05:00 INNER Joins 00:14:00 Full Outer Joins 00:04:00 Left Outer join 00:03:00 Right Outer Join 00:05:00 Union 00:05:00 Advanced SQL Commands Basic of Advanced SQL Commands 00:04:00 Timestamps 00:17:00 Extract from Timestamp 00:05:00 Mathematical Functions 00:06:00 String Functions 00:16:00 SubQuery 00:08:00 Databases and Tables Overview of Databases and Tables 00:02:00 Creating a Database backup 00:03:00 Restoring a Database from backup 00:04:00 Mock Exam Mock Exam - The Complete SQL from Scratch: Bootcamp 00:20:00 Final Exam Final Exam - The Complete SQL from Scratch: Bootcamp 00:20:00