- Welcome To The Course
- Introduction To SQL
- Schema In SQL
- Creating Databases and Tables In SQL
- Data Types In SQL
- Constraint In SQL (PART - I)
- Constraint In SQL (PART - II)
- Practical Example
- Create Table In SQL
- Insert Date Into The Table
- Delete Data and Update Data
- Drop And Alter Table In SQL
- Retrieve Data From Tables
What you'll 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.
Description
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:
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 cover 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 cover 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 are the problem occur at that time and how to handel them )
Modify and Delete Table ( This lesson cover 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 )
Other Courses
How to publish an Android App on Google Play Store
Step by step lectures on how to prepare your App for publishing, create a Google Publisher account and publish the App.
CCNP ROUTE Labs: Learn Routing by Scenarios
Learn CCNP ROUTE course by practical scenarios
React training to become a professional front end developer2
part2- Learn React, Hooks, Redux, React Router, Next.js, Best Practices and way more!
Programming Course for Beginners - Become a Software Dev
Learn Java programming and become a Java software developer in 6 months! What you will learn applies in Java 8-17
How to Find Suppliers for Your Amazon FBA Wholesale Business
Learn step by step how to find profitable products and suppliers for your e-commerce and Amazon FBA Wholesale business
About the instructors
- 3.86 Calificación
- 7979 Estudiantes
- 2 Cursos
Ranjit Haldar
Computer Science Engineer
Hello there! I'm Ranjit Haldar, and I'm passionate about demystifying the world of computer science and engineering for learners worldwide. With over 3 years of experience in academia, including 1 year and 4 months as an Assistant Professor, I've had the privilege of guiding aspiring minds through the intricacies of technology.
My journey began with a BTech in Computer Science and Engineering from the esteemed Government College of Engineering and Textile Technology, Berhampore, where I graduated with distinction in 2020. Building upon this solid foundation, I further honed my skills with a Master of Engineering in Software Engineering from Jadavpur University in 2022, graduating with top honors.
Throughout my academic career, I've cultivated a deep understanding of computer science domains, leveraging my expertise to create engaging and insightful educational content. From mastering algorithms to delving into the intricacies of software engineering, I thrive on making complex concepts accessible to learners of all levels.
As an Assistant Professor, I've had the opportunity to inspire and mentor students, fostering a dynamic learning environment where curiosity and innovation flourish. My hands-on experience in the classroom has provided me with valuable insights into effective teaching methodologies and strategies for student engagement.
In addition to my academic pursuits, I've also ventured into the realm of online education, crafting comprehensive video courses for platforms like Udemy and TutorialsPoint. These courses aim to empower learners with practical skills and theoretical knowledge, equipping them for success in an ever-evolving tech landscape.
My mission as an instructor is simple: to inspire, educate, and empower individuals to unlock their full potential in the world of technology. Whether you're a novice looking to embark on your coding journey or a seasoned professional seeking to expand your expertise, join me on this exciting learning adventure!
Student feedback
Course Rating
Reviews
The lecture is very interesting and the lecturer is very insightful, and the screen is very clear. I really enjoy the course. Thanks
Language of instructor is hard to follow and he does not explain the content very well.
SQL basics are explained in easy to understand manner with the help of practicals. Crisp & clear content helps to develop skills which are required in day to day work