In this course, you would be learning all the concepts and terminologies related to the DBMS and Microsoft SQL Server. Upon completion of this course, you would have a fair knowledge about database and why data storage is so important and its use in the organization. Learn More...
In this course, you would be learning all the concepts and terminologies related to the Business Intelligence and Data Warehouse such as the OLTP, OLAP, ETL and much more. Upon completion of this course, you would be able to make DWH using BI tool. Learn More...
We provide assistance in creating ASP.Net Project using backend SQL Server for final year students of Engineering, MCA, BCA, MSc IT. This program is our most focus area to really help students to prepare them for industry ready professionals through our academic project guidance.
Database Concepts : Data and Database
DBMS / RDBMS
Data Models
Constraints
Normalization
ER Diagrams
Sql Server brief history
Sql Server 2014 Features
SSMS - SQL Server Management Studio
DDL
Data Types
System Defined Data Types
User defined Data
Create/modify/delete database / tables
Operators
DML | DCL
Using Select Statement
Constraints
Rules
Entity Integrity
Domain Integrity
Referential Integrity
Primary / Foriegn Key
Nested Sub Queries
Correlated Sub Queries
Derived tables
Recursive queries
Common Table Expression
Cross Join, Inner Join, Self Join, Outer Join
Indexes and why it needed : Clustered | Non Clustered
Creating indexes
Modifying indexes
Dropping indexes
About View | Creating - Altering Views
Stored Procedure Advantages | Creating Stored Procedure
User Defined Function and its uses
Cursors | Creating Cursors
Triggers | Creating Trigger
ACID Properties
Implicit / Explicit / Distributed Transactions
Transaction Process
Concurrency Problems
Lock Types
Dead Locks
What is Business Intelligence
SSIS
SSAS
SSRS
Understand the concepts of RDBMS & SQL Server Management Studio
Learn how to write simple and complex queries to retrieve data from the database
Understand how to Insert, delete, and update data
SQL Server is the leading database server used by most of the world's largest organizations to derive insights from their data and make decisions
With the growing demand for MS SQL-Server, the need for skilled professionals is increasing each day
SQL and Database Administrators
Software Developers
Business Intelligence professionals
Project Managers
Big Data and Hadoop Professionals
Business Analysts and Managers
Individuals aspiring for a career in SQL development
Mock interviews by Techzuke gives you the platform to prepare, practice and experience the real-life job interview
Familiarizing yourself with the interview environment
Our mock interviews will be conducted by industry experts
Why Business Intelligence
What is Business Intelligence
What is Data Warehouse
Why Data warehouse is required
Who needs Data warehouse
OLTP V/S OLAP
ETL
Data Mart
Metadata
Top-Down approach
Bottom-up approach
Sample view of DW design
What is ETL
ETL Tools
Selection criteria to choose ETL tool
OLAP Cube
Excel Pivot Report
DTS and its Limitation
SSIS Overview
Architecture
Flow Types
Tools
Utilities
Typical Uses
Launch Business Intelligence Development Studio (BIDS)
Use Package Designer
Use Toolbox
Use Solution Explorer
Use Properties Window
Use Variable Window
Using the SSIS Import and Export Wizard
Using the SSIS Designer
Control Flow Overview
Precedence Constraints
Execute SQL Task
Bulk Insert Task
File System Task
FTP Task
Send E-mail Task
Data Flow Overview
Data Sources
Data Destinations
Data Transformations
The Derived Column Transformation
The Data Conversion Transformation
The Conditional Split Transformation
The Aggregate Transformation
Event Handlers
Handling Errors in Data
Configuring Package Logging
Built-in log providers
DW Concepts
OLTP & OLAP
SQL Server Analysis services Architecture
Launch Business Intelligence Development Studio (BIDS)
Creating a Project using BIDS
MDX Fundamentals
MDX Expressions
MDX Operators
MDX Functions
Manipulating data with MDX
Data Source
Data Source View
Working with A DSV
Adding / Removing Table from a DSV
Create / Delete Relationship
Adding Named Queries
Multiple Data Sources within a DSV
Dimension and Dimension Properties
Dimension Creation using Dimension Wizard
Creating a Time Dimension
Translations in Dimensions
Defining Linked Dimensions
Unified Dimensional Model
Cubes
Cube Creation
Cube Structure
Cube Dimensions
Dimension Relationship
Integrating SSAS with Excel
Meet our team
