T-SQL (Transact-SQL) for beginners with 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
Requirements
- Computer and Internet Access Required
Description
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
Instructor
![Digital Learning Academy](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 3.9 Instructor Rating
- 406 Reviews
- 22,651 Students
- 13 Courses
Digital learning academy produces bespoke elearning which helps you to effectively gain useful and marketable skills and knowledge .
We work closely with you to map out exactly what you want to bring about and discover what you want to learn and achieve.
We can help you learn something completely new? Working together, we can help you acquire some useful digital skills online.
Our instructors are industry experts and have years of experience to deliver the
training and skills you need.