Loading Events

« All Events

SQL Training for Data Science

September 25 @ 10:00 am - September 27 @ 4:00 pm

N40000
SQL Training

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

 

Prerequisites

  • Laptop
  • Interest in Data Science

 

Course Schedule:

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

Details

Start:
September 25 @ 10:00 am
End:
September 27 @ 4:00 pm
Cost:
N40000
Event Category:
Website:
www.datalab.com.ng

Venue

Datalab Training Centre
Suite 33 Mazfalah Plaza
Karu Site Round-About Abuja, F.C.T 23401 Nigeria
Phone:
08139608388
Website:
www.datalab.com.ng

Organizer

Datalab Technology Limited
Phone:
08139608388
Email:
training@datalab.com.ng
Website:
www.datalab.com.ng