LINUX Cheat Sheet

1 – SYSTEM INFORMATION uname -a# Display Linux system informationuname -r# Display kernel release informationcat /etc/redhat-release# Show which version of Red Hat installeduptime# Show how long the system has been running + loadhostname# Show system host namehostname -I# Display all local IP addresses of the hostlast reboot# Show system reboot historydate# Show the current dateContinue reading “LINUX Cheat Sheet”

SQL-certification path

OLTP and OLAP OLTP – Online Transaction processing – inserts , updates and deletes very efficient and fast, OLAP (Online Analytical processing – Data Warehouse) – data insert not efficient, reading data is efficient Indexes are used to retrieve data from the database more quickly than otherwise. The users cannot see the indexes, they areContinue reading “SQL-certification path”