SQL Programming
Duration: 21 hours
Prerequisites: None.
Students Will Learn:
- Introduction to Relational Databases and SQL
- Designing Relational Databases
- Creating Databases and Tables
- Working with Records
- JOIN Statements
- Advanced SELECT Statements
- Understanding Subqueries
- SQL Procedural Programming
- Views and Triggers
- Database Security and Transactions
Course Description:
This SQL programming course teaches students relational database fundamentals and SQL programming skills. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. This class is intended for analysts, developers, designers, administrators, and managers who need to harness the power of the SQL programming language. Upon completion, participants will understand SQL functions, join techniques, database objects and constraints, and will be able to write advanced SELECT, INSERT, UPDATE and DELETE statements. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.
Course Overview:
Relational Database Fundamentals
|
Writing Basic SQL Queries
|
Creating a Database
|
Manipulating Query Results
|
Advanced Query Techniques
|
Manipulating Table Data Using SQL's Data Manipulation Language (DML)
|
User-Defined Functions
|
Stored Procedures
|
Triggers
|
Working with Table Expressions
|
Related Bootcamps:
Track | Duration | Price |
---|---|---|
SQL Programmer | 1-course track | $1,495 |
Microsoft .NET Developer: C# | 5-course track 6-course track 7-course track 8-course track 9-course track 10-course track |
$6,000 $7,200 $8,400 $9,600 $10,800 $12,000 |
Microsoft .NET Developer: VB.NET | 5-course track 6-course track 7-course track 8-course track 9-course track |
$6,000 $7,200 $8,400 $9,600 $10,800 |
Java Programmer | 2-course track 3-course track 4-course track 5-course track |
$2,400 $3,600 $4,800 $6,000 |
Advanced Java Developer | 4-course track 5-course track 6-course track 7-course track 8-course track |
$4,800 $6,000 $7,200 $8,400 $9,600 |
C/C++ Programmer | 2-course track 3-course track 4-course track |
$2,400 $3,600 $4,800 |