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

SEO , Top Keyword Research 2015

Google's Hummingbird update created a lot of anxiety, but ultimately, it could be a good thing for the industry, because it frees us from the tyranny of competing for a limited number of top keywords. Essentially, the role of the Hummingbird algorithm is to better answer those longer-tail queries users are typing in Google. If your pages are optimized for these more conversational queries, you have a better chance of top rankings. Try a new, niche-based approach to keywords, which allows you to double or even triple the list of profitable keywords in your SEO arsenal. This article explains the four steps for doing keyword research the modern way, using SEO PowerSuite or other tools. 1. Ideas: Most search marketers simply think of the main keywords related to their businesses, plop them into a tool like Google Keyword Planner, and then run with the keyword list it delivers. However, search habits vary widely: Searchers may use hundreds of different word combinations to describe the ...
Post a Comment
Detail Alamat »

TRAINING UNITY 3D GAME ADVANCED : WORKING WITH FIREBASE-BANDUNG

TRAINING UNITY 3D GAME ADVANCED : WORKING WITH FIREBASE By Purnama Academy - Training Center January 08, 2018  No comments UNITY 3D GAME ADVANCED : WORKING WITH FIREBASE www.purnamaacademy.com , Hotline (Call/SMS/WA) :  0838-0838-0001 Syllabus Overview Training yang membahas tingkatan lanjut dari pengembangan game 3D menggunakan UNITY 3D baik skala desktop ataupun mobile, dimana peserta mengetahui cara cara menyimpan informasi data game dari player ke dalam backend dengan bantuan firebase SDK, hal ini memungkinkan untuk pengembangan game skala jaringan (online) Class Type : Training Duration : 2 Days (09.00 – 17.00) Venue / Price : Click Here , Registration : Click Here  (Save up to 20% for Early Bird Registration !) Description : Firebase is Google's mobile platform that helps you quickly develop high-quality apps and grow your business A dependable backend is a must-have for today's games. Giving users the ability to log in and save and retrieve player data can make or...
Post a Comment
Detail Alamat »

Freelance Trainer QGIS Bali Jakarta

Hery Purnama Trainer QGIS Jakarta Bandung 081223344506 QGIS is a free and open-source cross-platform desktop geographic information system application that supports viewing, editing, and analysis of geospatial data Enrich your GIS data and make more effective maps with QGIS. PurnamaAcademy'trainer shows how to get QGIS up and running on your computer and create maps with vector and raster data. Plus, learn how to stylize maps, get more insights from data with overlays and heat maps, and publish results with powerful Python-driven plugins for QGIS. Topics include: ·            Installing QGIS ·            Working with vector and raster data ·            Styling data with layers ·            Labeling data ·            Adding maps and elements ·            Creating new data ·            Using plugins
Post a Comment
Detail Alamat »