We may earn an affiliate commission when you visit our partners.
Combining and Filtering Data with T-SQL 2019
Tamara Pattinson
Tamara Pattinson
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.
Read more
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.
Read more
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.
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/c2opgf/combining
What's inside
Syllabus
Course Overview
Setting up the SQL Server Environment
Shaping Data in a Query
Querying Data from Multiple Tables Using JOINS
Read more
Syllabus
Course Overview
Setting up the SQL Server Environment
Shaping Data in a Query
Querying Data from Multiple Tables Using JOINS
Read more
Filtering and Controlling Flow
Limiting the Results with T-SQL Functions
Aggregating Data in a Query
Using T-SQL Set Operators
Simplifying with Intermediate Tables and Common Table Expressions
Summary
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Provides a foundational understanding of T-SQL, including formatting, calculations, and logic functions
Covers essential T-SQL techniques for joining data from multiple tables using JOINS
Builds on foundational knowledge to explore advanced T-SQL functions, expressions, and logic
Incorporates hands-on exercises to reinforce learning and provide practical application
Taught by experienced instructor Tamara Pattinson
Suitable for both beginners and intermediate learners looking to enhance their T-SQL skills
Save this course
Save Combining and Filtering Data with T-SQL 2019 to your list so you can find it easily later:
Save
Save
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Combining and Filtering Data with T-SQL 2019 with these
activities:
Follow a T-SQL tutorial for beginners
Show steps
Enhance foundational understanding of T-SQL by following a beginner-friendly tutorial.
Show steps
-
Search for a comprehensive T-SQL tutorial for beginners
-
Follow the tutorial step-by-step, completing all exercises and examples
Review T-SQL Functions and Expressions
Show steps
Review foundational knowledge of SQL function and expressions to better prepare for the course.
Browse courses on
T-SQL Functions
Show steps
-
Review documentation on T-SQL functions and expressions
-
Complete practice exercises on T-SQL functions and expressions
Complete T-SQL coding exercises
Show steps
Reinforce T-SQL skills through repetitive coding exercises.
Show steps
-
Find a reputable platform or resource offering T-SQL coding exercises
-
Solve coding exercises of varying difficulty levels to challenge your understanding
Four other activities
Expand to see all activities and additional details
Show all seven activities
Solve T-SQL logic puzzles
Show steps
Develop problem-solving skills in T-SQL by engaging in logic puzzles.
Show steps
-
Locate resources or websites that provide T-SQL logic puzzles
-
Attempt to solve logic puzzles of varying complexity and difficulty levels
Join a T-SQL study group or online forum
Show steps
Engage with peers to discuss T-SQL concepts and reinforce learning.
Show steps
-
Identify and join an active T-SQL study group or online forum
-
Participate in discussions, ask questions, and share knowledge with other learners
Build a T-SQL project to demonstrate your skills
Show steps
Apply your T-SQL skills in a practical project to solidify your understanding.
Show steps
-
Identify a real-world problem or scenario that can be solved using T-SQL
-
Design and develop a T-SQL solution to address the identified problem
-
Test and refine your solution to ensure accuracy and efficiency
Contribute to open-source T-SQL projects
Show steps
Deepen your understanding of T-SQL and contribute to the community by participating in open-source projects.
Show steps
-
Identify open-source T-SQL projects that align with your interests and skill level
-
Review the project documentation and identify areas where you can contribute
-
Make meaningful contributions to the project, such as bug fixes, feature enhancements, or documentation improvements
Follow a T-SQL tutorial for beginners
Show steps
Enhance foundational understanding of T-SQL by following a beginner-friendly tutorial.
Show steps
Show steps
Show steps
- Search for a comprehensive T-SQL tutorial for beginners
- Follow the tutorial step-by-step, completing all exercises and examples
Review T-SQL Functions and Expressions
Show steps
Review foundational knowledge of SQL function and expressions to better prepare for the course.
Browse courses on
T-SQL Functions
Show steps
Show steps
Show steps
- Review documentation on T-SQL functions and expressions
- Complete practice exercises on T-SQL functions and expressions
Complete T-SQL coding exercises
Show steps
Reinforce T-SQL skills through repetitive coding exercises.
Show steps
Show steps
Show steps
- Find a reputable platform or resource offering T-SQL coding exercises
- Solve coding exercises of varying difficulty levels to challenge your understanding
Four other activities
Expand to see all activities and additional details
Show all seven activities
Solve T-SQL logic puzzles
Show steps
Develop problem-solving skills in T-SQL by engaging in logic puzzles.
Show steps
Show steps
Show steps
- Locate resources or websites that provide T-SQL logic puzzles
- Attempt to solve logic puzzles of varying complexity and difficulty levels
Join a T-SQL study group or online forum
Show steps
Engage with peers to discuss T-SQL concepts and reinforce learning.
Show steps
Show steps
Show steps
- Identify and join an active T-SQL study group or online forum
- Participate in discussions, ask questions, and share knowledge with other learners
Build a T-SQL project to demonstrate your skills
Show steps
Apply your T-SQL skills in a practical project to solidify your understanding.
Show steps
Show steps
Show steps
- Identify a real-world problem or scenario that can be solved using T-SQL
- Design and develop a T-SQL solution to address the identified problem
- Test and refine your solution to ensure accuracy and efficiency
Contribute to open-source T-SQL projects
Show steps
Deepen your understanding of T-SQL and contribute to the community by participating in open-source projects.
Show steps
Show steps
Show steps
- Identify open-source T-SQL projects that align with your interests and skill level
- Review the project documentation and identify areas where you can contribute
- Make meaningful contributions to the project, such as bug fixes, feature enhancements, or documentation improvements
Career center
Learners who complete Combining and Filtering Data with T-SQL 2019 will develop knowledge and skills
that may be useful to these careers:
Data Engineer
Data Engineer
Data Engineers are responsible for designing, building, and maintaining data pipelines that enable organizations to collect, process, and analyze vast amounts of data. This course introduces T-SQL, a powerful language for data manipulation and transformation. By becoming proficient in T-SQL, you can excel as a Data Engineer, building efficient and scalable data pipelines that support data-driven decision-making.
ETL Developer
ETL Developer
ETL Developers design and implement data pipelines that extract, transform, and load data from various sources into a target data warehouse or database. This course introduces T-SQL, a powerful language for data integration and transformation. By becoming proficient in T-SQL, you can excel as an ETL Developer, building efficient and reliable data pipelines that support data-driven decision-making.
Technical Data Analyst
Technical Data Analyst
Technical Data Analysts combine technical skills with analytical expertise to derive insights from data. This course provides a solid foundation in T-SQL, a widely used language for data analysis and modeling. By mastering T-SQL, you can become a more effective Technical Data Analyst, capable of cleaning, manipulating, and analyzing data to identify trends, patterns, and anomalies.
Data Analyst
Data Analyst
Data Analysts play a crucial role in extracting insights from vast amounts of data. This course provides a strong foundation in T-SQL, empowering you to write efficient queries, aggregate and analyze data, and draw meaningful conclusions. With these skills, you can succeed as a Data Analyst, transforming raw data into valuable insights that drive informed decision-making.
Data Warehouse Engineer
Data Warehouse Engineer
Data Warehouse Engineers are responsible for designing, building, and maintaining data warehouses that store and manage large volumes of data for analysis and reporting. This course provides a strong foundation in T-SQL, enabling you to understand the principles of data warehousing and develop efficient data warehouse solutions. By mastering T-SQL, you can succeed as a Data Warehouse Engineer, ensuring that data warehouses are optimized for performance and scalability.
Database Architect
Database Architect
Database Architects design and implement database systems that meet the specific needs of an organization. This course provides a strong foundation in T-SQL, enabling you to understand the intricacies of database design and optimization. By mastering T-SQL, you can succeed as a Database Architect, ensuring that database systems are efficient, scalable, and aligned with business requirements.
Data Scientist
Data Scientist
Data Scientists leverage data to solve complex business problems and make data-driven decisions. This course provides a solid foundation in T-SQL, a widely used language for data analysis and modeling. By mastering T-SQL, you can become a more effective Data Scientist, capable of extracting insights from vast amounts of data and developing predictive models that drive business value.
Database Administrator
Database Administrator
Database Administrators are tasked with managing, monitoring, and maintaining database systems, ensuring optimal performance and data integrity. This course can help you build a strong foundation in T-SQL, a widely used database programming language, equipping you with the skills to effectively design, implement, and manage database solutions as a Database Administrator.
Market Researcher
Market Researcher
Market Researchers gather and analyze data to understand market trends, customer behavior, and industry dynamics. This course provides a solid foundation in T-SQL, a widely used language for data analysis and modeling. By mastering T-SQL, you can become a more effective Market Researcher, capable of cleaning, manipulating, and analyzing data to identify market opportunities and develop data-driven strategies.
Business Intelligence Developer
Business Intelligence Developer
Business Intelligence Developers are responsible for designing and developing business intelligence solutions that help organizations gain insights from their data. This course introduces T-SQL, a powerful tool for data manipulation and analysis. By mastering T-SQL, you can excel as a Business Intelligence Developer, creating data-driven solutions that empower businesses to make strategic decisions.
Business Analyst
Business Analyst
Business Analysts help organizations improve their performance by analyzing business processes and recommending solutions. This course provides a solid foundation in T-SQL, a powerful language for data analysis and reporting. By mastering T-SQL, you can become a more effective Business Analyst, capable of extracting insights from data, identifying areas for improvement, and developing data-driven recommendations.
Information Security Analyst
Information Security Analyst
Information Security Analysts are responsible for protecting an organization's information systems from security breaches and threats. This course introduces T-SQL, a powerful tool for data security and auditing. By gaining proficiency in T-SQL, you can enhance your ability to detect and prevent security incidents, making you a valuable asset as an Information Security Analyst.
Operations Research Analyst
Operations Research Analyst
Operations Research Analysts use mathematical and analytical techniques to solve complex business problems and improve operational efficiency. This course introduces T-SQL, a powerful language for data manipulation and analysis. By gaining proficiency in T-SQL, you can enhance your ability to build optimization models, perform data analysis, and make data-driven decisions, making you a valuable asset as an Operations Research Analyst.
Quantitative Analyst
Quantitative Analyst
Quantitative Analysts use mathematical and statistical techniques to analyze financial data and make investment decisions. This course introduces T-SQL, a powerful language for data manipulation and analysis. By gaining proficiency in T-SQL, you can enhance your ability to build financial models, perform data analysis, and make data-driven investment decisions, making you a valuable asset as a Quantitative Analyst.
Software Developer
Software Developer
Software Developers play a vital role in creating and maintaining software applications. This course provides a solid foundation in T-SQL, a widely used database programming language. By enhancing your T-SQL skills, you can become a more versatile and effective Software Developer, capable of working with relational databases and integrating them into software applications.
For more career information including salaries, visit:
OpenCourser.com/course/c2opgf/combining
Reading list
We've selected eight books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Combining and Filtering Data with T-SQL 2019.
Provides practical guidance on how to optimize SQL Server performance, including tips on indexing, query optimization, and hardware tuning.
Save
Comprehensive reference for SQL, covering all major dialects, including T-SQL.
Good starting point for beginners who want to learn T-SQL.
Save
Focuses on T-SQL querying, covering advanced techniques such as subqueries, joins, and window functions.
Provides a comprehensive overview of T-SQL programming and database administration.
Good starting point for beginners who want to learn SQL Server.
Provides a comprehensive overview of SQL performance tuning, including tips on indexing, query optimization, and hardware tuning.
Provides a comprehensive overview of T-SQL 2019 administration, including topics such as installation, configuration, and maintenance.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/c2opgf/combining
Share
Similar courses
Here are nine courses similar to
Combining and Filtering Data with T-SQL 2019.
T-SQL Functions Playbook
OpenCourser.com/course/gm6un2/t
T-SQL Functions Playbook
Most relevant
Querying Data Using T-SQL
OpenCourser.com/course/crrt4c/querying
Querying Data Using T-SQL
Most relevant
70-461, 761: Querying Microsoft SQL Server with Transact-SQL
OpenCourser.com/course/qq8nay/70
70-461, 761: Querying Microsoft SQL Server with Transact...
Most relevant
Querying Data with SQL Server
OpenCourser.com/course/imlmgt/querying
Querying Data with SQL Server
Most relevant
Understanding Query Optimization in SQL Server
OpenCourser.com/course/og3xif/understanding
Understanding Query Optimization in SQL Server
Most relevant
Capturing Logic with Stored Procedures in T-SQL
OpenCourser.com/course/po7fli/capturing
Capturing Logic with Stored Procedures in T-SQL
Most relevant
Retrieve Data with Multiple-Table SQL Queries
OpenCourser.com/course/unmbxw/retrieve
Retrieve Data with Multiple-Table SQL Queries
Most relevant
Troubleshooting Your First Low-performing T-SQL Query
OpenCourser.com/course/2hdz5x/troubleshooting
Troubleshooting Your First Low-performing T-SQL Query
Most relevant
Effective Query Analysis with SQL Server Tools
OpenCourser.com/course/2g9ivm/effective
Effective Query Analysis with SQL Server Tools
Most relevant
Time
207 hours
Level
Introductory
Via
Pluralsight
Instructor
Tamara Pattinson
Language
English
This course belongs to a
collection
called
Querying Data with T-SQL from SQL Server. It's comprised of seven courses:
- Querying Data Using T-SQL
- Combining and Filtering Data with T-SQL 2019 (viewing)
- T-SQL Data Manipulation Playbook
- Capturing Logic with Stored Procedures in T-SQL
- Querying JSON, XML, and Temporal Data with T-SQL
- Handling Errors in T-SQL
- T-SQL Functions Playbook
Good to know
Provides a foundational understanding of T-SQL, including formatting, calculations, and logic functions
Covers essential T-SQL techniques for joining data from multiple tables using JOINS
Builds on foundational knowledge to explore advanced T-SQL functions, expressions, and logic
Incorporates hands-on exercises to reinforce learning and provide practical application
Taught by experienced instructor Tamara Pattinson
Suitable for both beginners and intermediate learners looking to enhance their T-SQL skills
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser