Обучение MS SQL Server

Уровень 0 · материалов: 5

В кластер входят обучающие материалы по работе с MS SQL Server, включая язык запросов и инструменты интеграции, но не входят руководства по другим языкам запросов, таким как PromQL.

Общие признаки: базовые навыки работы с MS SQL Server, руководства для начинающих, манипуляция данными, запросы и агрегация в SQL

Группа выше: Выбор и сравнение систем управления базами данных

Материалы

• #20618 — SQL Language Tutorial: DDL and DML in MS SQL Server — Представитель этого кластера

  Учебник по языку SQL (DDL, DML) на примере диалекта MS SQL Server. Часть пятая — Leran2002

  Смысл: The text is a practical educational guide designed to teach beginning IT specialists how to manipulate data and perform advanced analysis using MS SQL Server, emphasizing safety and precision in database administration.

  A detailed practical guide to MS SQL Server DML operations, advanced analytical window functions, and data synchronization techniques.

• #28073 — Practical Guide to SQL DDL and DML in MS SQL Server

  Учебник по языку SQL (DDL, DML) на примере диалекта MS SQL Server. Часть первая — Leran2002

  Смысл: The text is a practical educational guide on the basics of SQL, focusing specifically on Data Definition Language (DDL) using MS SQL Server. It aims to teach beginners how to create tables, manage data types, implement constraints, normalize databases, and optimize performance using indexes.

  A practical, step-by-step tutorial on using MS SQL Server to design databases, implement constraints, normalize data, and optimize queries through indexing.

• #16180 — SQL Tutorial: Basic DML with MS SQL Server

  Учебник по языку SQL (DDL, DML) на примере диалекта MS SQL Server. Часть вторая — Leran2002

  Смысл: The main idea is to provide a foundational understanding of the SQL SELECT statement and basic data manipulation in MS SQL Server, emphasizing practical execution and the importance of understanding how the database handles types and NULLs.

  A practical guide to basic SQL DML in MS SQL Server, focusing on the SELECT operator, filtering, sorting, and data type nuances.

• #9727 — SQL Tutorial: CASE Expressions, Aggregates and Grouping in MS SQL Server

  Учебник по языку SQL (DDL, DML) на примере диалекта MS SQL Server. Часть третья — Leran2002

  Смысл: The main idea is to teach beginners how to transition from simple data retrieval to generating summary reports using conditional logic (CASE), aggregation functions, and grouping mechanisms (GROUP BY, HAVING) within MS SQL Server.

  A practical guide to MS SQL Server focusing on conditional expressions, aggregate functions, data grouping, and the use of views for simplified reporting.

• #21167 — Getting Started with SQL Server Integration Services (SSIS)

  SQL Server Integration Services (SSIS) для начинающих – часть 1 — Leran2002

  Смысл: The text is a practical, step-by-step tutorial designed to teach beginners how to install, configure, develop, deploy, and automate data integration packages using Microsoft SQL Server Integration Services (SSIS).

  A comprehensive beginner's guide to setting up SSIS, creating basic ETL packages to move data between SQL databases, and deploying them via SQL Server Agent.