2434 Programming courses

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

Learning Outcomes After completing this course, learners will be able to: Learn Python for data analysis using NumPy and Pandas Acquire a clear understanding of data visualisation using Matplotlib, Seaborn and Pandas Deepen your knowledge of Python for interactive and geographical potting using Plotly and Cufflinks Understand Python for data science and machine learning Get acquainted with Recommender Systems with Python Enhance your understanding of Python for Natural Language Processing (NLP) Description Whether you are from an engineering background or not you still can efficiently work in the field of data science and the machine learning sector, if you have proficient knowledge of Python. Since Python is the easiest and most used programming language, you can start learning this language now to advance your career with the Data Science And Machine Learning Using Python : A Bootcamp course. This course will give you a thorough understanding of the Python programming language. Moreover, it will show how can you use Python for data analysis and machine learning. Alongside that, from this course, you will get to learn data visualisation, and interactive and geographical plotting by using Python. The course will also provide detailed information on Python for data analysis, Natural Language Processing (NLP) and much more. Upon successful completion of this course, get a CPD- certificate of achievement which will enhance your resume and career. Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment After completing this course, you will be provided with some assessment questions. To pass that assessment, you need to score at least 60%. Our experts will check your assessment and give you feedback accordingly. Career Path After completing this course, you can explore various career options such as Web Developer Software Engineer Data Scientist Machine Learning Engineer Data Analyst In the UK professionals usually get a salary of £25,000 - £30,000 per annum for these positions. Course Content Welcome, Course Introduction & overview, and Environment set-up Welcome & Course Overview 00:07:00 Set-up the Environment for the Course (lecture 1) 00:09:00 Set-up the Environment for the Course (lecture 2) 00:25:00 Two other options to setup environment 00:04:00 Python Essentials Python data types Part 1 00:21:00 Python Data Types Part 2 00:15:00 Loops, List Comprehension, Functions, Lambda Expression, Map and Filter (Part 1) 00:16:00 Loops, List Comprehension, Functions, Lambda Expression, Map and Filter (Part 2) 00:20:00 Python Essentials Exercises Overview 00:02:00 Python Essentials Exercises Solutions 00:22:00 Python for Data Analysis using NumPy What is Numpy? A brief introduction and installation instructions. 00:03:00 NumPy Essentials - NumPy arrays, built-in methods, array methods and attributes. 00:28:00 NumPy Essentials - Indexing, slicing, broadcasting & boolean masking 00:26:00 NumPy Essentials - Arithmetic Operations & Universal Functions 00:07:00 NumPy Essentials Exercises Overview 00:02:00 NumPy Essentials Exercises Solutions 00:25:00 Python for Data Analysis using Pandas What is pandas? A brief introduction and installation instructions. 00:02:00 Pandas Introduction 00:02:00 Pandas Essentials - Pandas Data Structures - Series 00:20:00 Pandas Essentials - Pandas Data Structures - DataFrame 00:30:00 Pandas Essentials - Handling Missing Data 00:12:00 Pandas Essentials - Data Wrangling - Combining, merging, joining 00:20:00 Pandas Essentials - Groupby 00:10:00 Pandas Essentials - Useful Methods and Operations 00:26:00 Pandas Essentials - Project 1 (Overview) Customer Purchases Data 00:08:00 Pandas Essentials - Project 1 (Solutions) Customer Purchases Data 00:31:00 Pandas Essentials - Project 2 (Overview) Chicago Payroll Data 00:04:00 Pandas Essentials - Project 2 (Solutions Part 1) Chicago Payroll Data 00:18:00 Python for Data Visualization using matplotlib Matplotlib Essentials (Part 1) - Basic Plotting & Object Oriented Approach 00:13:00 Matplotlib Essentials (Part 2) - Basic Plotting & Object Oriented Approach 00:22:00 Matplotlib Essentials (Part 3) - Basic Plotting & Object Oriented Approach 00:22:00 Matplotlib Essentials - Exercises Overview 00:06:00 Matplotlib Essentials - Exercises Solutions 00:21:00 Python for Data Visualization using Seaborn Seaborn - Introduction & Installation 00:04:00 Seaborn - Distribution Plots 00:25:00 Seaborn - Categorical Plots (Part 1) 00:21:00 Seaborn - Categorical Plots (Part 2) 00:16:00 Seborn-Axis Grids 00:25:00 Seaborn - Matrix Plots 00:13:00 Seaborn - Regression Plots 00:11:00 Seaborn - Controlling Figure Aesthetics 00:10:00 Seaborn - Exercises Overview 00:04:00 Seaborn - Exercise Solutions 00:19:00 Python for Data Visualization using pandas Pandas Built-in Data Visualization 00:34:00 Pandas Data Visualization Exercises Overview 00:03:00 Panda Data Visualization Exercises Solutions 00:13:00 Python for interactive & geographical plotting using Plotly and Cufflinks Plotly & Cufflinks - Interactive & Geographical Plotting (Part 1) 00:19:00 Plotly & Cufflinks - Interactive & Geographical Plotting (Part 2) 00:14:00 Plotly & Cufflinks - Interactive & Geographical Plotting Exercises (Overview) 00:11:00 Plotly & Cufflinks - Interactive & Geographical Plotting Exercises (Solutions) 00:37:00 Capstone Project - Python for Data Analysis & Visualization Project 1 - Oil vs Banks Stock Price during recession (Overview) 00:15:00 Project 1 - Oil vs Banks Stock Price during recession (Solutions Part 1) 00:18:00 Project 1 - Oil vs Banks Stock Price during recession (Solutions Part 2) 00:18:00 Project 1 - Oil vs Banks Stock Price during recession (Solutions Part 3) 00:17:00 Project 2 (Optional) - Emergency Calls from Montgomery County, PA (Overview) 00:03:00 Python for Machine Learning (ML) - scikit-learn - Linear Regression Model Introduction to ML - What, Why and Types.. 00:15:00 Theory Lecture on Linear Regression Model, No Free Lunch, Bias Variance Tradeoff 00:15:00 scikit-learn - Linear Regression Model - Hands-on (Part 1) 00:17:00 scikit-learn - Linear Regression Model Hands-on (Part 2) 00:19:00 Good to know! How to save and load your trained Machine Learning Model! 00:01:00 scikit-learn - Linear Regression Model (Insurance Data Project Overview) 00:08:00 scikit-learn - Linear Regression Model (Insurance Data Project Solutions) 00:30:00 Python for Machine Learning - scikit-learn - Logistic Regression Model Theory: Logistic Regression, conf. mat., TP, TN, Accuracy, Specificityetc. 00:10:00 scikit-learn - Logistic Regression Model - Hands-on (Part 1) 00:17:00 scikit-learn - Logistic Regression Model - Hands-on (Part 2) 00:20:00 scikit-learn - Logistic Regression Model - Hands-on (Part 3) 00:11:00 scikit-learn - Logistic Regression Model - Hands-on (Project Overview) 00:05:00 scikit-learn - Logistic Regression Model - Hands-on (Project Solutions) 00:15:00 Python for Machine Learning - scikit-learn - K Nearest Neighbors Theory: K Nearest Neighbors, Curse of dimensionality . 00:08:00 scikit-learn - K Nearest Neighbors - Hands-on 00:25:00 scikt-learn - K Nearest Neighbors (Project Overview) 00:04:00 scikit-learn - K Nearest Neighbors (Project Solutions) 00:14:00 Python for Machine Learning - scikit-learn - Decision Tree and Random Forests Theory: D-Tree & Random Forests, splitting, Entropy, IG, Bootstrap, Bagging. 00:18:00 scikit-learn - Decision Tree and Random Forests - Hands-on (Part 1) 00:19:00 scikit-learn - Decision Tree and Random Forests (Project Overview) 00:05:00 scikit-learn - Decision Tree and Random Forests (Project Solutions) 00:15:00 Python for Machine Learning - scikit-learn -Support Vector Machines (SVMs) Support Vector Machines (SVMs) - (Theory Lecture) 00:07:00 scikit-learn - Support Vector Machines - Hands-on (SVMs) 00:30:00 scikit-learn - Support Vector Machines (Project 1 Overview) 00:07:00 scikit-learn - Support Vector Machines (Project 1 Solutions) 00:20:00 scikit-learn - Support Vector Machines (Optional Project 2 - Overview) 00:02:00 Python for Machine Learning - scikit-learn - K Means Clustering Theory: K Means Clustering, Elbow method .. 00:11:00 scikit-learn - K Means Clustering - Hands-on 00:23:00 scikit-learn - K Means Clustering (Project Overview) 00:07:00 scikit-learn - K Means Clustering (Project Solutions) 00:22:00 Python for Machine Learning - scikit-learn - Principal Component Analysis (PCA) Theory: Principal Component Analysis (PCA) 00:09:00 scikit-learn - Principal Component Analysis (PCA) - Hands-on 00:22:00 scikit-learn - Principal Component Analysis (PCA) - (Project Overview) 00:02:00 scikit-learn - Principal Component Analysis (PCA) - (Project Solutions) 00:17:00 Recommender Systems with Python - (Additional Topic) Theory: Recommender Systems their Types and Importance 00:06:00 Python for Recommender Systems - Hands-on (Part 1) 00:18:00 Python for Recommender Systems - - Hands-on (Part 2) 00:19:00 Python for Natural Language Processing (NLP) - NLTK - (Additional Topic) Natural Language Processing (NLP) - (Theory Lecture) 00:13:00 NLTK - NLP-Challenges, Data Sources, Data Processing .. 00:13:00 NLTK - Feature Engineering and Text Preprocessing in Natural Language Processing 00:19:00 NLTK - NLP - Tokenization, Text Normalization, Vectorization, BoW. 00:19:00 NLTK - BoW, TF-IDF, Machine Learning, Training & Evaluation, Naive Bayes 00:13:00 NLTK - NLP - Pipeline feature to assemble several steps for cross-validation 00:09:00 Resources Resources - Data Science and Machine Learning using Python : A Bootcamp 00:00:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Start your journey with the Linux command line with zero knowledge. This course will start from scratch with instructions to install a Linux OS on a virtual machine and advance to higher-level concepts with no prior knowledge required.

