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