A beginners guide to T-SQL ( Transact-SQL)
- 3.6
-
![]()
![]()
![]()
![]()
Brief Introduction
Learn Microsoft's own version of the standard SQL languageDescription
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.
Target Audience:
• 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
• Aliases
• 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 :-)
Requirements
- Basic computer knowledge
- Desire to learn
Outline
- Database Download and Install
- Introduction
- What is T-SQL
- Hardware and Software Requirements for SQL Server Express 2014
- Download SQL Server Express2014
- Install SQL Server Express 2014
- Download sample database
- Install Sample Database
- Useful T-SQL Commands
- TOP
- USE
- GO
- DISTINCT and TOP
- Using T-SQL Comments
- Retrieving and Sorting Data with T-SQL
- Using SELECT Statements
- Aliases
- Using ORDER BY clause
- Sort by ascending order
- Sort by multiple columns
- Case Expressions
- Using Stored Procedures
- How to query multiple tables with T-SQL
- Introduction to Table Joins
- Why are table joins relevant
- INNER Table Join
- Left Outer Table Join
- Right Outer Table Join
- Conclusion
- Filtering Rows of data with T-SQL
- Introduction
- Using basic equality filters
- Using basic comparison
- Using logical comparisons
- Using String Comparison
- Using Null Comparison
- Summary
- Using T-SQL to modify data
- Introduction
- Add new records to a database
- Update existing data in the database
- Delete data from a database
- Summary
- How to use T-SQL with Aggregate functions
- Introduction
- COUNT Function
- AVG Function
- MAX Function
- MIN Function
- SUM function
- Grouping Data
- Summary
247 Learning
3.6 Raiting
Microsoft Access SQL: SQL from Absolute Beginners To Expert
- 4.7
-
![]()
![]()
![]()
![]()
![]()
SQL Using Microsoft Access 2019 but applicable to MySQL, Oracle SQL, Microsoft SQL Server, PostgreSQL, SQLite and DB2 Learn from an expert who has a passion for training...
The Complete Microsoft SQL Masterclass: Beginner to Expert
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Master course using Microsoft SQL Server 2019. These SQL can also used in Oracle, MySQL, PostgreSQL, SQLite, DB2, etc. Covers different forms of SELECT Statements...
Beginner Data Analysis Using SQL and Microsoft SQL Server
- 3
-
![]()
![]()
![]()
![]()
![]()
Learn Hands-On how to build Real World SQL Queries to answer questions with data. SQL Server is a relational database management system -RDBMS developed and owned by Microsoft....
How You Can Master the Fundamentals of Transact-SQL
- 0.0
-
![]()
![]()
![]()
![]()
![]()
A Real World Introduction to Transact-SQL COURSE REVIEWS: "This is a great course- I would fully recommend completing it. "Finest experience with Udemy they explain each and everything so clearly....
