2358 Microsoft courses in Tring delivered On Demand

Course Overview: Imagine the power of interacting with databases, organising vast information, and extracting valuable insights - all at your fingertips. This might seem like a formidable task, but SQL, or Structured Query Language, brings this within reach. It is one of the most in-demand skills in the tech industry, with a projected 10% job growth rate over the next decade. Our course, The Complete SQL from Scratch: Bootcamp, provides a thorough understanding of SQL, irrespective of your prior familiarity with it. This comprehensive course walks you through the journey from the fundamentals of databases to the intricate functionalities of SQL. The curriculum includes detailed discussions on database creation, table manipulation, SQL statements, and utilisation of various operators. Moreover, it also covers essential operations like data backup and restoration, thus preparing learners for real-life database management scenarios. The course design ensures a smooth transition from one concept to another, enabling learners to solidify their understanding at each step. Enrol today and start learning SQL! Key Features of the Course: CPD certificate: Upon completion of the course, you'll receive a CPD certificate that you can use to demonstrate your skills to employers. 24/7 Learning Assistance: Our team of experts is available 24/7 to answer your questions and help you progress through the course. Interesting learning materials: The course is packed with engaging videos, interactive exercises, and quizzes to help you learn SQL in a fun and effective way. Who is This Course For? The Complete SQL from Scratch: Bootcamp course is suitable for anyone interested in diving into the world of databases or enhancing their skills further. Beginners with no prior knowledge and professionals seeking an in-depth understanding of SQL would equally benefit from the course. What You Will Learn: Through The Complete SQL from Scratch: Bootcamp , you will learn: An in-depth understanding of databases and their functions. Familiarity with PostgreSQL installation and various connections. Proficiency in manipulating data including insert, update, delete operations. A comprehensive grasp of complex SQL commands and queries. Skills to design and alter table structures using SQL scripts. Advanced knowledge about SQL statements, their structure, and usage. Competence in data backup and restoration in databases. Why Enrol in This Course: The Complete SQL from Scratch: Bootcamp course is reviewed as a top choice among learners, and is recently updated to match the trending industry needs. By enrolling, you will acquire a set of skills that are crucial in today's data-centric world, enhancing your employability and competitive edge. Requirements: No prior experience is required A computer with internet access Career Path: Database Administrator (average UK salary £47,000) Data Analyst (£40,000), Business Analyst (£43,000) SQL Developer (£45,000) Database Engineer (£48,000) Systems Analyst (£41,000) Data Architect (£62,000). Certification: After successfully completing the course, you will receive a CPD certificate, signifying your expertise in SQL. This course is your stepping stone to becoming a proficient database professional. Enrol and Lets get started! Course Curriculum 12 sections • 56 lectures • 06:39:00 total length •Introduction: 00:04:00 •Course Curriculum overview: 00:04:00 •Overview of Databases: 00:08:00 •PostgreSQL Installation: 00:13:00 •Connecting to PostgreSQL using psql: 00:04:00 •Connecting to PostgreSQL using PgAdmin: 00:07:00 •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 •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 •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 •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 •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 •Overview of Databases and Tables: 00:02:00 •Creating a Database backup: 00:03:00 •Restoring a Database from backup: 00:04:00 •Overview Assessment Test: 00:02:00 •Mock Exam - The Complete SQL from Scratch: Bootcamp: 00:20:00 •Final Exam - The Complete SQL from Scratch: Bootcamp: 00:20:00

Everywhere, from tiny businesses to major corporations, needs people skilled in SQL. In light of this, our online training course has been developed to help you succeed by equipping you with all the necessary skills. The importance of mastering SQL increases if you're looking for your first job in the data industry. You will learn about topics such as SQL fundamentals, data wrangling, SQL analysis, AB testing, distributed computing with Apache Spark, Delta Lake, and more through four increasingly more challenging SQL projects with data science applications. These subjects will equip you with the skills necessary to use SQL creatively for data analysis and exploration, write queries quickly, produce datasets for data analysis, conduct feature engineering, integrate SQL with other data analysis and machine learning toolsets, and work with unstructured data. This Specialisation is designed for a learner with little or no prior coding expertise who wants to become proficient with SQL queries. Experts have meticulously planned out the curriculum for the SQL Skills Training course with years of expertise. As a result, you will find it simple to learn the course material. Learning outcome After finishing the course, you'll Learn to utilise the tools for view creation Become familiar with updating columns and indexed views Be able to test and debug Be able to search a database using SQL Become more familiar with inline table-valued functions Learn the fundamentals of transactions and multiple statements Why Prefer US? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standards-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support *** Course Curriculum *** SQL Programming Course Module 01: Course Introduction Introduction Course Curriculum Overview Overview of Databases Module 02: SQL Environment Setup MySQL Installation MySQL Workbench Installation Connecting to MySQL using Console Module 03: SQL Statement Basics Overview of Challenges SQL Statement Basic SELECT Statement SELECT DISTINCT Column AS Statement COUNT built-in Method usage SELECT WHERE Clause - Part One SELECT WHERE Clause - Part Two Statement Basic Limit Clause Statement Using BETWEEN with Same Column Data How to Apply IN Operator Wildcard Characters with LIKE and ILIKE Module 04: GROUP BY Statements Overview of GROUP BY Aggregation function SUM() Aggregation MIN() and MAX() GROUP BY - One GROUP BY - Two HAVING Clause Module 05: JOINS Overview of JOINS Introduction to JOINS AS Statement table INNER Joins FULL Outer Join LEFT Outer JOIN RIGHT JOIN Union Module 06: Advanced SQL Commands / Statements Timestamps EXTRACT from timestamp Mathematical Functions String Functions SUBQUERY Module 07: Creating Database and Tables Basic of Database and Tables Data Types Primary key and Foreign key Create Table in SQL Script Insert Update Delete Alter Table Drop-Table NOT NULL Constraint UNIQUE Constraint Module 08: Databases and Tables Creating a Database backup 10a Overview of Databases and Tables 10c Restoring a Database CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course can be helpful for anyone working in the SQL fields, whether self-employed or employed, regardless of their career level. Requirements You will not need any prior background or expertise to enrol in this course. Career path The vocation of SQL Skills Training moves very quickly but pays well. This position provides unparalleled satisfaction. This is your opportunity to learn more and start changing things. Query Language Developer Server Database Manager Python Developer Technical Consultant Project Implementation Manager Software Developer (SQL) Certificates Certificate of completion Digital certificate - £10

