Month: November 2020

Swift programming for Beginners – Swift Characters and Strings

Hits: 24 (Swift for Beginners) Swift Characters and Strings In this tutorial, you will learn about characters and strings usage in Swift. You’ll also learn different operations that can be performed on strings and characters. What is a character? A character is a single symbol (letter, number, etc.). Character in swift are of Character type and is …

Swift programming for Beginners – Swift Variables, Constants and Literals

Hits: 22 (Swift for Beginners) Swift Variables, Constants and Literals   In this article, you will learn about variables, constants, literals and their use cases in Swift programming. What is a Variable? In programming, variables are used to store data in memory which can be used throughout the program. Each variable must be given a …

Swift programming for Beginners – Swift “Hello World” Program

Hits: 23 (Swift for Beginners) Swift “Hello World” Program In this article, you will dive into Swift programming by writing a “Hello, World!” program. You’ll learn the basic syntax for a working Swift program. A “Hello, World!” is a computer program that is often used to illustrate the basic syntax of a programming language with …

Python Basics for Beginners – Python | Basic Operators

Hits: 68 Python Basics for Beginners – Python | Basic Operators Operators are the constructs which can manipulate the value of operands. Consider the expression 4 + 5 = 9. Here, 4 and 5 are called operands and + is called operator. Types of Operator Python language supports the following types of operators. Arithmetic Operators …

Python Basics for Beginners – Python | Variable Types

Hits: 30 Python Basics for Beginners – Python | Variable Types Variables are nothing but reserved memory locations to store values. This means that when you create a variable you reserve some space in memory. Based on the data type of a variable, the interpreter allocates memory and decides what can be stored in the …

Python Basics for Beginners – Python | Basic Syntax

Hits: 39  Python Basics for Beginners – Python | Basic Syntax The Python language has many similarities to Perl, C, and Java. However, there are some definite differences between the languages. First Python Program Let us execute programs in different modes of programming. Interactive Mode Programming Type the following text at the Python prompt and …

Python Basics for Beginners – Python | Introduction

Hits: 51  Python Basics for Beginners – Python | Introduction   Python is a high-level, interpreted, interactive and object-oriented scripting language. Python is designed to be highly readable. It uses English keywords frequently where as other languages use punctuation, and it has fewer syntactical constructions than other languages. Python is Interpreted − Python is processed at …

Python Basics for Beginners – Why should I learn Python?

Hits: 28 Python Basics for Beginners – Why should I learn Python? Python is a general-purpose interpreted, interactive, object-oriented, and high-level programming language. It was created by Guido van Rossum during 1985- 1990. Like Perl, Python source code is also available under the GNU General Public License (GPL). This tutorial gives enough understanding on Python programming language.   Why to …

SQL tutorials for Business Analyst – SQL | Date Functions

Hits: 45  SQL tutorials for Business Analyst – SQL | Date Functions   The following table has a list of all the important Date and Time related functions available through SQL. There are various other functions supported by your RDBMS. The given list is based on MySQL RDBMS. Sr.No. Function & Description 1 ADDDATE()Adds dates …

SQL tutorials for Business Analyst – SQL | Wildcard Operators

Hits: 35  SQL tutorialsfor Business Analyst SQL| Wildcard Operators We have already discussed about the SQL LIKE operator, which is used to compare a value to similar values using the wildcard operators. SQL supports two wildcard operators in conjunction with the LIKE operator which are explained in detail in the following table. Sr.No. Wildcard & …

Excel formula for Beginners – How to find Maximum value with if condition

Hits: 27      (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Max value with if condition.   Excel formula for Beginners – How to find Max value with if condition Generic formula {=MAX(IF(range=criteria,values))} Summary To get a maximum value based on …

Excel formula for Beginners – How to find Max value

Hits: 23    (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Max value.   Excel formula for Beginners – How to find Max value Generic formula =MAX(range) Summary To get the maximum value from a set of numbers, use the MAX function. In …

Excel formula for Beginners – How to find Maximum if multiple criteria

Hits: 16    (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Maximum if multiple criteria.   Excel formula for Beginners – How to find Maximum if multiple criteria Generic formula {=MAX(IF(rng1=criteria1,IF(rng2=criteria2,values)))} Summary To get the maximum value in a data set based …

Excel formula for Beginners – How to find Max value with variable column

Hits: 25    (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Max value with variable column.   Excel formula for Beginners – How to find Max value with variable column Generic formula =MAX(INDEX(data,0,MATCH(column,header,0))) Summary To retrieve the max value in a set …