Software Development Basics
Fundamental principles and concepts
Combining and Filtering Data with T-SQL 2019
Following along with the exercise files, this course takes you from setting up the environment through writing more advanced queries using T-SQL functions, expressions, and logic.
Pluralsight Teams₹4,166.75 per user/month, billed annually
₹50,004
CompleteBilled Monthly
₹2,370/mo
Why choose Core Tech?
verifiedGet this course for free with the Coursera Plus subscription.
✓ Compare courses before making a decision
Check Latest Price →Price may vary. Check latest price on provider site.
Course Insight
Suitable for beginner learners. This course serves as an entry point into Software Development, building foundational knowledge before moving on to advanced frameworks or specialized paths.
Beginner FriendlySelf-Paced Learning
SKILLS TO
MASTER
Practical ApplicationTrending
Real-world project implementationBest Practices
Industry standard workflows and guidelinesCareers:Relevant for professionals pursuing roles within Software Development.
Quick Facts
Below sections are verified from last major sync. For real-time updates and today's latest lectures, Check official page here.
What You’ll Learn
Take your skills beyond the basics of T-SQL by learning how to apply the functionality T-SQL has to offer. In this course, Combining and Filtering Data with T-SQL, you will learn foundational knowledge of how to work with data and T-SQL. First, you will learn how to format and calculate data, and about logic functions. Next, you will discover how to join data from two or more tables. Finally, you will explore how to aggregate data to find the sum, minimum, maximum, count, and average values, as well as learn about intermediary tables. When you are finished with this course, you will have the skills and knowledge to write queries, validate results from a query, and work with variables.
See how this course curriculum compares with alternatives
Outcomes
- Course Overview : 2mins.
- Setting up the SQL Server Environment : 22mins.
- Shaping Data in a Query : 48mins.
- Querying Data from Multiple Tables Using JOINS : 26mins.
- Filtering and Controlling Flow : 31mins.
- Limiting the Results with T-SQL Functions : 15mins.
- Aggregating Data in a Query : 27mins.
- Using T-SQL Set Operators : 13mins.
- Simplifying with Intermediate Tables and Common Table Expressions : 19mins.
- Summary : 0mins.
See side-by-side differences in learning outcomes
FAQs
Top Alternatives
Highly-rated courses worth your attention
⭐ 4(210+ learners)