Sunday, February 26, 2017

Online Training Course- Oracle SQL for Data Science

Upon the requests of many people who listened to my presentations, I have built the online course Oracle SQL for Data Science. This course requires that students already have basic knowledge about SQL. The following is the description of the course.

Most of the core business data in an enterprise are stored in relational databases that support Structure Query Language (SQL). When data scientists perform common tasks such as data cleanse, validation, manipulation and feature variable calculation using SQL within database environment, they can achieve important advantages such as more compact code, easy deployment and security in comparison to moving the data outside of the database to a separate analytics environment. The instructor Dr. Jiang Zhou is one of the pioneers in developing SQL based in-database analytics solutions that are used by banks and insurance companies. In addition to his technical skills, he is, as one of his clients put it, "a great trainer, and a good presenter of theoretical data mining concepts so that they can be understood by most".
In this course, students will learn practical Oracle SQL skills to solve problems such as:

  • Data Validation
  • Data Summary
  • Detect and Remove Duplicates
  • Binning Variable Based on Equal Frequency
  • Build Good Variables for Predictive Models or Business Rules, e.g., RFM Analysis, Time Elapse Since Last Purchase, Number of Transactions in Last 3 Days, Moving Average Purchase Amount in Last 7 Days
  • Random Sampling
  • Gain Chart
  • Using View to Organize Process Flows
  • Histogram
There are totally about 4 hours and 30 minutes video presentations. SQL scripts that create data sets and perform the Data Science tasks are provided. Slides are included so that students can easily find the topics that they interested in.

13 comments:

Jeffy said...

Thank you for sharing such a nice and interesting blog with us. Hope it might be much useful for us. keep on updating...!!
seo company in india
digital marketing company in india

Mohana M said...

Excellent Sharing. You have done great job. I gathered lots of new information. . Devops Online Training | Data Science Online Training

Logavani G said...

hi welcome to this blog. really you have post an informative blog. it will be really helpful to many peoples. thank you for sharing this blog.
android training in chennai

Logavani G said...

This is seriously good, you have really highlighted some of the great points one should know. Awesome work
Wonderful suggestions and guidance
python training in chennai

Siva Seo said...

Thank you for this valuable information. I have got some important suggestions from it. I'm working in Brave Technologies Private Limited. web designing company chennai

Nancy 12 said...

It was very nice blog to learn about Data Science.Thanks for sharing new things.. Data Science Training in Chennai

sai venkat said...

It is really a great work and the way in which u r sharing the knowledge is excellent.Thanks for helping me to understand basic concepts.

Data Science Online Training

raj kumar said...

Excellent Sharing. You have done great job. I gathered lots of new information. . keep sharing more blogs.


Data Science Training in Bangalore

Jayarajan K said...

SQL, managing a database is very important for big data analytics, R programming.

online aptitude training | learn core java online | MBA in marketing management | MBA in event management | Big data analytics training | Big data for beginners | annamalai university distance education mba | Analytics courses

Evelin Harriet said...

Nice article, I loved it. Thanks for sharing and keep sharing. Get a ERP software for you small business.For more details contact us.
erp in chennai
cloud erp in chennai
leather erp in chennai
trading erp in chennai
franchise erp in chennai

Mohana M said...

Well Said, you have provided the right info that will be beneficial to somebody at all time. Thanks for sharing your valuable Ideas to our vision.Big Data Hadoop Training in Bangalore | Data Science Training in Bangalore

vignesjoseph said...

It's really marvelous article blog.And it believes to you very helpful to me. Thanks a lot share this usual post.I am really happy to found such a helpful and interesting post that is written in a good manner. Thanks for receiving such an informative post. Selenium Training in Chennai | Selenium Training Institute in Chennai | Selenium Automation Testing Training in Chennai

hasara said...

Good admin.keep it up.your blog was informative. Thank you for sharing.The Millionaire Guide On Devops Training in Bangalore
Devops Training Institute in Bangalore