SQL Online Training Call : +91 9441233734
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
No comments:
Post a Comment