Thursday, September 21, 2017

Database Fundamentals #11: Why Learn T-SQL?

DZone Database Zone
Database Fundamentals #11: Why Learn T-SQL?
Database Fundamentals #11: Why Learn T-SQL?

If you've been following along with the previous 10 Database Fundamentals blog posts, you have a SQL Server installed and a database with a table in it. You may have more if you've been practicing. Now would be the time to start adding data to the database, but first, I want to talk about the importance of T-SQL!

Why T-SQL?

The way SQL Server accepts information is very different than most programs you're used to using. Most programs focus on the graphical user interface as a mechanism for enabling data entry. While there is a GUI within SQL Server that you can use for data entry (and I will do a blog post on it), the primary means of manipulating data within SQL is the Transact-Structured Query Language (or T-SQL).

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...