IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Merhaba, bu yazıda çok sık kullanılan kullanıcıdan veri alma işlemine bakacağız. Kullanıcıdan veri alma, verdiğimiz …
Read More »
June 8, 2020
Oracle SQL Tutorials For Beginners – Learn Oracle SQL from scratch with Oracle SQL Online Course
Hi, I will share with you Step by Step Oracle SQL Tutorials For Beginners. 43,239 views l…
May 10, 2020
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )
I will share with you Step by Step Oracle Tutorial | Oracle Database Tutorials for Beginners in this…
April 15, 2020
Performance Tuning and SQL Tuning Tutorial in the Oracle Database
I will share with you Step by Step Performance Tuning and SQL Tuning Tutorial in the Oracle Database…
December 10, 2019
RMAN Tutorial | Backup, Restore and Recovery Tutorials For Beginner Oracle DBA
Hi, I will share with you Step by Step RMAN Backup, Restore and Recovery Tutorials For Beginners in …
July 4, 2019
Dataguard ( Standby ) Monitoring Lag Command and Scripts | Oracle DBA Scripts All in One -2
Hi, I will share all Oracle DBA Scripts related Dataguard in this post. 38,005 views last…
2 days ago
Install multiple MySQL instances on a Linux server -use a separate MySQL configuration file
curl -L -O https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.23-el7-x86_64.tar [root]# rpm -qa…
4 days ago
DATA WAREHOUSE – CHANGE DATA CAPTURE (CDC)
CDC (Change Data Capture) It can be called the process of defining and capturing changes made in the…
5 days ago
[INS-06006] Passwordless SSH connectivity not set up between the following node
I got ” [INS-06006] Passwordless SSH connectivity not set up between the following node ̶…
6 days ago
No active extraction maps on Goldengate Extract or Replicat Stats
I got No active extraction maps on Goldengate while running Extract or Replicat Stats. 2,631&n…
6 days ago
ORA-25153: Temporary Tablespace is Empty
I got ” ORA-25153: Temporary Tablespace is Empty ” error in Oracle database during expo…
Kafka Stream API Json Parse
Kafka Stream API Json Parse Hello, in this article, I will talk about how to process …
Read More »
PySpark Makina Öğrenmesi (PySpark ML Classification Decision Tree)
PySpark Makina Öğrenmesi (PySpark ML Classification Preapering)
PySpark Makine Öğrenmesi
Advanced RDD Actions
Clustering Wikipedia
Clustering Wikipedia Hi, in this article i’ll make a simple clustering example using wikipedia. You …
Read More »
Dimension reduction with PCA | Python Unsupervised Learning -6
Dimension reduction | Python Unsupervised Learning -5
t-SNE visualization | Python Unsupervised Learning -4
Introduction to gensim (Python)
Cannot shrink ‘read only’ database | Shrink Transaction Log While Using AlwaysOn Availability Group
I got ” Cannot shrink ‘read only’ database ” error during Shrink Transaction Log While …
Read More »
Azure SQL Database administration Tips and Hints Exam (DP-300)
JSON in SQL Server
SQL CASE Statement
Software Review – Stellar Repair for MS SQL
How to Clear ILOM FMA Faults And Reset The SP on Exadata or Other Servers
Hi, I will explain How to Clear ILOM FMA Faults And Reset The SP on …
Read More »
How to Shutdown and Startup Exadata and Oracle Databases
Exadata Temp Tablespace Migration To Flash Disk
Oracle 18c RAC Database Upgrade From 12c (12.1.0.2) to 18c (18.7.0.0.0) on Full Rack Exadata -2 Manual 18c Database Upgrade
Oracle 18c RAC Database Upgrade From 12c (12.1.0.2) to 18c (18.7.0.0.0) on Full Rack Exadata -1 29757256 Patch Apply
Android Programming -15 Custom Adapter
Hi guys in this tutorial we will continue the custom adapter. In my previous article, …
Read More »
Android Programming -14 Custom Listview-2
Android Programming -13 Custom Listview
Android Programming -12 ArrayAdapter
Android Programming -11 Listview Component
No active extraction maps on Goldengate Extract or Replicat Stats
I got No active extraction maps on Goldengate while running Extract or Replicat Stats. 2,632 views …
Read More »OGG-00662 ORA-04031: unable to allocate bytes of shared memory
OGG-02191 Incompatible record 101 in | Logdump Usage
OGG-02870 Missing Log File WAITING FOR DICTIONARY REDO
OGG-15122 No viable tables matched specification
How to connect to Oracle from Your Windows Host to a VirtualBox Guest
I am sure that anyone who wants to work on a database or a data …
Read More »Windows İşletim Sistemi ile Oracle Linux Sanal Makinesinin haberleştirilmesi(Virtualbox)
Veri Ambarı Konsepti(OLAP,OLTP)
Tableau Server Architecture
Tableau Server has a high scalable architecture that many users can connect and receive service …
Read More »Tableau Sunucu Mimarisi
DATA WAREHOUSE – CHANGE DATA CAPTURE (CDC)
CDC (Change Data Capture) It can be called the process of defining and capturing changes …
Read More »
DATA WAREHOUSE – ETL/ELT
Introduction of DATA WAREHOUSE-What is DATA WAREHOUSE?
Introduction of DATA WAREHOUSE-What is DATA?
Data Warehouse Architectures
Constraints ( Primary Key, Foreign Key , Unique Key, Not Null and Check ) in Oracle SQL | Oracle SQL Tutorials -30
Hi, I will explain Constraints ( Primary Key, Foreign Key , Unique Key, Not Null …
Read More »Alter Table and Alter Table Add or Drop Column in Oracle SQL | Oracle SQL Tutorials -29
SQL Data Types, LOB Data Types in Oracle SQL | Oracle SQL Tutorials -28
Create Table ( CTAS ) and Data Types, LOB Data Types in Oracle SQL | Oracle SQL Tutorials -27
SQL Subquery, Nested Queries and In Any All Operator in Subquery in Oracle SQL | Oracle SQL Tutorials -26
dbms_output.put_line in PL/SQL
I will explain dbms_output.put_line in PL/SQL in this post. 44,022 views last month, 77 views today
Read More »
Alter Session Set NLS_DATE_FORMAT in Oracle with Examples
PL/SQL Conversion/Decoding/NULL-Related Functions
PL/SQL Datetime Functions
PL/SQL – Number Functions
PostgreSQL – How to Eliminate Repeated Values
It’s possible that in a table, some field that has repeated values is necessary to …
Read More »
Performance Tuning and SQL Tuning Tutorial in the Oracle Database
Bulk Insert and Bulk Update in Oracle Database
What is the Optimizer Hints and How to Use Hints in Oracle | Oracle Database Performance Tuning Tutorial -16
How to Create SQL Plan Baselines Using Enterprise Manager Cloud Control | Oracle Database Performance Tuning Tutorial -15
Usefull Scripts For Couchbase Dba
Why Couchbase? Today’s mission-critical applications demand support for millions of interactions with end-users. Traditional databases …
Read More »
MongoDB Backup and Restore Using MongoDump
How to Access MongoDB Instance 4.2?
How to Install MongoDB on Windows System?
How To Install MongoDB 4.2 on RedHat/ CentOS 7 systems
Recent Posts
January, 2021
- 7 January
ORA-17629: Cannot connect to the remote database server
I got ” ORA-17629: Cannot connect to the remote database server ” error in Oracle database during Standby database ( Dataguard ). 6,218 views last month, 4 views today
Read More » - 7 January
no parent backup or copy of datafile found | RMAN Image Copy Backup
I got ” no parent backup or copy of datafile found ” error in Oracle database during RMAN Image Copy Backup. 4,434 views last month, 4 views today
Read More » - 6 January
Python Kullanıcıdan Veri Alma
Merhaba, bu yazıda çok sık kullanılan kullanıcıdan veri alma işlemine bakacağız. Kullanıcıdan veri alma, verdiğimiz bir değişkenin veya liste, tuple gibi elemanlara direkt atama yapabileceğimiz veya farklı şekilde kullanabilmemize olanak …
Read More » - 6 January
Python __str__ and __repr__ methods
Merhaba, bu yazıda __str__ ve __repr__ method’larına bakacağız. Python programlama dilinde bazı standart gelen önemli methodlar vardır. Örneğin __init__ methodu bir class oluşturduğumuzda hazır olarak ekleyebileceğimiz bir metottur. Bu method …
Read More » - 3 January
Python Flask Connect Database
Merhaba, bu yazıda Python’da mysql bağlantısı nasıl yapılır inceleyeceğiz. Python’da veritabanı bağlantılarını gerçekleştirmek önemlidir, çünkü hangi uygulamayı yaparsak yapalım kuvvetli ihtimal bir veritabanına ihtiyacımız olacaktır. Şimdi uygulama üzerinden kısaca açıklayalım. …
Read More »