Analyze Data with SQL

Live / Classroom Sessions

Duration : 30 Days

Live Classes Fee : 4,200 3,500

  • RDBMS , Getting Started with SQL
  • Retrieving data using the SQL
  • Sorting Data, Joining Multiple Tables
  • Analyze Real Data with SQL

Register for free live demo, Batch Starting 24 May, 2021 @ 6 PM

Request more info

Next Batch -
  • 21/12/2020
  • |
  • Tuesday
  • |
  • 03:30 AM
 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 -
  • 21/12/2020
  • |
  • Tuesday
  • |
  • 03:30 AM
 Register For Free Demo

Connect with us

Whatsapp Call
Next Batch -
  • 21/12/2020
  • |
  • Tuesday
  • |
  • 03:30 AM
 Register For Free Demo Enroll Now

Introduction to Oracle 11G-SQL

Duration : 30 Days

This module is intended for quality assurance engineers test engineers technical managers software engineers customer support engineers and anyone who needs to learn manual testing and also prepare for software testing certifications offered by ISTQB, QAI such as CTFL, CAST, etc

Login to Register
4,200
3,500
Next Batch -
  • 21/12/2020
  • |
  • Tuesday
  • |
  • 03:30 AM
 Register For Free Demo Enroll Now

Address

  • 11, Professor Colony, Bhanwarkuan Square, Indore
  • +917314289083-84
  • info@ssiedu.in

Courses

Copyright 2020 SSiDigital. All Rights Reserved.