118 UNIX courses

About Course Learn how to use Linux to boost your programming productivity and become a more efficient developer. In this comprehensive course, you will learn: The best Linux terminals to use for programming How to use clipboard managers to save time and effort How to use Vim, the most powerful text editor for programmers How to use Zsh and the oh-my-zsh framework to customize your terminal experience Extensive lessons on terminal commands, including how to find and replace text, work with pipes and subshells, and automate tasks And much more! You will also receive access to a repository of scripts and an eBook containing all of the examples and explanations from the course. This course is perfect for programmers who are new to Linux or who want to learn how to use Linux more effectively. Enroll today and start your journey to becoming a more productive programmer with Linux! Here are some of the benefits of learning how to use Linux for programming: Linux is a powerful and flexible operating system that can be customized to meet your specific needs. Linux is also very efficient, which can make a big difference in your productivity, especially when working with large projects. Linux has a wide range of built-in tools and utilities that are designed for programmers, such as the Bash shell, Vim, and Git. Linux is also open source, which means that there is a large community of developers who are constantly contributing to and improving the platform. If you are serious about becoming a more productive programmer, then learning how to use Linux is an essential skill. This course will teach you everything you need to know to get started. Enroll today and start boosting your productivity! What Will You Learn? I'll increase my terminal productivity by using Terminator, Guake and other tools I'll be able to use regular expressions, pipes and subshells and external shell scripting libraries I'll work with files like a vim-fu master I'll increase my command line productivity (by learning how to use sed, find, tmux, network, autoenv and more) I'll be able to launch a webserver, modify images and productively work with Git I'll edit files without leaving the terminal, use the screen space efficiently and copy-paste like a pro All in all: I will double my terminal productivity Course Content Introduction Introduction Terminator- Hasta La Vista Terminal Guake - Not Quake! Clipit- Forget Everything, Paste from History Productive Shells: Reinvent The Way You Work Pre Chapter Vim Oh-my-zsh Your Terminal Never Felt This Good Before! Basic Regular Expressions Pipes and Subshells Your Shell's Salt and Pepper Shell Scripting for Fun and Profit Shell Scripting Libraries Vim Kung Fu Supercharging Vim Keyboard Kung Fu Plugin Steroids for Vim Vim Password Manager Extra- Fast Configuration Restore CLI: The Hidden Recipe Sed - One-Liner Productivity Treasure You Can Run, But You Can't Hide From 'Find' Tmux Virtual Consoles, Background Jobs and The Likes Network Who's Listening Autoenv Set a Lasting, Project-Based Habitat Don't rm The Trash Developers' Treasure On the Spot Webserver Shrinking Spells and Other Image Magic Go With the Git Flow Merge Git Conflicts With Ease From Localhost to Instant DNS JSON Jamming in The New Age No More Mister Nice Guy Closing Chapter Bonus Chapter Terminal Art Bonus Chapter Closing Chapter A course by Bogdan Vaida Experiential Trainer RequirementsYou need to have prior experience in the Linux command lineYou must have access to a Linux/Unix terminalBasic programming skills are recommended (but not required)Some basic shell scripting and web development knowledge make the course easier to understand Audience System administrators Developers who already know the basics of Linux and want to sharpen their skills People working in the Linux command line This course is not for people who are opening a terminal for the first time Audience System administrators Developers who already know the basics of Linux and want to sharpen their skills People working in the Linux command line This course is not for people who are opening a terminal for the first time

