Learnfly Academy

SQL

  • Sale
  • Regular price Rs. 18,000.00

Drop a query

Speak to Counsellor: Call 1-800 3000 7460 (India Toll Free)


Quick Overview

Course Description

SQL (pronounced as sequel) is one of the highly used programming languages. SQL finds its application in businesses, banks, universities, hospitals etc. Which means that each person on this planet who has some access to technology will use or touch something which has SQL. Big organizations like Google and Skype are the best examples to give when exemplifying the vitality of this language.


SQL training course offers a detailed learning on concepts of Database and working of Relational Databases. During the course, you will be learning about:



  • HSQL Server
  • Introduction to SQL
  • Relational Databases
  • Queries
  • Joins
  • Unions
  • Functions
  • Subqueries
  • Views
  • T-SQL
  • Stored procedures
  • SQL Server Installation
  • Database Backup and Restoration

Enroll for a Live Class

Enroll for the course at the earliest as we have limited seats available.

Duration : 1 hour
Length : 8 Weeks
Batch Start Date : 27/11/2016
Course Fee Rs. 18000
Test Lab Hours : 30 mins
Class Room Training : Available
Instructor Learnfly Faculty
Available Training Modes Instructor-Led Class

Almost all IT companies look to hire efficient back-end developers, with a firm understanding of SQL. The curriculum serves the needs of experienced professionals to upgrade their skills, as well as, fresh graduates to understand the subject and its real life applications.

  • Types of Database
  • TClient server Architecture
  • File server v/s client server DB’s
  • Client communication manager
  • Relational query processor
  • What is SQL?
  • How to open SSMS
  • Introduction of SQL 2012
  • Windows authentication
  • Schema
  • T-SQL
  • Keywords
  • Identification
  • System table
  • Data types
  • Functions
  • Data Manipulation
  • Data control language
  • Drop table
  • The commit/Rollback
  • Coolum
  • Select statement clauses
  • Using group by and having clauses
  • Logical and relational operators
  • Joins
  • Relational & logical opera
  • group function
  • Joins Constraints:-
  • Primary key
  • Foreign key
  • Unique key
  • check
  • Not null
  • Introduction to Joins
  • Types of Joins
  • Complete explanation by using figures and query
  • Creation of tables
  • Set operators and its Types
  • Union
  • Union all
  • Intersect
  • Except
  • Rules of Set operators
  • Temporary Table creation
  • Table variables
  • Example of Function creation
  • System function
  • Single row function
  • Number function
  • Char/String function
  • Date function
  • General function
  • Inline function
  • Duplicate function
  • Introduction to Sub queries
  • Sub queries used with IN or NOT IN
  • Sub queries used ANY or ALL
  • Sub queries used with EXISTS and NOT EXISTS
  • The update statement
  • Using the set clause to modify
  • Using the where clause
  • using the from clause
  • The DELETE statement
  • The TRUNCATE table statement
  • Creating view
  • Type of view
  • Views
  • Usage
  • Create view
  • Alter view
  • Drop view
  • Rename view
  • Modifying data using view
  • TSQL
  • Stored procedure
  • Advantage of stored procedure
  • Creating stored procedure
  • Drop procedure
  • Error handling in stored procedure
  • User defined function (UDF)
  • Scalar UDFs
  • Inline table value UDFs
  • Multi-statement table UDFs
  • Limitation of UDFs
  • Stored procedure
  • Try catch block
  • User stored procedure (UDFs)
  • Inline table value UDFs
  • Limitation of UDFs
  • User stored procedure (USP)
  • Rank function
  • DENSE Rank
  • Row Number
  • Triggers
  • How to create Triggers
  • Pivot
  • SQL server management studio
  • Pivot in excel
  • Pivot in SQL server
  • Stuff
  • For XML path
  • Example for XML path
  • Difference between CHAR, Varchar and NVarchar
  • How to change values
  • Indexes
  • With no Indexes defined
  • How to create an Index
  • How Indexes works
  • Index advantages
  • Searching for records
  • Sorting records
  • Grouping records
  • Index drawbacks
  • Indexes and Data modification
  • Clustered Indexes
  • How to create a Clustered Index
  • Composite Indexes
  • Covering queries with an index
  • Additional Index guidelines
  • Common Table Expression

 

Learnfly Academy is a forward-thinking educational ecosystem. We train extraordinary people for the emerging professions of the 21st century according to industry demand. We fill a crucial gap between learners and companies to train and hire the best talent in the market. Learning from Learnfly Academy increases your chances by 95% to get you the right job.

Live Class is a live streaming of teacher from our location. Learnfly Academy instructors deliver live classes in an online environment. Attendees join a WebEx session from their preferred location and connect to a hosted lab environment to practice what they learn. We run classes as per Indian Standard time.

Each attendee needs a computer with a high-speed Internet connection in order to connect to

  • A WebEx web conference session and
  • A hosted lab environment.
and For best results, we recommend the following browsers: PC - Internet Explorer or FireFox. Mac - 64-bit browser (Safari of FireFox). or Google Chrome We also highly recommend that you use a computer headset and microphone (VOIP) and that you attend from a quiet workspace to allow you to concentrate.

 

We have a very transparent fee structure. Please see the course fee next to the “Add to Cart” button on this page.

We only provide certified and industry expert trainers to our learners. Our teachers/instructors are highly qualified in their training verticals. Our instructors could be an individual teachers from colleges or working professionals from multi national companies like google, Facebook or Microsoft.

Of course you should. That’s what applications are for, don't worry. It's our responsibility to make sure that you are ready for any course you will attend. If it's not right for you, we'll let you know. We're not shy about things like that.

Yes. We do offer full job assistance once you do the certification from Learnfly. We have partnered ourselves with multiple small business and multi national companies to provide you the best working platform. We also conduct in-house campus events and send you invitations to experience multiple job opportunities at one place. We offer 99% job placement, if you do 2-3 job oriented courses from our catalogs.

Currently, you can attend our class’s in English or Hindi Language.

Yes Off course! You can reschedule a class with your assigned teacher or request for a pre-recorded session on your email.

We accept payments via credit cards, debit cards, net banking & NEFT. You can also pay us via paypal & paytm. Use the “Add to Cart” button provided on this page and checkout by making the online payment. You will receive an automated confirmation on your email after a success-full payment with further instructions.

Once you purchase training, we'll send you an email with registration instructions. Also, One of our counsellor will get in touch with you to assign you an online teacher and decide the class timings. We can either assign you to the existing running batch or add you in the upcoming batches.

You may cancel an order within 30 days of purchase for a full refund, but not inside of 3 days of your scheduled course.

 

Step 1 : Make an Online Payment


Step 2 : Our Counsellor will contact you within few minutes after payment.


Step 3 : Choose your time to attend your live class with our counsellor


Step 4 : Connect with a Live Teacher from your PC, Phone or a tablet & attend the class from anywhere in the world.


You may be interested in:


Customer Reviews

Based on 7 reviews Write a review