Database Concepts and SQL Training

$300.00

Description

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

Functional Dependencies

Keys Introduction and requirement

Database Designs

  • Methods
  • Design Requirement
  • Process Examples

Normalization

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)

Interactive SQL

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

Data Constraints

Table level and column level constraint

Key concepts

Check integrity constraints

SQL Operators

SQL Functions

SQL Clause and pattern

Union , Intersection & minus

Like and IN

Grouping and Sorting Data

Group by

Order By

Joins

Inner join

Outer Join ( left , Right , Full )

Self Join

Cross Join

Sub Queries

Indexes

Create and Drop

Types of Index

Views On Database

Creating and Updating views

Renaming

Destroying views

Sequences

Creating & Referring

Altering Seq

Dropping Seq

Clone Table

SQL – Transaction

Commit

Rollback

Savepoint

Set Transaction

.

Granting Permission

How to right the permissions on the object

Object privileges

Create Roles

Duration & Timings :

Duration – 30 Hours.

Training Type: Online Live Interactive Session.

Faculty: Experienced.

Weekday Session – Mon – Thu 8:30 PM to 10:30 PM (EST) – 4 Weeks. April 1, 2024.

Weekend Session – Sat & Sun 9:30 AM to 12:30 PM (EST) – 5 Weeks. April 20, 2024.

DATABASE CONCEPTS & SQL REVIEWS 

I am not from computer background, Mr. Rajendra gives step by step guidance through installation and good real time examples. Easy to understand. The practice exercises are very good for learning the real time scenarios. Best place to learn T-SQL for beginners from Rajendra Trainer. Thanks for you time
Swetha

 

Had some good learning experience through the sessions conducted by Srinu and he was thorough professional and handled all queries raised during class and afterwards with ease and provided good real time examples
Srikanth

 

 For More Reviews 

 Inquiry Now         Discount Offer 

USA: +1 734 418 2465 | India: +91 40 4018 1306

LEARNTEK

© 2019 LEARNTEK. ALL RIGHTS RESERVED | Privacy Policy | Terms & Conditions



USA: +1 734 418 2465 | info@learntek.org Discount Offer
Season's Best Discount Offer End's in
Discount Offer