Learn SQL

Home >> Learn SQL

Learn SQL

The following SQL topics will help you to learn SQL in an easy way. This SQL Tutorial almost covers all the topics required for a basic understanding of SQL.

 Basics

Basics Table Queries
Clauses
Operators
Functions
Keys
Joins
Other Topics
Please leave a comment below if you like this post or found some error, it will help me to improve my content.
By

Comments

Post a Comment

Popular Posts from this Blog

Basic Structure of C++ Program - The Coding Shala

Image
Home >> Learn C++ >> Basic Structure of C++ Program Basic Structure of the C++ Program The basic structure of the C++ program is as follows -  C++ program can be simplified into two parts - first, writing a program in a text editor and save it with the correct extension. c++ program can be save with .cpp, .c, .cp extension . second, compiling your c++ program using a compiler or online IDE to check the output of your program. Let's look the below c++ code that will print ' Hello World ' as output -   1: //This is comment inline comment 2: /* This is also comment mulitine comment 3: C++ program to display "Hello World" 4: end of multiline comment */ 5: #include<iostream> // this include header file for input output functions 6: using namespace std; 7: // main function starts where the execution of program begins 8: int main() 9: { 10: cout<<"Hello World"; // pr
Read more

Richest Customer Wealth LeetCode Solution - The Coding Shala

Home >> LeetCode >> Richest Customer Wealth  In this post, we will learn how to solve LeetCode's Richest Customer Wealth problem and will implement its solution in Java. Richest Customer Wealth Problem You are given an m x n integer grid accounts where accounts[i][j] is the amount of money i​​​​​​​​​​​th​​​​ customer has in the j​​​​​​​​​​​th​​​​ bank. Return the wealth that the richest customer has.  A customer's wealth is the amount of money they have in all their bank accounts. The richest customer is the customer that has the maximum wealth. Example 1: Input: accounts = [[1,2,3],[3,2,1]] Output: 6 Explanation: 1st customer has wealth = 1 + 2 + 3 = 6 2nd customer has wealth = 3 + 2 + 1 = 6 Both customers are considered the richest with a wealth of 6 each, so return 6. Example 2: Input: accounts = [[1,5],[7,3],[3,5]] Output: 10 Example 3: Input: accounts = [[2,8,7],[7,1,3],[1,9,5]] Output: 17 Practice this problem on LeetCode . LeetCode - Richest Customer
Read more

Shell Script to find sum, product and average of given numbers - The Coding Shala

Home >> Scripting >> Sum, product and average Shell Script to find the sum, product, and the average of given numbers Read four integer numbers from the user and find the sum, product, and average of these four numbers? Code:  #! / bin / bash echo "enter four integers" read a b c d sum =$(echo "$a + $b + $c + $d" | bc - l) average=$(echo "$sum / 4" | bc - l) product=$(echo "$a * $b * $c * $d" | bc - l) echo "sum = $sum" echo "Average = $average" echo "Product = $product" Other Posts You May Like Shell script to print sum of the digits of a number Shell Script to print number in descending order Shell script to find out biggest number from three numbers Shell script to find out factorial of a number Shell Script to create a simple calculator Please leave a comment below if you like this post or found some error, it will help me to improve my content.
Read more

Shell Script to Create a Simple Calculator - The Coding Shala

Home >> Scripting >> simple calculator Shell Script to Create a Simple Calculator Write a shell script to create a simple calculator using a switch-case statement? Code:  #! / bin / bash echo "simple calculator" sum = 0 i = "y" echo "enter first number" read n1 echo "enter second number" read n2 while [ $ i = "y" ] do echo "1.Addition" echo "2.Subtraction" echo "3.Multiplication" echo "4.Division" echo "Enter choice" read ch case $ch in 1 ) sum =$(echo " $n1 + $n2" | bc - l) echo "Addition is =" $ sum ;; 2 ) sum =$(echo "$n1 - $n2" | bc - l) echo "Sub is =" $ sum ;; 3 ) sum =$(echo "$n1 * $n2" | bc - l) echo "Mul is =" $ sum ;; 4 ) sum =$(echo "$n1 / $n2" | bc - l) echo "div is =" $ sum ;; * )echo "invalid choice" esac echo "Do y
Read more

First Unique Character in a String Java - The Coding Shala

Home >> Interview Questions >> first unique character in a string First Unique Character in a String In this post, you will learn how to find the first unique character in a given string in Java. Given a string, find the first non-repeating character in it and return its index. If it doesn't exist, return -1. Examples: s = "leetcode" return 0. s = "loveleetcode", return 2. First Unique Character in a String Solution Approach 1: We can use HashMap. We Count every character's frequency and store it as value. Again check with string's char and if the value in the map is one return its index. Java Program:  class Solution { public int firstUniqChar ( String s ) { Map < Character , Integer > map = new HashMap < Character , Integer >(); for ( int i = 0 ; i < s . length (); i ++){ char ch = s . charAt ( i ); i
Read more