Preparation guide to learn SQL ππ
π Start from the scratch: Learn about the structure of databases and the basic syntax of SQL, including data types, tables, and operations like SELECT, FROM, WHERE, etc.
π Get hands-on experience: Try writing simple SQL queries on your own and practice working with real data. You can find sample databases from websites like https://mode.com/sql-tutorial/introduction-to-sql
π Study relational databases: SQL is most commonly used to work with relational databases, so learn about the theory and principles of relational databases, such as primary keys, foreign keys, normalization, etc.
π FREE LEARNING RESOURCES
You can learn about SQL for free in interesting way from here https://t.me/bca_programmer/129
π Practice, practice, practice: The more you practice, the better you will become at using SQL. Try to work on projects that interest you and challenge yourself to solve more complex problems.
π Try different database management systems: There are many different database management systems that use SQL, such as MySQL, Oracle, Microsoft SQL Server, etc. Try working with a few different systems to get a feel for the similarities and differences between them.
π Learn SQL commands: Familiarize yourself with the different SQL commands and how they are used, including SELECT, INSERT, UPDATE, DELETE, etc.
π Use SQL in real-world projects: Try to find ways to use SQL in real-world projects, such as building a database for a small business or analyzing data for a research project.
π Collaborate with others: Find a study group or collaborate with others who are also learning SQL. Working together on projects and discussing your learning experiences can help you stay motivated and deepen your understanding of the language.
@bca_programmer
π Start from the scratch: Learn about the structure of databases and the basic syntax of SQL, including data types, tables, and operations like SELECT, FROM, WHERE, etc.
π Get hands-on experience: Try writing simple SQL queries on your own and practice working with real data. You can find sample databases from websites like https://mode.com/sql-tutorial/introduction-to-sql
π Study relational databases: SQL is most commonly used to work with relational databases, so learn about the theory and principles of relational databases, such as primary keys, foreign keys, normalization, etc.
π FREE LEARNING RESOURCES
You can learn about SQL for free in interesting way from here https://t.me/bca_programmer/129
π Practice, practice, practice: The more you practice, the better you will become at using SQL. Try to work on projects that interest you and challenge yourself to solve more complex problems.
π Try different database management systems: There are many different database management systems that use SQL, such as MySQL, Oracle, Microsoft SQL Server, etc. Try working with a few different systems to get a feel for the similarities and differences between them.
π Learn SQL commands: Familiarize yourself with the different SQL commands and how they are used, including SELECT, INSERT, UPDATE, DELETE, etc.
π Use SQL in real-world projects: Try to find ways to use SQL in real-world projects, such as building a database for a small business or analyzing data for a research project.
π Collaborate with others: Find a study group or collaborate with others who are also learning SQL. Working together on projects and discussing your learning experiences can help you stay motivated and deepen your understanding of the language.
@bca_programmer
C program using #structure
#include <stdio.h>
#include <string.h>
struct student{
int roll_no;
char name[200];
float marks;
};
int main(){
struct student s1;
s1.roll_no = 23452231;
strcpy(s1.name, "Priyanshi");
s1.marks = 135;
printf("roll no = %d\n", s1.roll_no);
printf("student name = %s\n", s1.name);
printf("marks = %f\n", s1.marks);
return 0;
}
@bca_programmer
#include <stdio.h>
#include <string.h>
struct student{
int roll_no;
char name[200];
float marks;
};
int main(){
struct student s1;
s1.roll_no = 23452231;
strcpy(s1.name, "Priyanshi");
s1.marks = 135;
printf("roll no = %d\n", s1.roll_no);
printf("student name = %s\n", s1.name);
printf("marks = %f\n", s1.marks);
return 0;
}
@bca_programmer
π6π₯°1π1
# PASSWORD GENERATOR IN PYTHON
# @bca_programmer
import random
import string
LETTERS = string.ascii_letters
NUMS '0123456789'
SPE='+*%&$!_!
SYMBOLS LETTERS + NUMS + SPE
len = int(input("ENTER PASS. LENGTH:"))
password = ".join(random.sample(
SYMBOLS, len))
print(password)# @bca_programmer
β€1
β LEARN FOR FREE.
β¨ CSS
βͺ web.dev
β¨ JS
βͺ javascript.info
β¨ Git
βͺ learngitbranching.js.org
β¨ API
βͺ rapidapi.com
β¨ DS/Algo
βͺ Visualgo.net
β¨ SQL
βͺ SQLbolt.com
@bca_programmer
β¨ CSS
βͺ web.dev
β¨ JS
βͺ javascript.info
β¨ Git
βͺ learngitbranching.js.org
β¨ API
βͺ rapidapi.com
β¨ DS/Algo
βͺ Visualgo.net
β¨ SQL
βͺ SQLbolt.com
@bca_programmer
Rock, Paper, Scissors with Hand using JS and TensorFlow
Code - https://medium.com/geekculture/rock-paper-scissors-with-hand-gesture-recognition-841297a7d915
@bca_programmer
Code - https://medium.com/geekculture/rock-paper-scissors-with-hand-gesture-recognition-841297a7d915
@bca_programmer
Calender in Python
import calendar
yy = 2012 # year
mm = 12 # month
# display the calendar
print(calendar.month(yy , mm))
@bca_programmer
import calendar
yy = 2012 # year
mm = 12 # month
# display the calendar
print(calendar.month(yy , mm))
@bca_programmer
π2π2
Random OTP generator in python
import random
a = random.randint(1,9)
b = random.randint(1,9)
c = random.randint(1,9)
d = random.randint(1,9)
print(a,b,c,d)
@bca_programmer
import random
a = random.randint(1,9)
b = random.randint(1,9)
c = random.randint(1,9)
d = random.randint(1,9)
print(a,b,c,d)
@bca_programmer
π3π₯2π1
Programming vs Scripting
Programming language defines a specific set of instructions that can be used to produce various kinds of output. The programmer provides a set of instruction for a computer to achieve a certain goal. Certain algorithms can also be implemented by writing programmes.
A scripting language is a programming language that does not require an explicit compilation step and support scripts. Scripting languages are often interpreted rather than compiled. Software applications, web pages within a web browser, usage of a shell of an operating system can be automated through Scripting languages.
Key Differences Between Programming vs Scripting:
1. Code with Programming language takes longer to develop as more code needs to be written whereas with Scripting, it takes less time to code as it needs less coding.
2. Programming languages do not require a host; they are executable whereas Scripting languages need a host.
3. Programming languages are complex and tedious to learn whereas Scripting languages are easier to learn, write and master as compare to Programming languages.
4. Programming languages are generally compiled and create an executable file whereas Scripting languages are interpreted and do not create an executable file.
by @stranger_0_0
Do not share without credit β οΈ
@bca_programmer
Programming language defines a specific set of instructions that can be used to produce various kinds of output. The programmer provides a set of instruction for a computer to achieve a certain goal. Certain algorithms can also be implemented by writing programmes.
A scripting language is a programming language that does not require an explicit compilation step and support scripts. Scripting languages are often interpreted rather than compiled. Software applications, web pages within a web browser, usage of a shell of an operating system can be automated through Scripting languages.
Key Differences Between Programming vs Scripting:
1. Code with Programming language takes longer to develop as more code needs to be written whereas with Scripting, it takes less time to code as it needs less coding.
2. Programming languages do not require a host; they are executable whereas Scripting languages need a host.
3. Programming languages are complex and tedious to learn whereas Scripting languages are easier to learn, write and master as compare to Programming languages.
4. Programming languages are generally compiled and create an executable file whereas Scripting languages are interpreted and do not create an executable file.
by @stranger_0_0
Do not share without credit β οΈ
@bca_programmer
Alt_Balaji_Premum_Account_Checker_By_@hardyisop.py
3.8 KB
Alt Balaji Python Checker (Updated)
What's New :-
(+) Fixed issues which mobile users were facing, now can be runned in mobile or any device which supports python.
Requirements :-
Must download requests library
Command => pip install requests
This checker can be used in android phone using termux without rdp, you can also use in pc or any device you want.
If you hit any account send me the screenshot at below mentioned accounts
If you face any error in this checker message at @hardyisop or @hardy1_bot
#first_in_telegeam
#leechers_stay_away
#only_for_educational_purposes
#hardyisop
@bca_programmer
What's New :-
(+) Fixed issues which mobile users were facing, now can be runned in mobile or any device which supports python.
Requirements :-
Must download requests library
Command => pip install requests
This checker can be used in android phone using termux without rdp, you can also use in pc or any device you want.
If you hit any account send me the screenshot at below mentioned accounts
If you face any error in this checker message at @hardyisop or @hardy1_bot
#first_in_telegeam
#leechers_stay_away
#only_for_educational_purposes
#hardyisop
@bca_programmer
π1
HTML Tutorial Part - 2 Creating our first webpage | Basic html structure
By @hardyisop
https://youtu.be/T7Sbi6ohpvA
@bca_programmer
By @hardyisop
https://youtu.be/T7Sbi6ohpvA
@bca_programmer
π€ 20 ChatGPT Alternatives You Can Try
- You can use ChatGPT alternatives, they too are GPTs
1. https://chat.tgbot.co
2. https://chat.theb.ai
3. https://freechatgpt.chat
4. https://fastgpt.app
5. https://freegpt.cc
6. https://freegpt.one
7. https://chatgpt.ddiu.me
8. https://chat.ninvfeng.xyz
9. https://www.aitoolgpt.com
10 https://www.chatsverse.xyz
11. https://chatforai.com
12. https://desk.im
13. https://ai.ls
14. https://ai.ci
15. https://talk.xiu.ee
16. https://www.scyu.app
17. https://www.chat2ai.cn
18. https://aigcfun.com
19. https://chat.forchange.cn
20. https://94gpt.com
Share And Support Us β₯οΈ
@bca_programmer
- You can use ChatGPT alternatives, they too are GPTs
1. https://chat.tgbot.co
2. https://chat.theb.ai
3. https://freechatgpt.chat
4. https://fastgpt.app
5. https://freegpt.cc
6. https://freegpt.one
7. https://chatgpt.ddiu.me
8. https://chat.ninvfeng.xyz
9. https://www.aitoolgpt.com
10 https://www.chatsverse.xyz
11. https://chatforai.com
12. https://desk.im
13. https://ai.ls
14. https://ai.ci
15. https://talk.xiu.ee
16. https://www.scyu.app
17. https://www.chat2ai.cn
18. https://aigcfun.com
19. https://chat.forchange.cn
20. https://94gpt.com
Share And Support Us β₯οΈ
@bca_programmer
π1
π1