- This event has passed.
SQL Training for Data Science
September 25 @ 10:00 am - September 27 @ 4:00 pmN40000
SQL (Structured Query Language) is the most popular database language for Data Scientists.
SQL Training is designed to facilitate retrieving specific information from databases, and that’s exactly what Data Scientists do. To put it simply, SQL is the language of databases that every Data Scientist MUST know. That also matters because most companies now store their data in databases.
WHAT TO EXPECT FROM THIS COURSE
(SQL + R + PYTHON)
This training is for aspiring data scientists. We will start with basic examples and gradually move toward more complex SQL queries. By the end of this training, you will know how to write SQL queries and integrate your database with R and Python to solve Data Science problems.
SQL Training Course Outline
- Introduction to Relational Databases
- Introduction to SQL and Databases
- Integrating SQLite and PostgreSQL Databases with Python
- Integrating SQLite and PotgreSQLDatabases with R
- Querying SQL Databases with Python and R for Data Science Tasks
- Using SQL Data Manipulation and Data Query Language e.g Insert, Concatenate, Create, Update, Delete queries, Select, Where clause, Order By Clause, Distinct Keyword, Isnull() function, Column aliases e.t.c
- Restricting and Sorting Data with SQL, and continuing Analysis with R or Python
- Joining Tables with SQL Joins
- Combining SQL Joins with Subqueries
- Arithmetic Operators in SQL
- Using Built-In Functions and Expressions
- Capstone Project
What you will learn
- How Companies use Database
- How to connect R and Python to SQL Database
- How to retreive data from SQL Database and analyze in R Studio
- How to retreive data from SQL Database and analyze with Pandas in Jupyter Notebook
- How to write simple to complex SQL queries to obtain useful information from database
- How to perform data sorting with SQL for Data Science Tasks
What you will Earn
A Professional Certificate in SQL For Data Science
- Interest in Data Science
Duration: 3 Days
Time: 10am – 3pm (Fri and Sat) and (1pm on Sunday)
Date: 25th Oct – 27th Oct. 2020.
Course Fee: N40,000
Register Below to Attend
This form is disabled.