Course
Functions for Manipulating Data in PostgreSQL
- IntermediateSkill Level
- 4.8+
- 4.5K
Learn the most important PostgreSQL functions for manipulating, processing, and transforming data.
Data Manipulation
Data, AI, and Cloud Courses
Master skills that matterFollow short videos led by expert instructors and then practice what you’ve learned with interactive exercises in your browser.
- Learn at your own pace
- Get hands-on experience
- Complete bite-sized chapters
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.52 Courses
Course
Creating PostgreSQL Databases
- BasicSkill Level
- 4.8+
- 1.1K
Learn how to create a PostgreSQL database and explore the structure, data types, and how to normalize databases.
Data Preparation
Course
Introduction to NoSQL
- BasicSkill Level
- 4.8+
- 1K
Conquer NoSQL and supercharge data workflows. Learn Snowflake to work with big data, Postgres JSON for handling document data, and Redis for key-value data.
Data Engineering
Course
Cleaning Data in PostgreSQL Databases
- IntermediateSkill Level
- 4.8+
- 531
Learn to tame your raw, messy data stored in a PostgreSQL database to extract accurate insights.
Data Preparation
Course
NoSQL Concepts
- IntermediateSkill Level
- 4.8+
- 513
In this conceptual course (no coding required), you will learn about the four major NoSQL databases and popular engines.
Data Engineering
Course
Improving Query Performance in PostgreSQL
- IntermediateSkill Level
- 4.8+
- 491
Learn how to structure your PostgreSQL queries to run in a fraction of the time.
Software Development
Course
Transactions and Error Handling in PostgreSQL
- IntermediateSkill Level
- 4.8+
- 300
Ensure data consistency by learning how to use transactions and handle errors in concurrent environments.
Software Development
Course
Time Series Analysis in PostgreSQL
- IntermediateSkill Level
- 4.9+
- 182
Learn how to use PostgreSQL to handle time series analysis effectively and apply these techniques to real-world data.
Data Manipulation
Course
Introduction to Databricks
- BasicSkill Level
- 4.8+
- 5.6K
Learn about the Databricks Lakehouse platform and how it can modernize data architectures and improve data management processes.
Data Engineering
Course
Introduction to Snowflake
- BasicSkill Level
- 4.8+
- 5.6K
Snowflake is a top data warehousing platform. Learn how they use Snowsight, a user-friendly SQL interface for accessing and exploring data.
Data Warehouse
Course
Introduction to Importing Data in Python
- BasicSkill Level
- 4.8+
- 5.1K
Learn to import data into Python from various sources, such as Excel, SQL, SAS and right from the web.
Data Preparation
Course
Introduction to PySpark
- IntermediateSkill Level
- 4.8+
- 4.8K
Master PySpark to handle big data with ease—learn to process, query, and optimize massive datasets for powerful analytics!
Data Engineering
Course
Introduction to dbt
- IntermediateSkill Level
- 4.7+
- 3.5K
This course introduces dbt for data modeling, transformations, testing, and building documentation.
Data Engineering
Course
Introduction to Databases in Python
- IntermediateSkill Level
- 4.8+
- 739
In this course, youll learn the basics of relational databases and how to interact with them.
Data Manipulation
Course
Data Processing in Shell
- IntermediateSkill Level
- 4.9+
- 465
Learn powerful command-line skills to download, process, and transform data, including machine learning pipeline.
Data Manipulation
Course
Case Study: Data Analysis in Databricks
- AdvancedSkill Level
- 4.6+
- 287
Learn to analyze Airbnb data using SQL in Databricks, create dashboards, and derive actionable insights.
Importing & Cleaning Data
Course
Introduction to Redshift
- IntermediateSkill Level
- 4.9+
- 284
Master Amazon Redshifts SQL, data management, optimization, and security.
Data Engineering
Course
Querying a PostgreSQL Database in Java
- AdvancedSkill Level
- 4.8+
- 279
Connect Java to PostgreSQL with JDBC. Write secure queries, manage transactions, and handle large datasets efficiently.
Software Development
Course
Introduction to Databricks Genie
- BasicSkill Level
- 4.8+
- 171
Ask data questions in plain English with Databricks Genie - build spaces, curate business language, and monitor quality.
Data Engineering
Course
Select a Google Cloud Database for Your Applications
- BasicSkill Level
- 4.9+
- 33
In this course, you learn to analyze and choose the right database for your needs, to effectively develop applications on Google Cloud.
Cloud
Course
Intermediate Importing Data in Python
- BasicSkill Level
- 4.8+
- 4.2K
Improve your Python data importing skills and learn to work with web and API data.
Data Preparation
Course
Streamlined Data Ingestion with pandas
- IntermediateSkill Level
- 4.8+
- 1.4K
Learn to acquire data from common file formats and systems such as CSV files, spreadsheets, JSON, SQL databases, and APIs.
Data Preparation
FAQs
What is data science?
Data science is an area of expertise focused on gaining information from data. Using programming skills, scientific methods, algorithms, and more, data scientists analyze data to form actionable insights.
How can I learn data science?
You’ll need to learn a programming language such as Python or R and master the principles of math and statistics. Knowledge of data analysis methods and data science tools is also essential. There are many ways to learn data science. As well as formal means of education, such as a degree or university study, there are plenty of other resources to help you learn at your own pace. As well as online courses and tutorials, there are books, videos, and more.
What skills are required for data science?
As well as knowledge of mathematics and statistics, data scientists need programming skills in languages such as Python, R, and SQL. Additionally, data science requires the ability to work with large data sets, knowledge of data visualization, data wrangling, and database management. Skills in machine learning and deep learning can also be useful.
What can I use data science for?
In a professional capacity, almost every industry can use data science to some degree. Healthcare organizations use data science to detect and cure diseases, while finance companies use it to detect and prevent fraud. All kinds of industries use data science for marketing, such as building recommendation systems and analyzing customer churn.
Is data science a good career?
Yes, data science is among the fastest-growing sectors in the US and worldwide. It’s also one of the best-paid careers out there. According to data from Payscale, experience data scientists earn an average of $97,609 and have a satisfaction rating of four stars out of five in the US.
Is it difficult to become a data scientist?
There are a few things to consider here. First, data science degrees can be competitive to get onto, often requiring consistently high grades. Similarly, many of the skills required for data science require a lot of study and patience. It can take several months to master all of the necessary basics, as well as a lot of practical experience to secure an entry-level position.
Does data science require coding?
Yes, you’ll need some coding experience in languages such as Python, R, SQL, Java, and C/C++. However, due to its relatively simple syntax, Python programming language is often the preferred choice among newcomers.
How long does it take to become a data scientist?
For a person with no prior coding experience and/or mathematical background, it can typically take 7 to 12 months of intensive studies to be at the level of an entry-level data scientist. However, it is important to remember that learning only the theoretical basis of data science may not make you a real data scientist.
What topics can I study within data science?
Once you’ve mastered the foundations of data science, you can then specialize in a variety of areas, including machine learning, artificial intelligence, big data analysis, business analytics and intelligence, data mining, and more.
Grow your data skills with DataCamp for Mobile
Make progress on the go with our mobile courses and daily 5-minute coding challenges.