Centre for Continuing Education

SQL Course: Level 1

SQL. Work smarter, not harder.

Learn SQL the smart way with SQL training courses at CCE, the University of Sydney.

This SQL course is provided for people with minimum understanding of relational databases (Microsoft Access, Oracle Database, Microsoft SQL Server, MySQL etc) who want to get more value from SQL Course Level 2a training or who just want to demystify relational database management systems.

There is a trend developing in business for non IT people to understand and use SQL (structured query language) to query relational database management systems. For many years CCE has offered several courses that teach SQL. The content and pace of these SQL courses were tuned to the historical participants, principally IT professionals, who came into the course with a particular skill level understandably not present in most business people.

Business people new to databases (how they actually work and why they are designed in particular ways) need to grasp some basic database concepts before tackling the intricacies of SQL.

If you are a business person, or IT professional, who is not completely comfortable with relational database concepts, then you should complete this course before attempting SQL Course Level 2 training.

The principles taught are common to all relational database management systems. For the purposes of this SQL training course, Microsoft SQL Server and Microsoft SQL Server Management Studio will be used to illustrate the content of the course.

Outcomes

Upon successful completion of this course, participants should be able to:

  1. Recognise elements of good and bad database design relevant to SQL and apply those elements when designing a database.
  2. Interpret database structures to determine the SQL required to reslove queries.
  3. Choose appropriate clauses to write an SQL query.
  4. Write SQL queries to answer specific questions.
  5. Read SQL queries to determine the result sets produced.

Content

This SQL training course covers the following topics:

  • Rationalise the purpose of Relational Database Management Systems and their role in information systems.
  • Interpret the narratives that define business rules that form the basis of a databases design.
  • Simplify business rules to enable database design and the interpretation of database design when answering questions with SQL.
  • Resolve the metaphor used in relational database management systems and thus SQL.
  • Discuss the principles of a normalised database that store facts in a single place and the method used to relate facts.
  • Name and discover the natural cardinalities in a given business narrative.
  • The create n ERD (Entity Relationship Diagram) for the design of a database using its symbols and their meaning that express those cardinalities to capture business rules using primary keys and foreign keys, constraints and datatypes to enforce cardinalities.
  • Implement a database design in SQL from an ERD creating tables, columns and relationships.

Use Structured Query Language (SQL) to:

  • Build a result set from one table.
  • Alias columns in the result set.
  • Derive columns in the result set with arithmetic, intrinsic functions and concatenation.
  • Cull records from a result set with WHERE clause boolean predicates.
  • Involve multiple boolean predicates in the WHERE clause with the logical operators AND and OR using their operator precedence and brackets.
  • Sort result sets with the ORDER BY clause and nested sort orders.
  • State the purpose of statements and clauses, specifically a SELECT statement, SELECT clause, FROM clause, WHERE clause and ORDER BY clause.
  • Read a statement using the SQL elements above stating what each clause consumes and produces, and the order in which the clauses execute.

Intended Audience

This SQL Level 1 course is suitable for participants who have little to no prior understanding of relational database management.

Delivery Style

This SQL Level 1 course is delivered as presenter-taught computer-based training.

Features

  • Free repeat class - Conditions apply
  • Free USB flash drive
  • Expert trainer
  • Dedicated computer for every student
  • Small class size
  • Student notes – yours to keep
  • Statement of completion