Many organisations find that project teams struggle to create and maintain effective plans. Estimates are often overly optimistic and risks go unmanaged until the inevitable happens. Resource managers also find it hard to forecast the likely loading on their departments and requests for support are not provided in a consistent format. This programme has been developed to address these needs in a very practical, hands-on format. Case study work can be based on simulations or on the organisation's current projects for maximum benefit to participants. The aim of this training is to develop and enhance participants' planning and risk management skills in order to maximise the success of project work undertaken by the organisation. The principal training objectives for this programme are to: Provide a structured, integrated approach to planning and risk management Demonstrate practical tools and techniques for each stage of planning Show how to organise and involve relevant people in the planning process Explain how to use the plan for forecasting and pro-active project control Identify ways to improve planning, both individually and corporately The course will emphasise the importance of participative planning techniques that improve the quality of plans whilst reducing overall time and cost of planning. The course will encourage discussion of internal procedures and practices and may be customised to include them if required. DAY ONE 1 Introduction (Course sponsor) Why this programme has been developed Review of participants' needs and objectives 2 Projects and planning Why plan? The benefits of good planning / penalties of poor planning Planning in the project lifecycle; the need for a 'living' plan The interaction between target setting and the planning process Team exercise: planning the project 3 Planning the plan Defining the application and structure of the plan Impact of planning decisions during the project lifecycle Using available time to create an effective plan 4 Defining deliverables Assessing the context; reviewing the goals and stakeholders Developing the scope and defining deliverables; scope mapping Understanding customer priorities; delivering value for money Case study: defining the project deliverables 5 Creating the work breakdown Building the work breakdown structure Detailing the tasks and sub-tasks; structured brainstorming Defining task ownership; the task responsibility matrix 6 Creating and using a logical network Developing the logical network; task boarding Determining the critical path and calculating float Accelerating the plan; concurrent programming and risk Individual and group exercises DAY TWO 7 Developing resource schedules Deriving the Gantt chart from the network Developing the detailed resource schedules Calculating the expenditure profile ('S' curve) 8 Estimating task durations and costs Understanding estimates: effort, availability and duration Estimating tools and techniques Application of estimating techniques during the project lifecycle 9 Case study Developing the project plan Refining the project plan Team presentations and discussion 10 Managing risks and refining the plan Awareness of contractual issues associated with risk Identifying and evaluating risks; deciding ownership Managing risks: determining levels of provision and contingency Controlling risks: maintaining an up-to date risk register 11 Planning for pro-active control The earned value analysis (EVA) concept and its predictive value Deriving the measures needed for cost and delivery performance Practical issues associated with implementing EVA 12 Using and maintaining the plan Tracking progress and updating the plan Publishing and controlling the plan 13 Course review and transfer planning (Course sponsor present) Identify ways of implementing the techniques learnt Sponsor-led review and discussion of proposals Conclusion

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

Based in London, UK Creature Courage is the UK's animal phobia expert, get over your animal phobia in a fun way in just one afternoon!

Through this course, you will learn how to arrange Kafka a producer and consumer and Kafka Streams and Connectors accurately. You will also gain the skills needed to coordinate Kafka with existing application stages and to pass the Apache Kafka certification exam.

Course Overview Peek into the world of data science and machine learning with the comprehensive Data Science & Machine Learning With R in 2021 course. This course will provide you with a detailed understanding of both machine learning and data science. In addition, you will acquire essential skills to pursue a career in this growing industry. The Data Science & Machine Learning With R in 2021 course will teach you the core concept of data science. You will be able to recognize different data types and structures. From the modules, you will receive an introduction to the intermediate R Section. The course will show you the techniques of data manipulation in R. You will know the process of data visualization with R and learn to create reports with R markdown. The Data Science & Machine Learning With R in 2021 course will provide you with an insight into the fundamentals of machine learning. You will understand the principles of data processing, linear regression, logistic regression and more.  This highly informative Data Science & Machine Learning With R in 2021 course will equip you with the essential skills of data science. If you desire to become a professional data scientist, this course can be your stepping stone. So, enroll in the course and fast track your career. Learning Outcomes Learn the definition of data science Understand the basics of machine learning Enrich your knowledge of data types and structures Know the process of data manipulation in R Gain the ability to create reports with R markdown Become skilled in building web apps with R shiny Who is this course for? Aspiring data scientists or individuals interested in learning data science and machine learning  Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £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/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path  The Data Science & Machine Learning With R in 2021 course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Data Scientist Data Science and Machine Learning Course Intro Data Science and Machine Learning Introduction 00:03:00 What is Data Science 00:10:00 Machine Learning Overview 00:05:00 Who is This Course for 00:03:00 Data Science and Machine Learning Marketplace 00:05:00 Data Science and Machine Learning Job Opportunities 00:03:00 Data Types and Structures in R Getting Started 00:16:00 Basics 00:06:00 Files 00:11:00 RStudio 00:07:00 Tidyverse 00:05:00 Resources 00:04:00 Data Types and Structures in R Unit Introduction 00:30:00 Basic Type 00:09:00 Vector Part One 00:20:00 Vectors Part Two 00:25:00 Vectors - Missing Values 00:16:00 Vectors - Coercion 00:14:00 Vectors - Naming 00:10:00 Vectors - Misc 00:06:00 Creating Matrics 00:31:00 List 00:32:00 Introduction to Data Frames 00:19:00 Creating Data Frames 00:20:00 Data Frames: Helper Functions 00:31:00 Data Frames Tibbles 00:39:00 Intermediate R Intermediate Introduction 00:47:00 Relational Operations 00:11:00 Conditional Statements 00:11:00 Loops 00:08:00 Functions 00:14:00 Packages 00:11:00 Factors 00:28:00 Dates and Times 00:30:00 Functional Programming 00:37:00 Data Import or Export 00:22:00 Database1 00:27:00 Data Manipulation in R Data Manipulation in R Introduction 00:36:00 Tidy Data 00:11:00 The Pipe Operator 00:15:00 The Filter Verb 00:22:00 The Select Verb 00:46:00 The Mutate Verb 00:32:00 The Arrange Verb 00:10:00 The Summarize Verb 00:23:00 Data Pivoting 00:43:00 JSON Parsing 00:11:00 String Manipulation 00:33:00 Web Scraping 00:59:00 Data Visualization in R Data Visualization in R Section Intro 00:17:00 Getting Started 00:16:00 Aesthetics Mappings 00:25:00 Single Variable Plots 00:37:00 Two Variable Plots 00:21:00 Facets, Layering, and Coordinate Systems 00:18:00 Styling and Saving 00:12:00 Creating Reports with R Markdown Creating with R Markdown 00:29:00 Building Webapps with R Shiny Introduction to R Shiny 00:26:00 A Basic R Shiny App 00:31:00 Other Examples with R Shiny 00:34:00 Introduction to Machine Learning Machine Learning Part 1 00:22:00 Machine Learning Part 2 00:47:00 Starting A Career in Data Science Starting a Data Science Career Section Overview 00:03:00 Data Science Resume 00:04:00 Getting Started with Freelancing 00:05:00 Top Freelance Websites 00:05:00 Personal Branding 00:05:00 Importance of Website and Blo 00:04:00 Networking Do's and Don'ts 00:04:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Welcome to Microsoft sql server development for everyone Course. The world of data is a vast and complex one. But with the right tools, it can be yours to explore. SQL Server is one of those tools. It's a powerful database management system that can help you store, manage, and analyse data in ways that were never before possible.   In this Microsoft SQL Server Development for Everyone! course, you'll learn the basics of SQL Server development. You'll learn how to create and manage databases, tables, and data. You'll also learn how to write SQL queries to manipulate data.   Starting with a solid Introduction to SQL, you'll grasp core concepts and gain a strong foundation. We'll then dive into Manipulating Tables and Data, equipping you with effective skills for storing, retrieving, updating, and deleting information.   But we won't stop there! Our in-depth exploration of Relationships and Foreign Keys will ensure you understand the importance of data integrity and how to establish connections between tables. You'll create robust and reliable databases with enforced referential integrity. Next, we'll empower you with the tools of Group By and Aggregate Functions, enabling efficient data analysis and summarisation. Extracting meaningful insights from vast amounts of information will become second nature to you.   To become a well-rounded SQL Server developer, we'll conclude the course with Advanced SQL Server Objects and Concepts. You'll gain a deep understanding of essential elements like stored procedures, views, triggers, and indexes. This knowledge will optimise performance and streamline your development process.   By the end of this Microsoft SQL Server Development for Everyone! course, you'll have a strong understanding of how to use SQL Server to manage and manipulate data. You'll be able to build powerful applications that make better decisions. Become a sought-after SQL Server developer and master the art of data management. Join us today and unlock your data-driven potential!   Learning Outcomes: Through this comprehensive course, you should be able to:   Understand core concepts and gain a strong foundation in SQL Server development. Acquire skills to effectively manipulate tables and data. Establish relationships and enforce data integrity using foreign keys. Utilise group by and aggregate functions for efficient data analysis. Explore advanced SQL Server objects and concepts like stored procedures and views. Gain proficiency in implementing triggers and optimising database performance. Develop the ability to create robust and reliable databases.   Who is this course for? This Microsoft SQL Server Development for Everyone! course is perfect for:   Aspiring developers looking to enhance their programming skills. Professionals seeking to expand their knowledge of SQL Server development. Individuals interested in exploring the world of databases and data management. Students or graduates pursuing a career in database administration or development. Curious learners eager to harness the power of SQL Server.   Career Path Our course will help you to pursue a range of careers, including:   Database Administrator: £25,000 - £60,000 per year. SQL Developer: £30,000 - £65,000 per year. Data Analyst: £25,000 - £55,000 per year. Business Intelligence Developer: £35,000 - £70,000 per year. Software Engineer: £30,000 - £70,000 per year. Data Engineer: £40,000 - £80,000 per year. Database Architect: £45,000 - £90,000 per year. Certification After studying the course materials of the Microsoft SQL Server Development for Everyone! there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Prerequisites This Microsoft SQL Server Development for Everyone! does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft SQL Server Development for Everyone! 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 Introduction Introduction to SQL Server and Databases 00:04:00 Download and Install SQL Server Express 00:05:00 Manipulating Tables and Data Connect to Database Instance and Create a Database 00:06:00 Drop or Remove Database 00:04:00 What is a Database Table? 00:02:00 Create an SQL Database Table 00:32:00 Insert Data into the Table with SQL Script 00:15:00 Insert Data into the Table with Management Studio 00:05:00 Select Data from the Table with SQL Script 00:09:00 More Advanced Select Queries Part 1 00:18:00 Update Data in the Table 00:10:00 Update Data in the Table with Management Studio GUI 00:02:00 Delete Data from the Table with SQL Script 00:06:00 Delete Data from the Table with Management Studio GUI 00:01:00 Relationships and Foreign Keys What are Relationships, Foreign Keys and Normalization 00:11:00 Create a Relationship in SQL Server 00:19:00 Insert Records in Related Tables 00:13:00 Run Queries on Related Tables 00:19:00 Left, Right and Full Joins 00:11:00 Group By and Aggregate Functions Grouping Data using SQL GROUP BY Clause 00:12:00 SQL AVG Aggregate Function 00:11:00 SQL COUNT Aggregate Function 00:04:00 SQL MAX and MIN Aggregate Functions 00:04:00 SQL SUM Aggregate Function 00:04:00 Advanced SQL Server Objects and Concepts Create and Manage Views 00:23:00 Scalar Valued Functions 00:27:00 Inline Table Valued Functions 00:09:00 Multi Statement Table Valued Functions 00:12:00 Stored Procedures 00:28:00 Table Triggers 00:19:00 Database Scripting, Backup and Restore 00:15:00 Assignment Assignment - Microsoft SQL Server Development for Everyone! 00:00:00

