Mastering Microsoft SQL Server
40 Using GROUP BY in SQL Server
Mastering Microsoft SQL Server
0%
Completed
المحتوى
1 Introduction to SQL Server 2017
Video - 4:20 mins
1 Introduction to SQL Server 2017
Video - 4:20 mins
2 Installing SQL Server Express Edition 2017
Video - 4:20 mins
3 Installing the Northwind Database in SQL Server
Video - 4:20 mins
4 Editions of SQL Server
Video - 4:20 mins
5 SQL Server Management Studio 2017
Video - 4:20 mins
6 Differences Between DDL, DML, and DCL
Video - 4:20 mins
7 Elements of the SELECT Statement
Video - 4:20 mins
8 Retrieving Data and Filtering by Columns
Video - 4:20 mins
9 Computing Columns in SQL
Video - 4:20 mins
10 Using Alias Names in SQL
Video - 4:20 mins
11 Filtering Rows in SQL
Video - 4:20 mins
12 Sorting Data with ORDER BY
Video - 4:20 mins
13 Using DISTINCT to Remove Duplicate Data
Video - 4:20 mins
14 Understanding Schema in SQL Server
Video - 4:20 mins
15 Using CASE Expressions in SQL Server
Video - 4:20 mins
16 Using TOP in SQL Server
Video - 4:20 mins
17 Handling NULL Values in SQL Server
Video - 4:20 mins
18 Using LIKE in SQL Server
Video - 4:20 mins
19 Using IN in SQL Server
Video - 4:20 mins
20 INNER JOIN in SQL Server
Video - 4:20 mins
21 OUTER JOIN in SQL Server
Video - 4:20 mins
22 Self Join in SQL Server
Video - 4:20 mins
23 Cross Join in SQL Server
Video - 4:20 mins
24 Data Types in SQL Server
Video - 4:20 mins
25 String Function: CONCAT in SQL Server
Video - 4:20 mins
26 String Function: SUBSTRING in SQL Server
Video - 4:20 mins
27 String Function: LEN in SQL Server
Video - 4:20 mins
28 String Function: DATALENGTH in SQL Server
Video - 4:20 mins
29 String Function: CHARINDEX in SQL Server
Video - 4:20 mins
30 String Function: REPLACE in SQL Server
Video - 4:20 mins
31 String Function: LOWER and UPPER in SQL Server
Video - 4:20 mins
32 Date and Time Functions in SQL Server
Video - 4:20 mins
33 Inserting Data in SQL Server
Video - 4:20 mins
34 Updating Data in SQL Server
Video - 4:20 mins
35 Deleting and Truncating Data in SQL Server
Video - 4:20 mins
36 Overview of Data Modification in SQL Server
Video - 4:20 mins
37 String Functions in SQL Server
Video - 4:20 mins
38 Numeric Functions in SQL Server
Video - 4:20 mins
39 Aggregation Functions in SQL Server
Video - 4:20 mins
40 Using GROUP BY in SQL Server
Video - 4:20 mins
41 Using HAVING in SQL Server
Video - 4:20 mins
42 Subqueries in SQL Server
Video - 4:20 mins
43 Declaring Variables in SQL Server
Video - 4:20 mins
44 User-Defined Functions in SQL Server
Video - 4:20 mins
45 Triggers in SQL Server
Video - 4:20 mins
46 Views in SQL Server
Video - 4:20 mins
47 Stored Procedures in SQL Server
Video - 4:20 mins
48 Cursors in SQL Server
Video - 4:20 mins
49 Example 1 on Cursors in SQL Server
Video - 4:20 mins
50 Example 2 on Cursors in SQL Server
Video - 4:20 mins
Final Exam - Mastering Microsoft SQL Server
Quiz
Final Exam - Mastering Microsoft SQL Server
Quiz
Final Exam - Mastering Microsoft SQL Server
Quiz
More
Announcements
Reviews
Course Info
Understand how to group data using the GROUP BY clause to perform aggregate calculations.
Sign in
Sign up
Sign in
Don’t have an account?
Sign up
Remember me
Lost your password?
Sign up
Already have an account?
Sign in
