Practice the SQL language on quizzes and exercises. Mainly suitable for beginners and intermediates.
Currently, competition in the IT market is increasing. Therefore, the importance of lifelong learning is increasing and it doesn’t just end with graduating from a school or an institute. This course is one of many that make this possible. However, it is different in many ways. This course contains 12 quizzes and 34 exercises.
What you’ll learn
- Exercise the Data Manipulation Language (DML).
- Exercise the Creating Data operation.
- Exercise the Reading Data operation.
- Exercise the Updating Data operation.
- Exercise the Deleting Data operation.
- Exercise the Filtering Data in SQL.
- Exercise the using logical operators.
- Exercise the Sorting Data in SQL.
- Exercise the Data Definition Language (DDL).
- Check SQL knowledge.
- Exercise how to get count, sum, minimal, maximal or average value.
- Understand how to write comments in SQL code.
Course Content
- Introduction –> 1 lecture • 2min.
- Inserting data into the database –> 2 lectures • 15min.
- Picking up data from DB –> 2 lectures • 5min.
- Data modification –> 2 lectures • 5min.
- Erasing of data –> 2 lectures • 3min.
- Filtering –> 2 lectures • 27min.
- Sorting –> 3 lectures • 10min.
- Joining – it is getting harder to study but still elementary –> 2 lectures • 7min.
- Basic functions –> 2 lectures • 12min.
Requirements
Currently, competition in the IT market is increasing. Therefore, the importance of lifelong learning is increasing and it doesn’t just end with graduating from a school or an institute. This course is one of many that make this possible. However, it is different in many ways. This course contains 12 quizzes and 34 exercises.
It is oriented towards practicing the SQL language. The teaching and theoretical component is minimized here and is basically only available in the assignment exercises and any hints. That way you won’t be bothered with something you’ve heard many times elsewhere.
It is aimed at beginners and intermediate students. It is especially beneficial for those who do not have the opportunity to test their own acquired skills on database software. Either because they don’t have access to the server side of the database, or they have access to the tools but are afraid of experimentation, or they have to deal with real data but where such experimentation is simply not allowed. I have designed this course with all these groups of students in mind.
Also, this course may be appreciated by students who feel that they are not getting enough education in their passive role as a learner. I will be glad if after completing this course you will be more confident and self-assured in your next independent use of the SQL language. Anywhere. Whether in your further studies or professional life.
So if you are at least familiar with any of the above, give this course a try.
The course will stay in your Udemy profile and you can come back to it anytime.