Courses

img1

Dr. Abdul Kalam

11Th President of India

"There is no end to education. It is not that you read a book, pass an examination, and finish with education. The whole of life, from the moment you are born to the moment you die, is a process of learning. "

Testimonial

MS-SQL
Duration : 16 weeks
Fees :
  • SQL Server components and tools

    Fundamentals of the relational database engine

    Benefits of the Business Intelligence stack

    SQL Server Agent and Management Studio

    Integration Services

    Analysis Services

    Reporting Services

    Data Quality Services

    Master Data Services

    Building the Database

    Choosing optimal file size and growth parameters

    Working with database schemas

    Specifying appropriate data types

    Indexing tables with Management Studio

    Adding, modifying or removing columns

    Enforcing uniqueness through primary key constraints

    Validating conditions with check constraints

    Protecting relationships with foreign keys

    Leveraging Server Programmability

    Employing Query Designer to construct select statements

    Analyzing data for aggregate functions

    Retrieving data as an XML document

    Inserting new rows into tables

    Updating targeted data

    Deleting specific rows

    Creating stored procedures for productivity

    Writing user-defined functions to simplify queries

    Deploying triggers to capture change events

  • Administering SQL Server Databases

    Defragmenting data and checking database integrity

    Improving performance by rebuilding indexes

    Scheduling repeating jobs

    Implementing a backup strategy

    Displaying current activity and expensive queries

    Running reports with Management Studio

    Authenticating SQL Server and Windows logins

    Assigning users to database and server roles

    Granting or revoking permissions

    Integrating External Applications

    Pulling data from SQL Server into Excel

    Creating a front-end interface with Access

    Importing and exporting data from text files

    Migrating an Access database to SQL Server

    Advanced User Interfaces & WebKit Browser

    Embedding HTML Content in Apps with WebKit

    Displaying Analog and Digital Clocks

    Using Tabs to Display Multiple UIs

    Applying Standard Styles and Fonts

    Creating Reusable UI Components with Fragments

  • Implementing Business Intelligence Solutions

    Transforming and cleaning data

    Loading data into a data warehouse

    Designing reports quickly with the Report Builder

    Deploying reports for centralized access

    Building multidimensional cubes

    Predicting trends with data mining

    Leveraging SharePoint, Excel and Power Pivot

    Transferring data into knowledge with BI functionality