- Download and install Golang
- Set up environment variables
GOROOT: path to Golang installation directoryGOPATH: path to workspace directoryPATH: add$GOROOT/binand$GOPATH/bintoPATH
- Check installation:
go version
- Primitive types:
bool,string,int,float32,float64 - Aggregate types:
array,slice,map,struct - Reference types:
pointer,function,interface,slice,map,channel-More
- Declare variables with primitive types
- Declare variables with aggregate types
- Declare variables with reference types
- Declare:
var <name> <type>
int:0float:0.0bool:falsestring:""pointer,function,interface,slice,map,channel:nilstruct: zero value of each fieldarray: zero value of each element- More
- Print zero value of each data type
- Declare:
const <name> <type> = <value> - More
- Arithmetic operators:
+,-,*,/,%,++,-- - Comparison operators:
==,!=,>,<,>=,<= - Logical operators:
&&,||,! - More
- Create a calculator program
ifstatementswitchstatement- More
- Create a program to check if a number is prime or not
- Create a program to check if a year is leap year or not
- Create a program to check if a number is odd or even
- Create a program to check if a number is positive, negative or zero
- Find the maximum number in 3 numbers
forloop- More
- Create a program to print all prime numbers from 1 to 100
- Factorial of a number
- Fibonacci sequence
- Print multiplication table of a number
- Print the Piramids with * help of loops
- Declare:
func <name>(<params>) <return type> {<body>} - More
- Take 2 numbers as input and return the sum
- Caculate the area of a circle with radius,trianle with 3 sides, rectangle with 2 sides
- Take a number as input and return the factorial of that number
- Declare:
var <name> [<size>] <type> - More
- Create a program to find the maximum number in an array
- Use Built-in functions of slice and array
- Declare:
type <name> struct {<fields>} - More
- Declare:
var <name> map[<key type>]<value type> - More
- Declare:
var <name> *<type> - More
- Declare:
type <name> interface {<methods>} - More
- Declare:
<value>.(<type>) - More
- Declare:
errors.New(<message>) - More
- Download and install PostgreSQL
- RDBMS benefits and limitations
- What are the differences between SQL and NoSQL?
- Postgres and other RDBMS
- Data types
- Rows, columns and tables
- Schema
- Read more about schema
-
Data definition language (DDL)
-
Data manipulation language (DML)
-
Data control language (DCL)
-
Transaction control language (TCL)
-
Data Query Language (DQL)
-
Read more about concepts
-
Inner join
-
Left join
-
Right join
-
Full join
-
Union
-
Union all
-
Read more about join
-
What is indexing?
-
Types of indexing
-
When to use indexing?
-
When not to use indexing?
-
Read more about indexing
-
Atomicity
-
Consistency
-
Isolation
-
Durability
-
Read more about ACID
-
What are functions?
-
What are triggers?
-
When to use functions and triggers?
-
Read more about functions and triggers
-
What are migrations?
-
Why do we need migrations?
-
How to use migrations?
-
Read more about migrations