Top products from r/SQL

SQL Queries for Mere Mortals is an excellent beginner's read front to back. The same guy wrote a database design book, which I did not find as helpful.

As for software, it depends on what database system you end up using. I use SQL Server and a little MySQL, but I know PostgreSQL, SQLite, and many others are popular.

If you're learning indipendantly, I'd start with MySQL , as it is free (open source) and you will be able to learn the basics of SQL in any SQL database. It also has a good free GUI development tool, MySQL Workbench, and a robust online community.

Like any programming language, the best way to learn is to build something with it. So start thinking of something you want to build, so you'll have something to do once you know enough to play around.

This book is designed specifically for the test. It covers everything on the test, and some things that aren't specifically on it but may help for other questions.

It also comes with practice test software that is very useful.

The test goes well beyond writing queries.

Be prepared for (not meant to be comprehensive):

• UDFs,
  
• window functions,
  
• defining and modifying tables and views,
  
• best use of data types,
  
• pivots
  
• using XML data
  
• CTEs
  
• creating and modifying triggers, stored procs
  
  Good luck!

False. Oracle is a RDBMS. To query an Oracle DB, you use SQL, just like you do with almost all other RDBMS. Granted, each DB can have its slightly different syntax, but it's generally all the same.

PL/SQL is a object-oriented procedural language for SQL and the Oracle database. This is similar (but much more powerful and feature rich) to SQL Server's T-SQL. It's modeled after the language Ada, which in turn is modeled after Pascal.

Get familiar with the anonymous block and DBMS_OUTPUT.PUT_LINE. Toad is by far your best (although super pricey) IDE for PL/SQL and it's debugger is great.

Make sure to pick up a copy of this book. It's seriously the only book that I've ever seen multiple copies of at every single job I've had. My current job actually calls it "Steve's Book" and it's often referred to as the PL/SQL Bible:

Oracle PL/SQL Programming

I would be useful to find out which specific DBMS they use but in the meantime I would recommend getting SQL in 10 Minutes, Sams Teach Yourself.

The book teaches ASNI (American National Standards Institute) SQL - all the general main concepts like SELECT, UPDATE that all DBMS share.

It has 22 chapters that each take 10 mins to read (but you should spend more time after each chapter practicing examples). It was incredibly helpful for me when I started learning as i knew 0 about SQL. There's a reason that books it #1 Best Seller. Once you find out what database they use you can learn DBMS-specific functions in addition.

Yeah, job-title wise, things were similar. My background is a bit more technical, I did get a degree related to databases, and by the time I was interviewing other places I had passed both the 70-461 and 70-462 MS certificate tests. Certificates are definitely useful, mostly because you will be more confident in answering interview questions.

If you do want to do a cert, I would highly recommend the 70-461 test. The book is really good for that one, and it will set you apart from lots of others in your experience range. You could start by asking your boss if he would pay for the book (https://www.amazon.com/Training-70-461-Querying-Microsoft-Server/dp/0735666059). It will take some time to study it to be ready for the test. I think you should be able to get a new job without having passed the test. From my experience, not too many employers know about/are impressed by me having the 70-461 completed. But they are impressed by the amount of knowledge I have about databases, most of which came from that book.

Start studying, but really, networking is going to be very very valuable. You made it to the final round of interviews, imagine if a buddy was telling them that they HAVE to hire you? You would probably be a shoe-in. How does your network look on LinkedIn right now?

This website is really helpful for upping your SQL skills because it gives you instant feed back and provides problems that aren't overly easy to google.

This book is excellent and written by a God that is known to mortals as Itzik Ben-Gan.

This online SQL code formatter is my personal favorite

When you hit the wall this is also helpful

Hope that helps and remember in Codd we trust!

Select is exactly as it implies, it is what you are selecting. Performance wise, it's the same to say, give me everything vs give me one or two things. It's best to specify what you want, because if you don't need everything, you're going to pull a lot of network time trying to pull more data across. Also, it can break things. Example: My beginning point has 5 columns and so does my end point, I get sloppy, I just say, hey, just grab everything from my beginning point, insert it into my end point. What if I add a column in the future? It will break your code because the end point has 5 columns, but you added a 6th column to your beginning point and told it to grab everything.

For joins, practice. Lots of practice. This covers joins well: https://blog.codinghorror.com/a-visual-explanation-of-sql-joins/

Here are some books I'd highly recommend:

First book to read

Second book

Go download SQL 2016 developer, almost the same as enterprise and free. They have a huge DB for it that you can practice in.

You are getting some good advice from others but I'll give a slightly different take. One of the MS SQL exams is on querying SQL. Now take the exam or not - your call - but the book is a great way to introduce yourself to some advanced concepts like windowing functions.

Now other exam books (looking at you administering sql) are steaming piles of crap but the linked one is readable and you actually use what you've learned. The other issue is the old 'you don't know what you don't know.' The book will give you ideas and terms you can use to get better google results.

I completed the 70-761 T-SQL exam.

For the exam I used:

1. Edx - They have a free SQL course.
   https://www.edx.org/course/querying-data-with-transact-sql
   
2. I learnt basic and more complex topics from a book called 'Exam Ref 70-761 Querying Data with Transact-SQL' by Itzik Ben-Gan. The book has some really great examples.
   
   https://www.amazon.com/Exam-70-761-Querying-Data-Transact-SQL/dp/1509304339
   
   I would recommend practising each new topic locally so you get a feel for it. I hope this helps!

You don't need to have formal coursework or a certification.


Learn however much you need to so that you feel comfortable honestly putting it on your resume in some way. Even if this means that your resume includes something along the lines of 'light SQL experience'. If you get into an interview make sure you set the right expectation about any skills listed on your resume like this. From the mouth of a VP - "I know this job won't require (insert random skill here). I put that on there so that I have an HR friendly reason to reject any candidate."


All that being said, check out this book:


https://www.amazon.com/SQL-Minutes-Sams-Teach-Yourself/dp/0672336073


It should get you a good enough understanding to be able to talk about SQL in an interview (assuming you level set with them correctly) to demonstrate that you took the job seriously enough to start learning. It's not a lot by any means, but it can give you an opportunity to convince the person interviewing you that you can learn it if needed.

I thought the book Head First SQL was extremely useful. It did a great job of explaining the concepts and getting me comfortable using SQL.

I’d have to say these were a great combo in my SQL class last year:

SQL Queries For Mere Mortals

and

Murach’s MySQL

Jon Duckett also has a MySQL & PHP book coming out next month that I’m looking forward to. Loved his books on HTML/CSS and Javascript/JQuery

PHP & MySQL: Server Side Web Development

http://db-class.org is open this quarter, and covers the fundamental relational database concepts.

SQL and Relational Theory is a solid next step. (and available using the free 10 day Safari Books Online trial account)

For specific syntax, refer to Microsoft's own product documentation. The SQL Server Books Online should have been installed on your workstation along with the client tools if you're using SSMS. The T-SQL language reference begins here.

You might also want to install one of the SQL Server editions on a workstation as a playground so you don't need to worry about breaking your production servers. Developer Edition is under $50 a seat. Express is free. There's also a time-limited full evaluation copy available here.

The best book would be Itzik Ben-Gan's T-SQL Fundamentals: http://www.amazon.com/gp/aw/d/0735658145/ref=mp_s_a_1_2?qid=1375556912&sr=1-2&pi=SL160_PIsitb-sticker-arrow-dp,TopRight,12,-18_SH30_OU01_AA160

You can also check out our free SQL tutorials on MidnightDBA.com I have a number of introductory videos on T-SQL (under the Dev) section.

This http://www.amazon.com/Microsoft-Server-2012-T-SQL-Fundamentals/dp/0735658145 excellent with great examples

Sorry I'm coming in here so late, but "Database Design for Mere Mortals" is where I learned from.

Good tables, good relationships, good life.

Warning: Databases are not easy. There's a reason that some folks specialize in them.

Your code doesn't sound that bad. I once updated a series of reports (ie, vendor report, services report, etc.) that the previous guy made internally consistent by re-running the entire original base report (including select) in every other report because they were timing out. I honestly still wasn't too mad at him because he'd turned it from a 20+ step access db job into reports through SSRS.

I would focus on what you've identified.

For grouping, go through hackerrank's aggregation - https://www.hackerrank.com/domains/sql?filters%5Bsubdomains%5D%5B%5D=aggregation and/or Itzik Ben-Gan's TSQL Querying books chapter on grouping.

Having is a filter (where clause) that's applied after the data is grouped. You might group together orders by customer and filter out customers whose max order-date is more than a year ago. Most of my aggregate or grouped queries don't have a 'having' clause.

For performance, I you might look at some of your longest running reports and re-factor them using the execution plan, etc. Itzik's https://www.amazon.com/T-SQL-Querying-Developer-Reference-Ben-Gan/dp/0735685045/ has a chapter on query tuning. I'm not personally great at it because I don't use it a lot.

If you are the type that doesn't mind reading a book, there's a book called The Art of SQL, it's all about fine tuning queries for performance, it will definitely help you. https://www.amazon.com/Art-SQL-Peter-Robson-ebook/dp/B0028N4WEC

I would recommend Joe Celko's Trees and Hierarchies in SQL for Smarties. All the sql that you can ever want! Has great problems and solutions.

I wouldn't go that far, but the book has little practical value. Date is very knowledgeable, but he writes like an academic - he can take any piece of prose and suck the life out of it.
The Art of SQL is a much better book.

Itzik Ben-Gan has several books that come highly recommended. Carlos Chacon's Zero to SQL book is new and I've heard positive things.

https://www.amazon.com/T-SQL-Fundamentals-3rd-Itzik-Ben-Gan/dp/150930200X

https://www.amazon.com/Zero-SQL-20-Lessons-language-ebook/dp/B01MYORI53

A little off-topic, but I just got the Teach Yourself SQL in 10 Minutes book (where each chapter is supposed to be 10 minutes). I just started learning SQL and this $20 book is pretty handy.

Assuming you mean this book, which is an excellent resource. There are other 'training' videos/classes that can help, but they aren't nearly as thorough.

• Download the 2016 CPL
  
• Download Adventure Works
  
  Live and breath what the book has to offer. The only way to pass the exam is the practice and understand how the system works. You, maybe, could pass the exam by studying alone, but that is taking the hardest route I could think of to do so; not really progressing yourself either.

I've taken a couple courses on Oracle database. The thing one of my instructors said is that if you learn Oracle (or MySql, or one of those DBs) well, it's a short step to learning SQL Server (ie: Access). But if you learn SQL Server first, the learning curve to jumping to Oracle/MySQL/Etc. is much greater.

I'd say download/install MySQL and learn its command line first, that will give you a universal SQL background which can be applied to a bunch of different databases.

When I was learning SQL, these were the two books I mainly used:

SQL Fundamentals


Oracle SQL Fundamentals Exam Guide

On Oracle? Best book SQL / PL/SQL book I've ever bought : Excuse the lack of hyperlink, on my phone. http://www.amazon.co.uk/gp/aw/d/1449324452/ref=mp_s_a_1_1?qid=1394853719&sr=1-1&pi=AC_SX110_SY165

I learned by reading Itzik Ben-Gan's T-SQL Fundamentals From what I read, he's considered the world's foremost authority on the T-SQL language (Microsoft's implementation of SQL) and also does a very good job teaching ANSI (standard) SQL. I'm actually finishing up this book now. I have around 30 pages or so left.

