Data Analytics
27.4K subscribers
1.18K photos
24 videos
33 files
997 links
Dive into the world of Data Analytics – uncover insights, explore trends, and master data-driven decision making.

Admin: @HusseinSheikho || @Hussein_Sheikho
Download Telegram
πŸ“š Learn Advanced Java Programming with Beginners (2024)

1⃣ Join Channel Download:
https://t.iss.one/+MhmkscCzIYQ2MmM8

2⃣ Download Book: https://t.iss.one/c/1854405158/1642

πŸ’¬ Tags: #java

πŸ‘‰ BEST DATA SCIENCE CHANNELS ON TELEGRAM πŸ‘ˆ
πŸ‘4πŸ”₯1
πŸ“š Learn Java Fundamentals (2024)

1⃣ Join Channel Download:
https://t.iss.one/+MhmkscCzIYQ2MmM8

2⃣ Download Book: https://t.iss.one/c/1854405158/1648

πŸ’¬ Tags: #java

πŸ‘‰ BEST DATA SCIENCE CHANNELS ON TELEGRAM πŸ‘ˆ
πŸ‘6
πŸ“š Object-Oriented Programming Exercises with Java 2022

1⃣ Join Channel Download:
https://t.iss.one/+MhmkscCzIYQ2MmM8

2⃣ Download Book: https://t.iss.one/c/1854405158/1677

πŸ’¬ Tags: #java

πŸ‘‰ BEST DATA SCIENCE CHANNELS ON TELEGRAM πŸ‘ˆ
πŸ‘5
πŸ“š Java Programming Exercises (2024)

1⃣ Join Channel Download:
https://t.iss.one/+MhmkscCzIYQ2MmM8

2⃣ Download Book: https://t.iss.one/c/1854405158/1688

πŸ’¬ Tags: #java

πŸ‘‰ BEST DATA SCIENCE CHANNELS ON TELEGRAM πŸ‘ˆ
πŸ‘3
πŸ“š Java Programming Exercises (2024)

1⃣ Join Channel Download:
https://t.iss.one/+MhmkscCzIYQ2MmM8

2⃣ Download Book: https://t.iss.one/c/1854405158/1699

πŸ’¬ Tags: #java

πŸ‘‰ BEST DATA SCIENCE CHANNELS ON TELEGRAM πŸ‘ˆ
πŸ‘4
πŸ“š BIG DATA HADOOP AND JAVA CODING MADE SIMPLE (2024)

1⃣ Join Channel Download:
https://t.iss.one/+MhmkscCzIYQ2MmM8

2⃣ Download Book: https://t.iss.one/c/1854405158/1754

πŸ’¬ Tags: #java #hadoop #bigdata

πŸ‘‰ BEST DATA SCIENCE CHANNELS ON TELEGRAM πŸ‘ˆ
πŸ‘5
πŸ“š Java Cookbook (2024)

1⃣ Join Channel Download:
https://t.iss.one/+MhmkscCzIYQ2MmM8

2⃣ Download Book: https://t.iss.one/c/1854405158/1757

πŸ’¬ Tags: #java

USEFUL CHANNELS FOR YOU
πŸ‘8
πŸ“š Grokking the Java Interview (2024)

1⃣ Join Channel Download:
https://t.iss.one/+MhmkscCzIYQ2MmM8

2⃣ Download Book: https://t.iss.one/c/1854405158/2046

πŸ’¬ Tags: #java

USEFUL CHANNELS FOR YOU
πŸ‘6
# πŸ“š Connecting MySQL Database with Popular Programming Languages

#MySQL #Programming #Database #Python #Java #CSharp #PHP #Kotlin #MATLAB #Julia

MySQL is a powerful relational database management system. Here’s how to connect MySQL with various programming languages.

---

## πŸ”Ή 1. Connecting MySQL with Python
#Python #MySQL
Use the mysql-connector-python or pymysql library.

import mysql.connector

# Establish connection
conn = mysql.connector.connect(
host="localhost",
user="your_username",
password="your_password",
database="your_database"
)

cursor = conn.cursor()
cursor.execute("SELECT * FROM your_table")
result = cursor.fetchall()

for row in result:
print(row)

conn.close()


---

## πŸ”Ή 2. Connecting MySQL with Java
#Java #JDBC
Use JDBC (Java Database Connectivity).

import java.sql.*;

