Learn to Program with T- SQL

Learn to Program with T- SQL, available at $19.99, has an average rating of 4.3, with 50 lectures, based on 10 reviews, and has 505 subscribers.

You will learn about Install SQL Server Download and attach a database Write basic T-SQL queries Retrieve Data using SELECT Statement Sorting Data output using ORDER BY Statement Filtering Data using various filters Modifying data: Add , Update, Delete Implement a stored procedure Combine data from multiple tables Use Aggregate functions to compute single value output This course is ideal for individuals who are Beginner SQL Programmers or Beginner Database Administrators or Beginner Data Analyst or Beginner Data warehouse analyst or Anyone working with data It is particularly useful for Beginner SQL Programmers or Beginner Database Administrators or Beginner Data Analyst or Beginner Data warehouse analyst or Anyone working with data.

Enroll now: Learn to Program with T- SQL

Summary

Title: Learn to Program with T- SQL

Price: $19.99

Average Rating: 4.3

Number of Lectures: 50

Number of Published Lectures: 50

Number of Curriculum Items: 50

Number of Published Curriculum Objects: 50

Original Price: $109.99

Quality Status: approved

Status: Live

What You Will Learn

Install SQL Server

Download and attach a database

Write basic T-SQL queries

Retrieve Data using SELECT Statement

Sorting Data output using ORDER BY Statement

Filtering Data using various filters

Modifying data: Add , Update, Delete

Implement a stored procedure

Combine data from multiple tables

Use Aggregate functions to compute single value output

Who Should Attend

Beginner SQL Programmers

Beginner Database Administrators

Beginner Data Analyst

Beginner Data warehouse analyst

Anyone working with data

Target Audiences

Beginner SQL Programmers

Beginner Database Administrators

Beginner Data Analyst

Beginner Data warehouse analyst

Anyone working with data

SQL (Structured Query Language) is a common tool for retrieving data from relational databases such as SQL Server,Oracle, MySQL, MariaDB, and PostgreSQL. SQL skills is in the Top 3 of 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 main 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 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. You will also be familiar with 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.

?This beginner ?course provides an introduction to this core ?programming language.
? Learn how to:
? Request data from a server,
? Limit ?and sort the ?data responses
? Get single output value using aggregate functions
? Combine data from multiple tables with joins
? Modify data: Add, Update and Delete
? Filter records and remove duplicates
? Write basic T-SQL Statements
? Understand T-SQL TOP Command
? Understand Normalisation

Course Curriculum

Chapter 1: Basic Database Concepts

Lecture 1: Introduction

Lecture 2: What is T-SQL

Lecture 3: What is a Database

Lecture 4: What is a Primary Key

Lecture 5: What is a Foreign Key

Chapter 2: SQL Server and Database Setup

Lecture 1: System Requirements

Lecture 2: Download SQL Server Express Edition 2014

Lecture 3: Install SQL Server Express 2014

Lecture 4: Download Sample Database

Lecture 5: Attach Sample Database to SQL Server 2014

Lecture 6: Exploring SSMS

Lecture 7: What is Intellisense

Lecture 8: Using SQL USE Command

Lecture 9: What is Normalization

Lecture 10: Using T-SQL GO Command

Lecture 11: Using SQL DISTINCT and TOP Command

Lecture 12: Using Comments

Chapter 3: How to Get Data from a Database

Lecture 1: Using SELECT Statement

Lecture 2: Using Aliases

Lecture 3: Using Case Expressions

Lecture 4: Sort data in Ascending Order

Lecture 5: Sorting Data in Descending Order

Lecture 6: Using Stored Procedures

Chapter 4: Combining Data from multiple Database Tables

Lecture 1: Introduction to Table Joins

Lecture 2: Why are Table joins important?

Lecture 3: Getting Data with INNER Join

Lecture 4: Getting Data with LEFT -OUTER Join

Lecture 5: Getting Data with RIGHT -OUTER Join

Lecture 6: Summary

Chapter 5: Returning Single Value Data with Aggregate Functions

Lecture 1: Introduction

Lecture 2: COUNT Function

Lecture 3: SUM function

Lecture 4: MAX function

Lecture 5: MIN function

Lecture 6: AVG function

Lecture 7: Querying Data Using Multiple Aggregate Functions

Lecture 8: Summary

Chapter 6: Inserting and Modifying Data

Lecture 1: Introduction

Lecture 2: Adding Records

Lecture 3: Deleting Records

Lecture 4: Updating records

Lecture 5: Summary

Chapter 7: How To Filter Data From a Database

Lecture 1: Introdution

Lecture 2: Using Basic Comparison Filters

Lecture 3: Using Equality Filters

Lecture 4: Using Logical Filters

Lecture 5: Using String Comparison filters

Lecture 6: Using NULL as filters

Lecture 7: Summary

Lecture 8: Thank You

Instructors

Skill Tree
Skill based learning

Rating Distribution

1 stars: 0 votes

2 stars: 1 votes

3 stars: 0 votes

4 stars: 5 votes

5 stars: 4 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!