{"id":325,"date":"2017-02-20T18:34:16","date_gmt":"2017-02-20T23:34:16","guid":{"rendered":"https:\/\/www.onlc.com\/blog\/?p=325"},"modified":"2017-02-20T18:34:16","modified_gmt":"2017-02-20T23:34:16","slug":"sql-can-use","status":"publish","type":"post","link":"https:\/\/www.onlc.com\/blog\/sql-can-use\/","title":{"rendered":"What is SQL and How Can I Use It?"},"content":{"rendered":"

What is SQL<\/span><\/a>? SQL stands for Structured Query Language. It is the most popular programming language for databases. It\u2019s used by all of the top players in the industry including Microsoft SQL Server, Oracle, MySQL and Microsoft Access, just to name a few. It is the easiest and quickest way to get data into and out of a database and manipulate it any way imaginable. <\/span><\/p>\n

Let\u2019s discuss some basic SQL commands and learn about some of the certifications that may designate you as an expert on the topic of Structured Query Language.<\/span><\/p>\n

Basic Commands<\/span><\/h2>\n

Probably the most commonly used commands in basic queries and commands are the SELECT, INSERT, UPDATE and DELETE commands. Let\u2019s talk about their basic syntax and what each command accomplishes when used in a database that interprets SQL.<\/span><\/p>\n

SELECT<\/b><\/p>\n

The SELECT command is used when you want to retrieve data from the database. You use it to simply select what you would like to see by specifying a table that you want to retrieve data from and then what columns in that table that you would like to return. Think of database tables as being similar to Microsoft Excel spreadsheets. They have columns and rows and values are contained in cells. Below are some syntax examples:<\/span><\/p>\n