Featured Post

SQL Interview Success: Unlocking the Top 5 Frequently Asked Queries

Image
 Here are the five top commonly asked SQL queries in the interviews. These you can expect in Data Analyst, or, Data Engineer interviews. Top SQL Queries for Interviews 01. Joins The commonly asked question pertains to providing two tables, determining the number of rows that will return on various join types, and the resultant. Table1 -------- id ---- 1 1 2 3 Table2 -------- id ---- 1 3 1 NULL Output ------- Inner join --------------- 5 rows will return The result will be: =============== 1  1 1   1 1   1 1    1 3    3 02. Substring and Concat Here, we need to write an SQL query to make the upper case of the first letter and the small case of the remaining letter. Table1 ------ ename ===== raJu venKat kRIshna Solution: ========== SELECT CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name, 2))) AS capitalized_name FROM Table1; 03. Case statement SQL Query ========= SELECT Code1, Code2,      CASE         WHEN Code1 = 'A' AND Code2 = 'AA' THEN "A" | "A

SAS career these are different job roles

What is SAS?
Originating in 1966 at North Carolina State University, SAS is a proprietary 4th generation programming language specifically designed for data analysis. Data analysis includes data management, ETL, descriptive statistics, plots and graphics, inferential statistics, data mining, forecasting, etc.. In addition to the SAS programming language, SAS Institute, its parent company, also sells solutions built on top of the SAS language.

SAS career
Many people assumptions about SAS: Some people confuse SAS with the common database query language called “SQL”, thinking that both languages manage data in some way. While SAS may be used for database querying (reading/writing data to databases), this is only a tiny fraction of SAS’s capabilities. To give some scope, the entire SQL language is available in SAS as but one “procedure” (think of a procedure as a bundle of functionality).
SKILL Set: What It Is: Pronounced “sass,” this software helps workers perform a variety of tasks, including business forecasting, project management and statistical analysis. 
Different roles in SAS Jobs:
  1. Business analyst
  2. Clinical data programmer
  3. Data Analyst
  4. Data Quality Steward
  5. Data Scientist
  6. Data warehouse architect
  7. Database administrator
  8. Database programmer
  9. Developer
  10. ETL specialist
  11. Financial analyst
  12. IT Manager
  13. Marketing analyst
  14. Platform Administrator
  15. Programmer
  16. Project Manager
  17. Quality analyst
  18. Report programmer
  19. Reporting Analyst
  20. Securities analyst
  21. Statistician
  22. Statistics programmer
  23. Systems/network programmer

Comments

Popular posts from this blog

How to Fix datetime Import Error in Python Quickly

Explained Ideal Structure of Python Class

How to Check Kafka Available Brokers