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

Course Features

  • Complimentary Life time Access to Core Java 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

  • 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 Java based web applications.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: Will to learn
  • Recommended for: Anyone who wants to learn and build Data Analytics/ ML/ AI Model or Python-based 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

  • Nitesh Sir, synonymous for C, C++, Data Structure and Python Training is a very seasoned trainer loved by students from last 11 years. His knowledge and delivery style for any entry level programming languages training for beginners specifically ' C, C++, Data Structure & Python ' is appreciated not only by graduates, undergraduates but by professionals also who are working on these technologies. He is the most preferred trainer of beginners.

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 on Wats app

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
5999
2999