MAINTAINING A MICROSOFT SQL SERVER 2012 R2 DATABASE
MAINTAINING A MICROSOFT SQL SERVER 2012 R2 DATABASE
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
Jadwal Pelatihan Jakarta Training 2026 :
Batch 1 : 05-06 Januari 2026 | 19-20 Januari 2026 || Batch 2 : 02-03 Februari 2026 | 18-19 Februari 2026
Batch 3 : 05 – 06 Maret 2024 | 19 – 20 Maret 2024 || Batch 4 : 03 – 04 April 2024 | 23 – 24 April 2024
atch 5 : 07 – 08 Mei 2024 | 21 – 22 Mei 2024 || Batch 6 : 05 – 06 Juni 2024 | 25 – 26 Juni 2024
Batch 7 : 06-07 Juli 2026 | 20-21 Juli 2026 || Batch 8 : 03-04 Agustus 2026 | 19-20 Agustus 2026
Batch 9 : 07-08 September 2026 | 21-22 September 2026 || Batch 10 : 05-06 Oktober 2026 | 19-20 Oktober 2026
Batch 11 : 02-03 November 2026 | 16-17 November 2026 || Batch 12 : 07-08 Desember 2026 | 14-15 Desember 2026
–
Catatan: Jadwal tersebut dapat disesuaikan dengan kebutuhan calon peserta.Training Afe Budget Migas Jakarta Fixed Running
Biaya dan Lokasi Pelatihan : Pelatihan Estimasi Biaya Proyek Afe Di Jakarta
Training Efe Project Pasti Jalan
- Yogyakarta, Hotel Dafam Malioboro
- Jakarta, Hotel Amaris Tendean
- Bandung, Hotel Golden Flower
- Bali, Hotel Ibis Kuta
Catatan :Biaya diatas belum termasuk akomodasi/penginapan.Training Estimasi Biaya Proyek Afe Jakarta Pasti Running
Investasi Pelatihan Jakarta Training: Pelatihan Efe Project Di Jakarta
- Investasi pelatihan selama tiga hari tersebut menyesuaikan dengan jumlah peserta (on call). *Please feel free to contact us.
- Apabila perusahaan membutuhkan paket in house training, anggaran investasi pelatihan dapat menyesuaikan dengan anggaran perusahaan.
Fasilitas Pelatihan di Jakarta Training: Training Afe Budget Preparation Skills Of Oil & Gas Projects Di Jakarta Murah
-
- Hotel
- Module / Handout
- FREE Flashdisk
- Sertifikat
- FREE Bag or bagpackers (Tas Training)
- Training Kit (Dokumentasi photo, Blocknote, ATK, etc)
- 2xCoffe Break & 1 Lunch, Dinner
- FREE Souvenir Exclusive
- Training room full AC and Multimedia
Technorati Tags: training afe budget preparation skills of oil & gas projects di jakarta,training afe budget migas di jakarta,training estimasi biaya proyek afe di jakarta,training efe project di jakarta,pelatihan afe budget preparation skills of oil & gas projects di jakarta