SQL forms an integral part of IT industry and hence any IT professional should add this certification to his profile. SQL online training introduces you to this computer language, which is used to raise queries against the relational databases and also to obtain suitable answers.
SQL commands are used to construct statements that form sensible databases for detecting and understanding. More often, the IT concerns, adopt SQL as it forms the prime language that is used for database inquiries these days. SQL constitutes a block of codes nested inside one another with every block forming a logical module unit or task. SQL online training helps you to learn storing the SQL blocks in the databases and ways to reuse it.
- 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