Learn MS SQL Server from Scratch

SQL Server Basics to Advanced Concepts
Rating: 4.2 out of 5 (42 ratings)
1,748 students
English
English [Auto]

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

Requirements

  • Any IT person can attend

Description

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

Who this course is for:

  • Any IT person can attend

Course content

3 sections21 lectures2h 40m total length
  • SQL Server Introduction
    05:48
  • History of SQL Server
    05:48
  • Hardware and software requirements
    04:12
  • How to Check SQL Instance name and Version
    08:01
  • How to create Data base and tables for the first time
    12:40
  • SQL Commands
    06:34
  • SQL DDL Command - Create and Drop
    14:29
  • How to check definition of table in SQL
    03:26
  • SQL DML Command - Insert examples
    09:26
  • SQL DML Command - Update and Delete
    10:35
  • SQL DDL - Truncate Command
    04:58
  • SQL DDL - Alter Command
    05:53
  • What is Alias in SQL
    09:11

Instructor

Technical Architect at MNC
VenkatM M
  • 4.0 Instructor Rating
  • 196 Reviews
  • 4,282 Students
  • 5 Courses

Having 15+ Years of IT experience

10 Years of SQL , MSBI Professional Experience

Expertise in Design , Development , ETL Testing and delivering

Expertise in SQL Performance Improvements

Expertise in SSAS Cubes design and development

Proficient in delivering complex tabular , graphical and linear SSRS reports

Expertise in Power BI configuration , Development and Setup

SSRS Report manager configurations and setup

SSRS , SSIS troubleshooting experience