Learn SQL from Basic

Learn SQL from Basic, available at Free, has an average rating of 3.6, with 13 lectures, based on 117 reviews, and has 4839 subscribers.

Free Enroll Now

You will learn about Introduction Database and Tables in SQL. How to create, Drop and Alter table and Datebase. How to Insert, delete, update data in a table. How to Retrive data from a table and execute query. This course is ideal for individuals who are This course is for absolute beginener who want to build their carrier in database related field like database manager, database administrator, database engineer etc. It is particularly useful for This course is for absolute beginener who want to build their carrier in database related field like database manager, database administrator, database engineer etc.

Enroll now: Learn SQL from Basic

Summary

Title: Learn SQL from Basic

Price: Free

Average Rating: 3.6

Number of Lectures: 13

Number of Published Lectures: 13

Number of Curriculum Items: 13

Number of Published Curriculum Objects: 13

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

Introduction Database and Tables in SQL.

How to create, Drop and Alter table and Datebase.

How to Insert, delete, update data in a table.

How to Retrive data from a table and execute query.

Who Should Attend

This course is for absolute beginener who want to build their carrier in database related field like database manager, database administrator, database engineer etc.

Target Audiences

This course is for absolute beginener who want to build their carrier in database related field like database manager, database administrator, database engineer etc.

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 this course, you will learn how to create a database, how to add, delete and modify tables in a database, how to add data, delete data, 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:

1. 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 )

2. The schema in SQL ( This part cover what is schema and how to create and implement schema )

3. How to Create Database and Tables (This part cover how to create different databases and how to create tables under a particular database)

4. Data Types in SQL ( This part cover what are the different data types in SQL )

5. Constraint in SQL ( This part cover what are the different constraint in SQL and how to implement them )

6. Practical Example ( In this part we will discuss a practical example of SQL )

7. Create Table on a SQL Server ( This lesson cover how to create tables on a SQL server )

8. Insert Data Into the Tables (This lesson cover how to insert data in an existing table )

9. Update and Detele Data from a Table ( This lesson cover how to modify existing data or delete existing data and what are the problem occur at that time and how to handel them )

10. Modify and Delete Table ( This lesson cover how to change the table description and how to remove a table from the database )

11. Retrieve Data From Table ( This lesson cover how to fetch any particular data from one or more table based on some conditions )

Course Curriculum

Chapter 1: Learn SQL From Basic

Lecture 1: Welcome To The Course

Lecture 2: Introduction To SQL

Lecture 3: Schema In SQL

Lecture 4: Creating Databases and Tables In SQL

Lecture 5: Data Types In SQL

Lecture 6: Constraint In SQL (PART – I)

Lecture 7: Constraint In SQL (PART – II)

Lecture 8: Practical Example

Lecture 9: Create Table In SQL

Lecture 10: Insert Date Into The Table

Lecture 11: Delete Data and Update Data

Lecture 12: Drop And Alter Table In SQL

Lecture 13: Retrieve Data From Tables

Instructors

Ranjit Haldar
Computer Science Engineer

Rating Distribution

1 stars: 6 votes

2 stars: 5 votes

3 stars: 32 votes

4 stars: 41 votes

5 stars: 33 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!