2744 Engineer courses in Reading delivered On Demand

Introducing the 'Python Programming Bible | Networking, GUI, Email, XML, CGI' - your comprehensive, all-in-one resource for mastering Python! Are you an aspiring developer looking to dive into the ocean of Python programming or a seasoned coder seeking to level up your Python game? Look no further! Our course is expertly designed to take you from the basics to the complexities of Python, including Networking, GUI, Email, XML, and CGI. If you've ever dreamt of not just learning Python but truly mastering it, this is the course for you. This program is designed to provide a solid foundation and sharpen your skills in one of the most in-demand programming languages, while also introducing you to its many applications. This course starts with the basics of Python, providing a gentle yet thorough introduction and setup that caters to beginners as well as those looking to refresh their Python knowledge. As we study deeper into the heart of Python, we dive into objects, classes, and the power of regular expressions. But it doesn't stop there! You'll also become comfortable with concepts like CGI programming, which is an important building block for creating dynamic web pages. Navigating from core programming, we transition into the intricacies of managing databases and executing multithreading in Python. You'll gain the confidence to handle complex data management tasks, understand how Python interacts with databases, and efficiently manages multiple tasks simultaneously. The XML section allows you to get hands-on with parsing, data extraction, and manipulation, while the GUI section unveils the art of creating beautiful, user-friendly interfaces using Python. The course is enriched with a diverse set of resources, including real-world projects, quizzes, and interactive coding exercises. This is more than just a course, it's your passport to a new realm of opportunities, unlocking a world where Python programming is your strength, not just a skill.  So whether you're a student aiming to get a head start on your peers, a professional looking to diversify your skills, or an enthusiast wanting to dive deeper into the Python universe, the Python Programming Bible is the starting point for your journey to becoming a Python expert. Enrol today and step into a future of endless opportunities with Python! Learning Outcomes: Upon completion of the Python Programming Bible course, you should be able to: Understand and implement Python basics and advanced concepts. Build object-oriented programs with Python. Utilise regular expressions for pattern-matching tasks. Develop dynamic web pages using CGI programming. Interact with databases efficiently using Python. Apply multithreading for better utilisation of resources. Process and manipulate data using XML in Python. Design and create user-friendly GUIs with Python. Who is this course for? This Python Programming Bible course is ideal for the following: Beginners aiming to learn Python from scratch. Professionals looking to broaden their programming skills. Students pursuing a degree in Computer Science. Web developers looking to integrate Python into their toolkit. Data enthusiasts aiming to handle data with Python. Career Path: This Python Programming Bible course will help you to develop your knowledge and skills to pursue different careers, such as: Python Developer: (£35,000 - £70,000). Data Analyst: (£27,000 - £55,000). Web Developer: (£24,000 - £60,000). Data Scientist: (£45,000 - £90,000). Machine Learning Engineer: (£50,000 - £90,000). Software Developer: (£30,000 - £70,000). Certification After studying the course materials of the Python Programming Bible | Networking, GUI, Email, XML, CGI 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. Prerequisites This Python Programming Bible | Networking, GUI, Email, XML, CGI does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Python Programming Bible | Networking, GUI, Email, XML, CGI 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. Course Curriculum Section 01: Introduction & Setup Introduction 00:02:00 Setup on Mac OS X 00:03:00 Setup On Linux/Ubuntu 00:03:00 Setup On Windows 00:03:00 Run Code Online 00:03:00 Section 02: Basics Comments 00:02:00 Variables & Variable Types 00:05:00 Lists 00:04:00 Tuples 00:03:00 Dictionary 00:06:00 Data Type Conversion 00:02:00 Arithmetic Operators 00:05:00 Comparison Operators 00:03:00 Assignment Operators 00:03:00 Bitwise Operators 00:10:00 Logical Operators 00:07:00 Membership Operators 00:02:00 Identity Operators 00:02:00 Operator Precedence 00:03:00 Decision Making 00:09:00 Loops 00:06:00 Loop Control Statements 00:05:00 Numbers 00:05:00 Strings 00:12:00 Lists In Depth 00:05:00 Tuples In Depth 00:06:00 Dictionary In Depth 00:08:00 Date & Time 00:07:00 Functions 00:11:00 Modules 00:05:00 File Inputs & Outputs 00:13:00 Handling Exceptions 00:07:00 Section 03: Classes/Objects Simple Example 00:04:00 Creating Instance Objects 00:01:00 Accessing Attributes 00:04:00 Constructor New & Init Method 00:06:00 Destroying Objects 00:02:00 Class Inheritance 00:04:00 Overriding Methods 00:03:00 Overloading Methods 00:01:00 Overloading Operators 00:04:00 Data Hiding 00:03:00 Section 04: Regular Expressions Match Function 00:05:00 Search Function 00:02:00 Advanced Expressions 00:05:00 Search & Replace 00:03:00 Section 05: CGI Programming Basic CGI Programming 00:08:00 Get Method 00:06:00 Post Method 00:05:00 Cookies 00:05:00 Section 06: Database Setup Database 00:02:00 Connect To Database 00:05:00 Create Table 00:03:00 INSERT Operation 00:04:00 READ Operation 00:06:00 UPDATE Operation 00:02:00 DELETE Operation 00:02:00 Simple Network Example 00:04:00 Simple Client 00:04:00 Section 07: Multithreading Initiate a New Thread 00:07:00 Create Thread 00:06:00 Synchronise Threads 00:03:00 Multithreaded Priority Queue 00:09:00 Section 08: XML Parse an XML File 00:10:00 Section 09: GUI Introduction 00:02:00 Button Preview 00:03:00 Canvas 00:04:00 Checkbutton 00:02:00 Entry 00:02:00 Frame 00:04:00 Label 00:02:00 List Box 00:02:00 Menu button 00:03:00 Menu 00:08:00 Message 00:02:00 Radio button 00:05:00 Scale 00:03:00 Scrollbar 00:04:00 Text 00:03:00 Top-level 00:02:00 Spinbox 00:02:00 Paned Window 00:03:00 Message Box 00:02:00 Label Frame 00:02:00 Section 10: Resource Resource 00:00:00 Assignment Assignment - Python Programming Bible | Networking, GUI, Email, XML, CGI 00:00:00

Overview This comprehensive course on Autocad Electrical Design will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Autocad Electrical Design 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 Electrical Design. It is available to all students, of all academic backgrounds. Requirements Our Autocad Electrical Design 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 6 sections • 57 lectures • 10:23:00 total length •Module 1- Introduction to Electrical Design Drawing: 00:05:00 •Module 2- Introduction to Autocad: 00:02:00 •Module 3- Free Activation for Students: 00:05:00 •Module 4- Starting Autocad and Changing Background: 00:03:00 •Module 5- Drawing a Line in Autocad: 00:04:00 •Module 6- Drawing a Rectangle in Autocad: 00:04:00 •Module 7- Drawing a Circle in Autocad: 00:01:00 •Module 8- Drawing a Polygon in Autocad: 00:03:00 •Module 9- Drawing an Arc in Autocad: 00:01:00 •Module 10- Drawing a PolyLine in Autocad: 00:03:00 •Module 11- Multiple Lines Using The Offset feature: 00:03:00 •Module 12- Adding Text to Autocad: 00:04:00 •Module 13- Extending Lines in Autocad: 00:02:00 •Module 14- Selection in Autocad: 00:05:00 •Module 15- F-shortcuts in Autocad: 00:02:00 •Module 16- Dimensions in Autocad: 00:04:00 •Module 17- Multi Spiral Line and MLD in Autocad: 00:02:00 •Module 18- Block and Explode: 00:02:00 •Module 19- Move and Scale Commands in Autocad: 00:02:00 •Module 20- Rotate, Mirror and Fillet Commands in Autocad: 00:03:00 •Module 21-Area Calculation and Adding Layer in Autocad: 00:04:00 •Module 22- Saving Your File and Autosave Feature: 00:08:00 •Module 23- Drawing Fluorescent Symbol Using Autocad: 00:07:00 •Module 24- Autocad Classic Mode and Workspace: 00:03:00 •Module 1- Introduction to Dialux: 00:02:00 •Module 2- Types of Electrical Drawings: 00:03:00 •Module 3- Different Lighting Situations: 00:05:00 •Module 4- Understanding Different Types of Lighting Schemes: 00:03:00 •Module 5- Properties of Good Lighting Scheme: 00:01:00 •Module 6- Important Definitions for Lighting: 00:09:00 •Module 7- Utilisation and Maintenance Factor: 00:04:00 •Module 8- Important Notes When Designing: 00:06:00 •Module 9-Steps of Project Design: 00:04:00 •Module 10- Manual Calculation of Lighting: 00:07:00 •Module 11- Understanding Catalogs and Photometric Data: 00:05:00 •Module 12-Dialux Interior Design Task Part 1: 00:33:00 •Module 13-Dialux Interior Design Task Part 2: 00:22:00 •Module 14-Dialux Interior Design Task Part 3: 00:26:00 •Module 15-Wiring of Luminaries and Switches Using Autocad: 00:39:00 •Module 16-Types of Sockets: 00:02:00 •Module 17- Adding and Wiring of Sockets: 00:40:00 •Module 18-Panel Schedule for Lighting and Power Circuits: 00:31:00 •Module 19-Circuit Breakers and Cable Selection: 00:36:00 •Module 20-Single Line Diagram for Industrial Area and Riser of The Residential Building: 00:23:00 •Module 1- Voltage Drop in Low Voltage Distribution System and Manual Calculations: 00:21:00 •Module 2-Short Circuit in Low Voltage Distribution System and Manual Calculations: 00:32:00 •Module 3-Voltage Drop and Short Circuit Calculations Using ETAP Easily: 00:36:00 •Module 1- Effect of Current on Human Body: 00:09:00 •Module 2-Types of Electric Hazards: 00:08:00 •Module 3-Classification of Earthing Systems: 00:24:00 •Module 4-Components of Earthing System: 00:09:00 •Module 5- Design and Resistance of Earthing Electrode: 00:12:00 •Module 6- Design and Resistance of Earthing Conductor: 00:13:00 •Module 7- Measurement of Earth Resistance by Megger and Three Point Method: 00:03:00 •Module 8- Design Earthing or Ground Grid Using ETAP: 00:21:00 •Module 1- Sizing of Electrical Generator for Power Engineering: 00:52:00 •Resources - Autocad Electrical Design: 00:00:00

Overview of Diploma in Basic Chemistry Level 3 Unleash your curiosity with our Basic Chemistry Course. In an era where science and technology underpin our lives, understanding the chemical nature of the world around us is a key skill. The UK chemical industry alone contributed £20.9bn to the economy in 2020, offering diverse opportunities for chemists. Whether your interest lies in healthcare, the environment, or manufacturing, this Basic Chemistry course provides a strong foundation. Master the ABCs of atoms, bonding, and compounds with us. Enrich your understanding and become a part of the chemical revolution. Join our Basic Chemistry Course and navigate the periodic table like a pro! This Diploma in Basic Chemistry Level 3 Course will help you to learn: Comprehend core concepts of basic and applied chemistry. Interpret chemical reactions and understand their impacts. Grasp the interplay between chemistry and energy. Assess chemical safety and laboratory hygiene protocols. Apply chemistry knowledge to environmental and industrial scenarios. This course covers the topics you must know to stand against the tough competition. The future is truly yours to seize with this Diploma in Basic Chemistry Level 3. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online — Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion – Digital / PDF Certificate After completing the Diploma in Basic Chemistry Level 3 course, you can order your CPD Accredited Digital/ PDF Certificate for £5.99. Certificate of Completion – Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This course is designed for learners with a keen interest in science, particularly in understanding the world at a molecular level. It caters to those wanting to lay a solid foundation for further studies in chemistry or related fields. Moreover, anyone wishing to augment their knowledge base, perhaps for a career change or to make informed decisions about chemistry matters, would find the Course beneficial. Those in professions such as teaching, nursing, or even culinary arts, where a basic understanding of chemistry can enhance performance and outcomes, may also find this Basic Chemistry Course helpful. Requirements You don’t need any educational qualification or experience to enrol in the Diploma in Basic Chemistry Level 3 course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path Laboratory Technician - £18K to £27K/year. Quality Control Analyst - £20K to £35K/year. Environmental Consultant - £22K to £40K/year. Chemical Engineer - £27K to £52K/year. Research Scientist - £30K to £50K/year.

Course Overview Find the ultimate guide for learning Django framework by taking this Django REST Framework - Full Stack Python APIs using Python course. In this course, you will learn the techniques to build Python Rest APIs using the Django framework. This Django REST Framework - Full Stack Python APIs using Python course breaks tools and techniques to enhance your understanding of the Django framework and its features. The project-based course provides step-by-step instructions on how to create a Rest API from scratch. You will start the course by learning how to set up a Django development environment and proceed towards the fundamental steps in creating a Rest API project. You will gain the knowledge to develop Rest APIs using function-based views and class-based views. You will also learn the best practices to secure your Rest APIs. Learning Outcomes Gain in-depth knowledge Rest API Learn hope to configure the Rest API Identify the importance of Django Framework Deepen your understanding of mixins and generic views Know how to create Rest APIs using function based views Learn how to create viewset Be able to create Rest APIs with class based views Who Is This Course For? The Django REST Framework - Full Stack Python APIs using Python course is incredibly beneficial for professionals interested in learning how to create Python Rest APIs in Django Framework.  Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the 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 and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path Django REST Framework - Full Stack Python APIs using Python provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as Full Stack- Lead Software Developer Python/Django Developer Backend Developer Software Engineer-Python Unit 01: Start Here Module 01: Course and Instructor Introduction 00:03:00 Module 02: How to make the best of this course 00:02:00 Unit 02: Introduction Module 01: What is REST? 00:06:00 Module 02: Why REST 00:08:00 Module 03: What and Why DJango REST Framework 00:06:00 Unit 03: Software Setup Module 01: Install DJango 00:03:00 Module 02: Install DJango REST Framework 00:01:00 Module 03: Install MySql and MySql workbench 00:03:00 Module 04: Launch MySql workbench 00:02:00 Module 05: Install python mysqlclient 00:01:00 Module 06: Install ATOM 00:03:00 Module 07: Install Postman 00:01:00 Unit 04: REST in Action Module 01: Create the Project 00:03:00 Module 02: Create a view 00:02:00 Module 03: Configure the URL and TEST 00:03:00 Module 04: Create app level urls 00:02:00 Module 05: Create a model class 00:03:00 Module 06: Configure the database and run migrations 00:03:00 Module 07: Use the model in the view and test 00:03:00 Unit 05: Function Based Views and Serializers Module 01: DRF Components 00:06:00 Module 02: Function Based Views 00:05:00 Module 03: Serializers 00:04:00 Module 04: Create the Project 00:02:00 Module 05: Create the Model 00:02:00 Module 06: Create the Serializer 00:02:00 Module 07: GET single student 00:04:00 Module 08: Create Student 00:04:00 Module 09: Implement Non Primary Key Based Operations 00:07:00 Module 10: Use @api_view 00:01:00 Module 11: Configure the URLs 00:02:00 Module 12: Test 00:07:00 Module 13: Test Using Postman 00:04:00 Unit 06: Class Based Views Module 01: Introduction 00:03:00 Module 02: Create the Project 00:03:00 Module 03: Implement Non Primary Key Based Operations 00:06:00 Module 04: Implement Primary Key Based Operations 00:07:00 Module 05: Configure the URLs and TEST 00:04:00 Unit 07: Mixins Module 01: Introduction 00:05:00 Module 02: Non Primary Key based operations 00:04:00 Module 03: Primary Key based operations 00:02:00 Module 04: Configure the URLs and TEST 00:02:00 Unit 08: Generic Views Module 01: Generics 00:03:00 Module 02: Generics in action 00:03:00 Unit 09: ViewSets Module 01: Introduction 00:03:00 Module 02: Create ViewSet 00:02:00 Module 03: Configure URLs and Test 00:04:00 Unit 10: Nested Serializers Module 01: Create the project 00:02:00 Module 02: Create model 00:03:00 Module 03: Create Serializers 00:04:00 Module 04: Create REST endpoints 00:03:00 Module 05: Configure URLs 00:02:00 Module 06: Test 00:03:00 Unit 11: Pagination Module 01: Introduction 00:06:00 Module 02: Pagination in action 00:05:00 Module 03: Pagination at class level 00:03:00 Module 04: Using LimitOffsetPagination 00:01:00 Unit 12: Security Module 01: Introduction 00:04:00 Module 02: Authentication in action 00:03:00 Module 03: Authorization in action 00:06:00 Module 04: Global Security 00:04:00 Unit 13: Flight Reservation API Module 01: Usecase 00:01:00 Module 02: Create the Project 00:01:00 Module 03: Create Model Classes 00:03:00 Module 04: Create Reservation Model 00:01:00 Module 05: Create Serializers 00:01:00 Module 06: Create ViewSets 00:02:00 Module 07: Configure the Router 00:02:00 Module 08: Run Migrations 00:01:00 Module 09: Initial round of testing 00:04:00 Module 10: Implement findFlights endpoint 00:03:00 Module 11: Test findFlights 00:05:00 Module 12: Implement Save Reservation 00:06:00 Module 13: Test Save Reservation 00:04:00 Unit 14: Validations Module 01: In-Built Validations 00:04:00 Module 02: Allowing Blank and Null Values 00:02:00 Module 03: Create Custom Validator 00:05:00 Module 04: Two more ways 00:07:00 Unit 15: Token Auth Module 01: Introduction 00:03:00 Module 02: Configure Token Auth 00:05:00 Module 03: Create Users and Token 00:04:00 Module 04: Token Auth in action 00:03:00 Module 05: Automate Token Creation 00:09:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Learn to effectively integrate and build RESTful API clients into Java and Spring Boot applications using WireMock.

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

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

This is a comprehensive and practical Apache Spark course. In this course, you will learn and master the art of framing data analysis problems as Spark problems through 20+ hands-on examples, and then scale them up to run on cloud computing services. Explore Spark 3, IntelliJ, Structured Streaming, and a stronger focus on the DataSet API.

Overview With the ever-increasing demand for Electrical Safety in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Electrical Safety may be. Learning about Electrical Safety or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Electrical Safety . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Electrical Safety is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Electrical Safety course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Electrical Safety course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Electrical Safety course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Electrical Safety , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Electrical Safety , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Electrical Safety , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Electrical Safety course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.    Course Curriculum Advanced Electrical Safety Module 1 - Establishing an Effective Electrical Safety Program Establishing an Effective Electrical Safety Program 00:00 Advanced Electrical Safety Module 2 - Equipment Inspection, Protection, and Clothing Equipment Inspection, Protection, and Clothing 00:00 Advanced Electrical Safety Module 3 - Physiological Effects of Electricity Physiological Effects of Electricity 00:00 Advanced Electrical Safety Module 4 - Electrical Safety Rules Electrical Safety Rules 00:00 Advanced Electrical Safety Module 5 - Electrical Safe Work Practices Plan Electrical Safe Work Practices Plan 00:00 Advanced Electrical Safety Module 6 - Electrical Equipment Electrical Equipment 00:00 Advanced Electrical Safety Module 7 - Accident and Injury Prevention and Procedures Accident and Injury Prevention and Procedures 00:00 Advanced Electrical Safety Module 8 - Functional Safety for Electric Power Transmission Functional Safety for Electric Power Transmission 00:00 Advanced Electrical Safety Module 9 - Risk Assessment Risk Assessment 00:00

🚀 Unlock Peak Performance in Power Systems with 'Distribution Stations and Feeder Protection' Course! 🌐 Are you ready to revolutionize your understanding of power distribution and take your expertise to new heights? Look no further! Our cutting-edge course, 'Distribution Stations and Feeder Protection,' is designed to empower professionals like you with the knowledge and skills needed to excel in the dynamic world of electrical engineering.   🔧 Course Highlights: Comprehensive Curriculum: Delve into a meticulously crafted curriculum that covers every aspect of distribution stations and feeder protection. From fundamental concepts to advanced techniques, this course ensures you gain a holistic understanding. Real-world Applications: Learn through practical, real-world scenarios and case studies. Gain insights into the challenges faced in distribution stations and master the art of implementing effective feeder protection strategies. Expert-Led Instruction: Benefit from the expertise of seasoned industry professionals who bring a wealth of experience to the table. Our instructors are committed to providing you with valuable insights and hands-on knowledge. Cutting-edge Technologies: Stay ahead of the curve by exploring the latest advancements in distribution station technologies and feeder protection systems. Understand the integration of smart technologies and how they enhance the reliability and efficiency of power systems. Interactive Learning: Engage in interactive sessions, discussions, and practical exercises that reinforce your understanding of key concepts. Collaborate with peers, share experiences, and build a network of like-minded professionals. Certification: Earn a prestigious certification upon successful completion of the course. Showcase your expertise and commitment to excellence in distribution station design and feeder protection.   💡 Who Should Attend: Electrical Engineers Power System Professionals Energy Sector Technicians Maintenance and Operations Personnel Those looking to enhance their skills in power distribution   📈 Benefits of the Course: Strengthen your understanding of distribution station design. Master advanced feeder protection strategies. Enhance the reliability and efficiency of power systems. Boost career prospects with a recognized certification. Stay updated on the latest industry trends and technologies.   🌟 Don't miss this opportunity to elevate your career in electrical engineering! Enroll now and become a leader in Distribution Stations and Feeder Protection. Let's power up your success together! 🔗🔌 Course Curriculum Intro Intro 00:00 Per Phase Analysis Per Phase Analysis 00:00 Sub-Station Protection Sub-Station Protection 00:00 A Protection Coordination Problem A Protection Coordination Problem 00:00 Surge Protective Equipment Surge Protective Equipment 00:00 Transformer Protection Transformer Protection 00:00