Beginning SQL (inc MTA) 16-20 March 2015

2015-02-28 Alta

Prerequisites

Matric

Intended Audience

    • This course is for database developers and administrators at beginner level.
    • Some familiarity with relational databases and basic SQL might be helpful.
    • Some programming experience might be helpful.

After this course you should

    • Know basic SQL syntax
    • Know SQL database design concepts
    • Know Advanced querying
    • Know how to do hard core database manipulation with Subqueries, Joins and Transactions
    • Understand effective and efficient database design and creation
    • Be able to query, normalize and join data
    • Be ready to prepare for the MTA DBA Fundamentals Exam 98-364

Further Training

Course Material

    • Course material included.

Course Contents

 Day 1:

  • Data and Tables – a place for everything
  • Data in categories
  • What’s in a Database
  • CREATE TABLE Statement
  • Data types
  • DESCribed
  • INSERT Statement
  • NULL, NOT NULL
  • DEFAULT
  • The SELECT Statement – gifted data retrieval
  • How to query data types
  • Comparison Operators
  • AND, OR, LIKE, BETWEEN, IN, NOT IN

Day 3:

  • Advanced SELECT – Seeing your data with new eyes
  • CASE expression
  • ORDER BY
  • SUM, MIN, MAX, AVG, GROUP BY
  • COUNT, LIMIT
  • Multi-table Database Design – Outgrowing your table
  • Schema
  • How to go from one table to two
  • Create a table with a Foreign Key
  • Relationships between tables
  • Patterns of data
  • Junction table
  • 1NF
  • Partial functional dependency
  • Transitive functional dependency
  • 2NF
  • 3NF

Day 5:

  • Constraints, Views and Transactions
  • CHECK CONSTRAINT
  • Creating a view
  • Inserting, updating and deleting with views
  • View with CHECK OPTION
  • Transactions
  • The ACID Test
  • Security – protecting your assets
  • GRANT statement
  • GRANT variations
  • REVOKE privileges
  • REVOKING a used GRANT OPTION
  • MTA-Exam 98-364 Review Prep
  Day 2:

  • DELETE and UPDATE – a change will do you good
  • Smart table design – why be normal?
  • Atomic data
  • Primary Key
  • ALTER – Rewriting the past
  • Renaming the table
  • DROP column
  • UPDATE, SET


Day 4:

  • JOINS and multi table operations
  • CREATE, SELECT, INSERT at the same time
  • AS, column aliases
  • Inner JOINS
  • Subqueries – Queries within queries
  • Natural Join
  • Noncorrelated subqueries
  • Correlated subqueries
  • EXISTS and NOT EXISTS
  • OUTER JOINS, SELF JOINS and UNIONS
  • Left and right outer join
  • A self-referencing foreign key
  • INTERSECT and EXCEPT
  • Turning a subquery into a join

Duration and pricing

  • Full-time over 5 days (R8995 excl VAT)
  • Part-time over 4 weeks (2 nights per week, 3 hour sessions) (R10995 excl Vat)
  • Part-time over 8 Saturdays, 3 hour sessions (R10995 excl Vat)
  • Distance-learning over up to 3 months (R7995 excl Vat)
  • Excluding MTA MS exam, including SQL assessment for competency certificate .

Certificate

  • Upon completion of this course we will issue you with attendance certificate to certify your attendance and / or completion of the prescribed minimum examples.
  • You will also  get the competency  certificate if you pass the Beginning SQL assessment on the last day of the course
  • External students that did not attend the course, may write the assessment at a cost of R950.

Schedule for Johannesburg (Jhb) and Cape Town (CT)

On the calender on this page below.
If your browser doesn’t display the calendar below, please click on this link or try using Google Chrome, alternatively please enquire via our ‘Contact Us’ page.

Bookings

You can download the course registration form on our home page or by clicking here

Brochure

You may download a pdf copy of this page by clicking here.

Questions

Please email us

Beginning SQL (20 – 24 Jan 2014)

2014-01-15 Lizel GetCertified

HOT Course ! : The Beginning SQL course is a comprehensive introduction to SQL, intended for complete beginners. A ‘must do’ course for almost everyone in IT who is starting out with SQL querying. Not linked to any vendor like Microsoft / Oracle or MySQL – this course is universal across all.

For more info click here

 

10774A: Querying Microsoft SQL Server 2012 (5 Days)

2013-10-27 getcertarn

This 5-day instructor led course on 4-11 November 2013, provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps you prepare for exam 70-461. This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.

After completing this course, students will be able to:

  • Write SELECT queries
  • Query multiple tables
  • Use built-in functions
  • Use subqueries
  • Execute stored procedures
  • Use set operators
  • Implement error handling
  • Implement transactions
  • Use table expressions
  • Sort and filter data
  • Use window ranking, offset and aggregate functions
  • Query SQL Server metadata
  • Program with T-SQL
  • Improve query performance

Click here for more info

Will I get a job after doing only Beginning SQL?

2012-12-10 getcertarn

It depends on your other skills. We have had a lady once who had a BComm. Hons Degree in pure economics as well as a couple of years working experience in the financial industry. She was retrenched and could not find a job for longer than 6-9 months – employers told her that she lacked IT skills. She did our Beginnig SQL course only and then she got 3 job offers.

The bottom line is that this course can get you a job, yes, but you also have to look at your other skills. If you do not have a lot of other skills to offer, then I would suggest you need to study further, like doing the advanced SQL course as well and then sit for the international exam in Microsoft SQL (T-SQL). Alternatively go into a software development direction like PHP or .NET or Java.