Duration : 10 Days

Fees : 4000 /-

We live in a data-driven world now, and with all that data, people have to search through it to find insights to help inform strategy, marketing, operations, and a plethora of other categories. There are a ton of business that use large, relational databases, which makes basic understanding of SQL is a great employable skill not only for data scientists, but for almost everyone.

Introduction to SQL

Data Definition Language (DDL)

Data Manipulation Language (DML)

Introduction to SQL Server

SQL Server Management Studio

Create a new Database

Queries

Create table

Database Modelling

Create Tables using the Designer Tools

SQL Constraints

  • Primary key
  • Foreign key
  • Not null / required columns
  • Unique
  • Check
  • Default
  • Auto increment or identity
  • Alter table

Insert into

Update

Delete

Select

  • The order by keyword
  • Select distinct
  • The where clause

Operators

  • Like operator
  • In operator
  • Between operator
  • Wildcards
  • And & or operators
  • Select top clause
  • Alias
  • SQL joins
  • SQL scripts
  • Using comments
  • Variables
  • Flow control
  • Cursor
  • Views
  • Stored Procedures
  • Functions
  • Triggers
  • Communication from other Applications
  • ODBC