Master SQL Server & T-SQL Course
Uploaded by
tirana.it.tctMaster SQL Server & T-SQL Course
Uploaded by
tirana.it.tctTCT
TIRANA CENTER
OF TECHNOLOGY
Microsoft SQL Server – Querying Data with Transact-SQL
Kursi Microsoft SQL Server – T-SQL Querying prezanton studentët me përdorimin dhe
menaxhimin e databazave duke përdorur Transact-SQL. Gjatë programit mësohen bazat e SQL
Server, krijimi i query-ve SELECT dhe menaxhimi i shumë tabelave.
Gjithashtu trajtohen tema të avancuara si agregimi i të dhënave, subquery, funksionet, stored
procedures, trajtimi i gabimeve dhe transaksionet. Kursi ofron aftësi për dizajnimin dhe
menaxhimin profesional të databazave.
The objectives of the database course at Tirana Center of Technology covered primarily
Microsoft course 20761B. This course also overviewed topics from the Microsoft Administration
course.
Database Querying: Course 70-461
Module 1: Introduction to Microsoft SQL Server 2016
Module 2: Introduction to T-SQL Querying
Module 3: Writing SELECT Queries
Module 4: Querying Multiple Tables
Module 5: Sorting and Filtering Data
Module 6: Working with SQL Server 2016 Data Types
Module 7: Using DML to Modify Data
Module 8: Using Built-In Functions
Module 9: Grouping and Aggregating Data
Module 10: Using Sub-queries
Module 11: Using Table Expressions
Module 12: Using Set Operators
Module 13: Using Window Ranking, Offset, and Aggregate Functions
Module 14: Pivoting and Grouping Sets
Module 15: Executing Stored Procedures
Module 16: Programming with T-SQL
Module 17: Implementing Error Handling
Module 18: Implementing Transactions
Rr Durresit
# 53 Tirane + 355 67 686 1620
www. tct. edu. al info@[Link]
TCT
TIRANA CENTER
OF TECHNOLOGY
Module 19: Create & Alter database objects
1. Create and alter tables using T-SQL syntax
2. Create and alter views
3. Design views
4. Create and modify constraints
5. Create and alter Stored Procedures
6. Create and alter user defined functions
Module 20: Administering Databases
1. Full, Differential and Transaction Log Backup
2. Restore Databases
Module 21: Design & Create Database on Customer Request Exercise
Rr Durresit
# 53 Tirane + 355 67 686 1620
www. tct. edu. al info@[Link]