I really enjoyed and was able to build a strong foundation with Head First SQL

http://www.amazon.com/Head-First-SQL-Brain-Learners/dp/0596526849/ref=sr_1_1?ie=UTF8&qid=1416913925&sr=8-1&keywords=head+first+sql&pebp=1416913929647

Orielly used to publish the first chapter online but I can't find t on their site right now.

Get this book and study it, and actually do all of the exercises and questions until you're comfortable.

There is a list of training resources in the sidebar. I bought

https://www.amazon.com/SQL-Minutes-Sams-Teach-Yourself/dp/0672336073

and its pretty handy. I get most of my basics now from w3schools or stack overflow.

http://www.amazon.com/SQL-Antipatterns-Programming-Pragmatic-Programmers/dp/1934356557/ref=pd_sim_b_3

http://www.amazon.com/Joe-Celkos-SQL-Smarties-Programming/dp/1558605762

http://www.amazon.com/Art-SQL-Stephane-Faroult/dp/0596008945/ref=pd_sim_b_4

http://www.amazon.com/SQL-Relational-Theory-Write-Accurate/dp/0596523068/ref=pd_sim_b_7

And then read a book on whichever dialect of SQL you're using, because they're pretty different.

I found this book to be really good:

https://www.amazon.com/Art-SQL-Peter-Robson-ebook-dp-B0028N4WEC/dp/B0028N4WEC/ref=mt_kindle?_encoding=UTF8&me=&qid=1568905015

