Beginner to T-SQL [Full Course]
293,974
Published 2022-04-07
For decades, T-SQL (Structured Query Language) has been the primary language for storing, retrieving, and manipulating data in databases. As greater amounts of data are imported into environments, organizations need individuals that have built their database knowledge upon strong fundamentals.
In this session, Mitchell Pearson will teach you how to get started with T-SQL quickly and efficiently. You will learn database fundamentals and concepts, then dive into writing T-SQL queries. You'll also learn how to filter, find data, and tackle writing multi-table joins. After joining our Learn with The Nerds session, you will have acquired the skills and confidence to begin writing and querying data in your very own environment!
✔ What You’ll Learn:
• What is T-SQL
• The SELECT query and its elements
• How to retrieve data and filter the data
• How to write single table queries and multi-table joins
• How to return data in an aggregated format
👉 To download your certificate of completion, visit: share.hsforms.com/10hH__MVaT_2IOvXTNq9AQA8xue
Prerequisites: (to follow along)
✔️ Download the latest version of SSMS - tinyurl.com/bdh72b3n
✔️ Download student files - share.hsforms.com/1UL7yaNt8QN-Kk1ijRjqvgQ8xue
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: prag.works/lwtn-trial
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-training/hackathons/
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-mentoring/
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-training/customized-ent…
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: twitter.com/PragmaticWorks
✔️Facebook: www.facebook.com/pragmaticworks/
✔️Instagram: www.instagram.com/pragmatic.works
✔️LinkedIn: www.linkedin.com/company/pragmaticworks
✔️YouTube: youtube.com/pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: [email protected]
#PragmaticWorks #MitchellPearson #Training #Microsoft #TSQL #QueryLanguage #LearnWithTheNerds
**Any sale mentioned in the video are no longer valid. Offers are subject to change with/without notice and are for a limited time only.
~-~~-~~~-~~-~
Please watch: "(275) Free Pragmatic Works Power Apps Component Library "
• Free Power Apps Component Library - B...
~-~~-
All Comments (21)
-
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!
-
Best instructor on YouTube
-
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
-
Recently join with this company.. Employees are very responsive... Services are good also get a good response from it 👏👏
-
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
-
Great job! Everything is clear and easy even for beginners. Thank you!
-
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!
-
This class is brilliant!
-
Excellent trainer! Everything seems easy, despite its complexity! Congratulations, Mitchell Pearson!
-
Mitchell,YOU ARE THE LEGEND, GOD BLESS
-
Excellent job
-
What an amazing:) Thank you a lot
-
worked it really works. thanks so much. this video saved me hundreds of dollars on subscription.
-
Thanks!
-
Thanks. I have only started this course and already picked up a few things that were good for my revision. Subbed.
-
Super useful. Thank you very much Pragmatic Works
-
Thank you for the great content
-
I love u guys, please keep up the good work!
-
Superb tutorial very helpful and good content...many Many thanks 👍🙏 this tutorial my problem resolved
-
Agree thank you
