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

LinuxDevOpsCybersecurityKali LinuxDevOps EngineerCybersecurity EngineerDatabaseData ScienceRed Hat Enterprise LinuxCompTIADockerKubernetesPythonGitShellNmapWiresharkHydraJavaSQLitePostgreSQLMySQLRedisMongoDBGolangC++CJenkinsAnsiblePandasNumPyscikit-learnMatplotlibWeb DevelopmentHTMLCSSJavaScriptReact
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
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.
MySQL
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
MySQL Full-Text Search Capabilities

MySQL Full-Text Search Capabilities

In this lab, you will explore MySQL's full-text search capabilities. You'll create a database and table, add a full-text index, and verify its creation. This setup prepares you for efficient text searches within your MySQL database.
MySQL
MySQL Partitioning for Large Datasets

MySQL Partitioning for Large Datasets

In this lab, you will learn how to implement MySQL partitioning for large datasets to improve query performance and data management. You'll partition a table by range, query specific partitions, reorganize partitions, and check the impact on query speed.
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 Replication Basics

MySQL Replication Basics

In this lab, you will explore the fundamentals of MySQL replication. You will learn how to set up a master-slave replication environment by configuring a single MySQL instance to act as both a master and a slave. This lab covers enabling binary logging, creating a replication user, configuring a slave to connect to a master, and verifying the replication status.
MySQL
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 Security Best Practices

MySQL Security Best Practices

In this lab, you will learn essential MySQL security practices. The lab covers securing the root account, creating dedicated users with limited permissions, managing privileges, and removing unnecessary default accounts to harden your database server.
MySQL
MySQL JSON Data Handling

MySQL JSON Data Handling

In this lab, you will learn how to handle JSON data within a MySQL database. This includes inserting JSON data, querying with `JSON_EXTRACT`, updating JSON field values, and creating an index on a JSON property. Connect to MySQL, create a database, and manipulate JSON data.
MySQL
MySQL Indexes and Performance Optimization

MySQL Indexes and Performance Optimization

In this lab, you will learn about MySQL indexes and performance optimization techniques. The lab focuses on creating and managing indexes to improve database query performance. You'll analyze query plans, add composite indexes, and remove unused indexes.
MySQL
MySQL Import and Export Operations

MySQL Import and Export Operations

In this lab, you will learn how to perform MySQL import and export operations. You'll explore importing data from CSV files into MySQL tables using `LOAD DATA INFILE`, exporting query results to CSV, and validating imported data. Master MySQL data handling!
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
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
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
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
MySQL Functions and Custom Logic

MySQL Functions and Custom Logic

In this lab, you will learn how to create and use custom functions in MySQL. The lab focuses on encapsulating reusable logic within your database by creating a function to calculate the area of a rectangle. Steps involve creating, using, testing, and dropping a MySQL function.
MySQL
Matplotlib Subplots Creation

Matplotlib Subplots Creation

In this lab, you will learn how to create and customize multiple subplots in a single figure using Matplotlib, a powerful plotting library in Python. You will practice creating subplots, plotting data on them, and adjusting layouts.
Matplotlib
  • Prev
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • ...
  • 165
  • Next