Skip to navigation
Skip to navigation
Skip to search form
Skip to login form
Skip to footer
Skip to main content
MVP189
LEO777
LEO777
LEO777
LEO777
LEO777
LEO777
LEO777
LEO777
LEO777
PAREPOS
JAVABET99
KONTAN88
PEWE128
LAGA88
SKY99IDN
BUANA88
BOXING55
DEWISRI88
DEWISRI88
DEWISRI88
MVP189
slot mania
MVP189
situs tergacor
pg slot wallet
Accessibility options
Accessibility profiles
Visual impairment
Seizure and epileptic
Color vision deficiency
ADHD
Learning
Content adjustments
Readable font
Highlight titles
Highlight links
Stop animations
Text size
+
+ +
+ + +
Line height
+
+ +
+ + +
Text spacing
+
+ +
+ + +
Color adjustments
Dark contrast
Light contrast
High contrast
High saturation
Low saturation
Monochrome
Orientation adjustments
Reading guide
Reading Mask
Big black cursor
Big white cursor
Email: it@huph.edu.vn
Email: it@huph.edu.vn
Các khóa học
Link list
Đổi giao diện
Giao diện cũ
Giao diện mới
Learning AI
Machine Learning cơ bản
en
English
Technology
Database
Microsoft SQL - The Complete Guide for Beginners (TSQL)
0 students
Last updated
Jul 2025
Enrol now
Overview
Course content
Instructors
About the course
Microsoft SQL - The Complete Guide for Beginners (TSQL)
Show more...
Course content
Sections:
1
•
Activities:
1
•
Resources:
115
Expand all
Section 1
Introduction
Announcements
001 Welcome fGXh gitir
002 Install SQL Server PEzX gitir
004 Install SSMS OwUh gitir
005 What are tables and Query Sdid gitir
006 Connect to SQL Server ZfVg gitir
007 Restore Adventure Works QNkE gitir
008 Data Types in SQL a3UO gitir
009 Basic Fundamentals vTNx gitir
010 Select with Hello World 68eh gitir
011 Select statement and Alias Names 9iQe gitir
012 Select from Table TrSX gitir
013 DISTINCT and TOP Keywords Y1me gitir
014 Alias Names Cczo gitir
015 Quick SELECT NHdj gitir
017 Filtering Records qgTo gitir
018 Data and WHERE Clause FGN2 gitir
019 WHERE clause with multiple conditions to2r gitir
020 BETWEEN logical operator 0Bmi gitir
021 IN operator jOzT gitir
022 NOT operator mWj6 gitir
023 IS NULL operator WaMi gitir
024 Wildcards Part 1 FPB7 gitir
025 Wildcards Part 2 WoZh gitir
027 ORDER BY clause umHE gitir
028 Order multiple columns RbQE gitir
029 Order by row number aKqK gitir
031 Counting Rows j7it gitir
032 Common Aggregate Functions Wx8E gitir
034 GROUP BY Clause OxFV gitir
035 WHERE clause with GROUP BY FnoB gitir
036 Multiple aggregate functions in GROUP BY gk8P gitir
037 HAVING clause eNsS gitir
038 Optimized Query XuZd gitir
040 CASE statement tLQB gitir
041 CASE and GROUP BY JrDb gitir
042 CASE and WHERE clause iYys gitir
044 INNER JOIN Theory qToU gitir
045 INNER JOIN in Action XLUJ gitir
046 INNER JOIN and column selection bshs gitir
047 Join three tables SYmJ gitir
048 NULL values are ignored in join CV5J gitir
049 LEFT JOIN yCxn gitir
050 Right JOIN 5Yp5 gitir
051 Joins and WHERE clause bQVM gitir
052 SELF JOIN lXv4 gitir
053 CROSS JOIN sMBl gitir
055 UNION and UNION ALL w6zC gitir
056 UNION in Complex Example 89Yw gitir
057 EXCEPT and INTERSECT 7fmT gitir
059 CASE LEFT and TRIM u2UJ gitir
060 LEFT and RIGHT Jwf6 gitir
061 SUBSTRING mko3 gitir
062 CHARINDEX uMU7 gitir
063 REPLACE and REVERSE gki2 gitir
065 GETDATE t8It gitir
066 DATEADD j22u gitir
067 DATEPART C80v gitir
068 DATEDIFF JXSb gitir
069 ISDATE YHM9 gitir
071 CAST NjOJ gitir
072 CONVERT OVAa gitir
074 FLOOR and CEILING uirt gitir
075 ROUND rI2T gitir
076 More functions 5zAi gitir
077 Random in SQL oa5E gitir
079 NULLIF WdJS gitir
080 ISNULL OU3e gitir
081 COALESCE WzKa gitir
083 Execution Sequence jWaw gitir
084 Execution Sequence Example o42Q gitir
085 Scalar Subquery STac gitir
086 Column Subquery B4a1 gitir
087 Derived Table VicW gitir
088 Derived Table and JOIN 6oXy gitir
089 Derived Table and JOIN use case SInB gitir
090 Common Table Expression TJCD gitir
091 Common Table Expression Example 2zX4 gitir
093 Create and delete database SvKJ gitir
094 Create table without query y6eI gitir
095 Delete table without query o2RE gitir
096 Create and drop table zbPG gitir
097 Create table and constraints 2vyq gitir
098 Create table with constraints TchB gitir
099 Apply constraints HG0L gitir
100 Constraints in Depth 9vFl gitir
101 Shortcut to generate create statements U1GR gitir
102 Insert statement WHDv gitir
103 Insert without column names jyXy gitir
104 Update statement 0xSH gitir
105 Delete statement KsQB gitir
106 Restore Adventure Works cAek gitir
107 Create View K5SD gitir
108 Edit View rNgy gitir
109 Join and Views YWz9 gitir
110 Delete View h8Zw gitir
112 Create Scalar valued functions qJWO gitir
113 Updating and calling Scalar functions KfBr gitir
114 Inline table valued functions xRWS gitir
115 Calling table valued functions ZYz9 gitir
116 Multi line table valued functions 6oLX gitir
117 Calling multi line table valued functions 9OoD gitir
119 Transaction Theory tFpL gitir
120 Transactions Demo Rdhn gitir
121 Check data before update KR30 gitir
122 Try Catch with transactions EdEs gitir
123 Schemas EJ6I gitir
124 Table Variables zSEw gitir
125 Create Temp Table oJoE gitir
126 Scope of local Temp Table brYJ gitir
127 Global Temp Table 2Xfc gitir
129 Variables and PRINT 7KHU gitir
130 IF ELSE lMg7 gitir
131 Create Stored Procedure v2Vh gitir
132 Execute a Stored Procedure 7881 gitir
133 NOCOUNT 4rJF gitir
Instructors
Enrolment options
Microsoft SQL - The Complete Guide for Beginners (TSQL)
Course modified date:
19 July 2025
Microsoft SQL - The Complete Guide for Beginners (TSQL)
Enrolled students:
There are no students enrolled in this course.
Guests cannot access this course. Please log in.
Continue
Enrol now
This course includes
Forums
Resources
Share this course
Scroll to top
×
Close
×
Close