SQL Querying for Beginners Tutorial

246,993
0
2022-01-07に共有
SQL Querying for Beginners Tutorial

Get Ad-Free Training by becoming a member today!
youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join

Exercise Files: bit.ly/3n5sr0G

SQL Express Download Link:
www.microsoft.com/en-us/Download/details.aspx?id=1…

Northwindsql Link:
raw.githubusercontent.com/microsoft/sql-server-sam…

Northwind Alternate: bit.ly/3sIvodn

If you are having issues with the Northwind DB pleases delete lines 24 and 25 and execute.

Who it's for: This course has been designed for individuals who wish to learn how to use SQL to query databases and extract information.

What it is: SQL stands for Structured Query Language. It’s a common language for gathering, organizing, and exporting data stored in relational databases.

What you'll learn: In this course, you’ll learn basic SQL usage and terminology, as well as how to execute simple queries and queries using criteria conditions. Next, you’ll learn how to summarize, organize, and export valuable query data and results.

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
www.learnitanytime.com/

For Private Group Trainings please visit:
www.learnit.com/private-group-classes-workshops

Manuals: bit.ly/30xZb59
Username: manuals
Password: password

Start 0:00
Introduction 0:03
Introduction to SQL 0:30
Installing SQL Server 4:27
SQL Keyword Command Language and Hierarchy 8:26
Connecting to a SQL Database 13:35
Creating and Saving a Query 22:44
Using One or More Query Conditions 32:43
Applying AND OR Operators 40:36
NULL NOT NULL 46:48
Range of Values 49:28
Querying Data Using Wildcard Characters 58:04
Formatting Column Headings with Aliases 1:04:48
Formatting Query Data Results 1:10:06
Performing Date Calculations - DateDifDateAdd 1:14:10
Summarizing Data Using Aggregate Functions AVG COUNT SUM min max 1:22:39
Manipulating Text Results with String Functions CONCAT_SUBSTR 1:30:26
Sorting Data Order BY and GROUPBY 1:38:07
RANK and HAVING 1:46:24
Mathematical Financial Expressions 1:52:23
PIVOT 1:58:24
JOIN 2:07:27
Union ALL 2:20:30
Except Clause 2:26:30
Sub Queries 2:28:25
Exports 2:40:41
Conclusion 2:44:04

#SQL #Query

(C) 2022 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.

コメント (21)
  • To anyone unable to see the Northwind Database on the left side of the screen: (i) Rigth click on the folder "Databases" -> "New Database..." (ii) On "Database name" write Northwind and click OK (iii) Click "New Query", paste and execute the script Thanks lolo for the great tip! If you are having issues downloading the northwind file please use this online practice lab: www.sql-practice.com/
  • @sepegden
    This instructor is probably the best I've seen so far. This course was at the right pace, and the right subject matter and has been such a great help. Thanks so much
  • OMG - perfect diction! Thank you Christina!! Some of the folks on here I cannot understand for they speak about 10,000 mph! Best and thank you for your time! Mort
  • Thank you very much for making this tutorial, it really helped me out! Many tutorials out there just can't compete with your level of quality. Can't wait for intermediate and advanced tutorials! I hope they will be in the foreseeable future :)
  • Very good video for a refresher! I was able to quickly pick up from where I left when I began learning SQL. Thank you for such a great content. You're awesome.
  • Great instructor! Thank you so much for this course, Christina. Your guidance has been invaluable and truly appreciated
  • WOW What a best instructor! this is the most comprehensible SQL tutorial I have came across so far !✅✅✅
  • Excellent instructor. Crystal clear explanation! Please add SQL queries intermediate, advanced, expert and database design with her. Dan McAllister also was an amazing instructor. Keep up the good work.
  • We can't wait for more advanced tutorials by your state-of-the-art tutors like captain Dan McAllister ( the man with a gorgeously coarse voice),Sean Bugler (eloquent man), ma'am Chelsea Dohman (a sweetheart s voice), etc. They made me a programmer. God bless learnit
  • @lorik9940
    Wow. What a great course! Good job😄 I learned the basics of sql in 3 days and ready to go. Thanks!!
  • @samnako
    Guys, the instructor here is awesome. Her explanations on sql concepts are excellent. She made me develop a strong desire for sql. Its often been confusing all along in years past. For the first time i saw there is a fine line separating sql from php though they both go together in my choice of programming. For the first time i wrote sql statements and ran them on the phpmyadmin environment and also saw a button that can help me generate the php code of sql. Madam, i can't thank you enough. You are a 5 star GENERAL in the teaching of sql. You made it less frustrating and less intimidating. This is what a teacher looks like. Thank you again ma, i had to come back here after a week to give you this feedback, review and to subscribe to your channel. God bless you richly with more wisdom.
  • Very great SQL course and very specific. Thanks for sharing.
  • @lori3248
    You guys make such good courses. I could learn anything explained by you.
  • Very good tutorial, straightforward.....have learnt alot. Waiting patiently for the intermediate and advanced Sql tutorial from this Channel.🙏🙏👏👏
  • @1982epm
    Greattt, especially for me who is self-taught because I got a job as an IT Consultant DBA Now I have become proficient in MSSQL queries. But there are still some that I don't fully understand. This content has really helped me a lot. If I may request, I want to see the content of always on replication
  • i love it! looking forward intermediate and advanced sessions as well. thankyou so much for the open upload of such quality content <3
  • Cant Wait for your full SQL course!!! so exited!!! 🤩🤩🤩
  • Pretty neat, simple, and well-explained! Thanks for this tutorial! It helps me a lot!
  • This is an incredible tutorial. I'm at the 1:57:00 mark and have already learned so much. Well done on teaching this!
  • @box5329
    Very clear lecture and easy to follow, thank you ! 👍