SQL Boot Camp is the hands-on, beginner to advanced level online training for database and SQL professionals.

You are shown, taught and instructed on how to write best-practice SQL code in an instructor-led, convenient and interactive web-based SQL course.

You gain mastery of SQL query writing, database design or database development from sql instructors using multiple videos, quizzes and hands-on database projects.

Why Learn SQL Online?

SQL is one of the most useful skills to employers because organizations everywhere need to save, modify or access data from relational database applications!

Learning SQL helps you access, query or maintain the information stored in databases, by yourself, without relying on someone else.

Strong relational database skills is useful for designing or developing high-performance transactional or analytical databases and applications.

Who Should Attend?

This course is valuable for anyone who researches in, queries, enhances, supports, designs or develops databases.

This including Database Administrators, Report Writers, Data Analysts, Database Developers, Business Analysts, Software Developers, Web Developers, Project Managers, Managers and anyone else that works with relational databases.

By The End Of This Course You Will be Able To

Support, enhance, design and develop complex queries or databases that will be used by data analysis or software developers.

Design high-performance relational databases based on a sound understanding of normalization and relational database theory.

Write efficient, optimized SQL queries or stored procedures utilizing joins, transactions, error handling.

Hands-on Relational Database + SQL Query Writing Skills In:

1. Modeling Relational Databases
2. Normalizing Tables to First, Second, Third Normal Form
3. Enforcing Referential Integrity
4. Choosing Primary, Foreign, Unique, Candidate, Surrogate, Artificial and Composite Keys
5. One-to-One, One-to-Many, Many-to-Many relationships
6. Writing Simple SQL Queries
7. Joining Multiple Tables using Inner, Outer, Cross or Outer Joins
8. Retrieving Data from Tables using SQL
9. Adding, Removing rows or Changing Data with INSERT, UPDATE or DELETE SQL Statements
10. Building simple and complex SQL Stored Procedures or Triggers
11. Building Subqueries, Views, Functions, Indexes, Constraints

Detailed Course Outline / Training Curriculum

COURSE 1: DATABASE DESIGN

MODULE 1: RELATIONAL DATA MODEL

1. What is the Relational Data Model?
2. Relational database systems
3. How to choose a relational database system
4. Logical database design process
5. Physical database design process
6. Identifying Entities, Attributes and Domains
7. Identifying keys
8. Primary keys, Foreign keys
9. Simple Keys, Composite keys
10. Candidate keys, Alternate keys
11. Natural keys, Surrogate keys
12. Choosing Globally Unique Identifiers (GUIDs)
13. Choosing Identity / Auto-numbering fields

MODULE 2: ENTITY RELATIONSHIP MODELING

1. What is Normalization?
2. First Normal Form
3. Second Normal Form
4. Third Normal Form
5. Relationships
6. One to one relationships
7. One to many relationships
8. How to create an Entity Relationship Data Model
9. Data Integrity
10. Entity Integrity
11. Domain Integrity
12. Referential Integrity
13. How to enforce Referential Integrity
14. De-normalization

COURSE 2: SQL QUERY DEVELOPMENT

MODULE 1: THE SELECT STATEMENT

1. What is the SELECT statement?
2. How to eliminate duplicate rows in SELECT statements
3. How to sort or order results in SELECT statements
4. FROM clause
5. WHERE clause
6. GROUP BY clause
7. HAVING clause
8. WHERE clause
9. NULL, NOT NULL
10. AND, OR NOT
11. TOP clause
12. Identity / Auto-numbering fields

MODULE 2: COMPLEX QUERIES

1. What is a table join?
2. Inner Join, Left Outer Join, Right Outer Join, Cross Join, Self Join
3. UNION, UNION ALL
4. Aggregate Functions
5. Using the COUNT Function
6. Exploring the SUM, AVG Functions
7. Using the MIN, MAX Functions
8. INSERT, UPDATE, DELETE, TRUNCATE queries
9. Working with Subqueries
10. Using EXISTS, NOT EXISTS , ANY in Subqueries
11. Using Correlated Subqueries, Nested Subqueries
12. Working with more T-SQL Functions:
13. Using IsNumeric , ROUND, LEFT , RIGHT SUBSTRING, LEN Functions
14. Using REPLACE, STUFF, LOWER, UPPER, the LTRIM, RTRIM Functions
15. Using the LTRIM, RTRIM, GETDATE , MONTH, DAY, YEAR Functions
16. Using the DATEPART, DATENAME, DATEADD, DATEDIFF Functions
17. Using the ISNULL, COALESCE Functions

