Skip to main content

Syllabus SQL Server 2008 Database Design and Implentation (SISINDOTEK Silabus)

Silabus / Syllabus SQL Server 2008

SQL Server 2008 Database Design & Implementation
Durasi : 7 jam x 4 Hari (28 Jam)

Deskripsi : SQL Server 2008 merupakan salah satu produk database kelas server yang dikembangkan oleh Microsoft Co. , Release terbaru yang diluncurkan Microsoft memungkinkan untuk memenuhi kebutuhan database perusahaan besar dengan fitur fitur Business Intelegence dan integrasi yang lebih maksimal. Training ini ditujukkan bagi siapa saja yang ingin menguasai teknologi Microsoft SQL Server 2008. Materi yang dibahas dalam training ini dapat memberikan pengetahuan dan keterampilan untuk merancang, mengoptimalkan, serta memelihara database.
Secara umum, topic yang dibahas dalam training :
* RDBMS Concept
* SQL Server Management Studio (SSMS)
* Transact SQL language
* Data Definition Language
* Relationships and Data Integrity
* Queries, Views, Trigger
* Stored Procedures and User-Defined Functions

Tujuan Training : Peserta dapat memahami konsep dan langkah-langkah perancangan database menggunakan SQL Server, mengenal
cara konfigurasi SQL Server, teknik pemeliharaan database, penggunaan fitur dan tools SQL Server 2008 serta
dapat menggunakan berbagai task untuk pengembangan database menggunakan SQL Server 2008 baik secara sintak T-SQL maupun menggunakan user interface.

Target Peserta : - Database Developer
- Aplication Programmer
- Umum , Mahasiswa

Prasyarat : - Familiar dengan sistem operasi Windows Client dan Server.
- Telah mengetahui kegunaan dan pemanfaatan database secara umum.

Materi Training : • Introduction to Database Concepts
• RDBMS Vs Traditional file
• The Language of Data Modeling
• Conceptual Data Modeling
• The Normalization Process
• Implementing the Base Table Structures
• Protecting the Integrity of Your Data
• Patterns and Query Techniques
• Securing Access to the Data
• Table Structures and Indexing
• T-SQL Essential (DDL, DML , Agregation, Join, Grouping,)
• T-SQL Advance (Subquery,Ranking Function, Pivoting data, Raiserror, Dictinct Value )
• Trigger & Stored Procedures
• VIEW
• Reporting Service (Architecture, Configuration, Ad Hoc)
• Coding for Concurrency
• Index & Data performances
• Considering Data Access Strategies
• Codd’s 12 Rules for an RDBMS
• Scalar Datatype Reference

Training Lanjutan yang Disarankan : SQL Server 2008 DBA fundamental

Informasi dan pendaftaran training hubungi

SISINDOTEK - IT Training & Solution Provider
Jl. Sukasenang VI-6B Bandung - Jawa Barat 40124
Tel. 022-71242266 , SMS. 0812.8733.1966
info , YM. sisindotek
www.sisindotek.com , facebook.com/sisindotek , twitter.com/sisindotek
Labels:

Comments

Post a Comment

Silahkan isi komentar atau iklan baris Anda, Jangan lupa visit social media kami di FB/Twitter/Instagram @alamatclick

Popular posts from this blog

Legenda Crystal Skulls , benarkah adanya ?

Crystal Skulls Most people are familiar with crystal skulls from the film Indiana Jones and the Kingdom of the Crystal Skull. However there are actually many serious crystal skull collectors that claim they are pre-Columbian and were made during the Aztec or Maya civilizations and exhibit paranormal phenomena. In 2008 a team of British and American researchers using electron microscopy and X-ray crystallography examined skulls from the British Museum and Smithsonian. A detailed analysis of the skull’s surface revealed minute rotary scratch marks around the eye sockets, teeth and cranium. This was clear evidence that the skull was cut and polished with a wheeled instrument – and the Aztecs never used the wheel. The researchers concluded that the skulls were cut from a piece of Brazilian rock crystal in Europe. They were then probably sold to collectors as a relic from the ancient Aztec civilization. Many museums now have removed the skulls from display because of their questionable orig...
Post a Comment
Detail Alamat »

WHAT IS COBIT ISACA

What is COBIT? COBIT stands for Control Objectives for Information and Related Technology. It is a framework  created by the ISACA (Information Systems Audit and Control Association). It was designed to be a  supportive tool for managers—and allows bridging the crucial gap between technical issues,  business risks, and control requirements. COBIT is a thoroughly recognized guideline that can be applied to any organization in any  industry. Overall, COBIT ensures quality, control, and reliability of information systems in an  organization, which is also the most important aspect of every modern business. Cybersecurity Expert Master's Program Master the Skills of a Cybersecurity ProfessionalVIEW COURSECybersecurity Expert Master's Program What is ISACA? ISACA stands for Information Systems Audit and Control Association. It develops controls and  guidance for information governance, security, control, and audit professionals. This i...
Post a Comment
Detail Alamat »

Vicky Prasetyo Gerebek Angel Lelga, Ada Pria Lain?

Drama rumah tangga Vicky Prasetyo dan Angel Lelga saat ini kembali memanas. Sebab, Vicky baru saja menggerebek kediaman istrinya, Angel Lelga, di kawasan Ciganjur, Jagakarsa, Jakarta Selatan, Senin (19/11), sekitar pukul 02.00 WIB. Saat digerebek bersama ketua RT setempat, polisi, serta sejumlah warga, salah seorang pria langsung menendang pintu kamar Angel. Setelah pintu bagian tengah dijebol, rupanya terlihat Angel tengah berada satu kamar dengan seorang pria. Menurut kuasa hukum Vicky, Salahudin Pakaya, yang juga ikut menyaksikan penggerebekan tersebut, laki-laki yang diduga bersama Angel, usia lebih muda dari istri Vicky tersebut. "Jadi yah kita semalam bersama suami sah Angel, Vicky menggerebek rumah istrinya itu. Pas sampai disana, ternyata benar istrinya melakukan zina. Bersama seorang pria sedang di dalam kamar," ujar Salahudin, saat dihubungi melalui sambungan telepon, senin (19/11). "Laki-lakinya saya enggak tahu. Tapi dia masih muda. Iyah benar (saat digerebek...
Post a Comment
Detail Alamat »