Product Image

Developing Microsoft SQL Databases (MS-20762) (Flex)

The course aims around teaching individuals the way to utilize SQL Server product tools and features identified with developing a database.

Virtual

Learning Style

Microsoft

Provider

Intermediate

Difficulty

20 Days (2 hrs/day)

Course Duration

Course Info

Download PDF

Certificate

See Sample

Timezone
tab
About Individual Course:
  • Individual course plan gives you access to this course
New
$2,995.00
/ Seat

You have already taken demo for this course.

If you want to get access to demo again, feel free to contact our support at (855) 800-8240

The course aims around teaching individuals the way to utilize SQL Server product tools and features identified with developing a database.

Course Information

About this course:

This five-day instructor-drove course gives understudies the skills and information to build up an MS SQL Server database. The course aims around teaching individuals the way to utilize SQL Server product tools and features identified with developing a database. This course additionally readies the understudies for the MS 70-464: certification exam of Developing MS SQL Server Databases.

The normal pay for a SQL Developer is $81,714 every year.

Course Objectives:

  • Plan and Implement Tables.
  • Project and Implement Views.
  • Confirm Data Integrity through Constraints.
  • Explain advanced table designs
  • Define indexes, including Columnstore and Optimized indexes
  • React to data manipulation using triggers.
  • Plan and Implement Stored Procedures.
  • Design and execute User Defined Functions.
  • Query and Store XML Data.
  • Design and apply In-Memory Tables.
  • Execute Managed Code in SQL Server.
  • Work with Spatial Data.
  • Store and Query Text and Blobs Documents.

Audience:

  • The IT Professionals need to be an expert on SQL Server product features and technologies for database implementation are the primary audience of this course.
  • The secondary audience is individuals coming from other product platforms or past forms of SQL Server looking to become professional in the usage of a SQL Server database.

Prerequisites:

  • Fundamental information on the MS Windows operating framework and its core functionality.
  • Working information on Transact-SQL.
  • Working information on relational databases.

Outline

More Information

More Information
BrandMicrosoft
SubjectsIT Ops & Management
Lab AccessNo
TechnologyMicrosoft
Learning StyleVirtual Classroom
Learning TypeCourse
DifficultyIntermediate
Course Duration20 Days (2 hrs/day)
LanguageEnglish

Reviews

Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account

Course Expert:

Author

Tom Robertson
(Data Science Enthusiast)

Tom is an innovator first, and then a Data Scientist & Software Architect. He has integrated expertise in business, product, technology and management. Tom has been involved in creating category defining new products in AI and big data for different industries, which generated more than hundred million revenue cumulatively, and served more than 10 million users.
As a Data Scientist and Software Architect Tom has extensive experience in data science, engineering, architecture and software development. To date Tom has accumulated over a decade of experience in R, Python & Linux Shell programming.

Tom has expertise on Python, SQL, and Spark. He has worked on several libraries including but not limited to Scikit-learn, Pandas, NumPy, Matplotlib, Seaborn, SciPy, NLTK, Keras, and Tensorflow.

click here