Duration : 10 - 12 days

Fees : 6500 /-

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.

MS SQL Background and Concepts

  • 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