Data Modeling and Databases Lab 3: Introduction to SQL презентация
Содержание
- 2. Basic SQL query structure Basic SQL query structure consists of SELECT,
- 3. Data manipulation INSERT Inserts a tuple into the specified table INSERT
- 4. Inserting Create a new student Harvey Specter: INSERT INTO students
- 5. Updating Change firstname of all students having student_id = 1 to
- 6. Deleting Delete student having student_id = 1 from table students: DELETE
- 7. Expressions Calculate expression 1 + 1 and name it as two:
- 8. Tables Return list of all students: SELECT * FROM students
- 9. Exercise Insert a new department named ‘Machine Learning’ and leaded with
- 10. Exercise Find the address of the student with first name "Donna”
- 11. Exercise Find all students who are either male or are from
- 12. Exercise Find all courses that worth at least 9 credits and
- 13. Exercise Find names and salaries of professors who earn less than
- 14. Exercise Find students born earlier than 1980 SELECT * FROM students
- 15. Exercise List full names of all students living in Moscow Hint:
- 16. Exercise Find students who's address contains "k" letter SELECT *
- 17. Exercise Find students who's lastname consists of 7 letters and ends
- 18. Exercise Order and display students by lastname (alphabetically) SELECT * FROM
- 19. Exercise Order and display students by lastname and then by firstname
- 20. Exercise Order by login : first letter of firstname + full
- 21. Exercise Find names of male students who got more than 50
- 22. Exercise Which students are enrolled in DMD course?
- 23. QA?
- 24. Скачать презентацию
Слайды и текст этой презентации
Скачать презентацию на тему Data Modeling and Databases Lab 3: Introduction to SQL можно ниже: