Katılımcı Ön Koşulları:

• Temel Veritabanı Bilgisi
• SQL Bilgisi

Neler Öğreneceksiniz?

• Introduction to Data Warehousing
• Creating an ETL Solution with SSIS
• Introduction to Business Intelligence and Analysis Services
• Implementing,Enhancing and Managing Reports with SQL Server Reporting Services
• SQL Server Database Certification Path

The post SQL SERVER 2019 İLE UÇTAN UCA İŞ ZEKASI UYGULAMALARI WORSKHOP first appeared on veriboxcademy.

Katılımcı Ön Koşulları:

• Temel Veritabanı Bilgisi
• SQL Bilgisi

Neler Öğreneceksiniz?

• Introduction to Data Warehousing
• Planning Data Warehouse Infrastructure
• Designing and Implementing a Data Warehouse
• Creating an ETL Solution with SSIS
• Implementing Control Flow in an SSIS Package
• Debugging and Troubleshooting SSIS Packages
• Implementing a Data Extraction Solution
• Loading Data into a Data Warehouse
• Enforcing Data Quality
• Master Data Services
• Extending SQL Server Integration Services
• Deploying and Configuring SSIS Packages
• Consuming Data in a Data Warehouse

The post SQL SERVER 2019 İLE VERİ AMBARI GELİŞTİRME VE ETL UYGULAMALARI (SSIS) first appeared on veriboxcademy.

Katılımcı Ön Koşulları:

• RH124 Red Hat System Administration I eğitimini tamamlamış olmak

Neler Öğreneceksiniz?

• Install Red Hat Enterprise Linux using scalable methods
• Access security files, file systems, and networks
• Execute shell scripting and automation techniques
• Manage storage devices, logical volumes, and file systems
• Manage security and system access
• Control the boot process and system services
• Run containers

The post RH124 RED HAT SYSTEM ADMINISTRATION II EĞİTİMİ first appeared on veriboxcademy.

Katılımcı Ön Koşulları:

• Temel Veritabanı Bilgisi
• Oracle Veritabanı Bilgisi
• SQL Bilgisi
• Temel Programlama Bilgisi
• Oracle SQL Developer veya Toad Gibi Araçları Kullanma Bilgisi
• Oracle Veritabanı Yüklü ve Çalışır Durumda Olmalı

 Neler öğreneceksiniz?

• Introduction to PL/SQL
• Declaring PL/SQL Variables
• Writing Executable Statements
• Using SQL Statements Within a PL/SQL Block
• Writing Control Structures
• Working with Composite Data Types
• Using Explicit Cursors
• Handling Exceptions
• Introducing Stored Procedures and Functions
• Creating Procedures
• Creating Functions
• Debugging Subprograms
• Creating Packages
• Working with Packages
• Using Oracle-Supplied Packages in Application Development
• Using Dynamic SQL
• Creating Triggers
• Creating Compound, DDL, and Event Database Triggers
• Design Considerations for the PL/SQL Code
• Tuning the PL/SQL Compiler
• Managing Dependencies

The post PL/SQL İLE VERİ TABANI PROGRAMLAMA WORKSHOP first appeared on veriboxcademy.

Katılımcı Ön Koşulları:

• Temel Veritabanı Bilgisi
• SQL Bilgisi

Neler Öğreneceksiniz?

• Introduction to Business Intelligence and Data Modeling
• Creating Multidimensional Databases
• Working with Cubes and Dimensions
• Working with Measures and Measure Groups
• Introduction to MDX
• Enhancing a Cube
• Implementing an Analysis Services TabularData Model
• Introduction to DAX
• Implementing Reports with SQL Server Reporting Services
• Enhancing Reports with SQL Server Reporting Services
• Managing Report Execution and Delivery

The post SQL SERVER 2019 İLE OLAP MODELLEME VE RAPORLAMA (SSAS, SSRS) WORKSHOP first appeared on veriboxcademy.

 Katılımcı Ön Koşulları:

• Temel Veritabanı Bilgisi
• SQL Bilgisi

Neler Öğreneceksiniz?

• Sql server 2019 high availability overview
• Sql server 2019 high availability features overview
• Windows server 2019 failover clustering
• Sql server 2019 failover clustering instance
• Sql server 2019 availability groups

The post SQL SERVER 2019 İLE ALWAYSON YÜKSEK KULLANILABİLİRLİK WORKSHOP first appeared on veriboxcademy.

Katılımcı Ön Koşulları:

• Temel Veritabanı Bilgisi
• SQL Bilgisi

 Neler Öğreneceksiniz?

• SQL Query Performance Tuning Path
• SQL Query Performance Analysis
• SQL Server Storage Fundamentals
• Index Analysis
• Execution Plan Details
• Statistics Analysis
• Fragmentation Analysis
• Query Design Analysis
• Transaction Log and Tempdb Optimization
• SQL Server Advanced Features
• Blocking Analysis
• SQL Server Optimization Checklist

The post SQL SERVER 2019 İLE PERFORMANS TUNING WORKSHOP first appeared on veriboxcademy.

Katılımcı Ön Koşulları:

• Temel Veritabanı Bilgisi
• SQL Bilgisi

Neler Öğreneceksiniz?

• Introduction to SQL Server 2019 Database Administration
• Working with Databases and Storage
• Planning and Implementing a Backup Strategy
• Restoring SQL Server 2019 Databases
• Importing and Exporting Data
• Managing SQL Server Security
• Protecting Data by Using Encryption and Auditing
• Monitoring SQL Server 2019
• Tracing Access to SQL Server 2019
• Automating SQL Server 2019
  Management
• Advanced Monitoring SQL Server 2019
• Performing Ongoing Database
  Maintenance
• Troubleshooting Common SQL Server 2019 Administrative Issues
• SQL Server High Availability and Disaster Recovery

The post SQL SERVER 2019 İLE TEMEL VERİTABANI YÖNETİMİ WORKSHOP first appeared on veriboxcademy.

Katılımcı Ön Koşulları:

• Temel Veritabanı Bilgisi
• SQL Bilgisi

Neler Öğreneceksiniz?

• Introduction to Database Development
• Designing and Implementing Tables
• Ensuring Data Integrity through Constraints
• Introduction to Indexing
• Advanced Indexing
• Columnstore Indexes
• Designing and Implementing Views
• Designing and Implementing Stored Procedures
• Designing and Implementing User Defined Functions
• Responding to Data Manipulation via Triggers
• Using In-Memory Tables
• Implementing Managed Code in SQL Server
• Storing and Querying XML Data in SQL Server
• Working with SQL Server Spatial Data

The post SQL SERVER VERİTABANI PROGRAMLAMA WORKSHOP first appeared on veriboxcademy.

The post MySQL DB EĞİTİMİ first appeared on veriboxcademy.