Using R with Databases (SKO 8101)

Loading...
icon

icon
Loading...
course-icon

Course

org-logo
Using R with Databases (SKO 8101)

Using R with Databases (SKO 8101)

Self-Paced

time-icon

Duration

10 hours
fee-icon

Fee

Loading...

NOS 8101

If you are a database professional (Data Engineer, DBA, Database Developer, etc.) and looking to leverage the power of R to analyze and visualize data in relational databases then Using R with Databases will work for you. This NASSCOM approved course will satisfy NOS 8101, PCs 1-8.

N8101

  • PC1. Identify the objective of the analysis
  • PC2. Define the type of data to be imported
  • PC3. Define the volume of data to be imported
  • PC4. Define the key variables to be imported
  • PC5. Identify suitable sources for the data
  • PC6. Perform operations to acquire the data and store it in datasets or data frames
  • PC7. Populate metadata for the imported data
  • PC8. Validate imported data using appropriate tools & processes

Do you want to leverage the power of R to unlock the value of data in relational databases?

Are you a SQL professional and looking to get skilled in data science?

Are the limits of R programming language preventing you from analyzing very large data sets?

If you answered yes to any of these questions, this course is for you. It will introduce you to the benefits of using R with databases. Teach you how to connect to databases from R. Show you how to create database objects, populate the database, and issue SQL queries to retrieve and modify your data from R. The course will also delve into advanced topics of using stored procedures and utilizing in-database analytics with R.

  • Module 1 - R and Relational Databases
  • Module 2 - Connecting to Relational Databases using RJDBC and RODBC
  • Module 3 - Database Design and Querying Data
  • Module 4 - Modifying Data and Using Stored Procedures
  • Module 5 - In-Database Analytics with R
  • None
  • The minimum passing mark for the course is 60%, where the review questions are worth 40% and the final exam is worth 60% of the course mark.
  • You have 1 attempt to take the exam with multiple attempts per question.
  • None.
  • Rav Ahuja is a Senior Manager with IBM Canada Lab specializing in Data Science and Big Data analytics. He is part of the Emerging Technologies team and is involved in incubating offerings for Data and Analytics Professionals. Rav also leads the work on partnerships and private portals for BDU. He presents at events worldwide and has authored numerous papers, articles, books and courses on subjects in managing and analyzing data. Rav holds B. Eng. from McGill University and MBA from University of Western Ontario.

    Grant Hutchison had worked with IBM for 18 years as Senior Engineer and Manager at IBM Canada (1991-2009). He held various roles including: Software Development, Support, Quality Assurance, Marketing, Sales, Training, and Product Management. Since 2010, he has been focusing himself as a computer science teacher in Toronto District School Board. He has two Bachelors degrees and a Master degree in software engineering from three well-known universities in Ontario, Canada. Grant Hutchison published a book, and holds a patent in software system and database.

    Course Outline

    Why Learn with SkillUp Online?

    We believe every learner is an individual and every course is an opportunity to build job-ready skills. Through our human-centered approach to learning, we will empower you to fulfil your professional and personal goals and enjoy career success.

    tick

    Reskilling into tech? We’ll support you.

    tick

    Upskilling for promotion? We’ll help you.

    tick

    Cross-skilling for your career? We’ll guide you.

    icon

    Personalized Mentoring & Support

    1-on-1 mentoring, live classes, webinars, weekly feedback, peer discussion, and much more.

    icon

    Practical Experience

    Hands-on labs and projects tackling real-world challenges. Great for your resumé and LinkedIn profile.

    icon

    Best-in-Class Course Content

    Designed by the industry for the industry so you can build job-ready skills.

    icon

    Job-Ready Skills Focus

    Competency building and global certifications employers are actively looking for.

    Newsletters & Updates

    Subscribe to get the latest tech career trends, guidance, and tips in your inbox.

    FAQs

    Using R with Databases (SKO 8101)

    Newsletters & Updates

    Subscribe to get the latest tech career trends, guidance, and tips in your inbox.