Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQL : SQL Programming For Beginners
Rating: 3.4 out of 5(9 ratings)
399 students

SQL : SQL Programming For Beginners

Tutorial for SQL beginners with SQL Server Management Studio
Created bySuprio Dutta
Last updated 6/2025
English

What you'll learn

  • Sql required for Analysts etc,Sql sub queries ,correlated queries for Sql related to Microsoft Developers
  • WORKING with Stored Procedures,DDL AND DML Basics
  • working with SQL SERVER MANAGEMENT STUDIO
  • Sql related to Microsoft Developers

Course content

4 sections • 30 lectures • 3h 0m total length

  • start with sql sever management studio2:48
  • create database,create Table(Installation-resource file)4:33
  • create table using auto increment primary key5:26

    Create a table with an autoincrement primary key for a person, define last name, first name, city, and age as not null, then insert records to observe auto-generated ids.

  • select from table, select distinct8:10
  • Alter Table,Alter Column,Drop Column,Add Column6:45
  • Drop Databse4:13

    Learn how to create and drop a database in a SQL Server instance using the drop database command, and verify results by refreshing the database tree.

  • create Table4:33
  • drop table4:42
  • Primary Keys and Foreign Keys4:03
  • insert query(SQL full tutorial resource file)8:47
  • Update Query8:14
  • Delete Query4:50

    Learn to perform selective deletes in sql with delete from table where age >= 30, verify results using select all from the table, and ensure correct database and table naming.

  • select WITH WHERE Clause3:09
  • where AND clause5:32

    Learn to filter data using the where and clause in SQL, applying multiple conditions on profession, age, and availability with a sample table.

  • Or Clause5:30
  • Alias2:20
  • sum,average in sql3:16
  • max and min in sql3:16

Requirements

  • no complex programming knowledge required
  • the RDBMS basic concepts like what is a database,field,tuple etc., is optional

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.

Who this course is for:

  • students from engineering colleges and professional at companies like cognizant,IBM,IIHT,NIIT etc
  • students looking for career in sql development ,data analytics,.

Report abuse