Beginner to T-SQL [Full Course]

[@GuilhermePalazzoRodrigues]

This is awesome. I've been working with T-SQL since march and this is the training that could have made my life a lot easier. You lay out every fundamental skill that I use every day in my job, congrats!

[@PragmaticWorks]

Glad it helped!

[@rewrite__life]

Best instructor on KZbin

[@chetangupta-eq6ob]

Recently join with this company.. Employees are very responsive... Services are good also get a good response from it 👏👏

[@PragmaticWorks]

Thank you for the comment! Glad you are enjoying our content!

[@potathoe1170]

For those who didn't already know, if you click "Show More" on the description and scroll to the bottom of it there is a very helpful "Key Moments" section for those looking for timestamps. Great training! Thank you for uploading!

[@PragmaticWorks]

Thanks for watching!

[@saloriasaxon7323]

Just started the course, but will there be any time stamps in this one? It helps a lot when starting and stopping. I made these for myself which are not best examples: 0:00 - 01_Introduction 26:00 - 02_T-SQL Functions and Expressions: 59:08 - 03_null_top_distinct_where.sql 2:03:29 - 04_Joins_Union_Cast_and_Convert.sql 05_Aggregate queries.sql

[@mohamedyasin7505]

there is no T-SQL Functions and Expressions in the video, it's simple SQL!

[@inzemohd2319]

Clear, Filtered, Understandable lecture. Worth the time. Thank you so much for this. It'd be a plus if you'd have explained primary key, foreign key etc, (Not complaining, just a thought). Thanks again

[@grungeglamtealsunrise401]

Can you link a video w that info?

[@vascoandrade4688]

Excellent trainer! Everything seems easy, despite its complexity! Congratulations, Mitchell Pearson!

[@PragmaticWorks]

Thank you!

[@jmcc000]

Thanks. I have only started this course and already picked up a few things that were good for my revision. Subbed.

[@PragmaticWorks]

Glad it was helpful!

[@parthanirmalia2453]

Awesome Video for any one new to SQL

[@PragmaticWorks]

Glad you liked it! Thank you for learning with us.

[@ThePhoebe76]

Great job! Everything is clear and easy even for beginners. Thank you!

[@benaiahbasehan1082]

Very helpful as a database student ❤

[@fadwa2413]

Mitchell,YOU ARE THE LEGEND, GOD BLESS

[@luisfernandomacedo1451]

This class is brilliant!

[@JamesNjanjo]

Thank Alot Christina, eagerly waiting for intermediate and Advanced tutorials from you on the same topic..👏👏👏🙏🙏

[@LeomarLosarito]

Thank you for sharing your knowledge. More power.

[@PragmaticWorks]

Glad it was helpful!

[@jahmeheru]

Excellent job

[@tacijjola]

Super useful. Thank you very much Pragmatic Works

[@Ganeshay-09]

Superb tutorial very helpful and good content...many Many thanks 👍🙏 this tutorial my problem resolved

[@Its_Me_Butters]

I love u guys, please keep up the good work!

[@rongjerhsugm]

awesome.thanks you~

[@ManaviVideos]

Informative!!

[@PragmaticWorks]

Glad to hear it!

[@a.useronly2266]

This is so amazing and great, thanks a lot

[@PragmaticWorks]

Thanks for watching!

[@wondatowudneh6898]

Awesome !!!

[@PragmaticWorks]

Thanks!!

[@linusmuhanguzi5453]

very clear

[@haymanotachn2234]

What an amazing:) Thank you a lot

[@michaell1884]

Thanks!

[@Raisincookies55]

Thank you for the great content

[@simon3374]

A very clear tutorial. Is it possible to connect with Azuree Data studio as well? Was not able to on 24. November 2024 - or is the database no longer accessible?

[@joaofigueiredo2327]

Hello Peter, is the server still on? Thanks.

[@ronniewest5652]

Agree thank you

[@luisafernandalondonoquinte1885]

worked it really works. thanks so much. this video saved me hundreds of dollars on subscription.

[@ravijain6279]

01:28:40 (firstname, middlename, lastname - space problem - solved) Select Top 100 FirstName, MiddleName, LastName, FirstName + Coalesce(' ' + MiddleName + ' ', Null,' ') + LastName As FullNameCoalesce, Concat(FirstName + ' ', MiddleName + ' ', LastName) As fullNameConcat, FirstName + Isnull(' ' + MiddleName + ' ', ' ') + LastName As FullNameIsNull From Person.Person

[@5892432]

Hello , anyone know if the server is still available? Thanks

[@Miviene13]

