2219 Programming courses

Duration 5 Days 30 CPD hours This course is intended for This course is intended for anyone who is new to software development and wants, or needs, to gain an understanding of programming fundamentals and object-oriented programming concepts. They will typically be high school students, post-secondary school students, or career changers, with no prior programming experience. They might want to gain an understanding of the core programming fundamentals before moving on to more advanced courses such as Programming in C#. Overview Explain core programming fundamentals such as computer storage and processing. Explain computer number systems such as binary. Create and use variables and constants in programs. Explain how to create and use functions in a program. Create and use decisions structures in a computer program. Create and use repetition (loops) in a computer program. Explain pseudocode and its role in programming. Explain the basic computer data structures such as arrays, lists, stacks, and queues. Implement object-oriented programming concepts. Create and use classes in a computer program. Implement encapsulation, inheritance, and polymorphism. Describe the base class library (BCL) in the .NET Framework. Explain the application security concepts. Implement simple I/O in a computer program. Identify application errors and explain how to debug an application and handle errors. Identify the performance considerations for applications. In this 5-day course, students will learn the basics of computer programming through the use of Microsoft Visual Studio 2022 and the Visual C# and Visual Basic programming languages. The course assumes no prior programming experience and introduces the concepts needed to progress to the intermediate courses on programming, Programming in C#. The focus will be on core programming concepts such as computer storage, data types, decision structures, and repetition by using loops. The course also covers an introduction to object-oriented programming covering classes, encapsulation, inheritance, and polymorphism. Coverage is also included around exception handling, application security, performance, and memory management. 1 - INTRODUCTION TO CORE PROGRAMMING CONCEPTS * Computer Data Storage and Processing * Application Types * Application Lifecycle * Code Compilation 2 - CORE PROGRAMMING LANGUAGE CONCEPTS * Syntax * Data Types * Variables and Constants 3 - PROGRAM FLOW * Introduction to Structured Programming Concepts * Introduction to Branching * Using Functions * Using Decision Structures * Introducing Repetition 4 - ALGORITHMS AND DATA STRUCTURES * Understand How to Write Pseudocode * Algorithm Examples * Introduction to Data Structures 5 - ERROR HANDLING AND DEBUGGING * Introduction to Program Errors * Introduction to Structured Error Handling * Introduction to Debugging 6 - INTRODUCTION TO OBJECT-ORIENTED PROGRAMMING * Introduction to Complex Structures * Introduction to Structs * Introduction to Classes * Introducing Encapsulation 7 - MORE OBJECT-ORIENTED PROGRAMMING * Introduction to Inheritance * Introduction to Polymorphism * Introduction to .NET and the Base Class Library 8 - INTRODUCTION TO APPLICATION SECURITY * Authentication and Authorization * Code Permissions on Computers * Introducing Code Signing 9 - CORE I/O PROGRAMMING * Using Console I/O * Using File I/O 10 - APPLICATION PERFORMANCE AND MEMORY MANAGEMENT * Value Types vs Reference Types * Converting Types * The Garbage Collector ADDITIONAL COURSE DETAILS: Nexus Humans 55337 Introduction to Programming training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 55337 Introduction to Programming course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

This Python Machine Learning online instructor led course is an excellent introduction to popular machine learning algorithms. -------------------------------------------------------------------------------- Python Machine Learning 2-day Course Prerequisites: Basic knowledge of Python coding is a pre-requisite. Who Should Attend? This course is an overview of machine learning and machine learning algorithms in Python SciKitLearn. Practical: * We cover the below listed algorithms, which is only a small collection of what is available. However, it will give you a good understanding, to plan your Machine Learning project * We create, experiment and run machine learning sample code to implement a short selected but representative list of available the algorithms.  Course Outline: Supervised Machine Learning: * Classification Algorithms: Naive Bayes, Decision Tree, Logistic Regression, K-Nearest Neighbors, Support Vector Machine * Regression Algorithms: Linear, Polynomial Unsupervised Machine Learning: * Clustering Algorithms: K-means clustering, Hierarchical Clustering * Dimension Reduction Algorithms: Principal Component Analysis Latent Dirichlet allocation (LDA) * Association Machine Learning Algorithms: Apriori, Euclat Other machine learning Algorithms: * Ensemble Methods ( Stacking, bagging, boosting ) Algorithms: Random Forest, Gradient Boosting * Reinforcement learning Algorithms: Q-Learning * Neural Networks and Deep Leaning Algorithms: Convolutional Network (CNN) Data Exploration and Preprocessing: * The first part of a Machine Learning project understands the data and the problem at hand. * Data cleaning, data transformation and data pre-processing are covered using Python functions to make data exploration and preprocessing relatively easy. What is included in this Python Machine Learning: * Python Machine Learning Certificate on completion   * Python Machine Learning notes * Practical Python Machine Learning exercises and code examples * After the course, 1 free, online session for questions or revision Python Machine Learning. * Max group size on this Python Machine Learning is 4. -------------------------------------------------------------------------------- REFUND POLICY No Refunds

