SQL Course at Intellipaat Overview
Duration | 30 hours |
Start from | Start Now |
Total fee | ₹15,048 |
Mode of learning | Online |
Official Website | Go to Website  |
Credential | Certificate |
- Overview
- Highlights
- Course Details
- Curriculum
- Admission Process
- + 1 more item
SQL Course at Intellipaat Highlights
- Earn a certificate after completion of course from Microsoft
- 32 Hrs Project & Exercises
- Lifetime free course upgrades
- Flexible schedule
- Job assistance facility available
- Fee can be paid in instalments
SQL Course at Intellipaat Course details
SQL Architecture
Triggers
Joins
Database Normalization
SQL Views
Functions
Stored Procedures
User-defined Functions
Transact-SQL
Indexes
Concurrency Control
Exception handling
This SQL Course enables you to manage and optimize databases, perform operations, migrate them to the cloud, and scale them on demand. Accredited by Microsoft, it is taught by top industry experts who are certified by Microsoft.
You’ll learn how to use SQL to unlock valuable information, that is high in demand as businesses rely more on data.
This course will help you prepare for the developing industry while getting a Microsoft SQL certification that companies trust.
Schedule (Sat - Sun)
08:00 PM - 11:00 PM
SQL Course at Intellipaat Curriculum
Module 1 - Introduction to SQL
Various types of databases
Introduction to Structured Query Language
Distinction between client-server and file-server databases
Understanding SQL Server Management Studio
SQL table basics
Data types and functions
Transaction-SQL
Authentication for Windows
Data control language
The identification of the keywords in T-SQL, such as Drop Table
Module 2 - Database Normalization and Entity Relationship Model
Entity-Relationship Model
Entity and Entity Set
Attributes and types of Attributes
Entity Sets
Relationship Sets
Degree of Relationship
Mapping Cardinalities, One-to-One, One-to-Many, Many-to-one, Many-to-many
Symbols Used in E-R Notation
Module 3 - SQL Operators
Introduction to relational databases
Fundamental concepts of relational rows, tables, and columns
Several operators (such as logical and relational), constraints, domains, indexes, stored procedures, primary and foreign keys
Understanding group functions
The unique key
Module 4 - Working with SQL: Join, Tables, and Variables
Advanced concepts of SQL tables
SQL functions
Operators & queries
Table creation
Data retrieval from tables
Combining rows from tables using the inner, outer, cross, and self joins
Deploying operators such as ‘intersect,’ ‘except,’ ‘union,’
Temporary table creation
Set operator rules
Table variables
Module 5 - Deep Dive into SQL Functions
Understanding SQL functions – what do they do
Scalar functions
Aggregate functions
Functions that can be used on different datasets, such as numbers, characters, strings, and dates
Inline SQL functions
General functions
Duplicate functions
Module 6 - Working with Subqueries
Understanding SQL subqueries, their rules
Statements and operators with which subqueries can be used
Using the set clause to modify subqueries
Understanding different types of subqueries, such as where, select, insert, update, delete, etc.
Methods to create and view subqueries
SQL Course at Intellipaat Admission Process
Important Dates
Other courses offered by Intellipaat
Student Forum
Anything you would want to ask experts?