infyni

Core Java and SQL for Beginners

This live online course combining Java and SQL is a very popular course. Unlike prerecorded sessions, learning is easier when your trainer interacts with you in every class and answers your doubts on the spot. So join us for a free trial to try it.

Live Course

Live Class: Saturday, 11 Nov

Duration: 35 Hours

Enrolled: 53

Offered by: infyni

Client: NRIVA

(10)

Live Course

$68

Enrollment Closed Notify Me

About Course

In this live online course you will not only learn Java but you will master the fundamentals of SQL Server. Along with exceptional handling and multi-threading, this interactive training is taken by instructors who will clarify your doubts on the spot. Java is a popular and powerful programming language used by a large number of Fortune 500 companies to build their back-ends.

It’s also the foundation of many Android applications. If you want to work in back-end web development, mobile development, and desktop applications, Java is a great language for you. Combined with SQL, you’ll be able to incorporate database tasks with your development work. 

Most Java developers interested in employing SQL in their work will do so through JDBC, which allows Java to connect to SQL databases. Here are some reasons why experts say you should learn an SQL course:

  • It is easy to install using a setup wizard
  • It has improved performance Several SQL server editions keep coming up
  • It has a highly secure database that makes it nearly hard to breach security
  • It has excellent data restoration and recovery mechanism. It costs lower to own

Offered along with Java, this course can be the perfect training for the current market needs. You will have a project on Java as assignment. In addition, your instructor will discuss frequently asked coding interview questions. So join us for this popular course.

Skills You Will Gain

OOPs Concepts JAVA Features Array Pacjages Exceptional Handling Multithreading Wrapper Class InnerClass AWT SWING (JFC) GUI Programming Applets SQL Data tTypes Constraints Table statement

Course Offerings

  • Instructor-led interactive classes
  • Clarify your doubts during class
  • Access recordings of the class
  • Attend on mobile or tablet
  • Live projects to practice
  • Case studies to learn from
  • Lifetime mentorship support
  • Industry specific curriculum
  • Certificate of completion
  • Employability opportunity
  • Topics
  • Instructor (1)
  • Reviews
  • What is JAVA

  • history of JAVA
  • Features of java
  • what is JDK, JRE, JVM?
  • What are variables
  • Datatypes
  • Operators
  • Keywords


  • If
  • If-else
  • switch
  • For loop
  • While loop
  • Do while loop
  • Break
  • Continue
  • programs on all the below stated topics
  • Constructor
  • THIS KEYWORD
  • STATIC KEYWORD
  • Method Over Loading
  • Method Over Riding
  • Access Modifiers
  • Object
  • Class
  • Method
  • Abstraction
  • Encapsulation
  • Inheritance
  • Polymorphism
  • Java strings
  • What is a string
  • What is a substring
  • String buffer class
  • String builder class
  • String methods
  • Exceptions in java
  • Try catch
  • Multi catch
  • Throw
  • Throws
  • Final
  • What is multi-Threading
  • Life cycle of thread
  • Thread priority
  • Garbage collection
  • Dead lock
  • Inter thread communication
  • Synchronization in java
  • What is Collection Framework
  • Array List
  • Linked LIST
  • ARRAY LIST VS LINKED LIST
  • List Interface
  • Hash set
  • Linked Hash Set
  • Tree Set
  • Map Interface
  • Hash Map
  • Comparable VS Comparator Interface
  • Vector
  • Stack
  • Recursively List and Filter all files and folders
  • Read content from a File
  • Writing Content to a File - Files write method
  • • JDBC introduction with Basic JDBC Operation (e.g. MySQL)Submitting SQL Queries
  • Inserting Data into the Database
  • Updating Data in the Database
  • Deleting Data from the Database
  • Creating Prepared Statements
  • Calling Stored Procedure
  • Transaction handling
  • What is SQL
  • SQL syntax
  • SQL Database
  • How to create database
  • How to UPDATE Database
  • How to Rename database
  • How to select database
  • What is a table
  • How to alter commands
  • How to create a Table
  • DROP table
  • DELETE Table
  • RENAME Table
  • TRUNCATE Table
  • Copy Table
  • SELECT
  • SELECT UNIQUE
  • COUNT
  • DISTINCT
  • TOP
  • LAST
  • IN
  • SUM
  • DATE
  • WHERE
  • AND
  • OR
  • HAVING
  • ORDER BY
  • ORDER BY ASC
  • ORDER BY DESC
  • RANDOM
  • LIMIT
  • INSERT
  • UPDATE
  • DELETE TABLE
  • ROWS
  • ALL ROWS
  • DUPLICATE ROWS
  • DATABASE
  • VIEWS
  • JOINS
  • PRIMARY KEY
  • FOREIGN KEY
  • UNIQUE

(10)

Core Java and SQL for Beginners students also learn