SQL & MS ACCESS
SQL is a database computer language designed for the
retrieval and management of data in relational database. our objective is to teach you how to use SQL to access and manipulate data in: MySQL, SQL Server, Access, Oracle, DB2, and other database systems.
What is SQL?
SQL stands for Structured Query Language
SQL lets you access and manipulate databases
SQL Overview & Relational database concepts
Some of The Most Important SQL Commands
SELECT - extracts data from a database
UPDATE - updates data in a database
DELETE - deletes data from a database
INSERT INTO - inserts new data into a database
CREATE DATABASE - creates a new database
ALTER DATABASE - modifies a database
CREATE TABLE - creates a new table
ALTER TABLE - modifies a table
DROP TABLE - deletes a table
CREATE INDEX - creates an index (search key)
DROP INDEX - deletes an index
SQL Functions and Expressions
SQL Sub queries and Unions
What is Access ?
Why it's Need
Difference between Excel Vs ACCESS
Import / Export data in ACCESS
What is Access database?
Data Base link
What is Access Objects?
Create table using all methods
What is Query ?
Various types of Query?
Cross Tab Query vs other Query
SQL View Query Wizard Form design Access Macro etc