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 am writing to thank all of the hardworking individuals at Global IT. Without your support, it would not have been possible for me to make such a smooth career transition. After being laid off from the tool making industry, I had the opportunity to enroll in the program at GIT. With a family to [...] Read more
Stewart Sykes
I cannot begin to tell you how fortunate I am to have found Global Information Technology (GIT). I had been laid off in the spring and was looking for a new job. The Web Program sparked my interest. I have degrees in Advertising and Graphic Design but learning to design web sites was something I [...] Read more
Jennifer Dudek
I got married young, had two amazing boys. At age 31 I found myself at a low paying job as an Office Assistant that wasn’t challenging me at all. So I visited Global IT and met with the Director. After looking at my background and doing a personal assessment, he suggested I become a Business [...] Read more
Shazia Rashid
Global Information Technology: To whom it may concern: I was looking around for a training institution that offered Oracle 10g DBA program. I found only one school that offered this program at the best price and the right fit for me. The school name is Global Information Technology (Global I.T.). I still remember that moment [...] Read more
Vijaykumar Patel
I was a veteran who wanted to start a second career in IT. I had a bad experience with another computer training company, which actually had me about ready to quit, I was introduced to Global Information Technology by my VA counselor and the rest is ALL GOOD!  Global IT has been proactive on my [...] Read more
Brian Gibson