SQL Server Developer Beginner - анхан шатны сургалт

Товч агуулга

• 1. Understand what DQL is
• 1.1 Learn to retrieve data from a table (SELECT)
• 1.2 Learn to limit results using WHERE
• 1.3 Learn to sort results using ORDER BY
• 1.4 Learn to group results using GROUP BY
• 1.5 Learn to filter groups using HAVING
• 1.6 Learn to join tables using JOIN
• 1.7 Learn to use aggregate functions - COUNT, AVG, SUM, MIN, MAX.
• 2. Understand what DML is.
• 2.1 Learn to insert data into tables (INSERT)
• 2.2 Learn to update data in tables (UPDATE)
• 2.3 Learn to delete data from tables (DELETE)
• 2.4 Understand the concept of transactions
• 2.5 Learn to start transactions (BEGIN TRAN, COMMIT, ROLLBACK).
• 2.6 Learn to use MERGE statement.