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?

• 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.

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

• Temel Veritabanı Bilgisi
• Linux İşletim Sistemi Bilgisi
•  SQL Bilgisi
•  Oracle Veritabanı Temelleri Bilgisi

Neler Öğreneceksiniz?

• Introduction to Oracle Database
• Accessing an oracle database
• Creating an Oracle Database by Using DBCA
• Creating an Oracle Database by Using a SQL Command
• Starting Up and Shutting Down a Database Instance
• Managing Database Instances
• Oracle Net Service: Overview
• Configuring Naming Methods
• Configuring and Administering the Listener
• Configuring a Shared Server Architecture
• Configuring Oracle Connection Manager for Multiplexing and Access Control
• Creating PDBs from Seed
• Using Other Techniques to Create PDBs
• Managing PDBs
• Database Storage Overview
• Creating and Managing Tablespaces
• Improving Space Usage
• Managing Undo Data
• Creating and Managing User Accounts
• Configuring Privilege and Roles Authorization
• Configuring User Resource Limits
• Implementing Oracle Database Auditing
• Introduction Loading and Transporting Data
• Loading Data
• Transporting Data
• Using External Tables to Load and Transport Data
• Automated Maintenance Tasks: Overview
• Automated Maintenance Tasks: Managing Tasks and Windows
• Database Monitoring and Performance Tuning Overview
• Monitoring Database Performance
• Analyzing SQL and Optimizing Access Paths

The post ORACLE 19C (DBA) WORKSOP first appeared on veriboxcademy.

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

• Temel Veritabanı Bilgisi
• SQL Bilgisi

Neler Öğreneceksiniz?

• Using Table Expressions
• Using Window Ranking, Offset, and Aggregate Functions
• Pivoting and Grouping Sets
• Implementing Transactions
• Ensuring Data Integrity through Constraints
• Other Advanced Technics
• SQL Query Performance Tuning Path
• Index Analysis Execution Plan Details
• Statistics Analysis
• Query Design Analysis

The post SQL SERVER İLE İLERİ SORGULAMA TEKNİKLERİ VE PERFORMANS OPTİMİZASYONU WORKSHOP first appeared on veriboxcademy.

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

• Temel Veritabanı Bilgisi
• SQL Bilgisi
• Temel Programlama bilgisi (Opsiyonel)
• Temel Linux bilgisi

Neler Öğreneceksiniz?

• Introduction and Architectural Overview
• System Architecture
• PostgreSQL Installation
• User Tools – Command Line Interfaces
• Database Clusters
• Configuration
• Data Dictionary
• Creating & Managing Databases
• Database Security
• Monitoring and Admin Tools
• SQL Primer
• Backup, Recovery and Point-in Time Recovery
• Routine Maintenance Tasks
• Moving Data
• Replication and High Availability Tools

The post POSTGRE SQL DB first appeared on veriboxcademy.

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

• Temel Veritabanı Bilgisi
• SQL Bilgisi

Neler Öğreneceksiniz?

• Introduction to Microsoft SQL Server
• Introduction to T-SQL Querying
• Writing SELECT Queries
• Querying Multiple Tables
• Sorting and Filtering Data
• Working with SQL Server 2019 Data Types
• Using DML to Modify Data
• Using Built-In Functions
• Grouping and Aggregating Data
• Using Subqueries
• Using Table Expressions
• Using Set Operators
• Using Window Ranking, ffset, aOnd Aggregate Functions
• Executing Stored Procedures
• Improving Query Performance

The post SQL SERVER 2019 İLE TEMEL VERİTABANI SORGULAMA first appeared on veriboxcademy.