254 Programming Fundamentals courses

Duration 1 Days 6 CPD hours This course is intended for Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases. Overview Upon successful completion of this course, students will be able to: - connect to the SQL Server database and execute a simple query. - include a search condition in a simple query. - use various functions to perform calculations on data. - organize data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, and generate a report. In this course, students will compose SQL queries to retrieve desired information from a database. 1 - Executing a Simple Query Connect to the SQL Database Query a Database Save a Query Modify a Query Execute a Saved Query 2 - Performing a Conditional Search Search Using a Simple Condition Compare Column Values Search Using Multiple Conditions Search for a Range of Values and Null Values Retrieve Data Based on Patterns 3 - Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values 4 - Organizing Data Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators 5 - Retrieving Data from Tables Combine Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Check for Unmatched Records Retrieve Information from a Single Table Using Joins 6 - Presenting Query Results Save the Query Result Generate an XML Report

Duration 1 Days 6 CPD hours This course is intended for Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology. Overview Upon successful completion of this course, students will be able to: - Use subqueries to generate query output. - Manipulate table data by inserting, updating, and deleting records in a table. - Manipulate the table structure. - Create views, manipulate data through views, modify the view structure, and drop views. - Create indices on table columns and drop inefficient indices. - Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction. In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process. Prerequisites SQL Querying Fundamentals - Part 1 1 - Using Subqueries to Perform Advanced Querying Search Based on Unknown Values Compare a Value with Unknown Values Search Based on the Existence of Records Generate Output Using Correlated Subqueries Filter Grouped Data Within Subqueries Perform Multiple-Level Subqueries 2 - Manipulating Table Data Insert Data Modify and Delete Data 3 - Manipulating the Table Structure Create a Simple Table Create a Table with Constraints Add or Drop Table Columns Add or Drop Constraints Modify the Column Definition Back Up Tables Delete Tables 4 - Working with Views Create a View Manipulate Data in Views Create Aliases Modify and Drop Views 5 - Indexing Data Create Indices Drop Indices 6 - Managing Transactions Create Transactions Commit Transactions

This course offers you the exact skills and principles you need to deliver a project using Python along with the tools you can use to create solid Python code. Master the language constructs, tools, and terminology with this carefully designed course for beginners.

his course covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom. This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language. These concepts are daily used by programmers and is your first step to working as a programmer. By the end, you'll be comfortable in programming Python code. You will have done small projects. This will serve for you as examples and samples that you can use to build larger projects.

