Search results
Hi everyone, so I spent most of last week learning SQL and trying to do SQL query problems. Here's a quick reference/cheatsheet I made for all useful SQL queries I learned from w3schools. Github Page: https://github.com/enochtangg/quick-SQL-cheatsheet
Put this together a little while ago. Might come in handy for some. Link to full PDF here: https://github.com/ABZ-Aaron/CheatSheets
For MS SQL Server, you can install SQL Server Developer edition on a PC at home for free to learn on. You then install SSMS to interact with your private little learning server. The StackOverflow database can be pulled down for free to have real data to play with.
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!
LIKE OPERATOR – PATTERN MATCHING. Use the _ character to replace any single character. Use the % character to replace any number of characters (including 0 characters). Fetch all names that start with any letter followed by 'atherine':
14 wrz 2009 · The data for document generation and the rules to trigger the generation are all on sql server. We now have to create a pdf file. I was planning on using pdfsharp/migradoc to do it, but then we'd have to create document and time its readiness with sql server data state and mail state.
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 Cookbook by Anthony Molinaro. SQL Practice Problems by Sylvia Moestl Vasilik.
