Tutorialspoint

SQL Programming

SQL with sql server management studio

Course Description

SQL is Structured Query Language, which is a computer language for storing, manipulating and retrieving data stored in a relational database.SQL is the standard language for Relational Database System. All the Relational Database Management Systems (RDMS) like MySQL, MS Access, Oracle, Sybase, Informix, Postgres and SQL Server use SQL as their standard database language.

SQL is widely popular because it offers the following advantages ,Allows users to access data in the relational database management systems.Allows users to describe the data.Allows users to define the data in a database and manipulate that data.Allows to embed within other languages using SQL modules, libraries & pre-compilers.Allows users to create and drop databases and tables.Allows users to create view, stored procedure, functions in a database.Allows users to set permissions on tables, procedures and views.

What is SQL?

  • SQL stands for Structured Query Language
  • SQL lets you access and manipulate databases
  • SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987

What Can SQL do?

  • SQL can execute queries against a database
  • SQL can retrieve data from a database
  • SQL can insert records in a database
  • SQL can update records in a database
  • SQL can delete records from a database
  • SQL can create new databases
  • SQL can create new tables in a database
  • SQL can create stored procedures in a database
  • SQL can create views in a database
  • SQL can set permissions on tables, procedures, and views

Goals

  • meant for back end developers, database administrators, data analytics

Prerequisites

  • no complex programming knowledge required
  • So, anyone who can use English at a basic level can learn and write SQL queries easily
  • the RDBMS basic concepts like what is a database,field,tuple etc., is optional
Show More

Curriculum

  • Start with management
    02:48
    Preview
  • Create Table with Auto-Increment primary key,
    05:26
    Preview
  • AUTO-INCREMENT PRIMARY KEY
    04:51
  • Delete Query
    04:40
  • Alter Table
    06:45
  • ALIAS IN Sql
    04:19
  • Update where
    08:14
  • Auto increment
    05:26
  • Top clause
    08:45
  • Update sub query
    12:37
  • Insert sub query
    05:07
  • Delete sub query
    05:52
  • Min max
    03:16
  • Sum avg
    03:16
  • SQL JOIN
    22:20
Feedbacks
  • No Feedbacks Posted Yet..!
SQL Programming
This Course Includes
  • 1.5 hours
  • 15 Lectures
  • 1 Resources
  • Completion Certificate Sample Certificate
  • Lifetime Access Yes
  • Language English
  • 30-Days Money Back Guarantee

Sample Certificate

sample certificate

Use your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

We have 30 Million registered users and counting who have advanced their careers with us.

X

Sample Certificate

Talk to us

1800-202-0515