Softuni-DB-Basics

The course covers:

• MSSQL Server, T-SQL;
• creating tables and relations between them;
• queries and nested queries;
• built-in functions;
• user-defined functions;
• stored procedures;
• transactions;
• triggers;

Tasks

• Data definitions and data types
• Basic CRUD
• Built-in functions
• Data aggregation
• Table relations
• Joins, subqueries, indexes and CTEs
• Functions, triggers and transactions

Exams

• Exam-19th-Feb-2017 - Bakery
• Exam-24th-April-2017 - WMS
• Exam-22nd-Oct-2017 - Report service