SSi|Digital
Next Batch Online -
  • 24/May/2021
  • |
  • Monday
  • |
  • 06:00 PM
 Register For Free Demo

Course Features

  • Complimentary Life time Access to Sql Online course
  • Course mentored by Industry expert
  • Project-based learning which will add stars to your resume
  • Course completion certificate
  • 1 Minor Project based on real-world applications

Course Overview

  • The role of a data scientist is to turn raw data into actionable insights. Much of the world's raw data—from electronic medical records to customer transaction histories—lives in organized collections of tables called relational databases. To be an effective data scientist, you must know how to wrangle and extract data from these databases using a language called SQL . This course teaches syntax in SQL shared by many types of databases, such as PostgreSQL, MySQL, SQL Server, and Oracle. This course teaches you everything you need to know to begin working with databases today! The course includes 2 minor projects based on real-world applications with guided lab sessions.
  • It will be an online live (Live Stream) class, so you can attend this class from any geographical location. It will be an interactive live session, where you can ask your doubts to the instructor (similar to an offline classroom program).
  • Pre-requisites: Only Will to learn
  • Recommended for: Anyone who wants to learn and build Data Analytics/ ML/ AI Model or develop web applications, specifically
    • 1. College students who are looking for training in Python/ NumPy/ Pandas/ Matplotlib/ Django/ Flask
    • 2. Working Professionals who want to learn backend development with Python / Django/ Flask or Data Analytics

Course Mentor

  • Experts with 10-12 years of practical experience.

Course Content

  • Data, Database Concept
  • Entity, Relation
  • RDBMS Concept
  • Normalization
  • Codd’s Rules
  • List the capabilities of SQL SELECT statements
  • Execute a basic SELECT statement
  • Projection and selection of the rows
  • Limit the rows that are retrieved by a query
  • Sort the rows that are retrieved by a query
  • Use ampersand substitution to restrict and sort output at runtime

  • Describe various types of functions available in SQL
  • Use character, number, and date functions in SELECT statements
  • Describe various types of conversion functions that are available in SQL
  • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  • Apply conditional expressions in a SELECT statement (CASE, DECODE)
  • Identify the available group functions
  • Describe the use of group functions
  • Group data by using the GROUP BY claus
  • Include or exclude grouped rows by using the HAVING clause

  • Write SELECT statements to access data from more than one table using equijoins and no equijoins
  • Join a table to itself by using a self-join
  • View data that generally does not meet a join condition by using outer joins
  • Generate a Cartesian product of all rows from two or more tables
  • Define subqueries
  • Describe the types of problems that the subqueries can solve
  • List the types of subqueries
  • Write single-row and multiple- row subqueries
  • Describe set operators
  • Use a set operator to combine multiple queries into a single query
  • Control the order of rows returned

  • Describe each data manipulation language (DML) statement
  • Insert rows into a table
  • Update rows in a table
  • Delete rows from a table
  • Control transactions
  • Advance DML statement:- multiple Insert, Insert all
  • Categorize the main database objects
  • Review the table structure
  • List the data types that are available for columns
  • Create a simple table
  • Explain how constraints are created at the time of table creation
  • Flashback
  • Functionality of recycle Bin
  • Purge
  • Describe how schema objects work

  • Create simple and complex views
  • Retrieve data from views
  • Inline views
  • Top –N Analysis
  • Create, maintain, and use sequences
  • Create and maintain indexes
  • Create private and public synonyms
  • System security and data security
  • user creation and management
  • grant, revoke, with grant option
  • System Privileges
  • Objects Privileges
  • Public synonyms
Next Batch Online -
  • 24/May/2021
  • |
  • Monday
  • |
  • 06:00 PM
 Register For Free Demo

Connect with us on Whats app

+91-7314289083

Python Programming

Duration : 45 Days

This course will help you to learn Python Programming Language which is basic to build Scientific Computing, Data Science, Data Analytics, Machine Learing and AI models and general purpose web applications. The course will be mentored & guided by an Industry expert having hands-on experience in the design, development & maintenance of Python applications

Login to Register
5999
2999

This coaching is not available for purchase.