Udemyalles

Conviértete en un SysAdmin en Linux, Windows Server y MySQL

Learn essential system administration skills! SysAdmin 101 covers server management, network basics, and troubleshooting. Perfect for beginners.

4.3(165)
870students
17h 54m
Certificate
Jhonatan Fernández
Jhonatan FernándezIngeniero en Sistemas

Course Content

Conviértete en un SysAdmin en Linux, Windows Server y MySQL is an all-levels Udemy course taught by Jhonatan Fernández. It runs 17h 54m, is taught in Spanish, and includes a certificate of completion. Learners rate it 4.3 out of 5 from 165 reviews, with 870 students enrolled. It is a paid course, last updated March 2020.

Windows Server Administration: GPOs for Beginners

Master Windows Server 2012 R2 and later versions with this comprehensive Windows Server administration course. Learn to install and manage your server environment with a focus on Group Policy Objects (GPOs). This course provides a solid foundation and practical guidance for daily server management.

  • Beginner-Friendly Approach: Taught from the ground up with detailed, practical examples suitable for individuals with basic IT knowledge.
  • Real-World Application: Gain the skills to effectively manage a simple server infrastructure, saving you time searching for solutions online.
  • Why Windows Server 2012 R2? A widely used platform, and its similarities to newer versions ensure your skills are transferable.
  • Mixed Environment Solutions: Learn to troubleshoot GPO application across diverse operating systems, including Windows 7, Windows 8, and Windows 10.

This course is ideal for aspiring System Administrators and Technical Support professionals looking to build a strong foundation in server administration.

CentOS Server Administration: Linux for Beginners

Kickstart your journey into server administration with CentOS and GNU/Linux. This course equips you with the essential tools to manage your own server.

Upon completion, you will be able to:

  • Virtual Machine Creation: Build and configure virtual servers.
  • CentOS 6.5 Installation: Install the CentOS operating system.
  • Command-Line Management: Update the system using the command line (Terminal).
  • Text Editor Proficiency: Master text editors like Gedit, Nano, and Vi.
  • Root Access & Permissions: Manage root user access (using sudoers) and set file/folder permissions (read, write, execute).
  • Secure Remote Access: Establish secure remote connections via SSH (text mode) and modify SSH port.
  • Firewall Configuration: Configure IP Tables to allow specific ports.
  • IP Address Management: Retrieve your system's IP address and configure static IP addresses.
  • System Naming: Change your computer's name.
  • Graphical Remote Access: Set up remote access using XRDP.
  • Port Forwarding: Open ports in IPTABLES for XRDP.
  • Process Management: Open programs from the console and utilize commands like TOP and KILL.
  • File Compression: Compress files using TAR CF, TAR XF, and GZIP commands.
  • Networking Commands: Utilize essential networking commands like PING, IFCONFIG, and NETSTAT.
  • Web Server Installation: Install Apache.
  • PHP Installation: Install PHP.
  • MySQL Installation: Install MySQL.

MySQL Database Management: From Beginner to Advanced

This course is designed for individuals with little to no experience with databases, including MySQL. Learn to manage MySQL databases quickly, practically, and effectively, from basic concepts to advanced techniques.

By the end of this course, you will be able to:

  • Server Setup: Understand different programs for setting up a database server.
  • MySQL Fundamentals: Grasp key concepts related to MySQL.
  • Connection Methods: Connect to MySQL using PHPMYADMIN, MySQL Workbench, and the command line (Terminal/CMD).
  • Database Creation: Create databases using SQL.
  • Table Manipulation: Create, alter, and modify tables using SQL.
  • Field Management: Create, show, and modify fields in tables.
  • SQL Commands: Understand the difference between CHANGE and MODIFY, and effectively use USE DATABASE, DESC/Describe, comments, and RENAME.
  • Indexing: Create indexes for improved query performance.
  • Data Manipulation: Master IF EXISTS, IF NOT EXISTS, INSERT, DELETE, UPDATE, SELECT, and TRUNCATE statements.
  • Data Export/Import: Export and import databases using various methods.
  • Operators & Functions: Utilize operators, alphanumeric functions, numeric functions, and date functions.
  • Table Relationships: Understand and implement joins between tables.
  • Advanced Techniques: Work with advanced variables, create views, and write subqueries.
  • User & Security Management: Manage database users and create triggers and stored procedures.
  • Stored Procedures & Functions: Create stored procedures and functions.

Ubuntu Server Setup: Web Server with LAMP Stack

Learn to build a robust web

$ whoami — the devs behind tutorialsearch.io

Hire the developers behind TutorialSearch.io

We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.

5.0(30)
14h 48m
all
5.0(5)
2h 41m
beginner
5.0(17)
8h 12m
beginner

Certificación LPIC-2 : Ingeniero Linux. Examen 201

by Antonio Sánchez Corbalán - LPI Training Partner Platinum

4.9(503)
19h 34m
expert

Certificación LPIC-1: Administrador de Linux. EXAMEN 102

by Antonio Sánchez Corbalán - LPI Training Partner Platinum

4.9(5,294)
17h 13m
intermediate