Учебные материалы по SQL

Будьте в курсе последних техник и ресурсов по SQL Server. В наших учебниках — множество бесплатных советов по обучению работе с SQL Server, которые помогут вам учиться, создавать и развиваться.

Другие технологии:

Обучение двух или более человек?Попробуйте DataCamp for Business

MySQL in Python Tutorial: Getting Started

In this tutorial, you'll learn how to install MySQL, create databases, and create tables, along with much more.

14 апреля 2023 г.

Building Data Pipelines using R

Learn how to transform and load (ETL) a data pipeline from scratch using R and SQLite to gather tweets in real-time and store them for future analyses.

3 октября 2019 г.

SQL Interface within JupyterLab

Learn how to use and modify SQL tables within JupyterLabs.

23 июля 2019 г.

User Defined Stored Procedures in SQL

Learn how to use and apply the user-defined stored procedure along with examining different types of stored procedures in SQL.

15 июля 2019 г.

Materialized Views in PostgreSQL

Learn how to store the results of a query with the help of materialized views in PostgreSQL.

2 мая 2019 г.

Cleaning Data in SQL

In this tutorial, you'll learn techniques on how to clean messy data in SQL, a must-have skill for any data scientist.

24 апреля 2019 г.

SQLite in R

In this tutorial, you will learn about using SQLite, an extremely light-weight relational database management system (RDBMS) in R.

19 апреля 2019 г.

Data Visualization with Power BI

Learn how to analyze and display data using Power BI and make better, more data-driven decisions.

30 августа 2024 г.

Aggregate Functions in SQL

Learn how to use aggregate functions for summarizing results and gaining useful insights about data in SQL.

17 апреля 2019 г.

CASE Statements in PostgreSQL

In this tutorial, you'll learn how to write conditional queries in PostgreSQL using the PostgreSQL CASE conditional expression.

3 апреля 2019 г.

10 Command-line Utilities in PostgreSQL

In this tutorial, learn about 10 handy command-line utilities in PostgreSQL which can enable you to interact with databases efficiently.

29 марта 2019 г.

SQL with Power BI

In this tutorial, you'll learn how to connect Power BI to a Microsoft SQL Server database and then analyze the data to get insights.

28 марта 2019 г.