3108 Microsoft courses

Are you someone who aims to improve your virtual team through team building? If you want to be an effective leader through team management and development, this course is specifically designed for you. Description: To become an effective leader, you need to have the dedication to your work and team. If you are a team leader of a virtual team, you need to double your efforts since your transactions are online. Virtual team-leading is more challenging since you won't be able to face your client or members in person. This course is specially made to help you ease up your burden when faced with obstacles. This course will focus on team building and management skills by helping you to effectively communicate with your team members online. Learn now and establish a successful virtual team through this course. Who is the course for? A virtual team leader or members who want to learn about team building and management to help the team dynamics and learn to become more effective through teamwork. Anyone who wants to know and learn more about team building and management. Entry Requirement: This course is available to all learners, of all academic backgrounds. 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 recognized 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 Virtual Team Building and Management Course is a useful qualification to possess, and would be beneficial for the following careers: Home-based Entrepreneur Online Manager Project Leader Team Manager Virtual Team Leader. Virtual Team Building and Management Course Module One - Getting Started 00:30:00 Module Two - Setting Up Your Virtual Team (I) 01:00:00 Module Three - Setting Up Your Virtual Team (II) 01:00:00 Module Four - Virtual Team Meetings 01:00:00 Module Five - Communication (I) 00:30:00 Module Six - Communication (II) 01:00:00 Module Seven - Building Trust 01:00:00 Module Eight - Cultural Issues 01:00:00 Module Nine - To Succeed With a Virtual Team 01:00:00 Module Ten - Dealing With Poor Team Players 01:00:00 Module Eleven - Choosing the Right Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Virtual Team Building and Management Course- Activities 00:00:00 Mock Exam Mock Exam- Virtual Team Building and Management Course 00:20:00 Final Exam Final Exam- Virtual Team Building and Management Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

