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