حالت شب

پرس و جو از Microsoft SQL Server 2019

Turn data into information with queries
01:01
What you should know
00:38
Download the sample database
02:02
Exploring the code challenge environment
01:54

Solution: Query information from a database
05:28
What is Transact SQL?
02:31
The SQL querying environment
05:34
Return records with SELECT and FROM
07:39
Filter records with WHERE
05:05
Sort records with ORDER BY
02:25
Column aliases
02:22
Create values with constants
03:40

Solution: Filter results from a query result
04:22
Limit results with TOP
04:05
Remove duplicates with DISTINCT
02:57
Comparison operators
03:28
Understand NULL values
04:26
Match text with LIKE and wildcards
04:18

Solution: Join data in multiple tables
04:01
Table joins and relationships
03:04
Inner joins
07:19
Left, right, and full outer joins
04:25
Cross joins
04:02

Solution: Group rows and aggregate data
03:47
Understand record grouping
02:26
Use GROUP BY and COUNT
04:49
Aggregate functions
02:28
Explore data with SUM
07:08
Filter groups with HAVING
03:22

Use functions in T-SQL
02:46
Solution: Use functions in a query
04:20
String functions
03:24
Text concatenation
03:33
Round with mathematical functions
02:46
Work with date functions
04:53
FORMAT date and times
02:59
Return random records with NEWID
02:02
The IIF logical function
03:09

Change database context with USE
02:24
Add comments to a script
03:09
When to use square brackets
01:30

Solution: Obtain information with a subquery
05:35
What is a subquery?
04:23
Use a subquery in a WHERE clause
04:55
Correlated subqueries
04:58
PIVOT the result set
04:03

Create and use variables in a query
04:15
Create a counter for a looping statement
03:37

Combine results with UNION
02:30
Return distinct rows with EXCEPT
03:42
Return common rows with INTERSECT
03:37

Next steps
01:25

00:00

00:00

Hello, world! This is a toast message.

درصورتیکه بیش از 70% یک محتوا را مشاهده نمایید، به صورت تمام شده در نظر گرفته می شود.