Skip to content
Home
About Us
Course
Master Program in Data Analytics Course
Master Program in Data Science Course
Master Program Business Analytics Course
3‑Month Machine Learning Course
Explore Our Courses
Contact Us
Vista Academy Institute Gallery
Home
Explore Our Courses
Written Edition English Tutorial
Master Fundamental of SQL Written Edition English
Master Fundamental of SQL Written Edition English
Curriculum
6 Sections
77 Lessons
10 Weeks
Expand all sections
Collapse all sections
Course Description:
55
1.1
Course Detail
1.2
Introduction to SQL
1.3
Introduction to Data Analytics and SQL
1.4
create a database, table, and insert data in SQL
1.5
database, table, and insert data in SQL MCQ
10 Minutes
4 Questions
1.6
select command in SQL
1.7
select command in SQL MCQ
10 Minutes
4 Questions
1.8
What is the SELECT DISTINCT Statement?
1.9
MCQs for SQL SELECT DISTINCT Statement
10 Minutes
4 Questions
1.10
SQL WHERE Clause
1.11
SQL SELECT DISTINCT and WHERE Clause – MCQ Quiz
10 Minutes
6 Questions
1.12
SQL ORDER BY Keyword
1.13
SQL AND Operator
1.14
SQL NOT Operator
1.15
The SQL INSERT INTO Statement
1.16
SQL NULL Values
1.17
SQL Update
1.18
Deleting data in SQL
1.19
SQL TOP, LIMIT, FETCH FIRST or ROWNUM Clause
1.20
MCQs for SQL TOP, LIMIT, FETCH FIRST or ROWNUM Clause
4 Questions
1.21
SQL MIN() and MAX() Functions
1.22
Understanding the SQL COUNT() Function
1.23
SQL SUM() Function
1.24
SQL AVG() Function
1.25
The SQL LIKE Operator
1.26
SQL Wildcards
1.27
MCQs for SQL Wildcards
4 Questions
1.28
SQL IN Operator Explained with Examples
1.29
SQL BETWEEN Operator
1.30
SQL MCQs: Mastering ORDER BY, AND, and NOT Operators
10 Minutes
6 Questions
1.31
Data Manipulation Language (DML) Commands
1.32
MCQ Date Manipulation Language
10 Minutes
5 Questions
1.33
Data Definition Language (DDL) Commands:
1.34
MCQ on DDL commands
10 Minutes
6 Questions
1.35
Data Control Language (DCL) Commands:
1.36
MCQs for SQL DCL
4 Questions
1.37
Transaction Control Commands:in sql step by step
1.38
SQL Joins: A Comprehensive Guide
1.39
Understanding SQL INNER JOIN
1.40
MCQs for SQL INNER JOIN
4 Questions
1.41
Understanding SQL LEFT JOIN
1.42
MCQs for SQL LEFT JOIN
4 Questions
1.43
SQL IN Operator Explained with Examples
1.44
Understanding SQL FULL JOIN
1.45
MCQs for SQL FULL JOIN
4 Questions
1.46
Understanding SQL RIGHT JOIN
1.47
MCQs for SQL RIGHT JOIN
4 Questions
1.48
Understanding SQL SELF JOIN
1.49
MCQ SQL SELF JOIN
10 Minutes
4 Questions
1.50
SQL UNION Operator
1.51
MCQ SQL Union
10 Minutes
4 Questions
1.52
Group By operator In SQL
1.53
MCQ Group By operator In SQL
10 Minutes
4 Questions
1.54
SQL HAVING Clause
1.55
MCQ SQL HAVING Clause
10 Minutes
4 Questions
SQL keys
10
2.1
Primary key SQl
2.2
MCQ Primary Key SQL
10 Minutes
5 Questions
2.3
Understanding SQL Unique Key Constraints
2.4
MCQ PRIMARY KEY AND UNIQUE CONTRAINTS
12 Minutes
6 Questions
2.5
The SQL Foreign Key
2.6
MCQ FOREIGN KEY
10 Minutes
4 Questions
2.7
SQL Composite Key
2.8
MCQ SQL Composite Key
10 Minutes
4 Questions
2.9
ALTERNATE KEY
2.10
Multiple Choice Questions (MCQs) on Alternate Keys
10 Minutes
4 Questions
SQL Views
8
3.1
SQL – CREATE View
3.2
MCQ SQL – CREATE View
10 Minutes
4 Questions
3.3
SQL UPDATE View Statement
3.4
MCQ SQL UPDATE View Statement
10 Minutes
4 Questions
3.5
SQL – DROP or DELETE View
3.6
MCQ SQL “DROP and DELETE
10 Minutes
5 Questions
3.7
SQL – Rename View
3.8
MCQs for Rename a View in MySQL
10 Minutes
4 Questions
SQL Indexes
3
4.1
SQL – Indexes
4.2
MCQs for SQL Indexes
10 Minutes
4 Questions
4.3
SQL – Create Index
Advanced SQL
35
5.1
SQL – Wildcards
5.2
MCQs FOR SQL Wildcards
10 Minutes
4 Questions
5.3
SQL – Injection
5.4
MCQs on SQL Injection
10 Minutes
4 Questions
5.5
SQL – Hosting
5.6
MCQs for SQL Hosting
10 Minutes
4 Questions
5.7
SQL – MIN() – MAX() function
5.8
MCQs for SQL MAX() and MIN() Function
10 Minutes
4 Questions
5.9
SQL – Null Functions
5.10
MCQs for SQL NULL Functions
10 Minutes
4 Questions
5.11
SQL – Check Constraint
5.12
MCQs for CHECK Constraint in SQL
10 Minutes
4 Questions
5.13
SQL – Default Constraint
5.14
MCQs for DEFAULT Constraint in SQL
10 Minutes
4 Questions
5.15
SQL – Stored Procedures
5.16
MCQs for Stored Procedures in SQL
10 Minutes
0 Questions
5.17
SQL – NULL Values
5.18
MCQs for NULL Values in SQL
10 Minutes
4 Questions
5.19
SQL – Transactions
5.20
MCQs for Transactions in SQL
10 Minutes
4 Questions
5.21
SQL – Sub Queries
5.22
MCQs for Sub Queries in SQL
10 Minutes
4 Questions
5.23
SQL – Handling Duplicates
5.24
MCQs on Handling Duplicates in SQL
10 Minutes
4 Questions
5.25
SQL – Using Sequences
5.26
MCQs for Using Sequences in SQL
10 Minutes
4 Questions
5.27
SQL – Auto Increment
5.28
MCQs for Auto Increment in SQL
10 Minutes
4 Questions
5.29
SQL – Date & Time
5.30
MCQs for Date & Time in SQL
10 Minutes
4 Questions
5.31
SQL – Cursors
5.32
MCQs on MySQL Cursors in Stored Procedures
10 Minutes
4 Questions
5.33
SQL – Group By vs Order By
5.34
MCQs for SQL GROUP BY vs ORDER BY
10 Minutes
4 Questions
5.35
SQL – IN vs EXISTS
SQL Function Reference
22
6.1
SQL – Date Functions
6.2
MCQs for “SQL Server Date & Time Functions
10 Minutes
4 Questions
6.3
SQL – String Functions
6.4
MCQs for SQL String Functions
10 Minutes
4 Questions
6.5
SQL – Aggregate Functions
6.6
MCQs for SQL Aggregate Functions
10 Minutes
4 Questions
6.7
SQL – Numeric Functions
6.8
MCQs for SQL Numeric Functions
10 Minutes
4 Questions
6.9
SQL – Text & Image functions
6.10
MCQs for SQL Text and Image Functions
10 Minutes
4 Questions
6.11
SQL – Statistical Functions
6.12
MCQs for SQL Statistical Functions
10 Minutes
4 Questions
6.13
SQL – Logical Functions
6.14
MCQs for SQL Logical Functions
10 Minutes
4 Questions
6.15
SQL – Cursor Functions
6.16
MCQs for SQL Server Cursor Functions
10 Minutes
4 Questions
6.17
SQL – JSON Functions
6.18
MCQs on SQL Server JSON Functions
10 Minutes
4 Questions
6.19
SQL – Conversion Functions
6.20
MCQs for SQL Conversion Functions
10 Minutes
4 Questions
6.21
SQL – Datatype Functions
6.22
MCQs for SQL Data Type Functions
10 Minutes
4 Questions
This content is protected, please
login
and
enroll
in the course to view this content!
Vista Academy
– 316/336, Park Rd, Laxman Chowk, Dehradun – 248001
📞
+91 94117 78145
| 📧
thevistaacademy@gmail.com
| 💬
WhatsApp
💬 Chat on WhatsApp: Ask About Our Courses
Modal title
Main Content
