Title: SQL server online training
1SQL 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
3What 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
4SQL 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
5Components 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
6Instance 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
7Process of sql
Reach Us Tectist.com Contact Us 1
(720)-463-3800
8Commands 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
9commands
- 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
10commands
- 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