Learn MS SQL Server from Scratch

Learn MS SQL Server from Scratch, available at $19.99, has an average rating of 4.45, with 22 lectures, based on 144 reviews, and has 4441 subscribers.

You will learn about SQL Server Basics with practical examples SQL Server advanced Concepts SQL Server Performance Improvements sql 2019 sql 2016 sql 2022 This course is ideal for individuals who are Any IT person can attend It is particularly useful for Any IT person can attend.

Enroll now: Learn MS SQL Server from Scratch

Summary

Title: Learn MS SQL Server from Scratch

Price: $19.99

Average Rating: 4.45

Number of Lectures: 22

Number of Published Lectures: 22

Number of Curriculum Items: 22

Number of Published Curriculum Objects: 22

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

SQL Server Basics with practical examples
SQL Server advanced Concepts
SQL Server Performance Improvements
sql 2019
sql 2016
sql 2022

Who Should Attend

Any IT person can attend

Target Audiences

Any IT person can attend

SQL (Structured Query Language)

SQL stands for “Structured Query Language” and can be pronounced as “SQL” or “sequel – (Structured English Query Language)”.SQL (Structured Query Language) is used to modify and access data or information from a storage area called database.

SQL Commands:

SQL commands are instructions used to communicate with the database to perform specific task that work with data.

Data Definition Language (DDL) – These SQL commands are used for creating, modifying, and dropping the structure of database objects. The commands are CREATE, ALTER, DROP, RENAME, and TRUNCATE.

Data Manipulation Language (DML) – These SQL commands are used for storing, retrieving, modifying, and deleting data. These commands are SELECT, INSERT, UPDATE, and DELETE.

Transaction Control Language (TCL) – These SQL commands are used for managing changes affecting the data. These commands are COMMIT, ROLLBACK, and SAVEPOINT.

Data Control Language (DCL) – These SQL commands are used for providing security to database objects. These commands are GRANT and REVOKE.

CREATE TABLE

CREATE TABLE table name

(column_name1 datatype,

column_name2 datatype,

column name datatype

);

table name – is the name of the table.

column_name1, column_name2…. – is the name of the columns

datatype – is the datatype for the column like char, date, number etc.

Many more examples on SQL Server 2016 and SQL Server 2019

Will try to cover sql performance tuning and trouble shooting concepts as well.

how to create jobs in sql agents and trouble shooting concepts

Course Curriculum

Chapter 1: SQL Concepts

Lecture 1: SQL Server Introduction

Lecture 2: History of SQL Server

Lecture 3: Hardware and software requirements

Lecture 4: How to Check SQL Instance name and Version

Lecture 5: How to create Data base and tables for the first time

Lecture 6: SQL Commands

Lecture 7: SQL DDL Command – Create and Drop

Lecture 8: How to check definition of table in SQL

Lecture 9: SQL DML Command – Insert examples

Lecture 10: SQL DML Command – Update and Delete

Lecture 11: SQL DDL – Truncate Command

Lecture 12: SQL DDL – Alter Command

Lecture 13: What is Alias in SQL

Chapter 2: SQL Server Installation and Setup

Lecture 1: SQL Server Installation and Setup

Chapter 3: SQL Joins

Lecture 1: What is Join and Types of Joins

Lecture 2: What is Inner Join and Examples

Lecture 3: What is Outer Join and Types of Outer Joins

Lecture 4: Left Outer Joins with Examples

Lecture 5: Right Outer Joins with Examples

Lecture 6: Full Outer Joins with Examples

Lecture 7: Cross Join or Cartesian Joins in SQL

Chapter 4: SQL Maintenance Activities

Lecture 1: SQL Backup and Restore concept

Instructors

VenkatM M
Technical Architect at MNC

Rating Distribution

1 stars: 1 votes
2 stars: 8 votes
3 stars: 19 votes
4 stars: 53 votes
5 stars: 63 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!

Menu