In short, Structural Query Language is called as SQL. It is the base to enter into Analytics, Datawarehouse and various jobs. Since past few years, data is increasing rapidly from multiple sources due to various reasons. Whenever data increases, SQL requirement also increases. It is a common Database language to interact with any Databases like MySQL, Postgres, SQL Server, Oracle, DB2, etc. SQL is required in most of the project related to Banking, Healthcare, Telecom, Finance, etc. This Course is designed from basic to advanced level topics based on IT industry requirement. From this course, you will learn all the topics required for real-time project work. This course will help you to build your career as the role of Development, Database/ETL Testing, Support, DBA, etc.
Course Objectives
What are the Course Objectives?
- Understanding high-level Architecture of Database.
- Work independently in Development, Support and Testing Project.
- In-depth knowledge of various advanced concepts.prepare the Complex queries.
- Upgrade database related technologies like DBA, Datawarehouse, Bigdata, ETL, etc.
Who should go for this Course?
- Any IT experienced Professional.
- Any B.E/ B.Tech/ BSC/ M.C.A/ M.Sc Computers/ M.Tech/ BCA/ BCom College Students in any stream.
- Fresh Graduates
Pre-requisites:
The course can learn by any IT professional having basic knowledge of :
- Computer System
- DBMS Concepts
Course Curriculum
BASIC CONCEPTS
- Database Concepts
- RDBMS Concepts
- Data Models
- Constraints
- Normalization- 1NF,2NF,3NF,BCNF etc
- ER Diagrams
SQL SERVER CONCEPTS
- Introduction to Sql Server 2008 R2
- Sql Server 2008 Features
- Server Types
- Editions
- Components
- Management Studio
- T-SQL Features
- New Operators
- DML Statements
T-SQL
- DDL
- Data Types
- System Defined Data Types
- User defined Data
- Create/modify/delete tables
- Operators
- DML
- DCL
- Using Select Statement
MAINTAINING DATABASE INTEGRITY
- Constraints
- Rules
- Entity Integrity
- Domain Integrity
- Referential Integrity
SUBQUERIES
- Built-in function
- Nested Sub Queries
- Correlated Sub Queries
- Derived tables
- Recursive queries
- Common Table Expression
JOINS
- Cross Join, Inner Join, Self Join, Outer Join
INDEXES
- Types of Indexes
- • Creating indexes
- Modifying indexes
- Dropping indexes
VIEWS
- About View
- Creating Views
- Altering Views
- Materialized Views
- Distributed View
STORED PROCEDURES
- Advantages
- System Stored Procedures
- Extended Stored Procedures
- Parameter Handling
USER DEFINED FUNCTIONS
- Returning Scalar Value
- Returning Table of Data
- Deterministic Functions
- Non Deterministic Functions
TRIGGERS
- Constraints Vs Triggers
- After Triggers
- Instead of Trigger
- DDL Triggers
- Altering and Dropping Triggers
CURSORS
- Select Vs Cursors
- Types of Cursors
- Creating Cursors
- Open/Fetch/Close Cursors
- Using Cursors in Stored Procedures and Triggers
MICROSOFT .NET FRAME WORK INTEGRATION
- CLR Integration
- UDA
- UDF
- Stored Procedures
- Triggers
TRANSACTIONS AND LOCKS
- ACID Properties
- Implicit Transactions
- Explicit Transactions
- Transaction Process
- Concurrency Problems
- Lock Types
- Distributed Transactions
- Dead Locks
DATA TRANSFORMATION SERVICES
- BCP
- DTS
ADMINISTRATIVE TASKS
- Creating Database
- Copy, Maintaining Database
- Security Concepts
- Schemas, Permissions
- Backup and Restore Database
- Sql Server Agent
- Sql Server Profiler
- Database Engine Tuning Adviser
SQL SERVER MANAGEMENT OBJECTS
- Programming with SMO
- Connecting to Sql Server
- Scripting
XML IN SQL SERVER
- XML in Sql Server
WORKING WITH IMAGES
- Working with Images
INTRODUCTION TO MS- BI
- SSRS
- Standard, Ad- hoc Embedded Reports
- SSIS
- SSAS
SQL SERVER 2012 FEATURES
- Sequence
- OFFSET and FETCH
- WITH RESULT SETS in stored procedure THROW in triggers