|
www.KursusKomputerKu.com |
|
SILABUS Programmer |
Jenis Program : Special Class |
|
Durasi: 252 Jam |
DESKRIPSI:
Tujuan dari Program ini untuk
menghasilkan seorang programmer yang dapat melakukan pekerjaan analisa bisnis,
mendesain, membangun dan mengimplementasikan sebuah sistem solusi berikut
dengan aplikasi database dengan menggunakan teknologi komputer yang populer.
Secara keseluruhan dalam kursus ini
anda akan belajar:
. Algoritma dan Struktur Data
. Pemrograman Aplikasi Database
. Manajemen Database Server
. System Development
. Proyek Implementasi
Peserta:
· Lulusan SMA atau sederajat
· Low entry - Programmer
· Staf IT/Technical Staf
· System Administrator
PERSYARATAN KEMAMPUAN AWAL :
. Sudah lulus SMA atau setingkat
DURASI :
84 Sesi X 3 jam
Tujuan:
Peserta dapat membuat dan membangun
aplikasi database dengan menggunakan teknologi komputer yang sudah populer
seperti Microsoft Visual Basic.NET dan Microsoft SQL Server
PEKERJAAN YANG BERHUBUNGAN :
· Analyst Programmer
· System Designer
· System Programmer
· Engineering Implementation
Specialist
· MIS (Management Information System)
Staff
· Application Programmer / Developer
· Database Administrator / Developer
· IT Support Specialist
· IT Project Manager
· Audit Technology Programmer (ATP)
· Junior Technical Consultant ERM
(ERP)
· Junior Data Processing Executive
REKOMENDASI PELATIHAN SELANJUTNYA :
---
REFERENSI :
---
SUSUNAN MATERI:
MATERI SOFT SKILL
- Bagaimana Membawakan Presentasi yang Efektif (Participants Certificate)
Lihat Silabus
- Membangun Kerjasama Tim
Logical Programming with Microsoft VB .NET 2005
Introduction
to Programming, Algorithm and Flowchart
Introduction
to Programming World
Introduction
to Algorithm
Introduction
to Flowchart
Introduction
to Some Programming Cases
Introduction
to Real Programming Case
Progression
/ Sequence
Validation
& Verification
Positioning
& Animation
String
Manipulation
Microsoft
.NET Framework
Introduction
to Microsoft .NET Framework
Object
Oriented Programming Concept
Microsoft
.NET Framework Component
Namespace
IDE
Visual Studio .NET
Console
Application
Data
and Control Flow
Introduction
Variable and Data Type
Introduction
to Control Flow
Array
Exception
String
Manipulation
String
String
Functions
String
Builder
Object
Oriented Programming (OOP)
Object
Oriented Programming Concept
Characteristic
of OOP
File
Streaming
File
Manipulation
File
I/O
Introduction to Database with Microsoft Access
Introduction
to Database System
Introduction
to Database
Overview
Ms Access
Create
Database
Database
Password
Compact
and Repair
Security
Import
and Export
Table
Create
table
Property
of object table
Primary
Key & Foreign Key
Types
of Data
Relationship
between Table
Relationship
(in RDBMS)
Create
relationship
Types
of relationship
Cascade
update and delete
Query
Definition
of Query
Tools
in Query
SQL
statement
Types
of Query
Query
Advanced
Inter
table query
Query
with Group by
Calculated
Query
Visual Programming with Microsoft VB .NET 2005
Introduction
to Visual programming
Introduction
to VB .NET
Visual
Programming Environment
Visual
Programming Terminology
Event-Driven
Project
Management
Visual
Component - 1
About
Component
Basic
Component
Collections
Collections
ArrayList
Other
Collections
Visual
Component - 2
ComboBox
List
Box
CheckedListBox
TabControl
DateTimePicker
MonthCalendar
ScrollBar
TrackBar
ProgressBar
DomainUpDown
NumericUpDown
TreeView
ListView
Message
and Runtime Component
Input
Box and MessageBox
Runtime
Component
Menu
and Toolbar
ImageList
MenuStrip
ContextMenuStrip
ToolStrip
StatusStrip
ToolStripContainer
Dialog
About
Dialog
OpenFileDialog
SaveFileDialog
ColorDialog
Font
Dialog
FolderBrowserDialog
Graphics
Image
PictureBox
Color
Graphics
Form,
MDI, and User Control
Form
MDI
Form
UserControl
Setup
and Deployment
Creating
Installer
Installing
Application
Database Programming T-SOL with Microsoft SOL Server 2005
Introduction
to Database and SOL Server
Introduction
to SOL Server Database
Types
of Database
Connected
Database System
Database
Components
Transaction
Log
Table
Index
Trigger
Constraint
View
Stored
Procedure Rule
Default
User-Defined
Data Types S
OL
Server Data Types
Collation
Maximum
Capacity
Management
Database SOL Server
Microsoft
SOL Server Management Studio
Scripting
Structured
Ouery Language
Data
Definition Language - Database
Database
Overview
Filegroup
Creating
Database
Viewing
Database
Managing
Database
Dropping
Database
Data
Definition Language - Table
Table
Overview
Creating
Table
Viewing
Table
Managing
Table
Dropping
Table
Data
Manipulation Language
Inserting
Data
Retrieving
Data
WHERE
Clause
Wildcard
Characters
Updating
Data
Deleting
Data
Constraint
Constraint
Overview
PRIMARY
KEY Constraint
FOREIGN
KEY Constraint
UNIQUE
Constraint
CHECK
Constraint
DEFAULT
Definition
Allowing
NULL Values
Dropping
Constraint
Joining
Multiple Table
About
Joining Multiple Table CROSS JOIN
INNER
JOIN
OUTER
JOIN
Stored
Procedure
Stored
Procedure Overview
Creating
Stored Procedure
Executing
Stored Procedure
Parameters
Batch
Managing
Stored
Procedure
Dropping
Stored Procedure
View
View
Overview
Creating
View
Managing
View
Dropping
View
Trigger
Trigger
Overview
Creating
Trigger
Managing
Trigger
Dropping
Trigger
ROLLBACK
and COMMIT
Database Administering with Microsoft SOL Server 2005
Introduction
to Database and SOL Server
Introduction
to SOL Server Database
Types
of Database
Connected
Database System
Database
Components
Transaction
Log
Table
Index
Trigger
Constraint
View
Stored
Procedure Rule
Default
User-Defined
Data Types SOL Server Data Types Collation
Maximum
Capacity
Management
Database SOL Server
SOL
Server Configuration Manager
Books
Online
SOL
Server Surface Area Configuration
Microsoft
SOL Server Management
Studio
Scripting
Creating
Database
Altering
Database
Dropping
Database
Data
Transfer
SOL
Server Integration Services
SOL
Server Business
Intelligence
Development Studio
Transferring
Data
Executing
Package
SOL
Server Import and Export Wizard
Backup
and Restore
Backup
and Restore Introduction
Backup
Devices
Backup
Operation
Restore
Operation
Index
Table
Index
Introduction
Types
of Index
Creating
Index
Showing
Information of Index
Changing
Index Name
Dropping
Index
Security
Security
Philosophy
Login
User
Securable
Principal
Permissions
Schema
Credential
Certificate
& Asymmetric Keys
Synonym
Database Programming with Microsoft VB .NET 2005
Introduction
to Database Programming
Database
Programming
Data
Access
Database
API
Connection
.NET
Framework
Data
Providers
DataSet
DataReader
or DataSet ?
Data
Adapter
About
Data Adapter & DataSet
Type
of Data Adapter DataGridView
Retrieving
Data
Updating
Data
DataSet
& DataGridView
DataSet
DataGridView
Command
& DataReader
Command
DataReader
Using
Command and DataReader Method
Report
Crystal
Report
Reporting
in .NET
Object Oriented Analisis and Design with UML
Information
System Development
System
Development Life Cycle
Systems
analysis and design definition Definition of system, information system The users of information system Modeling
The
role to play in the development and use of information systems
Object
Oriented Systems Development
Systems
analyst definition, the key players in the development and implementation of
information systems
Career
prospects for systems analyst
Analysis
Tools
Data
Flow Diagram
Unified
Modeling Language
Use
Case Diagram
Case
Study-1
System
Concepts for Object Modeling
Object,
Attribute, Methods, Encapsulation
Classes,
Generalization, Specialization
Object/Class
Relationships
Messages
Polymorphism
Modeling
the Functional Description of the System (Use Case Diag) The
Use Case Diagrams
Events
Actors
Additional
UML Analysis Diagrams
Object
Diagrams
Class
Diagrams State(-chart) Diagrams
Sequence
Diagrams
Collaboration
Diagrams
Finding
and Identifying the Business Objects
Find
the potential objects
Select
the Proposed Objects
Organizing
the Objects
Identifying
Their Associations Modeling the Behavior of the Objects
Object
Oriented Design and Modeling
Design
Object
Object
Responsibility Refining the Use Case Model
Modeling
Object Interactions & Behavior
Additional
UML Design and Implementation Diagrams
Activity
Diagram
Component
Diagram
Deployment
Diagram
Program
Design Case Study
Output
Layout
Input
Data Model
Process
Specifications
Process
Diagramming Programming
Structured
English
Implementation Project
Jl. Raden Saleh Raya No.18 D-G
Jakarta Pusat 10330
Telp : 021-3929888
Fax : 021-3900187
Email : raden_saleh@kursuskomputerku.com