T-SQL Tutorial

Unlock the Power of Transact-SQL

Welcome to the T-SQL Tutorial, your definitive guide to mastering Transact-SQL (T-SQL). Whether you’re a database developer, administrator, or analyst, this course empowers you to harness the full potential of T-SQL for efficient and powerful data manipulation.

Course Highlights:

T-SQL Fundamentals: Learn the basics of querying and managing data.
Advanced T-SQL: Dive into complex operations, stored procedures, and functions.
Performance Optimization: Optimize T-SQL queries for speed and efficiency.
Data Manipulation: Master CRUD operations for data control.
Real-world Scenarios: Apply your skills to practical data challenges.
Best Practices: Develop industry-standard expertise in T-SQL development.

Whether you’re working with SQL Server, Azure SQL, or other relational databases, T-SQL is a valuable skill. Join us on this journey to become a T-SQL expert and elevate your data manipulation capabilities. Let’s get started!

Course Information

Categories: Database, SQL Server Tutorial

Tags: database programming language, learn, T-SQL, Transact-SQL, tutorial

Course Instructor

lemborco Author

SQL Server Basics

SQL Server: SELECT Statement

New Lesson

SQL Server: Comparison Operators

SQL Server: WHERE Clause

SQL Server: ORDER BY Clause

SQL Server: AND Condition

SQL Server: OR Condition

SQL Server: Combining the AND and OR Conditions

SQL Server: DISTINCT Clause

SQL Server: IN Condition

SQL Server: IS NULL Condition

SQL Server: IS NOT NULL Condition

SQL Server: LIKE Condition

SQL Server: NOT Condition

SQL Server: ALIASES

SQL Server: Joins

SQL Server: BETWEEN Condition

SQL Server: INSERT Statement

SQL Server: UPDATE Statement

SQL Server: DELETE Statement

SQL Server: TRUNCATE TABLE Statement

SQL Server: EXISTS Condition

SQL Server: GROUP BY Clause

SQL Server: HAVING Clause

SQL Server: SELECT TOP Statement

SQL Server: SELECT INTO Statement

SQL Server: DELETE TOP Statement

SQL Server: UNION Operator

SQL Server: INTERSECT Operator

SQL Server: EXCEPT Operator

SQL Server: Subqueries

SQL Server: PIVOT Clause

SQL Server: Data Types

New Lesson

SQL Server: Primary Keys

SQL Server: ALTER TABLE Statement

New Lesson

SQL Server: VIEW

SQL Server: Global Temporary tables

SQL Server: LOCAL TEMPORARY TABLES

SQL Server: Foreign Keys

SQL Server: Foreign Keys with cascade delete

SQL Server: Foreign Keys with set null on delete

SQL Server: Drop a foreign key

New Lesson

SQL Server: Enable a foreign key

SQL Server: Unique Constraints

SQL Server: Check Constraints

SQL Server: Indexes

SQL Server: Grant/Revoke Privileges

SQL Server: CREATE LOGIN statement

SQL Server: ALTER LOGIN statement

SQL Server: DROP LOGIN statement

SQL Server: Find Logins in SQL Server

SQL Server: CREATE USER statement

SQL Server: Change a password in SQL Server

SQL Server: DROP USER statement

SQL Server: Find Users in SQL Server

SQL Server: Comments within SQL

SQL Server: Literals

SQL Server: Declare Variables

SQL Server: Sequences (Autonumber)

SQL Server: Functions

SQL Server: Procedures

SQL Server: IF…ELSE Statement

SQL Server: WHILE LOOP

SQL Server: FOR LOOP

SQL Server: BREAK Statement

SQL Server: CONTINUE Statement

SQL Server: GOTO Statement

SQL Server Tutorial (Complete)

String Functions

New Lesson

SQL Server: CHARINDEX Function

SQL Server: CONCAT Function

SQL Server: + Operator

SQL Server: DATALENGTH Function

SQL Server: LEFT Function

SQL Server: LEN Function

SQL Server: LOWER Function

New Lesson

SQL Server: NCHAR Function

SQL Server: PATINDEX Function

SQL Server: REPLACE Function

SQL Server: RIGHT Function

SQL Server: RTRIM Function

SQL Server: SPACE Function

SQL Server: STR Function

SQL Server: STUFF Function

SQL Server: SUBSTRING Function

New Lesson

Numeric/Math Functions

SQL Server: ABS Function

SQL Server: AVG Function

SQL Server: CEILING Function

SQL Server: COUNT Function

SQL Server: FLOOR Function

SQL Server: MAX Function

SQL Server: MIN Function

SQL Server: RAND Function

SQL Server: ROUND Function

SQL Server: SIGN Function

SQL Server: SUM Function

Date/Time Functions

New Lesson

SQL Server: CURRENT_TIMESTAMP function

SQL Server: DATEADD Function

SQL Server: DATEDIFF Function

SQL Server: DATENAME Function

SQL Server: DATEPART Function

SQL Server: DAY Function

SQL Server: GETDATE function

SQL Server: GETUTCDATE function

SQL Server: MONTH Function

SQL Server: YEAR Function

Conversion Functions

SQL Server: YEAR Function

SQL Server: CAST Function

SQL Server: CONVERT Function

SQL Server: TRY_CAST Function

SQL Server: TRY_CONVERT Function

Configuration Functions

SQL Server: @@VERSION Function

Advanced Functions

SQL Server: CASE Statement

New Lesson

SQL Server: COALESCE Function

SQL Server: CURRENT_USER function

SQL Server: ISDATE Function

SQL Server: ISNULL Function

SQL Server: ISNUMERIC Function

SQL Server: LAG Function

SQL Server: LEAD Function

SQL Server: NULLIF Function

SQL Server: SESSION_USER Function

SQL Server: SESSIONPROPERTY Function

SQL Server: SYSTEM_USER Function

SQL Server: USER_NAME Function