SQL is a database used to access a excel database

Duration: 16 Hours

SQL is a database computer language used to access a database. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, etc.

Module 1: introduction to SQL

    What is SQL?
    Why and where is SQL used?
    Why should one learn SQL?
    Database fundamentals.
    What is a database?
    What are the different features in a database (for example; primary key, foreign key and candidate key)

Module 2: Basic Relational Database Management Concepts

    How to access one table from the other?
    What are the different relationships possible between two tables?
    How to use SQL commands in Access?
    Normalization
    1NF, 2NF..BCN
    Model a normalized database

Module 3: Introduction to the concept of Tables

    Overview
    How to create a table?
    How to import data from excel , text files?
    How to check the tables for consistency?
    Functions
    How /Where/Why use the SELECT function?
    How/Where/Why use the INSERT / UPDATE / DELETE function?

Module 4: Database Functions

    How/Where/Why use "GROUP BY" option?
    How/Where/Why use "COUNT" option?
    How/Where/Why use "WHERE" option?
    Mathematical Functions: AVG, SUM, MIN, MAX, FIRST, LAST
    Scalar Functions: UCASE, LCASE, MID, LEN, NOW, ROUND, FORMAT
    Primary Key Constraint â ALTER
    In Class project using Functions