1-Database schema

2-Introduction to SQL (DML, DDL, DCL)

3-SQL sample commands and interactions

4-Learning and practice

Exercises: Select * from EMP; Select job from EMP; Select distinct job from EMP; How a question can be asked? Question: Display job, hiredate, a salary of all employees order by department number? Solution: First to find out an exact table or tables provides required columns by writing the following SQL SELECT FROM information_schema.tables; Then to see exact names of column(s) from a table (in this case table you decided is EMP), run command as EXEC sp_help 'dbo.EMP'; EXEC sP_columns EMP; SELECT * FROM information_schema.columns WHERE table_name = "EMP'; Based upon the above SQLs formulate a SQL statement as follows Select job, hiredate, sal from EMP order by deptno; Question: List of employee name, hiring date, job title, commission, and salary of those employees who are clerks. Uestion: ist of employees who may CLERK, MANAGER, ANAL YST having salary below 1200. Select * from EMP where Job='CLERK' OR job='MANAGER' OR Job='ANALYST' OR sal job= 'ANALYST') AND Question: List of employees having salary ranges from 1000 to 3000. Select % from EMP where sal BETWEEN 1600 AND 3ac9; Select = from EMP where sal>m 1696 ANO sal