Advertising on the Telegram channel «Programming, data science, machine learning»

Interesting site with collection of all kind of programming related cheat sheets in one place: https://overapi.com/

One of our subscribers wrote a comment asking for automation testing courses so here you go: 🎯 Ultimate Guide to Automation Testing — For Students & Beginners 🚀 *(All resources 100% FREE & No Signups Required!)* 👨‍💻 Thinking of diving into Automation Testing? Want to boost your QA skills and land a tech job fast? This guide has EVERYTHING you need: tools, tips, free courses, and materials. --- 🔥 What is Automation Testing? Automation testing uses software tools to run tests on your code automatically — saving time, improving accuracy, and scaling your testing process. You’ll commonly work with: ✅ Selenium ✅ Playwright ✅ Cypress ✅ JUnit/TestNG ✅ Postman (API Testing) ✅ Jenkins (CI/CD) ✅ Git & GitHub ✅ Python / Java / JS / C# --- 🧠 Top FREE Courses (No Login Needed): 🎓 Selenium + Java Full Course: YouTube (by Mukesh Otwani) 🔗 https://www.youtube.com/watch?v=FRn5J31eAMw 🎓 Playwright JS Testing (2024): YouTube (by Naveen AutomationLabs) 🔗 https://www.youtube.com/watch?v=jkGAw3m6mAg 🎓 Postman for API Automation Testing: YouTube (by Automation Step by Step) 🔗 https://www.youtube.com/watch?v=t5n07Ybz7yI 🎓 Cypress Crash Course (JavaScript): YouTube (by LambdaTest) 🔗 https://www.youtube.com/watch?v=I8N7I0C7D2g 🎓 Jenkins CI/CD for Beginners: YouTube (TechWorld with Nana) 🔗 https://www.youtube.com/watch?v=FxkSgkFv2TI --- 📚 Free Materials & Docs: 📘 Selenium Documentation: 🔗 https://www.selenium.dev/documentation/ 📘 Cypress Docs (Modern Web Testing): 🔗 https://docs.cypress.io/ 📘 Playwright Docs (Fast-growing alternative to Selenium): 🔗 https://playwright.dev/docs/intro 📘 Postman Learning Center: 🔗 https://learning.postman.com/ 📘 GitHub Learning Lab: 🔗 https://lab.github.com/ --- 💡 Top Tips & Tricks for Learners: 🧩 Start with Selenium + Java or Python – they’re industry standards. 🔁 Learn basic loops, conditionals & OOP in your chosen language. ⚙️ Practice writing test scripts for login/logout flows. 🧪 Use dummy sites like: 🔗 https://the-internet.herokuapp.com/ 🔗 https://demoqa.com/](https://demoqa.com/ 🗂 Use GitHub to track your code from Day 1. 🔧 Start learning CI/CD with Jenkins or GitHub Actions after mastering basics. --- 🎁 Bonus: Awesome Practice Projects ✅ Test a Login/Signup form ✅ Automate filling web forms ✅ Write data-driven tests (read data from CSV/Excel) ✅ Automate UI flows with Playwright or Cypress ✅ Automate REST API tests with Postman --- 💬 Final Words Mastering automation testing doesn’t require a degree or \$\$\$. Be consistent, build projects, contribute to GitHub, and keep learning. These free resources are enough to get you job-ready! 💼 💻 *Start today. Build your first automated test. Make future you proud.* 🌱 #AutomationTesting #Selenium #QA

🎯 Master Big Data & Data Engineering — Ultimate Free Resource Pack 🚀 --- 🔹 🔥 Pro Tips for Aspiring Data Engineers 1. Learn SQL deeply – it's still the foundation of everything 2. Understand data formats: JSON, Parquet, Avro, ORC 3. Master Apache Spark — it's everywhere 4. Learn to use Airflow for orchestrating workflows 5. Practice writing ETL pipelines — build your own mini data warehouse 6. Get comfortable with cloud platforms (start with AWS/GCP free tiers) 7. Version-control your work using Git + DVC for data versioning 8. Learn Docker & Kubernetes basics — modern data infra depends on it 9. Explore real-time processing: Kafka, Flink, and Spark Streaming 10. Follow best practices for data modeling — star/snowflake schemas, SCDs, etc --- 🎓 Top Free Online Courses *(No login required or audit available)* 1. 📘 Big Data Specialization – Coursera 🕒 6 courses | 80+ hours 👨‍🏫 UC San Diego Professors 💡 Hadoop, Spark, Hive, NoSQL, real-world projects *(audit for free)* 2. 📊 Learn to Code for Data Analysis – OpenLearn (The Open University) 🕒 8 weeks 💡 Beginner-friendly programming and data analysis 📜 Certificate of participation (free) 3. 🧰 Data Engineering Zoomcamp – DataTalks.Club 🕒 10+ weeks 🎥 Full video lectures + GitHub labs 💡 Docker, Terraform, GCP, Airflow, Kafka, Spark, DBT 4. 🌀 Hadoop Tutorial for Beginners – Simplilearn (YouTube) 🕒 2.5 hours 👨‍🏫 Industry trainer 💡 Intro to HDFS, MapReduce, and the Hadoop ecosystem 5. 🚀 Google Cloud Data Engineering Quest – Cloud Skills Boost 🕒 ~40 hours 💡 Hands-on with BigQuery, Dataflow, Pub/Sub 🎯 Free credits available for real GCP practice --- 📚 Bonus: Free Book 📘 The Data Engineering Cookbook – Andreas Kretz 💡 Open-source guide by a leading Data Engineering YouTuber

