SQL-Server

    This course introduces database design and creation using a MS SQL server product.

The emphasis is placed on Managing Data and Design Database Schema. Upon completion, students should be able to use SQL (structure query language) statement to manipulate the data in database. Moreover, the students will be able to design and implement normalized database structures by creating relationship, database tables, view, function, stored-procedure, trigger and cursor.

    The topic for system and database administrators is to solve the database technical problems. Showing students how to build upon their working knowledge, and upgrade the student’s knowledge from the basic level to a higher level and become a database administrator.

Created by Last updated Tue, 03-Nov-2020
Curriculum for this course
57 Lessons 07:22:39 Times
  • Introduction To Sql Server 00:10:24
  • 2. Install Sql Server 2019 00:12:29
  • 3. Sql Server Management Studio 00:10:40
  • Install Sql Server 2019 00:12:32
  • Sql Server Management Studio 00:10:50
  • 6. System Database 00:04:51
  • Create Database Using Gui 00:03:22
  • DML Create Table 00:10:04
  • Database Relationship 00:06:56
  • One To One Relationship 00:18:23
  • One To Many Relationship 1 00:06:16
  • One To Many Relationship 2 00:10:22
  • Many To Many Relationship 1 00:05:11
  • Many To Many Relationship 2 00:09:45
  • 15. DML Select Statement 00:16:14
  • Create Database Using Script 00:08:55
  • System Database 00:05:05
  • Create Table Using Gui 00:10:26
  • Create Table Using Script 00:04:37
  • Sql Insert Data 00:08:25
  • Sql Server Insert Data 00:09:29
  • DML Insert Statement 00:08:14
  • DML Update Statement 00:07:17
  • DML Delete Statement 00:05:24
  • DML Select Statement 00:16:17
  • POS Database 00:04:12
  • POS Employees Table 00:08:37
  • POS Customer Table 00:05:21
  • POS Unit Of Measurement Table 00:02:29
  • POS Product Table 00:03:40
  • POS Product Inventory Table 00:07:05
  • POS Orders Table 00:05:12
  • POS Order Product Table 00:03:49
  • POS Database Relationship 00:06:58
  • Inner Join 00:13:26
  • Left Join 00:04:21
  • Right Join 00:02:45
  • Full Join 00:04:16
  • Sql Server View 00:05:16
  • Sql Server View Practice 00:10:51
  • Sql Server View From Two Tables 00:07:32
  • Sql Server Aggregate Function 00:09:42
  • Sql Server Scalar Function 00:06:11
  • Sql Server Scalar Function Practice 00:07:06
  • Sql Server Table Valued Function 00:04:26
  • Sql Server Table Valued Function Practice 00:07:06
  • Sql Server Stored Procedure 00:06:11
  • Sql Server Stored Procedure Practice 00:14:02
  • Sql Server Trigger 00:07:57
  • Sql Server Trigger Practice 00:11:29
  • Sql Server Cursor 00:07:04
  • Sql Server Cursor Practice 00:07:58
  • Sql Server Backup And Restore 00:04:09
  • Sql Server Backup Restore Demo 00:04:32
  • Sql Server Backup And Restore Demo 00:03:00
  • Sql Server Create Login 00:06:00
  • Sql Server Login Demo 00:07:28
+ View more
Description

    This course introduces database design and creation using a MS SQL server product.

The emphasis is placed on Managing Data and Design Database Schema. Upon completion, students should be able to use SQL (structure query language) statement to manipulate the data in database. Moreover, the students will be able to design and implement normalized database structures by creating relationship, database tables, view, function, stored-procedure, trigger and cursor.

    The topic for system and database administrators is to solve the database technical problems. Showing students how to build upon their working knowledge, and upgrade the student’s knowledge from the basic level to a higher level and become a database administrator.