T-SQL (Transact-SQL) for beginners with Microsoft SQL Server
Learn Transact-SQL (T-SQL) coding skills to query and modify data in a Microsoft SQL Server database. This course covers the basics of SQL language and practical experience in writing Transact-SQL statements. Gain skills in creating, inserting, selecting, updating, and deleting data. Ideal for beginners in T-SQL, SQL, and Microsoft SQL Server.
What you’ll learn
- Learn Transact-SQL (T-SQL) coding skills needed to query and modify data held within a Microsoft SQL Server database.
- Write Transact-SQL statements to perform CRUD(create| Read | update |delete) operations on SQL Server database
- Installing SQL Server
- Writing CREATE queries
- Writing INSERT INTO queries
- Writing SELECT queries
- Writing UPDATE queries
- Writing DELETE queries
This course covers the basics of the SQL language as implemented by Microsoft SQL Server. The course is designed to give students
practical experience in writing Transact-SQL statements by hand using the SQL Server Management Studio (SSMS) development environment.
We will write Transact-SQL statements to perform CRUD(create| Read | update |delete) operations on SQL Server database.
CRUD operations are the most common operations performed on a database.
SQL Server is a relational database management system, or RDBMS, developed and marketed by Microsoft. Similar to other RDBMS software, SQL Server is built on top of SQL, a standard programming language for interacting with the relational databases. SQL server is tied to Transact-SQL, or T-SQL, the Microsoft’s implementation of SQL that adds a set of proprietary programming constructs.
Skills you learn and acquire Includes:
Writing CREATE queries
Writing INSERT INTO queries
Writing SELECT queries
Writing UPDATE queries
Writing DELETE queries
Course Objectives
To provide the Transact-SQL (T-SQL) coding skills needed to query and modify data held within a Microsoft SQL Server database.
Who this course is for:
- Beginners to Transact-SQL (T-SQL)
- Beginners to SQL
- Beginners to Microsoft SQL Server
User Reviews
Be the first to review “T-SQL (Transact-SQL) for beginners with Microsoft SQL Server”
You must be logged in to post a review.
There are no reviews yet.