SQL Basics

Learn the basics of SQL queries quickly In the digital age, data is the backbone of any business or service. SQL (Structured Query Language) is the key that unlocks the power of data stored in relational databases. Whether you’re a complete beginner, a developer, or simply curious, this guide will walk you through the basic concepts of SQL and how you can start querying databases. Debdatta SarkarDebdatta has more than 13 years in IT induustry and software engineering. Currently 6 years in data science, and machine learning. She holds a Master of Computer Applications degree and Executive Post Graduate Program Degree in Data Science. She is passionate about research, data-driven decisions, and technology’s role in business growth.

Remote Host Identification Has Changed – BLT Sync and SSH Error

Many times when you try to set up your local environment from scratch you might face this issue. This is originally SSH-error which shows “REMOTE HOST IDENTIFICATION HAS CHANGED”. Debdatta SarkarDebdatta has more than 13 years in IT induustry and software engineering. Currently 6 years in data science, and machine learning. She holds a Master of Computer Applications degree and Executive Post Graduate Program Degree in Data Science. She is passionate about research, data-driven decisions, and technology’s role in business growth.

“Enter Passphrase for key ‘/.ssh/id_rsa'” – Stop This Prompt To Appear Repeatedly

Love development but irritated after entering the ssh prompt again and again? Git commands – pull, push, BLT Commands – ‘blt sync:files’, ‘blt sync:db’ all asking the same question? Sometimes you want to fetch a cup of coffee while ‘blt sync:files’ completes but can’t leave because you are not sure when the next prompt for passphrase appears again? Debdatta SarkarDebdatta has more than 13 years in IT induustry and software engineering. Currently 6 years in data science, and machine learning. She holds a Master of Computer Applications degree and Executive Post Graduate Program Degree in Data Science. She is passionate about research, data-driven decisions, and technology’s role in business growth.

Composer in Windows and Symfony

As defined in Composer site – “Composer is a tool for dependency management in PHP. It allows you to declare the libraries your project depends on and it will manage (install/update) them for you.” Composer requires PHP 5.3.2+ to run. Debdatta SarkarDebdatta has more than 13 years in IT induustry and software engineering. Currently 6 years in data science, and machine learning. She holds a Master of Computer Applications degree and Executive Post Graduate Program Degree in Data Science. She is passionate about research, data-driven decisions, and technology’s role in business growth.

Drupal 7 Redirect after First and Later Login

In many cases you may need to take in extra information from user and display some type of graph after registration which cannot be fulfilled by adding extra fields within the form. In other way we can redirect to a second page containing your required form. Debdatta SarkarDebdatta has more than 13 years in IT induustry and software engineering. Currently 6 years in data science, and machine learning. She holds a Master of Computer Applications degree and Executive Post Graduate Program Degree in Data Science. She is passionate about research, data-driven decisions, and technology’s role in business growth.

Drupal 7 upload Sub Logo Advanced Theme Settings

In many cases you might need to upload a second logo for a theme. In this case you would like to upload a second logo from admin. You will need to add this code in your theme-settings.php page. Debdatta SarkarDebdatta has more than 13 years in IT induustry and software engineering. Currently 6 years in data science, and machine learning. She holds a Master of Computer Applications degree and Executive Post Graduate Program Degree in Data Science. She is passionate about research, data-driven decisions, and technology’s role in business growth.

Drupal 7 Node Type Based Custom Template

In many cases of theming in Drupal we may may need a different set of header and footer. We can achieve this by writing a couple of lines in template.php for your current Drupal theme. Code snippet for Drupal 7 node type based custom template. Debdatta SarkarDebdatta has more than 13 years in IT induustry and software engineering. Currently 6 years in data science, and machine learning. She holds a Master of Computer Applications degree and Executive Post Graduate Program Degree in Data Science. She is passionate about research, data-driven decisions, and technology’s role in business growth.

Others | Your Tech Salt