The SQL Developer 2014 Beginner is the perfect course for developers new to SQL Server and planning to create and deploy applications against Microsoft’s market-leading database system for the Windows platform. Learn everything you need to know to start building databases with SQL Server. Watch and learn how to install and configure SQL Server, create databases and tables, automate common tasks like backups, and use the SQL query language to retrieve and manipulate data.

Why choose this course

  • Earn a free e-certificate upon successful completion.
  • Accessible, informative modules taught by expert instructors
  • Study in your own time, at your own pace, through your computer tablet or mobile device
  • Benefit from instant feedback through mock exams and multiple-choice assessments
  • Get 24/7 help or advice from our email and live chat teams
  • Full Tutor Support on Weekdays

Course Design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

  • Video lessons
  • Online study materials
  • Mock exams
  • Multiple-choice assessment

Certification

Upon successful completion of the course you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of 9.99 and PDF Certificate at 4.99.

Who is this course for?

SQL Developer 2014 Beginner is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This is a great opportunity for all student from any academic backgrounds to learn more on this subject.

Course Curriculum

Module: 01
Introduction FREE 00:16:00
Tools for Creating Views 00:11:00
Examples 00:21:00
Updating Data Using a View 00:13:00
Columns and Indexed Views 00:18:00
Module: 02
Introduction Stored Procedures 00:18:00
Creating Stored Procedures 00:19:00
Returning Data 00:14:00
Module: 03
Testing and Debugging 00:17:00
Execute with Result Sets 00:11:00
Creating Triggers 00:26:00
Module: 04
Overview and Scalar Functions 00:20:00
Inline Table Valued Functions 00:11:00
Multi Statement 00:16:00
Views and Stored Procedures 00:18:00
Module: 05
Transaction Concepts 00:30:00
Applications and Transactions 00:13:00
Creating Explicit Transactions 00:29:00
Structured Error Handling 00:25:00
Module: 06
Introduction to SQL CLR 00:08:00
Writing SQL CLR Code 00:24:00
Using SQL CLR Code 00:22:00
SQL CLR Code 00:13:00
SQL CLR Security 00:20:00
Mock Exam
Final Exam

Course Reviews

4.9

4.9
9 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

622 STUDENTS ENROLLED

© Janets.