ADMEC Multimedia Courses

Advanced SQL Course

Training Mode: 

Classroom and Online

Duration: 

1 Month (2 Hrs/ 3 Days in a Week, Sat & Sun- 2½ Hrs/ 2 Days in a Week)

SQL or Structured Query Language is a de-facto standard and a standard language for accessing today's most popular databases. In our institute our advanced SQL course will teach you and make you proficient in using SQL to access and manipulate data in various popular databases like MySQL, SQL Server, Access, Oracle, Sybase, DB2, and other database systems being used in web development. Following are the few topics that we will cover in our course.

Pre-requisites for this Advanced SQL Course

Candidate must know basics of computer and internet only. Knowledge of Microsoft Excel and Access or any other database would be an added advantage.

1. Introduction to SQL

  • SQL Course overview
  • Installing the test environment
  • What is SQL?
  • Editors and Platforms to learn SQL

2. Complete SQL in a Class

  • Quick-start introduction
  • Using the basic SELECT statement
  • Selecting rows
  • Selecting columns
  • Counting rows
  • Inserting data
  • Updating data
  • Deleting data

3. Fundamentals of SQL

  • Databases and tables
  • SQL syntax overview
  • Creating tables
  • Deleting a table
  • Inserting rows into a table
  • Deleting rows from a table
  • What is NULL?
  • Controlling column behaviors with constraints
  • Changing a schema with ALTER
  • Creating an column with ID
  • Filtering data with WHERE, LIKE, and IN
  • Removing duplicates with SELECT DISTINCT
  • Sorting with ORDER BY

4. How Relationships Work in SQL

  • Understanding joins
  • Accessing related tables with JOIN
  • Multiple related tables

5. Explaining SQL Strings

  • About SQL strings
  • Finding the length of a string
  • Selecting part of a string
  • Removing spaces with TRIM
  • Making strings uppercase and lowercase

6. Numbers and SQL

  • About numeric types
  • Finding the type of a value
  • Integer division and remainders
  • Rounding numbers

7. Dates in SQL

  • Use of Dates and times
  • Date- and time-related functions

8. Aggregates Functions

  • How aggregates work
  • Using aggregate functions
  • Aggregating DISTINCT values

9. Exploring SQL Transactions

  • Why use transactions?
  • Using transactions

10. Studying Triggers in SQL

  • Updating a table with a trigger
  • Preventing automatic updates with a trigger
  • Automating timestamps with a trigger

11. What are Subselects and Views in SQL

  • Creating a simple subselect
  • Searching within a result set
  • Creating a view
  • Creating a joined view

12. A Simple CRUD Application in SQL

  • Touring the CRUD application
  • The SELECT functions
  • The INSERT, UPDATE, and DELETE functions

Training Mode: 

  • Regular
  • Fast-Track
  • Weekends (Sat/Sun)
  • Only Sundays
  • Online
  • Others

How to Apply: 

If you require any further information regarding our SQL Course please contact our admission team, email: admission@admecindia.co.in, phone: +91 (0)9811 8181 22.

Why Join Us?: 

We believe in completely practical SQL training with a very professional environment.

Learning Methodology: 

You will be proficient in creating structured queries with the sense of database normalization and de-normalization with various other techniques.

Our Brochure: 

Career Options: 

SQL Expert

Want a call from our expert!!! Please fill up this form

Fill the Form
Image CAPTCHA
Enter the characters shown in the image.

Newsletter

Don't want to miss our interesting news and updates! Make sure to join our newsletter list.

Registered Address

ADMEC MULTIMEDIA INSTITUTE
C-7/114, IInd Floor, Sector- 7, Rohini, Delhi- 85
Landmark: Rohini East Metro Station
Helpline 1: +91 9811 - 818 - 122
Helpline 2: +91 9911 - 782 - 350

Connect with us

We're on Social Networks. Follow us & get in touch.

DMCA.com Protection Status

OUR INSTITUTE TIMINGS

Mon - Sat:  8:00 am - 8:00 pm
Sunday:  10:00 am - 4:00 pm
(Only 3rd Sunday Closed)

Send us a message

2 + 0 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.