Duration 5 Days 30 CPD hours This course is intended for This course is intended for IT Professionals who are already experienced in general Windows Server, Windows client, Azure, and Microsoft 365 administration, and who want to learn more about using Windows PowerShell for administration. No prior experience with any version of PowerShell or any scripting language is assumed. This course is also suitable for IT Professionals already experienced in server administration, including Microsoft Exchange Server, Microsoft SharePoint Server, and Microsoft SQL Server. This course provides students with the fundamental knowledge and skills to use PowerShell for administering and automating administration of Windows servers. This course provides students the skills to identify and build the command they require to perform a specific task. In addition, students learn how to build scripts to accomplish advanced tasks such as automating repetitive tasks and generating reports. This course provides prerequisite skills supporting a broad range of Microsoft products, including Windows Server, Windows Client, Microsoft Azure, and Microsoft 365. In keeping with that goal, this course will not focus on any one of those products, although Windows Server, which is the common platform for all of those products, will serve as the example for the techniques this course teaches. Prerequisites Before attending this course, students must have: * -Experience with Windows networking technologies and implementation. * - Experience with Windows Server administration, maintenance, and troubleshooting. 1 - REVIEW WINDOWS POWERSHELL * Learn about Windows PowerShell * Get familiar with Windows PowerShell applications * Identify factors to install and use Windows PowerShell * Configure the Windows PowerShell console * Configure the Windows PowerShell Integrated Scripting Environment (ISE) * Use Visual Studio Code with PowerShell 2 - UNDERSTAND THE COMMAND SYNTAX IN WINDOWS POWERSHELL * Discover the structure of PowerShell cmdlets * Discover the parameters for using PowerShell cmdlets * Review the tab completion feature in PowerShell * Display the About files content in PowerShell 3 - FIND COMMANDS AND GET-HELP IN WINDOWS POWERSHELL * Define modules in PowerShell * Find cmdlets in PowerShell * Use command aliases in PowerShell * Use Show-Command and Get-Help in PowerShell * Interpret the help file contents and update the local help content in PowerShell 4 - MANAGE ACTIVE DIRECTORY DOMAIN SERVICES USING POWERSHELL CMDLETS * Manage user accounts in PowerShell * Manage groups and group memberships in PowerShell * Manage computer accounts in PowerShell * Manage organizational units and Active Directory objects in PowerShell 5 - MANAGE NETWORK SERVICE SETTINGS FOR WINDOWS DEVICES USING POWERSHELL CMDLETS * Manage IP addresses in PowerShell * Manage IP routing in PowerShell * Manage DNS clients in PowerShell * Manage Windows Firewall settings in PowerShell 6 - MANAGE WINDOWS SERVER SETTINGS USING POWERSHELL CMDLETS * Automate management tasks using the Group Policy management cmdlets * Manage server roles and services using PowerShell cmdlets * Manage Hyper-V Virtual Machines using PowerShell cmdlets * Manage Internet Information Services using PowerShell cmdlets 7 - MANAGE SETTINGS FOR A LOCAL WINDOWS MACHINE USING POWERSHELL CMDLETS * Manage Windows 10 using PowerShell * Manage permissions with PowerShell 8 - UNDERSTAND THE WINDOWS POWERSHELL PIPELINE * Review Windows PowerShell pipeline and its output * Discover object members in PowerShell * Control the formatting of pipeline output 9 - SELECT, SORT, AND MEASURE OBJECTS USING THE PIPELINE * Sort and group objects by property in the pipeline * Measure objects in the pipeline * Select a set of objects in the pipeline * Select object properties in the pipeline * Create and format calculated properties in the pipeline 10 - FILTER OBJECTS OUT OF THE PIPELINE * Learn about the comparison operators in PowerShell * Review basic filter syntax in the pipeline * Review advanced filter syntax in the pipeline * Optimize the filter performance in the pipeline 11 - ENUMERATE OBJECTS IN THE PIPELINE * Learn about enumerations in the pipeline * Review basic syntax to enumerate objects in the pipeline * Review advanced syntax to enumerate objects in the pipeline 12 - SEND AND PASS DATA AS OUTPUT FROM THE PIPELINE * Write pipeline data to a file * Convert pipeline objects to other forms of data representation in PowerShell * Control additional output options in PowerShell 13 - PASS PIPELINE OBJECTS * Pipeline parameter binding * Identify ByValue parameters * Pass data by using ByValue * Pass data by using ByPropertyName * Identify ByPropertyName parameters * Use manual parameters to override the pipeline * Use parenthetical commands * Expand property values 14 - CONNECT WITH DATA STORES USING POWERSHELL PROVIDERS * Define Windows PowerShell providers * Review the built-in providers in PowerShell * Access provider help in PowerShell 15 - USE POWERSHELL DRIVES IN POWERSHELL * Explain PowerShell drives in PowerShell * Use PowerShell drive cmdlets in PowerShell * Manage the file system in PowerShell * Manage the registry in PowerShell * Work with certificates in PowerShell * Work with other PowerShell drives in PowerShell 16 - REVIEW CIM AND WMI * Review architecture of CIM and WMI * Review repositories in CIM and WMI * Locate online class documentation by using CIM and WMI cmdlets 17 - QUERY CONFIGURATION INFORMATION BY USING CIM AND WMI * List local repository namespaces and classes by using CIM and WMI * Query instances by using commands and WMI Query Language * Connect to remote computers by using CIM and WMI cmdlets * Query repository classes from remote computers by using CIMSession objects 18 - QUERY AND MANIPULATE REPOSITORY OBJECTS BY USING CIM AND WMI METHODS * Discover methods of repository objects by using CIM and WMI * Locate class methods and documentation by using CIM and WMI * Invoke methods of repository objects by using CIM and WMI 19 - MANAGE VARIABLES IN WINDOWS POWERSHELL SCRIPTS * Define variables in Windows PowerShell scripts * Create variable names in Windows PowerShell scripts * Assign values and types to variables in Windows PowerShell scripts * Identify the methods and properties of variables in Windows PowerShell scripts * Use string variables and methods in Windows PowerShell scripts * Use date variables and methods in Windows PowerShell scripts 20 - WORK WITH ARRAYS AND HASH TABLES IN WINDOWS POWERSHELL SCRIPTS * Define an array in Windows PowerShell scripts * Work with array lists in Windows PowerShell scripts * Define hash tables in Windows PowerShell Scripts * Work with hash tables in Windows PowerShell scripts 21 - CREATE AND RUN SCRIPTS BY USING WINDOWS POWERSHELL * Review Windows PowerShell scripts * Modify scripts in the PowerShell Gallery * Create scripts using Windows PowerShell * Review the PowerShellGet module in Windows PowerShell * Run scripts and set the execution policy in Windows PowerShell * Review Windows PowerShell and AppLocker * Sign the scripts digitally in Windows PowerShell 22 - WORK WITH SCRIPTING CONSTRUCTS IN WINDOWS POWERSHELL * Review and use the ForEach loop in Windows PowerShell scripts * Review and use the If construct in Windows PowerShell scripts * Review and use the Switch construct in Windows PowerShell scripts * Review the For construct in Windows PowerShell scripts * Review other loop constructs in Windows PowerShell scripts * Review Break and Continue in Windows PowerShell scripts 23 - IMPORT DATA IN DIFFERENT FORMATS FOR USE IN SCRIPTS BY USING WINDOWS POWERSHELL CMDLETS * Use the Get-Content command in Windows PowerShell scripts * Use the Import-Csv cmdlet in Windows PowerShell scripts * Use the Import-Clixml cmdlet in Windows PowerShell scripts * Use the ConvertFrom-Json cmdlet in Windows PowerShell scripts 24 - USE METHODS TO ACCEPT USER INPUTS IN WINDOWS POWERSHELL SCRIPTS * Identify values that might change in Windows PowerShell scripts * Use the Read-Host cmdlet in Windows PowerShell scripts * Use the Get-Credential cmdlet in Windows PowerShell scripts * Use the Out-GridView cmdlet in Windows PowerShell scripts * Pass parameters to a Windows PowerShell script 25 - TROUBLESHOOT SCRIPTS AND HANDLE ERRORS IN WINDOWS POWERSHELL * Interpret error messages generated for Windows PowerShell commands * Add output to Windows PowerShell scripts * Use breakpoints in Windows PowerShell scripts * Interpret error actions for Windows PowerShell commands 26 - USE FUNCTIONS AND MODULES IN WINDOWS POWERSHELL SCRIPTS * Review functions in Windows PowerShell scripts * Use variable scope in Windows PowerShell scripts * Create modules in Windows PowerShell scripts * Use the dot sourcing feature in Windows PowerShell 27 - MANAGE SINGLE AND MULTIPLE COMPUTERS BY USING WINDOWS POWERSHELL REMOTING * Review the remoting feature of Windows PowerShell * Compare remoting with remote connectivity * Review the remoting security feature of Windows PowerShell * Enable remoting by using Windows PowerShell * Use one-to-one remoting by using Windows PowerShell * Use one-to-many remoting by using Windows PowerShell * Compare remoting output with local output 28 - USE ADVANCED WINDOWS POWERSHELL REMOTING TECHNIQUES * Review common remoting techniques of Windows PowerShell * Send parameters to remote computers in Windows PowerShell * Set access protection to variables, aliases, and functions by using the scope modifier * Enable multi-hop remoting in Windows PowerShell 29 - MANAGE PERSISTENT CONNECTIONS TO REMOTE COMPUTERS BY USING WINDOWS POWERSHELL SESSIONS * Review persistent connections in Windows PowerShell * Create and manage persistent PSSessions by using Windows PowerShell * Disconnect PSSessions by using Windows PowerShell * Review the feature of implicit remoting in Windows PowerShell 30 - REVIEW AZURE POWERSHELL MODULE * Review Azure PowerShell * Review the benefits of the Azure PowerShell module * Install the Azure PowerShell module * Migrate Azure PowerShell from AzureRM to Azure * Review Microsoft Azure Active Directory module for Windows PowerShell and Azure Active Directory PowerShell for Graph modules 31 - REVIEW THE FEATURES AND TOOLS FOR AZURE CLOUD SHELL * Review the characteristics of Azure Cloud Shell * Review the features and tools of Azure Cloud Shell * Configure and experiment with Azure Cloud Shell 32 - MANAGE AZURE RESOURCES WITH WINDOWS POWERSHELL * Create a new Azure virtual machine by using Windows PowerShell commands * Manage Azure virtual machines by using Windows PowerShell commands * Manage Azure related storage by using Azure PowerShell * Manage Azure subscriptions by using Azure PowerShell 33 - MANAGE USERS, GROUPS, AND LICENSES IN MICROSOFT ENTRA ID BY USING WINDOWS POWERSHELL * Review benefits to manage Microsoft 365 services by using Windows PowerShell * Connect to the Microsoft 365 tenant by using Windows PowerShell * Manage users in Microsoft 365 by using Windows PowerShell * Manage groups in Microsoft 365 by using Windows PowerShell * Manage roles in Microsoft 365 by using Windows PowerShell * Manage licenses in Microsoft 365 by using Windows PowerShell 34 - MANAGE EXCHANGE ONLINE BY USING WINDOWS POWERSHELL * Connect to Exchange Online by using Windows PowerShell * Manage mailboxes in Exchange Online by using Windows PowerShell * Manage resources in Exchange Online by using Windows PowerShell * Manage admin roles in Exchange Online by using Windows PowerShell 35 - MANAGE SHAREPOINT ONLINE BY USING WINDOWS POWERSHELL * Install and connect to SharePoint Online Management Shell by using Windows PowerShell * Manage SharePoint Online users and groups by using Windows PowerShell * Manage SharePoint sites by using Windows PowerShell * Manage SharePoint Online external user sharing by using Windows PowerShell 36 - MANAGE MICROSOFT TEAMS BY USING WINDOWS POWERSHELL * Review Microsoft Teams PowerShell module * Install the Microsoft Teams PowerShell module * Manage teams with Microsoft Teams PowerShell module 37 - CREATE AND MANAGE BACKGROUND JOBS USING WINDOWS POWERSHELL * Define the types of background jobs in Windows PowerShell * Start remote jobs and CIM/WMI jobs in Windows PowerShell * Monitor jobs in Windows PowerShell * Retrieve results for running jobs in Windows PowerShell 38 - CREATE AND MANAGE SCHEDULED JOBS USING WINDOWS POWERSHELL * Create and run Windows PowerShell scripts as scheduled tasks * Define scheduled jobs in Windows PowerShell * Create job option and job trigger objects in Windows PowerShell * Create and register a scheduled job in Windows PowerShell * Retrieve the results from a scheduled job in Windows PowerShell

