Learn to Program with T-SQL – Learn to Program with SQL Server
To Manipulate Databases SQL Programming Practical
SQL (Structured Query Language) is a common relational databases such as SQL Server tool for Retrieving data from, Oracle, MySQL, MariaDB, and PostgreSQL. SQL skills is in the top 3 of the requested IT Skills by recruiters and companies all over the world.
T-SQL is also popularly referred to as T-Sequel. In this course, you will learn all the basics of T-SQL. We will discuss the T-SQL features step by step. We will be using SQL Server Express 2014 (which is a free download). As a sample we will use AdventureWorks 2014 as our database.
Along the way, we will be creating our own T-SQL queries to get data into a database and also out of a database. But AdventureWorks 2014 will be our focus focus. As far as T-SQL, we will start with the simple select statements and add new features as we go.
This course will provide you with 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. You will also be familiar with SQL Server Management Studio 2014, also known as SSMS. This is the tool you will use to write and see the output of your T-SQL queries.
– Basic Database Concepts
– SQL Server and Database Setup
– How to Get Data from a Database
– Combining Data from Multiple Database Tables
– Returning Single Value Data with Aggregate Functions
– Inserting and Modifying Data
– How to Filter a Data From a Database
Manufacturer: Yudomi / Udemy
Language of instruction: English
Teacher: Skill Tree
Level of training: Preliminary
time of training: 5 hours + 30 minutes
File size: 749 MB
Download Link OneDrive Download on Box.com
Leave a Reply