Learning SQL Server 2016

Question

Learning SQL Server 2016

fluis

SSC Veteran

Points: 217
More actions
April 12, 2022 at 1:25 pm

#4014556
Hi there,
I am looking to find some very good beginner resources for SQL server 2016 as we have to use that at work. I dont have much experience with databases, apart from some https://routerlogin.uno/ very basic SQL knowledge. I searched on Lynda, Pluralsight and Edx. But I dont know which course would give me a solid knowledge on sql server 2016 so that I can build on top of that. Can someone please suggest one ?
- This topic was modified 2 years, 5 months ago by fluis.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

homebrew01 SSC Guru Points: 55454 More actions · Answer 1

How is SQL used at your workplace ? Are you looking for Administration or Developer skills ?

SQL has so many different areas, it would be good to focus on what's relevant to you, and not spend hours learning things you'll never use.

Do you have a "sandbox" area you can use, far away from production, so you can learn & practice ?

This reply was modified 2 years, 5 months ago by homebrew01.

ScottPletcher SSC Guru Points: 100262 More actions · Answer 2

(1) Download SQL Server Developer Edition. (Hint: it's free!)

(2) Get books by Itzik Ben-Gan (for T-SQL learning) or, for DBA/system learning, the "Inside SQL Server" books by MS.

(3) Do the examples in the book(s) using the Developer instance(s).

SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 3

fluis wrote:

Hi there,
I am looking to find some very good beginner resources for SQL server 2016 as we have to use that at work. I dont have much experience with databases, apart from some very basic SQL knowledge. I searched on Lynda, Pluralsight and Edx. But I dont know which course would give me a solid knowledge on sql server 2016 so that I can build on top of that. Can someone please suggest one ?

In my humble opinion, W3 Schools' free site is one of the fastest, easiest, and best ways to learn about SQL. Just understand that it covers T-SQL (SQL Server), PL/SQL (Oracle), Postgres, and, IIRC, MySQL and they each have their own dialect on a whole lot of things.

https://www.w3schools.com/sql/

And, yes, download the SQL Server Developer Edition and SQL Server Management Studio. Learn how to use "Help" in SQL Server Management Studio.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions

Grant Fritchey SSC Guru Points: 397721 More actions · Answer 4

On this web site, if you look at the top of the screen, are a series of lessons, utterly free, called Stairways. They cover things from T-SQL querying to backups and a whole lot more. That's a great place to start learning.

And, as everyone else says, get the developer edition. Costs nothing. Get SQL Server Management Studio or Azure Data Studio. Both cost nothing. You can start learning from there.

----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software