![]() ![]() It's time for slightly more difficult tasks - data grouping and data aggregation. Level 1.7: Grouping and aggregation (GROUP BY, HAVING, MIN, MAX, AVG, COUNT, DISTINCT) Let us now learn to filter data using the WHERE clause.ĭid you know that data from several tables can be joined with each other? Now we can start displaying data stored in the database. Level 1.4: Selecting data (SELECT AND ORDER clause) Level 1.3: Inserting data (INSERT INTO clause)Īnother thing you need to learn is inserting data into tables. The first thing you need to do is creating a database and tables. Level 1.2: Creating database and creating tables If you are a beginner, then you should familiarize yourself with several theoretical issues. In this first section, let's look at the basics of the SQL language. T-SQL expands on the SQL standard to include many useful things. T-SQL (Transact-SQL) is Microsoft's proprietary extension to the SQL. SQL (Structured Query Language) is a standard language for storing, manipulating and retrieving data in databases (in a relational database management system (RDBMS)). 229 minutes of watching and 5 minutes of reading. I came to the conclusion that the best way of learning are video tutorials. ![]() If you're new to this site and some articles are too hard for you, stay and learn SQL and T-SQL. On this site you can find a lot of interesting articles, but you need to know the basics of SQL or T-SQL. However, you need to spend a few hours or a few days to learn the basics. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |