I. Linux Basics
Introduction
• Distributions
• Executing commands from the command line
Working with files and directories
• The structure of the file system
• Creating and deleting files and directories
• Copying, moving and renaming files and directories
• Viewing file content
• Searching
• Packing and unpacking files
Editing files
• 'nano' editor
• Editing from the command line with the 'sed' editor
Working in the shell
• 'bash' shell
• Stream redirection
• Initialization files
File system permissions
• The concept of rights and ownership
• Viewing and verifying permissions
• Absolute and symbolic notation
• Changing permissions with 'chmod'
• Changing ownership with ‘chown'
II. Linux Advances Tasks
Working with processes
• Viewing and searching for processes
• Process management
User management
• User accounts
• Security and password policy
• Groups
• User privileges
Network connections
• Making remote connections using 'ssh'
• Downloading files
• Transferring files using 'scp'
III. Scripting Basics (Shell/Python)
Introduction to Scripting
• Variables and printing
• Loops
• Conditions
• Functions
• Loading External scripts
• Networking operations
• Executing Command Line Applications
IV. Introduction to SQL
MySQL Basics
• Installing MySQL Database on Linux
• Installing PHPMyAdmin
• Creating database, tables and columns
SQL Basics
• Basic SQL statements
• SQL CRUD Operations
• Dealing with Stored Procedures
• Database Backup and restore