On any given day a coder is running against deadlines. But in this race quality often gets hit, impacting the end product. A software engineering expert at eBay shares her insights on how to counter this
Every company wants to capitalize on the Internet of things (IoT) in its big data strategy–but what’s the best way to go about it? Here are 10 steps to include in your IoT enablement plans.
3: Go for the low-hanging fruit
4: Clean your data
5: Think about your customers
6: Never forget failover
7: Strengthen security
8: Work your IoT and system of record combinations
9: Set baselines and metrics… and go for results
10: Define your next-gen IoT applications
For more details Click Here
As we know Joomla is opensource, thus it has more rsik of getting hacked by hackers. We can minimize the risk of getting hacked our Joomla website by following below checklist:-
- Very important in Joomla website development, you have to be updated with latest version of Joomla CMS.
- Maintain secure / unique login credential or admin panel and database servers.
- If you are using .htaccess file, then rename that file.
- Change the default administrator panel URL with customized URL.
- You can set advanced permission to configuration file.
- While Joomla installation, change the database table prefix with another prefix
- Hackers can use log file and temp folders to hack the website, thus change the path of them.
- Remove all the unnecessary files such as extensions, articles, images form server.
- If your website have input forms, then validate those with validation library.
- You can use SSL certificates for your website to make it more secure
As per My experience, i found some of MySQL queries are repeat in interview questions, ans they are as follows;
1: Query to find second highest salary of Employee
select MAX(Salary) from Employee WHERE Salary NOT IN (select MAX(Salary) from Employee );
2: SQL Query to find Max Salary from each department
SELECT DeptID, MAX(Salary) FROM Employee GROUP BY DeptID.
3. Write an SQL Query to find employee whose Salary is equal or greater than 10000.
SELECT EmpName FROM Employees WHERE Salary>=10000;
4. Write an SQL Query to find name of employee whose name Start with ‘M’
SELECT * FROM Employees WHERE EmpName like ‘M%’;
5. find all Employee records containing the word “Joe”, regardless of whether it was stored as JOE, Joe, or joe.
SELECT * from Employees WHERE UPPER(EmpName) like ‘%JOE%’;
6. Write a SQL Query to find year from date.
SELECT YEAR(GETDATE()) as “Year”;