Understanding SQL

-

SQL is widely used across IT industry and is most common technology. We will be covering SQL topics in this article.

What is SQL?

SQL is structured query language which is a computer language for storing, manipulating and retrieving data stored in a relational database.

The standard SQL commands to interact with relational databases are CREATE, INSERT, SELECT, UPDATE, DELETE and DROP. These commands are classified into following groups based on their nature

DDL(Data Definition Language)

  • CREATE - Creates a new table or view of a table or other objects in databases.
  • ALTER - Modifies an database existing object or table.
  • DROP - Deletes an entire table, a view of a table.
  • Truncate - Delete the value stored in the table.
DML(Data Manipulation Language)

Comments

Post a Comment

Popular posts from this blog

Azure Tutorials Series - Azure Networking

-
Image
In this article, we will learn about Azure networking concepts such as architecture, microservices, virtual networks, VPNs, subnet, VPN gateways and most importantly Network Security Group(NSG). All these terms are to be understood if you appearing for AZ900 Microsoft Azure Fundamentals exam. Azure Networking In previous articles we have learnt about Micro- services and how they work, these are alos loosely coupled architecture. Some of the features includes Independent components interact with each other with the help of queues Can be updated and deployed independently Highly scalable Supports Asynchronous messaging N-tier Architecture Supports loosely coupled architecture Application divided into multiple tiers such that higher tier can access lower tier but not vice versa Tiers are re-usable and can be updated or replaced easily without any hassle. Three-tier in general Web Tier(front end) Application tier(back end) Data tier(Storage) Virtual Network Isolated network shared by few g
Read more

Testing in CI/CD

-
If you are part of testing fraternity you would have heard CI/CD numerous times by now. It's the talk of the software testing town. In this article, we will cover the basics of CI/CD, what actually it is and how it is implemented in software testing. What is continuous integration? In simple terms, development teams can integrate their code into a shared repository. This helps in maintaining code quality and identifying potential issues with the local version of the code at an early stage. What is continuous delivery? Everything that is being continuously merged by the development team, is continuously deployed to the live environment. Continuous delivery is often coined as ‘Continuous Deployment’ as well. Since most developers work in parallel, continuously integrating their code into one repository would mean that the master branch is continuously updated with new features. In order to ensure that there is no compromise in the code quality with so many changes
Read more

Incedo Automation Testing | SDET | Interview Experience | Gurgaon

-
In this article we will cover Incedo Automation Testing Interview Questions from 2022 which could help you prepare in advance. Incedo Automation Testing | SDET | Interview Experience  Company - Incedo Pvt Ltd Job role - Automation Engineer | SDET Job location- Gurgaon Interviewer - Vipin Grover Date - October 27 2022   Tell me about yourself? What testing frameworks have you used in your recent projects? Open Makemytrip and click on search - find xpath of Vistara. Write a program to find out missing number. For example 1,2,3,4,6. Your program should print 5, do not use any loops. Write a program to print below output. Input - My name is abhishek Output - My eman is kehsihba Interviewer needed dynamic approach for above program. What is the difference between findElementBy and findElementsBy? Tell atleast 3-4 differences. This method is used to return a single webelement in a webpage that matches the specified criteria. It returns the very first element which it finds in a webpage If no
Read more