Ms Sql

Introduction to Basic Database Concepts
- In this module we learn about Basic concepts and advantages of DBMS and limitations of file management system, and also about 3 data base models.
ER-Modeling and Diagram
- In this module we learn about entity, attributes and relationship, identify the entities and attributes How to draw an E-R diagram and translating the E-R diagram in relation schema.
Normalization
- In this module we learn about what is normalization, types of normalization, data before and after normalization, benefits of normalization.
Introduction to SQL Server
- In this module we learn about SQL Server,history of sql server ,types of system databases,communication between frontend and backend and sql server editions.
Introduction to SQL
- In this module we learn about types of sql statements, databases in sql server, how to create a database, datatypes in sql server, and about DDL Statements.
DDL and DML Statements
- In this module we learn about how to create a table, alter and drop a table, and about DML statements, like insert, update and delete statements.
Working with Queries (DQL)
- In this module we learn about select statement, top, distinct string and arithmetic expressions, Sorting the data and about sub queries and where clause (condition).
Aggregate Functions
- In this module we learn about how to use aggregate functions like sum,mean,max,avg what is difference between having and where clause, group by clause rollup and cube operator.
Joins and Set Operations
- In this module we will know about joins and types of joins how to join the tables and about Sub queries, types of operators like union, intersect and except and how to add the tables and relationship between them.
Implementation of Data Integrity
- In this module, we will learn correctness of data and types of integrity and types of constraints.
Working with Constraints
- In this module, we will learn about how to create a constraint, types of constraints, and difference between unique, not null and primary key constraints.
Implementing Views
- In this module, how to create a view, advantages of views, altering and dropping a view and advanced options while creating a view.
Data Control Language (DCL)
- In this module, we will learn how to grant permission and revoking of roles.
Working with Indexes
- In this module, how to create a index, advantages and disadvantages of index, and types of index and dropping index, and also about index structure.
Writing Transact-SQL (T-SQL)
- In this module, what is script and what is batch, variables and if else statements and working with temporary tables, and checking with the existence of database objects
Working with Stored Procedures and Functions
- In this module, we will learn how to create a stored procedure and difference between stored procedure and table, advantages of procedures and about types of parameters.
Implementing Triggers
- In this module, we will learn about what is trigger and how to create a trigger, types of triggers How to use a rollback transactions.
Working with Cursors
- In this module, how to create a cursor, what is cursor, types of cursor and benefits of cursor.
Transaction Control Language (TCL)
- In this module, we will learn what transaction, transaction management is and what are acid properties, what are isolation levels and about implicit and explicit transactions.
Backup and Restore
- In this module, how to backup database and how to restore a database and how to generate a sql script, and executing a sql script and how to attach and deattach a database.
Advance Features
- In this module we will learn about ranking functions and about how to use xml datatype.

This content is protected, please login and enroll course to view this content!

Prev In this module, we will learn what transaction, transaction management is and what are acid properties, what are isolation levels and about implicit and explicit transactions.

Next In this module we will learn about ranking functions and about how to use xml datatype.

Introduction to Basic Database Concepts

ER-Modeling and Diagram

Normalization

Introduction to SQL Server

Introduction to SQL

DDL and DML Statements

Working with Queries (DQL)

Aggregate Functions

Joins and Set Operations

Implementation of Data Integrity

Working with Constraints

Implementing Views

Data Control Language (DCL)

Working with Indexes

Writing Transact-SQL (T-SQL)

Working with Stored Procedures and Functions

Implementing Triggers

Working with Cursors

Transaction Control Language (TCL)

Backup and Restore

Advance Features

Ms Sql

Leave a Reply Cancel reply

Rony

Sales

Lina

Sales

Introduction to Basic Database Concepts

ER-Modeling and Diagram

Normalization

Introduction to SQL Server

Introduction to SQL

DDL and DML Statements

Working with Queries (DQL)

Aggregate Functions

Joins and Set Operations

Implementation of Data Integrity

Working with Constraints

Implementing Views

Data Control Language (DCL)

Working with Indexes

Writing Transact-SQL (T-SQL)

Working with Stored Procedures and Functions

Implementing Triggers

Working with Cursors

Transaction Control Language (TCL)

Backup and Restore

Advance Features

Ms Sql

Leave a Reply Cancel reply

Rony

Sales

Lina

Sales

Call Me Back!

Call Me Back!