I just got married guys! 😍 This is me and my wife at sunset on our wedding day. After conference in Spain i come back home and had most amazing wedding 💫 Thanks everyone for your patience. I will start posting regularly soon.

Enjoy our content? Advertise on this channel and reach a highly engaged audience! 👉🏻 It's easy with Telega.io. As the leading platform for native ads and integrations on Telegram, it provides user-friendly and efficient tools for quick and automated ad launches. ⚡️ Place your ad here in three simple steps: 1 Sign up 2 Top up the balance in a convenient way 3 Create your advertising post If your ad aligns with our content, we’ll gladly publish it. Start your promotion journey now!

Sorry for not posting for a long time. I am getting ready for my wedding which will happen in 10 days!🤵👰 Also I will be attending Data Science/AI conference in Malaga (Spain) this week: https://jonthebeach.com/ If you are going to be there please come to say hello 😊

How discord stores trillions of messages 🧠 An interesting video about one of the biggest challenges in tech world. This video breaks it down - from the databases they use, to the smart engineering choices that keep everything running smoothly at scale. No fluff, just a super interesting look at how one of the biggest chat platforms actually works behind the scenes. Duration ⏰: 1 hour 8 minutes If you're into system design, scalability, or backend engineering, this one’s a must-watch. Link

🌸🐣 Happy Easter from the World of Code & Data! 🐰💻 May your day be filled with joy, colorful moments, and beautifully structured queries. Wishing you and your loved ones a warm, happy, and meaningful Easter! Your @bigdataspecialist

🚨 Google just dropped a 68-page whitepaper on Prompt Engineering — perfect for API users! It’s packed with advanced tips, techniques, and real examples. Super useful if you're working with LLM APIs or building AI apps! PDF below 👇

SQL/MySQL learning series: Day 4️⃣

Sorry guys I was on a trip for previous few days so there was no new courses during previous week but now its time for: 💥 Day 4 of our SQL series 💥 📘 Lesson 4: Setting Up SQL – Install MySQL/PostgreSQL & Set Up Workbench or DBeaver Before writing your first SQL query, you need a database to work with — and a nice interface to explore it. Here’s a simple guide to setting up your environment: ————————————————— 🔹 Step 1: Choose your database system The most popular free options are: • MySQL – Beginner-friendly and widely used in web development. • PostgreSQL – Open-source, powerful, and great for more complex work. > If you're just starting out: go with MySQL. > If you're curious about more advanced features: try PostgreSQL. ————————————————— 🔹 Step 2: Install the database ✅ For MySQL: • Download: [https://dev.mysql.com/downloads/](https://dev.mysql.com/downloads/) • Install using the MySQL Installer. • Set a root password (don’t forget it!). ✅ For PostgreSQL: • Download: [https://www.postgresql.org/download/](https://www.postgresql.org/download/) • Use the installer for your OS. • Set a password for the "postgres" user during install. ————————————————— 🔹 Step 3: Install a database interface (GUI) Instead of using a terminal, you can write queries in a clean, visual tool: • MySQL Workbench (for MySQL only) →https://www.mysql.com/products/workbench/ • DBeaver (works with MySQL, PostgreSQL & many others) → https://dbeaver.io/ Both are 100% free. ————————————————— 🔹 Step 4: Connect the GUI to your database In the app you installed: • Click New Connection • Choose MySQL or PostgreSQL • Host: localhost • Port: 3306 (MySQL) or 5432 (PostgreSQL) • Username: root (MySQL) or postgres (PostgreSQL) • Password: the one you just created Test the connection – if it says "Success", you’re ready! ✅ ————————————————— 💡 No install? Try online playgrounds If you want to play with SQL right now without setting up anything: • db-fiddle • sqlime ————————————————— Once you’re all set up, let’s move on to writing your first queries!