Deskripsi
Microsoft SQL Server 2012 combines power with scalability, and is at the heart of a huge number of the world’s CRM, ERP, CMS and e-commerce systems, and has solid support for deployment in the Cloud through Microsoft’s Azure platform. If you are interested in custom / on-site SQL Server Programming training for any size of team, please get in touch – we would be glad to help build a course that meets your learning requirements. We can take into account your existing technical skills, project requirements and timeframes, and specific topics of interest to tailor the most relevant and focussed course for you. This can be particularly useful if you need to learn just the new features and SQL Server Programming Best Practices, or need to include extra topics to help with pre-requisite skills.
We can also base custom courses on SQL Server 2012 (and R2) if that is your current production platform. Our SQL Server 2012 Programming training course gives delegates a solid introduction to developing secure, robust commercial database applications incorporating Transact-SQL, Stored Procedures & XML
Tujuan
•Create robust & well-optimised databases in Microsoft SQL Server 2012 R2
•Write SQL queries and Stored Procedures to manipulate data
•Learn SQL Server Management Studio Best PractisesCreating tables and constraints
•Replicating data between multiple databases
•Disaster Recovery strategies
•Overview of Microsoft Business Intelligence with Reporting Services
Materi
1.Introducing Microsoft SQL Server 2012 R2 Database: an overview of SQL Server 2012
•Overview of SQL Server 2012 R2 Database
•SQL Server 2012 Editions and Components
2.Installing SQL Server 2012 R2 Databse
•Installation Options and Requirements
•Installing SQL Server
•Deploying SQL Server in a Private Cloud
3.Lab : Installing SQL Server
•Installing a SQL Server 2012 Named Instance
•Performing Post-Installation Setup and Check
4.Managing SQL Server 2012 R2 Database
•SQL Server Management Studio
•New and Enhanced Dynamic Management Views
•Using PowerShell to Manage SQL Server
5.Developing SQL Server 2012 R2 Databases
•Transact-SQL Enhancements
•New and Enhanced Transact-SQL Functions
•Enhancements to Spatial Data Support
•Storing and Querying Documents
6.Lab : Developing SQL Server Databases
•Using Sequence Objects
•Using the THROW Statement
•Implementing Paging
•Querying Documents
7.Performing Ongoing Database Maintenance
•Ensuring Database Integrity
•Maintaining Indexes
•Automating Routine Database Maintenance
8.Lab : Ongoing Database Maintenance
•Check database integrity using DBCC CHECKDB
•Correct index fragmentation
•Create a database maintenance plan
•Investigate table lock performance
•Ensure database integrity
•Maintain indexes
•Automate routine database maintenance
9.Performance and Tuning Enhancements
10.Lab : Optimizing SQL Server Performance
•Creating a Columnstore Index
•Using a Columnstore Index
•Updating a Table with a Columnstore Index
11.Implementing Security in Microsoft SQL Server 2012
12.Lab : Implementing Security
•Implementing user-Defined Server Roles
•Implementing Contained Databases
13.Overview of BI Enhancements in SQL Server 2012
•SQL Server 2012 for Data Warehousing
•SQL Server 2012 for Business Intelligence
Peserta
This course is aimed at anyone who needs to gain hands-on experience with SQL Server, creating commercial database solutions with T-SQL, XML and Stored Procedures.
Persyaratan
•Each participant is recommended to bring 1 unit of laptop with the reqiured specification minimum dual core processor or higher.
•Delegates will ideally have some experience of writing basic SQL queries in a Relational Database such as Access or MySQL.
Instruktur
Melwin Syafrizal, S.Kom. M. Eng
Agenda & Venue
Batch I : 16 sd 18 Februari 2016 ; Batch II : 19 sd 21 April 2016 ; Batch III : 14 sd 15 Juni 2016 ; Batch IV : 23 sd 25 Agustus 2016 ; Batch V : 25 sd 27 Oktober 2016 ; Batch VI : 20 sd 22 Desember 2016
Venue : Jogja
Fasilitas
•Qualified instructor
•Training Module
•Free High Quality Electronic Books of ITIL FOUNDATION
•Free Consultation
•Certificate
•Stationeries: NoteBook and Ballpoint
•Jacket or waistcoat or T-Shirt
•Bag or backpackers
•Training Photo
•Training room with full AC facilities and multimedia
•lunch and 2 coffeebreak every day of training
•Airport pick up services (Jogja venue)
•Transportation during training (Jogja venue)
Pendaftaran Hub
Wahyu Endah Puspitasari (iin)
Mobile : 0822 2724 4566
BBM :75D8EB91
E-mail: iin@bexcellentjogja.com
