Introduction to SQL
In this course, you will learn how to execute SQL commands to create. Define, select, manipulate, control access, aggregate and join data and data tables and also how to use subqueries. Optimizing SQL queries and cleaning data, and introduction to advance JOINs to enhance analysis performance.
Course Outline
SQL and Python integration
In this course. you will learn how to set up your Python SQL Server Integration: At the end of course, you will be able to
- Establish the SQL Server connection
- Running an SQL query and extracting query results
- Automating the Python and SQL Server functioning