- Beranda
- Komunitas
- Tech
- Programmer Forum
[ASK] Kursus C# & SQL Server
TS
jaimansunjoyo
[ASK] Kursus C# & SQL Server
Dear agan n aganwati,
ada yang punya waktu engga buat ngajarin ane bahasa permograman C#, SQL Server dan ASP.NET, setiap akhir weekend
ini silabusnya
C#
1. Fundamental C# Programming
2. Advanced C# Programming
3. NET Programming with C#
SQL Server
• SQL Server 2008 Overview and Installation
• SQL Server Management Studio
• Database Design and Creation
• Security and Compliance
• Defining Tables
• Creating Indexes
• Database Backups, Recovery, and Maintenance
• Working with the Data
• Building a View
• Stored Procedures and Functions
• T-SQL Essentials
• Advanced T-SQL
• Triggers
ada yang punya waktu engga buat ngajarin ane bahasa permograman C#, SQL Server dan ASP.NET, setiap akhir weekend
ini silabusnya
C#
1. Fundamental C# Programming
a. Basic C# Programming
b. Expressions and Operators
c. Decisions, Loops, and Preprocessor Directives
d. Object-Oriented Programming
e. More about Classes and Objects
f. Derived Classes
g. Interfaces
h. Strings, Dates, Times, and Time Spans
i. Arrays and Indexers
j. Collections
k. Delegates and Events
l. Exceptions and Debugging
b. Expressions and Operators
c. Decisions, Loops, and Preprocessor Directives
d. Object-Oriented Programming
e. More about Classes and Objects
f. Derived Classes
g. Interfaces
h. Strings, Dates, Times, and Time Spans
i. Arrays and Indexers
j. Collections
k. Delegates and Events
l. Exceptions and Debugging
2. Advanced C# Programming
a. Threads
b. Streams and Input/Output
c. Assemblies
d. Attributes and Reflection
e. Remoting
f. Security
g. XML
h. Other Classes in the Base Class Library
b. Streams and Input/Output
c. Assemblies
d. Attributes and Reflection
e. Remoting
f. Security
g. XML
h. Other Classes in the Base Class Library
3. NET Programming with C#
a. Active Data Objects: ADO.NET
b. Introduction to Windows Applications
c. Active Server Pages: ASP.NET
d. Web Services
b. Introduction to Windows Applications
c. Active Server Pages: ASP.NET
d. Web Services
SQL Server
• SQL Server 2008 Overview and Installation
o Hardware Requirements
o Installation
o Security
o Installation
o Security
• SQL Server Management Studio
o SSMS Options
o Query Editor
o Query Editor
• Database Design and Creation
o Defining a Database
o Prebuilt Databases
o Database System Type
o Building Relationships
o Normalization
o Prebuilt Databases
o Database System Type
o Building Relationships
o Normalization
• Security and Compliance
o Server Logins and Database Users
o Roles
o Schemas
o Roles
o Schemas
• Defining Tables
o SQL Server Data Types
o Image and Large Text Storage
o Creating Table
o Primary Key
o Relationship
o Image and Large Text Storage
o Creating Table
o Primary Key
o Relationship
• Creating Indexes
o Creating Index
o Drop Index
o Alter Index
o Drop Index
o Alter Index
• Database Backups, Recovery, and Maintenance
o Transaction Logs
o Backing Up the Data
o Restoring a Database
o Creating a Database Maintenance Plan
o Setting Up Database Mail
o Backing Up the Data
o Restoring a Database
o Creating a Database Maintenance Plan
o Setting Up Database Mail
• Working with the Data
o Select, Insert, Update and Delete Data
o DBCC CHECKIDENT
o Constraint
o Transaction
o Truncate Table
o DBCC CHECKIDENT
o Constraint
o Transaction
o Truncate Table
• Building a View
o Using Views for Security
o Encrypting View Definitions
o Creating View
o Indexing View
o Encrypting View Definitions
o Creating View
o Indexing View
• Stored Procedures and Functions
o Creating Stored Procedure
o Stored Procedure Executing Methods
o Flow Control
o User Defined Functions
o Stored Procedure Executing Methods
o Flow Control
o User Defined Functions
• T-SQL Essentials
o Joining Tables
o Variables
o Aggregations
o Grouping Data
o Error Handling
o Variables
o Aggregations
o Grouping Data
o Error Handling
• Advanced T-SQL
o Subqueries
o Apply Operator
o Common Table Expressions
o Pivot Data
o Ranking Functions
o Using PowerShell
o Apply Operator
o Common Table Expressions
o Pivot Data
o Ranking Functions
o Using PowerShell
• Triggers
o Creating Trigger
o DML Trigger
o DDL Trigger
o DML Trigger
o DDL Trigger
0
5.5K
43
Komentar yang asik ya
Urutan
Terbaru
Terlama
Komentar yang asik ya
Komunitas Pilihan