This workshop has been designed to help you to apply the principles of emotional intelligence with world-renowned coaching models to enable others to achieve greater results. By increasing your coaching skills you will find ways of developing others in a way that maintains a trusted relationship, engenders change and promotes personal accountability.

Duration 3 Days 18 CPD hours This course is intended for This course is designed for software developers, testers, and architects who design and develop software in various programming languages and platforms, including desktop, web, cloud, and mobile, and who want to improve their ability to deliver software that is of high quality, particularly regarding security and privacy. This course is also designed for students who are seeking the CertNexus Cyber Secure Coder (CSC) Exam CSC-210 certification Overview In this course, you will employ best practices in software development to develop secure software.You will: Identify the need for security in your software projects. Eliminate vulnerabilities within software. Use a Security by Design approach to design a secure architecture for your software. Implement common protections to protect users and data. Apply various testing methods to find and correct security defects in your software. Maintain deployed software to ensure ongoing security... The stakes for software security are very high, and yet many development teams deal with software security only after the code has been developed and the software is being prepared for delivery. As with any aspect of software quality, to ensure successful implementation, security and privacy issues should be managed throughout the entire software development lifecycle. This course presents an approach for dealing with security and privacy throughout the entire software development lifecycle. You will learn about vulnerabilities that undermine security, and how to identify and remediate them in your own projects. You will learn general strategies for dealing with security defects and misconfiguration, how to design software to deal with the human element in security, and how to incorporate security into all phases of development. IDENTIFYING THE NEED FOR SECURITY IN YOUR SOFTWARE PROJECTS * Identify Security Requirements and Expectations * Identify Factors That Undermine Software Security * Find Vulnerabilities in Your Software * Gather Intelligence on Vulnerabilities and Exploits HANDLING VULNERABILITIES * Handle Vulnerabilities Due to Software Defects and Misconfiguration * Handle Vulnerabilities Due to Human Factors * Handle Vulnerabilities Due to Process Shortcomings DESIGNING FOR SECURITY * Apply General Principles for Secure Design * Design Software to Counter Specific Threats DEVELOPING SECURE CODE * Follow Best Practices for Secure Coding * Prevent Platform Vulnerabilities * Prevent Privacy Vulnerabilities IMPLEMENTING COMMON PROTECTIONS * Limit Access Using Login and User Roles * Protect Data in Transit and At Rest * Implement Error Handling and Logging * Protect Sensitive Data and Functions * Protect Database Access TESTING SOFTWARE SECURITY * Perform Security Testing * Analyze Code to find Security Problems * Use Automated Testing Tools to Find Security Problems MAINTAINING SECURITY IN DEPLOYED SOFTWARE * Monitor and Log Applications to Support Security * Maintain Security after Deployment

