SQL Queries – All in 1

Part 1: Basic Selection Queries
Part 2: Aggregate Functions SQL
Part 3: String Functions SQL
Part 4: Conditional Queries
Part 5: Combining Data Queries
Part 6: Window Functions
Part 7: Ranking Functions
Part 8: Data Insertion Queries
Part 9: Data Updation Queries
Part 10: Common Table Expression
Part 11: User Defined Functions
Part 12: Table Functions
Part 13: SQL SubQueries
Part 14: SQL Joins
Part 15: SQL Wildcards
Part 16: SQL Range Operators

Spring Boot Tutorial : Part 1 REST

Annotation Meaning @RestController Defines Class that provides REST APIs endpoints methods @RequestMapping(“/myapp”) Defines endpoint for the overall API Class @GetMapping(“/info”) @GetMapping(“/students/{studentId}”) Defines Method that provides API endpoint implementation (@PathVariable int studentId) Defines Variable containing data in endpoint link

Docker Commands Cheat Sheet

Part 1 Docker Containers Object Type Command Type Command Meaning Container List docker psdocker ps -a List all running containers -a : List all containers – including stopped ones Container Create + Start docker run {image-name}docker run {imageName:tagName}docker run -flag image Create and start a new container based on image IMAGENAME (or use the image […]