Top Results for SQL

Within a data warehouse workflow, dbt turns SQL transformations into an organized project. Analysts and engineers write models that convert raw records into tables or views suitable for reporting and further analysis. Dependencies between models help structure that work, so a shared business calcula...

SQLite embeds a SQL database engine directly within an application instead of requiring a separate database server. A persistent database normally resides in a single portable file, making local storage straightforward to distribute and back up. The engine is widely used in mobile and desktop softwa...

For applications that need structured, dependable data storage, PostgreSQL provides an open-source relational database system. It uses Structured Query Language, usually shortened to SQL, to define and query information. Tables and relationships give data an explicit structure, while transactions al...

The IBM Data Analyst Professional Certificate covers practical tools used to organize, examine and present data. Its subject areas include Excel, Python and SQL, connecting spreadsheet work with programming and database queries. Data cleaning and exploratory analysis, the process of examining data f...

Oracle Database is a robust RDBMS designed for large-scale enterprise applications. It’s notable for its high performance capabilities and support of complex transactional workloads. Primarily used by organizations needing reliable data management solutions, Oracle Database caters to industries incl...

Designing a database means deciding how information should be structured so an application can store it consistently and retrieve it efficiently. Relational systems such as PostgreSQL organize data into related tables, while document databases such as MongoDB use a different model. Understanding SQL...

Retool is a development platform that enables teams to rapidly build internal tools by visually connecting to databases and APIs, streamlining workflows through customizable UI components and pre-built integrations.

Microsoft SQL Server is a relational database management system for storing information in structured tables and querying the relationships between them. It uses SQL, including Microsoft's Transact-SQL extensions, to retrieve and change data. Businesses use it behind applications and reporting syste...

Cloud-based warehousing sits at the center of Snowflake's data platform, where teams load information from different sources and analyze it with SQL. The service manages the underlying infrastructure, reducing the need to operate database servers directly. Its architecture separates stored data from...

Dataquest offers a unique interactive learning experience where students learn by coding directly in the browser. Unlike video-heavy platforms, Dataquest focuses on 'learning by doing.' The Data Analyst Path covers Python for data science, SQL for database querying, and exploratory data analysis. It...

Postgres Documentation provides a complete reference for PostgreSQL users. This official resource details the database system’s SQL syntax, features, and administration tasks. It supports developers, database administrators, and anyone seeking to understand or effectively utilize this modern, enterp...

PostgreSQL sits at the center of Supabase, an open-source backend platform positioned as an alternative to Firebase. Alongside the database, it provides authentication and file storage, with realtime features for applications that respond to data changes. Automatically generated APIs expose database...

MySQL, now owned by Oracle, remains a widely used relational database, particularly popular for web applications. Its maturity and extensive ecosystem contribute to its continued relevance. While its open-source roots are important, the licensing model has evolved, impacting some users. MySQL's perf...

Databricks SQL provides data-warehouse capabilities within the Databricks platform, allowing analysts to query data with SQL through dedicated compute resources called SQL warehouses. Delta Lake is central to its lakehouse approach, which combines data-lake storage with tools for structured analytic...

ClickHouse is an open-source, column-oriented database management system designed for online analytical processing (OLAP). It is famous for its incredible speed when performing aggregations on billions of rows. ClickHouse is often used in high-performance scenarios like log analysis, web analytics,...

DuckDB is an in-process SQL OLAP database management system. It is often described as 'SQLite for analytics.' Because it runs inside the application process, there is no need to set up a separate server or manage connections. DuckDB is incredibly fast for local data analysis and integrates perfectly...

Google BigQuery is a serverless, highly scalable, and cost-effective multi-cloud data warehouse. It is designed for business agility, allowing users to run SQL queries on massive datasets without managing any infrastructure. BigQuery's unique architecture separates compute from storage, and its inte...

Amazon Relational Database Service, or RDS, helps teams set up and operate relational databases within AWS. It supports engines such as PostgreSQL, MySQL and SQL Server, allowing applications to retain familiar SQL queries and relational data structures. Managed maintenance and backup features reduc...

DBeaver is a comprehensive database tool designed for professional use. It provides a graphical interface to manage multiple databases including MySQL, PostgreSQL, Oracle, and MongoDB. Users benefit from its cross-platform compatibility and ability to execute SQL queries effectively, making it suita...

CockroachDB is a distributed SQL database designed for resilience and scalability. Its built to handle massive workloads and provides strong consistency guarantees through its multi-region architecture. Its cloud-native design simplifies deployment and management, while its SQL interface makes it a...

Writing code during lessons is central to Dataquest's Data Analyst in Python path. The program introduces Python and SQL through interactive exercises, then connects those skills to practical analysis work. Learners practice preparing data and querying databases, with visualization and statistics he...

Data Build Tool (dbt) allows data analysts and engineers to transform data *within* the data warehouse using modular SQL models, treating the warehouse itself as a software application. It enforces version control and testing on data transformations. This shifts data engineering practices closer to...

The Supabase AI Assistant is an extension for the Supabase database platform. It provides generative AI functionality allowing developers to create applications with intelligent features. Users building backend systems or needing chatbot and content generation capabilities will find this tool valuab...

DataCamp excels in providing an incredibly hands-on, interactive learning environment. Its career tracks guide users step-by-step through the necessary skills, allowing immediate practice in the browser. It is perfect for absolute beginners who need constant, low-stakes coding practice to build conf...

Caspio is a low-code application development platform that allows users to build custom web and mobile applications without extensive coding knowledge, primarily utilizing a visual interface for data integration and workflow automation.

Snowflake is a fully managed, cloud-native data platform that excels in performance, scalability, and ease of use. Unlike traditional warehouses, it separates compute and storage, allowing users to scale resources independently based on workload demand. Its multi-cluster architecture ensures that co...

The Google Data Analytics Professional Certificate is the gold standard for beginners entering the field. Hosted on Coursera, this program covers the entire data lifecycle, including data preparation, processing, analysis, and visualization. It emphasizes practical skills using tools like R, SQL, Ta...

The Complete SQL Bootcamp is an online Udemy course taught by Jose Portilla that introduces relational database querying through PostgreSQL. It covers core SQL operations such as selecting and filtering records, grouping results, joining tables, using aggregate functions, creating databases and tabl...

Amazon Redshift is a fast, fully managed data warehouse that makes it easy to run complex queries against petabytes of data. It uses columnar storage and massively parallel processing (MPP) to deliver high performance for business intelligence workloads. As part of the AWS ecosystem, Redshift offers...