ADM EC M ULTIM EDIA INSTITUTE
ISO 9001:2008 Cert ified for Qualit y and M anagement
-----------------------------------------------
Advanced SQL Course
Durat ion: 1 M ont h (2Hrs/ 3Days in a Week)
SQL or Structured Query Language is a de-fact o st andard and a st andard
language for accessing t oday's most popular dat abases. In our inst it ut e our
advanced SQL course w ill t each you and make you proficient in using SQL t o
access and manipulat e dat a in various popular dat abases like M ySQL, SQL
Server, Access, Oracle, Sybase, DB2, and ot her dat abase syst ems being used in
w eb development . Follow ing are t he few t opics t hat w e w ill cover in our course.
Pre-requisites for this Advanced SQL Course
Candidat e must know basics of comput er and int ernet only. Know ledge of M icrosoft Excel and
Access or any ot her dat abase w ould be an added advant age.
1. Introduction to SQL
What is SQL?
SQL Course overview
Inst alling t he t est environment
Edit ors and Plat forms t o learn SQL
2. Complete SQL in a Class
Quick-st art int roduct ion
Using t he basic SELECT st at ement
Select ing row s and columns
Count ing row s
Insert ing dat a
Updat ing dat a
Delet ing dat a
3. Fundamentals of SQL
Dat abases and t ables
SQL synt ax overview
Creat ing and Delet ing a t able
Insert ing row s int o a t able
Delet ing row s from a t able
What is NULL?
Cont rolling column behaviors w it h const raint s
Changing a schema w it h ALTER
Creat ing an column w it h ID
Filt ering dat a w it h WHERE, LIKE, and IN
Removing duplicat es w it h SELECT DISTINCT
Sort ing w it h ORDER BY
4. How Relationships W ork in SQL
Underst anding joins
Accessing relat ed t ables w it h JOIN
M ult iple relat ed t ables
5. Explaining SQL Strings
St rings in SQL
Finding t he lengt h of a st ring
Select ing part of a st ring
Removing spaces w it h TRIM
M aking st rings uppercase and low ercase
6. Numbers and SQL
About numeric t ypes
Finding t he t ype of a value
Int eger division and remainders
Rounding numbers
7. Dates in SQL
Use of Dat es and t imes
Dat e- and t ime-relat ed funct ions
8. Aggregates Functions
How aggregat es w ork
Using aggregat e funct ions
Aggregat ing DISTINCT values
9. Exploring SQL Transactions
Why use t ransact ions?
Using t ransact ions
10. Studying Triggers in SQL
Updat ing a t able w it h a t rigger
Prevent ing aut omat ic updat es w it h a t rigger
Aut omat ing t imest amps w it h a t rigger
11. W hat are Subselects and View s in SQL
Creat ing a simple subselect
Searching w it hin a result set
Creat ing a view and joined view
12. A Simple CRUD Application in SQL
Touring t he CRUD applicat ion
SELECT funct ion
INSERT funct ion
UPDATE funct ion
DELETE funct ion
Pre-requisites for the Course
Candidat e must know basics of comput er and int ernet only. Know ledge of M icrosoft Excel and
Access or any ot her dat abase w ould be an added advant age.
Learning Outcomes
You w ill be proficient in creat ing st ruct ured queries w it h t he sense of dat abase normalizat ion
and de-normalizat ion w it h various ot her t echniques.
Career Options: SQL Expert
------------------------------------------------------------------------------------------------------------------------------------------
For M ore Info Please Contact Us
Our Address
ADM EC M ultimedia Institute
C-7/ 114, IInd Floor, Sect or-7, Rohini, Delhi-110085, India
Landmarks: Near Rohini East M et ro St at ion and Sect or-7 & Sect or-8 Divider Road
Phone Numbers
+91-9911 782 350, +91-9811 818 122, +011-3203 5055
W ebsites
w w w .admecindia.co.in | w w w .w eb-development -inst it ut e.com
------------------------------------------------------------------------------------------------------------------------------------------
