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