|
TOPS offers training in all Web Technologies. Our expertise is in training students in ASP.Net, VB.Net, PHP, Java, Open CMS, Drupal, Joomla, Software Testing (Manual and Automation), QTP, and Loadrunner and enabling them to get employment with various companies in Gujarat.
SQL Training
|
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
|
Joins
- What are joins?
- Why you need joins
- Creating a simple join
- INNER joins
- OUTER joins
- LEFT joins
- RIGHT joins
- FULL joins
- UNION
Key SQL Functions
- Strings and substrings
- UPPER and LOWER
- LENGTH
- TRIM
- Arithmetic functions
- SUM
- AVG
- MIN and MAX
- Date functions
- DATEADD
- DATEDIFF
- DATEPART
- GETDATE
- SYSDATE
- TODAY
Views
- What they are and how they work
- Abstraction
- Selecting from a view
- Creating a view
- Updates with views
- Secure views
The MySQL RDBMS
- Compilation of source code
- Installation
- Configuration
- MySQL extensions
- Optimizing SELECTs, UPDATEs, INSERTs and DELETEs
- Table types
- Portability
- Tuning mysqld
- OS tuning
- Hardware tuning
- Drivers and interfaces (Perl, PHP, C++, etc)
|
College Students from Gujarat (Ahmedabad, Vadodara, Rajkot, Jamnagar, Mehsana, Surat, Valsad, Bhavnagar, Patan) Amreli, Gandhinagar Gujarat, Udaipur, Jaipur, Jodhpur, Rajasthan, Madhya Pradesh (M.P) BCA, MCA, BE IT, BE Tech, BSC IT can also join.
|
