Reddit reviews T-SQL Fundamentals
We found 10 Reddit comments about T-SQL Fundamentals. Here are the top ones, ranked by their Reddit score.
Microsoft Press
We found 10 Reddit comments about T-SQL Fundamentals. Here are the top ones, ranked by their Reddit score.
If you want to get serious and take it to the next level you should check out Microsoft SQL certification.
https://www.amazon.com/T-SQL-Fundamentals-3rd-Itzik-Ben-Gan/dp/150930200X/ref=mp_s_a_1_6?keywords=Microsoft+sql&qid=1558398701&s=gateway&sr=8-6
The author is amazing. He also has some good videos on MSDN or Microsoft Learning.
Re-iterating what the previous posters said: the fundamentals are the same regardless of system. Learning how to get data out of a SQL system is all about learning how to write SQL.
To effectively learn how to write SQL for data engineering, I highly recommend grabbing a book like one of these*:
and grabbing a sample database for the system of your choice:
and then practice some of your chosen book on the sample db.
Notes and words of warning:
^((*I'm not affiliated w/ any of those books))
I started learning SQL by reading Itzik Ben-Gan's T-SQL Fundamentals. It's a fantastic text that I read cover to cover. One of the chapters on ACID was extremely boring (that's mostly DBA stuff) but other than that I thought it was very interesting. Microsoft also has an EdX course that's similar to the book if you'd prefer to use that.
As far as applying it goes, I set up multiple databases. So I had SQL Server, postgres, Access, and SQLite. I didn't get to apply it at my last job, but our DBA was comfortable enough with my knowledge to create a schema for me so that I could use postgres instead of having to use MS Access. I also personally found that employers were fairly impressed by it.
I'm in the process of learning SQL myself. I can write queries but I'm a beginner; taking Microsoft's 761 SQL exam at the end of the month...
I'm using two things to study for the exam:
-Free class in edx.org
-Book in T-SQL Fundamentals with exercises, $40 bucks
This is just what I've been using. T-SQL is the Microsoft flavor of SQL. I checked out the W3Schools website that someone suggested and it looks really good. Between that and the edx.org class (free) you will be up and running.
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
I'd recommend this as a starting place: https://www.amazon.com/T-SQL-Fundamentals-3rd-Itzik-Ben-Gan/dp/150930200X/
I ran into a similar conundrum. If you read the 70-461 or T-SQL Fundamentals, they have practice problems that are related. The 70-761 does not contain practice testing material.
Apart from that, it's recommended to do the more official practice tests if you decide you need one. They are supposed to be more difficult than the real test, but I do not have any experience taking the practice tests. I am thinking of trying the 762 practice test though.
I did use one other resource that was a practice test and I'll list it below, but here's a copy from my site that lists my favorite resources from when I studied for my 761.
My favorite resources:
https://www.cathrinewilhelmsen.net/2015/01/28/preparing-for-and-taking-exam-70-461-querying-microsoft-sql-server-2012/
https://www.mssqltips.com/sqlservertip/4644/sql-server-exam-70761-study-material-for-querying-data-with-transactsql/
https://www.amazon.com/T-SQL-Fundamentals-3rd-Itzik-Ben-Gan/dp/150930200X
https://www.amazon.com/Training-70-461-Querying-Microsoft-Server/dp/0735666059/ref=sr_1_1?ie=UTF8&qid=1513628070&sr=8-1&keywords=70%3D461
https://www.amazon.com/Exam-70-761-Querying-Data-Transact-SQL/dp/1509304339/ref=sr_1_1?s=books&ie=UTF8&qid=1513628083&sr=1-1&keywords=70-761
http://www.accelerated-ideas.com/70761-practice-test-questions.aspx#.WeeTWVtSypo
https://www.mssqltips.com/sqlservertip/4015/introducing-json-for-sql-server-2016/
https://www.mssqltips.com/sqlservertip/4073/sql-server-2016-advanced-json-techniques--part-1/
https://docs.microsoft.com/en-us/sql/relational-databases/json/json-data-sql-server
https://www.mssqltips.com/sqlservertip/3680/introduction-to-sql-server-2016-temporal-tables/
https://docs.microsoft.com/en-us/sql/t-sql/queries/select-group-by-transact-sql
https://www.mssqltips.com/sqlservertip/1958/sql-server-cross-apply-and-outer-apply/
My blog is advertised on my stack overflow account and github, all three are circular and refer to each other. I've kept my reddit account separate on purpose for identifiable reasons.
I'm still toying with the idea of posting occasional blog posts or creating a reddit account to link to my other social medias to help build a base. At the moment, the blog is really intended for employers and myself and it is not based on trying to accumulate or direct web traffic.
So while I'm happy to share my information, I don't want to link it from this account.
> It's incredibly generous and secure of you to actually share your notes and progress.
The notes are usually pretty barebones. Here's an example of the kind of information in my google sheet:
5/22/18
5/23/18
Then if I have done any work / notations, I add them to a folder and upload them to my github.
If you are interested in other examples of how I did things, let me know specifically and I can get you a scrubbed / masked version. Here's my list of recommended resources that appears in my 762 study guide though:
Exam 70-762
Exam policies and FAQ
Course 20762B: Developing SQL Databases
https://www.mssqltips.com/sqlservertip/4690/study-materials-for-developing-sql-databases-exam-70762/
https://www.amazon.com/T-SQL-Fundamentals-3rd-Itzik-Ben-Gan/dp/150930200X
https://www.amazon.com/T-SQL-Querying-Developer-Reference-Ben-Gan/dp/0735685045/ref=pd_lpo_sbs_14_t_0/138-3143892-2208566?_encoding=UTF8&psc=1&refRID=E5CA9HQ5WEXP7RPBE1B1
https://www.amazon.com/Pro-Server-Internals-Dmitri-Korotkevitch/dp/1484219635/ref=sr_1_1?s=books&ie=UTF8&qid=1520887778&sr=1-1&keywords=sql+server+internal+pro
First step will be to become proficient in SQL.
https://smile.amazon.com/T-SQL-Fundamentals-3rd-Itzik-Ben-Gan/dp/150930200X/ref=sr_1_1?ie=UTF8&qid=1483188942&sr=8-1
and/or
https://smile.amazon.com/Oracle-Database-Fundamentals-Guide-1Z0-061-ebook/dp/B00IA4J97S/ref=sr_1_1?s=books&ie=UTF8&qid=1483188985&sr=1-1
This, and this.