PYTHON BASICS: COURSE DESCRIPTION Excellent for beginners, practical, in small groups of max 4 people, 1 Day Online Instructor-led. You could contact us for your prefereed date. Session 1: Python Data Types and Variables: * Primitive types; Characters & Strings; Boolean; Working with variables and its scope; Conversion and casting types in Python. * Operators and Expressions: * Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators.. * Exercise: Calculate Movie Tickets for a Party, Are there enough seats in the cinema? Decision Making & Loops * If statement; If - else statement; If- elif - else statement; Nested if - else; * Exercise: Calculate the travel fee to deliver goods * The while, For loop * Jump statements: break, continue; * Nesting loops. * Exercise: Enter a password, if incorrect 3 times, you are blocked. Session 2: Data Structures * Lists. * Tuples. * Exercise: Hangman Game * Exercise: Get a word for the game from a Json File, store the high score in a Dictionary file Session 3: Files and exceptions * Exception Handling, Exception types; Using try and Except. * Files, streams: Open, Traverse, Read and Create Files: Csv, txt and Json Files. * API: Connecting to API’s. Session 4: OOP * Creating and using custom Functions. * Using parameters and return values. * Creating a Class; Creating an Object; Using an Object; Adding Instance variables; * Class Constructors; Parameterized Constructors. * Inheritance. Override. Session 5: Pandas Dataframe Basics * Getting data into a dataframe: Dict to Dataframe, Dataframe to Dict. Excel To Dict, Dict to Excel , working with Excel data, multiple Excel sheets. * Getting information about the dataframe, * Filter, sort and query a Dataframes, Slicing Dataframes, * Duplicate values,Working with null-values, Sampling. * Exercise: Query the top 1000 grossing movies of the last century Session 6: Built in Functions: String, Math, Random * Python built-in functions: * Strings functions. Maths functions. Random Functions. * Exercise: Find information in prose, to get the sentiment of the prose. * Exercise: Get a word for the game from a txt File * Exercise: Win the lottery INCLUDED: * PCWorkshops's Python Programming Basics Certification * Course notes, exercises and code examples * Revision session after the course -------------------------------------------------------------------------------- REFUND POLICY No Refunds

