NSDC (National Skill Development Corporation) - SQL for Data Science
4.7 /5- Offered bySkill Lync
SQL for Data Science at Skill Lync Overview
Duration | 12 weeks |
Total fee | ₹40,000 |
Mode of learning | Online |
Credential | Certificate |
SQL for Data Science at Skill Lync Highlights
- Earn a certificate after completion of the course
SQL for Data Science at Skill Lync Course details
- Engineering graduates and working professionals with a background in similar fields
- Database Management System (DBMS)
- Relational Database Management System (RDBMS)
- Database creation, manipulation, selection, exploration
- Querying multiple tables
- Index, view, transaction
- Querying with conditions
- Stored procedures
- Integrating SQL with Excel and Python
- The course will explain the meaning, relationship, and structure of raw data and how to use SQL to shape it for analysis
- It includes two real-time projects and will cover topics like SQL Basics, differences between DBMS and RDBMS, Understanding of E-R diagrams, integrating SQL with Python and Excel, Joins, and more
- The topics in this course assist learner in exploring and analyzing the data effectively to create queries that are compact and efficient
- The hands-on experience will provide the added advantage of being able to practice structured queries
- It gives learner a chance to manipulate numeric, string, and date data types with the aid of functions to blend data from multiple sources into fields of the correct format for analysis
SQL for Data Science at Skill Lync Curriculum
Week 1 - Introduction
Data Science: Introduction
Data Science Applications
Why SQL is required for Data Science
Database Management System (DBMS)
Relational Database Management System (RDBMS)
Basic terminology in RDBMS
Data Constraints
Entity Relationship Model
What SQL is
Categories of SQL Commands
Hands-on execution of simple SQL statements on RDBMS tool
Week 2 - Database Creation and Manipulation
Detailed SQL Data types
Creating databases
Create Tables
Using Constraints
Inserting Table
Altering Table structure
Dropping Database and Table
Deleting and Updating
Hands-on importing of sample database schema
Week 3 - Database Selection
Select statements
Removing Duplicate use of Alias
Use of Where
Use of Wildcards
Limit clause
Arithmetic Operators
Mathematical Functions
Hands-on creating of backups and restore for large database
Week 4 - Database Selection
Generating Strings
String Functions
Date Functions
Conversion Functions
Week 5 - Database Selection
Comparison Operators
Logical Operators
Order By
Group By
Aggregate Functions
Using aggregate functions with Group by clause
Union Operator
Sub-query
Week 6 - Querying Multiple Tables
The need to Join Multiple Tables
Cartesian Product
Inner Join
Left Join
Right Join
Self Join
Delete Join
Update Join
Hands-on demonstration of joining more than two tables in a sample database
Week 7 - Data Exploration
What Data Exploration is
Structure of Data
Understanding the E-R Diagram
How to Use SQL for Data Exploration
Significance of
Joins
Sub queries
Inbuilt functions
Other important capabilities of SQL for data exploration
Hands on demonstration
Working with NULL values
Making trends in Data
Identifying Outliers
Creating Data Summary
Week 8 - Index, View, Transaction
Creating Index
Use of Index
Type of Index and Ine
X Strategies
Views
Views for Data Analysis
Multi-user database
What is Transaction
Save points
Hands-on working on Multi user database environment
Week 9 - Querying with Conditions
Querying with Conditions
The Searched Case Expression
The Simple Case Expression
Applications of Case Expression
Common Error Codes
Hands-on working with Json type data
Week 10 - Stored Procedures
Stored Procedures for Data Analysis
Creating Stored Procedures
Removing Stored Procedures
Altering Stored Procedures
Conditional Statements
Loops
Hands-on working with cursors
Week 11 - Integrating SQL with Excel
Accessing MySQL data with MS Excel
Running SQL statements with Excel
Combining Excel and SQL statements for data representation
Week 12 - Integrating SQL with Python
Working with Python
Accessing SQL data with Python
Running basic SQL statements with Python
Running inbuilt python functions on SQL data
SQL for Data Science at Skill Lync Entry Requirements
- Interested students and graduates in computer science and related engineering domains cap opt for SQL training
Other courses offered by Skill Lync
Student Forum
Anything you would want to ask experts?