SQL – hints & tips


 

This time, I collected documents in the theme of SQL. Sources are marked, where avaliable.

All the material are downloaded from linkedin professional groups.

 

First of all, a detailed SQL handbook from Hans-Petter Halvorsen, also avaliable on https://www.halvorsen.blog

SQL in detail

 

Another useful document. Unfortunately the source is unknown:

SQL_basics

 

Another one from the internet (unknown source):

SQL_notes

 

SQL interview Q&A from www.algotutor.io site:

SQL_Quick_Revision_Notes_For_Interview

 

Another 80 interview questions from Aspersh Upadhyay (https://www.linkedin.com/in/aspersh-upadhyay/)

80_sql_interview_questions

 

An SQL tutorial from www.tutorialspoint.com

SQL Tutorial

 

A useful one from www.w3schools.com

SQL_tutorial_w3schools

 

A must save document from HIMANSHU KUMAR https://www.linkedin.com/in/himanshukumarmahuri

SQL_Must_Save_And_Share

 


Comments

Post a Comment

Popular posts from this blog

Excel – tips & tricks

Image
  We have several better tools for data analysis than Excel, but we will probably never eradicate Excel from our life. Excel has it’s onw beauty. And it was cool in the ’90s 😊 Thanks for the LinkedIn community, I want to share some useful documents of MS Excel. Let’s see the shortcuts firstly. Another one in pdf: Excel_Shortcuts   Some tips and tricks: Excel tipd and tricks Some useful functions (XLOOKUP, INDEX&MATCH, SUMIF, IFERROR, etc…) 10_EXCEL_FUNCTION_IN_DATA_ANALYSIS   Advanced formulas Advanced_Excel_Formulas_and_Calculations A long story…: EXCEL_NOTES   Anoter long one for mazochistics: Excel_Formula_Bible   Some VBA notes: Excel_VBA_notes_for_professionals   Have fun! 😊
Read more

What makes data analysts’ work difficult?

Image
Nowadays, data analysis is a rather recruited field. There is a huge need for well-qualified proffesionals. No concidence, that many people want to break into this labor market as part of career-hack. And this is not a problem. Currentrly we are lack of well-qualified professionals, who can use Power BI, Tableau or SQL on an advanced level. And you are able to learn these softwares. It’s not brain surgery… If you are interested in these tools, I encourage you to learn them. In my previos post I have wrote about it: Self-learning, self-developement Now I want to write a little about the difficulties we encounter as a data analyst at daily work. During learning of a software (Power BI, SQL, Access, whatever…), you are always in an almost ideal environment. You can practice on a well-structured database, and you can try all the features with them. In real life, this is usually not the case. Let's have a look what obstacles we have to face.   Data inputs are coming fr
Read more