COURSE 3: DATABASE DEVELOPMENT

MODULE 1: CREATING THE DATABASE

1. Creating / dropping a database
2. Creating / dropping a table
3. Creating / dropping columns
4. Creating /dropping Primary keys & Foreign keys
5. Creating / dropping Indexes
6. Unique Indexes
7. Non-unique indexes
8. Creating / dropping Constraints
9. Unique constraints
10. Check constraints
11. Implementing Relationships
12. Creating / deleting relationships
13. Implementing Delete Rules, Update Rules

MODULE 2: WORKING WITH VIEWS

1. Implementing Views
2. Creating / dropping a view
3. Using Views to Secure Data
4. Modifying Data in a View
5. Modifying Views
6. Renaming Views
7. Deleting Views
8. Implementing Indexed Views
9. Implementing Clustered / Non-Clustered Views

MODULE 3: WORKING WITH FUNCTIONS & TRIGGERS

1. What is a Function?
2. Building and Working with User-Defined Functions
3. Scalar, Inline Table-Valued, Multi-Statement Table-Valued Functions
4. What is a Trigger?
5. Creating / deleting INSTEAD OF Triggers
6. When to use Triggers?

COURSE 4: DATABASE DEVELOPMENT

MODULE 1: STORED PROCEDURES

1. Designing a Stored Procedure in the Query Editor
2. Using T-SQL to Create a Stored Procedure
3. Declaring and Working with Variables
4. Input Parameters
5. Output Parameters
6. Controlling the Flow of Execution
7. Using IF … ELSE
8. Working with BEGIN … END
9. Exploring GOTO, RETURN, and Labels
10. Working with the CASE Statement
11. Exploring the WHILE Statement
12. The SET NOCOUNT Statement
13. Using the @@RowCount System Variable
14. Using the @@TranCount System Variable
15. Using the @@Identity System Variable
16. Using the SCOPE_IDENTITY()
17. Using the @@Error System Variable
18. Handling Runtime Errors
19. Returning Success and Failure Information from a Stored Procedure
20. What is a Transaction?
21. Types of Transactions
22. Implementing Transactions
23. Stored Procedures and Temporary Tables
24. Stored Procedures and Security

MODULE 2: SQL QUERY / STORED PROCEDURE OPTIMIZATION

1. Analyzing SQL Execution Plans
2. Analyzing Database Statistics
3. Index Analysis and Tuning
4. Stored Procedure Recompilation
5. Handling Blocking and Deadlocks

SQL Boot Camp - How Does It Work?

• You can register for SQL Training from any home or office location:

  • You can take your training from home or the office because your SQL Training will be available online through videos, a web-based learning management system (LMS) and SQL trainers who will help you gain critical, hands-on SQL, Database Design and Database Development project experience

• You gain improved database skills Or hands-on SQL expertise

  • After you enroll in SQL training, the web based training software creates a new training schedule for you and then sends you a personalized e-mail with links to your SQL videos or Database lessons, assignments or quizzes
  • You are assigned a number of days for each SQL training video, SQL quiz, SQL assignment or hands-on database design or development project. You may however complete your work earlier or later than scheduled based on your own schedule
  • You can submit your SQL projects back to a live SQL course instructor using a feature of the SQL training program
  • Your SQL course instructors review and grade each of your database projects or provide personalized help, assistance or corrective feedback
  • Your SQL skills are sharpened through multiple quizzes and your grades are automatically displayed in a secure, private online report card
  • Your understanding or progress at learning SQL is constantly monitored or evaluated and you are given various opportunities to practice as you learn!

• You Retain Access to SQL Training Videos After the Course Is Completed!

  • You retain FULL and PERMANENT access to ALL SQL training videos after training is completed
  • The SQL training videos will remain accessible through the "Resources" Menu on the training portal

