SQL

TOPS Inc.
Ahmedabad, Gujarat, India

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' What is SQL?
A simple SQL statement
SQL-92
Differences between SQL dialects
Choosing a database
Relational databases
Relational vs. flat file databases
Standardization
Normalization
First, second, and third normal forms
SQL Foundations
Database components
Creating a table
Table statements
Understanding indexes
Creating indexes
Indexes and engines
The INSERT statement
The SELECT statement
Querying a table
Creating the table
Data types
INSERTs
SELECTs
Adding rows
The UPDATE statement
The problem with UPDATEs
Using the WHERE clause with UPDATE
The DELETE statement
The ALTER statement
The SELECT statement
Filtering SELECTs
WHERE in more detail
LIKE
INTO
Sorting information
ORDER BY
Ordering multiple columns
Ascending and descending order
Mastering the SELECT statement
The GROUP BY clause
Sorting or GROUP BY?
Sub-SELECTs
Sub-SELECT options
EQUALS
DISTINCT ...''

Elements of this syllabus are subject to change.

Phone:+91 79 3061 2162, 63

School Address/Venue(s):

907 Samedh Complex
Next to Associated Petrol Pump
CG Road
Ahmedabad 380009
India

Jobs & Resumes: Ahmedabad
Houses & Roommates: Ahmedabad

Search other schools for SQL training resources.

Automation Testing
Developing a Web Site
Java
EJB Architecture
Writing Entity Beans
EJB 2.0 Interface Enhancements
Java for Developers
PHP
JavaScript
Perl
Perl Security
Web Security
Perl Modules from CPAN
Software Quality Assurance

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed.