Code College Trophy
2018-05-11 Arnold

Congratulations to the winning team of the week ending on 4 May 2018! The winners team test average were the highest for that week.

At our DEF Learners Bootcamp, we teach coding skills to unemployed Deaf students in partnership with the DEF (Deaf empowerment firm) and Ericsson . They are currently finishing off the Intro To Programming Course in JavaScript. After this course they will continue into professional Web Development, WordPress and SQL training .

Coding Winners

Coding Winners

2017-02-21 admin

Prerequisites

None

Intended Audience

    • This Beginning SQL Querying training course is for anyone who wants to get into the world of Database Developers / Administrators or Business Intelligence.
    • Some familiarity with spreadsheets, relational databases and basic SQL might be helpful. Some coding experience might be helpful.
    • This is also the first course in the MCSA track.

After this course you should

    • Know 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

Alignment

This course is generally presented in MySQL, and also covers MS SQL ‘s MTA Certification. We guide and support you on the preparation of MTA exam. (MTA Exam not included in course price)

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
  • Comptency Assesment Project
 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 )
  • Part-time over 4 weeks (2 nights per week, 3 hour sessions) (R10995 )
  • Part-time over 8 Saturdays, 3 hour sessions (R10995 )
  • Distance-learning over up to 3 months (R8995)
  • Prices exclude Vat for Vat-registered companies
  • Monthly payment options for Distance Learning / Self Study
    If you want to pay the course on a monthly basis, we divide the course in 4 sections – one per month. You then have to complete a quarter of the course per month. The payments are as follows:

    1. R3000 registration fee and covering the first month and section 1
    2. R3000 start of month 2
    3. R3000 start of month 3 (final month)

Certificate

  • Upon completion of this course you will be issue with an attendance certificate to certify your attendance and / or completion of the prescribed minimum examples.
  • Also included is our competency assessment, in which you may achieve our Beginning SQL Competency Certificate, highly recognised and regarded by our clients (IT Industry employers). External students that did not attend the course, may write this assessment at a cost of R2950 (including course material).

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

Schedule for Johannesburg

On the calendar 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.

2016-05-23 admin

Prerequisites

Matric

Intended Audience

    • This SQL querying beginner training 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. This is also the first course in the MCSA track.

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

Alignment

This course is generally presented in MySQL, and also covers MS SQL ‘s MTA Certification. We guide and support you on the preparation of MTA exam. (MTA Exam not included in course price)

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 )
  • Part-time over 4 weeks (2 nights per week, 3 hour sessions) (R10995 )
  • Part-time over 8 Saturdays, 3 hour sessions (R10995 )
  • Distance-learning over up to 3 months (R7995)
  • Prices exclude Vat for Vat-registered companies

Certificate

  • Upon completion of this course you will be issue with an attendance certificate to certify your attendance and / or completion of the prescribed minimum examples.
  • Also included is our competency assessment, in which you may achieve our Beginning SQL Competency Certificate, highly recognised and regarded by our clients (IT Industry employers). External students that did not attend the course, may write this assessment at a cost of R950.

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

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

On the calender on this page below. Look for MTA+Beg-SQL-Jhb or MTA-Beg-SQL-CT
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.

2016-03-09 admin

Prerequisites

Matric

Intended Audience

    • This SQL querying beginner training 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. This is also the first course in the MCSA track.

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 )
  • Part-time over 4 weeks (2 nights per week, 3 hour sessions) (R10995 )
  • Part-time over 8 Saturdays, 3 hour sessions (R10995 )
  • Distance-learning over up to 3 months (R7995)
  • Prices exclude Vat for Vat-registered companies

Certificate

  • Upon completion of this course you will be issue with an attendance certificate to certify your attendance and / or completion of the prescribed minimum examples.
  • Competency assessment is included.
  • External students that did not attend the course, may write the assessment at a cost of R950.

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

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

On the calender on this page below. Look for MTA+Beg-SQL-Jhb or MTA-Beg-SQL-CT
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.

2015-02-18 Alta

 

Prerequisites

This is not a beginner course – you should be at the level of at least SQL Querying Beginner .

Intended Audience

This course is intended for T-SQL developers, DBAs, BI practitioners, report writers, analysts, architects, and SQL Server power users who need to write more advanced queries and develop code using Transact-SQL.

After this course you should

  • Be able to work with programming practices unique to T-SQL
  • Create database tables and define data integrity
  • Query multiple tables using joins and subqueries
  • Simplify code and improve maintainability with table expressions
  • Implement insert, update, delete and merge data modification strategies
  • Tackle advanced techniques such as window functions, pivoting and grouping sets
  • Control data consistency using isolation levels and mitigate deadlocks and blocking
  • Take T-SQL to the next level with programmable objects
  • Be ready to prepare for Microsoft Exam 70-461

Further Training

Consider doing our BI or DBA courses

Course Material

Course Material, normally a leading recommend book is included.

Course Contents

 
 
 
 
Day 1:
Background to T-SQL Querying
  • Theoretical Background
  • SQL
  • Set Theory
  • Predicate Logic
  • The Relational Model
  • The Data Life Cycle
  • SQL Server Architecture
  • The ABC Flavors of SQL Server
  • SQL Server Instances
  • Databases
  • Schemas and Objects
  • Creating Tables and Defining Data Integrity
  • Creating Tables
  • Defining Data Integrity
