Course Hero Logo

UGCS MySQL.pdf - 21/07/2019 SQL Module 5 Intro to MySQL By...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 4 out of 21 pages.

21/07/20191Module 5Intro to MySQLByTrainingSQL is a standard language for storing,manipulating and retrieving data in databases.Our SQL tutorial will teach you how to use SQLin: MySQL, SQL Server, MS Access, Oracle,Sybase, Informix, Postgres, and other databasesystems.SQL
21/07/20192SQL stands for Structured Query LanguageSQL lets you access and manipulate databasesSQL became a standard of the AmericanNational Standards Institute (ANSI) in 1986,and of the International Organization forStandardization (ISO) in 1987MySQLSQL stands for Structured Query LanguageSQL lets you access and manipulate databasesSQL became a standard of the AmericanNational Standards Institute (ANSI) in 1986,and of the International Organization forStandardization (ISO) in 1987What is SQL
21/07/20193SQL can execute queries against a databaseSQL can retrieve data from a databaseSQL can insert records in a databaseSQL can update records in a databaseSQL can delete records from a databaseSQL can create new databasesSQL can create new tables in a databaseSQL can create stored procedures in a databaseSQL can create views in a databaseSQL can set permissions on tables, procedures, and viewsWhat Can SQL do?When using Windows, you can download thecommunity editionfromWAMPorXAMPPcan be installed; it comeswith MySQL database.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 21 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
N/A
Tags

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture