Visual Studio Azure SQL Essential

On-Site / Training

Tertiary Courses 170 Upper Bukit Timah Road #05-23, #05-22, #05-19 Bukit Timah Shopping Centre Singapore 588179, Singapore, Singapore, Singapore 588179

SGD 298.00

Inquire Book Now

RESPONSE RATE

Details
Outline
About the Provider

Book Now

Inquire

Details

SkillsFuture Course - Visual Studio Azure SQL Essential

If you're developing with Visual Studio, you have a variety of tools available for managing database connections, manipulating tables, querying data, and deploying projects. This course will train you on Visual Studio platform which supports SQL Express LocalDB and the SQL Server, as well as Azure cloud-based data services.

Outline

Module 1. Database and Data Integration

Understanding SQL Server Data Tool (SSDT)
Install SSDT features
Explore Microsoft databases
The Azure data sources

Module 2. SQL Server Express LocalDB

Why localDB is essential for developers
Understanding SQL Server named instances
Determine the version LocalDB
How LocalDB in demand features work
List the apps that use LocalDB

Module 3. Server Explorer

Compare the Server Explorer and SQL Server Object Explorer windows
Data connnections available in SQL Server
Connect to a SQL database in Server Explorer
Connect to another database in Server Explorer
Manage connections
Add a project level database
Work with database table
Change database entities with Server Explorer or SQL Server Object Explorer

Module 4. SQL Server Object Explorer

How to accesss SQL Server Object Explorer (SSQE)
Interaction with Server Explorer from SSQE
Copy the database for editing
Add SQL Server to Object Explorer
Use a logical name to shorten the path
Tour the Table Designer
Add field to table
Understand the Power Buffer
Add or modify table data
Add or remove tables

Module 5. Queries, Views and Stored Procedures

Connect to Northwind database
User the Query window
Work with exiting Views
Create a custom View
Work with Existing Stored Procedures
Create a Custom Stored Procedure

Module 6.Compared Databases

Prepare to compare databases
Data comparison
Scheme comparison

Module 7. SQL Server Data Project

Understand the data project template
Create a data project
Add items to project
Import an existing database
Change a table or other data item
Build the project
The sandboxed debug database
Refactor a database object
Deploy the database with the publish option
Work with source control

Nodule 8. Azure Data

Create a Azure account
Connect to Azure with Server Explorer
Create an Azure SQL database with the Azure portal
Connect to Azure SQL database with Server Explorer
Deploy a Data Project to Azure
Manage Azuare SQL Databse with the SQL Object Explorer

Module 9. Entity Framework

What is Entity Framwork
The three approaches to modeling
Use database first to create an EDM
Explore the EDM
Use the table mapping window
Use the Model Browser window
Modiy the EDM
Use LINQ to query the EDM

Speaker/s

Joseph Bernabe Bagnes have 6 years total experience in IT industry. I started as Professional Instructor under Sun Microsystems and Oracle University handling Fundamentals of Java and Advanced JavaEE courses. As an instructor of Sun Microsystems itself, He went through a very comprehensive training which gave me a very solid foundation of Java knowledge. He then went to Hewlett-Packard as a developer practising and realizing all my knowledge into building enterprise-level applications with high business value. I am currently working with Credit Agricole Corporate and Investment Bank, a French bank, started as a developer and currently serving as Technology Lead and Architect of Transverse Security Services division. During my free time, He a lot of freelance programming, YouTube programming tutorials, spending time answering questions in Stack Overflow and contributing to open-source projects like Spring Security (Kerberos extension). I conduct seminars and talks to various universities and schools.

Reviews

Be the first to write a review about this course.

Write a Review

Tertiary Courses Singapore offer many SkillsFuture courses in Singapore. We offers wide range of classroom instructor-led technical training courses for working professionals and executives in Singapore. Many of our courses and trainings are SkillsFuture Approved and eligible for WDA Absentee Payroll Grant.

Our courses include Infocomm, Digital Media, Robotics, Semiconductor,Telecommunication, Life Science, Horticulture Industries , and Business Administration . Below are some of our popular courses