What others say.

  • The instructor is excellent, professional, and an expert in SQL. I strongly recommend this course for anyone who is looking for data and technology courses.

  • An outstanding tutor, very knowledgeable and with an excellent teaching manner. A credit to your organisation.

  • An absolutely brilliant tutor – I have taken a great deal away from the course and have been able to demonstrate many of the functions of SQL since returning to work. Would highly recommend this course to other students.

  • The tutor did well with keeping attendees focused and has a great style for explaining key concepts very quickly. I should have done this course many years ago.

  • Excellent tutor, a real expert in the field. Anyone who can explain complex theory in a simple understandable way is a true teacher and expert.

  • The tutor was very perceptive to the types of students in the class and was considerate to their learning needs according to the students experience or lack of experience.

  • The tutor was absolutely incredible and was able to simplify the material and kept the class engaged at all times.

  • I’d urge anyone, even those who are self-taught to attend. I had already been exposed to a lot of the content but the gaps in my knowledge that were filled made it very worthwhile.

  • Our tutor was brilliant. I’m keen to attend more courses as they made really difficult content totally accessible and made me feel confident I could master it. They gave interesting examples, kept the day flowing well and kept a large group on track. I was really impressed.

  • It was perfect! I am really happy I registered for this course and learnt so much in a day. Can’t wait for the next course! An excellent tutor. They explained everything so simply.

  • This tutor is a dedicated lecturer who is keen to assist the learner to understand the concepts. He teaches through example, referring the learning to industry based examples and step by step processes. He is a positive find for your organisation.

  • The SQL course was a very good experience. Excellent tutor who made it easy to follow and understand as an non IT person. I will be back for the next level SQL course soon.

  • An amazing tutor who has an amazing ability to simplify things that originally appear as extremely complex – also does a great job at keeping the session light-hearted and interesting to keep everyone focused.

  • This course gave me the tools to critically engage with relational databases.

  • An excellent teacher and I was extremely happy with the delivery of the course and subject matter. Keen to continue further with learning more on this subject.

  • Loved the course! The tutor was fantastic and managed to break down a (seemingly) difficult subject into very understandable bits. I was very surprised at their demystification of the whole subject. Very happy with it!

  • I was very impressed with the tutor – he was able to keep it simple and provide a very good grounding. I had no knowledge of SQL beforehand and I left very interested in acquiring more.

  • An excellent course, nice refreshments, great equipment and an excellent tutor. Flew up from Melbourne and was very satisfied.

  • Refreshing to be taught by a tutor with a deep understanding of the topic and a commitment to demystify IT generally and SQL specifically.

  • From no idea to creating a database in a day! Great introduction to SQL.

  • Perfect course for a beginners as it helped to fill the knowledge gaps to prepare me for the next level.

$358 Limited GST free
SQL Course: Level 1

<p>{block name:“Course Tagline - SQL”}</p><p>This SQL course is provided for people with minimum understanding of relational databases (<a target="_blank" href="https://products.office.com/en-us/

...
$376 Limited GST free
SQL Course: Level 1

<p>{block name:“Course Tagline - SQL”}</p><p>This SQL course is provided for people with minimum understanding of relational databases (<a target="_blank" href="https://products.office.com/en-us/

...
$376 Limited GST free
SQL Course: Level 1

<p>{block name:“Course Tagline - SQL”}</p><p>This SQL course is provided for people with minimum understanding of relational databases (<a target="_blank" href="https://products.office.com/en-us/

...
$376 Limited GST free
SQL Course: Level 1

<p>{block name:“Course Tagline - SQL”}</p><p>This SQL course is provided for people with minimum understanding of relational databases (<a target="_blank" href="https://products.office.com/en-us/

...
$376 Limited GST free
SQL Course: Level 1

<p>{block name:“Course Tagline - SQL”}</p><p>This SQL course is provided for people with minimum understanding of relational databases (<a target="_blank" href="https://products.office.com/en-us/

...
$376 Limited GST free
SQL Course: Level 1

<p>{block name:“Course Tagline - SQL”}</p><p>This SQL course is provided for people with minimum understanding of relational databases (<a target="_blank" href="https://products.office.com/en-us/

...
$376 Limited GST free
SQL Course: Level 1

<p>{block name:“Course Tagline - SQL”}</p><p>This SQL course is provided for people with minimum understanding of relational databases (<a target="_blank" href="https://products.office.com/en-us/

...
$376 Limited GST free
SQL Course: Level 1

<p>{block name:“Course Tagline - SQL”}</p><p>This SQL course is provided for people with minimum understanding of relational databases (<a target="_blank" href="https://products.office.com/en-us/

...
$376 Limited GST free
SQL Course: Level 1

<p>{block name:“Course Tagline - SQL”}</p><p>This SQL course is provided for people with minimum understanding of relational databases (<a target="_blank" href="https://products.office.com/en-us/

...
$376 Limited GST free
SQL Course: Level 1

<p>{block name:“Course Tagline - SQL”}</p><p>This SQL course is provided for people with minimum understanding of relational databases (<a target="_blank" href="https://products.office.com/en-us/

...
$376 Limited GST free
SQL Course: Level 1

<p>{block name:“Course Tagline - SQL”}</p><p>This SQL course is provided for people with minimum understanding of relational databases (<a target="_blank" href="https://products.office.com/en-us/

...
$376 Limited GST free
SQL Course: Level 1

<p>{block name:“Course Tagline - SQL”}</p><p>This SQL course is provided for people with minimum understanding of relational databases (<a target="_blank" href="https://products.office.com/en-us/

...
If there isn't a class to suit you, please join the waiting list.