Search this site
Home
Microsoft IT Academy
Microsoft Technology Associate (MTA)
MTA Software Development
MTA in System Administration
Microsoft Certified Professional (MCP)
Windows Server
SQL Server
Microsoft Sharepoint
Microsoft Office Specialist (MOS)
Cisco CCNA
Oracle
Java
LINUX Systems
PHP-MySQL
Android
Smart Processes
e-learning
Testoni njohurite Tuaja
Rreth Nesh
Kontakt
ICT Newsletter
Kalendari i trajnimeve
Te reja dhe evente
Referenca
Thirrje për aplikim
Kalendari i trajnimeve
ICT Education Newsletter
e-learning
>
Writting SQL Queries in SQL Server
Content
Chapter 00 - Bazat e te dhenave relacionale
Chapter 01 - Retrieving data using SELECT statement
Chapter 02 - Reporting aggregated data using group functions
Chapter 03 - Displaying data form multiple tables
Chapter 04 - Ranking Functions
Chapter 05 - Common Table Expressions
Chapter 06 - Managing content through DML commands
Chapter 07 - Transactions
Chapter 08 - Views
chapter 09 - Functions
Chapter 10 - Procedures
Chapter 11 Trigerat
Chapter 12 - Te dhenat XML
Exporting XML to a File
Exercices