Tuesday, October 20, 2020

Educative Best - 10 Free Python, Java, C++ and JavaScript Online Interactive Course for Beginners

Hello guys, if you are looking for text-based, interactive free courses to learn in-demand skills like Python, Java, C++, and JavaScript then you have come to the right place. Earlier, I have shared the best courses to learn Python, Java, C++, and JavaScript and today, I am going to share some awesome, free, online text-based interactive courses to learn Java, Python, C, C++, JavaScript, R, Scala, and Web Development from Educative. If you don't know, Educative is a new platform for learning online. Unlike traditional video course platforms like Udemy or Pluralsight, they provide Interactive Courses for Software Developers.

Monday, October 19, 2020

How to add new columns to an existing table in SQL Server database

Hello guys, adding a new column to an existing table with data is always tricky and if you don't pay enough due diligence then you risk of corrupting or deleting existing data. You need to know what data is there, how much data is there, to gauge how long your query is gonna take to complete in production. Also, you cannot add NOT NULL columns into an existing table if they are not empty and you don't have a default value specified. If you know SQL then you probably know that you can add columns to an existing table in SQL Server using the ALTER command. It not only allows you to add a column but to drop columns as well.

Top 5 Courses to learn Appium for Testing Android Apps - Best of Lot

Hello guys, if you want to learn the Appium tool for automation testing and looking for the best online courses then you have come to the right place. In the past, I have shared the best courses to learn Selenium and Android application development and in this article, I am going to share the best Appium courses for both beginners and experienced developers. These courses have been created by experts and trusted by many developers around the world and you can join them too to learn Appium from scratch as well as to improve your Appium skills if you are already using it without in-depth knowledge.

Sunday, October 18, 2020

Database LEFT JOIN Example - How to Join Two Tables in a SQL query - LeetCode Solution

Hello guys, when it comes to combining two tables in SQL many programmers don't know that they can use the JOIN clause. In fact, JOIN is there to fetch data from multiple tables together. There are mainly two types of joins, INNER Join, and OUTER join. On Inner join, only those records are selected which has matching values in both tables, while in Outer join all records from one table are selected in addition to matching records from other tables. There are two kinds of Outer join in SQL, LEFT OUTER JOIN and RIGHT OUTER JOIN. Both are actually the same thing, which means you can get the same result by using either of the outer joins by just changing the position of a table from left to right.

Top 5 Courses to learn VI Editor or Vim for Beginners in Linux - Best of Lot

Hello guys, if you want to master the  VI editor or Vim and looking for the best online courses then you have come to the right place. Earlier, I have shared the best Linux courses and best shell scripting courses and today, I am going to share the best courses to learn VI editor. If you have worked in Linux, then you may know that VIM is one of the most useful and powerful text editor and every people working in a Linux environment should know about VIM. Also known as VI Editor, it is often touted as the go-to-editor for genius developers who make full use of Vim's capability for code navigation and do fancy things.

Saturday, October 17, 2020

5 best Reactjs projects for beginners in 2020 - Best of Lot

Hello guys, if you are self-learning React.js and looking for some project ideas to hone your React skills then you have come to the right place. Earlier, I have shared the best websites, courses, roadmap, and books to learn Reactjs, and today, I am going to share the best React.js projects you can build to improve your React skills. Learning web development and new technologies is not easy and react js is one of them. Completing an online course about react doesn’t make you a professional web developer until you test your knowledge by creating multiple projects so you take advantage of its features for learning purposes.