Introduction: A collection of SQL statements is referred to as a stored procedure in SQL and is stored together in a database. It can execute
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
MySQL RDS – Publish logs in Cloudwatch
You can access the logs that are produced by each RDS database engine for auditing and troubleshooting. Your database engine determines the kind of logs
Usage of ROW Keyword in MySQL
Subqueries that are scalar or column return a single value or a column of values. A subquery variant known as a row subquery returns a
MySQL RDS – The specified log group does not exist
If you experience the error: There was an error filtering log events The specified log group does not exist, checking the parameter group may be
MySQL JOINs – USING vs ON
Both USING and ON will work in the same way in JOINS. It combines the two tables and returns the matched records from both. However,
Run a shell script in EC2
It’s really simple to execute a batch file in Windows by just invoking the script in PowerShell or by double-clicking. Similarly, you must specify the
Big Data & SQL 