Tutorials > Database MSSQL Server [Eng CC & Voice]

Database MSSQL Server [Eng CC & Voice]


Date: 25 July 2022 | Posted by: voska89
Database MSSQL Server [Eng CC & Voice]
Published 7/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.30 GB | Duration: 2h 13m
This is one of the three major databases, MSSQL lecture.


What you'll learn
MSSQL
Database
Database tuning basic
T SQL
Requirements
You will learn everything you need to know.
Description
This is one of the three major databases, MSSQL lecture.MSSQL is a relatively simple database management system that has the advantage of being easy to work with C#. It's easy to learn even if you're learning a database for the first time.If you don't know 'SELECT, DELETE, UPDATE, INSERT, TABLE' please look the "Database SQL Basic lecture" first.This provides subtitles so that you can learn through lectures during working hours.And you can study while listening to music.If you look at download, you can find an MSSQL installation ppt.The PowerPoint consists of 43 pages and covers installation instructions.I wrote down how to install it in detail.Just looking at this PowerPoint, I wrote it down in enough detail so that you can install it on your own.The time it takes to install all of them is different, so read this ppt one by one.Except for the installation, we are planning to learn together here while practicing.We will learn this lecture by typing and practicing it ourselves.You can learn how to use the database with this lecture.I hope this lecture will help you become a professional engineer in the field.
Overview
Section 1: Database SQL basic[Oracle, for beginners.]
Lecture 1 Database SQL basic
Section 2: Database MSSQL Server[ENG CC & voice]
Lecture 2 MSSQL,Supplies Downloadnstallation ppt. lecture ppt. etc.
Lecture 3 Introduction
Lecture 4 1.MSSQL Data type
Lecture 5 2.Integrity constraints
Lecture 6 3.'DROP TABLE', 'ALTER TABLE'
Lecture 7 4.'SEQUENCE'
Lecture 8 5.Sorting data, 'ORDER BY'
Lecture 9 6.'WHERE' clause and 'AND', 'OR', 'SELECT TOP' and 'SELECT DISTINCT'
Lecture 10 7.MSSQL Function
Lecture 11 8.Inner Join,Left Outer Join,Right Outer Join,Self Join
Lecture 12 9.Union,Union All
Lecture 13 10.Subquery
Lecture 14 11.Group By& Group function
Lecture 15 12.T-SQL: Transaction & Lock
Lecture 16 13.T-SQL: Procedure
Lecture 17 14.T-SQL: Variable
Lecture 18 15.T-SQL: Exception handling
Lecture 19 16.T-SQL: Repeat statement
Lecture 20 17.T-SQL: IF statement
Lecture 21 18.T-SQL: User defined function
Lecture 22 19.Temp table
Lecture 23 20.Database.Common sense
Anyone interested in a database or MSSQL.

Homepage
https://www.udemy.com/course/database-mssql-server-english/


DOWNLOAD LINK


Links are Interchangeable - No Password - Single Extraction

See full article