Apply SQL FOR DATA SCIENCE Course
TOOLS/PLATFORMS: MS SQL Server &
Python
Duration: 2 Weeks
Cost: $100
MODULE 1
INSTALL SQL PACKAGES AND
CONNECTING TO DB
- SQLAlchemy
- PyMySQL
MODULE 2
RDBMS (RELATIONAL DATABASE
MANAGEMENT) BASICS
- Basics of SQL DB
- Primary key
- Foreign key
MODULE 3
ARTIFICIAL NEURAL NETWORK (ANN)
- Retrieving data with select SQL
command - Where condition to pandas data
frame.
MODULE 4
ADVANCED SQL
- Order by clause
- Aggregate functions
- Group by clause
- Having clause
- Nested queries
- Inner join, outer joins, multijoin