Welcome to 'Python Programming for Non Programmers Level 5,' a course specially designed for those new to the world of coding. This program starts with a comprehensive introduction to Python, a versatile programming language favored in numerous fields. Progressing to the second unit, participants will familiarize themselves with the initial steps of Python programming, setting a strong foundation for future learning. The course then advances to conditional branching in Python, an essential skill for logical problem-solving in coding. A highlight of this course is the practical project: building the game 'Rock Paper Scissors'. This engaging task not only consolidates learning but also adds a fun element to the process. The curriculum further includes critical topics like string operations, date and time functionalities, and the nuances of file handling in Python. Learners will navigate through the complexities of Python data structures-tuples, lists, and dictionaries-and learn to craft user functions, enhancing their coding capabilities. The course also covers email automation, ingenious import tactics, interfacing with operating systems, and handling exceptions with finesse. Furthermore, learners will get hands-on experience with package installation, scheduling tasks in Python, and managing databases using SQLite. The course wraps up with insights on running Python programs via command prompt and Jupyter Notebook, ensuring learners are well-equipped for real-world applications. Learning Outcomes Acquire foundational knowledge and setup skills in Python programming. Master conditional branching for effective problem-solving in code. Complete a practical coding project to solidify Python skills. Learn essential Python operations, including string handling and file management. Explore and apply advanced Python concepts for real-world applications. Why choose this Python Programming for Non Programmers Level 5 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 Python Programming for Non Programmers Level 5 course for? Beginners eager to learn Python from scratch. Non-technical professionals desiring to add coding skills to their portfolio. Educators keen to integrate Python into their teaching methodologies. Businesspersons interested in understanding coding fundamentals for tech-based solutions. Enthusiasts exploring programming as a new hobby or career path. Career path Entry-Level Python Programmer: £25,000 - £40,000 Python-Enabled Data Analyst: £28,000 - £45,000 Python Automation Engineer: £30,000 - £50,000 Technical Support Analyst with Python Skills: £22,000 - £35,000 Python Web Developer: £26,000 - £42,000 Quality Assurance Analyst with Python Expertise: £24,000 - £38,000 Prerequisites This Python Programming for Non Programmers Level 5 does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Python Programming for Non Programmers Level 5 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 Unit 01: Introduction to Python Programming Section 01: Course Introduction 00:02:00 Unit 02: Getting Started with Python Section 01: Software Installation 00:02:00 Section 02: Hello World Program 00:06:00 Section 03: Input and Output 00:07:00 Section 04: Calculating Average of 5 Numbers 00:03:00 Unit 03: Conditional Branching with Python Section 01: If Loop In Python 00:06:00 Section 02: Program Using If Else part 1 00:03:00 Section 03: Program Using If Else part 2 00:08:00 Section 04: Program for Calculator 00:02:00 Section 05: Program Using For Loop 00:08:00 Section 06: For Table 00:05:00 Section 07: For loop and Mathematical Operator in Python 00:04:00 Section 08: Factorial of Number Using Python 00:06:00 Section 09: Program Using While 00:05:00 Section 10: While Loop Example 00:07:00 Section 11: Tasks for Practice 00:02:00 Unit 04: Importing external/internal library in python Section 01: Importing Library in Python 00:07:00 Unit 05: Project Rock Paper and Scissors Section 01: Rock Paper and Scissor Game 00:06:00 Unit 06: Strings Operation in Python Section 01: Program Using String part 1 00:05:00 Section 02: Program using String 2 00:06:00 Section 03: Program Using String 3 00:06:00 Section 04: Program Using String part 4 00:03:00 Unit 07: Date and time in Python Section 01: Use of Date and Time part 1 00:05:00 Section 02: Use of Date and Time part 2 00:05:00 Unit 08: File Handling, read and write using Python Section 01: File Handling Part 1 00:08:00 Section 02: File Handling Part 2 00:07:00 Unit 09: Data Storage Structures, Tuple, List and Dictionary Section 01: Tuple in Python Part 1 00:10:00 Section 02: Tuple in Python Part 2 00:07:00 Section 03: Using Lists part 1 00:07:00 Section 04: Using List part 2 00:12:00 Section 05: Using Lists part 3 00:06:00 Section 06: Using Lists part 4 00:08:00 Section 07: Using Lists part 5 00:02:00 Section 08: Use of Dictionary Part 1 00:04:00 Section 09: Use of Dictionary Part 2 00:05:00 Section 10: Use of Dictionary Part 3 00:08:00 Section 11: Use of Dictionary Part 4 00:07:00 Unit 10: Writing user functions in Python Section 01: Function in Python Part 1 00:06:00 Section 02: Function in Python Part 2 00:05:00 Section 03: Function in Python Part 3 00:04:00 Section 04: Function in Python Part 4 00:07:00 Section 05: Function in Python Part 5 00:08:00 Unit 11: Sending mail Section 01: Send Email 00:09:00 Unit 12: Import Tricks in Python Section 01: Import Study part 1 00:07:00 Section 02: Import Study part 2 00:03:00 Unit 13: Import Operating System and Platform Section 01: Importing OS 00:06:00 Section 02: Import Platform 00:05:00 Unit 14: Exceptions handling in python Section 01: Exception in Python part 1 00:11:00 Section 02: Exception in Python part 2 00:07:00 Section 03: Exception in Python part 3 00:05:00 Unit 15: Installing Packages and Scheduling In Python Section 01: Installing Packages using built in package manager 00:08:00 Section 02: Scheduler in Python 00:05:00 Unit 16: Data Base In Python using sqlite Section 01: Data Base 1 00:08:00 Section 02: Data Base 2 00:09:00 Section 03: Data Base 3 00:08:00 Section 04: Data base 4 00:07:00 Section 05: Data Base 5 00:06:00 Unit 17: Running Program from Command Prompt and jupyter Notebook Section 01: IDE_1 00:05:00 Section 02: IDE_2 00:07:00 Unit 18: Conclusion Section 01: Conclusion 00:02:00 Resources Resources - Diploma in Python Programming 00:00:00 Assignment Assignment - Diploma in Python Programming 00:00:00 Recommended Materials Workbook - Diploma in Python Programming 00:00:00

