Reddit mentions of Exam Ref 70-761 Querying Data with Transact-SQL

The Exam Reference is probably the best resource out there. The Kindle Edition is only $16 as well and comes with a decent amount of sample questions.

https://www.amazon.com/Exam-70-761-Querying-Data-Transact-SQL-ebook-dp-B06Y21QGGQ/dp/B06Y21QGGQ/ref=mt_kindle?_encoding=UTF8&me=&qid=

Here's some Database/SQL knowledge you can begin studying and looking up (taken from a previous post I made):

Relational Database Theory

• Understand what a relation actually is (most people don't)
  
• Understand Tuples and Attributes
  
• Understand Your Normal Forms up to 3NF
  
• Know the difference between a set and a multi-set (Each element in a set must be unique and a set is always unordered. A multi-set can contain duplicates and may be ordered)
  
• Know what a Primary Key (PK) and a Foreign Key (FK) is and how're they used to create relationships amongst relations.
  
  SQL General
  
  
• First and foremost - know the difference between relational and non-relational SQL statements (this goes back to understanding set vs. multi-sets)
  
• Please know your Logical Query Processing Phases and understand why each phase of a SQL Engine is executed in the way that it is.
  
• Know the difference between the different JOINs - RIGHT, LEFT, FULL, INNER, 'CROSS'
  
• Know that pre-SQL 89 style JOIN using the WHERE clause are bad and that you should feel bad for using them. Use the ON keyword to JOIN tables.
  
• Understand that you can self-join and be able to perform it as well as give an example as to why you may use a self-join.
  
• Understand the difference between UNION and UNION ALL
  
• Know how to use HAVING to filter aggregated data.
  
• Explain what the differences are between using IN/NOT IN and EXISTS/NOT EXISTS and when you should use them.
  
• Know how to filter over a range with BETWEEN
  
• Understand how to use the various aggregate functions: MIN, MAX, COUNT, etc.
  
• Understand using LIKE for pattern matching.
  
• Know the difference between DDL, DML, DCL and TCL Commands in SQL.
  
• Know how to handle NULL as best as possible.
  
  DDL SQL
  
  
• Know how to CREATE TABLE
  
• Know how to create a CONSTRAINT on a table.
  
• Know how to add a PRIMARY KEY to a table.
  
• Know how to reference a FOREIGN KEY from another table with a CONSTRAINT
  
• Know how to TRUNCATE a table.
  
• Know the differences between TRUNCATE and DROP.
  
• Know how to add a column with ALTER TABLE to an already existing table.
  
• Know how to CREATE INDEX on a table.
  
• Understand the differences between a CLUSTERED index and a NONCLUSTERED index.
  
• Know how to CREATE TABLE from a SELECT statement
  
• Know how to perform UPDATE and INSERT statements
  
  SQL Programming
  
  (This implementation of this may be determined based on the RDBMS that the company uses. You'll want to find out what they use [SQL Server, Oracle, Postgres, etc.]) - here's some general overview of common SQL Programming tasks
  
  
• Above all, know that SQL Programming is designed to work around set-based programming and not scalar-based programming (unlike most general programming languages are).
  
  
• Understand what a Transaction is.
  
• Know how to CREATE a TRIGGER on a TABLE.
  
• Know the performance implications of adding a TRIGGER to a TABLE.
  
• Know how to CREATE a PROCEDURE
  
• Know the differences between a PROCEDURE and a FUNCTION.
  
• Know how to CREATE temporary tables and how to use them within TRIGGERs and PROCEDUREs
  
• Know how to CREATE custom TYPEs.
  
• Know how to perform error-handling in the particular RDBMS
  
• Know how COMMIT works and how to COMMIT multiple transactions within a single PROCEDURE or TRIGGER.
  
• Know how to both create and read an Entity-Relationship Diagram via Crow's Foot Notation or UML.
  
  I'm running out of stuff, I probably missed a shit-ton, but this should at least be a good starter.
  
  __
  
  Additionally, the Microsoft 70-761 Certification is a good introduction to SQL and T-SQL (Microsoft SQL Server). You can find the exam reference here.
  
  If reading books is your thing (it probably is) then I'd highly recommend getting a subscription to O'Reilly Learning (formerly Safari Books Online). It has a massive collection of technical book resources.
  
  ____
  
  From a Data Analysis/Data Scientist standpoint (please know that Data Scientist job requirements are usually a required MS in Applied Math or Statistics, with a preferred PhD). there are a few resources:
  
  DataCamp
  
  Data Scientist Specialization on Coursera
  
  DataQuest
  
  You can find raw data sets to play around with at the following locations:
  
  Kaggle
  
  Data.gov
  
  /r/datasets
  
  Also, /r/dataisbeautiful may be of interest to you :)