Database Concepts and SQL Training : Introduction to Database Design Fundamentals
Database Concepts and SQL Training : Database Concepts
Relational Databases & its characteristics
Entities, Attributes and relationships
Keys Introduction and requirement
- Design Requirement
- Process Examples
Examples for Database Design
An introduction to SQL
What is SQL ?
Tune with SQL
SQL Server Design Architecture
SQL processing and various examples
Starting the SQL engine (installation)
SQL data types
Different Languages in SQL
Data manipulation In Database
Two dimension Table creation
Creating a table
- Creating a table from a table
- Insertion of Data Into a Table
Updating Table Contents
How to Delete Data from Table
Faces of select command
Table level and column level constraint
Check integrity constraints
SQL Clause and pattern
Union , Intersection & minus
Like and IN
Grouping and Sorting Data
Outer Join ( left , Right , Full )
Create and Drop
Types of Index
Views On Database
Creating and Updating views
Creating & Referring
SQL – Transaction
How to right the permissions on the object
Duration & Timings :
Duration – 30 Hours.
Training Type: Online Live Interactive Session.
Weekend Session – Sat & Sun 9:30 AM to 12:30 PM (EST) – 5 Weeks. July 21, 2018.
Weekday Session – Mon – Thu 8:30 PM to 10:30 PM (EST) – 4 Weeks. August 6, 2018.
Weekend Session – Sat & Sun 9:30 AM to 12:30 PM (EST) – 5 Weeks. September 8, 2018.
Weekday Session – Mon – Thu 8:30 PM to 10:30 PM (EST) – 4 Weeks. October 15, 2018.