Home || GulfamTech

Welcome to GulfamTech. You will hardly find wrong people at right places.

Translate:

Call us now

+91-976-034-0240
Mohalla Thotar Sabzi Mandi
Near Middle School

Rampur, U.P 244901
Mon - Sat

07.00 - 20.30

MYSQL Course Overview

SQL stands for Structured Query Language SQL lets you access and manipulate databases SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987

MYSQL Objectives

SQL can execute queries against a database
SQL can retrieve data from a database
SQL can insert records in a database
SQL can update records in a database
SQL can delete records from a database
SQL can create new databases
SQL can create new tables in a database
SQL can create stored procedures in a database
SQL can create views in a database
SQL can set permissions on tables, procedures, and views

Module 1: MySQL Core and SQL Basics

MYSQL Server Basics
Database models
ER Model Overview
Data types
Understanding Test Database
Basics Queries
Removing Duplicates
Data Filters Using Operators
Data Sorting

Module 2: Query Design & Functions

Grouping
Joins
Arithmetic and String functions
Advanced Functions
SET Operators
Creating Complex Queries
DML operations - Insert, Update & Delete
TSQL

Module 3: Database Operations

Database Objects - Create, Alter and Drop Tables
Views
Complex Views
Indexes
Advanced Index Concepts
Security - User Management Basics

Module 4: Routines

Programming Basics
Programming Concepts in PLSQL
Cursors
Nested Cursors
Functions
Procedures
Interoperability between Functions & Procedures
Query Optimization Techniques