[vc_row][vc_column][vc_column_text] Description: Are you interested in a career as a virtual assistant? Are you considering setting up a virtual assistant business? If so, then this Virtual Assistant Business Course will equip you with the practical knowledge and skills you need to kickstart your career. Are you wondering what the role of a virtual assistant entails? Are you looking for tools and guidance to set up your business? Wonder no more! This course will teach you about virtual assistant business from scratch. You will be introduced to VA business basics and the wide-ranging skills of a virtual assistant. In this virtual assistant training course, you will explore planning and evaluation and conflict and conflict management. You will also be able to make an informed decision about the services you provide and how to keep within budget. On successful completion of this virtual assistant course, you will have the practical skills and background knowledge to develop a business plan. You will also receive a certificate of achievement, which you can use to take steps to become a fully qualified virtual assistant. Who is the course for? Businessmen or investors who want to put up new virtual assistant business. People who have an interest in becoming a virtual assistant. Entry Requirement: This course is available to all learners, of all academic backgrounds. 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 hard copy 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 Virtual Assistant Business Course is a useful qualification to possess, and would be beneficial for the following careers: Assistants Businessmen Entrepreneurs Investors Marketing Managers Marketing Specialists. [/vc_column_text][/vc_column][/vc_row] Virtual Assistant Business Course Introduction To Virtual Assistant 00:15:00 What Skills Are Needed 00:15:00 Arranging A Work Area 00:15:00 Decide What Services You Will Offer To Accept 00:15:00 How to Know Your Budget 00:10:00 Have A Business Plan 00:10:00 Using Sites Like Scriptlance To Find Clients 00:15:00 Marketing Strategies to Get Clients 00:15:00 Handling Clients Correctly 00:10:00 Wrapping Up 00:05:00 Mock Test Mock Exam- Virtual Assistant Business Course 00:20:00 Final Exam Final Exam- Virtual Assistant Business Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview: Are you ready to embark on a journey into SQL Programming? Unlock the power of data manipulation and database management with the SQL Programming Masterclass. This comprehensive course is meticulously designed throughout this masterclass to provide you with an in-depth understanding of SQL, starting from the basics and progressing to advanced topics. You will explore SQL data types, filtering and sorting data, working with functions, handle NULL values, and even diving into complex SQL concepts like joins, unions, etc. With a course duration of carefully crafted lessons, this Masterclass ensures you grasp SQL's nuances and develop the proficiency to apply these skills effectively.By the end of the SQL Programming Masterclass, you will be prepared to navigate the world of databases confidently. Enrol in this course today and start your journey! Key Features of the Course: CPD certificate upon completion 24/7 learning assistance and support Who is This Course For? This course is perfect for individuals seeking to enhance their data management and analysis skills. Whether you're a data analyst, database administrator, software developer, or professional looking to upskill, this course will empower you to harness the power of SQL programming. Prior programming experience is not mandatory, making it accessible to beginners and intermediate learners. What You Will Learn: Foundations of SQL programming: Learn the basics of SQL, database management systems, and the tools used in this course, such as PostgreSQL and SQLectron. Data manipulation: Master the art of extracting, filtering, and sorting data based on specific requirements using various SQL keywords and operators. Advanced querying techniques: Dive deeper into SQL programming by exploring functions, grouping and aggregating data, and using advanced query techniques. Data conversion and manipulation: Discover how to convert data types, concatenate strings, manipulate characters and numbers, and utilise case statements for more sophisticated queries. Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Data modification: Learn how to insert, update, and delete records in a database, as well as manage table structures and constraints.Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Views and schemas: Explore the concepts of views and schemas, and learn how to create and use them to organise and present data effectively. Why Enrol in This Course: Top-reviewed course: Join thousands of satisfied learners who have praised this course for its clear explanations, comprehensive content, and examples. Recently updated curriculum: Benefit from the most up-to-date information and industry best practices in SQL programming. In-demand skills: SQL programming is a highly sought-after skill in today's job market, opening up numerous career opportunities across industries. Requirements: No prior programming experience is required. All you need is a computer with an internet connection and a willingness to learn. Career Path: Upon completing the SQL Programming Masterclass, you'll have the knowledge and skills for various career paths, including: Data Analyst - Average UK salary: £35,000 per year Database Administrator - Average UK salary: £40,000 per year Business Intelligence Analyst - Average UK salary: £45,000 per year SQL Developer - Average UK salary: £40,000 per year Data Engineer - Average UK salary: £55,000 per year Software Developer - Average UK salary: £45,000 per year Data Scientist - Average UK salary: £60,000 per year Certification: Upon completing the Hygiene and Infection Control CPD Level 4 course, you will receive a CPD certificate. It demonstrates your commitment to maintaining the highest standards of hygiene and infection control. Course Curriculum 17 sections • 117 lectures • 10:47:00 total length •Introduction: 00:01:00 •Tools Used in This Course: 00:01:00 •Download PostgreSQL: 00:02:00 •Install PostgreSQL: 00:03:00 •Download SQLectron: 00:02:00 •Install SQLectron: 00:01:00 •Connect to PostgreSQL - Credentials: 00:01:00 •Connect to PostgreSQL Using SQLectron: 00:02:00 •Import Course Data Using SQLectron: 00:02:00 •FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data: 00:08:00 •Check Imported Data: 00:06:00 •What is a Database?: 00:01:00 •SQL Data Types: 00:02:00 •Finally Some Fun! Extracting Data Based on Requirements: 00:01:00 •Filtering Data using WHERE Keyword: 00:08:00 •Filter Data by Range Using BETWEEN: 00:03:00 •Filter Data by Set of Values Using IN: 00:03:00 •Filter Data by Date: 00:05:00 •More Filtering by Date: 00:03:00 •Another Query Filtering by Date: 00:01:00 •Filter Data by Strings: 00:04:00 •More Filtering by Strings: 00:05:00 •More Filtering by Strings 2: 00:10:00 •More Filtering by Strings 3: 00:02:00 •How to Ignore Caps when Filtering by String: 00:04:00 •AND Operator: 00:10:00 •OR Operator: 00:12:00 •NOT Operator: 00:09:00 •AND, OR & NOT Operators: Which Has the Highest Priority?: 00:06:00 •Basic Math Operations: 00:06:00 •Modulo Operator: 00:04:00 •Calculate The Net Salary for Employees: 00:06:00 •Filter Data with Math Equations: 00:03:00 •Concatenate Strings with '||' Operator: 00:06:00 •Concatenate Strings with Numbers: 00:02:00 •Give Your Report Fields A Cool Name: 00:04:00 •A Report for Payroll: 00:07:00 •Order Records by Column: 00:06:00 •Order Records by Multiple Columns: 00:12:00 •How Alias Names Cannot Be Used with WHERE: 00:02:00 •LIMIT Record Count Fetched by Your Query: 00:08:00 •Fetch A Field's Unique Values Using DISTINCT: 00:03:00 •Using DISTINCT Keyword with Multiple Columns: 00:06:00 •What is a NULL Value Anyway?: 00:05:00 •Build More Sophisticated Queries with CASE Statements: 00:10:00 •Your Knowledge So Far Under A Great Test: 00:09:00 •Let Me Introduce You to Functions: 00:04:00 •SUM Function: 00:04:00 •AVG (Average) Function: 00:04:00 •COUNT Function: 00:07:00 •MIN & MAX Functions: 00:04:00 •How To Count Your Field's Unique Values: 00:04:00 •GROUP BY Clause: Use Functions with Dimensions: 00:06:00 •GROUP BY More Than One Dimension: 00:05:00 •Now For Some Tough Workout: 00:09:00 •Filter By Aggregate Functions with HAVING Clause: 00:08:00 •Character Functions - UPPER, LOWER & INITCAP: 00:08:00 •Character Functions - CONCAT & LENGTH: 00:10:00 •Character Functions - LPAD & RPAD: 00:13:00 •Character Functions - TRIM: 00:04:00 •Character Functions - REPLACE: 00:09:00 •Character Functions - SUBSTR: 00:10:00 •Number Functions - MOD & ROUND: 00:11:00 •Number Functions - TRUNC: 00:07:00 •Selectception: A Select Query inside another Select Query!: 00:06:00 •Auto Data Conversion in SQL: 00:11:00 •Cast Date to Character: 00:10:00 •Cast Number to Character: 00:09:00 •Cast Timestamp to Character: 00:07:00 •Cast Character to Number: 00:08:00 •Cast Character to Date & Timestamp: 00:09:00 •UNION: 00:03:00 •UNION ALL: 00:02:00 •Important Note about Combining Queries: 00:02:00 •INTERSECT: 00:01:00 •EXCEPT: 00:01:00 •Employees & Departments Tables Revised: 00:03:00 •Entity Relationship Diagram (ERD): 00:09:00 •Cartesian Join: 00:09:00 •Table Aliases with Joins: 00:07:00 •Why I Don't Recommend Cartesian Joins: 00:08:00 •Inner Join: 00:06:00 •In-Depth Look into Join Types in SQL: 00:03:00 •Outer Join - Right, Left & Full: 00:08:00 •INSERT a New Record to a Table: 00:09:00 •Insert Without Specifying Column Names: 00:09:00 •UPDATE a Record's Field Values: 00:07:00 •CAUTION! How an UPDATE Query Can Go Wrong: 00:04:00 •Update a Record Using Single-Row Functions: 00:04:00 •A Good Exercise: Extract Employee's Email Address: 00:02:00 •Solution: Extract Employee's Email Address: 00:13:00 •DELETE a Table's Record: 00:06:00 •Insert Records with Nested Select Queries: 00:06:00 •SQL Data Types Revised: 00:13:00 •Bookstore Data Set: Let's Move It to Database: 00:04:00 •Create Your First Table!: 00:08:00 •Insert Data to Your New Table: 00:08:00 •Change Column Data Type: 00:07:00 •Rename Column: 00:04:00 •Add a New Column to Table: 00:04:00 •Constraints in SQL: 00:01:00 •Primary Keys: 00:14:00 •NOT NULL Constraint: 00:05:00 •UNIQUE Constraint: 00:04:00 •DEFAULT Constraint: 00:04:00 •Foreign Keys: 00:08:00 •Use Foreign Keys with Joins - Books & Publishers: 00:06:00 •Foreign Keys - Properties: 00:06:00 •Drop Column: 00:01:00 •DROP Table: 00:01:00 •Create a New Table with Select Statement: 00:05:00 •A Trick to Create an Empty Table with Select Statement: 00:03:00 •Insert New Records Using Select Statement: 00:06:00 •Views: 00:03:00 •Schemas: 00:02:00 •Create & Use Schemas: 00:04:00 •Resources - SQL Programming Masterclass: 00:00:00

Explore the intersection of business intelligence and data mining with our comprehensive course. Learn how to extract valuable insights from large datasets to drive informed business decisions. Gain practical skills in data analysis, pattern recognition, and predictive modeling. Whether you're a business professional or aspiring analyst, this course equips you with the tools and techniques to harness the power of data for strategic advantage in today's competitive business landscape.

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

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

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 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 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 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