• Online SQL Training Is Flexible, Convenient, Affordable

  • Yes, you are given ample time to complete each SQL training module including the SQL training videos or SQL practice tests or hands on SQL projects
  • Yes, you can login for SQL training at any time
  • Yes, you may pause your SQL training any time because of work or life commitments
  • Yes, you may pause your SQL training without any penalty
  • Yes, you do not have to begin or complete your SQL training at the same time as everyone else
  • Yes, you do not have to login at the same time as everyone else or at a specific time of the day or night
  • Yes, your SQL training is a "go at your own pace", anytime, anywhere, anypace training. Yes, you can take some of your training at work (during lunchtime) or at home (after dinner) or on the road (from your laptop)!

• No Entrance Examination Or Pre-requisite Courses Required

  • Your SQL training will walk you step by step ... from utter beginner to advanced level without any prior SQL background
  • Your SQL course instructors do not assume anything about your background, so you are taken through the basics and then taken to the advanced-level SQL courses
  • Your SQL training Videos are all hands-on, instructional videos ... which means that you learn by simply watching the SQL course instructors
  • The SQL training videos cover both theoretical topics and practical requirements for Database Design or Database Development or SQL Query Writing
  • You do not need extra time to prepare for SQL training before registering because all the preparation, foundational topics or pre-requisite knowledge is in-built and included as part of your SQL training courses

• You Determine The Pace Of Your SQL Training

  • Yes, you can accelerate or speed-up your SQL training or customize your SQL learning to suit your own study time
  • Yes, you can finish SQL training in more time or less time than the estimated duration
  • You can control your SQL training pace or customize it to your personal preferences. So you don't have to start or finish at the same time as everyone else

• SQL Boot Camp's Learning Management System (LMS) Shortens Your Learning Curve:

  • The scheduling, tracking, monitoring and management of all SQL Boot Camp's training content is done through modules in-built into the SQL training program

• You Don't Need To Install Additional Software Programs to Watch SQL Training Videos

  • You don't need to install additional software programs to view the SQL training videos online
  • SQL Boot Camp uses a web-based training system that allows you to view the SQL training videos anytime from any location
  • All the necessary software training features are already built into your SQL training system ... so, you don't need to mess around with tiresome software installations
  • ... And yes, that means you don't need to worry about browser requirements either!

Why Learn SQL Online - at - SQL Boot Camp?

• Courses are Available Anywhere, Anytime

  You may enroll for training from Tokyo, Japan or Calgary, Alberta, Canada or New York, USA or London, UK or from any city without having to travel.

  You can enroll from any location in the North America, Europe Africa, Australia, Asia, New Zealand, South America.

• Training is Affordable

  Attending a complete beginner to advanced, database development and SQL training class is expensive because of the breadth of topics involved.

  When you have to pay for Hotel + Food + Class Room Tuition Fees, the costs quickly add up!

  SQL Boot Camp offers you the complete step-by-step, beginner to advanced level SQL + Database training at a fraction of the traditional class room costs.

• Classes are Convenient

  You don't have to be out-of-office, miss work deadlines, personal commitments or fall behind at work.

  You may take your training during office breaks or at home in the evening hours. Whatever is convenient for you, works for us as well!

• Training is Career Focused

  Your SQL Training is designed to assist you on the job by matching the tasks, assignments or project that you'll be performing for your employer!

  You are guaranteed that additional skills gained after training are immediately relevant to your job and employer!

• Learn Practical Skills in a Hands-On Instructor-led Online Class

  Our hands-on, skill boosting courses help you learn quickly and benefit your organization immediately.

• "No Barriers" To Learning

  There are no barriers or obstacles to your learning or career advancement.

  We make no assumptions about your background or require pre-requisite courses. You're taken step-by-step, from the beginning to advanced level topics, so you get a comprehensive and detailed education.

• Boost Your Skills With Practice Sessions

  We facilitate your learning using multiple learning activities until new concepts become second nature.

  We use practice tests to boost retention, comprehension and recall of new information.

• Continuous Progress Feedback

  We continuously evaluate your progress and provide instant feedback, so you always know how you are doing.

  You progress, grades or transcript are accessible online, so you can check-up on your progress anytime.

• Private, One-to-One Coaching

  You get personalized, private coaching from your course instructors so, can't get lost in class.

  You may request additional help from course instructors at any time, over any topic at zero cost!

• Hands-On Training Ensures That "You Learn by Doing"

  We understand that you learn better, when your senses are engaged by doing.

  So, you get hands-on projects that build-up your skills and experience.

Here at last ... the affordable, convenient, effective training that delivers on career success for database professionals. so, sign-up now to get started.

Sign-Up For SQL Boot Camp ...