SQL Training Course
Who will benefit
- School leavers intending to do one of our Coding Bootcamps.
- Anyone that wants to start learning to code the right way.
- This course is a requirement for entry into our Coding Bootcamps
Duration
- 5 Full Days or 40 hours part time
Price
What do I need?
- Live Online Training : A laptop, and a stable internet connection. The recommended minimum speed is around 10 Mbps.
- Classroom Training : A laptop, please notify us if you are not brining your own laptop. Please see the calendar below for the schedule
Outcomes
- Know the Fundamentals of HTML, CSS, JavaScript and how they work together to build apps.
- Know how to debug JavaScript programs in the browser.
- Know how to use data structures, control flow to build 5-10 useful small apps combining HTML, CSS and JavaScript.
- Have enough JavaScript knowledge to pass a recognised international JavaScript Quiz.
- Build an HTML Web Site showing off your portfolio of projects and host it online.
Certification
- Attendance : If you have attended 80% of the sessions and completed all the class work, you qualify for the Attendance Certificate.
- Competency : If you have also completed all the practical projects as described the Outcomes section, you qualify for the Competency Certificate.
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 2:
DELETE and UPDATE –
a change will do you good
Smart table design –
why be normal?
Atomic data mary KeyPri ALTER –
Rewriting the past
Renaming the table
DROP column
UPDATE, SET
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 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
Day 5:
Constraints, Views and Transactions
CHECK CONSTRAINT
with views
Creating a view
Inserting, updating and deleting
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
Avoid disappointment
Book Now!