Name: Python Data Science Courses
Price: 53 GBP
Availability: InStock

<p><strong></strong><strong> Boost Your Career By Enrolling In This IT Support Technician Bundle To Overcome Your Challenges!</strong><strong></strong></p><p><strong>07 </strong><strong>in 1 IT Support Technician Bundle </strong><strong></strong></p><p>Improve your knowledge and enhance your skills to succeed with this IT Support Technician bundle. This IT Support Technician bundle is designed to build your competent skill set and enable the best possible outcome for your future. Our bundle is ideal for those who aim to be the best in their fields and are always looking to grow.</p><p><strong>This IT Support Technician Bundle Contains 07 </strong><strong>of Our Premium Courses for One Discounted Price:</strong></p><ul><li><strong>Course 01: </strong>Learn Programming with Python <strong><br /></strong></li><li><strong>Course 02: </strong>Cloud Computing / CompTIA Cloud+ (CV0-002)</li><li><strong>Course 03: </strong>Mastering SQL Programming</li><li><strong>Course 04: </strong>IT: Ethical Hacking &amp; IT Security</li><li><strong>Course 05: </strong>CompTIA CySA+ Cybersecurity Analyst (CS0-002)<strong><br /></strong></li><li><strong>Course 06: </strong>Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</li><li><strong>Course 07: </strong>Building Your Computer Course<strong><br /></strong></li></ul><p>All the courses under this IT Support Technician bundle are split into a number of expertly created modules to provide you with an in-depth and comprehensive learning experience. Upon successful completion of the IT Support Technician bundle, an instant e-certificate will be exhibited in your profile that you can order as proof of your new skills and knowledge. Stand out from the crowd and get trained for the job you want.</p><p>With this comprehensive IT Support Technician bundle, you can achieve your dreams and train for your ideal career. This IT Support Technician bundle covers essential aspects in order to progress in your chosen career.</p><p><strong>Why Prefer Us?</strong></p><ul><li>All-in-one package of <strong>07 </strong>premium courses <strong>IT Support Technician </strong>bundle</li><li>Earn a certificate accredited by <strong>CPD. </strong></li><li><strong>Get a free student ID </strong>card<strong>! </strong>(£10 postal charges will be applicable for international delivery)</li><li>Globally accepted standard lesson planning</li><li>Free Assessments</li><li>24/7 tutor support.</li></ul> <p>Start your learning journey straightaway!</p><p><strong>*** Course Curriculum ***</strong></p><p>Our IT Support Technician bundle courses consist of the following learning modules:</p><p><strong> Course 01: Learn Programming with Python</strong></p><p><strong>Module 01:<br /></strong></p><ul><li>An Installing Python FREE</li><li>Documentation</li><li>Command Line</li><li>Variables</li><li>Simple Python Syntax</li><li>Keywords</li><li>Import-Module<strong><br /></strong></li></ul><p><strong>Module 02: <br /></strong></p><ul><li>Additional Topics</li><li>If Elif Else</li><li>Iterable</li><li>For</li><li>Loops</li><li>Execute</li><li>Exceptions</li></ul><p><strong>Module 03:<br /></strong></p><ul><li>Data Types</li><li>Number Types</li><li>More Number Types</li><li>Strings</li><li>More Strings</li><li>Files</li><li>Lists</li><li>Dictionaries</li><li>Tuples</li><li>Sets</li></ul><p><strong>Module 04:<br /></strong></p><ul><li>Comprehensions</li><li>Definitions</li><li>Functions</li><li>Default Arguments</li><li>Doc Strings</li><li>Variadic Functions</li><li>Factorial<strong><br /></strong></li></ul><p><strong>Module 05:<br /></strong></p><ul><li>Function Objects</li><li>Lambda</li><li>Generators</li><li>Closures</li><li>Classes</li><li>Object Initialization</li><li>Class Static Members</li><li>Classic Inheritance</li><li>Data Hiding</li></ul><p><strong>Assessment Process</strong></p><p>Once you have completed all the courses in the IT Support Technician bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards.</p> <h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        70 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div> <h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This IT Support Technician bundle is suitable for everyone.</p>
                        </div> <h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>You will not need any prior background or expertise.</p>
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>This IT Support Technician bundle will allow you to kickstart or take your career in the related sector to the next stage.</p>
                        </div> <h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Accredited Certificate by CPD QS</h4>
        <p>
            Digital certificate -
            £10
        </p>
            <div> <p>Upon passing the Bundle, you need to order to receive a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS</p> </div>
        <h4>Accredited Certificate by CPD QS</h4>
        <p>
            Hard copy certificate -
            £29
        </p>
            <div> <ul><li>Upon passing the Bundle, you need to order to receive a Hard copy Certificate for each of the courses inside this bundle.</li><li>If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.</li></ul> </div>

                        </div>

Academy for Health and Fitness

IT Support Technician Course - CPD Certified

General Admission

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p><span>Cloud Solutions Architects</span></p><br /><p><span> DevOps Engineers</span></p><br /><p><span> Individuals using Google Cloud Platform who deploy applications, monitor operations, and manage enterprise solutions</span></p><p></p>Overview<p></p><p><span>At course completion, you will have attained knowledge of:</span></p><br /><p><span>Fundamentals of Google Cloud Platform (GCP)</span></p><br /><p><span>Google Cloud Storage</span></p><br /><p><span>Google Compute Engine</span></p><br /><p><span>Google Cloud SQL</span></p><br /><p><span>Load Balancing (LB)</span></p><br /><p><span>Google Cloud Monitoring</span></p><br /><p><span>Auto-Scaling</span></p><br /><p><span>Virtual Private Cloud (VPC) Network</span></p><br /><p><span>Cloud Identity and Access Management (IAM)</span></p><br /><p><span>Cloud CDN and DNS</span></p><br /><p><span>Cloud VPN</span></p><br /><p><span>Google Cloud Deployment Manager</span></p><br /><p><span>Google Container Engine</span></p><br /><p><span>Cloud Run</span></p><br /><p><span>Cloud Bigtable</span></p><br /><p><span>Cloud Datastore</span></p><br /><p><span>Cloud BigQuery</span></p><br /><p><span>Cloud DataFlow</span></p><br /><p><span>Cloud DataProc</span></p><br /><p><span>Cloud Pub/Sub</span></p><p></p><p>In this course you will attain a deep knowledge of Google Cloud Platform infrastructure and design patterns on developing applications on GCP. This course will prepare you for the Google Cloud Architect Associate Certification Exam.</p></div><div id="course-pills-2"><h4>Fundamentals of Google Cloud Platform (GCP)</h4><ul><li>Overview</li><li>Regions and Zones</li><li>Review of major GCP services</li><li></li></ul><h4>Google Cloud Storage</h4><ul><li>Fundamental APIs</li><li>Consistency</li><li>Cloud Storage Namespace</li><li>Buckets and Objects</li><li>Bucket and Object Naming Guidelines</li><li>Encryption</li><li>Object Versioning</li><li>Object Lifecycle Management</li><li>Access Control</li><li>Access Control Lists</li><li>Signed URL</li><li>Multipart upload</li><li>Resumable upload</li><li>Understanding Pricing for Cloud Storage</li><li>Offline Media Import/Export</li><li>Architecture case study of common Use Cases of Google Cloud Storage</li><li>Hands-on: Cloud Storage Lab; Creating Buckets, objects, and managing access control</li><li></li></ul><h4>Google Compute Engine</h4><ul><li>Compute Engine Architecture</li><li>VM Instances types</li><li>Persistence Disks</li><li>Images</li><li>Generating Custom Images</li><li>IP Addresses</li><li>Static IPs</li><li>Ephemeral</li><li>Access Control Options</li><li>IAM</li><li>Service Account</li><li>Monitoring Instances with Google Cloud Monitoring</li><li>Compute Engine Networks and Firewalls</li><li>Hands-on: Hosting an Application on Compute Engine</li><li></li></ul><h4>Google Cloud SQL</h4><ul><li>Core advantages of Cloud SQL</li><li>Cloud SQL database instance types</li><li>Access Control</li><li>High availability options</li><li>Failover</li><li>Read replica</li><li>Backup options</li><li>On Demand</li><li>Automated</li><li>Understanding Pricing of Cloud SQL</li><li></li></ul><h4>Load Balancing (LB)</h4><ul><li>Fundamentals of a Load Balancer</li><li>Network Load balancing</li><li>HTTPS Load balancing</li><li>Cross region Load balancing</li><li>Content Load balancing</li><li>Target proxies</li><li>SSL Load Balancing</li><li>Internal Load Balancing</li><li>Network Load Balancing</li><li>Understanding Pricing for Load Balancer</li><li></li></ul><h4>Google Cloud Monitoring</h4><ul><li>Architecture of Cloud Monitoring</li><li>Supported metrics</li><li>Stackdriver Monitoring APIs</li><li></li></ul><h4>Auto-Scaling</h4><ul><li>Overview of Autoscaling</li><li>Auto-scaling Fundamentals</li><li>Instance groups</li><li>Templates</li><li>Policies</li><li>Decisions</li><li>Hands-on: Deploying a scale application on GCP using Autoscaling, Compute Engine, Cloud SQL, Load Balancers.</li><li></li></ul><h4>Virtual Private Cloud (VPC) Network</h4><ul><li>Salient features of Virtual Private Cloud (VPC) Network Infrastructure</li><li>Virtual Private Cloud (VPC) Networking Fundamentals</li><li>Subnetworks</li><li>Firewall</li><li>Internal DNS</li><li>Network Routes</li><li>Hands-on: Hosting Secure Applications in Google Cloud VPC Networks</li><li></li></ul><h4>Cloud Identity and Access Management (IAM)</h4><ul><li>Introduction</li><li>User and Service Accounts</li><li>IAM Roles</li><li>Policy</li><li>Hands-on: Managing Users, Policies and Granting Roles using Service Accounts</li><li></li></ul><h4>Cloud CDN and DNS</h4><ul><li>What is CDN</li><li>Google Cloud CDN</li><li>Cloud CDN Concepts</li><li>Some of the Cloud CDN Edge locations</li><li>Cloud DNS</li><li>Cloud DNS Terminologies</li><li>Supported Record Types</li><li>Hands-on: Moving an Existing Domain Name to Cloud DNS</li><li></li></ul><h4>Cloud VPN</h4><ul><li>Cloud VPN overview</li><li>Types of Cloud VPN</li><li>Specifications</li><li>Maintenance and Availability</li><li>Google Cloud Deployment Manager</li><li>Deployment Manager</li><li>Deployment Manager Fundamentals</li><li>Runtime Configurator</li><li>Quotas</li><li>Hands-on: Generating and Creating Cloud Deployment Manager Template</li><li></li></ul><h4>Google Container Engine</h4><ul><li>Google Container Engine Overview</li><li>Docker Overview</li><li>Kubernetes Terminologies</li><li>Replication Controller</li><li>Deployment</li><li>Price and Quotas</li><li>Hands-on: Deploying WordPress Cluster using Container Engine</li><li></li></ul><h4>Cloud Run</h4><ul><li>Overview of Cloud Run</li><li>Deploy a Prebuilt Sample container</li><li></li></ul><h4>Cloud Bigtable</h4><ul><li>Overview of Cloud Bigtable</li><li>Access Control</li><li>Performance</li><li>Locations</li><li>Cloud Datastore</li><li>Overview of Cloud Datastore</li><li>Limits</li><li>Storage Size</li><li>Multitenancy</li><li>Benefits of Multitenancy</li><li>Encryption</li><li> Locations</li><li></li></ul><h4>Cloud BigQuery</h4><ul><li>BigQuery Overview</li><li>Interacting with BigQuery</li><li>Datasets, Tables, and Views</li><li>Partitioned Tables</li><li>Query Plan Explanation</li><li>Hands-on: Getting Started with BigQuery</li><li></li></ul><h4>Cloud DataFlow</h4><ul><li>Overview</li><li>Programming Model</li><li>DataFlow SDK 1.x for java</li><li>Cloud Dataflow SDK 2.x</li><li>Security and Permissions</li><li>Advanced Access Control</li><li></li></ul><h4>Cloud DataProc</h4><ul><li>Overview</li><li>Clusters</li><li>Versioning</li><li></li></ul><h4>Cloud Pub/Sub</h4><ul><li>Overview of Cloud Pub/Sub</li><li>Pub/Sub Concepts and Message Flow</li><li>Data Model</li><li>Cleanup of All Services</li><li>Hands-on: Cloud Pub/Sub Lab with Background Cloud Function</li><li></li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Google Cloud Engineer Associate Certification Bootcamp training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the Google Cloud Engineer Associate Certification Bootcamp 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.  <p></p>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.<p></p></div>

Nexus Human

AWS Certification

AWS Certified Developer

AWS Certified Database

AWS Certified Cloud Practitioner

Google Cloud

AWS Certified Solutions Architect

Google Cloud Engineer Associate Certification Bootcamp

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>Anyone starting to write SAS programs</p>Overview<p>Use SAS Studio and SAS Enterprise Guide to write and submit SAS programs.<br />Access SAS, Microsoft Excel, and text data.<br />Explore and validate data.<br />Prepare data by subsetting rows and computing new columns.<br />Analyze and report on data.<br />Export data and results to Excel, PDF, and other formats.<br />Use SQL in SAS to query and join tables.</p><p>This course is for users who want to learn how to write SAS programs to access, explore, prepare, and analyze data. It is the entry point to learning SAS programming for data science, machine learning, and artificial intelligence.</p></div><div id="course-pills-2"><h4>Essentials</h4><ul><li>The SAS programming process.</li><li>Using SAS programming tools.</li><li>Understanding SAS syntax.</li></ul><h4>Accessing Data</h4><ul><li>Understanding SAS data.</li><li>Accessing data through libraries.</li><li>Importing data into SAS.</li></ul><h4>Exploring and Validating Data</h4><ul><li>Exploring data.</li><li>Filtering rows.</li><li>Formatting columns.</li><li>Sorting data and removing duplicates.</li></ul><h4>Preparing Data</h4><ul><li>Reading and filtering data.</li><li>Computing new columns.</li><li>Conditional processing.</li></ul><h4>Analyzing and Reporting on Data</h4><ul><li>Enhancing reports with titles, footnotes, and labels.</li><li>Creating frequency reports.</li><li>Creating summary statistics reports.</li></ul><h4>Exporting Results</h4><ul><li>Exporting data.</li><li>Exporting reports.</li></ul><h4>Using SQL in SAS</h4><ul><li>Using Structured Query Language in SAS.</li><li>Joining tables using SQL in SAS.</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans SAS Programming 1 - Essentials training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the SAS Programming 1 - Essentials 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.  <p></p>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.<p></p></div>

Service Design Courses (SDC)

SIA Training

Professional Skills Course (PSC)

Trainers Course

Ssas

SAS Programming 1 - Essentials

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>The ideal audience for this course includes database enthusiasts, IT professionals, and developers who are eager to expand their knowledge and skill set in database management and optimization. Roles that would greatly benefit from attending this course include:<br />Database Developers: Those who design, implement, and maintain databases as part of their primary responsibilities and want to improve their expertise in schema design, query optimization, and advanced database features.<br />Backend Developers: Professionals who work on server-side application logic and require a strong understanding of database management to integrate data storage and retrieval processes into their applications.</p>Overview<p>Upon completing this course, database developers will be able to:<br />Design and implement efficient database schemas by employing normalization techniques, appropriate indexing strategies, and partitioning methods to optimize data storage and retrieval processes.<br />Develop advanced SQL queries, including joining multiple tables, utilizing subqueries, and aggregating data, to extract valuable insights and facilitate decision-making processes.<br />Implement stored procedures, functions, and triggers to automate common database tasks, enforce data integrity, and improve overall application performance.<br />Apply database performance tuning techniques, such as query optimization, index management, and transaction control, to ensure optimal resource usage and enhanced system responsiveness.<br />Integrate databases with various programming languages and platforms, enabling seamless data access and manipulation for web, mobile, and desktop applications.</p><p>PostgreSQL is a powerful, open-source object-relational database management system that emphasizes extensibility, data integrity, and high performance. Its versatility and robust feature set make it an ideal choice for developers working on projects of all sizes, from small-scale applications to enterprise-level systems. By learning PostgreSQL, developers can tap into its advanced capabilities, such as full-text search, spatial data support, and customizable data types, allowing them to create efficient and scalable solutions tailored to their unique needs. PostgreSQL for Database Developers is a three-day hands-on course that explores the fundamentals of database management, covering everything from installation and management to advanced SQL functions. Designed for beginners and enthusiasts alike, this course will equip you with the knowledge and skills required to effectively harness the power of PostgreSQL in today's data-driven landscape. Throughout the course you?ll be immersed in a variety of essential topics, such as understanding data types, creating and managing indexes, working with array values, and optimizing queries for improved performance. You?ll gain valuable hands-on experience with real-world exercises, including the use of the psql client, writing triggers and stored procedures with PL/pgSQL, and exploring advanced SQL functions like Common Table Expressions (CTE), Window Functions, and Recursive Queries. You?ll exit this course with a solid foundation in PostgreSQL, enabling you to confidently navigate and manage your databases with ease and efficiency.</p></div><div id="course-pills-2"><h4>Installing &amp; Managing PostgreSQL</h4><ul><li>PostgreSQL installation process</li><li>Optimal configuration settings</li><li>User and role management</li><li>Database backup and restoration</li></ul><h4>Overview of PostgreSQL Database</h4><ul><li>PostgreSQL architecture overview</li><li>Understanding database objects</li><li>Efficient data storage</li><li>Transaction management basics</li></ul><h4>Using the psql client</h4><ul><li>Introduction to psql</li><li>Essential psql commands</li><li>Executing queries effectively</li><li>Managing databases with psql</li></ul><h4>Understanding PostgreSQL data types</h4><ul><li>Numeric data types explored</li><li>Character and binary types</li><li>Date, time, and boolean values</li><li>Array and other types</li></ul><h4>Understanding sequences</h4><ul><li>Sequence creation and usage</li><li>Customizing sequence behavior</li><li>Implementing auto-increment columns</li><li>Sequence manipulation and control</li></ul><h4>Creating &amp; managing indexes</h4><ul><li>PostgreSQL index fundamentals</li><li>Designing partial indexes</li><li>Utilizing expression-based indexes</li><li>Index management techniques</li></ul><h4>Using COPY to load data</h4><ul><li>COPY command overview</li><li>Importing and exporting data</li><li>Handling CSV and binary formats</li><li>Performance considerations</li></ul><h4>Working with Array Values</h4><ul><li>Array value basics</li><li>Array manipulation functions</li><li>Querying arrays efficiently</li><li>Multidimensional array handling</li></ul><h4>Advanced SQL Functions</h4><ul><li>Mastering Common Table Expressions</li><li>Utilizing Window Functions</li><li>Regular Expressions in SQL</li><li>Crafting Recursive Queries</li></ul><h4>Writing triggers &amp; stored procedures with PL/pgSQL</h4><ul><li>PL/pgSQL variables usage</li><li>Implementing loop operations</li><li>PERFORM and EXECUTE statements</li><li>Developing PostgreSQL triggers</li></ul><h4>Using the PostgreSQL query optimizer</h4><ul><li>Query analysis and optimization</li><li>EXPLAIN command insights</li><li>PostgreSQL query operators</li><li>Identifying performance bottlenecks</li></ul><h4>Improving query performance</h4><ul><li>Query performance tuning</li><li>Index optimization strategies</li><li>Efficient database partitioning</li><li>Connection and resource management</li></ul><h4>Wrap Up &amp; Additional Resources</h4><ul><li>Further learning opportunities</li><li>Staying up-to-date with PostgreSQL</li><li>Community engagement and support</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PostgreSQL for Database Developers (TTDB7024) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the PostgreSQL for Database Developers (TTDB7024) 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.  <p></p>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.<p></p></div>

Database Design & Development

PostgreSQL

Database Programming

Database Administration

Oracle Database

PostgreSQL for Database Developers (TTDB7024)

<strong>Learn more about basic Linux System Administration</strong>
        <p>This course is for someone who needs basic training in Linux, someone who is already in IT and wants to add a new skill.  It is specifically designed for those who have been really busy with their work and don't have enough time.  Now you don't have to stay awake at night or sneak out of your lunch break.  You will learn so many Linux commands in just 2 days.  Sounds unreal?  Well take a look at my syllabus: -  
Understanding of Linux
What is Oracle Virtual Box?   
Oracle Virtual Box Installation, Creating a virtual machine   
Linux Distributions, Linux Installation  
Download and install Putty, Connect Linux VM via Putty   
Changing Password, Introduction to File System   
File system structure description   
File system navigation commands, Directory listing overview   
Creating Files and Directories,File Permissions (chmod), File Ownership (chown, chgrp)   
Getting Help (man, what's etc.)   
Adding text to file, Pipes ( | )   
Quiz, Homework, and Handouts  
File Maintenance Commands, File Display Commands
Filters / Text Processing Commands (cut, sort, grep, awk, uniq, wc)
Finding System Information (uname, cat /etc/redhat-release, cat /etc/*rel*, dmidecode)
Linux File Editors (vi text editor)
User account management
Switch users and Sudo access
System utility commands (date, uptime, hostname, which, cal, bc etc.)
Processes and schedules (systemctl, ps, top, kill, crontab and at)
OS Maintenance Commands (shutdown, reboot, halt, init etc.)
System Monitoring Commands (top, df, dmesg, iostat 1, netstat, free etc.)   
Shell scripting, Basic Shell scripts, Aliases, Command history   
Enabling Internet in Linux VM   
Network Files and Commands (ping, ifconfig, netstat, tcpdump, networking config files)   
System Updates and Repositories (rpm and yum), System Run Levels   
All the code files are placed at https://github.com/PacktPublishing/Linux-Command-Line-for-Beginners</p>
        <h2>What You Will Learn</h2><p>&bull; Linux basic system administration<br>&bull; Efficient in basic Linux command line<br>&bull; A very well understanding of how Linux works</p>
        <h2>Audience</h2><p>Anyone who has very limited time to learn Linux and wants the fastest and efficient way to learn Linux. Anyone who is already in IT and wants to add a new skill. Network, Storage, Database or Software engineers, developers, IT Help-desk technicians. Someone with no patience to spend endless hours learning a new skill. Anyone who wants to level up his or her career.</p>
        <h2>Approach</h2><p>This course is designed for you to understand the importance of Linux and will help you learn it in two days.</p>
        <h2>Key Features</h2><p>The instructor will walk you through each step in a very detailed manner.</p>
        <h2>Github Repo</h2><p>https://github.com/packtpublishing/linux-command-line-for-beginners</p>
        <h2>About the Author</h2><h3>Imran Afzal</h3><p>Imran Afzal is a systems engineer/manager, entrepreneur, instructor, and a public speaker. He started his career with Time Warner in 2000 as a systems administrator. He was involved in deploying technologies such as DTV, VOD, CableCards, and others. These technologies were built on many Linux distributions. Since then, he has utilized Linux/Unix skills in many Fortune 500 companies.

He has worn many different hats and currently manages a large team of systems engineers, administrators and team leads globally. He has spearheaded projects such as datacenter migration, introduction, and deployment of VMware, monitoring tools implementation, Amazon cloud migration, and many more. He is certified in Linux Systems Management, UNIX Operating Systems, Linux System Administration, System Internals, VMWare Certified Professional, RHCSA, and Windows Server Certified.</p>
        <h2>Course Outline</h2><h4>1. Course Overview</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Course Overview</p><p style='margin: 0'>Course Overview: Course Overview</p></td></tr></tbody></table><br><h4>2. Saturday - Basic Linux Administration</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Welcome to Saturday Class</p><p style='margin: 0'>Saturday - Basic Linux Administration: Welcome to Saturday Class</p></td></tr><tr><td style='padding: 15px;'><p>2. What is Linux?</p><p style='margin: 0'>Saturday - Basic Linux Administration: What is Linux?</p></td></tr><tr><td style='padding: 15px;'><p>3. What is Virtual Box?</p><p style='margin: 0'>Saturday - Basic Linux Administration: What is Virtual Box?</p></td></tr><tr><td style='padding: 15px;'><p>4. Oracle Virtual Box Installation</p><p style='margin: 0'>Saturday - Basic Linux Administration: Oracle Virtual Box Installation</p></td></tr><tr><td style='padding: 15px;'><p>5. Creating Virtual Machine</p><p style='margin: 0'>Saturday - Basic Linux Administration: Creating Virtual Machine</p></td></tr><tr><td style='padding: 15px;'><p>6. Linux Distributions</p><p style='margin: 0'>Saturday - Basic Linux Administration: Linux Distributions</p></td></tr><tr><td style='padding: 15px;'><p>7. Linux Installation</p><p style='margin: 0'>Saturday - Basic Linux Administration: Linux Installation</p></td></tr><tr><td style='padding: 15px;'><p>8. Install Putty</p><p style='margin: 0'>Saturday - Basic Linux Administration: Install Putty</p></td></tr><tr><td style='padding: 15px;'><p>9. Connect Linux VM through Putty</p><p style='margin: 0'>Saturday - Basic Linux Administration: Connect Linux VM through Putty</p></td></tr><tr><td style='padding: 15px;'><p>10. Changing Password</p><p style='margin: 0'>Saturday - Basic Linux Administration: Changing Password</p></td></tr><tr><td style='padding: 15px;'><p>11. Introduction to File System and Structure</p><p style='margin: 0'>Saturday - Basic Linux Administration: Introduction to File System and Structure</p></td></tr><tr><td style='padding: 15px;'><p>12. File System Navigation Commands</p><p style='margin: 0'>Saturday - Basic Linux Administration: File System Navigation Commands</p></td></tr><tr><td style='padding: 15px;'><p>13. Directory Listing Overview</p><p style='margin: 0'>Saturday - Basic Linux Administration: Directory Listing Overview</p></td></tr><tr><td style='padding: 15px;'><p>14. Creating Files and Directories</p><p style='margin: 0'>Saturday - Basic Linux Administration: Creating Files and Directories</p></td></tr><tr><td style='padding: 15px;'><p>15. Pipes ( | )</p><p style='margin: 0'>Saturday - Basic Linux Administration: Pipes ( | )</p></td></tr><tr><td style='padding: 15px;'><p>16. File Permissions</p><p style='margin: 0'>Saturday - Basic Linux Administration: File Permissions</p></td></tr><tr><td style='padding: 15px;'><p>17. File Ownership Commands</p><p style='margin: 0'>Saturday - Basic Linux Administration: File Ownership Commands</p></td></tr><tr><td style='padding: 15px;'><p>18. Adding Text to Files</p><p style='margin: 0'>Saturday - Basic Linux Administration: Adding Text to Files</p></td></tr><tr><td style='padding: 15px;'><p>19. Getting Help (man, whatis, -help)</p><p style='margin: 0'>Saturday - Basic Linux Administration: Getting Help (man, whatis, -help)</p></td></tr></tbody></table><br><h4>3. Sunday - Advance Linux Administration</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Welcome</p><p style='margin: 0'>Sunday - Advance Linux Administration: Welcome</p></td></tr><tr><td style='padding: 15px;'><p>2. File Maintenance Commands (cp, rm, mv, mkdir, rmdir)</p><p style='margin: 0'>Sunday - Advance Linux Administration: File Maintenance Commands (cp, rm, mv, mkdir, rmdir)</p></td></tr><tr><td style='padding: 15px;'><p>3. File Display Commands (cat, less, more, head, tail, vi)</p><p style='margin: 0'>Sunday - Advance Linux Administration: File Display Commands (cat, less, more, head, tail, vi)</p></td></tr><tr><td style='padding: 15px;'><p>4. Filters / Text Processing Commands (cut, sort, grep, awk, uniq, wc)</p><p style='margin: 0'>Sunday - Advance Linux Administration: Filters / Text Processing Commands (cut, sort, grep, awk, uniq, wc)</p></td></tr><tr><td style='padding: 15px;'><p>5. Finding System Information (uname, cat /etc/redhat-release, cat /etc/*rel*, dmid</p><p style='margin: 0'>Sunday - Advance Linux Administration: Finding System Information (uname, cat /etc/redhat-release, cat /etc/*rel*, dmid</p></td></tr><tr><td style='padding: 15px;'><p>6. Linux File Editor (vi)</p><p style='margin: 0'>Sunday - Advance Linux Administration: Linux File Editor (vi)</p></td></tr><tr><td style='padding: 15px;'><p>7. User Account Management (useradd, groupadd, usermod, userdel, groupdel)</p><p style='margin: 0'>Sunday - Advance Linux Administration: User Account Management (useradd, groupadd, usermod, userdel, groupdel)</p></td></tr><tr><td style='padding: 15px;'><p>8. Switch Users and Sudo Access (su, sudo)</p><p style='margin: 0'>Sunday - Advance Linux Administration: Switch Users and Sudo Access (su, sudo)</p></td></tr><tr><td style='padding: 15px;'><p>9. System Utility Commands (date, uptime, hostname, uname, which, cal, bc)</p><p style='margin: 0'>Sunday - Advance Linux Administration: System Utility Commands (date, uptime, hostname, uname, which, cal, bc)</p></td></tr><tr><td style='padding: 15px;'><p>10. Processes and Schedules (systemctl, ps, top, kill, crontab and at)</p><p style='margin: 0'>Sunday - Advance Linux Administration: Processes and Schedules (systemctl, ps, top, kill, crontab and at)</p></td></tr><tr><td style='padding: 15px;'><p>11. OS Maintenance Commands (shutdown, reboot, halt, init)</p><p style='margin: 0'>Sunday - Advance Linux Administration: OS Maintenance Commands (shutdown, reboot, halt, init)</p></td></tr><tr><td style='padding: 15px;'><p>12. System Monitoring Commands (top, df, dmesg, iostat 1, netstat, free)</p><p style='margin: 0'>Structured Query Language - SQL: System Monitoring Commands (top, df, dmesg, iostat 1, netstat, free)</p></td></tr><tr><td style='padding: 15px;'><p>13. Shell Scripting</p><p style='margin: 0'>Sunday - Advance Linux Administration: Shell Scripting</p></td></tr><tr><td style='padding: 15px;'><p>14. Basic Shell Scripts</p><p style='margin: 0'>Sunday - Advance Linux Administration: Basic Shell Scripts</p></td></tr><tr><td style='padding: 15px;'><p>15. History Command (history)</p><p style='margin: 0'>Sunday - Advance Linux Administration: History Command (history)</p></td></tr><tr><td style='padding: 15px;'><p>16. Enabling Internet in Linux VM</p><p style='margin: 0'>Sunday - Advance Linux Administration: Enabling Internet in Linux VM</p></td></tr><tr><td style='padding: 15px;'><p>17. Network Files and Commands (ping, ifconfig, netstat, tcpdump, networking confi</p><p style='margin: 0'>Sunday - Advance Linux Administration: Network Files and Commands (ping, ifconfig, netstat, tcpdump, networking config</p></td></tr><tr><td style='padding: 15px;'><p>18. System Updates and Repositories (rpm and yum)</p><p style='margin: 0'>Sunday - Advance Linux Administration: System Updates and Repositories (rpm and yum)</p></td></tr></tbody></table>

Packt

Operating System

Linux

Learning

Learn more about basic Linux System Administration

Linux Command Line for Beginners

<strong>Step-by-step tutorial to build a robust automation framework - TestNG, ANT, Maven, Jenkins, Cucumber, Git, Pageobject, Cloud,SQL</strong>
        <p>Are you struggling with understanding test automation frameworks and clearing top company's interviews? Do you only have basic knowledge of Selenium and have a plan to enhance your skills to architect level? If yes then you are at right place. This single course enables you to master test automation frameworks with the latest technology from around the globe! This scratch-level program trains you on every aspect of the framework with  practical projects, and on course completion you will be mastered in designing frameworks that you can implement successfully in your work place.</p>
        <h2>What You Will Learn</h2><p>&bull; At the end of this course, you will be able to design a robust test automation Selenium framework on your own<br>&bull; Understand how TESTNG/JUNIT works for framework building<br>&bull; Importance of Maven/ANT - Build management tool in test projects<br>&bull; Jenkins - CI Integration to the frameworks for continuous monitoring of the test cases<br>&bull; Understand page object design patterns and its advantages in automation repository building<br>&bull; Additional knowledge in Selenium Grid- cross browser testing<br>&bull; You will know the coding standards in designing the most optimized automation script frameworks<br>&bull; Necessary core Java knowledge required for automation</p>
        <h2>Audience</h2><p>This course is for manual testers, non-programming aware testers interested in learning automation.</p>
        <h2>Approach</h2><p>This scratch-level program trains you in every aspect of the framework with  practical projects, and on course completion you will be mastered in designing frameworks that you can implement successfully in your work place.</p>
        <h2>Key Features</h2><p>&bull; Learn right from scratch. No prior knowledge required on any of the topics * &bull; By the end of the course, reach architect level skilled professional * </p>
        <h2>Github Repo</h2><p>https://github.com/packtpublishing/design-selenium-test-framework-from-scratch-architect-level</p>
        <h2>About the Author</h2><h3>Rahul Shetty</h3><p>Rahul Shetty is the founder and trainer at Rahul Shetty Academy. He is a passionate software tester and has 13 years of rich experience in the IT industry. He has completed more than 300 offline training batches. Rahul has extensive knowledge in web automation testing, mobile automation testing, and API automation testing. He has also worked with various CMM-level organizations and managed the set-up of QA processes for projects.</p>
        <h2>Course Outline</h2><h4>1. Introduction</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction to Course</p><p style='margin: 0'>Introduction: Introduction to Course</p></td></tr><tr><td style='padding: 15px;'><p>2. What am going to get from this course?</p><p style='margin: 0'>Introduction: What am going to get from this course?</p></td></tr><tr><td style='padding: 15px;'><p>3. Eclipse Installation</p><p style='margin: 0'>Introduction: Eclipse Installation</p></td></tr></tbody></table><br><h4>2. TestNG Testing Framework</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Why TestNG and Its Advantages</p><p style='margin: 0'>TestNG Testing Framework: Why TestNG and Its Advantages</p></td></tr><tr><td style='padding: 15px;'><p>2. Running testcases in TestNG with out Void main Java</p><p style='margin: 0'>TestNG Testing Framework: Running testcases in TestNG with out Void main Java</p></td></tr><tr><td style='padding: 15px;'><p>3. Importance of Testng xml file</p><p style='margin: 0'>TestNG Testing Framework: Importance of Testng xml file.</p></td></tr><tr><td style='padding: 15px;'><p>4. Prioritizing the tests using TestNG</p><p style='margin: 0'>TestNG Testing Framework: Prioritizing the tests using TestNG</p></td></tr><tr><td style='padding: 15px;'><p>5. Controlling the Testcase execution with Exclude Mechanism</p><p style='margin: 0'>TestNG Testing Framework: Controlling the Testcase execution with Exclude Mechanism</p></td></tr><tr><td style='padding: 15px;'><p>6. Executing the Testcases at Package level with regex</p><p style='margin: 0'>TestNG Testing Framework: Executing the Testcases at Package level with regex</p></td></tr><tr><td style='padding: 15px;'><p>7. Test level Testng Annotations examples</p><p style='margin: 0'>TestNG Testing Framework: Test level Testng Annotations examples.</p></td></tr><tr><td style='padding: 15px;'><p>8. Method& Suite level Testng Annotations examples</p><p style='margin: 0'>TestNG Testing Framework: Method& Suite level Testng Annotations examples</p></td></tr><tr><td style='padding: 15px;'><p>9. Importance of Groups in Testng</p><p style='margin: 0'>TestNG Testing Framework: Importance of Groups in Testng</p></td></tr><tr><td style='padding: 15px;'><p>10. Annotations helper attributes with examples</p><p style='margin: 0'>TestNG Testing Framework: Annotations helper attributes with examples</p></td></tr><tr><td style='padding: 15px;'><p>11. Parameterising from TestNG xml file</p><p style='margin: 0'>TestNG Testing Framework: Parameterising from TestNG xml file</p></td></tr><tr><td style='padding: 15px;'><p>12. DataProvider Annotation -Parameterizing Testcases</p><p style='margin: 0'>TestNG Testing Framework: DataProvider Annotation -Parameterizing Testcases</p></td></tr><tr><td style='padding: 15px;'><p>13. Practise exercises on Dataprovider annotations</p><p style='margin: 0'>TestNG Testing Framework: Practise exercises on Dataprovider annotations</p></td></tr><tr><td style='padding: 15px;'><p>14. Importance of Listeners in TestNG framework</p><p style='margin: 0'>TestNG Testing Framework: Importance of Listeners in TestNG framework</p></td></tr><tr><td style='padding: 15px;'><p>15. Running Tests in parallel and generating Reports</p><p style='margin: 0'>TestNG Testing Framework: Running Tests in parallel and generating Reports</p></td></tr></tbody></table><br><h4>3. Maven - Build Management Tool</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Why Maven &Maven Advantages</p><p style='margin: 0'>Maven - Build Management Tool: Why Maven &Maven Advantages</p></td></tr><tr><td style='padding: 15px;'><p>2. Maven Installation and Setup</p><p style='margin: 0'>Maven - Build Management Tool: Maven Installation and Setup</p></td></tr><tr><td style='padding: 15px;'><p>3. Creating Maven Project</p><p style='margin: 0'>Maven - Build Management Tool: Creating Maven Project</p></td></tr><tr><td style='padding: 15px;'><p>4. Importing Maven project into eclipse and anaylzing</p><p style='margin: 0'>Maven - Build Management Tool: Importing Maven project into eclipse and anaylzing</p></td></tr><tr><td style='padding: 15px;'><p>5. Maven POM.xml file Explanation</p><p style='margin: 0'>Maven - Build Management Tool: Maven POM.xml file Explanation</p></td></tr><tr><td style='padding: 15px;'><p>6. Maven TestNG Integration</p><p style='margin: 0'>Maven - Build Management Tool: Maven TestNG Integration</p></td></tr><tr><td style='padding: 15px;'><p>7. Maven Dependencies Importance</p><p style='margin: 0'>Maven - Build Management Tool: Maven Dependencies Importance</p></td></tr><tr><td style='padding: 15px;'><p>8. Multiple Automation Profiles in POM.xml</p><p style='margin: 0'>Maven - Build Management Tool: Multiple Automation Profiles in POM.xml</p></td></tr><tr><td style='padding: 15px;'><p>9. TestNG Html Reporting after Maven Build</p><p style='margin: 0'>Maven - Build Management Tool: TestNG Html Reporting after Maven Build</p></td></tr></tbody></table><br><h4>4. Jenkins- Continiuous Integration Tool</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Why Jenkins - Jenkins Advantages</p><p style='margin: 0'>Jenkins- Continiuous Integration Tool - Jenkins Advantages</p></td></tr><tr><td style='padding: 15px;'><p>2. Jenkins-Maven Project Setup</p><p style='margin: 0'>Jenkins- Continiuous Integration Tool: Jenkins-Maven Project Setup</p></td></tr><tr><td style='padding: 15px;'><p>3. Running Builds and checking reports</p><p style='margin: 0'>Jenkins- Continiuous Integration Tool: Running Builds and checking reports</p></td></tr><tr><td style='padding: 15px;'><p>4. Scheduling Jenkin Builds on needly Basis</p><p style='margin: 0'>Jenkins- Continiuous Integration Tool: Scheduling Jenkin Builds on needly Basis</p></td></tr></tbody></table><br><h4>5. ANT- Build Management Tool</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. What is ANT? Where it helps in framework?</p><p style='margin: 0'>ANT- Build Management Tool: What is ANT? Where it helps in framework?</p></td></tr><tr><td style='padding: 15px;'><p>2. Installing & Configuring ANT</p><p style='margin: 0'>ANT- Build Management Tool: Installing & Configuring ANT</p></td></tr><tr><td style='padding: 15px;'><p>3. Understanding Build.xml file</p><p style='margin: 0'>ANT- Build Management Tool: Understanding Build.xml file</p></td></tr><tr><td style='padding: 15px;'><p>4. Different ANT Commands to trigger Framework</p><p style='margin: 0'>ANT- Build Management Tool: Different ANT Commands to trigger Framework</p></td></tr></tbody></table><br><h4>6. Page object Design Patterns</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Why Page object pattern and its Advantages</p><p style='margin: 0'>Page object Design Patterns: Why Page object pattern and its Advantages</p></td></tr><tr><td style='padding: 15px;'><p>2. How to create object repository</p><p style='margin: 0'>Page object Design Patterns: How to create object repository</p></td></tr><tr><td style='padding: 15px;'><p>3. Creating pageobject classes</p><p style='margin: 0'>Page object Design Patterns: Creating pageobject classes</p></td></tr><tr><td style='padding: 15px;'><p>4. Invoking Pageobjects methods in testcases</p><p style='margin: 0'>Page object Design Patterns: Invoking Pageobjects methods in testcases</p></td></tr><tr><td style='padding: 15px;'><p>5. Live Example on Page object pattern</p><p style='margin: 0'>Page object Design Patterns: Live Example on Page object pattern</p></td></tr><tr><td style='padding: 15px;'><p>6. Creating environment variables dynamically</p><p style='margin: 0'>Page object Design Patterns: Creating environment variables dynamically</p></td></tr><tr><td style='padding: 15px;'><p>7. Running Testng Batch files</p><p style='margin: 0'>Page object Design Patterns: Running Testng Batch files</p></td></tr><tr><td style='padding: 15px;'><p>8. Triggering Jenkins build on Pageobject Testcases</p><p style='margin: 0'>Page object Design Patterns: Triggering Jenkins build on Pageobject Testcases</p></td></tr></tbody></table><br><h4>7. Selenium Grid -Cross Browser Testing</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. How to execute Selenium Tests Remotly</p><p style='margin: 0'>Selenium Grid -Cross Browser Testing: How to execute Selenium Tests Remotly</p></td></tr><tr><td style='padding: 15px;'><p>2. Configuring Hub and Node-1</p><p style='margin: 0'>Selenium Grid -Cross Browser Testing: Grid Concepts & Architecure</p></td></tr><tr><td style='padding: 15px;'><p>3. Grid Concepts & Architecure</p><p style='margin: 0'>Selenium Grid -Cross Browser Testing: Configuring Hub and Node-1</p></td></tr><tr><td style='padding: 15px;'><p>4. Registering Nodes with Hub Server</p><p style='margin: 0'>Selenium Grid -Cross Browser Testing: Registering Nodes with Hub Server</p></td></tr><tr><td style='padding: 15px;'><p>5. Desired Capabilities-Grid Program</p><p style='margin: 0'>Selenium Grid -Cross Browser Testing: Desired Capabilities-Grid Program</p></td></tr><tr><td style='padding: 15px;'><p>6. Execution Selenium scripts in Remote Machine</p><p style='margin: 0'>Selenium Grid -Cross Browser Testing: Execution Selenium scripts in Remote Machine</p></td></tr></tbody></table><br><h4>8. Java OOPS Basics for Framework Design</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Interface Concepts</p><p style='margin: 0'>Java OOPS Basics for Framework Design: Interface Concepts</p></td></tr><tr><td style='padding: 15px;'><p>2. Practical usage of Interface</p><p style='margin: 0'>Java OOPS Basics for Framework Design: Practical usage of Interface</p></td></tr><tr><td style='padding: 15px;'><p>3. Runtime Polymorphisim</p><p style='margin: 0'>Java OOPS Basics for Framework Design: Runtime Polymorphisim</p></td></tr><tr><td style='padding: 15px;'><p>4. Inheritance Concepts</p><p style='margin: 0'>Java OOPS Basics for Framework Design: Activity: Inheritance Concepts</p></td></tr><tr><td style='padding: 15px;'><p>5. Practical usage of Inheritance</p><p style='margin: 0'>Java OOPS Basics for Framework Design: Practical usage of Inheritance</p></td></tr><tr><td style='padding: 15px;'><p>6. Coding Basics-1</p><p style='margin: 0'>Java OOPS Basics for Framework Design: Coding Basics-1</p></td></tr><tr><td style='padding: 15px;'><p>7. Coding Basics-2</p><p style='margin: 0'>Java OOPS Basics for Framework Design: Coding Basics-2</p></td></tr></tbody></table>

Appium

Java

Test Driven Development

Testing

Web Development

Selenium

Python

Step-by-step tutorial to build a robust automation framework - TestNG, ANT, Maven, Jenkins, Cucumber, Git, Pageobject, Cloud,SQL

Design a Selenium Test Framework from Scratch-Architect level

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This class is intended for DBAs and IT Professionals who are responsible for administration and maintenance of PostgreSQL, and want to increase proficiency and learn best practices. Targeted at: DBAs and Architects, and appropriate for Analysts, Support Engineers, and other IT professionals</p>Overview<p>Please refer to overview</p><p>This is an immersive 5-day class that offers hands-on labs and combines the core topics from Foundations of Postgres Administration and Advanced PostgreSQL Administration into a one-week class, with significant savings over list price. Upon course completion, you will be prepared to manage mission critical PostgreSQL installations, and perform core administration tasks with confidence and skill.</p></div><div id="course-pills-2"><h4>Course Outline</h4><ul><li>1 - POSTGRES SYSTEM ARCHITECTURE</li><li>2 - INSTALLATION AND GETTING STARTED</li><li>3 - CONFIGURATION, CREATING, MANAGING DATABASES</li><li>4 - USER TOOLS ? USING PSQL</li><li>5 - GUI TOOLS - USING PGADMIN 4</li><li>6 - SECURITY BASICS</li><li>7 - SQL PRIME BACKUP AND RECOVERY</li><li>8 - ROUTINE MAINTENANCE</li><li>9 - POSTGRES DATA DICTIONARY</li><li>10 - MOVING DATA</li><li>11 - SQL TUNING</li><li>12 - PERFORMANCE TUNING</li><li>13 - STREAMING REPLICATION</li><li>14 - TABLE PARTITIONING</li><li>15 - EXTENSION MODULES</li><li>16 - MONITORING</li><li>17 - UPGRADING BEST PRACTICES</li></ul></div>

PGDM

Comprehensive PostgreSQL Administration

<p>If you want to get out of the 9 to 5 rat race and enter the more satisfying and rewarding world of Business, then this Business Intelligence Analyst - CPD Accredited course is perfect for you.</p><p>The business world is cutthroat and scary, but it's effortless to succeed if you have the proper knowledge and skills. This course is ideally suited to give you deep insights into the world of Business Intelligence Analyst - CPD Accredited whilst also preparing you for success.</p><p>You get 8 amazing lessons on Business Intelligence Analyst - CPD Accredited in this course, and you can study them as much as you want because you get access to the course materials around the clock.</p><p>Alongside the lessons, you also get a certificate for free after passing the course for all your career advancement needs.</p><p>With tutor support, a money-back guarantee and CPD certification, there's no better course out there for you to learn about Business Intelligence Analyst - CPD Accredited.</p><p>Enrol now and we'll see you in class.</p><p>P.S. - there's a full curriculum breakdown given in the description section below. Check it out if you want more information about the course and the topics it covers.</p><p><strong>Course Curriculum:</strong></p><ul><li>Module 01: An Introduction to Business Intelligence</li><li>Module 02: Real-time Business Intelligence</li><li>Module 03: Fundamentals of Statistics and Data Science</li><li>Module 04: Fundamentals of SQL</li><li>Module 05: Database Management Essentials</li><li>Module 06: Data Warehouse Concepts</li><li>Module 07: Data Visualisation in Business Intelligence</li><li>Module 08: Basics of Python</li></ul><p><strong>Course Assessment</strong></p><p>You will immediately be given access to a specifically crafted MCQ test upon completing Business Intelligence Analyst - CPD Accredited course. For each test, the pass mark will be set to 60%.</p><p><strong>Accredited Certificate</strong></p><p>After successfully completing this Business Intelligence Analyst - CPD Accredited course, you will qualify for the CPD Certification Service (CPD UK) certified certificate from Training Express.</p><p><strong>Disclaimer</strong>: The CPD approved course is owned by E-Learning Solutions Ltd and is distributed under license.</p><p><strong>Why Choose The CPD Certification Service Accredited Course? </strong></p><p>With 25 years of experience in the Continuous Professional Development sector, CPD Certification Service (CPD UK) is the leading CPD accreditation organisation in the UK, working across all industry sectors. The CPD Certification Service provides recognised independent CPD accreditation compatible with global CPD requirements.</p><p>Hundreds and thousands of professionals recognise the CPD Certified symbol as the qualitative benchmark that reflects and sets the industry standards. CPD UK evaluates learning activities to the highest standards and courses are certified against the universally accepted structured checklist.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        10 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by The CPD Certification Service
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>The Business Intelligence Analyst - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>There are no formal entry requirements for the course, with enrollment open to anyone!</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Learn the essential skills and knowledge you need to excel in your professional life with the help &amp; guidance from our Business Intelligence Analyst - CPD Accredited training.</p>
                        </div>

Training Express

Business Intelligence Analyst Training - CPD Accredited Course

<p><strong>Best Price Of The Market</strong></p> <p><strong>Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now</strong></p> <p>Give a compliment to your career and take it to the next level. This <strong>Web Development in Python </strong>will provide you with the essential knowledge and skills required to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this <strong>Web Development in Python </strong>will help you keep ahead of the pack.</p> <p>The <strong>Web Development in Python </strong>incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can reinforce your professional skills and essential knowledge, reaching out to the level of expertise required for your position. Further, this <strong>Web Development in Python </strong> will add extra value to your resume to stand out to potential employers.</p> <p>Throughout the programme, it stresses how to improve your competency as a person in your profession while at the same time it outlines essential career insights in this job sector. Consequently, you'll strengthen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the <strong> Web Development in Python,</strong> you can equip yourself with the essentials to keep you afloat into the competition.</p> <p><strong>This Bundle Consists of the following Premium courses: </strong></p> <ul> <li><strong> Course 01: </strong>Python Programming for Everybody</li><li><strong> Course 02: </strong>Higher Order Functions in Python - Level 03</li><li><strong> Course 03: </strong>Django Rest Framework Level 4<strong><br /></strong></li><li><strong> Course 04: </strong>Coding with HTML, CSS, &amp; Javascript<strong><br /></strong></li><li><strong> Course 05: </strong>Data Structures Complete Course<strong><br /></strong></li><li><strong> Course 06: </strong>Learn to Use Python for Spatial Analysis in ArcGIS<strong><br /></strong></li><li><strong> Course 07: </strong>Data Science with Python<strong><br /></strong></li><li><strong> Course 08: </strong>Cloud Computing / CompTIA Cloud+ (CV0-002)<strong><br /></strong></li><li><strong> Course 09: </strong>SQL Programming Complete Bundle<strong><br /></strong></li><li><strong> Course 10: </strong>Learn Ethical Hacking From A-Z: Beginner To Expert<strong><br /></strong></li><li><strong> Course 11: </strong>Cyber Security Incident Handling and Incident Response</li></ul> <p>Enrol now, to advance your career, and use the premium study materials from Apex Learning.</p> <p><strong>Benefits you'll get from choosing Apex Learning for this Web Development in Python:</strong></p> <ul> <li>Pay once and get lifetime access <strong>to 11 CPD courses </strong>including this Web Development in Python Course</li><li>Free e-Learning App for engaging reading materials &amp; helpful assistance</li><li>Certificates, student ID for the course included in a one-time fee</li><li>Free up your time - don't waste time and money travelling for classes</li><li>Accessible, informative modules designed by expert instructors</li><li>Learn about at your ease - anytime, from anywhere</li><li>Study from your computer, tablet or mobile device</li><li>CPD accredited course - improve the chance of gaining professional skills</li></ul><p>The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Web Development in Python expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes.</p> <p><strong>Curriculum:</strong></p> <p><strong>Course 1: Python Programming for Everybody<br /></strong></p> <p><strong>Module 01:</strong></p> <ul> <li>Documentation</li><li>Command Line</li><li>Variables</li><li>Keywords</li><li>Import Module</li></ul> <p>And Much More.....</p> <p><strong>Module 02:</strong></p> <ul> <li>Additional Topics</li><li>If Elif Else</li><li>Iterable</li><li>For</li><li>Loops</li><li>Execute</li><li>Exceptions</li></ul> <p><strong>Module 03:</strong></p> <ul> <li>Data Types</li><li>Number Types</li><li>More Number Types</li><li>Strings</li><li>More Strings</li><li>Files</li><li>Lists</li><li>Dictionaries</li><li>Tuples</li><li>Sets</li></ul> <p><strong>Module 04:</strong></p> <ul> <li>Comprehensions</li><li>Definitions</li><li>Functions</li><li>Default Arguments</li><li>Doc Strings</li><li>Variadic Functions</li><li>Factorial</li></ul> <p><strong>Module 05:</strong></p> <ul> <li>Function Objects</li><li>Lambda</li><li>Generators</li><li>Closures</li><li>Classes</li><li>Object Initialization</li><li>Class Static Members</li><li>Classic Inheritance</li><li>Data Hiding</li></ul> <p>And much more...</p> <p><strong>How will I get my Certificate?</strong></p> <p>After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.</p> <ul> <li><strong> PDF Certificate: Free (Previously it was £10 * 11 = £110)</strong></li><li><strong> Hard Copy Certificate: Free (For The Title Course)</strong></li></ul> <p>PS The delivery charge inside the UK is £3.99, and the international students have to pay £9.99.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        115 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>Anyone from any background can enrol in this Web Development in Python bundle.</p> 
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>This Web Development in Python course has been designed to be fully compatible with tablets and smartphones.</p> 
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Having this expertise will increase the value of your CV and open you up to multiple job sectors.</p> 
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Apex Learning

Web Development in Python

<p><strong>Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now</strong></p> <p>Give a compliment to your career and take it to the next level. This <strong>Python Data Science </strong>will provide you with the essential knowledge and skills required to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this <strong>Python Data Science </strong>will help you keep ahead of the pack.</p> <p>The <strong>Python Data Science </strong>incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can reinforce your professional skills and practical knowledge, reaching out to the level of expertise required for your position. Further, this <strong>Python Data Science </strong>will add extra value to your resume to stand out to potential employers.</p> <p>Along with this course<strong>,</strong> you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free.</p> <p><strong>This Bundle Consists of the following Premium courses: </strong></p> <ul> <li><strong> Course 1: Python Programming for Everybody<br /></strong></li><li><strong> Course 2: Higher Order Functions in Python - Level 03<br /></strong></li><li><strong> Course 3: Learn to Use Python for Spatial Analysis in ArcGIS<br /></strong></li><li><strong> Course 4: Data Structures Complete Course<br /></strong></li><li><strong> Course 5: Basic Google Data Studio<br /></strong></li><li><strong> Course 6: Data Analytics with Tableau<br /></strong></li><li><strong> Course 7: Business Intelligence and Data Mining Masterclass<br /></strong></li><li><strong> Course 8: SQL Programming Complete Bundle<br /></strong></li><li><strong> Course 9:  Decision Making and Critical Thinking<br /></strong></li><li><strong> Course 10: Time Management</strong></li></ul> <p>Enrol now,to advance your career, and use the premium study materials from Apex Learning.</p> <p><strong>Benefits you'll get from choosing Apex Learning for this Python Data Science:</strong></p> <ul> <li>Pay once and get lifetime access <strong>to 11 CPD courses </strong>including this Python Data Science Course</li><li>Free e-Learning App for engaging reading materials &amp; helpful assistance</li><li>Certificates, student ID for the course included in a one-time fee</li><li>Free up your time - don't waste time and money travelling for classes</li><li>Accessible, informative modules designed by expert instructors</li><li>Learn about at your ease - anytime, from anywhere</li><li>Study from your computer, tablet or mobile device</li><li>CPD accredited course - improve the chance of gaining professional skills</li></ul><p>The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Python Data Science expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes.</p> <p><strong>Curriculum:</strong></p> <p><strong>Course 1: Data Science with Python<br /></strong></p> <ul> <li>Introduction</li><li>Data Cleaning Packages</li><li>Data Visualization packages</li></ul> <p><strong>Course 2: Python Programming for Everybody</strong></p> <p>Module 01<strong><br /></strong></p> <ul> <li>A Installing Python</li><li>Documentation</li><li>Command Line</li><li>Variables</li><li>Simple Syntax</li><li>Keywords</li><li>Import Module</li></ul> <p>Module 02</p> <ul> <li>Additional Topics</li><li>If Elif Else</li><li>Iterable</li><li>For</li><li>Loops</li><li>Execute</li><li>Exceptions</li></ul> <p>Module 03</p> <ul> <li>Data Types</li><li>Number Types</li><li>More Number Types</li><li>Strings</li><li>More Strings</li><li>Files</li><li>Lists</li><li>Dictionaries</li><li>Tuples</li><li>Sets</li></ul> <p>Module 04</p> <ul> <li>Comprehensions</li><li>Definitions</li><li>Functions</li><li>Default Arguments</li><li>Doc Strings</li><li>Variadic Functions</li><li>Factorial</li></ul> <p>Module 05</p> <ul> <li>Function Objects</li><li>Lambda</li><li>Generators</li><li>Closures</li><li>Classes</li><li>Object Initialization</li><li>Class Static Members</li><li>Classic Inheritance</li><li>Data Hiding</li></ul> <p><strong>How will I get my Certificate?</strong></p> <p>After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.</p> <ul> <li><strong>PDF Certificate: Free (Previously it was £6*11 = £66)</strong></li><li><strong>Hard Copy Certificate: Free (For The Title Course: Previously it was £10)</strong></li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        110 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>Anyone from any background can enrol in this bundle.</p> 
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>This course has been designed to be fully compatible with tablets and smartphones.</p> 
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Having these various certifications will increase the value in your CV and open you up to multiple job sectors.</p> 
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div> <p>You will get the Hard Copy certificate for the title course (<strong>Data Science with Python</strong>) absolutely Free! Other Hard Copy certificates are available for £10 each. </p> <p>Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.</p> </div>

                        </div>

Python Data Science Courses

London

<article>
<div>
<h5>Learn SQL Course, 1-Day</h5>
</div>
<div></div>
<p>  						 
	</p><div>
	<ul>
		<p>
		<b>SQL Queries Course, 1-Day. </b>Basic SQL syntax. 
		<br />Most attendees are in-work IT Professional.
		<br />Private individuals are also very welcome. 
		<br />Evening courses also running.
		<br /><b>Our Style: </b>Hands-on, Practical  
		<br /><b>Location:  </b>Online, Instructor-led  
		<br /><b>Download:  </b>anaconda.com
		<br /><b>Duration:  </b>6 weeks, 1 evening per week, 6pm - 8pm
		<br /><b>Times: </b>arrange a time for your time zone
	    </p>
	</ul>	

<p></p>
</div></article>

<div>
	  <div>
		 <h5>Learn SQL Course, 1-Day</h5>
	  </div>
	  <div></div>
	  <p> With SQL Queries, you could learn SQL in a day, and master the basics of SQL, get interesting, insightful and essential business intelligence from data by using SQL queries on this SQL Course London, UK. 
	  <br />Queries are made easy and simple, saving hours of online training.
 
		<br />This 1 Day course is packed with power query techniques.

<br /><br />This SQL Introduction Course is hands-on, practical with many excellent query examples.
<br /><br />This course is Platform Independent.
<br /><br />This SQL course is hands-on and practical, to give you in-depth, practical experience of the topics covered.
<br /><br />Ask your SQL questions in small, friendly classroom SQL Course. 
<br /><br />Online, Instructor-led, Interactive, full screen sharing.

	  </p>
	<div>
	<h5> Learn SQL Relational Database Concepts:</h5>
	</div>
	<div></div>
	<div> 
					<p>  <strong>Database:</strong>  
					<br />What is a Relational Database?
<br />Tables, Rows and Columns
<br />Indexes, Primary Keys and Foreign Keys
<br />Data Types  
					</p> 
			 
				 
			</div>
	<div>
	<h5>Learn SQL Essentials:</h5>
	</div> <div></div>
	<div> 
				<p> <strong>Basics.</strong>
					<br />SQL Language Essentials:
<br />The SQL Select Statement, the Where Clause, SQL Order By Clause, Working with Null Values
<br />SQL Arithmetic Operations, Expression Queries
<br />SQL Column Aliases
<br />Limit/Top, Distinct

				 
				</p>
			</div>
	<div>
	<h5>Summarizing and Grouping Data:</h5>
	</div> <div></div>
	<div> 
				<p>  <strong>Group by</strong>
				<br />
Aggregate Functions (Sum, Avg, Count, Max, Min)
<br />The Group By Clause
<br />The Having Clause
				 
				</p>
			</div>
	<div>
	<h5>Querying Multiple Tables:</h5>
	</div> <div></div>
	<div>
				<p>   <strong>Joins</strong>
					<br />
Joining Tables
<br />Inner Joins, Outer Joins, Self Joins, Full Joins, 
<br />Cross Joins
<br />Alternative Join Syntax
				</p>
			</div>

	 
	
	 
	<div>
	<h5>Basic Subqueries</h5>
	</div> 
	<div></div>
	<div>	 
		<p> <strong>Sub-queries</strong>
			<br />Basics of CTE tables
			<br />SQL subqueries 
			<br />Using subqueries in the from clause
			<br />Using subqueries in the where clause
			<br />Using subqueries in the select clause
			<br />Using subqueries in the having clause 
			
		</p>
	</div>
	<div>
	<h5>Combine Queries</h5>
	</div> 
	<div></div>
	<div>	 
		<p> <strong>Combine Queries</strong>
			<br />The Union Operator
			<br /> Intersect and Minus Operators
			<br /> Simulating combine Intersect and Minus queries by using sub-queries
					   

			 

		</p>
	</div>
	  
</div>
 

<div>   

	   <div id="cincluded">
		  <div>
			 <h5>What is included</h5>
		  </div>

		  <article>
		  <div>
			 <ul>
				<li>PCWorkshops Course Certificate on completion  </li>
									   
				<li>SQL Course Notes</li>
				<li>SQL Code Examples</li>
				<li>Practical SQL Course exercises and Code Samples</li>
				<li>After the course: 1-Hour personalised online revision session</li>
			 </ul>
		  </div>
		  </article>
	   </div>
				    
<div>
	                  <div>
	                     <h5 id="cincluded2">Book the SQL Course</h5>
	                  </div>
 
	 
 <div id="eventbrite-widget-container-100389112538"></div>




									
					
					 
</div>
				   <div id="caboutus">
	                  <div>
	                     <h5>About us</h5>
	                  </div> 
	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
										<li>
										<div id="LTF_ST_m8v4lCcicRynaFxnT4tD2JOVCitkIkMwzh0sIQRc9Toth01PZo"></div>
										</li>	
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>
				   
				   
	        </div>

Learn SQL Course, 1-Day
This SQL course is platform independent.
SQL Queries Course, 1-Day. Basic SQL syntax.  This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 

Details
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 6 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 
Join us on your booked dates on https://meet.goto.com/910697125
Learn SQL Course, 1-Day Online Instructor-led
With SQL Queries, you could learn SQL in a day, and master the basics of SQL, and get interesting, insightful, and essential business intelligence from data by using SQL queries on this SQL Course in London, UK. 
Queries are made easy and simple, saving hours of online training. 
This 1 Day course is packed with power query techniques. 

This SQL Introduction Course is hands-on, practical with many excellent query examples.
This SQL course is hands-on and practical to give you in-depth, practical experience of the topics covered.
Ask your SQL questions in a small, friendly classroom SQL course. 

Learn SQL. Relational Database Concepts:
 Database: 
What is a Relational Database?

Tables, Rows and Columns

Indexes, Primary Keys and Foreign Keys

Data Types 
Learn SQL Essentials:
 Basics. 
SQL Language Essentials:

The SQL Select Statement, the Where Clause, SQL Order By Clause, Working with Null Values

SQL Arithmetic Operations, Expression Queries

SQL Column Aliases

Limit/Top, Distinct 
Summarizing and Grouping Data:
 Group by 

Aggregate Functions (Sum, Avg, Count, Max, Min)

The Group By Clause

The Having Clause 
Querying Multiple Tables:
 Joins 

Joining Tables

Inner Joins, Outer Joins, Self Joins, Full Joins, 
Cross Joins

Alternative Join Syntax 
Basic Subqueries
 Sub-queries 
Basics of CTE tables 
SQL subqueries 
Using subqueries in the from clause 
Using subqueries in the where clause 
Using subqueries in the select clause 
Using subqueries in the having clause 
 
 Combine Queries 
The Union Operator 
 Intersect and Minus Operators 
 Simulating combined Intersect and Minus queries by using sub-queries 

What is included
PCWorkshops Course Certificate on completion
SQL Course Notes
SQL Code Examples
Practical SQL Course exercises and Code Samples
After the course: 1-Hour personalised online revision session
  



PCWorkshops

Online Course Creation

IT Skills

Data Skills

SQL Queries Course, 1-Day. Basic SQL syntax.  This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 

Learn SQL Basics, 1-day Course, Online Instructor-Led

General admission

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>The Certified Ethical Hacking v12 course will significantly benefit security officers, auditors, security professionals, site administrators, and anyone who is concerned about the integrity of the network infrastructure.</p>Overview<p>Information security controls, laws, and standards. Various types of footprinting, footprinting tools, and countermeasures. Network scanning techniques and scanning countermeasures Enumeration techniques and enumeration countermeasures Vulnerability analysis to identify security loopholes in the target organization?s network, communication infrastructure, and end systems. System hacking methodology, steganography, steganalysis attacks, and covering tracks to discover system and network vulnerabilities. Different types of malware (Trojan, Virus, worms, etc.), system auditing for malware attacks, malware analysis, and countermeasures. Packet sniffing techniques to discover network vulnerabilities and countermeasures to defend against sniffing. Social engineering techniques and how to identify theft attacks to audit human-level vulnerabilities and social engineering countermeasures. DoS/DDoS attack techniques and tools to audit a target and DoS/DDoS countermeasures. Session hijacking techniques to discover network-level session management, authentication/authorization, and cryptographic weaknesses and countermeasures. Webserver attacks and a comprehensive attack methodology to audit vulnerabilities in webserver infrastructure, and countermeasures. Web application attacks, comprehensive web application hacking methodology to audit vulnerabilities in web applications, and countermeasures. SQL injection attack techniques, injection detection tools to detect SQL injection attempts, and countermeasures. Wireless encryption, wireless hacking methodology, wireless hacking tools, and Wi-Fi security tools. Mobile platform attack vector, android vulnerability exploitations, and mobile security guidelines and tools. Firewall, IDS and honeypot evasion techniques, evasion tools and techniques to audit a network perimeter for weaknesses, and countermeasures. Cloud computing concepts (Container technology, serverless computing), the working of various threats and attacks, and security techniques and tools. Penetration testing, security audit, vulnerability assessment, and penetration testing roadmap. Threats to IoT and OT platforms and defending IoT and OT devices. Cryptography ciphers, Public Key Infrastructure (PKI), cryptography attacks, and cryptanalysis tools.</p><p>CEH provides an in-depth understanding of ethical hacking phases, various attack vectors, and preventative countermeasures. It will teach you how hackers think and act maliciously so you will be better positioned to setup your security infrastructure and defend against future attacks. An understanding of system weaknesses and vulnerabilities helps organizations strengthen their system security controls to minimize the risk of an incident. CEH was built to incorporate a hands-on environment and systematic process across each ethical hacking domain and methodology, giving you the opportunity to work towards proving the required knowledge and skills needed to achieve the CEH credential. You will be exposed to an entirely different posture toward the responsibilities and measures required to be secure. Now in its 12th version, CEH continues to evolve with the latest operating systems, tools, tactics, exploits, and technologies.</p></div><div id="course-pills-2"><h3>1 - Introduction to Ethical Hacking</h3> <ul> <li>Information Security Overview</li> <li>Cyber Kill Chain Concepts</li> <li>Hacking Concepts</li> <li>Ethical Hacking Concepts</li> <li>Information Security Controls</li> <li>Information Security Laws and Standards</li> </ul> <h3>2 - 2 - Foot-printing and Reconnaissance</h3> <ul> <li>Footprinting Concepts</li> <li>Footprinting through Search Engines</li> <li>Footprinting through Web Services</li> <li>Footprinting through Social Networking Sites</li> <li>Website Footprinting</li> <li>Email Footprinting</li> <li>Who is Footprinting</li> <li>DNS Footprinting</li> <li>Network Footprinting</li> <li>Footprinting through Social Engineering</li> <li>Footprinting Tools</li> <li>Footprinting Countermeasures</li> </ul> <h3>3 - Scanning Networks</h3> <ul> <li>Network Scanning Concepts</li> <li>Scanning Tools</li> <li>Host Discovery</li> <li>Port and Service Discovery</li> <li>OS Discovery (Banner Grabbing/OS Fingerprinting) </li><li>Scanning Beyond IDS and Firewall</li> <li>Draw Network Diagrams</li> </ul> <h3>4 - Enumeration</h3> <ul> <li>Enumeration Concepts</li> <li>NetBIOS Enumeration</li> <li>SNMP Enumeration</li> <li>LDAP Enumeration</li> <li>NTP and NFS Enumeration</li> <li>SMTP and DNS Enumeration</li> <li>Other Enumeration Techniques</li> <li>Enumeration Countermeasures</li> </ul> <h3>5 - Vulnerability Analysis</h3> <ul> <li>Vulnerability Assessment Concepts</li> <li>Vulnerability Classification and Assessment Types</li> <li>Vulnerability Assessment Solutions and Tools</li> <li>Vulnerability Assessment Reports</li> </ul> <h3>6 - System Hacking</h3> <ul> <li>System Hacking Concepts</li> <li>Gaining Access</li> <li>Escalating Privileges</li> <li>Maintaining Access</li> <li>Clearing Logs</li> </ul> <h3>7 - Malware Threats</h3> <ul> <li>Malware Concepts</li> <li>APT Concepts</li> <li>Trojan Concepts</li> <li>Virus and Worm Concepts</li> <li>Fileless Malware Concepts</li> <li>Malware Analysis</li> <li>Countermeasures</li> <li>Anti-Malware Software</li> </ul> <h3>8 - Sniffing</h3> <ul> <li>Sniffing Concepts</li> <li>Sniffing Technique: MAC Attacks</li> <li>Sniffing Technique: DHCP Attacks</li> <li>Sniffing Technique: ARP Poisoning</li> <li>Sniffing Technique: Spoofing Attacks</li> <li>Sniffing Technique: DNS Poisoning</li> <li>Sniffing Tools</li> <li>Countermeasures</li> <li>Sniffing Detection Techniques</li> </ul> <h3>9 - Social Engineering</h3> <ul> <li>Social Engineering Concepts</li> <li>Social Engineering Techniques</li> <li>Insider Threats</li> <li>Impersonation on Social Networking Sites</li> <li>Identity Theft</li> <li>Countermeasures</li> </ul> <h3>10 - Denial-of-Service</h3> <ul> <li>DoS/DDoS Concepts</li> <li>DoS/DDoS Attack Techniques</li> <li>BotnetsDDoS Case Study</li> <li>DoS/DDoS Attack Tools</li> <li>Countermeasures</li> <li>DoS/DDoS Protection Tools</li> </ul> <h3>11 - Session Hijacking</h3> <ul> <li>Session Hijacking Concepts</li> <li>Application Level Session Hijacking</li> <li>Network Level Session Hijacking</li> <li>Session Hijacking Tools</li> <li>Countermeasures</li> </ul> <h3>12 - Evading IDS, Firewalls, and Honeypots</h3> <ul> <li>IDS, IPS, Firewall, and Honeypot Concepts</li> <li>IDS, IPS, Firewall, and Honeypot Solutions</li> <li>Evading IDS</li> <li>Evading Firewalls</li> <li>IDS/Firewall Evading Tools</li> <li>Detecting Honeypots</li> <li>IDS/Firewall Evasion Countermeasures</li> </ul> <h3>13 - Hacking Web Servers</h3> <ul> <li>Web Server Concepts</li> <li>Web Server Attacks</li> <li>Web Server Attack Methodology</li> <li>Web Server Attack Tools</li> <li>Countermeasures</li> <li>Patch Management</li> <li>Web Server Security Tools</li> </ul> <h3>14 - Hacking Web Applications</h3> <ul> <li>Web Application Concepts</li> <li>Web Application Threats</li> <li>Web Application Hacking Methodology</li> <li>Web API, Webhooks, and Web Shell</li> <li>Web Application Security</li> </ul> <h3>15 - SQL Injection</h3> <ul> <li>SQL Injection Concepts</li> <li>Types of SQL Injection</li> <li>SQL Injection Methodology</li> <li>SQL Injection Tools</li> <li>Evasion Techniques</li> <li>Countermeasures</li> </ul> <h3>16 - Hacking Wireless Networks</h3> <ul> <li>Wireless Concepts</li> <li>Wireless Encryption</li> <li>Wireless Threats</li> <li>Wireless Hacking Methodology</li> <li>Wireless Hacking Tools</li> <li>Bluetooth Hacking</li> <li>Countermeasures</li> <li>Wireless Security Tools</li> </ul> <h3>17 - Hacking Mobile Platforms</h3> <ul> <li>Mobile Platform Attack Vectors</li> <li>Hacking Android OS</li> <li>Hacking iOS</li> <li>Mobile Device Management</li> <li>Mobile Security Guidelines and Tools</li> </ul> <h3>18 - IoT and OT Hacking</h3> <ul> <li>IoT Hacking</li> <li>IoT Concepts</li> <li>IoT Attacks</li> <li>IoT Hacking Methodology</li> <li>IoT Hacking Tools</li> <li>Countermeasures</li> <li>OT Hacking</li> <li>OT Concepts</li> <li>OT Attacks</li> <li>OT Hacking Methodology</li> <li>OT Hacking Tools</li> <li>Countermeasures</li> </ul> <h3>19 - Cloud Computing</h3> <ul> <li>Cloud Computing Concepts</li> <li>Container Technology</li> <li>Serverless Computing</li> <li>Cloud Computing Threats</li> <li>Cloud Hacking</li> <li>Cloud Security</li> </ul> <h3>20 - Cryptography</h3> <ul> <li>Cryptography Concepts</li> <li>Encryption Algorithms</li> <li>Cryptography Tools</li> <li>Public Key Infrastructure (PKI) </li><li>Email Encryption</li> <li>Disk Encryption</li> <li>Cryptanalysis</li> <li>Countermeasures</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans EC-Council Certified Ethical Hacker (CEH) v.12 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the EC-Council Certified Ethical Hacker (CEH) v.12 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.  <p></p>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.<p></p></div>

Certified in Cybersecurity (CC)

IT Certifications

Cyber Security

Certified Ethical Hacker (CEH)

Certified Cyber Professional (CCP)

Ethical Hacking

EC-Council Certified Ethical Hacker (CEH) v12

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is for experienced information technology (IT) professionals, typically described as Enterprise Desktop Administrators (EDAs). These EDAs deploy, manage, and maintain PCs, devices, and applications across medium, large, and enterprise organizations. A significant portion of this audience uses, or intends to use, the latest release of Configuration Manager to manage and deploy PCs, devices, and applications.</p>Overview<p>Describe the features Configuration Manager and Intune include, and explain how you can use these features to manage PCs and mobile devices in an enterprise environment. Analyze data by using queries and reports. Prepare a management infrastructure, including configuring boundaries, boundary groups, and resource discovery, and integrating mobile-device management with Intune. Deploy and manage the Configuration Manager client. Configure, manage, and monitor hardware and software inventory, and use Asset Intelligence and software metering. Identify and configure the most appropriate method to distribute and manage content used for deployments. Distribute, deploy, and monitor applications for managed users and systems. Maintain software updates for PCs that Configuration Manager manages. Implement Endpoint Protection for managed PCs. Configure an operating-system deployment strategy by using Configuration Manager. Manage and maintain a Configuration Manager site.</p><p>This five-day course describes how to use Configuration Manager and its associated site systems to efficiently manage network resources. In this five-day course, you will learn day-to-day management tasks, including how to manage applications, client health, hardware and software inventory, operating system deployment, and software updates by using Configuration Manager. You also will learn how to optimize Endpoint Protection, manage compliance, and create management queries and reports.  Although this course and the associated labs are written for Microsoft Endpoint Configuration Manager and Windows 11, the skills taught will also be backwards compatible with previous editions of System Center Configuration Manager and Windows 10.</p>Prerequisites<p></p><li>Networking fundamentals, including common networking protocols, topologies, hardware, media, routing, switching, and addressing.</li>  <li>Active Directory Domain Services (AD DS) principles and fundamentals of AD DS management.</li>  <li>Installation, configuration, and troubleshooting for Windows-based personal computers.</li>  <li>Basic concepts of public key infrastructure (PKI) security.</li>  <li>Basic understanding of scripting and Windows PowerShell syntax.</li>  <li>Basic understanding of Windows Server roles and services.</li>  <li>Basic understanding of the configuration options for iOS and Android Mobile device platforms.</li><p></p></div><div id="course-pills-2"><h3>1 - Managing computers and mobile devices in the enterprise</h3> <ul> <li>Overview of systems management by using enterprise management solutions</li> <li>Overview of the Configuration Manager architecture</li> <li>Overview of the Configuration Manager administrative tools</li> <li>Tools for monitoring and troubleshooting a Configuration Manager site</li> </ul> <h3>2 - Analyzing data using queries, reports, and CMPivot</h3> <ul> <li>Introduction to queries</li> <li>Configuring SQL Server Reporting Services</li> <li>Analyzing the real-time state of a device by using CMPivot</li> </ul> <h3>3 - Preparing the Configuration Manager management infrastructure</h3> <ul> <li>Configuring site boundaries and boundary groups</li> <li>Configuring resource discovery</li> <li>Organizing resources using device and user collections</li> </ul> <h3>4 - Deploying and managing the Configuration Manager client</h3> <ul> <li>Overview of the Configuration Manager client</li> <li>Deploying the Configuration Manager client</li> <li>Configuring and monitoring client status</li> <li>Managing client settings and performing management operations</li> </ul> <h3>5 - Managing inventory for PCs and applications</h3> <ul> <li>Overview of inventory collection</li> <li>Configuring hardware and software inventory</li> <li>Managing inventory collection</li> <li>Configuring software metering</li> <li>Configuring and managing Asset Intelligence</li> </ul> <h3>6 - Distributing and managing content used for deployments</h3> <ul> <li>Preparing the infrastructure for content management</li> <li>Distributing and managing content on distribution points</li> </ul> <h3>7 - Deploying and managing applications</h3> <ul> <li>Overview of application management</li> <li>Creating applications</li> <li>Deploying applications</li> <li>Managing applications</li> <li>Deploying and managing Windows apps</li> </ul> <h3>8 - Maintaining software updates for managed PCs</h3> <ul> <li>The software updates process</li> <li>Preparing a Configuration Manager site for software updates</li> <li>Managing software updates</li> <li>Configuring automatic deployment rules</li> <li>Monitoring and troubleshooting software updates</li> <li>Enabling third-party updates</li> </ul> <h3>9 - Implementing Defender Protection for managed PCs</h3> <ul> <li>Overview of Endpoint Protection in Configuration Manager</li> <li>Configuring, deploying, and monitoring Endpoint Protection policies</li> <li>Configuring and deploying advanced threat policies</li> <h3>10 - Managing compliance and secure data access</h3> <ul> <li>Overview of Compliance Settings</li> <li>Configuring compliance settings</li> <li>Viewing compliance results</li> <li>Managing resource and data access</li> <h3>11 - Managing operating system deployment</h3> <ul> <li>An overview of operating system deployment</li> <li>Preparing a site for operating system deployment</li> <li>Deploying an operating system</li> <li>Managing Windows as a service</li> <h3>12 - Managing and maintaining a Configuration Manager site</h3> <ul> <li>Configuring role-based administration</li> <li>Configuring Remote Tools</li> <li>Overview of Configuration Manager site maintenance and Management Insights</li> <li>Backing up and recovering a Configuration Manager site</li> <li>Updating the Configuration Manager infrastructure</li> <h3>13 - What?s new in Microsoft Endpoint Configuration Manager</h3> <ul> <li>Whats new in Microsoft Endpoint Manager covering each semi annual release</li> </ul></ul></ul></ul></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55348: Administering Microsoft Endpoint Configuration Manager training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the 55348: Administering Microsoft Endpoint Configuration Manager 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.  <p></p>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.<p></p></div>

Microsoft Certification

Sccm

Microsoft Certified Technology Specialist (MCTS)

Commercial & Contract Management Certification Program (CCM)

IT Manager

Microsoft Certified Trainer (MCT)

55348 Administering Microsoft Endpoint Configuration Manager

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>The Microsoft Security Operations Analyst collaborates with organizational stakeholders to secure information technology systems for the organization. Their goal is to reduce organizational risk by rapidly remediating active attacks in the environment, advising on improvements to threat protection practices, and referring violations of organizational policies to appropriate stakeholders. Responsibilities include threat management, monitoring, and response by using a variety of security solutions across their environment. The role primarily investigates, responds to, and hunts for threats using Microsoft Sentinel, Microsoft Defender for Cloud, Microsoft 365 Defender, and third-party security products. Since the Security Operations Analyst consumes the operational output of these tools, they are also a critical stakeholder in the configuration and deployment of these technologies.</p><p></p><p></p><p>Learn how to investigate, respond to, and hunt for threats using Microsoft Sentinel, Microsoft Defender for Cloud, and Microsoft 365 Defender. In this course you will learn how to mitigate cyberthreats using these technologies. Specifically, you will configure and use Microsoft Sentinel as well as utilize Kusto Query Language (KQL) to perform detection, analysis, and reporting. The course was designed for people who work in a Security Operations job role and helps learners prepare for the exam SC-200: Microsoft Security Operations Analyst.</p><p></p>Prerequisites<p></p><li>Basic understanding of Microsoft 365</li>  <li>Fundamental understanding of Microsoft security, compliance, and identity products</li>   <li> Intermediate understanding of Windows 10</li>  <li> Familiarity with Azure services, specifically Azure SQL Database and Azure Storage</li>   <li> Familiarity with Azure virtual machines and virtual networking</li>   <li>Basic understanding of scripting concepts.</li><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Microsoft 365 threat protection</h3> <ul> <li>Explore Extended Detection &amp; Response (XDR) response use cases</li> <li>Understand Microsoft Defender XDR in a Security Operations Center (SOC)</li> <li>Explore Microsoft Security Graph</li> <li>Investigate security incidents in Microsoft Defender XDR</li> </ul> <h3>2 - Mitigate incidents using Microsoft 365 Defender</h3> <ul> <li>Use the Microsoft Defender portal</li> <li>Manage incidents</li> <li>Investigate incidents</li> <li>Manage and investigate alerts</li> <li>Manage automated investigations</li> <li>Use the action center</li> <li>Explore advanced hunting</li> <li>Investigate Microsoft Entra sign-in logs</li> <li>Understand Microsoft Secure Score</li> <li>Analyze threat analytics</li> <li>Analyze reports</li> <li>Configure the Microsoft Defender portal</li> </ul> <h3>3 - Protect your identities with Microsoft Entra ID Protection</h3> <ul> <li>Microsoft Entra ID Protection overview</li> <li>Detect risks with Microsoft Entra ID Protection policies</li> <li>Investigate and remediate risks detected by Microsoft Entra ID Protection</li> </ul> <h3>4 - Remediate risks with Microsoft Defender for Office 365</h3> <ul> <li>Automate, investigate, and remediate</li> <li>Configure, protect, and detect</li> <li>Simulate attacks</li> </ul> <h3>5 - Safeguard your environment with Microsoft Defender for Identity</h3> <ul> <li>Configure Microsoft Defender for Identity sensors</li> <li>Review compromised accounts or data</li> <li>Integrate with other Microsoft tools</li> </ul> <h3>6 - Secure your cloud apps and services with Microsoft Defender for Cloud Apps</h3> <ul> <li>Understand the Defender for Cloud Apps Framework</li> <li>Explore your cloud apps with Cloud Discovery</li> <li>Protect your data and apps with Conditional Access App Control</li> <li>Walk through discovery and access control with Microsoft Defender for Cloud Apps</li> <li>Classify and protect sensitive information</li> <li>Detect Threats</li> </ul> <h3>7 - Respond to data loss prevention alerts using Microsoft 365</h3> <ul> <li>Describe data loss prevention alerts</li> <li>Investigate data loss prevention alerts in Microsoft Purview</li> <li>Investigate data loss prevention alerts in Microsoft Defender for Cloud Apps</li> </ul> <h3>8 - Manage insider risk in Microsoft Purview</h3> <ul> <li>Insider risk management overview</li> <li>Create and manage insider risk policies</li> <li>Investigate insider risk alerts</li> <li>Take action on insider risk alerts through cases</li> <li>Manage insider risk management forensic evidence</li> <li>Create insider risk management notice templates</li> </ul> <h3>9 - Investigate threats by using audit features in Microsoft Defender XDR and Microsoft Purview Standard</h3> <ul> <li>Explore Microsoft Purview Audit solutions</li> <li>Implement Microsoft Purview Audit (Standard)</li> <li>Start recording activity in the Unified Audit Log</li> <li>Search the Unified Audit Log (UAL)</li> <li>Export, configure, and view audit log records</li> <li>Use audit log searching to investigate common support issues</li> </ul> <h3>10 - Investigate threats using audit in Microsoft Defender XDR and Microsoft Purview (Premium)</h3> <ul> <li>Explore Microsoft Purview Audit (Premium)</li> <li>Implement Microsoft Purview Audit (Premium)</li> <li>Manage audit log retention policies</li> <li>Investigate compromised email accounts using Purview Audit (Premium)</li> </ul> <h3>11 - Investigate threats with Content search in Microsoft Purview</h3> <ul> <li>Explore Microsoft Purview eDiscovery solutions</li> <li>Create a content search</li> <li>View the search results and statistics</li> <li>Export the search results and search report</li> <li>Configure search permissions filtering</li> <li>Search for and delete email messages</li> </ul> <h3>12 - Protect against threats with Microsoft Defender for Endpoint</h3> <ul> <li>Practice security administration</li> <li>Hunt threats within your network</li> </ul> <h3>13 - Deploy the Microsoft Defender for Endpoint environment</h3> <ul> <li>Create your environment</li> <li>Understand operating systems compatibility and features</li> <li>Onboard devices</li> <li>Manage access</li> <li>Create and manage roles for role-based access control</li> <li>Configure device groups</li> <li>Configure environment advanced features</li> </ul> <h3>14 - Implement Windows security enhancements with Microsoft Defender for Endpoint</h3> <ul> <li>Understand attack surface reduction</li> <li>Enable attack surface reduction rules</li> </ul> <h3>15 - Perform device investigations in Microsoft Defender for Endpoint</h3> <ul> <li>Use the device inventory list</li> <li>Investigate the device</li> <li>Use behavioral blocking</li> <li>Detect devices with device discovery</li> </ul> <h3>16 - Perform actions on a device using Microsoft Defender for Endpoint</h3> <ul> <li>Explain device actions</li> <li>Run Microsoft Defender antivirus scan on devices</li> <li>Collect investigation package from devices</li> <li>Initiate live response session</li> </ul> <h3>17 - Perform evidence and entities investigations using Microsoft Defender for Endpoint</h3> <ul> <li>Investigate a file</li> <li>Investigate a user account</li> <li>Investigate an IP address</li> <li>Investigate a domain</li> </ul> <h3>18 - Configure and manage automation using Microsoft Defender for Endpoint</h3> <ul> <li>Configure advanced features</li> <li>Manage automation upload and folder settings</li> <li>Configure automated investigation and remediation capabilities</li> <li>Block at risk devices</li> </ul> <h3>19 - Configure for alerts and detections in Microsoft Defender for Endpoint</h3> <ul> <li>Configure advanced features</li> <li>Configure alert notifications</li> <li>Manage alert suppression</li> <li>Manage indicators</li> </ul> <h3>20 - Utilize Vulnerability Management in Microsoft Defender for Endpoint</h3> <ul> <li>Understand vulnerability management</li> <li>Explore vulnerabilities on your devices</li> <li>Manage remediation</li> </ul> <h3>21 - Plan for cloud workload protections using Microsoft Defender for Cloud</h3> <ul> <li>Explain Microsoft Defender for Cloud</li> <li>Describe Microsoft Defender for Cloud workload protections</li> <li>Enable Microsoft Defender for Cloud</li> </ul> <h3>22 - Connect Azure assets to Microsoft Defender for Cloud</h3> <ul> <li>Explore and manage your resources with asset inventory</li> <li>Configure auto provisioning</li> <li>Manual log analytics agent provisioning</li> </ul> <h3>23 - Connect non-Azure resources to Microsoft Defender for Cloud</h3> <ul> <li>Protect non-Azure resources</li> <li>Connect non-Azure machines</li> <li>Connect your AWS accounts</li> <li>Connect your GCP accounts</li> </ul> <h3>24 - Manage your cloud security posture management?</h3> <ul> <li>Explore Secure Score</li> <li>Explore Recommendations</li> <li>Measure and enforce regulatory compliance</li> <li>Understand Workbooks</li> </ul> <h3>25 - Explain cloud workload protections in Microsoft Defender for Cloud</h3> <ul> <li>Understand Microsoft Defender for servers</li> <li>Understand Microsoft Defender for App Service</li> <li>Understand Microsoft Defender for Storage</li> <li>Understand Microsoft Defender for SQL</li> <li>Understand Microsoft Defender for open-source databases</li> <li>Understand Microsoft Defender for Key Vault</li> <li>Understand Microsoft Defender for Resource Manager</li> <li>Understand Microsoft Defender for DNS</li> <li>Understand Microsoft Defender for Containers</li> <li>Understand Microsoft Defender additional protections</li> </ul> <h3>26 - Remediate security alerts using Microsoft Defender for Cloud</h3> <ul> <li>Understand security alerts</li> <li>Remediate alerts and automate responses</li> <li>Suppress alerts from Defender for Cloud</li> <li>Generate threat intelligence reports</li> <li>Respond to alerts from Azure resources</li> </ul> <h3>27 - Construct KQL statements for Microsoft Sentinel</h3> <ul> <li>Understand the Kusto Query Language statement structure</li> <li>Use the search operator</li> <li>Use the where operator</li> <li>Use the let statement</li> <li>Use the extend operator</li> <li>Use the order by operator</li> <li>Use the project operators</li> </ul> <h3>28 - Analyze query results using KQL</h3> <ul> <li>Use the summarize operator</li> <li>Use the summarize operator to filter results</li> <li>Use the summarize operator to prepare data</li> <li>Use the render operator to create visualizations</li> </ul> <h3>29 - Build multi-table statements using KQL</h3> <ul> <li>Use the union operator</li> <li>Use the join operator</li> </ul> <h3>30 - Work with data in Microsoft Sentinel using Kusto Query Language</h3> <ul> <li>Extract data from unstructured string fields</li> <li>Extract data from structured string data</li> <li>Integrate external data</li> <li>Create parsers with functions</li> </ul> <h3>31 - Introduction to Microsoft Sentinel</h3> <ul> <li>What is Microsoft Sentinel?</li> <li>How Microsoft Sentinel works</li> <li>When to use Microsoft Sentinel</li> </ul> <h3>32 - Create and manage Microsoft Sentinel workspaces</h3> <ul> <li>Plan for the Microsoft Sentinel workspace</li> <li>Create a Microsoft Sentinel workspace</li> <li>Manage workspaces across tenants using Azure Lighthouse</li> <li>Understand Microsoft Sentinel permissions and roles</li> <li>Manage Microsoft Sentinel settings</li> <li>Configure logs</li> </ul> <h3>33 - Query logs in Microsoft Sentinel</h3> <ul> <li>Query logs in the logs page</li> <li>Understand Microsoft Sentinel tables</li> <li>Understand common tables</li> <li>Understand Microsoft Defender XDR tables</li> </ul> <h3>34 - Use watchlists in Microsoft Sentinel</h3> <ul> <li>Plan for watchlists</li> <li>Create a watchlist</li> <li>Manage watchlists</li> </ul> <h3>35 - Utilize threat intelligence in Microsoft Sentinel</h3> <ul> <li>Define threat intelligence</li> <li>Manage your threat indicators</li> <li>View your threat indicators with KQL</li> </ul> <h3>36 - Connect data to Microsoft Sentinel using data connectors</h3> <ul> <li>Ingest log data with data connectors</li> <li>Understand data connector providers</li> <li>View connected hosts</li> </ul> <h3>37 - Connect Microsoft services to Microsoft Sentinel</h3> <ul> <li>Plan for Microsoft services connectors</li> <li>Connect the Microsoft Office 365 connector</li> <li>Connect the Microsoft Entra connector</li> <li>Connect the Microsoft Entra ID Protection connector</li> <li>Connect the Azure Activity connector</li> </ul> <h3>38 - Connect Microsoft Defender XDR to Microsoft Sentinel</h3> <ul> <li>Plan for Microsoft Defender XDR connectors</li> <li>Connect the Microsoft Defender XDR connector</li> <li>Connect Microsoft Defender for Cloud connector</li> <li>Connect Microsoft Defender for IoT</li> <li>Connect Microsoft Defender legacy connectors</li> </ul> <h3>39 - Connect Windows hosts to Microsoft Sentinel</h3> <ul> <li>Plan for Windows hosts security events connector</li> <li>Connect using the Windows Security Events via AMA Connector</li> <li>Connect using the Security Events via Legacy Agent Connector</li> <li>Collect Sysmon event logs</li> </ul> <h3>40 - Connect Common Event Format logs to Microsoft Sentinel</h3> <ul> <li>Plan for Common Event Format connector</li> <li>Connect your external solution using the Common Event Format connector</li> </ul> <h3>41 - Connect syslog data sources to Microsoft Sentinel</h3> <ul> <li>Plan for syslog data collection</li> <li>Collect data from Linux-based sources using syslog</li> <li>Configure the Data Collection Rule for Syslog Data Sources</li> <li>Parse syslog data with KQL</li> </ul> <h3>42 - Connect threat indicators to Microsoft Sentinel</h3> <ul> <li>Plan for threat intelligence connectors</li> <li>Connect the threat intelligence TAXII connector</li> <li>Connect the threat intelligence platforms connector</li> <li>View your threat indicators with KQL</li> </ul> <h3>43 - Threat detection with Microsoft Sentinel analytics</h3> <ul> <li>What is Microsoft Sentinel Analytics?</li> <li>Types of analytics rules</li> <li>Create an analytics rule from templates</li> <li>Create an analytics rule from wizard</li> <li>Manage analytics rules</li> </ul> <h3>44 - Automation in Microsoft Sentinel</h3> <ul> <li>Understand automation options</li> <li>Create automation rules</li> </ul> <h3>45 - Threat response with Microsoft Sentinel playbooks</h3> <ul> <li>What are Microsoft Sentinel playbooks?</li> <li>Trigger a playbook in real-time</li> <li>Run playbooks on demand</li> </ul> <h3>46 - Security incident management in Microsoft Sentinel</h3> <ul> <li>Understand incidents</li> <li>Incident evidence and entities</li> <li>Incident management</li> </ul> <h3>47 - Identify threats with Behavioral Analytics</h3> <ul> <li>Understand behavioral analytics</li> <li>Explore entities</li> <li>Display entity behavior information</li> <li>Use Anomaly detection analytical rule templates</li> </ul> <h3>48 - Data normalization in Microsoft Sentinel</h3> <ul> <li>Understand data normalization</li> <li>Use ASIM Parsers</li> <li>Understand parameterized KQL functions</li> <li>Create an ASIM Parser</li> <li>Configure Azure Monitor Data Collection Rules</li> </ul> <h3>49 - Query, visualize, and monitor data in Microsoft Sentinel</h3> <ul> <li>Monitor and visualize data</li> <li>Query data using Kusto Query Language</li> <li>Use default Microsoft Sentinel Workbooks</li> <li>Create a new Microsoft Sentinel Workbook</li> </ul> <h3>50 - Manage content in Microsoft Sentinel</h3> <ul> <li>Use solutions from the content hub</li> <li>Use repositories for deployment</li> </ul> <h3>51 - Explain threat hunting concepts in Microsoft Sentinel</h3> <ul> <li>Understand cybersecurity threat hunts</li> <li>Develop a hypothesis</li> <li>Explore MITRE ATT&amp;CK</li> </ul> <h3>52 - Threat hunting with Microsoft Sentinel</h3> <ul> <li>Explore creation and management of threat-hunting queries</li> <li>Save key findings with bookmarks</li> <li>Observe threats over time with livestream</li> </ul> <h3>53 - Use Search jobs in Microsoft Sentinel</h3> <ul> <li>Hunt with a Search Job</li> <li>Restore historical data</li> </ul> <h3>54 - Hunt for threats using notebooks in Microsoft Sentinel</h3> <ul> <li>Access Azure Sentinel data with external tools</li> <li>Hunt with notebooks</li> <li>Create a notebook</li> <li>Explore notebook code</li> </ul></div>

Microsoft AZ-900

Microsoft AZ-104

Microsoft SC-200

Microsoft AZ-303

Microsoft AZ-700

SC-200T00 Microsoft Security Operations Analyst

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>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.</p><p></p><p></p><p>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.</p><p></p>Prerequisites<p>Before attending this course, students must have: </p><ul><li>-Experience with Windows networking technologies and implementation.</li> <li>- Experience with Windows Server administration, maintenance, and troubleshooting.</li></ul><p></p></div><div id="course-pills-2"><h3>1 - Review Windows PowerShell</h3> <ul> <li>Learn about Windows PowerShell</li> <li>Get familiar with Windows PowerShell applications</li> <li>Identify factors to install and use Windows PowerShell</li> <li>Configure the Windows PowerShell console</li> <li>Configure the Windows PowerShell Integrated Scripting Environment (ISE)</li> <li>Use Visual Studio Code with PowerShell</li> </ul> <h3>2 - Understand the command syntax in Windows PowerShell</h3> <ul> <li>Discover the structure of PowerShell cmdlets</li> <li>Discover the parameters for using PowerShell cmdlets</li> <li>Review the tab completion feature in PowerShell</li> <li>Display the About files content in PowerShell</li> </ul> <h3>3 - Find commands and Get-Help in Windows PowerShell</h3> <ul> <li>Define modules in PowerShell</li> <li>Find cmdlets in PowerShell</li> <li>Use command aliases in PowerShell</li> <li>Use Show-Command and Get-Help in PowerShell</li> <li>Interpret the help file contents and update the local help content in PowerShell</li> </ul> <h3>4 - Manage Active Directory Domain Services using PowerShell cmdlets</h3> <ul> <li>Manage user accounts in PowerShell</li> <li>Manage groups and group memberships in PowerShell</li> <li>Manage computer accounts in PowerShell</li> <li>Manage organizational units and Active Directory objects in PowerShell</li> </ul> <h3>5 - Manage network service settings for Windows devices using PowerShell cmdlets</h3> <ul> <li>Manage IP addresses in PowerShell</li> <li>Manage IP routing in PowerShell</li> <li>Manage DNS clients in PowerShell</li> <li>Manage Windows Firewall settings in PowerShell</li> </ul> <h3>6 - Manage Windows Server settings using PowerShell cmdlets</h3> <ul> <li>Automate management tasks using the Group Policy management cmdlets</li> <li>Manage server roles and services using PowerShell cmdlets</li> <li>Manage Hyper-V Virtual Machines using PowerShell cmdlets</li> <li>Manage Internet Information Services using PowerShell cmdlets</li> </ul> <h3>7 - Manage settings for a local Windows machine using PowerShell cmdlets</h3> <ul> <li>Manage Windows 10 using PowerShell</li> <li>Manage permissions with PowerShell</li> </ul> <h3>8 - Understand the Windows PowerShell pipeline</h3> <ul> <li>Review Windows PowerShell pipeline and its output</li> <li>Discover object members in PowerShell</li> <li>Control the formatting of pipeline output</li> </ul> <h3>9 - Select, sort, and measure objects using the pipeline</h3> <ul> <li>Sort and group objects by property in the pipeline</li> <li>Measure objects in the pipeline</li> <li>Select a set of objects in the pipeline</li> <li>Select object properties in the pipeline</li> <li>Create and format calculated properties in the pipeline</li> </ul> <h3>10 - Filter objects out of the pipeline</h3> <ul> <li>Learn about the comparison operators in PowerShell</li> <li>Review basic filter syntax in the pipeline</li> <li>Review advanced filter syntax in the pipeline</li> <li>Optimize the filter performance in the pipeline</li> </ul> <h3>11 - Enumerate objects in the pipeline</h3> <ul> <li>Learn about enumerations in the pipeline</li> <li>Review basic syntax to enumerate objects in the pipeline</li> <li>Review advanced syntax to enumerate objects in the pipeline</li> </ul> <h3>12 - Send and pass data as output from the pipeline</h3> <ul> <li>Write pipeline data to a file</li> <li>Convert pipeline objects to other forms of data representation in PowerShell</li> <li>Control additional output options in PowerShell</li> </ul> <h3>13 - Pass pipeline objects</h3> <ul> <li>Pipeline parameter binding</li> <li>Identify ByValue parameters</li> <li>Pass data by using ByValue</li> <li>Pass data by using ByPropertyName</li> <li>Identify ByPropertyName parameters</li> <li>Use manual parameters to override the pipeline</li> <li>Use parenthetical commands</li> <li>Expand property values</li> </ul> <h3>14 - Connect with data stores using PowerShell providers</h3> <ul> <li>Define Windows PowerShell providers</li> <li>Review the built-in providers in PowerShell</li> <li>Access provider help in PowerShell</li> </ul> <h3>15 - Use PowerShell drives in PowerShell</h3> <ul> <li>Explain PowerShell drives in PowerShell</li> <li>Use PowerShell drive cmdlets in PowerShell</li> <li>Manage the file system in PowerShell</li> <li>Manage the registry in PowerShell</li> <li>Work with certificates in PowerShell</li> <li>Work with other PowerShell drives in PowerShell</li> </ul> <h3>16 - Review CIM and WMI</h3> <ul> <li>Review architecture of CIM and WMI</li> <li>Review repositories in CIM and WMI</li> <li>Locate online class documentation by using CIM and WMI cmdlets</li> </ul> <h3>17 - Query configuration information by using CIM and WMI</h3> <ul> <li>List local repository namespaces and classes by using CIM and WMI</li> <li>Query instances by using commands and WMI Query Language</li> <li>Connect to remote computers by using CIM and WMI cmdlets</li> <li>Query repository classes from remote computers by using CIMSession objects</li> </ul> <h3>18 - Query and manipulate repository objects by using CIM and WMI methods</h3> <ul> <li>Discover methods of repository objects by using CIM and WMI</li> <li>Locate class methods and documentation by using CIM and WMI</li> <li>Invoke methods of repository objects by using CIM and WMI</li> </ul> <h3>19 - Manage variables in Windows PowerShell scripts</h3> <ul> <li>Define variables in Windows PowerShell scripts</li> <li>Create variable names in Windows PowerShell scripts</li> <li>Assign values and types to variables in Windows PowerShell scripts</li> <li>Identify the methods and properties of variables in Windows PowerShell scripts</li> <li>Use string variables and methods in Windows PowerShell scripts</li> <li>Use date variables and methods in Windows PowerShell scripts</li> </ul> <h3>20 - Work with arrays and hash tables in Windows PowerShell scripts</h3> <ul> <li>Define an array in Windows PowerShell scripts</li> <li>Work with array lists in Windows PowerShell scripts</li> <li>Define hash tables in Windows PowerShell Scripts</li> <li>Work with hash tables in Windows PowerShell scripts</li> </ul> <h3>21 - Create and run scripts by using Windows PowerShell</h3> <ul> <li>Review Windows PowerShell scripts</li> <li>Modify scripts in the PowerShell Gallery</li> <li>Create scripts using Windows PowerShell</li> <li>Review the PowerShellGet module in Windows PowerShell</li> <li>Run scripts and set the execution policy in Windows PowerShell</li> <li>Review Windows PowerShell and AppLocker</li> <li>Sign the scripts digitally in Windows PowerShell</li> </ul> <h3>22 - Work with scripting constructs in Windows PowerShell</h3> <ul> <li>Review and use the ForEach loop in Windows PowerShell scripts</li> <li>Review and use the If construct in Windows PowerShell scripts</li> <li>Review and use the Switch construct in Windows PowerShell scripts</li> <li>Review the For construct in Windows PowerShell scripts</li> <li>Review other loop constructs in Windows PowerShell scripts</li> <li>Review Break and Continue in Windows PowerShell scripts</li> </ul> <h3>23 - Import data in different formats for use in scripts by using Windows PowerShell cmdlets</h3> <ul> <li>Use the Get-Content command in Windows PowerShell scripts</li> <li>Use the Import-Csv cmdlet in Windows PowerShell scripts</li> <li>Use the Import-Clixml cmdlet in Windows PowerShell scripts</li> <li>Use the ConvertFrom-Json cmdlet in Windows PowerShell scripts</li> </ul> <h3>24 - Use methods to accept user inputs in Windows PowerShell scripts</h3> <ul> <li>Identify values that might change in Windows PowerShell scripts</li> <li>Use the Read-Host cmdlet in Windows PowerShell scripts</li> <li>Use the Get-Credential cmdlet in Windows PowerShell scripts</li> <li>Use the Out-GridView cmdlet in Windows PowerShell scripts</li> <li>Pass parameters to a Windows PowerShell script</li> </ul> <h3>25 - Troubleshoot scripts and handle errors in Windows PowerShell</h3> <ul> <li>Interpret error messages generated for Windows PowerShell commands</li> <li>Add output to Windows PowerShell scripts</li> <li>Use breakpoints in Windows PowerShell scripts</li> <li>Interpret error actions for Windows PowerShell commands</li> </ul> <h3>26 - Use functions and modules in Windows PowerShell scripts</h3> <ul> <li>Review functions in Windows PowerShell scripts</li> <li>Use variable scope in Windows PowerShell scripts</li> <li>Create modules in Windows PowerShell scripts</li> <li>Use the dot sourcing feature in Windows PowerShell</li> </ul> <h3>27 - Manage single and multiple computers by using Windows PowerShell remoting</h3> <ul> <li>Review the remoting feature of Windows PowerShell</li> <li>Compare remoting with remote connectivity</li> <li>Review the remoting security feature of Windows PowerShell</li> <li>Enable remoting by using Windows PowerShell</li> <li>Use one-to-one remoting by using Windows PowerShell</li> <li>Use one-to-many remoting by using Windows PowerShell</li> <li>Compare remoting output with local output</li> </ul> <h3>28 - Use advanced Windows PowerShell remoting techniques</h3> <ul> <li>Review common remoting techniques of Windows PowerShell</li> <li>Send parameters to remote computers in Windows PowerShell</li> <li>Set access protection to variables, aliases, and functions by using the scope modifier</li> <li>Enable multi-hop remoting in Windows PowerShell</li> </ul> <h3>29 - Manage persistent connections to remote computers by using Windows PowerShell sessions</h3> <ul> <li>Review persistent connections in Windows PowerShell</li> <li>Create and manage persistent PSSessions by using Windows PowerShell</li> <li>Disconnect PSSessions by using Windows PowerShell</li> <li>Review the feature of implicit remoting in Windows PowerShell</li> </ul> <h3>30 - Review Azure PowerShell module</h3> <ul> <li>Review Azure PowerShell</li> <li>Review the benefits of the Azure PowerShell module</li> <li>Install the Azure PowerShell module</li> <li>Migrate Azure PowerShell from AzureRM to Azure</li> <li>Review Microsoft Azure Active Directory module for Windows PowerShell and Azure Active Directory PowerShell for Graph modules</li> </ul> <h3>31 - Review the features and tools for Azure Cloud Shell</h3> <ul> <li>Review the characteristics of Azure Cloud Shell</li> <li>Review the features and tools of Azure Cloud Shell</li> <li>Configure and experiment with Azure Cloud Shell</li> </ul> <h3>32 - Manage Azure resources with Windows PowerShell</h3> <ul> <li>Create a new Azure virtual machine by using Windows PowerShell commands</li> <li>Manage Azure virtual machines by using Windows PowerShell commands</li> <li>Manage Azure related storage by using Azure PowerShell</li> <li>Manage Azure subscriptions by using Azure PowerShell</li> </ul> <h3>33 - Manage users, groups, and licenses in Microsoft Entra ID by using Windows PowerShell</h3> <ul> <li>Review benefits to manage Microsoft 365 services by using Windows PowerShell</li> <li>Connect to the Microsoft 365 tenant by using Windows PowerShell</li> <li>Manage users in Microsoft 365 by using Windows PowerShell</li> <li>Manage groups in Microsoft 365 by using Windows PowerShell</li> <li>Manage roles in Microsoft 365 by using Windows PowerShell</li> <li>Manage licenses in Microsoft 365 by using Windows PowerShell</li> </ul> <h3>34 - Manage Exchange Online by using Windows PowerShell</h3> <ul> <li>Connect to Exchange Online by using Windows PowerShell</li> <li>Manage mailboxes in Exchange Online by using Windows PowerShell</li> <li>Manage resources in Exchange Online by using Windows PowerShell</li> <li>Manage admin roles in Exchange Online by using Windows PowerShell</li> </ul> <h3>35 - Manage SharePoint Online by using Windows PowerShell</h3> <ul> <li>Install and connect to SharePoint Online Management Shell by using Windows PowerShell</li> <li>Manage SharePoint Online users and groups by using Windows PowerShell</li> <li>Manage SharePoint sites by using Windows PowerShell</li> <li>Manage SharePoint Online external user sharing by using Windows PowerShell</li> </ul> <h3>36 - Manage Microsoft Teams by using Windows PowerShell</h3> <ul> <li>Review Microsoft Teams PowerShell module</li> <li>Install the Microsoft Teams PowerShell module</li> <li>Manage teams with Microsoft Teams PowerShell module</li> </ul> <h3>37 - Create and manage background jobs using Windows PowerShell</h3> <ul> <li>Define the types of background jobs in Windows PowerShell</li> <li>Start remote jobs and CIM/WMI jobs in Windows PowerShell</li> <li>Monitor jobs in Windows PowerShell</li> <li>Retrieve results for running jobs in Windows PowerShell</li> </ul> <h3>38 - Create and manage scheduled jobs using Windows PowerShell</h3> <ul> <li>Create and run Windows PowerShell scripts as scheduled tasks</li> <li>Define scheduled jobs in Windows PowerShell</li> <li>Create job option and job trigger objects in Windows PowerShell</li> <li>Create and register a scheduled job in Windows PowerShell</li> <li>Retrieve the results from a scheduled job in Windows PowerShell</li> </ul></div>

Azure PowerShell

Powershell

Power Automate

Microsoft Power Automate

AZ-040T00 Automating Administration with Powershell

<article>
<div>
<h5>Java EVENINGS Course</h5>
</div>
<div></div>
<p>  						 
	</p><div>
	<ul>
		<p>
		<b>Python EVENINGS Course. </b>Basic Python syntax and principles of Object Orientated Programming. 
		<br />Most attendees are in-work IT Professional.
		<br />Private individuals are also very welcome. 
		<br />Evening courses also running.
		<br /><b>Our Style: </b>Hands-on, Practical  
		<br /><b>Location:  </b>Online, Instructor-led  
		<br /><b>Download:  </b>anaconda.com
		<br /><b>Duration:  </b>6 weeks, 1 evening per week, 6pm - 8pm
		<br /><b>Times: </b>arrange a time for your time zone
	    </p>
	</ul>	

<p></p>
</div></article>

<div>
	  <div>
		 <h5>Python Basics EVENINGS Course </h5>
	  </div>
	  <div></div>
	  <p> 
 
				This Python course London Evening 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.
				You can publish your code online to keep as a portfolio.

<br />
This Python Programming course is hands-on and practical, to give you in-depth, practical experience of the topics covered.

	  </p>
	<div>
	<h5>Week 1: Basics</h5>
	</div>
	<div></div>
	<div> 
					<p>  <strong>Python Data Types and Variables:</strong>  
					<br />  Primitive types; Characters &amp; Strings; Boolean; Working with variables and its scope; Conversion and casting types in Python.	 
					<br /> <strong>Operators and Expressions: </strong>   
					<br />  Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators.
					</p> 
			 
				<p><strong> Decision Making:</strong>
				<br />If statement; If - else statement; If- elif - else statement; Nested if - else.
				</p><p><strong>Using Loops:</strong>
				<br />The while, while-else.
				<br />For loop;
				<br />Jump statements: break, continue;
				<br />Nesting loops.				
				</p>
			</div>
	<div>
	<h5>Week 2: Data Structures</h5>
	</div> <div></div>
	<div> 
				<p> Lists.
					<br />Tuples.
					<br />Sets.
					<br />Dictionary. Nested Dictionary.
					<br />Json Files.
				</p>
			</div>
	<div>
	<h5>Week 3: Python built-in functions</h5>
	</div> <div></div>
	<div> 
				<p>  
				<br />Using Built-in modules and functions:
				<br />Strings Functions.
				<br />Pattern matching with Regex.
				<br />Maths Functions.
				<br />Random Functions.
				<br />Python Date functions.
				</p>
			</div>
	<div>
	<h5>Week 4: OOP: Using Modules, functions, classes</h5>
	</div> <div></div>
	<div>
				<p>  Creating and using custom Functions.
					<br />Creating functions;
					<br />Using parameters and return values;
					<br />
					<br />Introduction to Classes and Objects:
					<br />Creating a Class; 
					<br />Creating an Object; Using an Object; 
					<br />Adding Instance variables; Controlling accessibility; Naming conventions for class members. 
					<br /> Class Constructors; Parameterized Constructors.
					<br />Inheritance. Overload.
				</p>
			</div>

	<div>
	<h5>Week 5: Pandas DataBase Basics</h5>
	</div> <div></div>
	<div>	 
		<p> <b>Connection details:</b>
				Connect to a database using access codes. 
				<br /><b>Select Queries:</b>
				Retrieving records and iterating results sets, using variables and parameters in queries. 
				<br />Working with DDL comands:
				Create a database, drop a database.
				Create a table, alter tables, drop a table. 
				<br />Working with DML Commands:
				Insert, delete, update records.
		</p>
	</div>
	
	 
	<div>
	<h5>Week 6: Pandas Dataframe Basics</h5>
	</div> <div></div>
	<div>	 
		<p> Getting data into a dataframe:
			<br />Dict to Dataframe, Dataframe to Dict.
			<br />Excel To Dict, Dict to Excel , working with Excel data, multiple Excel sheets.

			<br />Dataframe basics:
			<br />Slicing Dataframes,
			<br />Getting information about the dataframe,
			<br />Filter, sort and query a Dataframes,
			<br />Duplicate values,
			<br />Working with null-values,
			<br />Sampling,
			<br />Group by,
			<br />Join.

		</p>
	</div>
	  
</div>
 

<div>   

	   <div id="cincluded">
		  <div>
			 <h5>What is included</h5>
		  </div>

		  <article>
		  <div>
			 <ul>
				<li>PCWorkshops Course Certificate on completion  </li>
									   
				<li>Python Course Notes</li>
				<li>Python Code Examples</li>
				<li>Practical Python Course exercises and Code Samples</li>
				<li>After the course: 1-Hour personalised online revision session</li>
			 </ul>
		  </div>
		  </article>
	   </div>
				    
<div>
	                  <div>
	                     <h5 id="cincluded2">Book the Python  Course</h5>
	                  </div>
 
<div id="eventbrite-widget-container-60636103217"></div>




							 
</div>
				   <div id="caboutus">
	                  <div>
	                     <h5>About us</h5>
	                  </div> 
	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>
				   
				   
	        </div>

Python EVENINGS Course
Basic Python syntax and principles of object-oriented programming. 
Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 

Details:
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 4 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 
How to attend:  
Connection Link For the course: https://meet.goto.com/910697125
Once you have made the payment, use the above link on the date booked, to connect with the trainer. 
Python Basics EVENINGS Course
 This Python course London Evening 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. You can publish your code online to keep as a portfolio. 

This Python Programming course is hands-on and practical, to give you in-depth, practical experience of the topics covered. 
Week 1: Basics
 Python Data Types and Variables: 
Primitive Data types; 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. 
 Decision Making: 
If statement; If - else statement; If- elif - else statement; Nested if - else. 
Using Loops: 
The while, while-else. 
For loop; 
Jump statements: break, continue; 
Nesting loops. 
Week 2: Data Structures & Database
Lists.  
Tuples. 
Sets. 
Dictionary. Nested Dictionary. 
Json Files. 
Reading csv and text files
Connecting with a database and run SQL Queries. 
Week 3: Python built-in functions &  Pandas Dataframe Basics
 
Using built-in modules and functions: 
Strings Functions. 
Maths Functions. 
Random Functions. 
Data Frames; 
Getting data into a dataframe: 
Dict to Dataframe, Dataframe to Dict.  
Dataframe basics: 
Slicing Dataframes, 
Getting information about the dataframe, 
Filter and query a Dataframes, 
Working with null-values.
Week 4: OOP: Using Modules, functions, classes
 Creating and using custom Functions. 
Creating functions; 
Using parameters and return values; 
 
Introduction to Classes and Objects: 
Creating a Class; 
Creating an Object; Using an Object; 
Adding instance variables; controlling accessibility; and naming conventions for class members. 
 Class Constructors; Parameterized Constructors. 
Inheritance. Overload. 

What is included
PCWorkshops Course Certificate on completion
Python Course Notes
Python Code Examples
Practical Python Course exercises and Code Samples
After the course: 1-Hour personalised online revision session
  

Programming Fundamentals

Computer Programming

Instructor

Basic Python syntax and principles of Object Orientated Programming. 
Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 6 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 

Python EVENINGS Course, Online Instructor-led

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This class has something for everything, from beginners who wish to customise their data entry forms in SharePoint right up to advanced users who need to use advanced formulas to deliver more bespoke actions to their apps.</p>Overview<p>After taking this course, students will be able to: - Understand when to use PowerApp. - Describe the components of PowerApps and their correct use. - Create PowerApps from existing data sources. - Brand PowerApps. - Customize PowerApps beyond just using the automated wizards. - Connect to a range of data sources from Excel to Azure SQL. - Understand the difference between canvas apps and model-driven apps. - Integrate PowerApps with other Office 365 systems ? including Teams and SharePoint Online. - Administer and Maintain PowerApps</p><p>Students will be taught how to design, test and publish new apps that work with a variety of data sources. We will take users through a selection of well-crafted lessons to help them build new applications for their business.</p></div><div id="course-pills-2"><h3>1 - AN INTRODUCTION TO POWERAPPS</h3> <ul> <li>What is PowerApps?</li> <li>The benefits of apps</li> <li>How to get PowerApps</li> <li>Canvas Apps and Model-Driven Apps</li> <li>License Options and Costs</li> <li>Discover PowerApps with Templates</li> <li>Lab 1: Introduction to PowerApps</li> </ul> <h3>2 - GETTING STARTED WITH POWERAPPS</h3> <ul> <li>Building a new app from a data source</li> <li>Add, edit and remove controls</li> <li>Intro to Formulas</li> <li>Testing an app</li> <li>App Settings</li> <li>Publish and Share Apps</li> <li>Version History and Restore</li> <li>PowerApps Mobile App</li> <li>Lab 1: Getting Started</li> </ul> <h3>3 - BRANDING AND MEDIA</h3> <ul> <li>Less is more</li> <li>Duplicate Screens</li> <li>Fonts</li> <li>Screen Colours and Matching Colours</li> <li>Screen Backgrounds</li> <li>Buttons and Icons</li> <li>Hide on Timer</li> <li>Size and Alignment by reference</li> <li>Show and Hide on Timer</li> <li>Lab 1: Branding and Media</li> </ul> <h3>4 - POWERAPPS CONTROLS</h3> <ul> <li>Text Controls for Data Entry and Display</li> <li>Controls ? Drop downs, combo box, date picker, radio button and more</li> <li>Forms ? Add and edit data in underlying data sources quickly</li> <li>Charts ? present information in pie, line and bar charts</li> <li>Lab 1: Build Apps from Blank</li> </ul> <h3>5 - DATA SOURCES AND LOGIC</h3> <ul> <li>Data Storage and Services</li> <li>How do I decide which database to use?</li> <li>Connect to on-premises data - Gateway</li> <li>What is Delegation?</li> <li>Specific Data Examples</li> <li>Displaying Data</li> <li>Lab 1: Data Source and Logic</li> </ul> <h3>6 - MODEL-DRIVEN APPS</h3> <ul> <li>What is a model-driven app?</li> <li>Where will my data be stored?</li> <li>How do create a model-driven app</li> <li>Canvas vs model-driven summary</li> <li>Lab 1: Model-Driven App</li> </ul> <h3>7 - POWERAPP INTEGRATION</h3> <ul> <li>Embed PowerApps in Teams</li> <li>Embed PowerApps in SharePoint Online</li> <li>Start a Flow from a PowerApp</li> <li>Lab 1: PowerApp Integration</li> </ul> <h3>8 - ADMINISTRATION AND MAINTENANCE OF POWERAPPS</h3> <ul> <li>Identify which users have been using PowerApps</li> <li>Reuse an app in another location (move from testing or development to production)</li> <li>Review app usage</li> <li>Prevent a user from using PowerApps</li> <li>Manage environments</li> <li>Lab 1: Administration and Maintenance</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55265 Microsoft PowerApps training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the 55265 Microsoft PowerApps 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.  <p></p>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.<p></p></div>

Microsoft Power Apps

Power Apps

Microsoft Power Platform

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material.</p>Overview<p>After completing this course, you will be able to:<br />Describe key database concepts in the context of SQL Server<br />Describe database languages used in SQL Server<br />Describe data modelling techniques<br />Describe normalization and denormalization techniques<br />Describe relationship types and effects in database design<br />Describe the effects of database design on performance<br />Describe commonly used database objects</p><p>This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance.<br />This material updates and replaces course Microsoft course 10985 which was previously published under the same title.</p></div><div id="course-pills-2"><h4>Module 1: Introduction to databases</h4><ul><li>Introduction to Relational Databases</li><li>Other Databases and Storage</li><li>Data Analysis</li><li>SQL Server Database Languages</li></ul><h4>Module 2: Data Modeling</h4><ul><li>Data Modelling</li><li>Designing a Database</li><li>Relationship Modeling</li></ul><h4>Module 3: Normalization</h4><ul><li>Fundamentals of Normalization</li><li>Normal Form</li><li>Denormalization</li></ul><h4>Module 4: Relationships</h4><ul><li>Introduction to Relationships</li><li>Planning Referential Integrity</li></ul><h4>Module 5: Performance</h4><ul><li>Indexing</li><li>Query Performance</li><li>Concurrency</li></ul><h4>Module 6: Database Objects</h4><ul><li>Tables</li><li>Views</li><li>Stored Procedures, Triggers and Functions</li></ul></div>

Microsoft SQL Server

Microsoft SQL

SQL Server

55315: Introduction to SQL Databases

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills.</p>Overview<p>Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries</p><p>This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling.</p>Prerequisites<p></p><ul> <li>Basic understanding of relational databases.</li> <li>Basic Windows knowledge.</li> </ul><p></p></div><div id="course-pills-2"><h3>Module 1: Introduction to Transact-SQL</h3><ul> <li>What is Transact-SQL</li> <li>The SELECT statement</li> <li>The WHERE clause</li> <li>Sorting results</li> <li>Calculations</li> <li>CASE expressions</li> </ul>   <h3>Module 2: Joining tables with Transact-SQL</h3><ul> <li>The JOIN clause</li> <li>Inner joins</li> <li>Outer joins</li> <li>Self joins and cross joins</li> </ul>  <h3>Module 3: Filtering and sorting results</h3><ul> <li>Implement the ORDER BY clause</li> <li>Filter data with the WHERE clause</li> <li>Limit the number of rows returned by a query</li> <li>Implement NULL logic</li> </ul>  <h3>Module 4: SQL Server data types</h3><ul> <li>Understand data types</li> <li>Implement string data types</li> <li>Implement temporal data types</li> </ul>  <h3>Module 5: Inserting, updating and deleting data</h3><ul> <li>Insert new records</li> <li>Update existing records</li> <li>Delete data</li> </ul>   <h3>Module 6: Using SQL Server functions with Transact-SQL</h3><ul> <li>Understand function types in SQL Server</li> <li>Convert data using functions</li> <li>Implement logical functions</li> <li>Work with NULL data using functions</li> </ul>  <h3>Module 7: Aggregating data with Transact-SQL</h3><ul> <li>Implement aggregation in SQL Server</li> <li>Group records in SQL Server</li> <li>Filter aggregated data</li> </ul>   <h3>Module 8: Implement subqueries with Transact-SQL</h3><ul> <li>Implement scalar and multi-valued sub-queries</li> <li>Implement correlated subqueries</li> <li>Implement existence checks with subqueries</li> </ul>   <h3>Module 9: Create queries that use table expressions</h3><ul> <li>Create views</li> <li>Create table-valued functions</li> <li>Implement derived tables</li> <li>Implement common table expressions</li> </ul>  <h3>Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data</h3><ul> <li>Write queries with the UNION operator</li> <li>Write queries with the INTERSECT and EXCEPT operators</li> <li>Write queries with the APPLY operator</li> </ul>    <h3>Module 11: Implement window functions in queries</h3><ul> <li>Understand window functions</li> <li>Impement window functions</li> </ul>    <h3>Module 12: Use PIVOT and grouping sets in queries</h3><ul> <li>Implement PIVOT in queries</li> <li>Implement grouping sets in queries</li> </ul>   <h3>Module 13: Use stored procedures in queries</h3><ul> <li>Query data with stored procedures</li> <li>Interact with stored procedures using input and output parameters</li> <li>Write simple stored procedures</li> <li>Pass dynamic SQL to SQL Server</li> </ul>    <h3>Module 14: Implement programming features in Transact-SQL</h3><ul> <li>Understand T-SQL programming elements</li> <li>Implement loops and conditions in T-SQL queries</li> </ul>   <h3>Module 15: Add error handling to queries</h3><ul> <li>Understand SQL Server error handling</li> <li>Implemet structured exception handling</li> </ul>   <h3>Module 16: Use transactions in queries</h3><ul> <li>Understand database transactions</li> <li>Implement transactions in T-SQL</li> </ul></div>

Computing Skills

55366 Querying Data with Transact-SQL

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p></p><p>This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.</p><p></p><p></p><p>This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.</p><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Transact-SQL</h3> <ul> <li>Work with schemas</li> <li>Explore the structure of SQL statements</li> <li>Examine the SELECT statement</li> <li>Work with data types</li> <li>Handle NULLs</li> </ul> <h3>2 - Sort and filter results in T-SQL</h3> <ul> <li>Sort your results</li> <li>Limit the sorted results</li> <li>Page results</li> <li>Remove duplicates</li> <li>Filter data with predicates</li> </ul> <h3>3 - Combine multiple tables with JOINs in T-SQL</h3> <ul> <li>Understand joins concepts and syntax</li> <li>Use inner joins</li> <li>Use outer joins</li> <li>Use cross joins</li> <li>Use self joins</li> </ul> <h3>4 - Write Subqueries in T-SQL</h3> <ul> <li>Understand subqueries</li> <li>Use scalar or multi-valued subqueries</li> <li>Use self-contained or correlated subqueries</li> </ul> <h3>5 - Use built-in functions and GROUP BY in Transact-SQL</h3> <ul> <li>Categorize built-in functions</li> <li>Use scalar functions</li> <li>Use ranking and rowset functions</li> <li>Use aggregate functions</li> <li>Summarize data with GROUP BY</li> <li>Filter groups with HAVING</li> </ul> <h3>6 - Modify data with T-SQL</h3> <ul> <li>Insert data</li> <li>Generate automatic values</li> <li>Update data</li> <li>Delete data</li> <li>Merge data based on multiple tables</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the DP-080T00 Querying Data with Microsoft Transact-SQL 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.  <p></p>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.<p></p></div>

772 Courses

IT Support Technician Course - CPD Certified

By Academy for Health and Fitness

Google Cloud Engineer Associate Certification Bootcamp

By Nexus Human

SAS Programming 1 - Essentials

By Nexus Human

PostgreSQL for Database Developers (TTDB7024)

By Nexus Human

Linux Command Line for Beginners

By Packt

Design a Selenium Test Framework from Scratch-Architect level

By Packt

Comprehensive PostgreSQL Administration

By Nexus Human

Business Intelligence Analyst Training - CPD Accredited Course

By Training Express

Web Development in Python

By Apex Learning

Python Data Science Courses

By Apex Learning

Search By Location