Тёмный

Beginner to T-SQL [Full Course] 

Pragmatic Works
Подписаться 221 тыс.
Просмотров 294 тыс.
50% 1

✔ Overview:
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_...
Prerequisites: (to follow along)
✔️ Download the latest version of SSMS - tinyurl.com/bdh72b3n
✔️ Download student files - share.hsforms.com/1UL7yaNt8QN...
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
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-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/

Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️RU-vid: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
#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 Compon...
~-~~-~~~-~~-~

Опубликовано:

 

6 апр 2022

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 75   
@GuilhermePalazzoRodrigues
@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
@PragmaticWorks Год назад
Glad it helped!
@rewrite__life
@rewrite__life 2 года назад
Best instructor on RU-vid
@saloriasaxon7323
@saloriasaxon7323 2 года назад
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
@chetangupta-eq6ob
@chetangupta-eq6ob Год назад
Recently join with this company.. Employees are very responsive... Services are good also get a good response from it 👏👏
@PragmaticWorks
@PragmaticWorks Год назад
Thank you for the comment! Glad you are enjoying our content!
@inzemohd2319
@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
@ThePhoebe76
@ThePhoebe76 Год назад
Great job! Everything is clear and easy even for beginners. Thank you!
@potathoe1170
@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
@PragmaticWorks Год назад
Thanks for watching!
@luisfernandomacedo1451
@luisfernandomacedo1451 Год назад
This class is brilliant!
@vascoandrade4688
@vascoandrade4688 Год назад
Excellent trainer! Everything seems easy, despite its complexity! Congratulations, Mitchell Pearson!
@PragmaticWorks
@PragmaticWorks Год назад
Thank you!
@fadwa2413
@fadwa2413 Год назад
Mitchell,YOU ARE THE LEGEND, GOD BLESS
@jahmeheru
@jahmeheru 2 года назад
Excellent job
@haymanotachn2234
@haymanotachn2234 2 года назад
What an amazing:) Thank you a lot
@luisafernandalondonoquinte1885
@luisafernandalondonoquinte1885 10 месяцев назад
worked it really works. thanks so much. this video saved me hundreds of dollars on subscription.
@michaell1884
@michaell1884 2 года назад
Thanks!
@johnmccourt000
@johnmccourt000 Год назад
Thanks. I have only started this course and already picked up a few things that were good for my revision. Subbed.
@PragmaticWorks
@PragmaticWorks Год назад
Glad it was helpful!
@tacijjola
@tacijjola 7 месяцев назад
Super useful. Thank you very much Pragmatic Works
@Raisincookies55
@Raisincookies55 Год назад
Thank you for the great content
@Ganeshay-996
@Ganeshay-996 9 месяцев назад
Superb tutorial very helpful and good content...many Many thanks 👍🙏 this tutorial my problem resolved
@amirrezajamadi4179
@amirrezajamadi4179 26 дней назад
I love u guys, please keep up the good work!
@LeomarLosarito
@LeomarLosarito Год назад
Thank you for sharing your knowledge. More power.
@PragmaticWorks
@PragmaticWorks Год назад
Glad it was helpful!
@ronniewest5652
@ronniewest5652 Год назад
Agree thank you
@a.useronly2266
@a.useronly2266 2 года назад
This is so amazing and great, thanks a lot
@PragmaticWorks
@PragmaticWorks Год назад
Thanks for watching!
@rongjerhsugm
@rongjerhsugm 4 месяца назад
awesome.thanks you~
@linusmuhanguzi5453
@linusmuhanguzi5453 8 месяцев назад
very clear
@wondatowudneh6898
@wondatowudneh6898 Год назад
Awesome !!!
@PragmaticWorks
@PragmaticWorks Год назад
Thanks!!
@ManaviVideos
@ManaviVideos 2 года назад
Informative!!
@PragmaticWorks
@PragmaticWorks 2 года назад
Glad to hear it!
@parthanirmalia2453
@parthanirmalia2453 7 месяцев назад
Awesome Video for any one new to SQL
@PragmaticWorks
@PragmaticWorks 6 месяцев назад
Glad you liked it! Thank you for learning with us.
@Miviene13
@Miviene13 6 месяцев назад
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?
@ravijain6279
@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
@tamerjuma
@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?
@5892432
@5892432 2 года назад
Hello , anyone know if the server is still available? Thanks
@ombotimbe
@ombotimbe Год назад
Can't connect to the server. Are the credentials still relevant?
@ishimwealin
@ishimwealin Год назад
Thank you is there part 2
@user-yr1ql1cm7w
@user-yr1ql1cm7w 11 месяцев назад
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.
@joaofigueiredo2327
@joaofigueiredo2327 Год назад
Hello Peter, is the server still on? Thanks.
@Sandroider
@Sandroider 2 года назад
Is there a history in Results / console panel to see previous query results?
@saidakishore
@saidakishore 2 года назад
Use 3rd party tools like ssms boost
@arjunroyalnaga2588
@arjunroyalnaga2588 Год назад
Ever thing is fine from your side who want to learn SQL they have spend some time to for watch this video
@Jeff-dl7pp
@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
@Jeff-dl7pp Год назад
disregard, updated the Connection Properties > Database , and was able to connect
@donnaorphan738
@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
@ThePhoebe76 Год назад
Yes, it is. Maybe you should check the password again?
@user-wn5vt7su1g
@user-wn5vt7su1g 4 месяца назад
am not able to connect to database
@zayne968
@zayne968 Год назад
Hi. Where can I download the test files?
@PragmaticWorks
@PragmaticWorks Год назад
✔ Download student files - share.hsforms.com/1UL7yaNt8QN-Kk1ijRjqvgQ8xue
@malaksayed897
@malaksayed897 Год назад
@@PragmaticWorks thanks
@farazaziz-en2ph
@farazaziz-en2ph 5 месяцев назад
T-SQL 😊
@dinarvasquez6114
@dinarvasquez6114 2 месяца назад
08:35
@clpzlava8981
@clpzlava8981 6 месяцев назад
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
@austinlibal 3 месяца назад
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
@clpzlava8981 3 месяца назад
thanks @@austinlibal
@flexambassador
@flexambassador 2 года назад
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
@Quitter2222 2 года назад
Remove the data base and remove the business analysis
@jimz6076
@jimz6076 2 месяца назад
The student files link has expired. Is there any other place to get the student files?
@PragmaticWorks
@PragmaticWorks 2 месяца назад
You can access the student files at share.hsforms.com/1UL7yaNt8QN-Kk1ijRjqvgQ8xue
@jimz6076
@jimz6076 2 месяца назад
@@PragmaticWorks You are the best!!!
@namilewis2820
@namilewis2820 Год назад
Whats the pw?
@julzbuzz7243
@julzbuzz7243 Год назад
How is this T-SQL though?🙃
@Thomasw04
@Thomasw04 11 месяцев назад
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.
@manojtalwar7407
@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
@manojtalwar7407 Год назад
Sorry, connected now after giving the Database name.
@Sufailps
@Sufailps Год назад
@@manojtalwar7407 can you help , how to connect
@abrilgonzalez7892
@abrilgonzalez7892 8 месяцев назад
which what it is?@@manojtalwar7407
Далее
SQL Tutorial for Beginners [Full Course]
3:10:19
Просмотров 11 млн
SQL Tutorial for Beginners
44:57
Просмотров 1,9 млн
Learn SQL In 60 Minutes
56:24
Просмотров 2 млн
Advanced Power BI Takeover!
2:56:16
Просмотров 176 тыс.
Learn SQL Basics in Just 15 Minutes!
16:57
Просмотров 117 тыс.
Data Modeling for Power BI [Full Course] 📊
2:34:41
Просмотров 3,1 млн
SQL Querying for Beginners Tutorial
2:45:17
Просмотров 242 тыс.