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