We Offer MySQL Database Training Course in Islamabad Pakistan.

SQL (Structured Query Language) is the world’s most widely used database language, used in a large variety of database systems for creating queries and manipulating data. SQL is supported by database programs such as MySQL, Microsoft SQL Server, and Oracle Database.

SQL – An Overview

• Relational Databases
• Using SQL
• Using Object Explorer
• Hiding system objects

SQL & MySQL

Creating databases

• Designing databases
• Primary keys
• Indexing fields

Working with tables

• Creating tables
• Allowing nulls
• Identity fields
• Database diagrams
• Designing database diagrams
• Joining tables

Data Manipulation Language

• SELECT, DISTINCT Operations
• Functions
• Ordering Data
• Inserting, Updating & Deleting rows

Queries

• Writing queries
• Indentation and case
• Setting criteria using WHERE
• Wildcards
• Setting criteria for dates
• Dealing with nulls

Exporting

• Results, text, and grid options
• Copying and pasting column headings
• Exporting using SQL & the menu

Calculations

• Calculated columns
• Aliases
• String functions and concatenation
• Using GetDate
• Converting dates
• Useful date functions

Joins

• Inner joins
• Table aliases
• Left and right outer joins
• Cross joins
• Full outer joins
• Self joins

Aggregation and grouping

• SUM, AVG, MIN, MAX
• Counts
• Grouping by fields
• Using HAVING to filter results

Views

• The view designer
• Limitations of the designer
• Scripting views

What will you gain from this Introduction to SQL Course?

During this course you will:

• Learn how read SQL
• Learn how to write queries
• Learn how to work with tables and fields
• Learn how to join multiple tables together in a query
• Learn how to output data for analysis