Mastering Microsoft SQL Server
26 String Function: SUBSTRING 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
Learn how to extract a substring from a string using the SUBSTRING function.
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