Python coding, interactive, instructor-led, hands-on, practical. From basics to working with professionals. Python Part Time. Python Coding. -------------------------------------------------------------------------------- Python Beginners Evenings Course COURSE SUMMARY This Python Programming course has become essential to all professional who would like to do code using Python. Learn evenings, work while studying. Work and study Python Part Time. It is a Python beginners course and teaches Python coding from scratch to intermediate. Hands-on, practical. We code some real life examples in this course. Duration: 3 Evenings, once per week for 3 weeks 6pm-8pm, of which the first date only shows on the booking. Virtual Classroom: You could attend in our classroom, or attend online via virtual classroom, by select the appropriate ticket. Who Should Attend? This course is intended for beginner programmers who need to code in Python. Fast-paced, Quite intensive. Course Outline: Session 1: Basics * Python Data Types, Variables, * Operators and Expressions: Arithmetic operators; Relational operators; Assignment operator; Logical operators. * Decision Making: If statement; If - else statement; If- elif - else statement; Nested if - else; * Using Loops: The while, while-else; do-while and the for loop; Enhanced for loop; Jump statements: break, continue; Nesting loops. Session 2: Lists. Dictionaries, Json * Python Data Structures: Lists. Data Structures: 2-d Lists, Tuples. Dictionary, Nested Disctionary. Session 3: Built-in functions: * Python Date Functions. Random. Math Functions. String Functions. Python Regex. Session 4: Database: * Connect to a database, create Database, create a table, insert, delete, update records, query a database and display results. Drop database, drop table. Session 5: Files * Exception Handling in Python: Fundamentals of exception handling; Exception types; Using try and except. * Files, streams: Create, Open, Traverse and Read Files: Csv, txt and Json Files. * API: Connecting to API’s Session 6: M ethods, Classes and Objects * Creating and using Function, Working with parameters, Calling functions. * Object-Oriented Programming (OOP) principles. Modules and Classes, Creating an Object; Using an Object; Adding Instance variables; Controlling accessibility; Naming conventions for class member.s FAQ Do I need Python on my Laptop? Ideally spoken yes, but if not possible, you could use our online platform. Can I pay by BACS? Yes, simply email us, a Python course consultant will contact you. training@pcworkshopslondon.co.uk or pcworkshopslondon@gmail.com Can I pay with PayPal? Yes, simply email us, a course consultant will contact you. training@pcworkshopslondon.co.uk or pcworkshopslondon@gmail.com Do I get an invoice? Yes, on request. Can I pay with a PO (Purchase Order Number)? Yes, simply email us, a Python course consultant will contact you. training@pcworkshopslondon.co.uk or pcworkshopslondon@gmail.com Do I get a certificate? Yes, a PCWorkshops Certificate Can I attend in classroom? Yes, on request, and it would incur an additional charge, depending on your location. We have offices in London, Manchester, Birmingham, Portmouth, Southend-on-Sea, Milton Keynes. Can beginners follow this course? Yes, this is a Python beginner friendly course. We offer Python courses with max 4 people, so we make sure each delegates fully understand the material covered Can I customise the course? Yes, all our Python courses are customisable. We can customise the dates, times, location. course outline. -------------------------------------------------------------------------------- REFUND POLICY No Refunds

Learn the essentials of software development. And increase your confidence when working with developers. Why take this course? * Talk with confidence about web and internet technologies * Build better relationships with developers on your team * Create smarter designs with a deeper understanding of technical constraints * Understand the concepts behind coding without needing to code -------------------------------------------------------------------------------- Who is it for? All UX professionals Format Online, self-paced Duration 6 weeks (recommended) Commitment 3 hours per week -------------------------------------------------------------------------------- What you’ll learn Over 6 weeks, you’ll learn about the key concepts and processes involved in software development. You'll understand how code works, so that you can collaborate more effectively with developers. Module 1 The software landscape Understand the relationship between hardware and software. Module 2 Layers of software Dig into each layer of the tech stack, from the front-end to the back-end. Module 3 Front-end technologies Get up to speed on the roles of HTML, CSS and Javascript. Module 4 Back-end technologies Explore the back-end, APIs and common programming languages. Module 5 How developers work Learn about common development workflows, from waterfall to agile. Module 6 Effective collaboration Get practical guidance on how to work well with development teams.

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

This Python BootCamp is Instructor-led, Practical. In the12-week Python course, learn start to in-depth, leading to a good Python career. -------------------------------------------------------------------------------- PYTHON BOOTCAMP: This 12-week Python Boot Camp is a practical, instructor-lead program, covering Python from start to in-depth. You will be fully fluent and confident as a Python programmer. If you have more questions goto https://pcworkshopslondon.co.uk/contact.html  [http://pcworkshopslondon.co.uk/contact.html], Or contact us on training@pcworkshopslondon.co.uk [https://pcworkshopslondon.co.uk/] Customise dates, course outline, arrange installments [https://pcworkshopslondon.co.uk/contact.htm] This course will give you enough practical experience and practical projects to code, to give you full confidence to enter into the coding profession.    Duration: 3 months: * 1 Python class per week, * Plus pratical work, * Plus personal trainer-mentor for 1-1 training, * Plus e-learning materials. Final project : Practical to upload to GitHub and show-case Date and times, choose: * Fridays in London or Online , 10am - 5pm, * or Saturdays in London or Online , 12noon-6pm, * or negotiate your date Study level: Start from beginners level to in-depth, ready to work professionally. Virtual attendance:  online instructor-led  Download: Anaconda.com Pre-requisites: General computer literacy. Oracle Qualification: PCWorkshops Python Programmer Certificate Payments:  You may apply to pay in installments for this Python Training course COURSE OUTLINE Week 1 - 4: Essentials 1. Python Coding Basics 2. Object Oriented programming: Python Object Orientated programming (OOP) 3. UX Principles: UX Principles and applying it on Front-ends with TKinter 4. Specialised topics: Dates, Localization, Strings, Maths Operation , Random Number, Lambdas Week 5 - 10 : All about data 1. Python Data Structures: Lists, Tuples, Sets, Exceptions, I/O Fundamentals , Reading and Writing file 2. Database: Database principles and SQL. Database Project: Python database connections and creating a database driven project 3. Data Analytics: Numpy. Pandas for data analytics and data queries. 4. Data Analytics: Pandas data cleaning and restructuring, interacticting with Excel, Csv, Json,etc. 5. Data visualisation: MatPlotLib 6. Prediction: Machine Learning Basics Week 11 and 12: The final touch 1. Python Concurrency and Multi-threading: Threads vs. Processes, Threading Module, Threading Event, Stop a Thread, Daemon Threads, Thread-safe Queue, Thread Pools, Locks 2. Python Unit Testing 3. Optional : Replace Week 11 or 12 with Scraping using Python, ot Tkinter Front-ends INCLUDED: * PCWorkshops Python Course Certificate on completion. * Python Course notes. * Practical Course exercises, Code Examples, Online Materials. * After the course, continuous assistance with practical and preparation for exams * Max group size on this is 4. * Portfolio: Post your Python project online. * Exam preparation and interview questions MORE ABOUT THE ONLINE CLASSROOM *  Attend from your internet connection *  Instructor-led, get instant answers to your questions *  Fully interactive *  Work clearly explained with demonstrations and examples *  Practical exercises to be tried out by delegate WHAT YOU WILL GAIN: * Skills & knowledge: Python coding knowledge and understanding with good practical application   * Certification: Internal PCWorkshops Python certificate * Portfolio: You will have an online portfolio of Python projects  * Experience: Our comprehensive practical makes you job ready -------------------------------------------------------------------------------- REFUND POLICY No Refunds