Home  /   Education

SQL Server පුහුණුව මුල සිට සරලව සිංහලෙන්

Published on 29 Jan 05:08 PM , Mount Lavinia - Colombo

Rs: 750

Info


For Sale
Category : Tuition

Share this ad



SQL Server පුහුණුව මුල සිට සරලව සිංහලෙන්

Conducted by the IT Senior Software Engineer .
Qualified with B.Sc Hons IT BCS
Course can be demonstrate in Sinhala or English language
Investment
Rs. 750/=(Per Hour/Per student)


1. Overview to Database Management System
2. Entity Relationship Diagrams
3. Enhanced Entity Relationship Diagrams (EER)
4. Data Normalization (0NF,1NF,2NF,3NF)
5. TSQL Overview
6. TSQL detailed sections
Data Definitions
Create/Alter/Drop table, Create/Alter/Drop Views etc.
Data Manipulations
Select / Insert/ Update data from Tables ,joining tables , Views etc.
Creating indexes
7. Optimizing Queries - basic rules only(optional)
8. Advanced TSQL
Stored Procedures ,Triggers
9. Constraints to tables advanced
Primary Key, Foreign Key , Unique Key
10. Aggregate functions, User Defined functions (Sum, Avg, Count … Built-in Functions etc.
11. Backup/restore database , creating users in SQL Server
12. SQL Server Report Services (SSRS)

AND MUCH MORE



I do not want to be contacted by brokers or any unsolicited services.

Contact


Sanjaya
075XXXXXXX
Click to show phone no

You may also like

Do you have something to sell?

Post your ad on Bambuwa.lk