Learn database and SQL query

Learn SQL Form Basic

Learn to create and manage datbase with MySQL. Learn Structured Query Language to store and extract data from database tables via SQL query. We teach over mysql which is gives an elegant way to store and acces data over the web.

• Course: SQL
• Duration: 2 weeks
• pre-requisite : basic computer awareness
• Trainer : Hemant Saxena
• Experience : 23 years
• Fees : 4000/-

SQL from Begining

We started from How to install & setup your database. All DML and DDL queries are covered.

Introduction to MySQL
• MySQL Overview
• What is Relational Databases
• Variants of SQL

MySQL Server and Client
• MySQL Client/Server Model
• MySQL Connectors
• Installation of the MySQL server
• Setting the root Password
• Starting and stopping the MySQL server
• Using the mysql client
• MySQL Workbench

Database Basics
• Basics of Relational Databases
• Spreadsheet Versus Database
• Entities and Relationships
• Relationship Categories
• SQL Language and MySQL
• SQL data definition language
• SQL data manipulation language

Designing Your Database
• Database Modeling
• Keys
• Normalization
• Database Design
• Viewing and Evaluating a Database

Data Types
• Data Types as Part of Database Design
• Numeric Data Types
• Temporal Data Types
• String Data Types
• Character Set and Collation Support
• Data Type Considerations
• The Meaning of NULL

Creating a Database
• Creating a Table
• Showing How a Table Was Created
• Column Options
• Table Options
• Indexes, Keys, and Constraints

Deleting databases and tables
• Creating a New Table Using an Existing Table
• Confirming the Creation of a New Table
• Copying an Existing Table Structure
• Creating a Temporary Table
• Adding, removing and modifying table columns
• Adding, removing and modifying Indexes

Query with tables
• The SELECT Statement
• Creating Views
• Querying Data from an Application
• Exporting and Importing a Delimited File
• Troubleshooting: Authorization Levels

Modifying Table data
• Manipulating Data
• Inserting records
• Replacing existing records
• Updating existing records
• Deleting records
• Exporting and importing a script
• Multistatement Transactions
• Modifying Data from an Application

Functions
• Functions in MySQL Expressions
• Using Functions
• String Functions
• Date and time functions
• Numeric Functions
• Aggregate Functions
• Spaces in Function Names

Joining tables
• Querying Multiple Tables
• Joining Tables with SELECT
• Inner Joins
• Outer Joins
• Table Name Aliases