Start your journey with Microsoft SQL and databases with on-hands experience in 100 minutes !
What you will learn
Hands-on experience of queries
Creating and executing databases
Logic and reasoning
Guaranteed instructor support
Description
Why would you take this course?
- Practice and boost your SQL skills with Queries.
- I am answering all your questions, usually in less than 24 hours.
- There is NO REQUIREMENT of any cross-platform. You just need a desktop/laptop and start your practice on Udemy inbuilt IDE without any software!!!
Whatβs this course all about?
- You will be provided with a complete environment to solve SQL Queries with their solutions.
- Join us and learn basic concepts of latest version of SQL with Queries.
- Our main target will be hands-on experience of SQL queries with a lot of examples.
- At the end of the course, students will be able to solve basic queries and guess what ? We are always there to help you for each exercise 24/7.
Note:
- The course is designed for people who have basic knowledge in SQL and it consists of exercises with solutions.
- This is a great test for people who are learning SQL and are looking for new challenges. Exercises are also a good test before the interview.
- Knowledge of SQL is one of the most desirable technical skills on the job market. If youβre wondering if itβs worth taking a step towards SQL and databases, donβt hesitate any longer and take the challenge today.
Why not get started today?
Click the Signup button to sign up for the course!
English
language
Content
Introduction
What is SQL ?
SQL SELECT
Lecture No. 1
Exercise No. 1
Solution
Exercise No. 2
Solution
Exercise No. 3
Solution
Explanation
SQL WHERE Clause
Lecture No. 2
Exercise No. 1
Solution
Exercise No. 2
Solution
Explanation
SQL AND, OR and NOT Operators
Lecture No. 3
Exercise No. 1
Solution
Exercise No. 2
Solution
Exercise No. 3
Solution
Exercise No. 4
Solution
Explanation
SQL ORDER BY Keyword
Lecture No. 4
Exercise No. 1
Solution
Exercise No. 2
Solution
Exercise No. 3
Solution
Exercise No. 4
Solution
Explanation
SQL INSERT INTO Statement
Lecture No. 5
Exercise No. 1
Solution
Explanation
SQL NULL Values
Lecture No. 6
Exercise No. 1
Solution
Explanation
SQL UPDATE Statement
Lecture No. 7
Exercise No. 1
Solution
Explanation
SQL DELETE Statement
Lecture No. 8
Exercise No. 1
Solution
Explanation
SQL MIN and MAX Functions
Lecture No. 9
Exercise No. 1
Solution
Exercise No. 2
Solution
Explanation
SQL COUNT, AVG and SUM Functions
Lecture No. 10
Exercise No. 1
Solution
Exercise No. 2
Solution
Exercise No. 3
Solution
Explanation
SQL IN Operator
Lecture No. 11
Exercise No. 1
Solution
Explanation
SQL Arithmetic Operators
Lecture No. 12
Exercise No. 1
Solution
Exercise No. 2
Solution
Exercise No. 3
Solution
Exercise No. 4
Solution
Explanation
SQL Comparison Operators
Lecture No. 13
Exercise No. 1
Solution
Exercise No. 2
Solution
Explanation
SQL BETWEEN Operator
Lecture No. 14
Exercise No. 1
Solution
Explanation
SQL LIKE Operator
Lecture No. 15
Exercise No. 1
Solution
Exercise No. 2
Solution
Exercise No. 3
Solution
Exercise No. 4
Solution
Exercise No. 5
Solution
Explanation
SQL Wildcards
Lecture No. 16
Exercise No. 1
Solution
Exercise No. 2
Solution
Exercise No. 3
Solution
Exercise No. 4
Solution
Explanation
SQL Joins
Lecture No. 17
Exercise No. 1
Solution
Explanation
Lecture No. 18
Exercise No. 2
Solution
Explanation
Lecture No. 19
Exercise No. 3
Solution
Explanation
Lecture No. 20
Exercise No. 4
Solution
Explanation
Lecture No. 21
SQL GROUP BY Statement
Lecture No. 22
Exercise No. 1
Solution
Explanation
SQL ANY and ALL Operators
Lecture No. 23
Exercise No. 1
Solution
Exercise No. 2
Solution
Explanation