- Главная
- Разное
- Дизайн
- Бизнес и предпринимательство
- Аналитика
- Образование
- Развлечения
- Красота и здоровье
- Финансы
- Государство
- Путешествия
- Спорт
- Недвижимость
- Армия
- Графика
- Культурология
- Еда и кулинария
- Лингвистика
- Английский язык
- Астрономия
- Алгебра
- Биология
- География
- Детские презентации
- Информатика
- История
- Литература
- Маркетинг
- Математика
- Медицина
- Менеджмент
- Музыка
- МХК
- Немецкий язык
- ОБЖ
- Обществознание
- Окружающий мир
- Педагогика
- Русский язык
- Технология
- Физика
- Философия
- Химия
- Шаблоны, картинки для презентаций
- Экология
- Экономика
- Юриспруденция
SQL for Beginner презентация
Содержание
- 1. SQL for Beginner
- 2. What we will cover today ? Simple
- 3. SQL (Structured Query Language) It is high
- 4. Learning SQL SELECT Statement Sample Table
- 5. You and Computer
- 6. Lets Practice
- 7. Hey !!!
- 8. WHERE Clause Operators to cover OR AND LIKE IN
- 9. Point to remember Parenthesis are having highest
- 10. GROUP BY Why do we need grouping ? When we need some aggregation
- 11. More Which product got sold ? (Detail)
- 12. What we covered ? SELECT FROM
- 13. Thank you www.Techsapphire.in
What we will cover today ? Simple SQL Queries Working with WHERE Clause GROUP BY Clause HAVING Clause Next Lecture Why we need relational tables ? How JOIN works ?
Слайд 1SQL FOR BEGINNER
Name: Yogesh Mehla
Email: Yogesh.mehla@gmail.com
Website: www.techsapphire.in
Phone: +91-9023262520
Слайд 2What we will cover today ?
Simple SQL Queries
Working with WHERE Clause
GROUP
BY Clause
HAVING Clause
Next Lecture
Why we need relational tables ?
How JOIN works ?
And lot of Practical
HAVING Clause
Next Lecture
Why we need relational tables ?
How JOIN works ?
And lot of Practical
Слайд 3SQL (Structured Query Language)
It is high level language which provide you
capability to query data from any structured data source (Tables).
High level language means language which is used by us to communicate (English).
For learning, we will be using online SQL editor provided by W3C.
http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all
High level language means language which is used by us to communicate (English).
For learning, we will be using online SQL editor provided by W3C.
http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all
Слайд 9Point to remember
Parenthesis are having highest precedence (Will be considered before
all conditions)
WHY ?
Simple Maths
2 + 2 * 5 =12 (* has high precedence then +)
(2+2)*5=20 (Parenthesis has high precedence then *)
WHY ?
Simple Maths
2 + 2 * 5 =12 (* has high precedence then +)
(2+2)*5=20 (Parenthesis has high precedence then *)
Слайд 11More
Which product got sold ? (Detail)
How many times product got sold
? (Aggregation)
Customers with address ? (Detail)
How many customers ? (Aggregation)
Customers with address ? (Detail)
How many customers ? (Aggregation)
