SQL Server for Developer
តម្លៃ៖ 120$
សិក្សារយៈពេល ៖ 55-60 ម៉ោង
ច័ន្ទ - សុក្រ ៖ 1ខែ21ថ្ងៃ - 1ខែ24ថ្ងៃ (សិក្សា១ម៉ោងកន្លះក្នុងមួយថ្ងៃ)
សៅរ៍ - អាទិត្យ ៖ 3ខែ8ថ្ងៃ - 3ខែ21ថ្ងៃ (សិក្សា២ម៉ោងក្នុងមួយថ្ងៃ)
សម្រាប់អ្នកចេះបង្កើតកម្មវិធីជាមួយ C# ឬ VB.NET ឬ Java ដើម្បីប្រើប្រាស់ និង គ្រប់គ្រងទិន្នន័យក្នុង Database ( ឬបញ្ចប់វគ្គ C# Database ឬ VB.NET Database ឬ Java Database) ហើយចង់លម្អិតទៅលើ SQL Server ក្នុងការប្រើសម្រាប់បង្កើតកម្មវិធី ឬ គេហទំព័រ ។
គ្រោងនៃការសិក្សា
Chapter I : Introduction to Database
- SQL Server Installation
- What is database?
- What is DBMS?
- Conceptual Database Design
- Integrity Constraints
- Relationship
Chapter 2: Understanding Tables and Databases
- System Databases
- User Define Database
+ Creating databases manually
+ Creating databases with database wizard
+ Attach and Detach Database
+ Backup and Restore database (with scheduling)
+ Script out an entire database
+ Database collation
+ deletion and renaming database
Chapter 3 : Index and Views
- The basics of index structures
- Creating and working with indexes
- Indexes and table architecture
- Creating views (including using view manager)
- Working with views
- Indexed views
Chapter 4 : Functions
- Build-in functions
- User-define functions
+ Scalar functions
+ Inline table-valued functions
+ Multi-statement table-valued functions
Chapter 5 : Stored Procedures, Triggers and Replication
- Components of stored procedures
- Creating and working with stored procedures/system stored procedures (Parameters)
- Components of triggers
- Creating and working with triggers
- Replication model and types of replication
- Merge replication
Chapter 6: Advanced T-SQL
- Using aggregate functions in the select list
- Grouping rows with GROUP BY
- Combining results with UNION
- Subquery fundamentals
- Conditional data processing using CASE
- Parallel queries
Chapter 7: Securities and Authentications
- Authentication types
- Creating users
- Creating roles
Chapter 8: Connecting to Programming Language