public class MySQLJava {
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/your_database";
String user = "your_username";
String password = "your_password";

try {
Connection conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM your_table");

while (rs.next()) {
System.out.println(rs.getString("column_name"));
}

conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}


---

## πŸ”Ή 3. Connecting MySQL with C# (.NET)
#CSharp #DotNet #MySQL
Use MySql.Data NuGet package.

using MySql.Data.MySqlClient;

string connStr = "server=localhost;user=your_username;database=your_database;password=your_password";
MySqlConnection conn = new MySqlConnection(connStr);

try {
conn.Open();
string query = "SELECT * FROM your_table";
MySqlCommand cmd = new MySqlCommand(query, conn);
MySqlDataReader reader = cmd.ExecuteReader();

while (reader.Read()) {
Console.WriteLine(reader["column_name"]);
}
} catch (Exception ex) {
Console.WriteLine(ex.Message);
} finally {
conn.Close();
}


---

## πŸ”Ή 4. Connecting MySQL with PHP
#PHP #MySQL
Use mysqli or PDO.

<?php
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT * FROM your_table";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo $row["column_name"];
}
} else {
echo "0 results";
}

$conn->close();
?>


---

## πŸ”Ή 5. Connecting MySQL with Kotlin
#Kotlin #JDBC
Use JDBC (similar to Java).

import java.sql.DriverManager

fun main() {
val url = "jdbc:mysql://localhost:3306/your_database"
val user = "your_username"
val password = "your_password"

try {
val conn = DriverManager.getConnection(url, user, password)
val stmt = conn.createStatement()
val rs = stmt.executeQuery("SELECT * FROM your_table")

while (rs.next()) {
println(rs.getString("column_name"))
}

conn.close()
} catch (e: Exception) {
e.printStackTrace()
}
}


---

## πŸ”Ή 6. Connecting MySQL with MATLAB
#MATLAB #Database
Use Database Toolbox.

conn = database('your_database', 'your_username', 'your_password', 'com.mysql.jdbc.Driver', 'jdbc:mysql://localhost:3306/your_database');

data = fetch(conn, 'SELECT * FROM your_table');
disp(data);

close(conn);


---

## πŸ”Ή 7. Connecting MySQL with Julia
#Julia #MySQL
Use MySQL.jl package.

using MySQL

conn = MySQL.connect("localhost", "your_username", "your_password", db="your_database")

result = MySQL.execute(conn, "SELECT * FROM your_table")

for row in result
println(row)
end

MySQL.disconnect(conn)


---
❀5
# πŸ“š Connecting MySQL with Popular Web Frameworks

#MySQL #WebDev #Frameworks #Django #Laravel #Flask #ASPNET #Spring

MySQL is widely used in web development. Here’s how to connect it with top web frameworks.

---

## πŸ”Ή 1. Django (Python) with MySQL
#Django #Python #MySQL
Use mysqlclient or pymysql.

1️⃣ Install the driver:
pip install mysqlclient  # Recommended
# OR
pip install pymysql


2️⃣ Update `settings.py`:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'your_database',
'USER': 'your_username',
'PASSWORD': 'your_password',
'HOST': 'localhost',
'PORT': '3306',
}
}


3️⃣ If using `pymysql`, add this to `__init__.py`:
import pymysql
pymysql.install_as_MySQLdb()


---

## πŸ”Ή 2. Laravel (PHP) with MySQL
#Laravel #PHP #MySQL
Laravel has built-in MySQL support.

1️⃣ Configure `.env`:
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=your_database
DB_USERNAME=your_username
DB_PASSWORD=your_password


2️⃣ Run migrations:
php artisan migrate


---

## πŸ”Ή 3. Flask (Python) with MySQL
#Flask #Python #MySQL
Use flask-mysqldb or SQLAlchemy.

### Option 1: Using `flask-mysqldb`
from flask import Flask
from flask_mysqldb import MySQL

app = Flask(__name__)

app.config['MYSQL_HOST'] = 'localhost'
app.config['MYSQL_USER'] = 'your_username'
app.config['MYSQL_PASSWORD'] = 'your_password'
app.config['MYSQL_DB'] = 'your_database'

mysql = MySQL(app)

@app.route('/')
def index():
cur = mysql.connection.cursor()
cur.execute("SELECT * FROM your_table")
data = cur.fetchall()
return str(data)


### Option 2: Using SQLAlchemy
from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://username:password@localhost/your_database'
db = SQLAlchemy(app)


---

## πŸ”Ή 4. ASP.NET Core with MySQL
#ASPNET #CSharp #MySQL
Use Pomelo.EntityFrameworkCore.MySql.

1️⃣ Install the package:
dotnet add package Pomelo.EntityFrameworkCore.MySql