Overview This comprehensive course on AutoCAD Programming Using C#.NET Level 7 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This AutoCAD Programming Using C#.NET Level 7 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 AutoCAD Programming Using C#.NET Level 7. It is available to all students, of all academic backgrounds. Requirements Our AutoCAD Programming Using C#.NET Level 7 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 12 sections • 193 lectures • 16:44:00 total length •Module 01: Introduction: 00:01:00 •Module 02: Who is this course for?: 00:01:00 •Module 03: What Will I Learn from this Course?: 00:01:00 •Module 04: What is CSharp (C#)?: 00:01:00 •Module 05: What is AutoCAD .NET API?: 00:01:00 •Module 06: What are the advantages of programming in AutoCAD .NET API?: 00:02:00 •Module 01: Section Overview: 00:01:00 •Module 02:.NET Framework Architecture Overview: 00:03:00 •Module 03: .NET Framework Class Library, Common Type System, Common Language Runtime: 00:03:00 •Module 04: More about.NET Framework Common Language Runtime (CLR): 00:02:00 •Module 05: Visual Studio 2017 Integrated Development Environment (IDE): 00:03:00 •Module 06: Visual Studio 2017 IDE Demo: 00:07:00 •Module 01: Section Overview: 00:03:00 •Module 02: DataTypes and Variables - Value Types (signed/unsigned integers): 00:04:00 •Module 03: DataTypes and Variables - Signed and Unsigned Integer Demo: 00:06:00 •Module 04: DataTypes and Variables - Floating Point and Decimal: 00:02:00 •Module 05: DataTypes and Variables - Floating Point and Decimal Demo: 00:04:00 •Module 06: DataTypes and Variables - Boolean: 00:03:00 •Module 07: DataTypes and Variables - Reference Types: 00:03:00 •Module 08: DataTypes and Variables - Class Type: 00:03:00 •Module 09: DataTypes and Variables - Class Type - Demo: 00:11:00 •Module 10: DataTypes and Variables - Interface Type: 00:01:00 •Module 11: DataTypes and Variables - Array Type: 00:02:00 •Module 12: DataTypes and Variables - Array Type - Demo (Single Dimension): 00:08:00 •Module 13: DataTypes and Variables - Array Type - Demo (Multi Dimension): 00:10:00 •Module 14: C# Operators Overview: 00:02:00 •Module 15: C# Assignment Operators: 00:03:00 •Module 16: C# Assignment Operators - Demo: 00:06:00 •Module 17: C# Unary Operators: 00:02:00 •Module 18: C# Unary Operators - Demo: 00:02:00 •Module 19: C# Primary Operators: 00:03:00 •Module 20: C# Primary Operators - Demo: 00:07:00 •Module 21: C# Equality Operators: 00:01:00 •Module 22: C# Equality Operators - Demo: 00:02:00 •Module 23: C# Additive Operators: 00:02:00 •Module 24: C# Additive Operators - Demo: 00:01:00 •Module 25: C# Multiplicative Operators: 00:01:00 •Module 26: C# Multiplicative Operators - Demo: 00:01:00 •Module 27: C# - Relational and Type Operators: 00:04:00 •Module 28: C# - Logical, Conditional and Null Operators: 00:04:00 •Module 29: C# - Logical, Conditional and Null Operators - Demo: 00:07:00 •Module 30: C# Keywords (Reserved Words): 00:04:00 •Module 31: C# - Conditionals Overview: 00:01:00 •Module 32: C# Conditionals - If-Then-Else Statement: 00:03:00 •Module 33: C# Conditionals - If-Then-Else Statement - Demo: 00:07:00 •Module 34: C# Conditionals - Switch Statement: 00:03:00 •Module 35: C# Conditionals - Switch Statement - Demo: 00:00:00 •Module 36: C# - Loops Overview: 00:04:00 •Module 37: C# Loops - For Loop: 00:02:00 •Module 38: C# Loops - For Loop - Demo: 00:02:00 •Module 39: C# Loops - Foreach Loop: 00:02:00 •Module 40: C# Loops - Foreach Loop - Demo: 00:05:00 •Module 41: C# Loops - While Loop: 00:02:00 •Module 42: C# Loops - While Loop - Demo: 00:02:00 •Module 43: C# Loops - Do While Loop: 00:02:00 •Module 44: C# Loops - Do While Loop - Demo: 00:03:00 •Module 45: Modifiers Overview: 00:04:00 •Module 46: Debugging Overview: 00:03:00 •Module 47: Debugging - Demo 1: 00:05:00 •Module 48: Debugging - Demo 2: 00:12:00 •Module 49: Debugging - Demo 3: 00:06:00 •Module 50: Error and Exception Handling - Overview: 00:02:00 •Module 51: ExceptionHandling - Demo 1: 00:07:00 •Module 52: ExceptionHandling - Demo 2: 00:07:00 •Module 53: ExceptionHandling - Demo 3: 00:13:00 •Module 54: Introduction to Object Oriented Programming (OOP): 00:04:00 •Module 55: OOP - Encapsulation - Demo (Part 1): 00:11:00 •Module 56: OOP - Encapsulation - Demo (Part 2): 00:12:00 •Module 57: OOP - Inheritance - Demo (Part 1): 00:07:00 •Module 58: OOP - Inheritance - Demo (Part 2): 00:05:00 •Module 59: OOP - Polymorphism - Demo (Part 1): 00:10:00 •Module 60: OOP - Polymorphism - Demo (Part 2): 00:03:00 •Module 01: AutoCAD .NET API - Overview: 00:01:00 •Module 02: AutoCAD .NET API Assemblies: 00:02:00 •Module 03: Using AutoCAD .NET API in C# - Hello AutoCAD Demo Part 1: 00:12:00 •Module 04: Using AutoCAD .NET API in C# - Hello AutoCAD Demo - Part 2: 00:04:00 •Module 05: AutoCAD .NET API Object Hierarchy: 00:03:00 •Module 06: AutoCAD .NET API - Application Object Overview: 00:03:00 •Module 07: AutoCAD .NET API - Document Object Overview: 00:03:00 •Module 08: AutoCAD .NET API - Database Object Overview: 00:03:00 •Module 01: Creating AutoCAD Objects using AutoCAD .NET API - Overview: 00:01:00 •Module 02: Creating a Line Object - Lab (Part 1): 00:14:00 •Module 03: Creating a Line Object - Lab (Part 2): 00:03:00 •Module 04: Creating a MText Object - Lab: 00:10:00 •Module 05: Creating a Circle Object - Lab: 00:07:00 •Module 06: Creating an Arc Object - Lab: 00:05:00 •Module 07: Creating a LWPolyline Object - Lab: 00:05:00 •Module 01: Manipulate AutoCAD Objects - Overview: 00:01:00 •Module 02: Copy Object using C# - Theory: 00:01:00 •Module 03: Copy Object using C# - Lab (Part 1): 00:11:00 •Module 04: Copy Object using C# - Lab (Part 2): 00:02:00 •Module 05: Copy multiple objects using C# - Lab (Part 1): 00:09:00 •Module 06: Copy multiple objects using C# - Lab (Part 2): 00:01:00 •Module 07: Erase Object using C# - Lab (Part 1): 00:06:00 •Module 08: Erase Object using C# - Lab (Part 2): 00:05:00 •Module 09: Move Object using C# - Lab (Part 1): 00:06:00 •Module 10: Move Object using C# - Lab (Part 2): 00:02:00 •Module 11: Mirror Object using C# - Lab (Part 1): 00:10:00 •Module 12: Mirror Object using C# - Lab (Part 2): 00:02:00 •Module 13: Rotate Object using C# - Lab (Part 1): 00:07:00 •Module 14: Rotate Object using C# - Lab (Part 2): 00:03:00 •Module 15: Scale Object using C# - Lab: 00:05:00 •Module 16: Copy Object Exercise: 00:02:00 •Module 17: Copy Object Solution: 00:06:00 •Module 18: Erase Object Exercise: 00:02:00 •Module 19: Erase Object Solution: 00:07:00 •Module 20: Move Object Exercise: 00:02:00 •Module 21: Move Object Solution: 00:06:00 •Module 22: Mirror Object Exercise: 00:02:00 •Module 23: Mirror Object Solution: 00:06:00 •Module 24: Rotate Object Exercise: 00:02:00 •Module 25: Rotate Object Solution: 00:06:00 •Module 26: Scale Object Exercise: 00:01:00 •Module 27: Scale Object Solution: 00:05:00 •Module 01: Exploring AutoCAD Dictionaries - Layers Overview: 00:03:00 •Module 02: Listing all the Layers in the drawing using C#: 00:11:00 •Module 03: Creating a Layer in AutoCAD using C#: 00:09:00 •Module 04: Updating a Layer in AutoCAD using C#: 00:09:00 •Module 05: Turning the Layer On/Off in AutoCAD using C#: 00:05:00 •Module 06: Thawing/Freezing Layer in AutoCAD using C#: 00:04:00 •Module 07: Deleting a Layer in AutoCAD using C#: 00:03:00 •Module 08: Locking/UnLocking a Layer in AutoCAD using C#: 00:05:00 •Module 09: Assigning a Layer to an AutoCAD object using C#: 00:03:00 •Module 10: Exploring AutoCAD Dictionaries - LineTypes Overview: 00:01:00 •Module 11: Listing all the LineTypes in the drawing using C#: 00:07:00 •Module 12: Loading a LineType in the drawing using C#: 00:07:00 •Module 13: Setting the Current LineType in AutoCAD using C#: 00:03:00 •Module 14: Deleting a LineType in AutoCAD using C#: 00:03:00 •Module 15: Setting a LineType to an object using C#: 00:04:00 •Module 16: Exploring AutoCAD Dictionaries - TextStyles Overview: 00:01:00 •Module 17: Listing all the TextStyles in the drawing using C#: 00:08:00 •Module 18: Updating current TextStyle Font in AutoCAD using C#: 00:10:00 •Module 19: Setting the Current TextStyle in AutoCAD using C#: 00:08:00 •Module 20: Setting a TextStyle to an object using C#: 00:04:00 •Module 01: User Input Functions Overview: 00:01:00 •Module 02: Using GetString Method - Lab (Part 1): 00:13:00 •Module 03: Using GetString Method - Lab (Part 2): 00:10:00 •Module 04: Using GetPoint Method - Lab: 00:12:00 •Module 05: Using GetDistance Method - Lab: 00:04:00 •Module 06: Using GetKeyWords Method - Lab (Part 1): 00:12:00 •Module 07: Using GetKeyWords Method - Lab (Part 2): 00:02:00 •Module 01: Selection Sets and Filters - Overview: 00:02:00 •Module 01: Selection Sets and Filters - Overview: 00:02:00 •Module 03: Using SelectAll Method - Lab (Part 2): 00:02:00 •Module 04: Using SelectOnScreen Method - Lab (Part 1): 00:06:00 •Module 05: Using SelectOnScreen Method - Lab (Part 2): 00:01:00 •Module 06: Using SelectWindow Method - Lab: 00:08:00 •Module 07: Using SelectCrossingWindow Method - Lab: 00:08:00 •Module 08: Using SelectFence Method - Lab: 00:08:00 •Module 09: Using PickFirstSelection Method - Lab: 00:11:00 •Module 10: Using SelectionSet Filters - Overview: 00:01:00 •Module 11: Using SelectionSet Filters - Selecting Lines: 00:09:00 •Module 12: Using SelectionSet Filters - Selecting MTexts Lab: 00:07:00 •Module 13: Using SelectionSet Filters - Selecting Polylines Lab: 00:03:00 •Module 14: Using SelectionSet Filters - Selecting Blocks (FrenchDoors) Lab: 00:07:00 •Module 15: Using SelectionSet Filters - Selecting Blocks (BiFoldDoors) Lab: 00:04:00 •Module 16: Using SelectionSet Filters - Selecting objects in a Layer (Walls) Lab: 00:07:00 •Module 17: Using SelectionSet Filters - Selecting all objects in a Layer (Stairs) Lab: 00:05:00 •Module 18: Using SelectionSets and Filters - Exercises: 00:02:00 •Module 01: TitleBlock Project - Overview: 00:05:00 •Module 02: Creating Project and TBlock Class - Lab: 00:14:00 •Module 03: Creating Classes for each Paper Sizes - Lab: 00:07:00 •Module 04: Creating TitleBlock Class - Lab: 00:14:00 •Module 05: Handling User Selected Paper Size - Lab: 00:05:00 •Module 06: Creating the TitleBlock Border Lines - Lab: 00:06:00 •Module 07: Creating the Horizontal Partition Lines - Lab (Part 1): 00:11:00 •Module 08: Creating the Horizontal Partition Lines - Lab (Part 2): 00:05:00 •Module 09: Creating Vertical Partition Lines - Lab: 00:11:00 •Module 10: Project Check on the Partition Lines - Lab: 00:07:00 •Module 11: Creating the TitleBlock Labels - Lab (Part 1): 00:10:00 •Module 12: Creating the TitleBlock Labels - Lab (Part 2): 00:09:00 •Module 13: Creating the TitleBlock Labels - Lab (Part 3): 00:11:00 •Module 14: Project Check on the Labels: 00:07:00 •Module 15: Creating Drawing Information Texts: 00:08:00 •Module 16: Debugging the TitleBlock Project - Lab: 00:10:00 •Module 17: Completing and Running the TitleBlock Plugin: 00:05:00 •Module 18: Audit Drawing Project - Overview: 00:02:00 •Module 19: Audit Drawing Project - Demo: 00:07:00 •Module 20: Creating the AuditDrawing Project: 00:11:00 •Module 21: Creating the AuditDrawing DisplayOnScreen Method: 00:14:00 •Module 22: Creating the AuditDrawing Write to TXT File Method: 00:08:00 •Module 23: Creating the AuditDrawing Write to CSV File Method: 00:06:00 •Module 24: Creating the AuditDrawing Write to HTML File Method: 00:14:00 •Module 25: AuditDrawing Plugin Demo: 00:04:00 •Module 26: Creating the AuditBlock Method: 00:05:00 •Module 27: Creating the AuditBlock GatherBlocksAndCount Method: 00:16:00 •Module 28: Creating the AuditBlock DisplayOnScreen Method: 00:06:00 •Module 29: Creating the AuditBlock WriteToTXTFile Method: 00:05:00 •Module 30: Creating the AuditBlock WriteToCSVFile Method: 00:05:00 •Module 31: Creating the AuditBlock WriteToHTMLFile Method: 00:07:00 •Module 32: AuditBlock Completed Component - Demo: 00:12:00 •Module 01: Conclusion: 00:01:00 •Assignment - AutoCAD Programming Using C#.NET Level 7: 00:00:00

Overview This comprehensive course on Flowchart Mapping will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Flowchart Mapping comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Flowchart Mapping. It is available to all students, of all academic backgrounds. Requirements Our Flowchart Mapping is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc Course Curriculum 4 sections • 23 lectures • 01:12:00 total length •Introduction: 00:02:00 •What is the purpose of this course?: 00:03:00 •What is process mapping?: 00:04:00 •What is a flowchart?: 00:02:00 •Pros vs. Cons of a flowchart: 00:07:00 •Flowchart icons: 00:02:00 •Scenario: 00:02:00 •Step 1: Identify the process: 00:02:00 •Step 1: Identify the process demonstration: 00:02:00 •Step 2: Identify the parameters: 00:04:00 •Step 2: Identify the parameters demonstration: 00:04:00 •Step 3: Identify start & end: 00:03:00 •Step 3: Identify start & end demonstration: 00:03:00 •Step 4: Identify the departments: 00:02:00 •Step 4: Identify the department's demonstration: 00:02:00 •Step 5: Identify the key steps: 00:02:00 •Step 5: Identify the key steps demonstration: 00:05:00 •Step 6: Identify the connecting steps: 00:02:00 •Step 6: Identify the connecting steps demonstration: 00:06:00 •Step 7: Identify the flow: 00:03:00 •Step 7: Identify the flow demonstration: 00:06:00 •Step 8: Validate the map: 00:02:00 •Step 8: Validate the map demonstration: 00:02:00

