Viewers: in countries Watching now:
Learn how to query data from SQL Server tables. Microsoft Certified Trainer Gerry O'Brien reviews the history of SQL and relational theory, so you'll understand exactly where this data manipulation language, and Microsoft's seminal database program, got their starts. Then he shows how to query one or many different tables using SELECT statements, and filter, group, and sort the results. Next, learn how to work with special data types like dates, times, and characters. Gerry also covers advanced topics like subqueries, programming with T-SQL (Microsoft's proprietary extension for SQL), and improving query performance.
Hi, I'm Gerry O'Brien, and welcome to Querying SQL Server 2012. In this course, I'm going to introduce you to using SQL servers and data manipulation language statements focused on querying data from tables. We'll begin by looking at a history of SQL Server and relational theory to form a foundation of your SQL knowledge. Next, we'll focus on the core concepts of selecting data from single and multiple tables with a select statement and using available filters to fine-tune your queries.
We'll then see examples of grouping and sorting your results. As well as working with different data types, such as date and time. And then we'll focus on built in functions for manipulating those data types. We'll follow up with some more advanced topics on writing subqueries, and common table expressions, and then finish up with a look at transact SQL programming constructs. And performance analysis of the queries that we write. So let's get started Querying SQL Server.
There are currently no FAQs about Querying Microsoft SQL Server 2012.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.