T-SQL course The path of a programmer from beginner to professional Level 1 - Beginner

The course is intended for those people who do not know the T-SQL language and have even heard little about SQL, but want or need to master this language. The course uses a sequential teaching methodology; we will smoothly move from simple to more complex. So, at the beginning of the course you will learn what a database is, what a DBMS is, what tools are used to work with a database. Then we'll set up the training ground and move on to learning T-SQL.

At the end of the course, you will learn how to create, modify, delete tables in the T-SQL language, add, modify and delete data in these tables, and, of course, learn how to extract data from tables, in other words, write queries to retrieve data. In addition, you will become familiar with the structure of a select query, find out which sections an SQL query includes, and also learn how to use each of these sections. For example, how to join tables in a query, how to group data, how to filter them, and much more.

Who is this course for:

• The course is designed for beginners who want to learn T-SQL from scratch
• The course will be useful for those who are a little familiar with SQL, but want to improve their skills
• The course is perfect for novice programmers, ordinary administrators, engineers , whose responsibilities include maintaining Microsoft SQL Server databases

What you will learn:

• Create, modify and delete tables on T-SQL
• Add, change and delete data in tables in T-SQL
• Write SELECT queries to select data (including joining tables, grouping, filtering and sorting data)