Overview Embarking on a journey through the intricate pathways of the Linux File Management System offers a thrilling yet essential adventure for those diving into modern computing. This course unfolds the mysteries behind Linux's unique file hierarchy, ensuring that users comprehend its structure and master the art of navigation and manipulation within this environment. From initial introductions to setting up a dedicated lab and diving deep into the Linux FileSystem, learners will be equipped with the prowess to navigate Linux systems effortlessly. Learning Outcomes: Understand the fundamental principles and concepts of the Linux File Management System. Acquire the knowledge to configure and set up a functional Linux lab environment. Demonstrate proficiency in navigating the Linux filesystem hierarchy. Apply various commands and techniques to manage files effectively. Recognise and differentiate between multiple Linux file types and their specific purposes. Implement appropriate security measures to safeguard files and directories. Evaluate and troubleshoot common file management issues within Linux environments. Why buy this Linux File Management System? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Linux File Management System there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Linux File Management System course is ideal for Aspiring system administrators keen on mastering Linux file management. Software developers looking to enhance their Linux-based application development skills. IT enthusiasts aiming to expand their knowledge on Linux operations. Individuals transitioning from other operating systems to Linux platforms. University students studying computer science or related fields with a focus on Linux systems. Prerequisites This Linux File Management System does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Linux File Management System was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Linux System Administrator: Average salary of £40,000 - £55,000 Per Annum. Software Developer (Linux-focused): Average salary of £45,000 - £60,000 Per Annum. Linux Support Engineer: Average salary of £30,000 - £45,000 Per Annum. IT Consultant (Linux speciality): Average salary of £50,000 - £70,000 Per Annum. Linux Systems Architect: Average salary of £60,000 - £80,000 Per Annum. Linux Training Specialist: Average salary of £35,000 - £50,000 Per Annum. Course Curriculum Section 1: Introduction Introduction 00:01:00 Course Overview 00:04:00 Section 2: Setup a Lab Unit 1: Download and Install VirtualBox 00:06:00 Unit 2: Creating First Virtual Machine 00:06:00 Unit 3: Linux Installation 00:25:00 Unit 4: Linux CentOS8 Installation 00:25:00 Section 3: Linux FileSystem Unit 1: Introduction to Unix and Linux 00:02:00 Unit 2: Accessing Linux System 00:03:00 Unit 3: Download and Install Putty 00:03:00 Unit 4: Connect Linux via Putty 00:05:00 Unit 5: Introduction to Linux FileSystem 00:05:00 Unit 6: FileSystem Structure and Description 00:13:00 Unit 7: FileSystem Navigation Commands 00:10:00 Unit 8: Absolute and Relative Paths 00:05:00 Unit 9: Directory Listing Attributes 00:03:00 Unit 10: Creating Files and Directories 00:09:00 Unit 11: Linux File Type 00:01:00 Unit 12: Difference Between Find and Locate Commands 00:06:00 Unit 13: Hard and Soft Link 00:12:00 Unit 14: i=Important Things to Remember 00:01:00 Unit 15: Understanding Wildcards 00:10:00 Unit 16: Command Prompts and Getting prompts Back 00:04:00 Unit 17: Changing Systems password 00:05:00 Assignment Assignment - Linux File Management System 00:00:00

