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

Querying SQL Server

Advertisement

Querying SQL Server


Microtechx is pleased to announce Course on Querying SQL Server Microsoft Certification Track Module I.

Starting Date: Sunday 25th March 2018
Time: 3:00 PM to 5:00 PM
Weekend Classes

*Course Fee: 15,000/- PKR*

Register Here: https://goo.gl/forms/xAFAT6UqgQyrOIE13

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



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
Loading venue map..
Event details from Report a problem

Are you going to this event?

Advertisement