Shivani Suram Blogs

What is SQL? SQL (STRUCTURED QUERY LANGUAGE) is a programming language used for managing and manipulating data in a relational database.It is used to insert,update,retrieve, and delete data stored in a database. SQL is widely used for managing data in large organizations as well as for building web applications and mobile apps that rely on databases. SQL is a standard language, which means that the syntax and basic functionality is consistent across different DBMS. SQL has a simple syntax that makes it easy to learn and use.what data you want to modify or retrieve and database management system takes care of executing the necessary operations to achieve that. Why SQL? It is a standard language that is supported by many relational database management systems, including oracle,Microsoft SQL server,MYSQL,and PostgreSQL. Here are some common SQL queries: SELECT - retrieves data from one or more tables in a database. INSERT - adds new data into a table. UPDATE - modifies ...

Roles and responsibilities of an MES engineer 1.Understand and determine the project requirements: a)The first step in project planning is to gather requirements from the end user. b)Need to take the time to listen and understand their point of view and ask their requirements, it helps us  in problem-solving in further situations. c)Based on the information, one can determine what things are needed to deliver to the user. This requires strong communication skills, positivity and problem-solving. d)Clearly communicate with the end user by answering questions or explain in doubts in addition to actively listening to the end user problems. 2.Define the scope i.The things to remember while defining the scope are a) It should be achievable. b)It sounds like pragmatic. ii.Along with the scope we need to estimate the line items like a)Major deliverables. b)Timelines. c)Resources and manpower. d)Related activities. e)Project boundaries. 3.Breakdown the project scope: a)Breakdown the scope...

What is Government? Yes,it is the group of people with the authority to govern a country or state. Types of government: 1.Monarchy: It is ruled by the monarch, who makes all governance decisions, and power is transferred to clans in this system. Ex:Saudi Arabia 2.Dictatorship: The person (Dictator) who governs and rules a region by making all decisions alone and sometimes without consulting anyone. They are not elected. Ex: Germany had a dictatorship with Hitler as dictator. Do you believe that dictators still exist? An organization name 'Borgen project' had identified 8 dictators in the world. 3.Military system of government: Powerful people generally tends to control all the things around them by their huge military weapons like war plains and missiles. The chief of the arm forces who takeover the government and start ruling it. Ex: Myanmar is under military rule. 4.Democracy or Democratic form of government: It is the word derived from the Greek word demoKratia. (Demo=Peopl...

The rights of citizens are written down in the constitution and in most democracies courts are set up to protect these rights.The Indian constitution lists the fundamental rights and these are have a high degree of protection from government encroachment.Fundamental rights always ensures equality,liberty(Freedom) and justice. No government have the power to remove certain basic features of the government and no government can abolish fundamental rights of citizens.  What are fundamental rights? They are set of rights that every Indian citizen gets by default.These rights are laid down by the constitution of India. 6 fundamental rights are: 1.Right to equality: All citizens are treated equally.you can't be subject to different set of laws. 2.Right to freedom: You are free to express your thoughts.You are having right to obtain working information of the government is called Right to information. 3.Right against exploitation: Nobody can exploit a fellow citizen. 4.Right to ...