Call +65 6100 0613 Email: enquiry@tertiaryinfotech.com

Instructor-led Classroom Adult Training in Singapore - Modular Fast Track Skill-Based Trainings

Microsoft Azure SQL Essential Training

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.

Course Highlights

  • Exploring integration with Azure data sources and other Microsoft databases
  • Working with SQL Server Express LocalDB
  • Connecting to databases with Server Explorer
  • Working with database tables
  • Manipulating tables with the SQL Server Object Explorer
  • Creating queries and custom views
  • Creating stored procedures
  • Comparing databases
  • Building a data project in Visual Studio
  • Refactoring a database object
  • Deploying the database
  • Connecting to Azure databases
  • Deploying data projects to Azure
  • Integrating Visual Studio with Entity Framework

Certificate

All participants will receive a Certificate of Completion from Tertiary Courses after achieved at least 75% attendance.

Funding and Grant Applications

Click the links below to apply. Note that you need to register the course first.

For Singaporeans: SkillsFuture Credit

For Company: SSG Training Grant

Course Code: CRS-N-0035372

Course Booking

$298.00 (GST-exclusive)
$318.86(GST-inclusive)

Course Date

Course Time

* Required Fields

Course Cancellation/Reschedule Policy

We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
Note the venue of the training is subject to changes due to class size and availability of the classroom.
Note the minimal class size to start a class is 3 Pax.


Course Details

  • Module 1 SQL Server Express LocalDB
  • Module 2 Exploring SQL Server
  • Module 3 SQL Query
  • Module 4 SQL Server Data Project
  • Module 5 Azure Database
  • Module 6 Entity Framework

Course Admin

Nil

Who Should Attend

  • Database Administrators who use Azure
  • Programmers who use Microsoft Visual Studio
  • Database Engineers who use Microsoft Visual Studio Azure

Trainers

Azure SQL TrainerSanjiv i is an experienced leader with a proven track record in business / finance consulting and in developing i) business intelligence (BI) solutions ii) data analytics/analysis solutions and iii) IOT lead BI solutions.

Sanjiv is also known for his strong presentation and communication skills and being able to communicate complex topics in a simple and elegant way. His goal through Prudentia Consulting, is to promote the simple joy and excitement of actively using the Microsoft Platform. He believes that the agility afforded by the Microsoft platform helps businesses get time back for deeper business thinking and to spend more time with their end customers

Sanjiv has spent a little over 20 years across North America (17 years) and Asia Pacific (3.5 years) with rich experiences in diverse/complex high-tech businesses, turn around environments and strategic transformations. His functional expertise is in sales analytics, financial planning and analysis, engineering and program management. He has worked across discrete manufacturing, professional services and higher education verticals. He also has a working knowledge of equities portfolio management within the financial services domain.

Sanjiv is the CEO of Prudentia Consulting, an organization committed to promoting the active usage of the Microsoft Platform. Prior to this, he has worked at Microsoft (US & APAC: 9.2 years), Cognizant Tech Solutions (3.3 years), Yazaki North America (8 years) and until recently at Oracle.

Below are a few of his BI/analytics projects driven at scale:

  • Built APAC wide BI dashboard using the Power BI umbrella tool set (Power BI online, Power BI desktop and Power Pivot) and a KPI lake (SQL DB)
  • Helped develop key KPIs – identified key KPIs and helped land this in the DB
  • Developed a budget audit tool that captured budget inputs from a host of countries across the globe
  • Developed a business unit P&L reporting tool (functional architecture) in Business Objects for the world-wide financial planning and analysis team

Azure SQL TrainerPeter Goh is the Technology Evangelist at Disruptive Digital, a full-service digital agency based in Singapore, offering innovative & effective web and native mobile application development. He specializes in bleeding edge software development and have more than 10 years' experience in developing customized applications for desktop, web and mobile platforms. He has extensive domain knowledge in .Net and Java programming, iOS development and has helped many to create e-commerce web sites on Amazon AWS and Microsoft Azure

Azure SQL TrainerRaaj has 14 years of experience in Designing , delivering and supporting, products, projects and programs in the area of enterprise SAP and Data Science . He is certified in SAP ABAP,HANA and ACTA certified as well .

He has also trained many consultants and developers on Data Science, R programming, Python, SAP HANA, BI and related products and worked extensively in Asia ( Singapore, Bhutan, Vietnam, India, Myanmar ). His core specialization skills are R programming, Python, Azure Machine Learning, SAP HANA.

Azure TrainerJoseph 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.

His portfolio in professional training includes:

  • Fundamentals of Java (training course for people with no or minimal experience in Java)
  • Advance Java (training course for developers with enough experience in Java SE)
  • Enterprise Java (training course for developers building web applications using Java EE)
  • Java Certifications review (training course for people preparing for Java certification exams)

Topics that he have expert-level knowledge and I conduct tutorials:

  • Spring Framework and Spring MVC
  • Hibernate and Java Persistence API
  • Microsoft Forefront Identity Manager

Customer Reviews (3)

Will RecommendReview by Lim Ee Hai
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
More practical examples (Posted on 8/7/2019)
Will RecommendReview by Teo Eng Loe
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
May be allocate more time for hand-on. (Posted on 8/7/2019)
Will RecommendReview by Lim Ee Hai
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
More practical examples (Posted on 8/7/2019)

Write Your Own Review

You're reviewing: Microsoft Azure SQL Essential Training

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
  • Reload captcha

Tags

Use spaces to separate Subjects. Use single quotes (') for phrases.

You May Be Interested In These Courses

C Programming Essential Training

C Programming Essential Training

8 Review(s)
$298.00 (GST-exclusive)
$318.86(GST-inclusive)
C++ Essential Training

C++ Essential Training

11 Review(s)
$298.00 (GST-exclusive)
$318.86(GST-inclusive)
C# Programming Essential Training

C# Programming Essential Training

12 Review(s)
$298.00 (GST-exclusive)
$318.86(GST-inclusive)