Scroll Down to get the courseGet The Course

Master SQL interviews (Top Interview questions & answers) | Discount Coupon for Udemy Course

Development Database Design & Development

$15.99 $19.9920% off

Price expires 2 years ago

Learn Most Common SQL interview questions and answers with detailed explanations & hands on examples | Discount Coupon for Udemy Course

top_rated

(12 ratings)

101 students

Created by:

Biswajit Nanda

Last updated 6/2022Course Language EnglishCourse Caption English [Auto]Course Length 02:05:01 to be exact 7501 seconds!Number of Lectures 80

This course includes:

2 hours hours of on-demand video
Full lifetime access
Access on mobile and TV
Certificate of completion

This course has been intended for programmers and testers who want to master SQL interview questions and answers.Most of the modern applications create data in a backend database and hence knowing SQL is an essential skill for everyone. The course covers a number of questions and answers in the following areas1) Databases2) Various types of Database Management system3) Different types of SQL statements - DDL, DML and DCL statements4) SQL introduction5) Creating tables6) SQL Data types7) SELECT INTO operations8) Conditional SELECT operations9) DELETE ALL and Conditional DELETE operations 10) DELETE and TRUNCATE operation comparison11) DROP table operations 12) Data Integrity and constraints 13) Column level and Table level primary Keys14) Creating Unique keys15) Various types of check constraints16) Nullable columns17) Aggregate functions 18) SQL statements to address different goals 19) Displaying schema of tables20) What are JOINS? 21) Different types of JOINS - Inner Join, Left Outer, Right Outer and Full Outer Joins22) What is SELF and Cross Joins?23) Displaying System Date and time 24) Displaying server and database names 25) Various string operations - Substring, CHARINDEX, Concatenation etc26) Creating an empty table from an existing table27) LEFT, RIGHT operations 28) What are indexes? 29) Describe Clustered indexes30) Non-clustered indexes and difference from Clustered indexes31) Describe Unique Indexesand many more ... Who this course is for:This course has been designed for Data scientists, programmers and testers looking to master SQL interviews

Course Content:

Sections are minimized for better readability, click the section title to view the course content

80 Lectures | 02:05:01

Question 1: What is a Database?
00:10
Question 2: What is the difference between a database and DBMS?
00:47
Question 3: What is the difference between DBMS and Relational DBMS?
00:32
Question 4. What are DDL, DML and DCL statements?
00:52
Question 5: What is SQL?
00:52
Question 6: How do you create a table?
01:43
Question 7: What is the difference between CHAR and VARCHAR2 datatype in sql
02:21
Question 8: How do you create a table from another table?
03:48
Question 9: How do you insert values into a table?
03:59
Question 10: Can you insert data into the same table by taking data from it?
01:13
Question 11: What will happen if you insert a bigger value into a varchar column
01:03
Question 12: How do you select data from a table?
01:30
Question 13: How do you select data from a table using WHERE clause?
02:02
Question 14: How do you delete all data from a table?
00:41
Question 15: How do you delete data from a table based on a condition?
01:16
Question 16: What is the difference between DELETE and TRUNCATE statements?
01:10
Question 17: How do you drop a table?
01:47
Question 18: What is the difference between Delete and Drop?
01:34
Question 19: What are constraints and what is their importance?
01:46
Question 20: What is a Primary Key?
01:12
Question 21: How do you create a Primary key while creating a table?
00:53
Question 22: How do you create a table level Primary Key?
00:44
Question 23: How do you create a Unique Key while creating a table?
01:11
Question 24: How do you create a table level Unique Key?
01:29
Question 25: What is the difference between a Primary Key and Unique Key?
02:30
Question 26: How do you create a Check constraint while creating a table?
01:53
Question 27: How do you create a table level check constraint?
02:49
Question 28: Create a check constraint to restrict values to a range
01:10
Question 29: Create a check constraint to have name starting with A
02:06
Question 30: How do you create a foreign key on a table?
02:44
Question 31: How do you create a table level foreign key?
01:46
Question 32: What is meant by a nullable column?
01:00
Question 33: What are aggregate functions?
00:25
Question 34: Write a SQL statement to count the total number of rows of a table
00:42
Question 35: Write a SQL statement to count number of rows matching a condition
00:57
Question 36: Write a SQL statement where column matches with a string value(LIKE
01:29
Question 37: How do you calculate the average,minimum and maximum salary from em
00:42
Question 38: How do you calculate total salary for employees grouped by employee
01:18
Question 39: How do you select data in a table in sorted order(Asc & and desc)
01:16
Question 40: How do you specify a condition with a GROUP BY clause?
02:03
Question 41: Can you have both HAVING and WHERE clauses together?
01:06
Question 42: Write a query to display schema of a table
01:43
Question 43: Alter a table to add a new column to a table
00:56
Question 44: How do you change the data type of a column of a table
01:18
Question 45: How do you drop a column from a table?
00:54
Question 46: What is a Join?
01:10
Question 47: Explain different types of joins
00:49
Question 48: What is the difference between an outer join and inner join?
02:36
Question 49: What is the difference between Left Inner Join and Left Outer join?
01:28
Question 50: What is Cross Join? Where is it useful?
02:40
Question 51: What is Full Join?
01:40
Question 52: What is Self Join?
02:40
Question 53: Write a sql statement to display current date and time
00:30
Question 54: Write a sql statement to display the server and database name
00:35
Question 55: Write a sql statement to display the user name
00:27
Question 56: Write a sql statement to display the number of tables present in db
01:50
Question 57: Write sql to display the second highest salary from employee table
02:02
Question 58: Write a SQL query to return a substring from a string
01:36
Question 59: Write a SQL query to return the no of characters of a given string
00:41
Question 60: Write SQL to return the numeric position of a character in a string
01:05
Question 61: Write a SQL statement to display distinct salaries from a table
00:54
Question 62: How do you concatenate two strings in sql?
01:08
Question 63: Create a empty table with the same structure as another table
01:20
Question 64: SQL to return first 3 characters(right and middle also) of a string
01:37
Question 65: What are indexes? Why they are used?
01:59
Question 66: What are clustered indexes?
02:28
Question 67: What are non-clustered index?
02:28
Question 68: What is a Unique index? Write a SQL to create one
02:29
Question 69: What is a view? Write a sql statement to create a view
01:43
Question 70: Write a sql statement to display the number of views present
01:40
Question 71: What is a subquery? Why is it used?
02:12
Question 72: Write a query to remove spaces present in a string from sides
01:34
Question 73: What is the difference between Union and Union all?
02:04
Question 74: What is EXCEPT or MINUS operator?
01:49
Question 75: What is Intersect operator?
00:55
Question 76: What are temp tables in SQL Server?
01:06
Question 77: What are global temp tables in SQL?
01:13
Question 78: How to get nth maximum salary from a table?
03:13
Question 79: Nth maximum salary when there are duplicate salaries
04:22
Question 80: What is COALESCE function in SQL?
01:36

(12 course ratings)

0/12

12/12

JOIN OUR WHATSAPP GROUP TO GET LATEST COUPON AS SOON AS UPDATED

JOIN WHATSAPP

JOIN OUR TELEGRAM CHANNEL TO GET LATEST COUPON

JOIN TELEGRAM

JOIN OUR FACEBOOK GROUP TO GET LATEST COUPON

JOIN FACEBOOK

Get The Course

If you like to get inspired by great web projects, you should check out Made with Javascript. If you have a project that you wish to share with the world, feel free to submit your project on Made with Javascript Club website.