Cumaali Celik – Medium

Cumaali Celik

Pinned

Cumaali Celik

Mastering Substring Method in SQL

Hello SQL learners! Today, I’m excited to introduce you to a fundamental string manipulation function in SQL: the 'SUBSTRING()‘ method…

Jul 25, 2023

Mastering Substring Method in SQL

Jul 25, 2023

Cumaali Celik

SQL User-Defined Functions (UDFs)-2

In the latest article, we have mentioned some UDFs in SQL. Now we will be examining different usages and examples of them.

Mar 24

SQL User-Defined Functions (UDFs)-2

Mar 24

Cumaali Celik

SQL User-Defined Functions (UDFs)-1

User-Defined Functions (UDFs) in SQL Server enable developers to encapsulate custom logic for reuse within SQL queries. Let’s start by…

Feb 18

SQL User-Defined Functions (UDFs)-1

Feb 18

Cumaali Celik

SQL String Functions

Structured Query Language (SQL) offers a rich set of string functions that empower database professionals to manipulate and analyze text…

Dec 17, 2023

SQL String Functions

Dec 17, 2023

Cumaali Celik

Handling with NULL Values in SQL

In SQL, efficiently handling NULL values is a critical aspect of database query construction. This guide delves into the ISNULL() and…

Nov 26, 2023

Handling with NULL Values in SQL

Nov 26, 2023

Cumaali Celik

Exploring SQL Date Functions

Dates and timestamps form the backbone of database management, seamlessly integrating into a multitude of business contexts. SQL, renowned…

Sep 28, 2023

Exploring SQL Date Functions

Sep 28, 2023

Cumaali Celik

🔍 Unraveling Data Patterns with SQL WHERE Clauses: Filtering Insights

In the world of databases, data can be vast and overwhelming. The WHERE clause in SQL helps us filter and extract precisely the…

Aug 21, 2023

🔍 Unraveling Data Patterns with SQL WHERE Clauses: Filtering Insights

Aug 21, 2023

Cumaali Celik

Commen Aggregate Functions in SQL

Aggregate functions in SQL are specially designed functions that perform calculations on a set of values and return a single value. These…

Aug 8, 2023

Commen Aggregate Functions in SQL

Aug 8, 2023

Cumaali Celik

Uniting Data with SQL Joins

The Basics of SQL Joins: SQL joins work by matching data from one table to another based on a common column. For example, if both tables…

Aug 2, 2023

Uniting Data with SQL Joins

Aug 2, 2023

Cumaali Celik

Cumaali Celik

Actively using Postgre SQL Server,Goggle Sheets and Tableau. Experienced in Data Preprocessing, DataManipulation, Data Visualization, Data Analysis and BI

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams