Category Archives: Programming

SQL LENGTH Function Tutorial

SQL LENGTH FUNCTION

This is a detailed tutorial of the LENGTH Function in SQL. Learn to find the number of characters of the column values using the LENGTH function. SQL LENGTH Function The LENGTH Function in SQL is used to find out the number of characters of a given string. This way, you can easily find out the […]

SQL Query To Find Duplicate Records

SQL Query To Find Duplicate Records

This is a detailed tutorial of querying duplicate records in a database table. Learn the SQL Query to find out completely or partially duplicate rows. Duplicate Table Records There might be cases when you require to find out the duplicate records of a database table. The duplicate records refer to the table rows who are […]

Python Program To Check Prime Number

Program To Check If A Number Is Prime Or Not

This is a detailed tutorial to check if a number is prime or not in Python. Explained with the help of an illustrative example based on simple logic. Prime Numbers These are the numbers that are greater than one and are not divisible by any of the numbers smaller than it. In other words, these […]

Python ord() Function Tutorial

Python Ord() Function

This is a detailed tutorial of the Python ord() Function. Learn to find the integers that represent different Unicode characters using this built-in method. Python ord() Function The Python built-in function ord() is used to find out a unique integer number that represents a Unicode character. In other words, in Python, every Unicode character has […]

Python String startswith() Method

Python String Startswith() Method

This is a detailed tutorial of the Python String startswith() method. Learn to check whether a string starts with a specified prefix (substring) or not. Python String startswith() The Python String method startswith() is used to check whether the string on which it is applied starts with a particular prefix or substring or not. It […]

Python String find() Method

Python String Find() Method

This is a detailed tutorial of the Python String find() method. Learn to find the first occurrence of a substring in a Python String using this method. Python String find() This string method find() is used to find the first occurrence of a substring in the string on which it is applied. It returns the […]

Python String strip() Method Tutorial

Python String Strip() Method

This is a detailed tutorial of the Python String strip() method. Learn to remove the leading and trailing characters from a string as per another string. Python String strip() The Python String strip() method simply removes the leading and trailing characters from a string on which it is applied according to another string which has […]

Python String Join Method Tutorial

Python String Join() Method

This is a detailed tutorial of the Python String Join Method. Learn to convert a Python Iterable Object into a String using some separator or delimiter. Python String join() The join() method can be applied to any of the Python String Objects. It simply converts an Iterable object into the string by using the string […]

Python round() Function Tutorial

Python Round() Function

This is a detailed tutorial of the Python round() Function. Round off numerical values to simple integers or upto a specified number of decimal points. Python round() Function The Python built-in function round() is used to round-off floating-point values (Numerical values with decimals) into either simple integers or floating-point values upto a specified number of […]

Python len() Function

Python Len() Function

This is a detailed tutorial of the Python len() Function. Learn to find out the number of items contained in a Python Object using this built-in method. Python len() Function The built-in function len() is used to find out the number of items or elements contained in a Python Object. For some Pythons, rather than […]