Question

In: Computer Science

I think that SQL language is a great tool for database creation and manipulation. The basics...

I think that SQL language is a great tool for database creation and manipulation. The basics of SQL are easy to learn and understand. The coding is simple from the creation, changing, or even deleting data from the database. I overall really like learning SQL I can easily visualize what I am doing with the code.

What could be added to this post?

Solutions

Expert Solution

Yes you are correct SQL is very easy to learn and one of the good option for database creation and manipulation.

Let me add more to your post.

SQL is a language to operate databases, it includes database creation, deletion, fetching rows, modifying rows etc.

SQL us a abbrevation of Structured Query Language, which is a langauge for storingm manipulating and retrieving data stored in a relation database. Also its one of the great choice to use because many relation database systems like MySQL, MS ACCESS, Postgres, Oracle, Sybase and SQL Server uses SQL as their standard language.

SQL language so simple that its like english language, for table creation we write.

Create table table_name which is pretty similar to english that also a reason sql is considered easy.

Why one should learn SQL:

1. Data manipulation

2. Data mining

3. SQL programmers in high demand.

4. Combine data from multiple source

5. Manage large data.

6. SQL is everywhere, i.e its used by most of the database system.

With SQL skill you can apply for profiles include data analysts, developers, admin, and even marketing specialists.


Related Solutions

SQL statements are divided into three major categories: Data Definition Language (DDL), Data Manipulation Language (DML),...
SQL statements are divided into three major categories: Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL). Explain the differences between DDL, DML, and DCL commands, and provide practical examples of each.
why do you think normalization is a necessary step in the creation of your database? list...
why do you think normalization is a necessary step in the creation of your database? list multiple reasons
Please write the SQL statement for the following. I am using the Adventurework2014 database. 1. Create...
Please write the SQL statement for the following. I am using the Adventurework2014 database. 1. Create a login for AdventureWorks employees. An employee login should be composed of the first letter of a person's first name combined with their last name. In addition, the login should be all lower case characters. All the required information is located in Person.Person table. Employees can be identified by "EM" value in the PersonType field. The output should include BusinessEntityID, first name (FirstName), last...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT