DataCamp
FreeIntroduction to SQL Server
4.8(403)171k studentsBEGINNEREnglish
Korshub's take
The Korshub Take
Microsoft SQL Server is an enterprise staple for database management and analytics. This beginner course provides a practical, hands-on introduction to T-SQL (Transact-SQL), teaching you how to query datasets, manipulate text, aggregate metrics, and join multiple tables across real-world datasets.
Who It's For
Data analysts, database administrators, and business analysts seeking practical experience querying Microsoft SQL Server databases.
Key Takeaways
- Data Retrieval with SELECT: Master the structure of SELECT statements to query, filter, and sort SQL Server tables.
- Aggregation & Text Functions: Calculate summary metrics with COUNT, SUM, AVG, and format strings with T-SQL string functions.
- Joining Multiple Tables: Combine data across related tables using INNER and OUTER JOINs to construct unified analytics queries.
About this course
Master the basics of Microsoft SQL Server—one of the world's most popular database systems.
This course covers:
✓ How to use SELECT statements to retrieve data
✓ How to use SQL Server aggregate functions
✓ How to manipulate text fields
✓ How to retrieve data from multiple sources
✓ All of the key aspects of working with data in SQL Server
Each time you're introduced to a new concept or function, you'll have the opportunity to test your knowledge and build your confidence. You'll work with a digital media database to review the sales of various artists and tracks, Eurovision datasets, and review trends in US power outages to explore a number of different data types and scenarios.
This course covers:
✓ How to use SELECT statements to retrieve data
✓ How to use SQL Server aggregate functions
✓ How to manipulate text fields
✓ How to retrieve data from multiple sources
✓ All of the key aspects of working with data in SQL Server
Each time you're introduced to a new concept or function, you'll have the opportunity to test your knowledge and build your confidence. You'll work with a digital media database to review the sales of various artists and tracks, Eurovision datasets, and review trends in US power outages to explore a number of different data types and scenarios.
Price
Free
Advertisement
