- 1 SQL INTRO
- 2 SQL SYNTAX
- 3 SQL SELECT
- 4 SQL SELECT DISTINCT
- 5 SQL WHERE
- REFERANCE
What you'll learn
- SQL
- Queries in SQL
- how to execute queries
- how to add data to data base and update data
Description
hello guys welcome to the course of sql in which u will learn things about sql and how to execute queries.
What is SQL?
SQL stands for Structured Query Language
SQL lets you access and manipulate databases
SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987.
What Can SQL do?
SQL can execute queries against a database
SQL can retrieve data from a database
SQL can insert records in a database
SQL can update records in a database
SQL can delete records from a database
SQL can create new databases
SQL can create new tables in a database
SQL can create stored procedures in a database
SQL can create views in a database
SQL can set permissions on tables, procedures, and v
Using SQL in Your Web Site
To build a web site that shows data from a database, you will need:
An RDBMS database program (i.e. MS Access, SQL Server, MySQL)
To use a server-side scripting language, like PHP or ASP
To use SQL to get the data you want
To use HTML / CSS to style the page.
RDBMS
RDBMS stands for Relational Database Management System.
RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.
The data in RDBMS is stored in database objects called tables. A table is a collection of related data entries and it consists of columns and rows.
so this was all about sql and other related inofrmation about the sql
Other Courses
Become a Web3.0 Leader!
JOIN US: WORK SMART, MAKE EXTRA INCOME AND ENJOY YOUR DESIRED LIFESTYLE!
Advanced CSS Development
Explore the basics of responsive web design and ways to improve front-end performance.
Materials Management & Inventory Control
Methods of Materials Management _ ABC analysis and EOQ
Automated Emails Using Python (Selenium, Pandas, CSV)
Automated Emails Using Python Programming Language. Modules as Selenium, Pandas and CSV are used
ISTQB Certified Tester Foundation Level (CTFL) v3.1 (2018)
Explanation of what is ISTQB, how to pass ISTQB certification successfully, and how to prepare for the exam on your own
About the instructors
- 3.58 Calificación
- 16250 Estudiantes
- 10 Cursos
Web Warrior
content creator
hey this is krishna mayekar founder of the web warrior and content creator who creates content online.
i really like teaching online and this makes me really happy i basically create content in the field of the digital and social media marketing .
im an engineer by profession and but i have always loved working in the field of the digital marketing as professional.
Student feedback
Course Rating
Reviews
Great course to understand mysql
problem of languge