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
MySQL Basic Data Manipulation
In this lab, we will explore the fundamental data manipulation operations in MySQL including inserting, selecting, updating, and deleting data using SQL commands.
MySQL
Create a Product Catalog Table
A local bookstore needs help setting up their product catalog database with proper table structure, data types, and constraints
MySQL
Create Your First MySQL Database
Learn how to create and manage your first MySQL database using essential commands. Perfect for beginners starting with database administration.
MySQL
Record Movie Data Challenge
A local cinema needs help setting up their movie database by inserting accurate movie records with titles, release years, genres, and pricing information
MySQL
MySQL User and Privileges Management
In this lab, we will explore user management and privileges in MySQL, essential skills for securing your database system
MySQL
Installation and Basic Configuration of MySQL
Learn how to install, secure, and perform basic operations in MySQL, a popular open-source relational database management system. This lab covers verifying installation, securing the MySQL instance, accessing the MySQL shell, creating databases and tables, and performing basic data operations.
MySQLLinux
MySQL Sales Data Analysis Challenge
A retail store manager needs help analyzing their sales data to make inventory decisions by calculating revenue performance across different product categories
MySQLLinux
MySQL Table Structure and Data Types
In this lab, we will explore the fundamentals of MySQL table structures and data types
MySQL
Book Search Challenge
A local bookstore is looking to improve their inventory management system by implementing a database query system to search for technical books based on publication date and price
MySQLLinux
MySQL Data Filtering and Sorting
In this lab, we will explore essential techniques for filtering and sorting data in MySQL
MySQL
How to create inline functions in Python
Learn to create efficient inline functions in Python using lambda expressions, explore advanced techniques, and improve your functional programming skills with concise code solutions.
Python
MySQL Data Aggregation and Grouping
In this lab, we will explore data aggregation and grouping in MySQL, essential skills for analyzing and summarizing data in databases
MySQL
How to efficiently group a Python list based on a given function
Learn how to efficiently group a Python list based on a given function. Discover built-in methods and advanced techniques to streamline your list grouping process.
Python
Database Management Fundamentals with MySQL
Previously, we have covered the process of installing a MySQL server, connecting to it using a client and performing some basic administration tasks.
MySQL
How to format the hexadecimal output in Python
Explore how to effectively format hexadecimal output in your Python programs. Learn the basics of hexadecimal and discover practical applications for this powerful numerical representation.
Python
MySQL Database Access Challenge
A small company needs to set up secure database access with appropriate permissions for their new marketing team users
MySQL
MySQL Multi-Table Operations
In this lab, we will explore the fundamentals of working with multiple tables in MySQL
MySQL
Author Book Information Challenge
A library database administrator needs help creating a report that combines information from the authors and books tables to generate a comprehensive publication listing
MySQLLinux
- Prev
- 1
- 2
- 3
- 4
- 5
- 6
- ...
- 238
- Next