101 Practice SQL Questions: Basic to Advanced
What you'll 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.
- There are many ways to provide the same results. Discover your own style and cultivate your abilities within Microsoft SQL Server.
- Microsoft SQL Server and T-SQL syntax
- Advanced Topics such as Triggers, Functions, Indexes, Self-Joins, Stored Procedures, Common Table Expressions (CTEs), and much mor.e
- A level of SQL knowledge above a beginner
- Basic to advanced understanding of SQL Syntax
- Ability to problem solve, think critically, and apply SQL knowledge
- Microsoft SQL Server - Instructor will help you download
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
Who this course is for:
- Any SQL developer, analyst, or individual wanting to become more skilled in SQL
- Individuals who learn by doing and enjoy challenging themselves
- Learners who want to gain a deeper understanding of SQL through practice
Hello, my name is Curtis and I enjoy solving problems. More specifically, I enjoy solving problems through logical, strategic, and data-driven thinking. I studied finance before finding my passion for healthcare, which led to studying healthcare administration at the University of Minnesota. My passion for healthcare come when my daughter was born prematurely, only weighing 1 lb at birth. This passion was inspired by clinical professionals who are driven to help patients heal. I love knowing that my work is in turn helping clinicians and patients. I've recently found a love for teaching complex subjects and simplifying them.