Are you a (very) big beginner on SQL, and you want to learn quickly how to make queries in TSQL?
This course will therefore be ideal for you.
After having installed SQL server on your computer, we will approach in this course in the order :
The creation and definition of a table
Selecting, updating, deleting and inserting data (with SELECT, UPDATE etc…)
Select a certain number of lines with the TOP, remove duplicates with the DISTINCT.
The operators BETWEEN, AND, OR,HAVING,PRINT,GROUP BY etc…).
Go even further in Transact SQL with UNION and UNION ALL, TRIM/LTRIM/RTRIM and UPPER/LOWER, etc…
Copy a table via SELECT INTO and comparison operators = != etc…
Aggregate functions: MIN, MAV and AVG
A long chapter of 1h 30 on joins! (INNER JOIN,LEFT/RIGHT JOIN FULL OUTER JOIN etc…)
Once this course is over, believe me that you will be much more comfortable with SQL and I also made sure that the videos don’t exceed 10 minutes, so that it won’t be too soporific 🙂
Why go for SQL technology?
SQL is one of the skills very actively sought after in the job market.
Administering an SQL server and querying in TSQL today is ensuring you have a full time job.
Moreover, SQL Server, because of its simplicity, allows you to quickly become proficient on very specific subjects.
Look at the average of my other courses (4,4/5), and you will see that my courses are quality courses :