Duration 2 Days 12 CPD hours Overview This skills-focused course combines expert instructor-led discussions with practical hands-on labs that emphasize useful, current techniques, best practices and standards. Working in this hands-on lab environment, guided by our expert practitioner, you'll learn about and explore: Review of the File System Introduction to Shells: sh, bash, and ksh Shell Programming Advanced Shell Features Text Manipulation Utilities File Processing Utilities Multitasking and Batch Processing Regular Expressions Intermediate Linux: Shell, Bash, Text Manipulation, Multitasking & More is a two-day course designed to provide you with hands on experience using standard Linux commands and utilities used for day-to-day tasks including file manipulation, program execution and control, and effective use of the shell and desktop environments. Throughout the course you?ll explore key concepts to Linux core functionality, while learning the system's most commonly used commands. You?ll also learn the Bourne shell, Bash shell and Korn shell programming techniques you?ll need to read and modify existing shell scripts, and create your own. Data manipulation utilities and shell syntax for synthesizing command pipelines are also emphasized throughout the course. Review of the File System File System Organization File Types File and Directory Naming Rules and Conventions Commands for Navigating the File System Introduction to Inodes Ownership, Permissions, and Dates Manipulating Files and Links Manipulating Directories Determining Disk Usage Other File System Utilities Introduction to Shells: sh, bash, and ksh Shell Functions I/O Redirection and Pipes Command Separation and Grouping Background Execution Filename Expansion Shell Variables Command Substitution Quoting and Escaping Metacharacters Bash Shell Features Korn Shell Features Command Execution Startup Files Customizing the User Environment Shell Programming Shell Script Features and Capabilities Creating and Running a Script Working With Variables Environment Variables Working With Data Types Formatting Base Conversion Setting Special Attributes Input/Output Techniques Conditional Constructs if/then else/elif Looping Constructs for, while, until Math Operators Advanced Shell Features Manipulating Strings Writing and Calling Functions Controlling Process Priorities Interpreting Command Line Arguments Making Scripts Interactive Special Shell Variables Advanced I/O with Streams Improving Performance of Scripts Text Manipulation Utilities Editing a File from a Script Scripting with ed or sed UNIX and Linux Utilities to Manipulate Files Regular Expressions grep and egrep The Stream Editor sed Sorting in Scripts Generating Reports with awk Splitting Large Files Counting Words, Lines, and Characters Transforming File Contents File Processing Utilities Examining and Comparing Files Reporting Differences Between Files Comparing Files of Any Format Displaying Data in Octal and Hex Compressing Data Converting File Formats Extracting Text Strings Multitasking and Batch Processing Multitasking Scheduled Execution Using cron The at and batch Commands Regular Expressions Regular Expression Overview Regular Expression Implementations Regular Expressions RE Character Classes Regex Quantifiers RE Parenthesis Additional course details: Nexus Humans Intermediate Linux (TTLX2104) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Intermediate Linux (TTLX2104) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for Experienced Programmers and Systems Administrators. Overview Throughout the course students will be led through a series of progressively advanced topics, where each topic consists of lecture, group discussion, comprehensive hands-on lab exercises, and lab review. This course is ?skills-centric?, designed to train attendees in core Python and web development skills beyond an intermediate level, coupling the most current, effective techniques with best practices. Working within in an engaging, hands-on learning environment, guided by our expert Python practitioner, students will learn to: ? Create working Python scripts following best practices ? Use python data types appropriately ? Read and write files with both text and binary data ? Search and replace text with regular expressions ? Get familiar with the standard library and its work-saving modules ? Use lesser-known but powerful Python data types ? Create 'real-world', professional Python applications ? Work with dates, times, and calendars ? Know when to use collections such as lists, dictionaries, and sets ? Understand Pythonic features such as comprehensions and iterators ? Write robust code using exception handling An introductory and beyond-level practical, hands-on Python training course that leads the student from the basics of writing and running Python scripts to more advanced features. An Overview of Python What is python? 1 -- An overview of Python What is python? Python Timeline Advantages/Disadvantages of Python Getting help with pydoc The Python Environment Starting Python Using the interpreter Running a Python script Python scripts on Unix/Windows Editors and IDEs Getting Started Using variables Built-in functions Strings Numbers Converting among types Writing to the screen Command line parameters Flow Control About flow control White space Conditional expressions Relational and Boolean operators While loops Alternate loop exits Sequences About sequences Lists and list methods Tuples Indexing and slicing Iterating through a sequence Sequence functions, keywords, and operators List comprehensions Generator Expressions Nested sequences Working with files File overview Opening a text file Reading a text file Writing to a text file Reading and writing raw (binary) data Converting binary data with struct Dictionaries and Sets About dictionaries Creating dictionaries Iterating through a dictionary About sets Creating sets Working with sets Functions Defining functions Parameters Global and local scope Nested functions Returning values Sorting The sorted() function Alternate keys Lambda functions Sorting collections Using operator.itemgetter() Reverse sorting Errors and Exception Handling Syntax errors Exceptions Using try/catch/else/finally Handling multiple exceptions Ignoring exceptions Modules and Packages The import statement Module search path Creating Modules Using packages Function and Module aliases Classes About o-o programming Defining classes Constructors Methods Instance data Properties Class methods and data Regular Expressions RE syntax overview RE Objects Searching and matching Compilation flags Groups and special groups Replacing text Splitting strings The standard library The sys module Launching external programs Math functions Random numbers The string module Reading CSV data Dates and times Working with dates and times Translating timestamps Parsing dates from text Formatting dates Calendar data Working with the file system Paths, directories, and filenames Checking for existence Permissions and other file attributes Walking directory trees Creating filters with fileinput Using shutil for file operations 17 ? Advanced data handling Defaultdict and Counter Prettyprinting data structures Compressed archives (zip, gzip, tar, etc.) Persistent data Advanced data handling Defaultdict and Counter Prettyprinting data structures Compressed archives (zip, gzip, tar, etc.) Persistent data Network services Grabbing web content Sending email Using SSH for remote access Using FTP Writing real-life applications Parsing command-line options Detecting the current platform Trapping signals Implementing logging Python Timeline Advantages/Disadvantages of Python Getting help with pydoc

Build 9 projects to master 2 essential and modern technologies: Python and PostgreSQL

Duration 5 Days 30 CPD hours This course is intended for This course is intended for System administrators who are either new to JBoss or have experience with JBoss Enterprise Application Platform 5. Base experience with system administration on Microsoft Windows, UNIX, or Linux© operating systems. Understanding of hardware and networking. Note: No prior knowledge of Java, scripting, or JBoss Developer Studio is required. Overview Upon successful completion of this course, students will be able to take the Red Hat Certified JBoss Administration (RHCJA) Exam. In this course, you'll discover the best practices for installing and configuring Red Hat© JBoss© Enterprise Application Platform (JBoss EAP) 7. Through hands-on labs, you'll learn the essential, real-world tasks that you need to know as a system administrator to effectively deploy and manage applications on JBoss EAP. This course will help prepare you to take the Red Hat Certified Specialist in Enterprise Application Server Administration exam. 1 - OVERVIEW OF JBOSS ENTERPRISE APPLICATION PLATFORM Learn the concepts and terminology of JBoss© Enterprise Application Platform 6, and install and run a JBoss Enterprise Application Platform instance. 2 - CONFIGURE JBOSS ENTERPRISE APPLICATION PLATFORM IN STANDALONE MODE Understand the directory structure of standalone mode and the standalone.xml configuration file, and deploy an application onto a standalone server. 3 - CONFIGURE JBOSS ENTERPRISE APPLICATION PLATFORM IN DOMAIN MODE Set up a domain, including a domain controller managing multiple host controllers. Also learn how to deploy an application onto a domain. 4 - CONFIGURE SERVERS Define a server group on a host, add servers to a server group, and deploy an application to a server group. 5 - USE THE CLI TOOL Learn how the command-line Interface tool can be used to script administrative tasks. 6 - THE DATASOURCE SUBSYSTEM Understand database connection pools in JBoss Enterprise Application Platform and how to configure the datasource subsystem. Learn how to deploy a Java? Database Connectivity (JDBC) driver and define a datasource. 7 - THE LOGGING SUBSYSTEM Configure the logging subsystem, including configuring the built-in handlers and loggers. 8 - THE MESSAGING SUBSYSTEM Understand JMS and HornetQ, including how to define and configure connection factories and destinations (topics and queues). 9 - THE SECURITY SUBSYSTEM Configure the security subsystem, including securing the management interfaces, securing an application, and securing a JMS destination. Also learn how to define an Lightweight Directory Access Protocol (LDAP) and database security realm. 10 - JVM CONFIGURATION Configure the JVM for both standalone and domain modes. 11 - MIGRATING APPLICATIONS TO JBOSS ENTERPRISE APPLICATION PLATFORM 6 Understand classpath and module dependencies, JPA issues, updating security settings, and other tips on how to migrate an application to JBoss Enterprise Application Platform 6. 12 - THE WEB SUBSYSTEM Configure the HTTP and HTTPS Connectors, set up an SSL connection, and configure an AJP Connector. 13 - INTRODUCTION TO CLUSTERING Set up JBoss Enterprise Application Platform 6 in a cluster in both standalone and domain mode. Additional course details: Nexus Humans Red Hat JBoss Application Administration I with Exam (AD249) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Red Hat JBoss Application Administration I with Exam (AD249) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

If you are looking for a new and challenging career in the area of computer programming or you just want to learn about this anyway, then our Diploma in Computer Programming course will give you the skills you need. Description: Computer Programming is regularly the primary port of call for anybody hoping to move into a full-time role in programming advancement. A comprehension of a scripting language will likewise offer many open doors for advancement as it gives understanding and information on how frameworks are constructed and executed within associations. This course is for learners with next to zero prior programming background, however a desire to comprehend computational ways to deal with critical thinking. This course starts by introducing the student to basic concepts and terminology of software development and helps them gain the skills that are required for writing and designing a program. It also gives a review of the software development process along with an introduction to programming constructs and approaches. If you want to learn computer programming, yet don't have any detailed knowledge, you'll appreciate this programming course. You will gain in depth knowledge and get up-to-date information in this field of your interest. Who is the course for? Beginners who are new to the world of programming. Individuals who want to master computer programming. Computer Programmers of a different language. Students. Entry Requirement: This course is available to all learners, of all academic backgrounds. However, an educational background or experience in business communications will be an advantage. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Diploma in Computer Programming is a useful qualification to possess, and would be beneficial for the following professionals: Software developer. Information systems specialist. PC specialist. Mid-range programmer. UNIX/Linux programmer. Computer Fundamentals Basic Terms 00:15:00 Types of Computers 00:15:00 Anatomy of a PC 00:30:00 How a PC Works 00:15:00 CPU and Memory 00:30:00 Input Devices 00:15:00 Output Devices 00:15:00 Secondary Storage Devices 00:30:00 The Basics 00:15:00 Operating Systems and Applications 00:30:00 How is Software Built 00:15:00 Types of Software 00:15:00 Legal Issues 00:15:00 COMPUTER PROGRAMMING 101 COMPUTER PROGRAMMING 101 01:00:00 WHAT IS COMPUTER PROGRAMMING AND WHY SHOULD I CARE? 00:30:00 What a Programmer Does 01:00:00 COMPUTER PROGRAMMING AT A GLANCE COMPUTER PROGRAMMING AT A GLANCE 01:00:00 UNDERSTANDING THE LANGUAGE OF THE COMPUTER 00:30:00 Choosing a Language 00:30:00 BASIC PROGRAMMING LANGUAGE BASIC Programming Language 01:00:00 Getting Started with BASIC Programming Language 01:00:00 BASIC Overview of BASIC Components 01:00:00 BASIC Special Variables 01:00:00 BASIC Probability Functions 01:00:00 Filtering the Data Set or Splitting the Data Set 01:00:00 DATA Blocks 01:00:00 DELETE Statement 01:00:00 FORNEXT Statement 01:00:00 IF. . . THEN Statement 01:00:00 JOB STATISTICS AT A GLANCE Computer Programming 01:00:00 Employment Outlook 00:15:00 How to Find A Great Job After Graduation 01:00:00 Additional Supporting Material Fundamentals of Computer-Programming with C+ 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Diploma in Computer Programming 00:20:00 Final Exam Final Exam- Diploma in Computer Programming 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Learn GitHub Actions in a weekend! This course covers all the important concepts to help you master GitHub Actions and its practical applications. Gain in-demand skills, design a CI/CD pipeline, and deploy infra as code with GitHub Actions. Boost your career with this essential skill for DevOps practices.

Duration 3 Days 18 CPD hours This course is intended for This intermediate course is for experienced SQL end users, application programmers, database administrators, and user support staff who need more advanced knowledge of SQL. Overview Discuss basic relational database concepts Use some of the OLAP features of DB2, such as GROUPing and RANKing functions Create tables, views and indexes Use referential integrity, check constraints and triggers Use outer joins, and join tables to themselves Use CASE expressions, and the CAST function Identify the impact of Summary Tables, Materialized Query Tables, and temporary tables Use complex subqueries Use a greater number of scalar SQL functions Use advanced SQL constructs, such as recursive SQL and table expressions Define User-Defined Distinct Types and User-Defined Functions Avoid several of the most common causes for poorly-performing SQL This course teaches you how to make use of advanced SQL techniques to access DB2 databases in different environments. This course is appropriate for customers working in all DB2 environments, specifically for z/OS, Linux, UNIX, and Windows. Introduction Identify the purpose of the clauses in the SELECT statement Describe the key differences among the IBM DB2 platforms Describe and use some of the OLAP features of DB2, such as GROUPING functions like CUBE and ROLLUP, and the RANK, DENSE_RANK and ROW_NUMBER functions Create Objects Code statements to: Create tables and views, Alter tables, Create indexes, Implement referential integrity (RI), and Define triggers and check constraints Identify impacts and advantages of referential integrity, including impacts of delete rules Identify considerations when using triggers and check constraints Define and make use of INSTEAD OF triggers Join Retrieve data from more than one table via inner and outer joins Use outer joins (LEFT, RIGHT, FULL) Use ANTI JOINS Join a table to itself Use UNION and UNION ALL Use EXCEPT and INTERCEPT CASE, CAST, Summary Tables, and Materialized Query Tables Identify when CASE expressions can be used Code CASE expressions in SELECT list and in the WHERE clause Identify when CAST specifications can be used Identify the advantages of using Summary (Materialized Query) Tables and Temporary tables Identify the advantages of using Materialized Query Tables (MQTs) Identify when and how to use Temporary tables Using Subqueries Code subqueries using the ALL, ANY/SOME, and EXISTS keywords Code correlated subqueries Choose the proper type of subquery to use in each case Scalar Functions Extend your knowledge of scalar functions which: Manipulate arithmetic data, Manipulate date values, and Manipulate character data Examples of scalar functions that are addressed in this course: SUBSTR POSSTR COALESCE/VALUE DECIMAL ROUND DIGITS CHAR DATE/TIME Table Expressions and Recursive SQL Identify reasons for using table expressions and recursive SQL Use nested and common table expressions Identify the difference between views and table expressions Code recursive SQL Control the depth of recursion when coding recursive SQL UDTs/UDFs and Performance Describe the concepts behind User-Defined Types, User-Defined Functions and Stored Procedures Predict when queries will use indexes to get better performance Identify concepts of predicate processing State introductory concepts about index structure State general best practices advice Additional course details: Nexus Humans CE131 IBM DB2 SQL Workshop for Experienced Users training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the CE131 IBM DB2 SQL Workshop for Experienced Users course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Description: Computer operation can be difficult if you have no idea how to do it. However, it only takes a complete beginner course on the computer to learn how. You need to learn the basics, operation systems and how healthy computing works which this course provides. If you think you are ready to start your journey in learning all about the computer, then you don't have to wait for. Start learning now and understand why the computer is considered as a necessity in this modern age. Who is the course for? Beginner to advanced level users can benefit from the lessons we provide People who have an interest in learning about computer and computer maintenance Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Beginners Guide to Computers is a very useful qualification to possess, and will be very helpful to have especially for these careers: Computer Maintenance Staff IT Department Manager Computer Engineer Computer Specialist Computer Technician. Computer Fundamentals Basic Terms 00:15:00 Types of Computers 00:15:00 Anatomy of a PC 00:30:00 How a PC Works 00:15:00 CPU and Memory 00:30:00 Input Devices 00:15:00 Output Devices 00:15:00 Secondary Storage Devices 00:30:00 The Basics 00:15:00 Operating Systems and Applications 00:30:00 How is Software Built 00:15:00 Types of Software 00:15:00 Legal Issues 00:15:00 Computer Essentials Introduction 00:15:00 Understanding The Components Of A PC 01:30:00 Do You Need To Upgrade Your PC? 01:00:00 Essential Softwares You Must Have On Your PC 01:00:00 Installing And Organizing Your PC 01:00:00 Troubleshooting Guidelines 01:00:00 How To Speak To A Technician 00:30:00 Summary 00:30:00 Operating Systems Introduction 00:15:00 What is an Operating System? 00:30:00 History of Operating System 00:30:00 What an Operating System Does 01:00:00 Microsoft Windows 00:15:00 MAC OS 01:00:00 UNIX 00:30:00 LINUX 00:30:00 GNU 00:30:00 Other Operating Systems999 01:00:00 Installing an Operating System 00:30:00 Defining The Processes 01:00:00 Conclusion 00:15:00 Healthy Computing Introduction 01:00:00 Body Position 01:00:00 Monitors 01:00:00 Keyboards 01:00:00 Mouse or Pointer 02:00:00 Document Holders and Desk 01:00:00 Chairs 02:00:00 Telephones 00:30:00 What Have We Learned 01:00:00 Work Process and Recognition 01:00:00 Lighting 01:00:00 Ventilation 00:30:00 Awkward Postures 02:00:00 Musculoskeletal Disorders (MSD) 02:00:00 4 Steps to Setting Up The Computer Workstation 01:00:00 Exercises and Breaks 01:00:00 Conclusion 00:15:00 Mock Exam Mock Exam-Beginners Guide to Computers 00:30:00 Final Exam Final Exam-Beginners Guide to Computers 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00