Duration 5 Days 30 CPD hours This course is intended for To fully benefit from this course, you should have three to five years of experience designing and implementing applications that are built on top of Cisco platforms. This course is appropriate for: Network engineers expanding their skill-base to include software and automation Developers expanding expertise in automation and DevOps Solution architects moving to the Cisco ecosystem Infrastructure developers designing hardened production environments The job roles best suited to the material in this course are: Senior network automation engineer Senior software developer Senior system integration programmer Additional job roles that could find this course useful are: Senior infrastructure architect Senior network designer Senior test development engineer Students preparing for Cisco Certified DevNet Professional and Cisco Certified DevNet Specialist - Core certification will also find this material useful. Overview After taking this course, you should be able to: Describe the architectural traits and patterns that improve application maintainability Describe the architectural traits and patterns that improve application serviceability Identify steps to design and build a ChatOps application Implement robust Representational State Transfer (REST) API integrations with network error handling, pagination, and error flow control Describe the necessary steps for securing user and system data in applications Describe the necessary steps for securing applications Identify common tasks in automated application release process Describe best practices for application deployment Describe methodologies for designing distributed systems Describe the concepts of infrastructure configuration management and device automation Utilize Yet Another Next Generation (YANG) data models to describe network configurations and telemetry Compare various relational and nonrelational database types and how to select the appropriate type based on requirements In this course, you will learn how to implement network applications using Cisco© platforms as a base, from initial software design to diverse system integration, as well as testing and deployment automation. The course gives you hands-on experience solving real world problems using Cisco Application Programming Interfaces (APIs) and modern development tools. This course helps you prepare for Cisco DevNet Professional certification and for professional-level network automation engineer roles. COURSE OUTLINE DESIGNING FOR MAINTAINABILITY (SELF-STUDY) DESIGNING FOR SERVICEABILITY (SELF-STUDY) IMPLEMENTING CHATOPS APPLICATION DESCRIBING ADVANCED REST API INTEGRATION SECURING APPLICATION DATA (SELF-STUDY) SECURING WEB AND MOBILE APPLICATIONS (SELF-STUDY) AUTOMATING APPLICATION-RELEASE DEPLOYING APPLICATIONS UNDERSTANDING DISTRIBUTED SYSTEMS ORCHESTRATING NETWORK AND INFRASTRUCTURE MODELING DATA WITH YANG USING RELATIONAL AND NON-RELATIONAL DATABASES (SELF-STUDY) PLEASE NOTE:This class includes lecture sections and self-study sections. In instructor-led classes, lectures are delivered in real-time, either in person or via video conferencing. In e-learning courses, the lectures are on recorded videos. In both versions, you will need to review self-study sections on your own before taking the certification exam. Additional course details: Nexus Humans Cisco Developing Applications Using Cisco Core Platforms and APIs v1.0 (DEVCOR) 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 Cisco Developing Applications Using Cisco Core Platforms and APIs v1.0 (DEVCOR) 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.