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

Understand how to group data using the GROUP BY clause to perform aggregate calculations.

Previous
Next
0% Complete