2️⃣ Configure in `Startup.cs`:
services.AddDbContext<ApplicationDbContext>(options =>
options.UseMySql(
"server=localhost;database=your_database;user=your_username;password=your_password",
ServerVersion.AutoDetect("server=localhost;database=your_database")
)
);


---

## πŸ”Ή 5. Spring Boot (Java) with MySQL
#SpringBoot #Java #MySQL

1️⃣ Add dependency in `pom.xml`:
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.28</version>
</dependency>


2️⃣ Configure `application.properties`:
spring.datasource.url=jdbc:mysql://localhost:3306/your_database
spring.datasource.username=your_username
spring.datasource.password=your_password
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver


3️⃣ JPA Entity Example:
@Entity
@Table(name = "users")
public class User {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;
private String name;
// Getters & Setters
}


---

## πŸ”Ή 6. Express.js (Node.js) with MySQL
#Express #NodeJS #MySQL
Use mysql2 or sequelize.

### Option 1: Using `mysql2`
const mysql = require('mysql2');

const connection = mysql.createConnection({
host: 'localhost',
user: 'your_username',
password: 'your_password',
database: 'your_database'
});

connection.query('SELECT * FROM users', (err, results) => {
console.log(results);
});


### Option 2: Using Sequelize (ORM)
const { Sequelize } = require('sequelize');

const sequelize = new Sequelize('your_database', 'your_username', 'your_password', {
host: 'localhost',
dialect: 'mysql'
});

// Test connection
sequelize.authenticate()
.then(() => console.log('Connected!'))
.catch(err => console.error('Error:', err));


---

### πŸ“Œ Conclusion
MySQL integrates smoothly with all major web frameworks. Choose the right approach based on your stack!

#WebDevelopment #Backend #MySQLIntegration

πŸš€ Happy Coding! πŸš€
Please open Telegram to view this post
VIEW IN TELEGRAM
❀1
# πŸ“š Java Programming Language – Part 1/10: Introduction to Java
#Java #Programming #OOP #Beginner #Coding

Welcome to this comprehensive 10-part Java series! Let’s start with the basics.

---

## πŸ”Ή What is Java?
Java is a high-level, object-oriented, platform-independent programming language. It’s widely used in:
- Web applications (Spring, Jakarta EE)
- Mobile apps (Android)
- Enterprise software
- Big Data (Hadoop)
- Embedded systems

Key Features:
βœ”οΈ Write Once, Run Anywhere (WORA) – Thanks to JVM
βœ”οΈ Strongly Typed – Variables must be declared with a type
βœ”οΈ Automatic Memory Management (Garbage Collection)
βœ”οΈ Multi-threading Support

---

## πŸ”Ή Java vs. Other Languages
| Feature | Java | Python | C++ |
|---------------|--------------|--------------|--------------|
| Typing | Static | Dynamic | Static |
| Speed | Fast (JIT) | Slower | Very Fast |
| Memory | Managed (GC) | Managed | Manual |
| Use Case | Enterprise | Scripting | System/Game |

---

## πŸ”Ή How Java Works?
1. Write code in .java files
2. Compile into bytecode (.class files) using javac
3. JVM (Java Virtual Machine) executes the bytecode

HelloWorld.java β†’ (Compile) β†’ HelloWorld.class β†’ (Run on JVM) β†’ Output


---

## πŸ”Ή Setting Up Java
1️⃣ Install JDK (Java Development Kit)
- Download from [Oracle] :https://www.oracle.com/java/technologies/javase-downloads.html
- Or use OpenJDK (Free alternative)

2️⃣ Verify Installation
java -version
javac -version


3️⃣ Set `JAVA_HOME` (For IDE compatibility)

---

## πŸ”Ή Your First Java Program
public class HelloWorld {
public static void main(String[] args) {
System.out.println("Hello, World!");
}
}


### πŸ“Œ Explanation:
- public class HelloWorld β†’ Class name must match the filename (HelloWorld.java)
- public static void main(String[] args) β†’ Entry point of any Java program
- System.out.println() β†’ Prints output

### ▢️ How to Run?
javac HelloWorld.java  # Compiles to HelloWorld.class
java HelloWorld # Runs the program

Output:
Hello, World!


---

## πŸ”Ή Java Syntax Basics
βœ… Case-Sensitive β†’ myVar β‰  MyVar
βœ… Class Names β†’ PascalCase (MyClass)
βœ… Method/Variable Names β†’ camelCase (myMethod)
βœ… Every statement ends with `;`

---

## πŸ”Ή Variables & Data Types
Java supports primitive and non-primitive types.

