Learn Basic SQL Language with Short Examples
Learn Basic SQL Language with Short Examples
Duration: 06:14:49 | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 3.51 GB
Genre: eLearning | Language: English
Duration: 06:14:49 | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 3.51 GB
Genre: eLearning | Language: English
SQL Step by Step
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
Requirements
No programming experience needed.
Description
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
More Info