sql-database-training

MS-SQL Database training in Andheri, Thane Mumbai by working professional. Become expert in sql queries, master in performance tuning in sql server database, become sql developer, SQL query optimization techniques and much more.

FREE Job Assistance, Hands on Training, Interview Prepare Session, Live Project

You will get complete practical training on Database Management,Query Optimization techniques with experience on live projects. Each student will get to work on live client project from first week to gain maximum knowledge on the working of the industry. Course includes theoretical ,practical and live training at each stage. Analysis, database design and development,write complex SQL queries and functions, SQL Server, Administrator level database management, SQL Optimization techniques,advanced SQL topics like SQL Partitioning etc.
  • SQL Database Expert
  • SQL Database Support
  • PL-SQL Expert
  • SQL Database Developer
  • SQL DBA
16 Hrs. for complete advanced training.
Just Rs. 6000+GST 18%

SQL Database Training:

Databases and Entity Relations

  • What is database
  • What relational database
  • What is SQL and what is it used for?
  • How to create database in sql
  • Altering Database
  • Deleting Database

 

Table

  • What is table in sql
  • Types of table in sql
  • What is temporary table in sql
  • Types of temporary table in sql
  • What is local temporary table in sql
  • What is global temporary table in sql
  • Create table in sql
  • Alter table in sql
  • Delete table in sql
  • drop table in sql
  • truncate table in sql
  • Difference between delete and truncate
  • Constraints

 

Views

  • What is view in sql
  • How to create view in sql
  • Advantage of view in sql
  • Difference between table and view in sql

SQL Query

  • SQL – Insert Query
  • SQL – Select Query
  • SQL – Where Clause
  • SQL – AND OR Clauses
  • SQL – Update Query
  • SQL – Delete Query
  • SQL – Like Clause
  • SQL – Top Clause
  • SQL – Order By
  • SQL – Group By
  • SQL – Distinct Keyword
  • SQL – Sorting Results
  • SQL – Sub Query
  • Difference between Query and Sub Query
  • SQL – Union
  • SQL – Union All

SQL Joins

  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • FULL JOIN
  • CROSS JOIN
  • SELF JOIN

PL/SQL Tutorial

  • PL/SQL – Overview
  • PL/SQL – Environment
  • PL/SQL – Basic Syntax
  • PL/SQL – Data Types
  • PL/SQL – Variables
  • PL/SQL – Constants and Literals
  • PL/SQL – Operators
  • PL/SQL – Conditions
  • PL/SQL – Loops
  • PL/SQL – Strings
  • PL/SQL – Arrays
  • PL/SQL – Stored Procedures
  • PL/SQL – Functions
  • PL/SQL – Cursors
  • PL/SQL – Statements
  • PL/SQL – Records
  • PL/SQL – Exceptions
  • PL/SQL – Triggers
  • PL/SQL – Packages
  • PL/SQL – Collections
  • PL/SQL – Transactions
  • PL/SQL – Date & Time
  • Pivot and Unpivot
Timings Days Duration Course Fees Branch
11:00 AM to 6:00 PM (IST) SAT. & SUN. 16 hrs Just Rs.6,000+GST 18% Thane (W)
11:00 AM to 2:00 PM (IST) SAT. & SUN 16 hrs Just Rs.6,000+GST 18% Andheri (W)

 

Money Back Guarantee: If you do not like our training, you can ask for 100% course fees refund after your 1st class.
Special Offer: Join same day after FREE Demo class Get Instant 10% OFF.
Group Discount: 10% discount for 1 or more registrations * GST 18% Service Tax Including.

Free class on MS SQL Database Training!

Join FREE Demo Class on Weekend Saturday & Sunday.





Submit your review
1
2
3
4
5
Submit
     
Cancel

Create your own review

Average rating:  
 0 reviews