SQL TRAINING
- +91-8655841477
- 022-25350538
- training@iqratechnology.com
Course Overview
SQL (Structured Query Language) free online training course by Iqra IT Academy. This course is designed to help you understand how to write SQL (Structured Query Language) using Microsoft’s SQL Server Management Studio from scratch.
This course starts with SQL basics (perfect for beginners who want to learn SQL for the first time), then expands into More advanced SQL queries, Relational queries in SQL, Modifying databases with SQL.
In this course, you will learn about SQL queries, commands, syntax, subqueries, data types, etc. Introduction to Databases teaches you how to apply queries in SQL to create, read, update and delete data in a database, concepts of entity integrity constraint (including the definition of the concept of a foreign key), and the JOIN operation, and much more.
Every session comes with fresh challenge questions and real-world tasks and situations
Why You Should Take SQL Training
- SQL, though an old language, is highly significant today as companies across the world are gathering massive amounts of data for their growth.
- SQL consistently ranks high skills and learning it will add great value to your array of skills.
Training Map
Course Duration
3 Weeks
Training Days
Monday to Friday 90 Minutes/Day
Training Format
Online Training
Course content:
- SQL Introduction
- Intalling and Loggin in to SQL Server
- Windows Authentication
- SQL Server Authentication
- What is Data, DBMS
- What is relational DBMS
- SQL Basic Syntax
- SQL Commands: DDL, DML, DCL
- Select
- How to create Northwind Sample database
- SQL Data types
- Create Database
- Drop Database
- Rename Database
- Select Database
- What is Table
- CREATE TABLE
- DROP TABLE
- DELETE TABLE
- RENAME TABLE
- TRUNCATE TABLE
- COPY TABLE
- TEMP TABLE
- ALTER TABLE
- SELECT
- SELECT DISTINCT
- SELECT COUNT
- SELECT TOP
- SELECT FIRST
- SELECT LAST
- SELECT AS/Alias
- SELECT IN
- Insert Into
- Null values
- Update
- Delete
- Like
- Wildcards
- In; nested queries
- Between
- NOT NULL
- UNIQUE
- PRIMARY KEY
- FOREIGN KEY
- CHECK
- DEFAULT
- INDEX
- Auto Increment
- How to create database diagram
- setting up constraint using query and wizard
- One to One
- One to Many
- Many to Many
- (INNER) JOIN
- LEFT (OUTER) JOIN
- RIGHT (OUTER) JOIN
- FULL (OUTER) JOIN
- Understanding Subqueries
Requirements:
- There are no programming skills necessary to take this course
- There is no special software needed for this course, we’ll download the trial version of Miscrosoft SQL Server.
Training Key Features:
- We provide video recording sessions of training so in case if student missed any class he/she can utilize those recorded sessions.
- All our training program are based on live industry projects.
- All our training program are based on current industry standard.
Expert Teaching
We Provide expert teaching
Practicals
We Provide practicals
Exams
We provide Exams after completion of each course
