SQLServerCentral Article

SQL and T-SQL for Beginners in 229 minutes


Learning SQL is not difficult. However, you need to spend a few hours or a few days to learn the basics. On this site you can find a lot of interesting articles, but you need to know the basics of SQL or T-SQL. If you're new to this site and some articles are too hard for you, stay and learn SQL and T-SQL. I came to the conclusion that the best way of learning are video tutorials. 229 minutes of watching and 5 minutes of reading. Let's get started.

Some information about SQL and T-SQL

SQL (Structured Query Language) is a standard language for storing, manipulating and retrieving data in databases (in a relational database management system (RDBMS)). T-SQL (Transact-SQL) is Microsoft's proprietary extension to the SQL. T-SQL expands on the SQL standard to include many useful things.

Level 1: Learning SQL

In this first section, let's look at the basics of the SQL language.

Level 1.1: Introduction to databases

If you are a beginner, then you should familiarize yourself with several theoretical issues.

Level 1.2: Creating database and creating tables

The first thing you need to do is creating a database and tables.

Level 1.3: Inserting data (INSERT INTO clause)

Another thing you need to learn is inserting data into tables.

Level 1.4: Selecting data (SELECT AND ORDER clause)

Now we can start displaying data stored in the database.

Level 1.5: Filtering data (WHERE clause)

Let us now learn to filter data using the WHERE clause.

Level 1.6: Joins

Did you know that data from several tables can be joined with each other?

Level 1.7: Grouping and aggregation (GROUP BY, HAVING, MIN, MAX, AVG, COUNT, DISTINCT)

It's time for slightly more difficult tasks - data grouping and data aggregation.


And now I will present a different displaying of data from several tables.

Level 1.9: Subqueries

You can write a SQL query inside another query.


This lesson is a tiny introduction to T-SQL. You will discover a lot of useful functions: CASE, ROUND, FLOOR, CEILING, LEFT, SUBSTRNG, RIGHT, CHARINDEX, MONTH, YEAR, DAY etc

Level 1.11: Update, Alter, Drop, Delete and Truncate clause

Once you've learned how to insert and display data, it's time to learn about data manipulation methods.

Level 1.12: Views

Some queries are used so often, you can save them as views. The views also fulfill several other functions.


One minute break

You already know SQL !!! Make a coffee and let's start. You'll also get to know T-SQL as soon as possible....

Level 2: Learning T-SQL

These videos look at specific ways the T-SQL language is written.

Level 2.1: Creating a database and tables

If you start learning from this place, first create a database

Level 2.2: Transact-SQL Introduction

It's time to get to know the simplest SQL file extensions available in SQL Server

Level 2.3: Views

One more lesson about the views, this time we delve more deeply.

Level 2.4: Stored Procedures

In this lesson, we see how powerful the T-SQL is with some examples.

Level 2.5: User-Defined Functions

If there are stored procedures, then there must also be functions.

Level 2.6: Cursors

Another very useful extension of SQL is the cursor.

Level 2.7: Triggers

A trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database.


In this way we have reached the end of this course.


2.5 (2)

You rated this post out of 5. Change rating




2.5 (2)

You rated this post out of 5. Change rating