X
Search results for:
No result found! Try with different keywords!
Users
Organizers
Events
Advertisement

Querying SQL Server

Advertisement

Querying SQL Server


Register @ https://goo.gl/forms/0AYKJM06rNoOlUP22

Starting Date: 23rd June 2018
Time: 9:00 AM to 11:00 AM
Weekend Classes

*Course Fee: 13,000/- PKR*

Course Content:

• Foundation of Querys
o Understanding the foundations
o Understanding logical Query processing
o Quiz
o Case Study 1
o Case Study 2

• Getting Started with Select Statement
o Using the from and Select Clause
o Working with DataTypes and Built in functions
o Case Study 1
o Case Study 2
o Quiz

• Filtering and Sorting Data
o Filtering Data with predicates
o Sorting Data
o Filtering Data with TOP and OFFSET-FETCH
o Case Study 1
o Case Study 2
o Quiz

• Combining Sets
o Using joins
o Using Subqueries ,Table Expressions and Apply Operator
o Using SET Operators
o Case Study 1
o Case Study 2
o Quiz

• Grouping and Windowing
o Writing Grouped Queries
o Pivoting and UnPivioting Data
o Using Windows Functions
o Case Study 1
o Case Study 2
o Quiz

• Querying Full TextData
o Creating FullText catalogs and indexes
o Using the Contains and FREE TEXT Predicates
o Using the full text and Semantic Search
o Case Study 1
o Case Study 2
o Quiz

• Quering and Managing XML Data
o For XML Clause
o Xquery
o XML Data Type
o Case Study 1
o Case Study 2
o Quiz

• Creating Tables and Enforcing Integrity
o Creating and Altering table
o Enforcing Data Integrity
o Case Study 1
o Case Study 2
o Quiz

• Designing and Creating Views ,Inline functions and Synonyms
o Implementation of Views
o Implementation of Inline Views
o Using Synonyms
o Case Study 1
o Case Study 2
o Quiz

• Inserting ,Updating and Deleting Data
o Inserting Data
o Updating Data
o Deleting Data
o Case Study 1
o Case Study 2
o Quiz

• Data Modification Aspects
o Sequance Object and Indentity Column
o Merging Data
o Using Output Option
o Case Study 1
o Case Study 2
o Quiz

Trainer:
Yasir Fazal
Co-founder of IBSTEL. A Retail Technology Company
PMP Certified
Microsoft Certified Professional in BI

Contact: 0322-4400400
Venue:
Suit # 108 1st Floor Sajjad Center Block H3 Johar Town,Near Expo Center Lahore



You may also like the following events from Microtechx:

Also check out other Business Events in Lahore, Exhibitions in Lahore, Workshops in Lahore.

Liked this event? Spread the word :

Map Microtechx, Suit#108 1st Floor Sajjad Center Block H3 Johar Town Lahore (Near Expo Center), Lahore, Pakistan-54000, Lahore, Pakistan
Loading venue map..
Report a problem

Are you going to this event?

Advertisement
Create an Event