SQL server online training - PowerPoint PPT Presentation

About This Presentation
Title:

SQL server online training

Description:

Tectist is one of the best online training institute, they are providing all the software and networking courses training with real time experts who are having 12+ years of experience providing live projects, they are expertise in SQL server Online Training . – PowerPoint PPT presentation

Number of Views:54

less

Transcript and Presenter's Notes

Title: SQL server online training


1
SQL SERVER Online Training
And placement program
BY
Tectist.com
Reach Us Tectist.com Contact Us 1
(720)-463-3800
2
What is SQL server
SQL SERVER might be a on-line database management
system developed by Microsoft. As a information
server, it might be wares with the primary
operate of sorting and retrieving info requested
by totally different code package applications
which may run either on constant portable
computer or on another portable computer across a
network beside the online.
Reach Us Tectist.com Contact Us 1
(720)-463-3800
3
What is the purpose of sql
  • SQL statements are most commonly used to perform
    tasks such as update data on a database, or
    retrieve data from a database. Some common
    relational database management systems that use
    SQL are
  • Oracle
  • Sybase
  • Microsoft
  • SQL Server
  • Access
  • Ingres etc

Reach Us Tectist.com Contact Us 1
(720)-463-3800
4
SQL SERVER USAGE
  • To create databases.
  • To maintain databases.
  • To analyze the data through SQL Server Analysis
    Services (SSAS).
  • To generate reports through SQL Server Reporting
    Services (SSRS).
  • To carry out ETL operations through SQL Server
    Integration Services (SSIS)

Reach Us Tectist.com Contact Us 1
(720)-463-3800
5
Components of SQl server
  • SQL Server works in client-server architecture.
    Hence it supports two types of components.
  • Workstation
  • Server

Reach Us Tectist.com Contact Us 1
(720)-463-3800
6
Instance of sql server
  • It is also similar type of installation.
  • It is also an exact copy of the same software.
  • If we install 'n' times, then 'n' instances will
    be created.
  • Two types of instances
  • Default
  • Named

Reach Us Tectist.com Contact Us 1
(720)-463-3800
7
Process of sql
Reach Us Tectist.com Contact Us 1
(720)-463-3800
8
Commands of SQl
  • The standard SQL commands to interact with
    relational databases are CREATE, SELECT, INSERT,
    UPDATE, DELETE and DROP. These commands can be
    classified into groups based on their nature.
  • DDL (Data Definition Language)
  • DML (Data Manipulation Language)
  • DCL (Data control Language)

Reach Us Tectist.com Contact Us 1
(720)-463-3800
9
commands
  • Data Definition language
  • Create It creates a new table
  • Alter Modifies an existing data.
  • Drop Deletes entire Table.

Reach Us Tectist.com Contact Us 1
(720)-463-3800
10
commands
  • Data manipulation language
  • Select Retrieves data from one or more
    tables.
  • Insert Creates a Record
  • Update Modifies Record
  • Delete Deletes Records
  • Data Control language
  • Grant Gives a privilege to user.
  • Revoke Takes back privileges granted from user.

Reach Us Tectist.com Contact Us 1
(720)-463-3800
11
Thank you
Reach Us Tectist.com Contact Us 1
(720)-463-3800
Write a Comment
User Comments (0)
About PowerShow.com