SQL Online Training Call : +91 9441233734

http://onlinetrainingsexpert.com/sql-online-training.html

SQL ONLINE TRAINING

• Overview of Database Concepts

• Basic Database Concepts
• Concepts of Data, Metadata, Files
• Concepts of DBMS
• Database Models
• File Management Systems
• Relational Database Systems
• Procedural & Non procedural approaches
• Database Design
• E.F.Codd's Rules

• Normalization
• First Normal Form
• Second Normal Form
• Third Normal Form

• Introduction to SQL Server
• Features of SQL Server
• Different Editions of SQL Server
• Components of SQL Server
• Services of SQL Server
• Comparison of SQL Server with Oracle

• Database Design
• Logical & Physical database design
• Relational database design
• Creating databases

• Management Studio
• Basics of SQL
• Data types, expressions, operators
• Working with Queries & Clauses
• Creating Databases
• Creating Tables, Stored Procedures
• Working with Indexes & Views

• Sub queries
• Nested sub queries
• Correlated sub queries
• Derived tables

• Implementation of Data integrity
• Entity integrity
• Domain integrity
• Referential integrity
• Types of constraints

• Data Definition Language(DDL)
• Creation of table
• Modifying the structure of a table
• Dropping a table
• Working with different options

• Data Manipulation Language(DML)
• Inserting, updating & deleting operations
• Operators, Built-in functions, Grouping
• Working with multiple tables

• Joins
• Introduction to Joins
• Inner join
• Outer join
• Cross joins
• Unions

• Working with Indexes
• Introduction to indexes
• Creating, dropping indexes
• Complex indexes
• Clustered & non clustered indexes

• Implementing Views
• Introduction & advantages of views
• Creating views
• Altering, dropping views

• Data Control Language(DCL)
• Creating Users and Roles
• Granting & Revoking of Roles & Privileges

• Transaction Control Language (TCL)
• Introduction
• Transactions process & types of transactions (Implicit, Explicit)
• Working with Locks and Types of locks

• Transact-SQL (T-SQL)
• Introduction
• Data types
• Statements
• Batch Execution

• Working with Cursors
• Creating Cursors
• Cursors vs. Select
• Types of cursors, locks on cursors
• Advantages of cursors

• Implementing stored procedures
• Introduction to stored procedures
• Creating, executing, modifying, dropping sp's
• Executing extended sp's

• Implementing User Defined Functions
• Introduction
• Creating, executing, altering, dropping UDF's
• Deterministic, non-deterministic functions
• Scalar, multi-statement, built-in functions

• Implementing Triggers
• Introduction to Triggers
• Constraints vs Triggers
• Creating, altering, dropping triggers
• for/after/instead of triggers