What are the everyday activities of an SQL queries for MIS Excecutive ?

Asked by Last Modified  

5 Answers

Learn MS SQL

Follow 4
Answer

Please enter your answer

IT Professional Trainer with 12 Years of Experience in IT Industry

For MIS executive, your everyday activity could be select the data, Insert the data, update the data and delete the data as well. Please make sure took table backup OR use Begin trans, Commit trans & Rollback trans before update/delete data from the table. It will help you to track the records.
Comments

IT Professional Trainer with 12 Years of Experience in IT Industry

Everyday activities for MIS executives is to run SQL queries to get data from the database, and insert/update/delete records as per day to day tasks.
Comments

IT Professional Trainer with 12 Years of Experience in IT Industry

HI Siddu,An MIS Executive – or Management Information System Executive – is responsible for planning, coordinating and directing all computer-related activities within an organization. They help determine the company's information technology goals and are responsible for implementing computer...
read more
HI Siddu,An MIS Executive – or Management Information System Executive – is responsible for planning, coordinating and directing all computer-related activities within an organization. They help determine the company's information technology goals and are responsible for implementing computer systems to meet those goals.Thanks! read less
Comments

I’m having 6+ yrs of real time exp in MSBI and Hands on Exp in SQL Server,ETL like SSIS,Talend

Day to day responsibilities will be- storing the data, managing the data, retrieves the data. Commands like Select/ create/ insert/ update/ delete will be main actions you will be performing on data in a table.
Comments

Computer Wizard

Basically, they need to do following operations regularly 1. Create 2. Read 3. Delete 4. Update
Comments

View 3 more Answers

Related Questions

What is the best way to start learning SQL server 2016?
Hi Ramya, To learn the SQL there is multiple step & way's. Start learn basic queries and RDBMS Database concept. Than Installing, Configuring, and Managing Microsoft SQL Server, Sample Databases...
Ramya
0 0
7
Need help regarding SQL Server and Access Database Connectivity over a network on ODBC. Can pay a good price. Thanks
Ok send me the details what you are using as a frontend lang like java or c# and what probelms you are facing.
Ruchi
2 0
5

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

What Is WorkTable In SQL Server?
What is WorkTable in SQL Server? USE AdventureWorks2014 GO SET STATISTICS IO ON GO SELECT * FROM Production.Product p CROSS JOIN Production.Product p1 GO If you run above query,...

Troubleshooting SQL Server Agent failed Jobs - Common daily routine work for DBA
If you are lazy and not intended to do repetitive manual work at a routine time, then SQL Server Agent job help you achieve this. SQL Server agent jobs help to automate the execution of the recurring task...

History of SQL server
In 1988, Microsoft released its first version of SQL Server. It was designed for the OS/2 platform and was developed jointly by Microsoft and Sybase. During the early 1990s, Microsoft began to develop...

What is database backup? How backup works in SQL Server?
Database Backup in normal terms can be said as a copy of data which can be used in a situation when the things go wrong with your system/server. If your role is IT/Database Administrator, then it is your...

Cursors In SQL Server
First thing first Usage of Cursors is not encouraged in SQL Server as they are slow. You may go with While loop if you need to iterate through a recordset. Cursor is a database object to retrieve data...

Recommended Articles

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to...

Read full article >

Looking for MS SQL Training?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you