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!
Global IT Changed My Life I remember the day I attended Global Information Technology. I met with the administrator who gave a lot of good information. My name is Larry Todd Sr. and I like to tell you about Global IT. Global IT really changed my life. If you are serious about starting a career, [...] Read more
Larry Todd
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
As a United States Army veteran, I participated in four (4) combat tours and a tour of duty to South Korea. I am a three (3) time veteran of Iraq, serving in various capacities in Operation Iraqi Freedom (OIF) I, III and Operation New Dawn (OND) which ended the war in Iraq in December 2011. [...] Read more
Christopher B. Amara, Jr.
US Army Veteran
7/10/2018 I enjoyed working for Global Information Technology on project as well as at the class. The management is very helpful and approachable when needed. I got very good opportunity to learn new tools and technologies and also to implement them. They provide very good support for their students in determining their areas of interest, [...] Read more
Megha Kashinkunti
I started training at Global I.T. in January of 2002 with the Web Pro course, then after successfully completing that course, I elected to take the Java Pro. I liked my instructors because they were always willing to help before and after class, as well as by appointment. The material was good because it explained [...] Read more
Lisa Majewski