Ad added to watch list.
Mouse over image to zoom
Price : |
Rs. 750
|
Type : |
Offered |
Contact : |
Sanjaya
- 0750656462 |
Date : |
03/02/2018 15:11 |
District : |
Colombo |
Details : |
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
The teacher has the following qualifications and experience
* Successfully conducting courses for students part time
basis for last 10 years
* Worked as a Assistance Lecturer at Semi Government Institution - More than 1
year
* Conducted Tutorial Classes For Diploma Level Students
* C Language
* Visual Basic .NET
* Introduction to Computer Systems
* Instructed for part-time/weekend courses
* Certificate Course in VB.Net Programming for Database Applications
* Certificate Course in Personal Computer Based Application Packages
* Certificate Course in Design and Development of Computer Systems
* International Computer Driving License [ICDL] Course |
|
|
|
Sell Faster!!
More
|