SQL Online Training Bundle
***3 Courses Bundle | 19 Modules | Free PDF Certificates | 21 CPD points***
SQL Online Training Bundle
Original price was: £425.£49Current price is: £49. ex Vat
Take This Course OR
1 Year Access 
Beginner
61 Students -
20 hours, 51 minutes
Course Overview
Take steps to become a qualified SQL Developer and pass your Oracle SQL 1Z0-071 (OCA) Certification Exam with flying colours, with this SQL online training bundle! Featuring beginner, intermediate and advanced lessons, this course will take you from novice to expert in SQL programming in no time.
You will learn how to read, write and analyse SQL queries, communicate with relational databases, manipulate data, and much more, with our step-by-step training guide. Gain the specialist industry skills needed to create and design databases from scratch, and confidently use SSMS tools for configuring, monitoring and administering.
There are no specific entry requirements for this course, which can be studied in your own time, as your convenience, on a part-time or full-time basis. All of these lessons have been designed in such a way that anyone with no prior knowledge can easily dive into them.
Fast track your career as an SQL Developer and enrol in this complete bundle course today!
Learning Outcomes:
- Learn how to read, write & analyse SQL queries, with our step-by-step training guide
- Fast track your career as a SQL Developer and gain in-demand industry skills
- Go from beginner to expert with this 3-level bundle training course
- Understand how to create and design databases and tables in QSL
- Confidently use SSMS tools for configuring, monitoring and administering
- Be fully prepared for your Oracle SQL 1Z0-071 (OCA) Certification Exam
- Resolve specific SQL-related problems quickly and easily
- Develop an understanding of the basics of SQL statements
Who is This Course for?
This SQL Developer Bundle applies to the following:
- Aspiring professionals looking to gain industry skills and a formal qualification
- Those whose work involves database management and administration
- Anyone who wants a step-by-step guide on how to write SQL queries
- Professionals who work in this field and want to test their existing knowledge
Career Path
This SQL online course will equip you with the skills, qualification and tools to guarantee your career advancement in this field. Related professions that require database management skills include:
- SQL Developer
- Data Analyst
- Database Administrator
- Web Designer
- Hosting Technician
- Software Developer
Course Curriculum
| Beginner Level | |||
| 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 | ||
| Columns and Indexed Views | 00:18:00 | ||
| Module: 02 | |||
| Introduction Stored Procedures | 00:19:00 | ||
| Creating Stored Procedures | 00:20:00 | ||
| Returning Data | 00:14:00 | ||
| Module: 03 | |||
| Testing and Debugging | 00:17:00 | ||
| Execute with Result Sets | 00:11:00 | ||
| Creating Triggers | 00:27:00 | ||
| Module: 04 | |||
| Overview and Scalar Functions | 00:20:00 | ||
| Inline Table Valued Functions | 00:11:00 | ||
| Multi Statement | 00:15: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:28: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 | ||
| Intermediate Level | |||
| Module: 07 | |||
| Topic A Aggregates | 00:27:00 | ||
| Topic B User Defined Types | 00:17:00 | ||
| Topic C Table and Functions | 00:10:00 | ||
| Topic D Managing Code Modules | 00:08:00 | ||
| Module: 08 | |||
| Topic A Introduction Data Tools | 00:19:00 | ||
| Topic B Connected Database Development | 00:20:00 | ||
| Topic C Updating a Connected Database | 00:16:00 | ||
| Module: 09 | |||
| Topic A Creating New Objects with TSQL | 00:12:00 | ||
| Topic B Comparing Database Schemas | 00:10:00 | ||
| Topic C Offline Database Development | 00:13:00 | ||
| Topic D Database Project Settings | 00:18:00 | ||
| Module: 10 | |||
| Topic A Using APPLY99 | 00:15:00 | ||
| Topic B MERGE Statement99 | 00:23:00 | ||
| Topic C Creating Recursive Queries | 00:08:00 | ||
| Topic D Grouping Sets | 00:12:00 | ||
| Module: 11 | |||
| Topic A ROLLUP and CUBE Operators | 00:12:00 | ||
| Topic B Creating Pivot Queries | 00:14:00 | ||
| Topic C Executing Dynamic SQL | 00:28:00 | ||
| Module: 12 | |||
| Topic A Complex Query Execution | 00:26:00 | ||
| Topic B Using Execution Plans | 00:16:00 | ||
| Topic C Execution Plan Operators | 00:12:00 | ||
| Topic D Common Join Operators | 00:15:00 | ||
| Module: 13 | |||
| Topic A Hierarchy ID Data Type | 00:12:00 | ||
| Topic B Exploring a Hierarchy | 00:09:00 | ||
| Topic C Sparse Columns 99 | 00:16:00 | ||
| Topic D Column Sets99 | 00:12:00 | ||
| Module: 14 | |||
| Topic A Filtered Indexes | 00:09:00 | ||
| Topic B FILESTREAM Storage | 00:22:00 | ||
| Topic C Adding Sequences to Queries | 00:22:00 | ||
| Module: 15 | |||
| Topic A Introduction to Spatial Data | 00:13:00 | ||
| Topic B Spatial Data in SQL Server | 00:23:00 | ||
| Topic C Manipulating Spatial Shapes | 00:10:00 | ||
| Topic D Interactions Between Objects | 00:09:00 | ||
| Advanced Level | |||
| Module: 16 | |||
| Topic A Partitioning | 00:20:00 | ||
| Topic B Creating Partition Tables | 00:30:00 | ||
| Topic C Querying Partitions | 00:14:00 | ||
| Topic D Managing Partitions | 00:18:00 | ||
| Module: 17 | |||
| Topic A Complex Querying | 00:22:00 | ||
| Topic B Rankings | 00:15:00 | ||
| Topic C SubQueries | 00:21:00 | ||
| Topic D Common Table Expressions | 00:17:00 | ||
| Module: 18 | |||
| Topic A Complex Data and Structures | 00:26:00 | ||
| Topic B Efficient Queries | 00:36:00 | ||
| Topic C Complex Queries | 00:17:00 | ||
| Module: 19 | |||
| Topic A XML Data Type | 00:28:00 | ||
| Topic B XML Schemas | 00:17:00 | ||
| Topic C Querying XML | 00:20:00 | ||
| Topic D Best Practices | 00:08:00 | ||
| Order Your Certificate | |||
| Order Your Certificate Now | 00:00:00 | ||
Related Courses
Beginner
Intermediate
Important Links
With a team of industry professionals producing and delivering our course content, you can be sure the skills and knowledge you learn are applicable to your career aspirations, whether that’s in management, administration or beyond.
0
0
Your Cart
Your cart is emptyBrowse Courses
Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year
Claim Offer & UpgradeMembership renews after 12 months. You can cancel anytime from your account.
Other Students Also Buy
-
Get Lifetime Access To Your Course£9.99 Add to cart+Add