15.10.2022, 12:44
![[Bild: 4578722a8cf13f8i04.jpg]](https://abload.de/img/4578722a8cf13f8i04.jpg)
101 Practice SQL Questions: Basic to Advanced
Published 10/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 416 lectures (16h 55m) | Size: 8.5 GB
Answer over one hundred practice SQL questions using Microsoft's Sample database, AdventureWorks
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.
Requirements
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
Description
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
Homepage
![[Bild: 19.question85videoexp4hdl0.jpg]](https://abload.de/img/19.question85videoexp4hdl0.jpg)
Download from Rapidgator:
