Publisher's Synopsis
SQL is the most used language for communicating with relational databases. SQL may be used to create, find, edit, and remove database records. SQL may also be used for a great deal more jobs, such database maintenance and optimization. Relational databases use ANSI SQL, which is often called "See-Quel" or "S-Q-L," and is used by programs like MySQL Database, Oracle, MS SQL Server, Sybase, etc.
- Introduction
- Types of SQL Statements
- Operation in SQL
- SQL Operation
- Constituents of the SQL Language
- Database in SQL
- Explain NoSQL
- MySQL
- MySQL Workbench
- Using the MySQL Workbench
- Database Design
- Benefits of database design
- Life cycle of database development
- Normalization of databases
- Modeling ER
- Data
- Types of Database
- Database Components
- Language for Database Access
- Advantages of DBMS
- Disadvantage of DBMS
- MySQL Database
- Collation and Character Set
- Numeric Data types
- Text Data Types
- Views in MySQL
- MySQL Views syntax
- Dropping Views in MySQL
- Describe an index
- PHP Web Application
- Describe PHP
- MySQL and PHP
- The Myflix Video Library App
