About the Course
This course on advanced SQL for data analysis has everything that is not covered in foundation SQL courses. The curriculum covers all the advanced techniques you ever need to wrangle and analyze data in the fastest and most efficient way possible. As a data analyst take your skills further so you can spend less time wrangling data and more time building models, everything is taught in the context of real-world analytics scenarios, meaning you’ll be ready to apply these techniques on the job from day one.
Salvatech will dig deep into the advanced toolbox that SQL has to offer, uncovering techniques to solve problems that leave even senior analysts scratching their heads. The course provides a treasure trove of coding exercises that give you ample opportunity for hands-on practice. You have an opportunity to practice every concept you learn, right after you learn it.
What will you Learn
- Train your brain with tons of hands-on exercises that reflect real-world business scenarios
- Make the leap to Senior Analyst by mastering advanced data wrangling techniques with SQL
- Master useful tips and tricks not found in most database courses, like Dynamic SQL
- Become the resident SQL expert on your team
- Gain an intuition for what technique to apply and when
Course Fee: N60,000
Duration: 6 weeks
Delivery Mode – Live, Instructor Led Online
Contact us for Group or Team Registration
Course Outline
SQL WITH MYSQL/POSTGRESQL – Advance
● Transaction Control Language
● MySQL/POSTGRESQL-Python Database connection
● SQL CASE statement
● Dropping records
● Understanding relationships
● Controlling numeric precision
● CONCAT function in SQL
● SQL Date functions
● SQL string functions
● Working with numeric data
● Controlling numeric precision
● The ALTER keyword
● Using ALIAS for tables and columns
● Querying
● The JOIN keyword
● Creating Views
● Creating Index
● The set/aggregate functions
● Reverse-engineering in SQL
● Performance tuning in SQL
● Regular Expressions and wildcards in SQL
● Importing data into an RDBMSs from external files
● Loading query results into an external file
