101 Practice SQL Questions: Basic to Advanced

101 Practice SQL Questions: Basic to Advanced

Let me guess, you’ve taken an Intro SQL course and don’t know what to do next? Or maybe you’ve taken a few months or years away from SQL and need to brush up. Either way, this course is for you!

This course literally includes 101 Practice SQL Questions! In fact, majority of questions include multiple parts. Including those multiple parts students get access to 286 practice questions. This gives individuals ample opportunity to try, fail, learn, and succeed.

The instructional level is listed as “All Levels.” However, those taking this course do need to have some basic understanding of SQL. The course includes basic, intermediate, and advanced questions. This course will not teach you concepts step-by-step. You will learn by attempting the question, using a hint if needed, then watching the video explanation. Video explanations are provided to show students how to answer the question; however, each question has multiple answers. The instructor simply shows students how he would answer the question.

Microsoft SQL Server Management Studio (SSMS) will be the database management system used in the course. All the questions in the course are answered using the Microsoft Sample database, AdventureWorks. The syntax used in SSMS is T-SQL. T-SQL is similar to syntax used in MySQL, PostgreSQL, Oracle, Snowflake, MariaDB, etc., however, Microsoft SQL Server will be needed to load the AdventureWorks database.

List of commands used in course questions:

• Basic concepts: Select, From , Where , Order by , Group by , Count, Inner Join, Select Into, Distinct, Having, Create Database, Use Database, Sum, Avg, Min, Max, Create Table, Drop Table, Insert Into

• Intermediate Concepts: And/Or, In/Not In, Between/Not Between, Like/Not Like, Case When, Concatenation, Left/Right Join, Format, Left/Right, Declare (local variable), Alter Table, Drop Column, Alter Column, Update, GetDate, DateAdd, DatePart, DateDiff, DateName, Month, Year, Day, Len, NewID

• Advanced Concepts: Truncate, Delete, Exists, Inner Query (Subquery), Stored Procedure, CTEs , Temp Tables, Union, Self-Join, Cross Join, Convert, Cast, IsNull, Nullif, Coalesce, Lag, Lead, Ceiling, Floor, Views, Alter View, Foreign Keys, Default Constraints, Rollup, Pivot, Unpivot, Over, Partition, Rank, Row_Number, NTile, Percent_Rank, Choose, IIF, User Defined Types, Rollback, Begin Transaction, Commit, While loop - Batching, CharIndex, Triggers, Function, Cross Apply, Outer Apply, Index

Answer over one hundred practice SQL questions using Microsoft's Sample database, AdventureWorks.

Url: View Details

What you will learn

• Take your SQL understanding to the next level. Questions are available for individuals at all levels; however, a basic understanding is needed.
• Prepare for SQL interviews by practice a plethora of challenging SQL questions.
• Learn how to take a difficult questions, think critically, and apply your SQL knowledge.

Rating: 4.96429

Level: All Levels

Duration: 17 hours

Instructor: Curtis Norman