• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

3924 Computing & IT courses in Prescot delivered On Demand

Criminal Intelligence & Counterterrorism Analysis

4.5(3)

By Studyhub UK

Welcome to the intriguing realm of 'Criminal Intelligence & Counterterrorism Analysis.' This course is your passport to the dynamic world of intelligence analysis, where you'll unravel the complexities of criminal activities and terrorism. With an extensive curriculum, you'll embark on a journey that spans from understanding the fundamentals of intelligence analysis to gaining insights into criminal psychology. Our engaging modules cover topics such as criminal intelligence and analysis, essential skills and competencies for analysts, and the application of research methods in crime analysis. You'll explore decision-making processes in criminal intelligence and analysis and delve into the realm of intelligence-led policing. With a focus on counterterrorism, technology's role in intelligence analysis, and an overview of the criminal justice system in England and Wales, this course equips you with the knowledge and expertise needed to make a real impact in the field of criminal intelligence and counterterrorism analysis. Learning Outcomes Gain proficiency in intelligence analysis fundamentals. Acquire skills and competencies essential for criminal intelligence analysts. Understand the intricacies of criminal psychology. Master research methods for effective crime analysis. Apply intelligence-led policing strategies. Why choose this Criminal Intelligence & Counterterrorism Analysis course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Criminal Intelligence & Counterterrorism Analysis course for? Aspiring intelligence analysts and law enforcement professionals. Students pursuing degrees in criminology and related fields. Individuals interested in counterterrorism and criminal intelligence analysis. Professionals seeking to enhance their understanding of crime analysis. Anyone passionate about contributing to public safety and security. Career path Intelligence Analyst: £25,000 - £45,000 Criminal Investigator: £30,000 - £50,000 Counterterrorism Analyst: £30,000 - £60,000 Criminologist: £25,000 - £45,000 Law Enforcement Officer: £24,000 - £50,000 Research Analyst: £22,000 - £40,000 Prerequisites This Criminal Intelligence & Counterterrorism Analysis does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Criminal Intelligence & Counterterrorism Analysis Module 01: Introduction to Intelligence Analysis 00:18:00 Module 02: Criminal Intelligence Analysis 00:21:00 Module 03: Criminal Intelligence Analyst - Skills and Competencies 00:17:00 Module 04: Understanding Criminal Psychology 00:37:00 Module 05: Research Methods in Crime Analysis 00:28:00 Module 06: Decision Making in Criminal Intelligence Analysis 00:18:00 Module 07: Intelligence-Led Policing 00:16:00 Module 08: Counterterrorism and Criminal Intelligence Analysis 00:18:00 Module 09: Technology in Criminal Intelligence Analysis 00:19:00 Module 10: The Criminal Justice System in England and Wales 00:17:00 Mock Exam Mock Exam - Criminal Intelligence & Counterterrorism Analysis 00:20:00 Final Exam Final Exam - Criminal Intelligence & Counterterrorism Analysis 00:20:00

Criminal Intelligence & Counterterrorism Analysis
Delivered Online On Demand4 hours 9 minutes
£10.99

Learn Spring & Angular Material with a Full Web Application

4.5(3)

By Studyhub UK

The course 'Learn Spring & Angular Material with a Full Web Application' provides comprehensive training in building a full-stack web application using Spring for the backend and Angular Material for the frontend. Participants will learn how to set up and run the application, model the application using UML, build the backend REST API with Spring Boot, and create the frontend components using Angular Material design. Learning Outcomes: Understand the purpose and content of the course, and the technologies used in the web application development. Set up and configure the application, including the backend with Spring Boot and the frontend with Angular Material. Model the application using UML to design its architecture effectively. Develop the backend REST API with Spring Boot, incorporating Swagger for API documentation. Build the frontend components with Angular Material design, including Login, Signup, and TODO-LIST components. Implement API services using Swagger API documentation and create services for the application. Use Angular Guards for securing routes and configure routing for the frontend application. Conclude the course with a comprehensive overview and guidance on what to explore next in web application development. Why buy this Learn Spring & Angular Material with a Full Web Application? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Learn Spring & Angular Material with a Full Web Application there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Learn Spring & Angular Material with a Full Web Application course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Learn Spring & Angular Material with a Full Web Application does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Learn Spring & Angular Material with a Full Web Application was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Learn Spring & Angular Material with a Full Web Application is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Unit 01: Introduction Module 01: Why this course? 00:02:00 Module 02: What will you learn in the course? 00:02:00 Module 03: Application demo 00:06:00 Unit 02: Application resources Module 01: How to setup and run the application 00:06:00 Unit 03: The application Module 01: About the course application 00:02:00 Module 02: Used Technologies 00:02:00 Module 03: Modeling the application (UML) 00:02:00 Module 04: The backend architecture 00:07:00 Module 05: The frontend architecture 00:03:00 Unit 04: The backend: REST API Module 01: Create a new spring boot project 00:05:00 Module 02: Configure the project 00:02:00 Module 03: Coding the REST API 00:37:00 Module 04: Adding the Swagger configuration 00:06:00 Module 05: Generating the API documentation 00:15:00 Unit 05: The frontend: Angular material design Module 01: Create a new angular project 00:08:00 Module 02: Configure the project 00:02:00 Module 03: Generate the API services using the Swagger API Doc 00:11:00 Module 04: Create the components 00:03:00 Module 05: Create Login / Signup components 00:15:00 Module 06: Create the TODO-LIST component 00:10:00 Module 07: Create the services 00:06:00 Module 08: What is and Why a Guard? 00:03:00 Module 09: Add and Configure the Routing 00:04:00 Unit 06: General conclusion Module 01: What comes next? 00:01:00 Assignment Assignment - Learn Spring & Angular Material with a Full Web Application 00:00:00

