You will learn to:
Databases drive nearly every Internet and Intranet Web site. Global IT’s Introduction to SQL and Database Design class teaches you how to master their power through a thorough grounding in SQL and sound database design fundamentals.
This course is designed for people with no relational database experience. The database that we use for the class is MySQL, an open source product that is gaining in popularity in the industry and SQL Server. However, the concepts are basic enough that they transfer easily to any standard database product that abides by the ANSI standards.
SQL (Structured Query Language) is used to retrieve, edit, remove and add data in relational databases. SQL programmers define and create relational database structures including tables, views etc.Good SQL skills are always in demand and are useful in a number of careers including database developers, report writers, business analysts, computer programmers, web developers, testers, data analysts, etc. Because an increasing number of companies are storing and analyzing an ever increasing amount of corporate data, the demand for SQL or database skills will continue to increase.
SQL has a shorter learning curve when compared to other skills like business analysis or computer programming or testing. Part of the reason is that SQL is a well-defined, standardized language that has been around for a number of years.
Database Basics
Database Design Fundamentals
Creating Tables
Single Table Queries
Multiple-Table Queries
Updating Data
Database Administration
SQL Functions and Procedures
Embed SQL commands in PL/SQL and T-SQL procedures
Real testimonials from our Students!
I wish to express my thanks and gratitude for your expert teaching and support that have helped me transition into a career in information technology. When I began taking classes in August of 2009, I had been unemployed for over a year, and job prospects in the insurance industry were slim. Your staff took the [...] Read more
Marcus Thompson
I was an out of work Engineering Technologist from ford motor. With a strong background in Electrical, Electronics and Mechanical. But no jobs. In this bad economy I was quite depressed and decided to do something about it. When your school was recommended I decided to go there and take a look. I liked what [...] Read more
Heather Berry
Manish – I am writing to say thank you. I thank God for Global Information Technology. I thank God for you, because you genuinely care about the direction of the student. I thank God for believing in me, for coaching me, and for helping me. I thank God for everyone at Global Information Technology for [...] Read more
Samar Gorial
After being laid-off and getting frustrated looking for work in the current market with outdated AS/400 and Mainframe skills, I decided to visit a few training providers to investigate some tech training to upgrade my skills set. The third one I visited was Global Information Technology. My first impression was very positive. The representative’s passionate [...] Read more
David Hamel
Dear Manish: I wanted to also take this opportunity to thank you, and the Staff at Global IT. You and your staff all really changed my life. I know you all know my story and where I came from and where I am now. If it were not for how you conduct classes, and the [...] Read more
Bradley Freeland