SQL Online Training Bundle

SQL Online Training Bundle

42 STUDENTS ENROLLED

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

Course Reviews

4.7

4.7
8 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE

COPYRIGHT © 2018 One Education