About Course Master the Fundamentals of Programming with Python Course Description Embark on an exciting journey into the world of programming with this comprehensive Python course, designed to equip you with the essential skills and knowledge to become a proficient Python programmer. Whether you're a complete beginner or seeking to enhance your existing Python skills, this course caters to all levels of expertise. What will be discussed in detail? Introduction to Python: Delve into the basics of Python programming, including variables, data types, operators, and control flow statements. Working with Data Types: Explore the fundamental data types in Python, including numbers, strings, booleans, and lists. Python Strings: Master the art of manipulating strings, including slicing, concatenation, and string formatting techniques. Python Lists: Discover the power of lists, one of Python's most versatile data structures, and learn how to create, access, modify, and iterate over lists. Python Casting and Input: Understand the concept of type casting and learn how to take user input from the console. Python Dictionary: Uncover the usefulness of dictionaries, another essential data structure in Python, and learn how to store and retrieve data using key-value pairs. Python Date and Time: Learn how to handle date and time operations in Python, including creating, formatting, and manipulating date and time objects. Python Loop Part 1: Master the 'for' loop, a fundamental looping construct in Python, to iterate over sequences and perform repetitive tasks. Python Loop Part 2: Expand your understanding of loops by exploring the 'while' loop, used to execute a block of code repeatedly while a condition remains true. Creating a Function: Discover the power of functions, reusable blocks of code that perform specific tasks, and learn how to define, call, and pass arguments to functions. Python OOP Part 1: Delve into the world of Object-Oriented Programming (OOP) with Python, and learn the concepts of classes, objects, inheritance, and polymorphism. Python OOP Part 2: Enhance your OOP skills by exploring advanced concepts such as abstract classes, multiple inheritance, and operator overloading. Python Advanced OOP Part 1: Discover more advanced OOP techniques, including class methods, static methods, and decorators. Python Advanced OOP Part 2: Master the concept of exception handling, a crucial aspect of robust programming, and learn how to handle errors and exceptions effectively. Error Handling: Understand the importance of error handling in Python programming and learn how to identify, handle, and prevent errors. Python File Handling: Learn how to read, write, and manipulate files in Python, enabling you to store and retrieve data from external sources. Python Modules: Explore the concept of modules, reusable code libraries, and discover how to import, use, and create your own modules. Why should you enroll into it? Gain a comprehensive understanding of Python programming: Master the fundamentals of Python programming, from basic syntax to advanced OOP concepts. Develop practical coding skills: Apply your theoretical knowledge to hands-on coding exercises, solidifying your understanding and building your confidence. Prepare for a career in programming: Equip yourself with the essential skills required for entry-level programming positions. Enhance your problem-solving abilities: Learn to think algorithmically and develop effective problem-solving techniques using Python programming. Expand your skillset and knowledge: Whether you're a beginner or an experienced programmer, this course will broaden your understanding of Python and its capabilities. What will be taught? (Learning Outcomes/Learning Objectives) Understand the fundamental concepts of Python programming Work with different data types, including numbers, strings, lists, dictionaries, and Booleans Master control flow statements such as 'if', 'elif', and 'else' Create and manipulate Python functions Implement Object-Oriented Programming (OOP) concepts using classes, objects, inheritance, and polymorphism Handle errors and exceptions effectively Read, write, and manipulate files in Python Import, use, and create Python modules What Will You Learn? Understand the fundamental concepts of Python programming Work with different data types, including numbers, strings, lists, dictionaries, and Booleans Master control flow statements such as 'if', 'elif', and 'else' Create and manipulate Python functions Implement Object-Oriented Programming (OOP) concepts using classes, objects, inheritance, and polymorphism Handle errors and exceptions effectively Read, write, and manipulate files in Python Import, use, and create Python modules Course Content Introduction to Python Introduction to Python Working with Data Types Working with Data Types Python Strings Python Strings Python List Python List Python Casting and Input Python Casting and Input Python Dictionary Python Dictionary Python Date and Time Python Date and Time Python Loop (Part - 1) Python Loop (Part - 1) Python Loop (Part - 2) Python Loop (Part - 2) Python While Loop Python While Loop Creating a Function Creating a Function Python OOP (Part - 1) Python OOP (Part - 1) Python OOP (Part - 2) Python OOP (Part - 2) Python Advanced OOP (Part - 1) Python Advanced OOP (Part - 1) Python Advanced OOP (Part - 2) Python Advanced OOP (Part - 2) Error Handling Error Handling Python File Handling Python File Handling Python Modules Python Modules A course by Uditha Bandara Microsoft Most Valuable Professional (MVP) RequirementsA basic understanding of computers and operating systemsA willingness to learn and practice codingA computer with internet access and the ability to install Python Audience Beginners with no prior programming experience Programmers seeking to transition to Python Individuals looking to enhance their programming skills and knowledge Anyone interested in pursuing a career in programming Audience Beginners with no prior programming experience Programmers seeking to transition to Python Individuals looking to enhance their programming skills and knowledge Anyone interested in pursuing a career in programming

This video course will prepare you to take and pass the CompTIA IT Fundamentals (ITF+) certification (FC0-U61) exam confidently by helping you get to grips with all the major domains covered in the certification and enabling you to develop the skills required to set up, configure, and secure desktop PC, mobile, and networking devices.

Powerful 1-hour Python workshop course understand Python Basics. Practical. Instructor-led. Online. Learn to code a Password Validator in 1 hour. 

Course Overview The comprehensive Fundamentals of Control Valve Basics has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Fundamentals of Control Valve Basics today, and learn from the very best the industry has to offer! This best selling Fundamentals of Control Valve Basics has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Fundamentals of Control Valve Basics is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Fundamentals of Control Valve Basics is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Fundamentals of Control Valve Basics is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Fundamentals of Control Valve Basics, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Fundamentals of Control Valve Basics will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Fundamentals of Control Valve Basics to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Python Course, code the Hangman. Basic Python Course covers in one hour the coding of an interesting app. Any one very welcome. Our Style: Hands-on, Practical Location: Online, Instructor-led Download: anaconda.com Duration: 1 Hour Times: arrange a time for your time zone