Overview This comprehensive course on Building a TodoMVC Application in Vue, React and Angular Masterclass will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Building a TodoMVC Application in Vue, React and Angular Masterclass 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 Building a TodoMVC Application in Vue, React and Angular Masterclass. It is available to all students, of all academic backgrounds. Requirements Our Building a TodoMVC Application in Vue, React and Angular Masterclass is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 5 sections • 14 lectures • 02:24:00 total length •Module 01: Introduction: 00:07:00 •Module 01: Scaffolding a Vue TodoMVC Application: 00:15:00 •Module 02: Programming a Vue TodoMVC Application: 00:17:00 •Module 03: Styling a Vue TodoMVC Application: 00:06:00 •Module 04: Vue TodoMVC Application Summary: 00:01:00 •Module 01: Scaffolding a React TodoMVC Application: 00:10:00 •Module 02: Programming a React TodoMVC Application's Views: 00:13:00 •Module 03: Adding Interactivity to a React TodoMVC Application: 00:20:00 •Module 04: React TodoMVC Summary: 00:02:00 •Module 01: Scaffolding an Angular TodoMVC Application: 00:21:00 •Module 02: Displaying Components in an Angular TodoMVC Application: 00:11:00 •Module 03: Adding Interactivity to an Angular TodoMVC Application: 00:16:00 •Module 04: Angular TodoMVC Summ-A-ry: 00:04:00 •Module 01: Conclusion: 00:01:00

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

