Tutorialspoint

#May Motivation Use code MAY10 for extra 10% off

SQL Programming Training Course

person icon SUPRIO DUTTA

4.3

SQL Programming Training Course

Master SQL programming with SQL server management studio

updated on icon Updated on May, 2024

language icon Language - English

person icon SUPRIO DUTTA

English [CC]

category icon SQL,Development

Lectures -15

Resources -1

Duration -1.5 hours

4.3

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

SQL is a 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 Systems. 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 Programming Online Training Overview

SQL is widely popular because it allows users to access data in relational database management systems. A user can describe the data with SQL. It 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 views, stored procedures, and functions in a database. Allows users to set permissions on tables, procedures, and views.

This online video course will teach you everything you need to know about SQL programming, from the basics to advanced topics. You will learn about SQL syntax, data types, operators, functions, and more. You will also learn how to write SQL queries to retrieve, insert, update, and delete data in databases.

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 into 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

What will you learn in this course:

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


Prerequisites

What are the prerequisites for this course?

  • 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., are optional
SQL Programming Training Course

Curriculum

Check out the detailed breakdown of what’s inside the course

Sql-Fundamentals
15 Lectures
  • play icon Start with management 02:48 02:48
  • play icon Create Table with Auto-Increment primary key, 05:26 05:26
  • play icon AUTO-INCREMENT PRIMARY KEY 04:51 04:51
  • play icon Delete Query 04:40 04:40
  • play icon Alter Table 06:45 06:45
  • play icon ALIAS IN Sql 04:19 04:19
  • play icon Update where 08:14 08:14
  • play icon Auto increment 05:26 05:26
  • play icon Top clause 08:45 08:45
  • play icon Update sub query 12:37 12:37
  • play icon Insert sub query 05:07 05:07
  • play icon Delete sub query 05:52 05:52
  • play icon Min max 03:16 03:16
  • play icon Sum avg 03:16 03:16
  • play icon SQL JOIN 22:20 22:20

Instructor Details

SUPRIO DUTTA

SUPRIO DUTTA


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515