### Primitive Types (Stored in Stack Memory)
| Type | Size | Example |
|-----------|---------|----------------|
| int | 4 bytes | int x = 10; |
| double | 8 bytes | double y = 3.14; |
| boolean | 1 bit | boolean flag = true; |
| char | 2 bytes | char c = 'A'; |

### Non-Primitive (Reference Types, Stored in Heap)
- String β†’ String name = "Ali";
- Arrays β†’ int[] nums = {1, 2, 3};
- Classes & Objects

---

### πŸ“Œ What’s Next?
In Part 2, we’ll cover:
➑️ Operators & Control Flow (if-else, loops)
➑️ Methods & Functions

Stay tuned! πŸš€

#LearnJava #JavaBasics #CodingForBeginners
❀4
# πŸ“š Java Programming Language – Part 2/10: Operators & Control Flow
#Java #Programming #OOP #ControlFlow #Coding

Welcome to Part 2 of our Java series! Today we'll explore operators and control flow structures.

---

## πŸ”Ή Java Operators Overview
Java provides various operators for:
- Arithmetic calculations
- Logical decisions
- Variable assignments
- Comparisons

### 1. Arithmetic Operators
int a = 10, b = 3;
System.out.println(a + b); // 13 (Addition)
System.out.println(a - b); // 7 (Subtraction)
System.out.println(a * b); // 30 (Multiplication)
System.out.println(a / b); // 3 (Division - integer)
System.out.println(a % b); // 1 (Modulus)
System.out.println(a++); // 10 (Post-increment)
System.out.println(++a); // 12 (Pre-increment)


### 2. Relational Operators
System.out.println(a == b); // false (Equal to)
System.out.println(a != b); // true (Not equal)
System.out.println(a > b); // true (Greater than)
System.out.println(a < b); // false (Less than)
System.out.println(a >= b); // true (Greater or equal)
System.out.println(a <= b); // false (Less or equal)


### 3. Logical Operators
boolean x = true, y = false;
System.out.println(x && y); // false (AND)
System.out.println(x || y); // true (OR)
System.out.println(!x); // false (NOT)


### 4. Assignment Operators
int c = 5;
c += 3; // Equivalent to c = c + 3
c -= 2; // Equivalent to c = c - 2
c *= 4; // Equivalent to c = c * 4
c /= 2; // Equivalent to c = c / 2


---

## πŸ”Ή Control Flow Statements
Control the execution flow of your program.

### 1. if-else Statements
int age = 18;
if (age >= 18) {
System.out.println("Adult");
} else {
System.out.println("Minor");
}


### 2. Ternary Operator
String result = (age >= 18) ? "Adult" : "Minor";
System.out.println(result);


### 3. switch-case Statement
int day = 3;
switch(day) {
case 1:
System.out.println("Monday");
break;
case 2:
System.out.println("Tuesday");
break;
// ... other cases
default:
System.out.println("Invalid day");
}


### 4. Loops
#### while Loop
int i = 1;
while (i <= 5) {
System.out.println(i);
i++;
}


#### do-while Loop
int j = 1;
do {
System.out.println(j);
j++;
} while (j <= 5);


#### for Loop
for (int k = 1; k <= 5; k++) {
System.out.println(k);
}


#### Enhanced for Loop (for-each)
int[] numbers = {1, 2, 3, 4, 5};
for (int num : numbers) {
System.out.println(num);
}


---

## πŸ”Ή Break and Continue
Control loop execution flow.

// Break example
for (int i = 1; i <= 10; i++) {
if (i == 5) {
break; // Exit loop
}
System.out.println(i);
}

// Continue example
for (int i = 1; i <= 10; i++) {
if (i % 2 == 0) {
continue; // Skip even numbers
}
System.out.println(i);
}


---

## πŸ”Ή Practical Example: Number Guessing Game
import java.util.Scanner;
import java.util.Random;

public class GuessingGame {
public static void main(String[] args) {
Random rand = new Random();
int secretNumber = rand.nextInt(100) + 1;
Scanner scanner = new Scanner(System.in);
int guess;

do {
System.out.print("Guess the number (1-100): ");
guess = scanner.nextInt();

if (guess < secretNumber) {
System.out.println("Too low!");
} else if (guess > secretNumber) {
System.out.println("Too high!");
}
} while (guess != secretNumber);

System.out.println("Congratulations! You guessed it!");
scanner.close();
}
}


---

### πŸ“Œ What's Next?
In Part 3, we'll cover:
➑️ Methods and Functions
➑️ Method Overloading
➑️ Recursion

#JavaProgramming #ControlFlow #LearnToCode πŸš€
Please open Telegram to view this post
VIEW IN TELEGRAM
❀3