This course is designed to benefit those who are looking to improve their database design and development skills. The course will be taught by the certified trainer with years of experience in database and SQL. This course is suitable for beginners, people thinking of changing career, students, graduates, professionals, company staff dealing with database/SQL.
Course Covers
- Introduction to SQL
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
- DATABASE Design
Syllabus
Relational Database Management System is the basis for SQL, and for all database design and development systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access. The data in RDBMS is stored in database objects called tables. SQL commands are used to perform select, insert, delete and update operations on database objects.
Module 1: Introuction to SQL
This module will cover the following lessons:- What is SQL
- SQL Programming Language
- RDBMS Concept in SQL
Module 2: Data Definition Language (DDL)
This module will cover the following lessons:- CREATE Statement
- DROP Statement
- ALTER Statement
Module 3: Data Manipulation Language (DML)
This module will cover the following lessons:- SELECT Statement
- INSERT Statement
- UPDATE Statement
- DELETE & TRUNCATE Statement
Module 4: DATABASE Design
This module will cover the following lessons:- Database Design Diagram
- Normalization