SQL for Business Analyst

If client is expecting some SQL knowledge from Business Analyst,

he will not expect more than create and drop (delete) database table in order to create and modify the database schema, insert new data or update the existing data within table columns, query the data, and manage data access. If is he is expecting more than this, he rather go with DBA guy. You can confidently say, I’m good at some SQL skills (atleast following), where I can manage or extract some of the data from databases as required.

Examples are from www.w3schools.com, hope it may help you.

Explanation DB Syntax
Creating a Database CREATE DATABASE dbname;
Creating table CREATE TABLE table_name
(
column_name1 data_type(size),
column_name2 data_type(size),
column_name3 data_type(size),
….
);A data type defines what kind of value a column can contain
Insert data into tables INSERT INTO table_name (column1,column2,column3,…)
VALUES (value1,value2,value3,…);
Update the data in tables UPDATE table_name
SET column1=value1,column2=value2,…
WHERE some_column=some_value;
  UPDATE table_name
SET column1=value1,column2=value2,…
WHERE some_column=some_value;
Deleting data from table DELETE FROM table_name
WHERE some_column=some_value;
Extracting data from table SELECT column_name,column_name
FROM table_name;
Extract data from table with conditions SELECT * FROM Customers
WHERE Country=’Germany’
AND City=’Berlin’;
Extract data from table with filters SELECT column_name,column_name
FROM table_name
WHERE column_name operator value;
Commonly used Tools to manage database  Microsoft Visual Studio
SQL Server
MySQL
TOAD
Oracle

 

Last modified on Sunday, 12 March 2017 21:26
Share this article

Contact info

About us

Newsletter

Join the network: We are Business Folks, analyzing IT projects.
Top
We use cookies to improve our website. By continuing to use this website, you are giving consent to cookies being used. More details…