Learn Spring & Angular Material with a Full Web Application
Delivered Online On Demand2 hours 40 minutes
£10.99

Level 2 TACCP Training Course

4.5(3)

By Studyhub UK

The Level 2 TACCP (Threat Assessment Critical Control Points) Training Course provides a comprehensive introduction to TACCP, covering food safety legislation, food threats, understanding attackers, and food fraud. Participants will gain insights into the TACCP process and food defense strategies to safeguard the food supply chain. Learning Outcomes: Understand the concept of TACCP and its significance in ensuring food safety and security. Familiarize with various food threats and the importance of identifying potential vulnerabilities in the food supply chain. Learn how to implement food defense measures and strategies to mitigate risks and protect against intentional contamination. Why buy this Level 2 TACCP Training Course? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Level 2 TACCP Training Course there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? Professionals working in the food industry, including food manufacturers, processors, and distributors. Food safety managers, supervisors, and quality assurance personnel responsible for food safety and security. Individuals seeking to enhance their knowledge and skills in food safety and protect against potential threats. Prerequisites This Level 2 TACCP Training Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Level 2 TACCP Training Course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Food Safety Manager: Oversee and implement food safety protocols and measures in food processing facilities. Quality Control Inspector: Conduct inspections and audits to ensure compliance with food safety standards. Supply Chain Manager: Manage the logistics and distribution of food products, considering safety and security aspects. Food Safety Consultant: Provide expert advice to food businesses on implementing TACCP and food defense strategies. Compliance Officer: Ensure adherence to food safety regulations and assess risks in the food supply chain. Course Curriculum Module 01: An Introduction to TACCP An Introduction to TACCP 00:29:00 Module 02: Food Safety Legislation Food Safety Legislation 00:33:00 Module 03: Food Threats Food Threats 00:26:00 Module 04: Understanding the Attacker Understanding the Attacker 00:19:00 Module 05: Food Fraud Food Fraud 00:28:00 Module 06: An Overview of TACCP Process An Overview of TACCP Process 00:21:00 Module 07: TACCP: Food Defence TACCP Food Defence 00:31:00 Assignment Assignment - Level 2 TACCP Training Course 00:00:00

Level 2 TACCP Training Course
Delivered Online On Demand3 hours 7 minutes
£10.99

Maya & Unity 3D: Modeling Environments for Mobile Games

4.5(3)

By Studyhub UK

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Maya & Unity 3D: Modeling Environments for Mobile Games Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Maya & Unity 3D: Modeling Environments for Mobile Games Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Maya & Unity 3D: Modeling Environments for Mobile Games Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Maya & Unity 3D: Modeling Environments for Mobile Games Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Maya & Unity 3D: Modeling Environments for Mobile Games? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Maya & Unity 3D: Modeling Environments for Mobile Games there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Maya & Unity 3D: Modeling Environments for Mobile Games course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Maya & Unity 3D: Modeling Environments for Mobile Games does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Maya & Unity 3D: Modeling Environments for Mobile Games was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Maya & Unity 3D: Modeling Environments for Mobile Games is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Maya & Unity 3D: Modeling Environments for Mobile Games Module 01: Get To Know Your Instructor and the Course 00:02:00 Module 02: Modeling the Base of the Island 00:17:00 Module 03: Modeling the Buildings 00:36:00 Module 04: Unwrap, Texture And Apply Materials 00:14:00 Module 05: Add Flowers, Birds and Background 00:13:00 Module 06: Export the Models from Maya to Unity 00:05:00 Module 07: Import and Setup the Project in Unity 00:04:00 Module 08: Add Our Mesh to the Scene 00:05:00 Module 09: Materials and Textures 00:06:00 Module 10: Setup Camera and Lightning 00:06:00 Module 11: Bake the Light Map 00:08:00 Module 12: Add Camera Effect to Polish the Scene 00:03:00 Assignment Assignment - Maya & Unity 3D: Modeling Environments for Mobile Games 00:00:00

Maya & Unity 3D: Modeling Environments for Mobile Games
Delivered Online On Demand1 hour 59 minutes
£10.99

CompTIA Security+

By CTC Institute

Security+ Course

CompTIA Security+
Delivered Online On Demand30 minutes
FREE

Test-Driven Development - A Stunningly Quick Introduction

By IIL Europe Ltd

Test-Driven Development - A Stunningly Quick Introduction "The job of QA is not just to do testing it's to build quality in.How often have you heard that sentence? And how often has it been followed up with solid practices for actually building quality in? Test-Driven Development (TDD) is one of the foundational practices of high-quality product development. Popularized nearly 20 years ago, TDD is an important skill for high-quality software development. If you want it to be easier to build high-quality code, then you need to understand TDD. In this hands-on session, we'll learn by doing. Richard will facilitate a coding dojo, a safe place to learn and practice the skills of test-driven development. We'll mob-program together on a coding kata - an easy programming problem - to learn TDD, refactoring, clean code, code smells, and more - all in the pursuit of technical agility, business agility, and a great product that people love. To follow along, bring your laptop and development environment. You'll leave with an introduction to solid new skills, including: Test-driven development (TDD) Extreme Programming (XP) Refactoring and refactoring patterns Code smells Mob programming

Test-Driven Development - A Stunningly Quick Introduction
Delivered Online On Demand30 minutes
£15

CompTIA Network+ Certification

4.8(9)

By Skill Up

Grab the opportunities of the networking world with the Best CompTIA Network+ Certification. Learn Networking Fundamentals, Network Devices, Network Security.

CompTIA Network+ Certification
Delivered Online On Demand16 hours 59 minutes
£13.59

Professional Certificate Course in Identifying Information Systems and Information Technology in London 2024

4.9(261)

By Metropolitan School of Business & Management UK

This course aims to provide learners with an in-depth understanding of Information Systems and their various components. The course covers the evolution, types, and components of Information Systems, including databases, database management systems, computer networking, and network architecture. It also explores key concepts and types of database management systems and database languages, information systems software, and the distinction between information systems and information technology. Additionally, the course covers enterprise resource planning (ERP), process mapping, implementation management, cloud computing, and artificial intelligence in Management Information Systems (MIS).After the successful completion of the course, you will be able to learn about the following, Information System, its evolution, types and components. Database and Database Management System. Key Concepts and Types of Database Management Systems and Database Languages. Computer Networking and Its Key Components and Types. What is Network Architecture? Information Systems Software. Information Systems V/s Information Technology. ERP, process mapping, Implementation Management and its components. Cloud Computing in Management Information Systems. Artificial Intelligence and Information Systems. This course provides learners with a comprehensive overview of Information Systems and their components. It begins by introducing the concept of Information Systems, their evolution, types, and components. It then covers databases and database management systems, including the types of database management systems, database languages, and the role of databases in managing information. This course provides learners with a comprehensive overview of Information Systems and their components. It begins by introducing the concept of Information Systems, its evolution, types, and components. It then covers databases and database management systems, including the types of database management systems, database languages, and the role of databases in managing information. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Identifying Information Systems and Information Technology Self-paced pre-recorded learning content on this topic. Identifying Information Systems and Information Technology Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. IT & Operations &Project Managers Business & Data Analysts Database Administrators & Network Engineers Systems Analysts & Software Developers Enterprise Architects, CIOs and CTOs Information Security Managers & IT Consultants Management Consultants & Business Owners Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Professional Certificate Course in Identifying Information Systems and Information Technology in London 2024
Delivered Online On Demand14 days
£31

SQL Programming Masterclass

4.9(27)

By Apex Learning

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

SQL Programming Masterclass
Delivered Online On Demand10 hours 47 minutes
£12

AutoCAD Programming using VB.NET with Windows Forms

4.9(27)

By Apex Learning

Overview This comprehensive course on AutoCAD Programming using VB.NET 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 VB.NET with Windows Forms 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 VB.NET with Windows Forms. It is available to all students, of all academic backgrounds. Requirements Our AutoCAD Programming using VB.NET 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 • 61 lectures • 09:51:00 total length •Module 01: Course Outline: 00:03:00 •Module 02: Introduction: 00:05:00 •Module 03: Who is this course for?: 00:04:00 •Module 04: Tools Needed for this Course: 00:01:00 •Module 01: What will you learn from this Course - Overview: 00:06:00 •Module 01: Windows Form and Controls - Overview: 00:04:00 •Module 02: ControlsDemo Project - Overview: 00:03:00 •Module 03: ControlsDemo Project - Creating the Project: 00:04:00 •Module 04: Controls Demo Project - Designing the Form: 00:19:00 •Module 05: ControlsDemo Project - Creating the Utility Class: 00:10:00 •Module 06: ControlsDemo Project - Coding the Combobox Control: 00:15:00 •Module 07: ControlsDemo Project - Coding the Textbox Control: 00:10:00 •Module 08: ControlsDemo Project - Coding the Radiobutton Control: 00:08:00 •Module 09: ControlsDemo Project - Coding the Checkbox Control: 00:17:00 •Module 01: Draw Rectangle Project - Overview: 00:03:00 •Module 02: Creating the DrawRectangle Project: 00:04:00 •Module 03: DrawRectangle Project - Creating the Utility Class: 00:20:00 •Module 04: DrawRectangle Project - Designing the Form: 00:15:00 •Module 05: DrawRectangle Project - Coding the User Interface Part 1: 00:24:00 •Module 06: DrawRectangle Project - Coding the User Interface Part 2: 00:18:00 •Module 07: DrawRectangle Project - Running the Program: 00:06:00 •Module 08: Automate Update Layer Project - Overview: 00:02:00 •Module 09: Creating the AutomateUpdateLayer Project: 00:03:00 •Module 10: Automate Update Layer Project - Creating the Utility Class: 00:17:00 •Module 11: AutomateUpdateLayer Project - Designing the User Interface: 00:07:00 •Module 12: AutomateUpdateLayer Project - Coding the Form: 00:18:00 •Module 13: AutomateUpdateLayer Project - Running the Program: 00:07:00 •Module 14: Automatic Block Extractor Project - Overview: 00:03:00 •Module 15: AutomaticBlockExtractor Project - Creating the Project: 00:03:00 •Module 16: AutomaticBlockExtractor Project - Creating the User Interface: 00:09:00 •Module 17: AutomaticBlockExtractor Project - Coding the Form: 00:27:00 •Module 18: AutomaticBlockExtractor Project - Creating the Utility Class: 00:27:00 •Module 19: AutomaticBlockExtractor Project - Running the Program: 00:10:00 •Module 20: AutomateUpdateTextStyles Project - Overview: 00:03:00 •Module 21: AutomateUpdateTextStyle Project - Creating the Project: 00:02:00 •Module 22: AutomateUpdateTextStyle Project - Creating the User Interface: 00:09:00 •Module 23: AutomateUpdateTextStyle Project - Coding the Form: 00:20:00 •Module 24: AutomateUpdateTextStyle Project - Coding the Utility Class: 00:16:00 •Module 25: AutomateUpdateTextStyle Project - Running the Program: 00:08:00 •Module 26: Multiple Plot DWG to PDF Project - Overview: 00:03:00 •Module 27: MultiplePlotDWGtoPDF Project - Creating the Project: 00:04:00 •Module 28: MultiplePlotDWGtoPDF Project - Creating the User Interface: 00:09:00 •Module 29: MultiplePlotDWGtoPDF Project - Coding the Form: 00:20:00 •Module 30: MultiplePlotDWGtoPDF Project - Creating the Utility Class: 00:30:00 •Module 31: MultiplePlotDWGtoPDF Project - Running the Program: 00:13:00 •Module 32: Multiple Object Extractor Project - Overview: 00:03:00 •Module 33: MultipleObjectExtractor Project - Creating the Project: 00:02:00 •Module 34: MultipleObjectExtractor Project - Creating the User Interface: 00:15:00 •Module 35: MultipleObjectExtractor Project - Coding the Form Load Event: 00:05:00 •Module 36: MultipleObjectExtractor Project - Coding the Browse Buttons: 00:10:00 •Module 37: MultipleObjectExtractor Project - Coding the Extract Button: 00:20:00 •Module 38: MultipleObjectExtractor Project - Coding the ProcessDrawing Method: 00:09:00 •Module 39: MultipleObjectExtractor Project - Coding the ProcessObjectExtraction Method: 00:11:00 •Module 40: MultipleObjectExtractor Project - Coding the ExtractLine Method: 00:09:00 •Module 41: MultipleObjectExtractor Project - Coding the ExtractCircle Method: 00:03:00 •Module 42: MultipleObjectExtractor Project - Coding the ExtractPolyline Method: 00:09:00 •Module 43: MultipleObjectExtractor Project - Coding the ExtractMText Method: 00:05:00 •Module 44: MultipleObjectExtractor Project - Coding the ExtractBlock Method: 00:05:00 •Module 45: MultipleObjectExtractor Project - Running the Program: 00:15:00 •Module 01: Conclusion: 00:01:00 •Assignment - AutoCAD Programming using VB.NET with Windows Forms: 00:00:00

AutoCAD Programming using VB.NET with Windows Forms
Delivered Online On Demand9 hours 51 minutes
£12