SQL for Absolute Beginner
A comprehensive course to teach you how to complete SQL queries
Updated on Dec, 2023
Language - English
Duration -1.5 hours
SQL (Structured Query Language) is the language we use to interact with databases that store data. This allows us to retrieve data with ease and simplicity. In SQL for Absolute Beginner course, you will learn how to create a database, how to add, delete and modify tables in a database, and how to add data, delete data, and modify data in tables. How to retrieve data based on user requirements.
If you don't know anything about databases and SQL then don't worry. You will learn from scratch in this course. After completing this you get a brief idea of how to work with databases in the professional field.
In this course, we will cover the following topic:
Introduction To SQL ( This part cover what is SQL, what can SQL do, what are the different subordinate language of SQL and different command in SQL )
The schema in SQL ( This part covers what is schema and how to create and implement schema )
How to Create Database and Tables (This part cover how to create different databases and how to create tables under a particular database)
Data Types in SQL ( This part covers what are the different data types in SQL )
Constraint in SQL ( This part cover what are the different constraint in SQL and how to implement them )
Practical Example ( In this part we will discuss a practical example of SQL )
Create Table on a SQL Server ( This lesson cover how to create tables on a SQL server )
Insert Data Into the Tables (This lesson cover how to insert data in an existing table )
Update and Detele Data from a Table ( This lesson cover how to modify existing data or delete existing data and what problem occur at that time and how to handle them )
Modify and Delete Table ( This lesson covers how to change the table description and how to remove a table from the database )
Retrieve Data From Table ( This lesson cover how to fetch any particular data from one or more table based on some conditions )
What will you learn in this course:
- Introduction Database and Tables in SQL.
- How to create, Drop and Alter tables and Databases.
- How to Insert, delete, and update data in a table.
- How to Retrieve data from a table and execute the query.
What are the prerequisites for this course?
No Basic knowledge is required. You will learn from scratch.
Check out the detailed breakdown of what’s inside the course
SQL for Absolute Beginner
- Introduction to SQL 10:30 10:30
- Schema in SQL 07:01 07:01
- Creating Databases and Tables 08:00 08:00
- Data Types in SQL 14:34 14:34
- SQL Constraint Part 1 04:53 04:53
- SQL Constraint Part 2 06:54 06:54
- SQL Practical Example 03:09 03:09
- SQL Create Table 12:14 12:14
- Insert Data into Tables in SQL 13:06 13:06
- Update and Delete Data from a Table in SQL 15:27 15:27
- Drop and Alter Table in SQL 08:44 08:44
- Retrieve Data from Tables in SQL 11:00 11:00
RANJIT HALDARComputer Science Specialist
I am a confident person; my experience has been in teaching several subjects for several years.
My strengths are, disciplined, prepared, friendly with new technology, friendly with students, a good environment creator, and motivator.
I try to make my lessons as real and relevant as possible.
I try to make lessons fun and engaging.
I try to help my students get the highest grades possible.
I try to respect and listen to my students.
I am always learning new and better ways to present material from my students, administrators, and fellow teachers.
I also continue to learn within the content area I teach.
As far as describing myself as a teacher honest, straightforward definitely not politically correct, opinionated, open minded to new ideas all of which I also encourage my students to be in my class.
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.
Our students work
with the Best
SQL is very comfortable lecture and faculty dealing with it , is really good. i'm fine to be with this program.
Related Video CoursesView More
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video CoursesSubscribe now
Master prominent technologies at full length and become a valued certified professional.Explore Now