Learn Basic SQL Language with Short Examples
Learn SQL language with this beginner-friendly course. Discover the basics of data processing, create and modify data structures, and work with data using practical examples. Test your knowledge with quizzes and gain a certificate. Perfect for newcomers wanting to delve into SQL.
What you’ll learn
- Work with data in SQL
- Create and modify a structure of data
- Create, modify, read and delete data
- Know allowed datatypes
- Create groups and sets
- Be aware of most used mathematical operations
- Be aware of advanced topics such conditions and modifications of data
You can join this course if you want to have an introduction to SQL. You can see mostly used commands for data processing on practical examples. You will learn the topic with small steps after small steps.
SQL Language Introduction Using Short Examples
Learn how to create and modify a structure of data
Learn how to work with data
Find the easy to understand syntax of SQL language
Test your knowledge in a quiz at the end of each chapter
Discover the basics of SQL language with this tutorial for beginners.
We will learn the Data Definition and Data Modification commands. The course will be guided by demonstrations. You can then test your knowledge on quizzes. On the end of course you should be able to write the commands for data creating and data manipulating by yourself.
Description:
I designed this programming course to be easily understood by absolute beginners.
Basic concepts of databases
Datatypes
Data Definition Commands
Data Modification Commands
Quizzes
Certificate
SQL language is nothing but computer language for data processing. Data is almost everywhere in the world. So, I selected the SQL language as a topic of this course. I demonstrated examples on the SQL Developer tool. SQL language is free and SQL Developer is also free.
The syntax of commands you will learn is possible to use in many others programming languages.
Content:
You will learn what is the possible structure of information – allowed datatypes.
You can also learn how to create storage of information.
Then I will show you how to write, read, update and delete data.
After that I will mention and demonstrate how to select only some subset of information.
Also you will be able to see sorting and some simple math operations.
Also I will show you operations with groups and sets.
Last sections will be dedicated to two advanced topics: Integrity and Alter table.
I will show you those topics on screen recording.
It will be demonstrated step by step. Small step after small step.
You will be able to test your new skills.
Who this course is for:
- Newcomer who wants to know more about SQL