Overview This comprehensive course on Docker Training for .Net and Angular Developers will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Docker Training for .Net and Angular Developers 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 Docker Training for .Net and Angular Developers. It is available to all students, of all academic backgrounds. Requirements Our Docker Training for .Net and Angular Developers 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 14 sections • 74 lectures • 05:36:00 total length •Module 01: Introduction: 00:05:00 •Module 02: About Me: 00:03:00 •Module 01: Container Overview: 00:02:00 •Module 02: What are containers?: 00:02:00 •Module 03: Containers Vs Virtual Machines: 00:02:00 •Module 04: Containers inside virtual machines: 00:02:00 •Module 05: Developers Vs Ops Team: 00:02:00 •Module 06: Docker Image Vs Containers: 00:02:00 •Module 07 Installation Steps deertr: 00:05:00 •Module 08: Docker Options: 00:10:00 •Module 09: Hands on with Docker: 00:14:00 •Module 01: Creating First Docker File: 00:07:00 •Module 02: Docker Build: 00:05:00 •Module 03 Docker Run: 00:05:00 •Module 04: Docker Run complex HTML site: 00:06:00 •Module 01: Docker commands like ps, ps-a, start, stop: 00:03:00 •Module 02: Docker containers and images cleanup: 00:08:00 •Module 01: Docker Pull: 00:02:00 •Module 02: Docker Run: 00:03:00 •Module 03: Docker Logs: 00:02:00 •Module 04: Docker Inspect: 00:02:00 •Module 05: Docker Stats: 00:02:00 •Docker File Instructions: 00:02:00 •Docker File overview for DotNet App: 00:04:00 •Docker File overview for Angular App: 00:02:00 •Console App example using STDIN example: 00:06:00 •Running Console App using Dockerfile: 00:04:00 •Command Vs Entrypoint: 00:03:00 •Running ASP.NET Core app using Dockerfile: 00:04:00 •Verifying Files uploaded in docker container: 00:03:00 •Debugging Docker Container: 00:06:00 •Running Angular app in a container: 00:09:00 •Verifying files in angular container: 00:03:00 •Creating Docker Compose file: 00:06:00 •Running Docker Compose: 00:05:00 •Introduction: 00:07:00 •Docker Network Creation: 00:08:00 •Creating Container for SQL Server: 00:06:00 •Connecting Dotnet app with SQL Container: 00:05:00 •Adding Docker Compose: 00:07:00 •Dotnet App failing to connect with SQL Server container: 00:04:00 •SQL Container connected with Dotnet app: 00:02:00 •Volume with SQL Container: 00:09:00 •Project Setup: 00:03:00 •Docker File Creation: 00:07:00 •Running On HTTP: 00:04:00 •Dev Certificate Creation: 00:04:00 •Running the container: 00:03:00 •Introduction: 00:04:00 •Tye build: 00:02:00 •Tye run: 00:04:00 •Creating Frontend App using Razor Template: 00:04:00 •Creating Backend App using Web API Template: 00:04:00 •Adding Service Discovery: 00:05:00 •Tye Run with Backend and Frontend Projects: 00:04:00 •Adding Redis: 00:11:00 •Tye Run with Redis: 00:04:00 •Pushing the image on DockerHub: 00:05:00 •Azure Container Registry (ACR) creation: 00:03:00 •Push images to Azure Container Registry (ACR): 00:05:00 •Spinning up Azure Container Instances using Azure Container Registry Images: 00:05:00 •Another way of creating Azure Container Instances: 00:04:00 •Consuming ACI endpoint in angular app: 00:06:00 •Deploying container to web app: 00:04:00 •Introduction: 00:03:00 •Workfile creation: 00:04:00 •Adding steps to login into ACR: 00:06:00 •Docker build and push step: 00:04:00 •Build failure: 00:05:00 •Fixed the Issue and Deployed to ACR: 00:04:00 •SQL Server container preparation: 00:03:00 •SQL Server container creation: 00:04:00 •Connect to SQL Container and publish database schema: 00:07:00 •Thank You: 00:02:00