If you are doing BI with MS SQL I would also start learning DAX.

Try this book: http://www.amazon.com/Microsoft-Server-2012-T-SQL-Fundamentals/dp/0735658145. It will be useful to you working with SQL Server

Another good desktop reference is this one

http://www.amazon.com/Cookbook-Cookbooks-OReilly-Anthony-Molinaro/dp/0596009763

It seems like you can use a date dimension here.

To read about multi-dimensional concepts: http://www.amazon.com/Data-Warehouse-Toolkit-Definitive-Dimensional/dp/1118530802/ref=sr_1_1?s=books&ie=UTF8&qid=1415023036&sr=1-1&keywords=the+data+warehouse+toolkit

I recommend [SQL Queries for Mere Mortals ($36.64)](SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (3rd Edition) https://www.amazon.com/dp/0321992474/ref=cm_sw_r_cp_apa_nCQrybW9TPPNN) and [Database Design for Mere Mortals ($31.57)](Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (3rd Edition) https://www.amazon.com/dp/0321884493/ref=cm_sw_r_cp_apa_CDQrybA2508FS)

Both helped guide me through my masters program, and they are fairly affordable.

You can download all the training kits books and only give all the tests.


70-461


70-462

70-463

I think this is a great beginners / fundamentals book. It will give you an in depth focus on the basics:

​

https://www.amazon.com/Microsoft-Server-Fundamentals-Developer-Reference/dp/0735658145/ref=sr_1_3?ie=UTF8&qid=1536613857&sr=8-3&keywords=tsql+fundamentals

http://www.amazon.com/gp/aw/d/0735666059/ref=mp_s_a_1_1?qid=1404265021&sr=8-1&pi=SY200_QL40

Check this out for the Querying T SQL 2012 exam.

Ah... I was thinking about getting that book. What did you think about it overall?

Just a link for future reference

• Beginners: Practical SQL Handbook or SQL Primer (Disclosure: I wrote the latter)
  
• Advanced: The Art of SQL and SQL Antipatterns
  
• Reference: Introduction to SQL or SQL Cookbook

This, and this.

Not BigQuery specific, but this is the book on hierarchical querying in SQL:

https://www.amazon.com/Hierarchies-Smarties-Kaufmann-Management-Systems/dp/0123877334

https://www.amazon.com/Data-Analysis-Using-SQL-Excel/dp/111902143X/ref=sr_1_2?s=books&ie=UTF8&qid=1505443462&sr=1-2

>data warehouse toolkit

Can you confirm that this is the book you are referring to? Amazon Link

Is this the cover?

Assuming MSSQL, two quick book tips:

https://www.amazon.de/T-SQL-Querying-Developer-Reference-Paperback/dp/0735685045

https://www.microsoftpressstore.com/store/t-sql-window-functions-for-data-analysis-and-beyond-9780135861448

The Itzik Ben Gan books on Querying T-SQL are invaluable imo. T-SQL fundamentals covers most things you will need to know:

http://www.amazon.com/Microsoft-Server-Fundamentals-Developer-Reference/dp/0735658145/ref=asap_bc?ie=UTF8

I'd check out 'Querying Microsoft SQL Server 2012', it's said to be one of the best - and it's also an exam prep book for 70-461.

Unfortunately OReilly no longer carries it, as MS apparently took back all of the MS Press rights from them - but if you happen to be in Canada it's ridiculously cheap on Amazon.ca right now, has an exam prep on the CD, and a 10% off coupon for the exam as well.

I started with this book: SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (4th Edition) https://www.amazon.com/dp/0134858336/ref=cm_sw_r_cp_api_UIWLBbJZF1KBH

It’s very through but a bit slow at the start. I go back and reference it from time to time still.

Read this book:

http://www.amazon.com/Data-Warehouse-Toolkit-Definitive-Dimensional/dp/1118530802

Seriously.