SQL for Data Science in Bangalore
RELATED RECENT PLACEMENTS
Rohit Mali
William O'Neil India
NMIMS MUMBAI
Dhiraj Satghare
RD Civil Solution
Acharya Shrimannarayan Polytechnic
Namrata Rao
Piaggio & C. S.p.A.
Rajeev Gandhi College of Engg and Research Institute
Siddhi Parab
C.C Engineers
lokmanya tilak college of engineering
Anil Katarkar
3D engineering
NATIONAL INSTITUTE OF TECHNOLOGY
Bhavesh Kumbhare
Dar Al-Handasah Engineering company
Rashtrasant Tukadoji Maharaj Nagpur University
Akash Bhadkumbe
XS CAD
Dr. D Y Patil College of Engineering & Innovation, Varale
Madhura Joshi
NEILSOFT LIMITED
Government Polytechnic Ratnagiri
Syllabus
This course is full of best-in-class content by leading faculty and industry experts in the form of videos and projects
Course Overview
Structured Query Language, or SQL, is used to manage and interface with relational databases. All industries operate on versatile databases that hold their information. With SQL, data can be accessed, manipulated, stored, and extracted efficiently. For data scientists and other professionals in the field, knowledge on SQL is mandatory to working with structured data.
This course will provide students with an elaborate understanding of the following:
- 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
Throughout this course, students will get to complete challenges and projects that require extensive handling of structured data.
Who can enrol in this course?
Engineering graduates and working professionals with a background in similar fields.
Course Syllabus in Bangalore
On a daily basis we talk to companies in the likes of Tata Elxsi and Mahindra to fine tune our curriculum.
Week 1 - Introduction
In this week, students will learn about
- 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
In this week, students will learn about
- 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
In this week, you will learn about
- 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
In this week, students will learn about
- Generating Strings
- String Functions
- Date Functions
- Conversion Functions
Week 5 - Database Selection
In this week, students will learn about
- 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
In this week, students will learn about
- 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
In this week, students will learn about
- 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
In this week, students will learn about
- 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
In this week, students will learn about
- 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
In this week, students will learn about
- 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
In this week, you will get a hands-on understanding of the following
- 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
In this week, you will get a hands-on understanding of the following
- Working with Python
- Accessing SQL data with Python
- Running basic SQL statements with Python
- Running inbuilt python functions on SQL data
Our courses have been designed by industry experts to help students achieve their dream careers
Industry Projects in Bangalore
Our projects are designed by experts in the industry to reflect industry standards. By working through our projects, Learners will gain a practical understanding of what they will take on at a larger-scale in the industry. In total, there are 2 Projects that are available in this program.
C2C E-Commerce User’s Behaviour Analysis
In this project, students are expected to analyze user behavior in a C2C E-Commerce business. Analyzing the user’s database will help understand the business perspective. The behavior of the users can be traced in terms of business with an exploration of the user’s database.
Analyzing the choice of career for the Alumni of Engineering College.
In this project, students are expected to analyze the career choices of alumni from an institution based on given data.
Our courses have been designed by industry experts to help students achieve their dream careers
Ratings & Reviews by Learners
Skill-Lync has received honest feedback from our learners around the globe.
Instructors profiles
Our courses are designed by leading academicians and experienced industry professionals.
1 industry expert
Our instructors are industry experts along with a passion to teach.
12 years in the experience range
Instructors with 12 years extensive industry experience.
Areas of expertise
- Full Stack development
- SQL
Find SQL for Data Science in other cities
Pune
Delhi
Hyderabad
Mumbai
Chennai
Similar Courses
Got more questions?
Talk to our Team Directly
Please fill in your number & an expert from our team will call you shortly.