T-SQL (Transact-SQL) also referred to as T-sequel is Microsoft's implementation of the SQL standard language.
This course is intended for users who are new to writing SQL statements for SQL Server database and
will provide you with the basic knowledge and skills to create queries using Transact-SQL. It will teach you how to select, filter and sort data from multiple tables and how to use views and stored procedures.
Transact-SQL is an essential skill for data professionals and developers working with SQL databases
T -SQL requires an SQL Server database i will walk you through downloading and installing SQL Server Express 2014 and also downloading and installing a sample database.
You will be introduced to SQL Server Management Studio 2014 also known in the tech industry as SSMS. This is the tool you will use to write and see the output of your T-SQL queries.
• Novice SQL developers
• Novice Database administrators
• Aspiring data analyst
• Aspiring data warehouse professionals
• IT Professionals who want to learn T-SQL
What you'll learn how to:
• Create Transact-SQL SELECT queries
• Work with data types and NULL
• Query multiple tables with JOIN
• Use Aggregate data
• Use table expressions
• Group sets and pivot data
• Modify data
• Filter rows of data
• Use basic equality filters
• Use logical and comparison filters
• Use stored procedures
• Case expressions
After completing this course you should be confident to write your T-SQL statements and run them against SQL Server Database.
Looking forward to you joining the course :-)
Hello and welcome to 247 Learning.
We are a small company from the united kingdom that create and teach designs.Our teaching style is designed to be simple and step by step.
We have taught courses like Adobe Photoshop, Adobe Illustrator,Adobe Indesign as well as web design related courses .
Our very first Udemy course was "How to create resume /cv for profit" which has over 500 students.
We will continue to add more courses on the Udemy platform.
Our tutors have over 7 years of a wide range of industry experience and understand how to teach in a way that students can understand.