Learn MS SQL Server from Scratch

Focused View

VenkatM M

2:47:05

50 View

1 - SQL Concepts

1 - SQL Server Introduction.mp4

05:48

2 - History of SQL Server.mp4

05:48

3 - Hardware and software requirements.mp4

04:12

4 - How to Check SQL Instance name and Version.mp4

08:01

5 - How to create Data base and tables for the first time.mp4

12:40

6 - SQL Commands.mp4

06:34

7 - SQL DDL Command Create and Drop.mp4

14:29

8 - How to check definition of table in SQL.mp4

03:26

9 - SQL DML Command Insert examples.mp4

09:26

10 - SQL DML Command Update and Delete.mp4

10:35

11 - SQL DDL Truncate Command.mp4

04:58

12 - SQL DDL Alter Command.mp4

05:53

13 - What is Alias in SQL.mp4

09:11

2 - SQL Server Installation and Setup

14 - SQL Server Installation and Setup.mp4

11:01

3 - SQL Joins

15 - What is Join and Types of Joins.mp4

05:31

16 - What is Inner Join and Examples.mp4

14:17

17 - What is Outer Join and Types of Outer Joins.mp4

04:54

18 - Left Outer Joins with Examples.mp4

08:11

19 - Right Outer Joins with Examples.mp4

05:55

20 - Full Outer Joins with Examples.mp4

04:30

21 - Cross Join or Cartesian Joins in SQL.mp4

05:38

4 - SQL Maintenance Activities

22 - SQL Backup and Restore concept.mp4

06:07

Description

SQL Server Basics to Advanced Concepts

What You'll Learn?

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

Who is this for?

Any IT person can attend

What You Need to Know?

Any IT person can attend

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

Having 15+ Years of IT experience10 Years of SQL , MSBI Professional ExperienceExpertise in Design , Development , ETL Testing and deliveringExpertise in SQL Performance ImprovementsExpertise in SSAS Cubes design and developmentProficient in delivering complex tabular , graphical and linear SSRS reportsExpertise in Power BI configuration , Development and SetupSSRS Report manager configurations and setupSSRS , SSIS troubleshooting experience

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.