Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
15 Hour(s) 31 Minute(s)
Language
English
Taught by
Shenggang Li
Rating
2 views
Course Overview
Learn SQLs & Python for SQLs by systematically solving more than 300 practical Questions
In this more than 16 hours course, we would teach the complete PostgreSQL Database, SQL, and Python for starting the career in data science! Please note, this is a really “for everyone’s” course.
You must take this course, not only because SQL and Python are so far the most useful tools for data analysis in the world, but also because you are learning a real hands-on as well as theoretical course about how to apply SQL and Python into practice! After you have solved and digested all those 300 practical questions, you will definitely become a real SQL & Python expert!
This is so far the most comprehensive guide to learn PostgreSQL database, PgAdmin management, all levels SQL commands and Python programming for SQL and database connections. One of most important features of this course is that it is a question proposition and solution based – we are trying to take a hands-on approach to tackle each practical problem while providing you a systematic explanation on theories.
This is also a business and data analytics jobs based course, as we have designed several real world and job interview projects for different levels’ students. We are not only proposing these questions and projects but also providing you with complete solution codes in SQL and Python
Upon completing this course, you’ll be able to apply SQL and Python to solve various data science, machine learning, statistical analysis and business problems under different environments and interfaces.
Want to be successful? Then join this course! You’ll learn by doing and meet various challenges!
Course Content
- 5 section(s)
- 241 lecture(s)
- Section 1 Introduction
- Section 2 Solve basic SQL & Python questions
- Section 3 Intermediate SQL and questions
- Section 4 Advanced SQL and questions
- Section 5 SQL projects for job interviews
What You’ll 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
Skills covered in this course
Reviews
-
AAnthony Leiva
great so far
-
aaman kumar
better voice
-
IIgor Semenenko
this course is obsolete. ENGINE.EXECUTE doesn't work; I have spent the last 3 days trying to execute code in video 25. The reason I got enrolled is that I struggled to connect Python and SQL. This course didn't advance me one bit in this direction. To learn basic SQL commands, one doesn't need a course - it is all available online and in textbooks.
-
AAnthony Lipphardt
The presenter in this course did a terrible job of presenting the material in an engaging way. I had to listen at 2x speed because the speaking pace was incredibly slow. Materials did not provide written code, which made it incredibly cumbersome to hand type all of the examples. This course is also working on a very outdated version of PostgreSQL, so it took additional time to orient myself to the new pgAdmin. Audio quality was poor or missing altogether in some sections.
