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