Overview This comprehensive course on AutoCAD Programming using C# with Windows Forms will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This AutoCAD Programming using C# with Windows Forms comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this AutoCAD Programming using C# with Windows Forms. It is available to all students, of all academic backgrounds. Requirements Our AutoCAD Programming using C# with Windows Forms is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 6 sections • 63 lectures • 09:11:00 total length •Introduction: 00:03:00 •Who is this course for?: 00:02:00 •Tools needed in this course: 00:01:00 •What will you learn from this course?: 00:05:00 •Controls Project Demo - Overview: 00:03:00 •Controls Demo Project Requirement - Explained: 00:03:00 •Create the Controls Demo Project: 00:03:00 •Controls Demo Project - Creating the Form (User Interface): 00:15:00 •Develop the Controls Demo Utility Class: 00:10:00 •Using Combobox Control to select an option: 00:13:00 •Using Textbox Control to select an option: 00:09:00 •Using Radiobutton Control to select an option: 00:06:00 •Using Checkbox Control to select an option(s): 00:18:00 •Developing Projects - Overview: 00:03:00 •Project 1: Creating a Rectangle - Project Overview: 00:03:00 •Project 1: Creating the Rectangle Utility Class: 00:17:00 •Project 1: Creating the User Interface: 00:10:00 •Project 1: Coding the User Interface28:50: 00:29:00 •Project 1: Running and Testing the Draw Rectangle Plugin: 00:08:00 •Project 2: Update Objects Layer - Overview: 00:02:00 •Project 2: Create the User Interface of Update Objects Layer Plugin: 00:09:00 •Project 2: Coding the Form Load Event: 00:07:00 •Project 2: Coding the Browse drawing Button: 00:03:00 •Project 2: Coding the Update Button control: 00:07:00 •Project 2: Coding the Update Layer Utility Class: 00:12:00 •Project 2: Running and Testing the Plugin: 00:08:00 •Project 3: Extracting Block Attributes to Files - Overview: 00:03:00 •Project 3: Creating the AutomaticBlockExtractor Project: 00:02:00 •Project 3: Creating the User Interface for the BlockExtractor Project: 00:09:00 •Project 3: Completing User Interface code: 00:22:00 •Project 3: Coding the AutoBlockExtractor Utility Class: 00:24:00 •Project 3: Running and Testing the AutomaticBlockExtractor Plugin in AutoCAD: 00:15:00 •Project 4: Updating MText Textstyle Project - Overview and Walkthrough: 00:05:00 •Project 4: Creating the UpdateTextStyle Utility Class: 00:19:00 •Project 4: Designing the UpdateTextStyle Plugin User Interface: 00:06:00 •Project 4: User Interface Code: 00:16:00 •Project 4: Running and Testing the UpdateTextstyle Plugin: 00:05:00 •Project 5: Converting Drawing to PDF Plugin - Overview: 00:03:00 •Project 5: Creating the PlotDWGtoPDF Project in Visual Studio 2019: 00:04:00 •Project 5: Creating the User Interface for MultiplePlotDWGtoPDF Project: 00:09:00 •Project 5: Coding the User Interface: 00:16:00 •Project 5: Developing the GetPlotSizes Method: 00:10:00 •Project 5: Developing the PlotCurrentLayout Method: 00:27:00 •Project 5: Testing and Running the MultiplePlotDWGtoPDF Project: 00:10:00 •Project 6: Multiple Object Extractor Project - Overview: 00:03:00 •Project 6: Creating the MultiObjectExtractor Project: 00:02:00 •Project 6: Designing the MultiObjectExtractor User Interface: 00:14:00 •Project 6: Coding the FormLoad Event: 00:07:00 •Project 6: Coding the BrowseDwg Button: 00:12:00 •Project 6: Coding the BrowseFile Button: 00:03:00 •Project 6: Coding the ProcessExtract Button: 00:05:00 •Project 6: Creating the Code Validation Methods: 00:10:00 •Project 6: Coding the ProcessDrawing Method: 00:19:00 •Project 6: Coding the ProcessObjectExtraction Method: 00:11:00 •Project 6: Coding the ExtractLine Method: 00:11:00 •Project 6: Coding the ExtractCircle Method: 00:04:00 •Project 6: Coding the ExtractPolyline Method: 00:11:00 •Project 6: Coding the ExtractMText Method: 00:05:00 •Project 6: Coding the ExtractBlock Method: 00:03:00 •Project 6: Coding the ExtractObjects Method: 00:02:00 •Project 6: Running and Testing the MultiObjectExtractor Plugin: 00:14:00 •Conclusion and Thank you: 00:01:00 •Assignment - AutoCAD Programming using C# with Windows Forms: 00:00:00

