SQL Server Malayalam Tutorial

5 rating

(1 Reviews)

2 students enrolled

A comprehensive course to teach you how to complete SQL queries using Microsoft SQL Server and the T-SQL language.

5 rating

(1 Reviews)

2 students enrolled

Whatlearn

• How to login in SQL Server • Introduction to Database • Difference between frontend software and backend software •...

• Use of SQL • Data base in SQL • Tables in SQL Data base • Data Field • Data Record • Types of SQL • DML (Data Ma...

• Different types of DDL • Use of DDL

• Syntax of Create table query • Create table example "ALTER TABLE QUERY" • Syntax of Alter table query • Alter ta...

• Different types of DML • "INSERT QUERY11,Syntax of Insert query • Working example of insert query • Insert values f...

• Use of Update Query • Syntax of Update Query • Working Example of Update query • "DELETE QUERY" • Syntax of De...

• Order by Clause • Syntax of Order by • Working Example of Order by AND---OR" • Use of "AND---OR" • Combine wher...

• Use of "IN" • Operator in select query • Syntax of "IN" Operator • Working Example of "IN" Operator "BETWEEN -AN...

• Use of "UNION" • Combine select query by using "UNION" • Syntax of "UNION" • Working Example of "UNION" • "INTERSE...

• Syntax of Built in Functions • Different types built in Functions • Examples of Built in functions • "SELECT INTO Q...

• How to join more than one table • Use of keys in SQL, Primary Key • Introduction to Primary Key • Syntax to create...

• Use of "INDEX" • Advantages of Index • Syntax to create an Index • Syntax to Drop an Index Working Example to crea...

• How to create a virtual copy of table • Use of "VIEW" • Syntax to create "VIEW" • Sub quires • Working example of...

• How to create procedures • Advantages of Procedures • Syntax to create procedures • Calling Procedures • Declaring...

CourseContent

14 sections • 14 lectures • 02h 09m total length

	Introduction Getting Started with SQL Server	preview	6min

	Introduction Get to know the basics of SQL		6min

	DDL (Data Definition Language) Learn the Data Definition Language of SQL		8min

	Create Table Query Learn to Create Table Query in SQL		2min

	DML (Data Manipulation Language) Learn Data Manipulation Language (DML) in SQL		20min

	Update Query Learn the Update Query in SQL Server		10min

	Arranging Data Values in SQL Learn to Arrange Data Values in SQL		8min

	IN Operator in SQL Get to know the IN Operator in SQL		7min

	UNION Statement Get to know the UNION Statement in SQL Server		12min

	Built In Functions Get to know the Arithmetic Built in Functions in SQL Server		8min

	Join And Keys Learn to Join Data in the table in SQL Server		23min

	Index Get to know the Index in SQL Server		5min

	View Get to know the view Feature in SQL Server		7min

	Procedures Get to know the Procedure Feature in SQL Server		7min

Requirements

Microsoft SQL software

Description

SQL (Structured Query Language) is the language we use to interact with databases that store data. This allows us to retrieve data with ease and simplicity. As terms like business intelligence and big data become more familiar, businesses will need more people to learn the SQL language. This course will teach you how to use the SQL language within Microsoft SQL Server, one of the most popular database engines in the world.