2:22:30 Could you explain me why theres more for SalesPersonID? What I would expect is getting more for * if there would be some NULLS. So what might be the reason?

[@tamerjuma]

This is the greatest SQL class ever! thank you so much for the outstanding presentation and the great content. Can we still connect to the SQL database?

[@Sandroider]

Is there a history in Results / console panel to see previous query results?

[@saidakishore]

Use 3rd party tools like ssms boost

[@ishimwealin]

Thank you is there part 2

[@donnaorphan738]

Hi! Is the server still available? I'm trying to login but I get error 18456 which indicates a bad password or user name. Help!

[@ThePhoebe76]

Yes, it is. Maybe you should check the password again?

[@timtanhueco1990]

Hi! I know it's 2 years late, but where's the database set for this SQL lesson?

[@zayne968]

Hi. Where can I download the test files?

[@PragmaticWorks]

✔ Download student files - share.hsforms.com/1UL7yaNt8QN-Kk1ijRjqvgQ8xue

[@malaksayed897]

@@PragmaticWorks thanks

[@manojtalwar7407]

Hi there, I cannot connect and am getting the error "Microsoft SQL Server, Error: 18456". Is the service available? I tried the password a few times as per the pdf but no joy. Pls advise. Many thanks.

[@manojtalwar7407]

Sorry, connected now after giving the Database name.

[@Sufailps]

@@manojtalwar7407 can you help , how to connect

[@abrilgonzalez7892]

which what it is?@@manojtalwar7407

[@clpzlava8981]

question: each employee have a position, however a lot of employees keep moving around when a position becomes available. how do i track this movement?

[@austinlibal]

This is more of a data modeling problem. Slowly changing dimensions can be handled several ways and it depends on what you’re using the data for to determine if SCD 1 or 2 should be used. Most likely you would want to use SCD2 and would need to have some ETL logic built in to ensure you keep old records as well as new records with updates.

[@clpzlava8981]

thanks @@austinlibal

[@jimz6076]

The student files link has expired. Is there any other place to get the student files?

[@PragmaticWorks]

You can access the student files at share.hsforms.com/1UL7yaNt8QN-Kk1ijRjqvgQ8xue

[@jimz6076]

@@PragmaticWorks You are the best!!!

[@farazaziz-en2ph]

T-SQL 😊

[@arjunroyalnaga2588]

Ever thing is fine from your side who want to learn SQL they have spend some time to for watch this video

[@VaishnaviChauhan-f6g]

am not able to connect to database

[@Jeff-dl7pp]

Hello, I attempted to use the credentials provided in the PDF document and got an error. I have emailed the training email given in the description. Hope to hear from you all soon. Thank you.

[@Jeff-dl7pp]

disregard, updated the Connection Properties > Database , and was able to connect

[@dinarvasquez6114]

08:35

[@gaborbence6943]

this is gold. again. fantastic content, thank you, im on advanced t-sql as well, hihgly recommended to everyone. thank you Mitchell, Pragmatic Guys!

[@mohamedyasin7505]

This is not T-SQL rather it is simply SQL in the form SQL Server syntax!

[@JoshNorris52]

I'm 3 minutes into this video and found myself realizing my greatest fear would be to be across the table from someone who has written multiple textbooks on Microsoft tools and having to play them in Ticket to Ride...

[@PragmaticWorks]

That's funny 🤣🤣 - Mitchell

[@flexambassador]

Michelle pls help me , am loosing my head learning alone, pls I'd like to reach out to direct mentorships into data analysis or buisness analysis..lets discuss all i need to know and how to work on it..pls reply

[@Quitter2222]

Remove the data base and remove the business analysis

[@namilewis2820]

Whats the pw?

[@AdekunleMuritala-e9f]

Where can I download the demo file

[@PragmaticWorks]

Hi, the files can be downloaded from the description of the video. Here is the link also: share.hsforms.com/1UL7yaNt8QN-Kk1ijRjqvgQ8xue

[@julzbuzz7243]

How is this T-SQL though?🙃

[@Thomasw04]

It is. What do you mean? If it was f.e postgreSQL then i could use to_char , that statement wont work since its t-sql.

[@mohamedyasin7505]

@@Thomasw04 It's not T-SQL, rather it's simply a SQL Server version of SQL and that's why to_char didn't work with you but that doesn't mean it's T-SQL!

[@mohamedyasin7505]

it's not, it's a deceiving title!

[@RadosławJakubowski-p4g]

Hi there, I cannot connect and am getting the error "Microsoft SQL Server, Error: 18456". Is the service available? I tried the password a few times as per the pdf but no joy. Pls advise. Many thanks.