Overview This comprehensive course on VMware vSphere Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This VMware vSphere Course comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this VMware vSphere Course. It is available to all students, of all academic backgrounds. Requirements Our VMware vSphere Course 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 11 sections • 109 lectures • 08:15:00 total length •Who's the Intended Audience?: 00:02:00 •Getting VMware Certified: 00:05:00 •What is Virtual Machine and Hypervisor?: 00:04:00 •vSphere Licensing Editions: 00:04:00 •What's the New in VMware vSphere7: 00:03:00 •vCenter and the Role: 00:03:00 •VMware Hands on Lab: 00:06:00 •What This Module Covers: 00:01:00 •Virtualization System Requirements: 00:04:00 •What do we need to start the course?: 00:05:00 •Download VMware workstation: 00:01:00 •Install VMware workstation: 00:02:00 •Download ESXi and vCenter server: 00:04:00 •Download ESXi and vCenter server: 00:04:00 •How to boot a VM from in VMware Workstation: 00:07:00 •Configure ESX Part 1: 00:09:00 •Configure ESX Part 2: 00:05:00 •ESXi by a Browser: 00:03:00 •ESXi Settings: 00:05:00 •Create a Datastore in ESXi: 00:04:00 •Upload a Windows ISO file to ESXi: 00:01:00 •Install a Virtual Machine in ESXi: 00:07:00 •Connect to an ESXi by VMware Workstation: 00:02:00 •What This Module Covers: 00:01:00 •Why Do We Need Active Directory: 00:01:00 •Prepare Active Directory Windows 2019: 00:06:00 •Create Virtual Machine Template for VMware Workstation: 00:06:00 •Install Active Directory Role: 00:05:00 •Creating DNS Record for vCenter: 00:02:00 •Deploy and install vCenter Appliance: 00:12:00 •Adding ESXis to VC: 00:03:00 •AUTO start VM: 00:02:00 •Verify AUTO Start VM: 00:03:00 •Take Snapshot from vSphere Lab: 00:03:00 •Enable SSH on ESX: 00:02:00 •ESXi DCUI Console: 00:01:00 •vCSA's Management Ul: 00:06:00 •Install ftp Server Using FileZilla Server: 00:05:00 •Backing up VCSA with ftp Server: 00:06:00 •Restore VCSA: 00:09:00 •Exploring vCSA with vSphere Client: 00:07:00 •Overview of VM Tools: 00:02:00 •Install VM Tools: 00:04:00 •Virtual Machine Files: 00:02:00 •Virtual Machine Power off: 00:04:00 •OVA and OVF Files: 00:03:00 •Demo OVF (Importing and Exporting): 00:04:00 •What This Module Covers: 00:01:00 •Virtual Switch (vSwitch) Overview: 00:03:00 •Standard vSwitches: 00:02:00 •Distributed vSwitches: 00:02:00 •Adding Network Adapter: 00:03:00 •vSwitch Creation and Configuration: 00:07:00 •Assign New Switch to the Virtual Machine: 00:02:00 •Verify New vSwitch Configuration: 00:06:00 •Adding VMkernel for Management and Vmotion Traffic: 00:03:00 •Create a vSphere Distributed Switch: 00:10:00 •What This Module Covers: 00:01:00 •Overview of Using ESXi with a SAN: 00:02:00 •Types of Storage: 00:03:00 •What Is Software-Defined Storage (SEIS): 00:04:00 •What is File Level Storage and Block Level Storage?: 00:03:00 •What is an iScsi Storage?: 00:08:00 •Adding vSwitch for iScsi Target: 00:05:00 •Adding Disk to Active Directory: 00:02:00 •Enable iScsi Target on Windows Server: 00:05:00 •Adding iSsci Disk as ESXi Datastore: 00:08:00 •Expand and Extend Datastore: 00:09:00 •Enable NFS on Windows Server: 00:05:00 •Creating an NFS Datastore: 00:03:00 •Migrate a VM to NFS Share: 00:04:00 •VM Add to Inventory: 00:02:00 •What This Module Covers: 00:01:00 •Update Sequence: 00:03:00 •vCenter 6.7 Upgrade to vCenter 7: 00:08:00 •Upgrade ESXi 6.7 ESXi 7: 00:04:00 •Upgrade ESXi 6.7 ESXi 7 using Bundle File: 00:07:00 •Introduction to vSphere 7 Lifecycle Management: 00:03:00 •Demo vSphere 7 Lifecycle Management: 00:17:00 •What This Module Covers: 00:01:00 •vCenter 7 MultiMorning: 00:02:00 •Demo Configure vCenter J MultiMorning: 00:04:00 •vCenter 7 PNID and FQDN Changes: 00:10:00 •vCenter Server Profiles: 00:04:00 •vSphere 7 Licensing: 00:03:00 •What the Module Covers: 00:01:00 •Manual Backup and restore from a VM: 00:06:00 •Backup a VM using Filezilla: 00:05:00 •Backup a VM using OVF Files: 00:06:00 •Clone and Snapshot: 00:08:00 •Installing Veeam Backup and Replication: 00:05:00 •Backup and Restore Using Veeam Backup Software: 00:09:00 •Upload VM from Workstation to ESXi: 00:04:00 •What This Module Covers: 00:01:00 •User Identity: 00:04:00 •Users and Poles: 00:11:00 •Define a New Role in vSphere: 00:04:00 •Account Policy and Message: 00:03:00 •Firewall and Service: 00:11:00 •Enable Lockdown Mode: 00:09:00 •What This Module Covers: 00:01:00 •Troubleshooting using ESXi Management Agents: 00:05:00 •Working with vCenter 7 Logs: 00:04:00 •ESXi Shell Power on and off Commands: 00:05:00 •What This Module Covers: 00:01:00 •Monitoring Virtual Machines in vSphere 7: 00:15:00 •Introduction to ESXTOP Command in ESXi: 00:03:00 •Using ESXTOP to Monitor an ESXi 6.0 Host: 00:07:00 •Monitor Vsphere with Veeam ONE: 00:07:00

In an era awash with data, understanding it is the key to unlocking significant opportunities. Enter the realm of 'SQL For Data Analytics & Database Development'. Dive deep into the heart of data manipulation, exploration, and insight generation. This course unfurls the magic behind SQL, drawing back the curtain on the tools that empower businesses globally. Understanding SQL's profound capabilities opens doors to a world where data-driven decision-making is not just an advantage but an imperative. It isn't simply about data storage. This course unravels the art of analytics, shedding light on how to glean valuable insights from vast data lakes. The path of SQL isn't merely technical; it's the spine of transformative decisions in today's leading industries. Offering a systematic approach to database development, we invite you to embark on this illuminative journey, stitching the threads of raw data into the fabric of meaningful stories. Come harness the power of SQL. Whether your intent is data analytics or the intricate craft of database development, this is your gateway. Let us guide you, from the rudimentary steps to mastering advanced commands, constructing your data narrative, and informing the future. Learning Outcomes: Comprehend the fundamental architecture of SQL and its environment. Acquire proficiency in basic and advanced SQL statements. Understand and implement GROUP BY statements for data aggregation. Master the concepts and applications of JOINS in databases. Cultivate the ability to create and structure databases and tables. Delve into advanced SQL commands, enhancing data manipulation and querying capabilities. Construct efficient database models, fostering optimal data storage and retrieval.   Video Playerhttps://studyhub.org.uk/wp-content/uploads/2021/03/SQL-DATA-ANALYSIS.mp400:0000:0000:00Use Up/Down Arrow keys to increase or decrease volume. Why choose this SQL For Data Analytics & Database Development 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 SQL For Data Analytics & Database Development 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 For Data Analytics & Database Development course for? Aspirants seeking to transition into data-driven roles in various industries. Database administrators aiming to broaden their analytical capabilities. Business analysts eager to enhance their data querying skills. Researchers in need of comprehensive data management tools. Tech enthusiasts wanting to grasp the underpinnings of database systems. Career path Data Analyst - Average salary: £35,000 - £50,000 Per Annum Database Developer - Average salary: £40,000 - £55,000 Per Annum Business Intelligence Analyst - Average salary: £38,000 - £52,000 Per Annum SQL Developer - Average salary: £42,000 - £58,000 Per Annum Database Administrator (DBA) - Average salary: £45,000 - £60,000 Per Annum Data Engineer - Average salary: £47,000 - £63,000 Per Annum Prerequisites This SQL For Data Analytics & Database Development 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. 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