3247 STUDENTS ENROLLED
  • Educaps services
  • Suraj Neekhra
  • Ashish Kumar
  • Educaps services
  • Anshul Pandey

SQL stands for Structured Query Language. SQL is a database language, it is used for database creation, deletion, fetching rows, and modifying rows, etc. All the Relational Database Management Systems (RDMS) like MySQL, MS Access, Oracle, Sybase, Informix, Postgres, and SQL Server use SQL as their standard database language.

This tutorial will provide you with the instruction on the basics of each of the commands as well as allow you to put them to practice using the SQL Interpreter.

Course Curriculum

Section 1: Basic
SQl Overview FREE 00:00:00
SQL Introduction FREE 00:00:00
DBMS 00:00:00
Datatypes 00:00:00
Operators 00:00:00
QUIZ-SQL SECTION 1 00:20:00
Section 2: SQL DATABASE
CREATE Database 00:00:00
DROP Database 00:00:00
RENAME Database 00:00:00
BACKUP Database 00:00:00
SELECT Database 00:00:00
QUIZ SQL SECTION 2 00:20:00
SECTION 3: KEYS
SQL-Super key 00:00:00
SQL Primary Key 00:00:00
SQL-Candidate Key 00:00:00
SQL-Foreign Key 00:00:00
SQL Composite Key 00:00:00
SQL-Unique Key 00:00:00
SQL-Alternate Key 00:00:00
QUIZ-SQL SECTION 3 00:20:00
SECTION 4: TABLE
What is Table 00:00:00
SQL CREATE TABLE 00:00:00
SQL DROP TABLE 00:00:00
SQL DELETE TABLE 00:00:00
SQL TRUNCATE TABLE 00:00:00
SQL COPY TABLE 00:00:00
QUIZ-SQL SECTION 4 00:20:00
SECTION 5: SELECT
SELECT Statement 00:00:00
SELECT DISTINCT 00:00:00
SELECT COUNT 00:00:00
SELECT TOP 00:00:00
SELECT AS 00:00:00
SELECT IN 00:00:00
SELECT DATE 00:00:00
SELECT NULL 00:00:00
QUIZ-SQL SECTION 5 00:20:00
SECTION 6: INSERT
INSERT Statement 00:00:00
INSERT INTO SELECT 00:00:00
QUIZ-SQL SECTION 6 00:20:00
SECTION 7: UPDATE
UPDATE Statement 00:00:00
UPDATE DATE 00:00:00
QUIZ-SQL SECTION 7 00:20:00
SECTION 8: DELETE
DELETE Statement 00:00:00
DELETE Duplicate Rows 00:00:00
DELETE VIEW 00:00:00
QUIZ-SQL SECTION 8 00:20:00
SECTION 9: CLAUSE
SQL where 00:00:00
SQL AND 00:00:00
SQL OR 00:00:00
SQL NOT 00:00:00
QUIZ-SQL SECTION 9 00:20:00
SECTION 10: SQL ORDER BY
ORDER BY Clause 00:00:00
ORDER BY DESC 00:00:00
ORDER BY RANDOM 00:00:00
QUIZ-SQL SECTION 10 00:20:00
SECTION 11: SQL JOIN
SQL Join 00:00:00
SQL Left Join 00:00:00
SQL Right Join 00:00:00
SQL Full Join 00:00:00
SQL Outer Join 00:00:00
SQL Cross Join 00:00:00
QUIZ-SQL SECTION 11 00:20:00
SECTION 12: Advance SQL
SQL Constraints 00:00:00
SQL Alter Command 00:00:00
SQL Having Clause 00:00:00
SQL Transactions 00:00:00
SQL Wildcards 00:00:00
SQL Sub Queries 00:00:00
SQL Using Sequences 00:00:00
SQL Injection 00:00:00
SQL Aggregate Function 00:00:00
SQL Union 00:00:00
SQL Function 00:00:00
SQL Date Functions 00:00:00
QUIZ-SQL SECTION 12 00:20:00
SECTION 13: PL/SQL
PL/SQL Overview 00:00:00
PL/SQL Basic Syntax 00:00:00
PL/SQL Data Types 00:00:00
PL/SQL Variables 00:00:00
PL/SQL Constants and Literals 00:00:00
PL/SQL Operators 00:00:00
PL/SQL QUIZ SECTION 13 00:20:00
SECTION 14: PL/SQL CONTROL STATEMENTS
PL/SQL If 00:00:00
PL/SQL Case 00:00:00
PL/SQL Loop 00:00:00
PL/SQL Continue 00:00:00
PL/SQL Goto 00:00:00
PL/SQL QUIZ SECTION 14 00:20:00
SECTION 15: PL/SQL Advance Topics
PL/SQL String 00:00:00
PL/SQL Arrays 00:00:00
PL/SQL Procedure 00:00:00
PL/SQL Function 00:00:00
PL/SQL Cursor 00:00:00
PL/SQL Exception 00:00:00
PL/SQL Trigger 00:00:00
PL/SQL Records 00:00:00
PL/SQL Packages 00:00:00
PL/SQL Collections 00:00:00
PL/SQL Date & Time 00:00:00
PL/SQL DBMS Output 00:00:00
PL/SQL QUIZ SECTION 15 00:20:00

Course Reviews

4.2

4.2
675 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE

Popular Courses

Advanced Course Search Widget

About EduCaps

EduCap Services India Pvt. Ltd. (Sister Concern of Praedico Global Research Pvt. Ltd.) is established in 2011 and registered as a PVT LTD Firm in the last year. EduCap is leading firm, providing the educational training in PAN India in the field of advanced technologies involving Machine Learning, Artificial Intelligence, Deep Learning, Python, Neural Networks etc. along with the basic and trending technologies

Educaps : The Best Learning platform

Certificate Code

Course Stats Widget

46732

Contact Us –

Hyderabad - +91 9009054508
Delhi - +91 9999703728
Mumbai - +91 9999703728
Kolkata - +91 88152 72997

contact@educapsindia.com

top
Copyright © 2020 EduCaps Services India Pvt. Ltd. All Rights Reserved.
error: Content is protected !!
X