SQL Programming Training Course
Master SQL programming with SQL server management studio
Updated on Sep, 2024
Language - English
Development ,Database and Design Development,SQL
Lectures -15
Resources -1
Duration -1.5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
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.
Course 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
- meant for back-end developers, database administrators, and 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., are optional
Curriculum
Check out the detailed breakdown of what’s inside the course
Sql-Fundamentals
15 Lectures
-
Start with management
02:48
02:48
-
Create Table with Auto-Increment primary key,
05:26
05:26
-
AUTO-INCREMENT PRIMARY KEY
04:51
04:51
-
Delete Query
04:40
04:40
-
Alter Table
06:45
06:45
-
ALIAS IN Sql
04:19
04:19
-
Update where
08:14
08:14
-
Auto increment
05:26
05:26
-
Top clause
08:45
08:45
-
Update sub query
12:37
12:37
-
Insert sub query
05:07
05:07
-
Delete sub query
05:52
05:52
-
Min max
03:16
03:16
-
Sum avg
03:16
03:16
-
SQL JOIN
22:20
22:20
Instructor Details
SUPRIO DUTTA
IT Professional with 8+ Experience in software training and more than 10+ years at undergraduate and graduate level mathematics.
Mentoring Dotnet framework and its interrelated Corporate level Education .,MICROSOFT Visual studio DotNet,Microsoft sql server, my sql oracle server,objected oriented programing langauge like c++ and Java..and Azure.
knowledge offered is with Advanced topics in the desktop applications and consumed projects are mainly comprising of Enterprise based applications,client relationship management and E-Commerce.
offered training for Bank exams for more than 2+ years at Brillinace college ,Trivandrum,Kerala for candidates appearing for various Bank exmas and various other competitive exmas for subjects reasoning,numericals, Gk and English..
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now