Introduction to SQL

4 ore

41 capitoli

Principiante

This course is perfect for beginners ready to explore the world of SQL. Whether you're just starting out in database management or aiming to use SQL for your application development projects, this course covers the essentials. You'll quickly learn how to leverage the full potential of SQL, from querying and managing data to seamlessly integrating it into real-world applications. By the end of the course, you'll have the confidence and skills to solve practical problems with SQL and enhance your development process.

Vedi dettagli

Intermediate SQL

3 ore

25 capitoli

Intermedio

This course is perfect for those who already have a basic understanding of SQL and want to delve into more advanced concepts to craft more powerful queries. Throughout the course, you will become familiar with data grouping and filtering grouped data. You will also learn how to work with multiple tables simultaneously, including how to combine them. Additionally, you will explore different types of table joins and how to apply them in practice.

Vedi dettagli

Pandas First Steps

4 ore

33 capitoli

Intermedio

Pandas is an extremely user-friendly library for data analysis. It's also designed to handle large datasets, using data structures like DataFrame and Series. This makes it an invaluable tool for Data Science. In this guide, you'll get acquainted with a range of statistical functions, including how to find correlations, modes, medians, and maximum and minimum values within a dataset. You'll also learn how to handle missing values and manipulate specific values, as well as how to remove them.

Vedi dettagli

Excel Formulas

1 ora

15 capitoli

Principiante

This course is designed for beginners who want to start exploring formulas in Excel. You'll begin with the basics and then discover some really useful formulas for daily use. You'll learn about array formulas and how they work, and you'll also dive into Lookup and Reference functions.

Vedi dettagli

Conducting Exploratory Data Analysis of Nobel Prizes

1 ora

6 capitoli

Intermedio

We will delve into the concept of Exploratory Data Analysis (EDA) and explore its critical role within every Data Analysis process, particularly focusing on the analysis of Nobel Prizes. EDA serves as a foundational step that enables data scientists and analysts to uncover patterns, anomalies, and insights from data through visual and statistical methods.

Vedi dettagli

Extracting Text Meaning using TF-IDF

2 ore

12 capitoli

Intermedio

This project focuses on the design and implementation of a robust text summarizer, built using Python. By harnessing the capabilities of Python’s Natural Language Toolkit (NLTK), participants will gain hands-on experience in processing and analyzing textual data. The project covers a range of NLP techniques essential for text summarization. Participants will develop skills in parsing text and extracting meaningful content, learning how to filter essential information from large volumes of text.

Vedi dettagli

Recognizing Handwritten Digits

2 ore

10 capitoli

Avanzato

In this project, our primary objective will be to delve into the identification of handwritten digits through the application of machine learning algorithms. This endeavor aims to harness the power of machine learning to effectively interpret and understand handwritten digits, showcasing the potential of these algorithms in processing and analyzing complex visual information.

Vedi dettagli

Advanced Techniques in pandas

4 ore

33 capitoli

Intermedio

This course contains a lot of useful functions for a future data analyst. You will learn different ways of extracting data and even set conditions on it. After it, you will be familiar with the methods of grouping data. Also, you will learn how to preprocess data. Each section has its data set so that the course will be gripping.

Vedi dettagli

Ultimate NumPy

3 ore

27 capitoli

Intermedio

Unlock the full potential of Python's most essential library for numerical computing, NumPy. This comprehensive course is designed to take you from a beginner's understanding to an advanced level of proficiency in NumPy. Whether you're a data scientist, engineer, researcher, or developer, mastering NumPy is essential for efficient data manipulation, scientific computing, and machine learning.

Vedi dettagli

Introduction to Neural Networks

4 ore

25 capitoli

Avanzato

Neural networks are powerful algorithms inspired by the structure of the human brain that are used to solve complex machine learning problems. You will build your own Neural Network from scratch to understand how it works. After this course, you will be able to create neural networks for solving classification and regression problems using the scikit-learn library.

Vedi dettagli

Identifying the Most Frequent Words in Text

1 ora

11 capitoli

Principiante

In this project, we will be utilizing the capabilities of the Natural Language Toolkit (NLTK), a versatile and comprehensive library in Python designed for working with human language data. Our focus will encompass several core areas of natural language processing: tokenization, stemming, tagging and parsing. These NLTK features will form the backbone of our text processing and analysis tasks, making it an essential tool in our project for handling and extracting meaningful insights from language data.

Vedi dettagli

Relational Database and Normalization

1 ora

12 capitoli

Principiante

This course delves into the theory behind relational databases. You'll learn what they are and see how they differ from non-relational databases. Throughout the course, we'll walk you through the ins and outs of database design and familiarize you with various types of relationships. Additionally, you'll explore the concepts of normalization and normal forms, equipping you with the knowledge to craft efficient and optimized databases.

Vedi dettagli