The complete SQL & Python for SQL with Hands-on Questions

Learn SQLs & Python for SQLs by systematically solving more than 300 practical Questions

Created by: Shenggang Li
Senior Data Scientist

What Will I Learn?

• All fundamental SQLs for everyone
• Complete Intermediate SQLs for job seekers
• Advanced SQLs for experienced learners
• More than 300 practical questions related to SQLs and Python
• How to utilize and manage PostgreSQL and Pgadmin interfaces to write SQLs
• Efficient Database administration
• How to solve real world & capstone projects about SQLs and Python
• Store procedures, triggers, regular expressions and statistical analysis with PostgreSQL & Python
• Business analysis methods and backgrounds such as cohort analysis, credit risk analysis, retail recommendation system, fraud detection and stock trend analysis
• How to work with Python, SQLs and external files together
• Comprehensive job interview guidance on SQLs and Python

Requirements

• Able to use computer including being able to install software
• Prior exposure to programming languages will be helpful

Target audience

• Anyone who desires to learn SQL, PostgreSQL, Pgadmin, Anaconda, Spyder, Python and Data Science
• Anyone who wishes to learn basic knowledge and skills statistics
• Anyone who needs to get started data analysis or science career using Database, SQLs and Python
• Anyone who wants to learn how to apply SQLs and Python into various business and industry areas
• Anyone who needs to expend and improve knowledge and skill set in Python, SQLs and PostgreSQL database administration