Description

Recommended Book

Beginning T-SQL 2012 is the first step toward learning the T-SQL language that underlies Microsoft’s SQL Server database engine. T-SQL is essential in writing SQL statements to get data into and out of a database. T-SQL is the foundation for business logic embedded in the database in the form of stored procedures and functions. Beginning T-SQL 2012 starts you on the path to mastering T-SQL, with an emphasis on best practices and sound coding techniques.

Beginning T-SQL 2012 begins with an introduction to databases, normalization, and to SQL Server Management Studio. Each subsequent lesson teaches an aspect of T-SQL, building on the skills learned in previous lessons. Exercises in each lesson give students an opportunity for the hands-on practice that leads to true learning and distinguishes the competent professional.

Syllabus

  1. Getting Started
  2. Writing Simple SELECT Queries
  3. Using Functions and Expressions
  4. Querying Multiple Tables
  5. Grouping and Summarizing Data
  6. Manipulating Data
  7. Understanding T-SQL Programming Logic
  8. Working with XML
  9. Moving Logic to the Database
  10. Working with Data Types
  11. Writing Advanced Queries
  12. Where to Go Next?

Enrollment Information

Self-Paced

» Online
» Free Course Resources
» Online Course Facilitator
» Online Assessments
» Facilitator initiated Conferencing
» Student Gradebook
» Interactive Tools
» Communication Center
» Certificate

Blended Learning

» All options of Self-Paced
» Online / Offline
» Physical Campus Enrollment

For Blended Learning option please explore our Affiliated Institutes in different countries and ask for Enrollment.

Checkout

Beginning T-SQL 2012
Level: Beginner
Code: CODE143023704X
Cost: 40 USD
Duration: 45 days

Related Experts

Ali Jutt
Located in Pakistan
Primary Job
Custom Projects Team Lead-RADCO
Contact & Details
Contact & Other Details Available for Consulting
Alamdar Hussain
Located in Pakistan
Primary Job
SEO Team Lead-RADCO
Contact & Details
Contact & Other Details Available for Consulting
Umair Anwer
Located in Pakistan
Primary Job
edExt Administrator
Contact & Details
Contact & Other Details Available for Consulting
Muhammad Ishaq Malik
Located in Pakistan
Primary Job
WordPress Team Lead-RADCO
Contact & Details
Contact & Other Details Available for Consulting
Faraz-ul-Islam
Located in Pakistan
Primary Job
Graphic Designer-RADCO
Contact & Details
Contact & Other Details Available for Consulting
Bilal Ahmad
Located in Pakistan
Primary Job
Project Manager-RADCO
Contact & Details
Contact & Other Details Available for Consulting
Muhammad Awais
Located in Pakistan
Primary Job
Custom Developer-RADCO
Contact & Details
Contact & Other Details Available for Consulting
Muhammad Akbar
Located in Pakistan
Primary Job
Web Team Lead-RADCO
Contact & Details
Contact & Other Details Available for Consulting