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.

Level 1.8: Unions (UNION, UNION ALL, INTERSECT, EXCEPT)

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.

Level 1.10: Useful functions (CASE, ROUND, FLOOR, CEILING, LEFT, SUBSTRNG, RIGHT, CHARINDEX, MONTH, YEAR, DAY)

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.

Rate

2.5 (2)

Share

Share

Rate

2.5 (2)