U Lectures.com

FREE & EASY Education for everyone.

Home
C++
C Programming
DBMS
Data Structures

Back to Home »
DBMS »
DBMS Tutorial........................................ (32 Lessons)

DBMS Tutorial........................................ (32 Lessons)

Posted by : Unknown Tuesday, 10 June 2014

DBMS Complete Course

DBMS

DBMS is Database Management system. It deals with handling and assembling data into database properly. Here we have complete DBMS Course.

Database Concepts

Overview of DBMS
Database Architecture
Database Model
Codd's rule
RDBMS Concept
Database key
Normalization
ER-Diagram
Generalization and Specialization

Basic SQL

SQL Intoduction
Create query
Alter query
Truncate, Drop and Rename query
All DML command
All TCL Command
All DCL Command
WHERE clause
SELECT query
LIKE clause
ORDER BY clause
Group BY clause
Having clause
DISTINCT keyword
AND & OR operator

Advance SQL

SQL Constraints
SQL function
SQL Join
SQL Alias
SQL SET operation
SQL Sequences
SQL Views

Leave a Reply

Subscribe to Posts | Subscribe to Comments

Topics

C Language
C Plus Plus
Data Structures
DBMS

- Copyright © U Lectures.com -