Coder Baba
2.42K subscribers
1.01K photos
23 videos
722 files
723 links
Everything about programming for beginners.
1 and only official telegram channel of CODERBABA India.

Content:
.NET Developer,
Programming (ASP. NET, VB. NET, C#, SQL Server),
& Projects
follow me https://linktr.ee/coderbaba
*Programming
*Coding
*Note
Download Telegram
50 PROJECTS IN 50 DAYS - HTML, CSS & JAVASCRIPT 🔥

https://drive.google.com/drive/folders/1GxODsAg9lK9L1YIhvHahx3QYGi2wc1t8
Ultimate Coding Desk Setup 2024: Ideal for Programmers with Multiple Devices Stylish & Budget-Friendly Under ₹4000 🖥
https://youtu.be/n_b-sgpvfFo
1👍1
Database keys :

Database keys are essential for organizing and managing data effectively. In this post, we'll explore ten key concepts that every IT professional should know.

1. 🗝 𝗣𝗿𝗶𝗺𝗮𝗿𝘆 𝗞𝗲𝘆
- A unique identifier for each record in a table.
- Cannot be null.
- Ensures that each row is unique.

2. 🌉 𝗙𝗼𝗿𝗲𝗶𝗴𝗻 𝗞𝗲𝘆
- A field in one table that refers to the Primary Key of another table.
- Establishes relationships between tables.

3. 🧩 𝗖𝗼𝗺𝗽𝗼𝘀𝗶𝘁𝗲 𝗞𝗲𝘆
- A combination of two or more columns that uniquely identifies each record.
- Useful when a single column can't uniquely identify a record.

4. 💪 𝗦𝘂𝗽𝗲𝗿 𝗞𝗲𝘆
- One or more columns that can uniquely identify a record.
- A Primary Key is a type of Super Key.

5. 🏅 𝗖𝗮𝗻𝗱𝗶𝗱𝗮𝘁𝗲 𝗞𝗲𝘆
- A column or set of columns that could be the Primary Key.
- Must be unique.

6. 🔍 𝗨𝗻𝗶𝗾𝘂𝗲 𝗞𝗲𝘆
- Ensures uniqueness for a column or column combination.
- Similar to Primary Key but allows one null value.

7. 🛤 𝗔𝗹𝘁𝗲𝗿𝗻𝗮𝘁𝗲 𝗞𝗲𝘆
- A Candidate Key that isn't the Primary Key.
- Another option for a unique identifier.

8. 🍃 𝗡𝗮𝘁𝘂𝗿𝗮𝗹 𝗞𝗲𝘆
- A key that's a natural part of the data, like an email address.

9. 🎭 𝗦𝘂𝗿𝗿𝗼𝗴𝗮𝘁𝗲 𝗞𝗲𝘆
- An artificial key created when no natural unique identifier exists.

10. 🔑 𝗦𝗲𝗰𝗼𝗻𝗱𝗮𝗿𝘆 𝗞𝗲𝘆
- Used for data retrieval, not identification.
- Helps create non-clustered indexes.
👍4
Cheat Sheet.xlsx
28 KB
🚀📚 DSA Cheat Sheet Alert! 📚🚀

Hey everyone! I've put together an amazing Data Structure and Algorithms (DSA) Cheat Sheet just for you! Whether you're prepping for exams, coding interviews, or simply brushing up on your skills, this cheat sheet has got you covered! 📝💡

What's inside?

Key concepts & definitions
Quick reference guides
Time complexities
Visual aids & examples
Perfect for students, developers, and anyone passionate about coding! 💻

📥 Download your DSA Cheat Sheet now

📌 follow @coder_baba #coderbaba
Hashtags: #DSA #DataStructures #Algorithms #Coding #Programming #CheatSheet #StudyNotes #TechTips #CodingLife #Developer #ComputerScience #Education #TechCommunity #CodeSmart #StudyWithMe #StudentLife #ExamPrep #CodingInterview #TechSavvy #InstaTech
1👍1
1👍1
1👍1
1👍1
SMS_Pro003.zip
8.6 MB
Project Source code
1👍1
DB Interview questions

Position - Associate Developer
Package - 26LPA

1st Round 🔥
1. What are the new features introduced in Java 8.
https://www.baeldung.com/java-8-new-features

2. Sort a student class list based on the student age in descending order.
https://www.educative.io/answers/how-to-sort-a-list-of-user-defined-objects-in-java

3. Write a logic to detect a loop in linked list and remove the loop
https://www.google.com/amp/s/www.geeksforgeeks.org/detect-loop-in-a-linked-list/amp/

4. Design HashMap put method.
https://www.turing.com/kb/implementing-hashmap-in-java

5. How to divide a monolithic application to Microservice
https://martinfowler.com/articles/break-monolith-into-microservices.html

6. Why String is immutable
https://www.google.com/amp/s/www.geeksforgeeks.org/java-string-is-immutable-what-exactly-is-the-meaning/amp/

7. How Redis Works and what are the different caching strategies.
https://codedamn.com/news/backend/advanced-redis-caching-techniques

8. How to add a list in redis cache and how to access the data again
https://redis.io/glossary/lists-in-redis/

9. What are the design pattern spring boots internally use
https://www.baeldung.com/spring-framework-design-patterns

10. How spring Auto configuration features works
https://www.marcobehler.com/guides/spring-boot-autoconfiguration

11. How to enable hibernate caching
https://www.baeldung.com/hibernate-second-level-cache

12. Lazy loading vs Eager Loading
https://www.imperva.com/learn/performance/lazy-loading/

13. Asked me to improve one SQL query
https://developernation.net/blog/12-ways-to-optimize-sql-queries-in-database-management/



2nd Round 🔥
1. Implements a search engine, something like Google. Low Level Coding
https://medium.com/@maxi.gkd/building-a-search-engine-using-a-trie-data-structure-cb79475d8a3d

2. How Pulisher Subscribe modal works
https://www.geeksforgeeks.org/what-is-pub-sub/

3. How to restrict an API call to be called from users who have required roles and permission
https://www.baeldung.com/role-and-privilege-for-spring-security-registration

4. Request Scope in spring boot
https://www.baeldung.com/spring-bean-scopes#:~:text=The%20request%20scope%20creates%20a,for%20a%20particular%20WebSocket%20session.
5. How to exclude a dependency
https://www.baeldung.com/mvn-plugin-dependency-exclusion

6. How to pass JWT token in rest api call
https://www.toptal.com/spring/spring-security-tutorial

7. logic to execute a method after every one hour without using Cron job
https://stackoverflow.com/questions/10748212/how-to-call-function-every-hour-also-how-can-i-loop-this#:~:text=Create%20a%20Timer%20object%20and,timer.

while(1==1) {
//Your code here
try{
Thread.sleep(3600000);
}
catch (Exception e) {}
}

8. Difference between scheduled and cached thread pool
https://www.linkedin.com/pulse/types-thread-pool-executors-aniket-nandan?utm_source=share&utm_medium=member_android&utm_campaign=share_via
___

❤️ Please add more peoples to this telegram channel . follow @coder_baba
👍1
100+ Practice Questions

❍ C/C++
❍ Python
❍ JavaScript
❍ Java
❍ C#
❍ Golang

➊ Simple Numbers

➀ Find a digit at a specific place in a number
➁ Find count of digits in a number
➂ Find the largest digit
➃ Find the 2nd largest digit
➄ Find the kth largest digit
➅ Find the smallest digit
➆ Find the 2nd smallest digit
➇ Find the kth smallest digit
➈ Find generic root (sum of all digits) of a number
➉ Reverse the digits in a number
➀➀ Rotate the digits in a number
➀➁ Is the number a palindrome?
➀➂ Find sum of 'n' numbers
➀➃ Check if a number is perfect square
➀➄ Find a number in an AP sequence
➀➅ Find a number in a GP sequence
➀➆ Find a number in fibonacci sequence
➀➇ Check number divisibility by 2, 3, 5, 9
➀➈ Check if a number is primary or not
20. Given a number, print all primes smaller than it
➁➀ Check if a number is circular prime or not
➁➁ Find all prime factors of a number
➁➂ Find the GCD of 2 numbers
➁➃ Find the LCM of 2 numbers
➁➄ Find the factorial of a number
➁➅ Find the exponentiation of a number

➋ Unit Conversion

➀ Number Base (Binary, Octal, Hexadecimal, Decimal)
➁ Weight (gram, kg, pound)
➂ Height (cm, m, inch, feet)
➃ Temperature (centigrade, fahrenhite)
➄ Distance (km, mile)
➅ Area (m², km², acre)
➆ Volume (ltr, gallon)
➇ Time (sec, min, hour)
➈ Currency

➌ Calculator

➀ Loan EMI Calculator
➁ Fixed Deposit Returns Calculator
➂ Interest Calculator
➃ BMI Calculator
➄ Item Price (considering tax, discount, shipping)
➅ Tip Calculator

➍ Geometry

➀ Find distance between 2 points
➁ Given 2 sides of a right angle triangle, find the 3rd
➂ Find 3rd angle of a triangle when 2 are given
➃ Area of a triangle when 3 sides are given
➄ Area of a right angle triangle
➅ Perimeter of a Square
➆ Area of a Square
➇ Perimeter of a Rectangle
➈ Area of a Rectangle
➉ Circumference of a Circle
➀➀ Area of a Circle
➀➁ Circumference of a Semi-Circle
➀➂ Area of a Semi-Circle
➀➃ Area of a Ring
➀➄ Circumference of an Ellipse
➀➅ Area of an Ellipse
➀➆ Suface Area of a Sphere
➀➇ Volume of a Sphere
➀➈ Surface Area of a Hemisphere
20. Volume of a Hemisphere
➁➀ Surface area of a Cube
➁➁ Volume of a Cube
➁➂ Surface area of a Cylinder
➁➃ Volume of a Cylinder

➎ Vector

➀ Find Scalar Multiplication of a vector
➁ Find addition/subtraction of vectors
➂ Find magnitude of a vector
➃ Find an unit vector along a given vector
➄ Find dot product of 2 vectors
➅ Find cross product of 2 vectors
➆ Check if 2 vectors are orthogonal

➏ Matrix

➀ Find the determinant of a matrix
➁ Find Scalar Multiplication of a matrix
➂ Find addition/subtraction of matrices
➃ Find the transpose of a matrix
➄ Find if 2 matrices are orthogonal
➅ Find inverse of a 2x2 and 3x3 matrix

➐ Set

➀ Find Union of 2 sets
➁ Find Intersection of 2 sets
➂ Find the Difference of 2 sets
➃ Find the Symmetric Difference of 2 sets
➄ Find if a set is subset/superset of another set
➅ Find if 2 sets are disjoints

➑ Special Numbers

➀ Strong Number
➁ Perfect Number
➂ Armstrong Number
➃ Harshad Number
➄ Kaprekar Number
➅ Lychrel Number
➆ Narcissistic Decimal Number
➇ Lucus Number
➈ Catalan Number
➉ Duck Number
➀➀ Ugly Number
➀➁ Abundant Number
➀➂ Deficient Number
➀➃ Automorphic Number
➀➄ Magic Number
➀➅ Friendly Pair Numbers
➀➆ Neon Number
➀➇ Spy Number
➀➈ Happy Number
20. Sunny Number
➁➀ Disarium Number
➁➁ Pronic Number
➁➂ Trimorphic Number
➁➃ Evil Number
➁➄ Amicable Pairs

⬘ If you want to excel in programming, practice a lot.

⬙ Problems based on numbers are easy to start with and they help in improving your analytical skills.

follow @coder_baba
👍31
Top 50 Linux Commands You Must Know as a Regular User...

1. ls - view contents of directory (list)
2. pwd - path of the current directory
3. cd - change directoryn
4. mkdir - make new directory
5. mv - move files / rename files
6. cp - copy files
7. rm - remove files
8. touch - create blank new file
9. rmdir - delete directory
10. cat - list content of file to terminal
11. clear - clear terminal window
12. echo - move data into a file
13. less - Read text file one screen at a time
14. man - show manual of Linux commands
15. sudo - enables you to perform tasks that require administrative or root permissions
16. top - task manager in terminal
17. tar - used to archive multiple files into a tarball
18. grep - used to searching words in specific files
19. head - view first lines of any text file
20. tail - view last lines of any text file
21. diff - compares the contents of two files line by line
22. kill - used for killing unresponsive program
23. jobs - display all current jobs along with their statuses
24. sort - is a command line utility for sorting lines of text files
25. df - info about system disk
26. du - check how much space a file or directory takes
27. zip - to compress your files into a zip archive
28. unzip - to extract the zipped files from a zip archive
29. ssh - a secure encrypted connection between two hosts over and insecure network
30. cal - shows calendar
31. apt - command line tool for interaction with packaging system
32. alias - custom shortcuts used to represent a command
33. w - current user info
34. whereis - used to locate the binary, source, manual page files
35. whatis - used to get one-line man page description
36. useradd - used to create a new user
37. passwd - used to changing password of current user
38. whoami - print current user
39. uptime - print current time when machine starts
40. free - print free disk space info
41. history - print used commands history
42. uname - print detailed information about your Linux system
43. ping - to check connectivity status to a server
44. chmod - to change permissions of files and directories
45. chown - to change ownership of files and directories
46. find - using find searches for files and directories
47. locate - used to locate a file, just like the search command in Windows
48. ifconfig - print ip address stuff
49. ip a - similar to ifconfig but shortest print
50. finger - gives you a short dump of info about a user

Follow @coder_baba
#coderbaba #linux #cmd
1👍1