LabEx
Log InJoin Free

Data Science Tutorials

Data Science provides a comprehensive curriculum for aspiring data scientists and analysts. Our tutorials cover statistical analysis, machine learning, and data visualization, suitable for both beginners and intermediate learners. Through interactive labs and hands - on coding exercises, you'll gain practical experience with real - world datasets. Our data science playground allows you to apply your skills in a dynamic online environment.

Other Skill Trees

LinuxDevOpsCybersecurityDevOps EngineerCybersecurity EngineerDevSecOpsKali LinuxRed Hat Enterprise LinuxRHCSA TrainingRHCE in Enterprise Linux TrainingLFCS TrainingShellGitDockerKubernetesCKA TrainingCKAD TrainingCKS TrainingAnsibleRHCE in Ansible TrainingJenkinsNmapWiresharkHydraCompTIADatabaseMySQLPostgreSQLRedisMongoDBSQLitePythonGolangJavaCC++Web Development
Data Filtering and Simple Queries in PostgreSQL

Data Filtering and Simple Queries in PostgreSQL

In this lab, you will learn how to perform data filtering and simple queries in PostgreSQL. You'll use WHERE clause to filter data, LIKE for pattern matching, ORDER BY for sorting, and LIMIT and OFFSET to control result set size. Connect to a PostgreSQL database and create a sample table.
PostgreSQL
Create a URL Shortener with Python Flask

Create a URL Shortener with Python Flask

In this project, we will learn how to create a URL shortener using Python and Flask. A URL shortener is a tool that takes a long URL and converts it into a shorter, more manageable URL. This can be useful for sharing links on social media or in emails, as well as making long URLs more user-friendly.
Python
How to clean up virtual environments

How to clean up virtual environments

Efficiently manage and clean up Python virtual environments with expert techniques, optimize disk space, and streamline development workflow for better project management
Python
How to add multiple argparse arguments

How to add multiple argparse arguments

Learn how to efficiently add and parse multiple command-line arguments in Python using the powerful argparse module for flexible script configuration
Python
MySQL Common Table Expressions (CTEs)

MySQL Common Table Expressions (CTEs)

In this lab, you will learn how to use Common Table Expressions (CTEs) in MySQL to improve query readability and maintainability. The lab covers defining simple CTEs using the `WITH` clause, writing recursive CTEs for hierarchical data, joining CTEs with tables, and testing CTE query output.
MySQL
MySQL Error Handling and Logging

MySQL Error Handling and Logging

In this lab, you will learn essential MySQL error handling and logging techniques. You will practice enabling the general query log, implementing error handlers in stored procedures, raising custom errors with SIGNAL, and reviewing the MySQL error log to debug and audit your database effectively.
MySQL
Basic Data Operations in PostgreSQL

Basic Data Operations in PostgreSQL

In this lab, we will explore basic data operations in PostgreSQL. We'll learn to insert data, query with SELECT, update records, and delete records within a PostgreSQL database using SQL commands. This provides a hands-on introduction to essential data management techniques.
PostgreSQL
MySQL Backup and Recovery

MySQL Backup and Recovery

In this lab, you will learn how to back up and restore MySQL databases using the `mysqldump` command-line tool. The lab covers essential techniques for creating logical backups and restoring them to ensure data integrity and availability.
MySQL
Database Management Basics with PostgreSQL

Database Management Basics with PostgreSQL

In this lab, you will learn the fundamentals of database management using PostgreSQL. The lab covers creating, listing, connecting to, and dropping databases. Explore basic database administration tasks and view database metadata in PostgreSQL.
PostgreSQL
Installation and Initial Setup of PostgreSQL

Installation and Initial Setup of PostgreSQL

In this lab, we will install and perform the initial setup of PostgreSQL on the LabEx VM. The goal is to get PostgreSQL up and running and verify its basic functionality. We will explore default databases and check server status and basic configuration.
PostgreSQLLinux
MySQL Event Scheduler

MySQL Event Scheduler

In this lab, you will learn how to use the MySQL Event Scheduler to automate tasks. The lab guides you through enabling the Event Scheduler, creating an event to periodically update data in a table, checking the event's execution status, and finally, dropping the event.
MySQL
Build URL Shortener with Flask MySQL

Build URL Shortener with Flask MySQL

This project guides you through creating a simple URL shortener service using Flask and MySQL. You'll learn to set up a database, design a web interface, and implement functionality to shorten URLs, search for URLs by tags, and view analytics. The project is beginner-friendly and offers a comprehensive insight into web development with Python and database management.
HTMLPythonMySQLCSS
How to add time in Python datetime

How to add time in Python datetime

Learn efficient techniques to add time in Python datetime, explore timedelta methods, and perform precise time calculations with practical examples and best practices.
Python
MySQL Configuration and Tuning

MySQL Configuration and Tuning

In this lab, you will learn how to configure and tune your MySQL server for optimal performance. The lab guides you through viewing the current configuration using `SHOW VARIABLES`, adjusting the InnoDB buffer pool size, monitoring query performance after tuning, and saving the configuration changes.
MySQLLinux
Building Flask REST API with SQLite

Building Flask REST API with SQLite

In this project, we will learn how to build a REST API in Flask using SQLite as the database. We will start by creating a sample SQLite database and populating it with some data. Then, we will build a Flask application with endpoints to perform CRUD (Create, Read, Update, Delete) operations on the data in the SQLite database.
Python
How to deactivate Python venv

How to deactivate Python venv

Learn essential techniques to deactivate Python virtual environments safely and efficiently, manage development workflows, and switch between project environments seamlessly.
Python
PostgreSQL Table Creation and Data Types

PostgreSQL Table Creation and Data Types

In this lab, we will explore PostgreSQL table creation and data types. We'll connect to PostgreSQL using `psql`, create tables with primary keys, and add constraints like `NOT NULL` and `UNIQUE`. We will then inspect the table structure and insert data to demonstrate data types.
PostgreSQL
How to pass arguments in Python multiprocessing

How to pass arguments in Python multiprocessing

Learn efficient techniques for passing arguments in Python multiprocessing, explore practical methods to handle complex parallel processing scenarios and optimize performance.
Python
  • Prev
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • ...
  • 238
  • Next