Single-Table Queries
  • Elements of the SELECT Statement
  • The FROM Clause
  • The WHERE Clause
  • The GROUP BY Clause
  • The HAVING Clause
  • The SELECT Clause
  • The ORDER BY Clause
  • The TOP and OFFSET-FETCH Filters
  • A Quick Look at Window Functions
  • Predicates and Operators
  • CASE Expressions
  • NULL Marks
  • All-at-Once Operations
  • Working with Character Data
  • Data Types
  • Collation
  • Operators and Functions
  • The LIKE Predicate
  • Working with Date and Time Data
  • Date and Time Data Types
  • Literals
  • Working with Date and Time Separately
  • Filtering Date Ranges
  • Date and Time Functions
  • Querying Metadata
  • Catalog Views
  • Information Schema Views
  • System Stored Procedures and Functions
Day 2:
Joins
  • Cross Joins
  • ANSI SQL-92 Syntax
  • ANSI SQL-89 Syntax
  • Self Cross Joins
  • Producing Tables of Numbers
  • Inner Joins
  • ANSI SQL-92 Syntax
  • ANSI SQL-89 Syntax
  • Inner Join Safety
  • More Join Examples
  • Composite Joins
  • Non-Equi Joins
  • Multi-Join Queries
  • Outer Joins
  • Fundamentals of Outer Joins
  • Beyond the Fundamentals of Outer Joins
Subqueries
  • Self-Contained Subqueries
  • Self-Contained Scalar Subquery Examples
  • Self-Contained Multivalued Subquery Examples
  • Correlated Subqueries
  • The EXISTS Predicate
  • Beyond the Fundamentals of Subqueries
  • Returning Previous or Next Values
  • Using Running Aggregates
  • Dealing with Misbehaving Subqueries
Day 3:

Table Expressions
  • Derived Tables
  • Assigning Column Aliases
  • Using Arguments
  • Nesting
  • Multiple References
  • Common Table Expressions
  • Assigning Column Aliases in CTEs
  • Using Arguments in CTEs
  • Defining Multiple CTEs
  • Multiple References in CTEs
  • Recursive CTEs
  • Views
  • Views and the ORDER BY Clause
  • View Options
  • Inline Table-Valued Functions
  • The APPLY Operator
Set Operators
  • The UNION Operator
  • The UNION ALL Multiset Operator
  • The UNION Distinct Set Operator
  • The INTERSECT Operator
  • The INTERSECT Distinct Set Operator
  • The INTERSECT ALL Multiset Operator
  • The EXCEPT Operator
  • The EXCEPT Distinct Set Operator
  • The EXCEPT ALL Multiset Operator
  • Precedence
  • Circumventing Unsupported Logical Phases
Day 4:
Beyond the Fundamentals of Querying
  • Window Functions
  • Ranking Window Functions
  • Offset Window Functions
  • Aggregate Window Functions
  • Pivoting Data
  • Pivoting with Standard SQL
  • Pivoting with the Native T-SQL PIVOT Operator
  • Unpivoting Data
  • Unpivoting with Standard SQL
  • Unpivoting with the Native T-SQL UNPIVOT Operator
  • Grouping Sets
  • The GROUPING SETS Subclause
  • The CUBE Subclause
  • The ROLLUP Subclause
  • The GROUPING and GROUPING_ID Functions
Data Modification
  • Inserting Data
  • The INSERT VALUES Statement
  • The INSERT SELECT Statement
  • The INSERT EXEC Statement
  • The SELECT INTO Statement
  • The BULK INSERT Statement
  • The Identity Property and the Sequence Object
  • Deleting Data
  • The DELETE Statement
  • The TRUNCATE Statement
  • DELETE Based on a Join
  • Updating Data
  • The UPDATE Statement
  • UPDATE Based on a Join
  • Assignment UPDATE
  • Merging Data
  • Modifying Data Through Table Expressions
  • Modifications with TOP and OFFSET-FETCH
  • The OUTPUT Clause
Day 5:
Transactions and Concurrency
  • Transactions
  • Locks and Blocking
  • Locks
  • Troubleshooting Blocking
  • Isolation Levels
  • The READ UNCOMMITTED Isolation Level
  • The READ COMMITTED Isolation Level
  • The REPEATABLE READ Isolation Level
  • The SERIALIZABLE Isolation Level
  • Isolation Levels Based on Row Versioning
  • Summary of Isolation Levels
  • Deadlocks
Programmable Objects
  • Variables
  • Batches
  • A Batch As a Unit of Parsing
  • Batches and Variables
  • Statements That Cannot Be Combined in the Same     Batch
  • A Batch As a Unit of Resolution
  • The GO n Option
  • Flow Elements
  • The IF . . . ELSE Flow Element
  • The WHILE Flow Element
  • An Example of Using IF and WHILE
  • Cursors
  • Temporary Tables
  • Local Temporary Tables
  • Global Temporary Tables
  • Table Variables
  • Table Types
  • Dynamic SQL
  • The EXEC Command
  • The sp_executesql Stored Procedure
  • Using PIVOT with Dynamic SQL
  • Routines
  • User-Defined Functions
  • Stored Procedures
  • Triggers
  • Error Handling

Duration and pricing

  • Full-time over 5 days (R8995 excl VAT incl MS Exam)
  • Part-time over 4 weeks (2 nights per week, 3 hour sessions) (R10995 excl Vat)

Duration and pricing

  • Full-time over 5 days (R8995 excl VAT incl MS Exam)
  • 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)

Certificate

1. Upon completion of this course we will issue you with attendance certificate to certify your attendance and / or completion of the prescribed minimum examples.
2. You have the option to get the competency / academic certificate if you :
hand in a project (pre-approved) covering most of the topics in the book.

Schedule

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