SQL Server for Beginners | A Complete Guide | Theory, Set Up, Practice Datasets & Querying
ฝัง
- เผยแพร่เมื่อ 10 ก.ค. 2023
- A complete guide to SQL for beginners: this tutorial can act as a one stop shop for understanding SQL background, how to actually start writing SQL in a database management system, getting a huge array of free data that simulates real world datasets & data models and learning the core and most widely used SQL querying functionality, as well as creating your own tables.
The specific areas I cover in this ~3 hour tutorial are as follows:
- What is SQL?
- What is SQL Server?
- Getting Started with SQL Server & SQL Server Management Studio (SSMS)
- Downloading & Importing the AdventureWorks sample database (over 50 tables)
- Navigating SSMS
- Functions for selecting, filtering and ordering data from your database
- Sampling data, commenting your code and working with NULL values
- Essential string functions
- Mathematical Operators
- Conditional logic using the CASE expression
- Grouping, aggregating, subqueries
- Creating tables and inserting & updating data
These concepts will be cemented with real world examples and commentary around applying this knowledge to data roles.
Enjoy!
🤝 Want 1:1 mentorship, data career guidance or interview prep?
topmate.io/james_andrew_matad...
🤝 Connect with me on LinkedIn:
/ ja376 - วิทยาศาสตร์และเทคโนโลยี
Thank you James! Time stamps would be amazing for this video!
Great! Thanks a lot🙏
This is amazing! I hope you make one of these for PostgreSQL too! It’s starting to get used a lot for many Applications.
Appreciate the feedback, I’ll add Postgres to my list of topics to cover!
Fabulous
Thanks! Glad you find it helpful!
Amazing! Thanks a lot 🙏
Your comment made my night, thanks Alex! Hope it’s useful for you!
Yeah thanks a lot yoooh 🙏🏿🙏🏿🥺🥺🥺🥺
My pleasure, hope it’s useful for you!
Well I’ll make sure 😅😅😅 yhooo so excited 😁😁😁