Note: 

   

If you guys are getting coupon expired or course is not free after opening the link, then it is due to the fact that course instructors provide only few hundreds or thousands of slots which get exhausted. So, try to enroll in the course as soon as it is posted in the channel. The Coupons may expire any time for instant notification follow telegram channel

Practical Hands-on Data Query and Manipulation with SQL

Description

The volume of data available is huge and increasing daily. Structured Query Language -SQL (pronounced as sequel) is the standard language used to communicate and interact with data stored in relational management database systems like Microsoft SQL Server Oracle, PostgreSQL,MySQL etc.

 

Different database management systems have their own proprietary version of the SQL language but they all conform to using some commands in SQL the same way. Microsoft SQL Server’s version of SQL is known as Transact-SQL (T-SQL). In this course you will learn the basics of the SQL language and Transact-SQL since both use certain commands in the same way.

 

T-SQL is also popularly referenced 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. I will introduce you to the data types available so you can make the appropriate selection when creating a column. Then, we will talk about joins, functions, tables, procedures, triggers, indexes, and much more. By the time you are done with this course, you will be very comfortable using T-SQL.

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.

 

 

 

What You will learn includes:

 

 

 

Installing SQL Server

 

Install SSMS

 

Basic Database Concepts

 

Creating Database

 

Creating Table

 

Creating Views

 

Creating stored procedures

 

Reading data from a database

 

Updating database records

 

Backing up database

 

Deleting Records

 

Truncating Table

 

Dropping Table

 

Dropping Database

 

Restore Database

 

Query Multiple Database Tables

 

Change query output column names using case expressions

 

Perform Various table joins

 

Filter records and remove duplicates

 

Write basic T-SQL Statements

 

Understand T-SQL TOP Command

 

Understand Normalisation

 

Know how to use SSMS

 

Create Views

 

Create Stored Procedures

 

Understand NULL Values

 

Data Types

 

Functions

 

Who this course is for:

Beginners to Microsoft SQL

Beginners to SQL

Enroll Now