Search results
I've created a new SQL Cheat Sheet for my website visitors (those who sign up to my email newsletter) and wanted to offer it to the Reddit community as well. The link to the PDF file is here: SQL Cheat Sheet. It includes many commands, such as: Insert from a table Insert multiple rows at once Merge Many different ALTER TABLE features
Hello, I am completely new to the world of SQL and would like to get my journey started! Where do I start? I don't mind paying for courses, I am just looking for the best possible place to learn SQL.
I've looked at 14 blogs and the top books in Goodreads and compiled a list of the most recommended books on sql. There's 31 books on the list, I copied the top 20 here. The full list is at https://www.readthistwice.com/lists/best-sql-books. “SQL for Data Analysis - Advanced Techniques for Transforming Data into Insights” by Cathy Tanimura.
1 cze 2021 · Use the || operator to concatenate two strings: SELECT 'Hi ' || 'there!'; -- result: Hi there! ||. Use this trick for numbers: Some databases implement non-standard solutions for concatenating strings like CONCAT() or CONCAT_WS(). Check the documentation for your specific database. Use the _ character to replace any single character.
SQL Handwritten Notes Repository: A collection of PDF notes covering SQL concepts with concise definitions and examples. Explore fundamental commands, date/time functions, joins, and more. Contributions welcome!
1 cze 2021 · Try out the interactive Standard SQL Functions course at LearnSQL.com, and check out our other SQL courses. The basic version of CASE WHEN checks if the values are equal (e.g., if fee is equal to 50, then 'normal' is returned).
1 cze 2021 · Fetch all names that start with any letter followed by 'atherine': SELECT name FROM names WHERE name LIKE '_atherine'; Fetch all names that end with 'a': SELECT name FROM names WHERE name LIKE '%a'; USEFUL FUNCTIONS. Get the count of characters in a string: SELECT LENGTH('LearnSQL.com');-- result: 12 Convert all letters to lowercase: SELECT ...
