SQL Fundamentals

Gain a solid working knowledge of the most powerful and widely used database programming language.
Picture of SQL Fundamentals
NZD$285.14 RRP $528.94

Quick Facts

  • Delivery Method Online
  • Professional Certificate
  • 24hrs Suggested Study Time
  • 8 Weeks Access
  • Tutor Support
  • Mobile and Tablet Friendly
  • 26703 Students

What's it all about?

Learn the key concepts of Structured Query Language (SQL), and gain a solid working knowledge of this powerful and universal database programming language.

In this course, you'll learn about the basic structure of relational databases and how to read and write simple and complex SQL statements and advanced data manipulation techniques. First, you'll learn about the traditional database structure, the structure and history of the relational database, and what structured query language (SQL) is and how it relates to the relational-database structure.

Next, you'll discover how to use SQL to sort and retrieve data from tables and how to use SQL to filter retrieved data. You'll learn how to reformat retrieved data with calculated fields and how to merge columns and create alternate names for columns.You'll also learn how to gather significant statistics from data using aggregate functions, and you'll see how to extract data from multiple tables simultaneously using joins and subqueries. In addition, you'll learn how to manipulate data using the INSERT, UPDATE, and DELETE statements.

We'll also cover how to use SQL to create and maintain tables, and you'll learn how to create and use views to simplify complex queries, summarise data, and manipulate data stored in tables. You'll discover how transaction processing, constraints, and indexes are implemented in SQL. And finally, you'll discover how stored procedures, triggers, and cursors are implemented in SQL.

By the end of this course, you'll have a solid working knowledge of structured query language. You'll feel confident in your ability to write SQL queries to create tables; retrieve data from single or multiple tables; delete, insert, and update data in a database; and gather significant statistics from data stored in a database.

 

Courses are delivered to you through expertly executed lessons, online instruction and interaction with like-minded students. Our courses are designed to deliver all of the benefits of studying in a classroom whilst giving you the flexibility to study at a time and place to suit your needs. You can access your classroom 24/7 from any device with an internet connection.

New sessions of each course start monthly and last for six weeks. You’ll gain access to two lessons a week (for a total of 12 lessons) helping you pace your learning. There are no set times for you to study, you can log in and out at any time and complete the course at your own pace. Your expert tutor will guide and facilitate your course, answering any questions you have and providing guidance and feedback. You’ll complete comprehensive lessons, quizzes and assignments before submitting your final exam at the end of the course to achieve your certificate.

Session start dates are listed below. Has the start date already passed? Don’t worry, you can join a class up to 2 weeks after the start date!

Start Dates:

  • 14 June
  • 12 July
  • 16 August
  • 13 September

Who's the instructor?

Cecelia Allison

Cecelia Allison is an experienced software tester and technicalspecialist with more than 15years of hands-on experience using and teaching SQL. She is also a technical writer, a published author, and a university instructor. Sheholds a Bachelor of... Read more

Read Cecelia Allison's Profile

What's involved?

  • Lesson 1- Database Basics, and Structured Query Language
  • Lesson 2- Sorting and Retrieving Data
  • Lesson 3- Filtering Data
  • Lesson 4- Calculated Fields and Functions
  • Lesson 5- Summarizing and Grouping Data
  • Lesson 6- Working with Subqueries
  • Lesson 7- Creating and Using Table Joins
  • Lesson 8- Inserting, Updating, and Deleting Data
  • Lesson 9- Table Creation and Maintenance
  • Lesson 10- Creating and Understanding Views
  • Lesson 11- Understanding Transaction Processing, Constraints, and Indexes
  • Lesson 12- Understanding Stored Procedures, Triggers, and Cursors

What do others think?

‘Cecelia did a fine job in presenting the material and backing it up with examples. The assignments and questions on the quizzes were also appropriate. Enjoyed it!’

Show more reviews

The Learning Environment

From the moment that you enrol in SQL Fundamentals you will become an integral part of our learning community. You will experience the perks of classroom studies such as chatting by the water cooler or sharing your opinion on a specific task, all in your own home.

Tutor support during your learning is flawless, friendly and encouraging. You will learn from your professional tutor who is not only knowledgeable and highly skilled but is a passionate industry expert. Our ethos is that if you succeed, we succeed. As with any studies, learning can be intense, yet you will soon realise that your hard work and commitment will be both personally and professionally rewarding.

Ready to get started?

Enrol Now

Why Choose Vibe Learning?

Learn Your Way

We understand that everyone works at their own pace and no two students are the same. That's why when you study with Vibe Learning we provide you with all the study guidelines, tools and support you need but leave you to set the pace. You are free to complete your assessments when and where you want.

We don't break the bank

With Vibe Learning we believe that education should be accessible to anyone who wants to learn. That's why we offer some of the most competitive prices in the industry. Investing in your future is a smart choice and doesn’t have to break the bank. Whether you choose our money saving upfront prices or flexible payment plans, studying is accessible to you.

You'll get the personal attention you deserve

We are real people, providing real support every step of the way. When you study with Vibe Learning, you'll benefit from learning from professional, knowledgeable and most of all passionate industry experts.

Reap the rewards sooner rather than later

We offer a range of options from short 6 week courses through to extensive 12 month courses. Whatever your personal or professional goals, studying online with Vibe Learning provides a rewarding life changing experience which is well within your reach.

Learn real life skills

We don’t profess to know everything about every industry. That's why, when we write a course we work with industry experts who do know everything! Before delivering a course we make sure that the following boxes have big green ticks in them;

  • The course is industry Current
  • The course is Relevant to our students
  • The course is Engaging and delivers outcomes

Recently viewed products