SQL Developer 2014 Beginner - John Academy

7/9/2018

SQL Developer 2014 Beginner - John Academy

LOGIN

HOME / COURSE / TECHNOLOGY / SQL DEVELOPER 2014 BEGINNER

SQL Developer 2014 Beginner ( 9 REVIEWS ) 

546 STUDENTS

Description Nowadays, SQL Developers are in-demand and becoming a SQL developer can be a rewarding and ful lling profession. This is …

TAKE THIS COURSE

£199.00 £10.00

1 YEAR

https://www.johnacademy.co.uk/course/sql-developer-2014-beginner/

  1/12

7/9/2018

SQL Developer 2014 Beginner - John Academy

BEGINNER COURSE BADGE COURSE CERTIFICATE

   24

NUMBER OF UNITS NUMBER OF QUIZZES

0

7 HOURS, 13 MINUTES





HOME







CURRICULUM

REVIEWS

Description Nowadays, SQL Developers are in-demand and becoming a SQL developer can be a rewarding and ful lling profession.

This SQL Developer 2014 Beginner is intended for absolute beginners that concentrate on giving the appropriate knowledge of Microsoft SQL Server and help to acquire the skills and abilities to become an SQL Server developer as well as o er many job opportunities in the competitive job market.

In this course, you will learn how to create databases, tables, design databases and tables.

You will also learn to create at le database, con dently use SSMS Tool as well as write basic T-SQL Queries. In addition to that, learn to create constraints and views in the most dynamic way possible.

Enrol right now and start exploring SQL, the most popular relational database management system.

Entry Requirement: This course is available to all learners, of all academic backgrounds.

Learners should be aged 16 or over to undertake the quali cation.

Good understanding of English language, numeracy and ICT are required to attend this course.

https://www.johnacademy.co.uk/course/sql-developer-2014-beginner/

2/12

7/9/2018

SQL Developer 2014 Beginner - John Academy

Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful.

Before sitting for your nal exam, you will have the opportunity to test your pro ciency with a mock exam.

Certi cation: After completing and passing the course successfully, you will be able to obtain an Accredited Certi cate of Achievement. Certi cates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.

Why choose us?

A ordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; E cient exam systems for the assessment and instant result; The UK & internationally recognized accredited quali cation; Access to course content on mobile, tablet or desktop from anywhere anytime; The bene t of applying for NUS Extra Discount Card; 24/7 student support via email.

Career Path After completing this course you will be able to build up accurate knowledge and skills with proper con dence to enrich yourself and brighten up your career in the relevant job market.

COURSE CURRICULUM

Module: 01



Introduction



00:16:00



Tools for Creating Views



00:11:00



Examples



00:21:00



Updating Data Using a View



00:13:00

https://www.johnacademy.co.uk/course/sql-developer-2014-beginner/

3/12

7/9/2018



SQL Developer 2014 Beginner - John Academy

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

https://www.johnacademy.co.uk/course/sql-developer-2014-beginner/

4/12

7/9/2018



SQL Developer 2014 Beginner - John Academy

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   9 ratings

https://www.johnacademy.co.uk/course/sql-developer-2014-beginner/

5/12

7/9/2018

SQL Developer 2014 Beginner - John Academy

5 STARS

0

4 STARS

0

3 STARS

0

2 STARS

0

1 STARS

0

NO REVIEWS FOUND FOR THIS COURSE.

RELATED COURSES

https://www.johnacademy.co.uk/course/sql-developer-2014-beginner/

6/12

7/9/2018

SQL Developer 2014 Beginner - John Academy

CompTIA Network+ N10-007

£350.00 £49.00  

375

SQL Developer 2014 Advanced

£279.00 £14.00  

https://www.johnacademy.co.uk/course/sql-developer-2014-beginner/

566

7/12

7/9/2018

SQL Developer 2014 Beginner - John Academy

SQL Developer 2014 Intermediate

£249.00 £14.00 566

 

546 STUDENTS ENROLLED

https://www.johnacademy.co.uk/course/sql-developer-2014-beginner/

8/12

7/9/2018

SQL Developer 2014 Beginner - John Academy

CERTIFICATION

ACCREDITED BY

https://www.johnacademy.co.uk/course/sql-developer-2014-beginner/

9/12

7/9/2018

SQL Developer 2014 Beginner - John Academy

CENTRE APPROVED BY

Registered with the UK Register of Learning Providers (UKRLP) UKPRN: 10063816

COURSE PARTNERS

https://www.johnacademy.co.uk/course/sql-developer-2014-beginner/

10/12

7/9/2018

SQL Developer 2014 Beginner - John Academy

ABOUT We are a company who is best known for o ering awarding body accredited courses for anyone who wishes to take their professional life to the next level.  11 Floor, 15 St Botolph Street, London EC3A 7BB  020 3744 3990  info@johnacademy.co.uk CERTIFICATE CODE Enter Certi cate Code

VALID ATE

IMPORTANT LINKS https://www.johnacademy.co.uk/course/sql-developer-2014-beginner/

11/12

7/9/2018

SQL Developer 2014 Beginner - John Academy

About Us FREE CV REVIEW For Business Redeem Voucher Terms & Conditions Privacy Policy Cookie Policy FAQ Contact FREE CV REVIEW

© JOHN ACADEMY.



https://www.johnacademy.co.uk/course/sql-developer-2014-beginner/







12/12