SQL Server 2019 Básico

SQL Server 2019 – Basic Level The SQL Server Basic badge attests to a user’s foundation in interacting with relational databases. Earners understand table structures and relationships, and are capable of performing essential queries (SELECT) as well as data manipulation operations (INSERT, UPDATE, DELETE) to effectively retrieve and manage information.

Skills

Relational Database Concepts
SQL Server Management Studio (SSMS)
Basic Queries (SELECT)
Filtering & Sorting (WHERE, ORDER BY)
Data Manipulation (INSERT, UPDATE, DELETE)
Basic Joins (INNER JOIN)
Aggregate Functions (SUM, COUNT, AVG)

Earning Criteria

Understanding Database Fundamentals (Tables, Primary Keys, Foreign Keys) Navigating SQL Server Management Studio (SSMS) Writing Basic SELECT Queries Filtering Data with WHERE and Logic Operators Sorting Data with ORDER BY Modifying Data (INSERT, UPDATE, DELETE statements) Connecting Tables with Basic JOINS