Fundamentals of Relational Databases Training Class

Course ID: 12041

Fundamentals of Relational Databases Training Seminar

This course will teach the fundamentals of database design and provide an
education in Structured Query Language (SQL), the standard language used to
access database structure and data. Modern web applications use a back-end
database, usually a SQL-based tool. Learn the fundamentals of SQL, along with an
introduction to database design, which will allow you to work with any database
when building your web applications. We will be using MySQL as the basis for
this class, an open-source product that is gaining in popularity in the
industry.


	Agenda
	1. Introduction: Databases and the Web Overview The File System Databases and the ACID Test 2. An Overview of SQL The Role of SQL SQL History and Major DBMS Vendors 3. Relational Databases Queries and Recordsets 4. More about the Parts of Relational Databases Tables Primary Keys, Foreign Keys, and Relationships 5. Retrieving Data with SELECT Comparison Operators for the WHERE Clause Apostrophes in Database Text Calculated Columns: Doing Math in Select Statements Select Distinct Selecting All Columns 6. Data Manipulation: INSERT, UPDATE, DELETE INSERT Statements 7. UPDATE Statements 8. DELETE Statements 9. Data Retrieval: More About SELECT ORDER BY Aggregate Functions Extended WHERE Conditions 10. Fine-Tuning Aggregate Functions GROUP BY The HAVING Clause Exercise 9: Using GROUP BY and HAVING to Analyze Sales Data 11. Querying Data Across Tables Basic Joins 12. Reusing Queries as Views 13. Query Within A Query Subqueries 14. Database Definition SQL CREATE TABLE 15. Database Design Data Modeling Handling More than One Phone Number 16. Establishing a Primary Key Auto-numbered Columns 17. Relationships Between Tables Normalization Online Transaction Processing vs. Decision Support Restructuring Tables Renaming Tables or Columns Adding or Deleting Columns 18. Data Integrity: Controlling What Goes Into a Database Default Values Check Constraints Creating Foreign Keys 19. Many-to-Many Relationships Tying It All Together: Creating The Movies Database 20. Introduction to Transactions Diagram of the Relationships Among the Tables Table Data Types 21. Major SQL Statements 22. Advanced SQL and Database Design 23. Entity-Relationship Diagrams Text Functions Matching Patterns with LIKE Text Manipulation Functions Dates in SQL Server Conversion Functions Using Union to Combine Queries Transact-SQL's CASE Statement 24. A Review of Aggregate Functions GROUP BY HAVING WITH CUBE and WITH ROLLUP COMPUTE BY 25. Querying Data Across Tables Joins the ANSI-92 Way Outer Joins Self Joins 26. Subqueries Correlated Subqueries Performance Tuning Connecting to Data in Other Databases 27. Beginning Transact-SQL Programming Introduction to Stored Procedures Transactions in SQL Server Triggers 28. Entity-Relationship Diagrams 29. Create Table Statements


	Audience
	Those who need to understand relational databases and how they are designed and implemented.


	Pre-requisites
	PreReqs


	Comments
	For all course dates held in Canada, please add 5% GST to the course price. Canadian residents will need to add an additional 7% PST to the course price.

Bring this Fundamentals of Relational Databases training class in-house at your facility.

Request More Information On Fundamentals of Relational Databases

Fundamentals of Relational Databases Training Course Dates and Locations

Course ID: 12041 | Course Duration: 5 Days

Locations:

Request dates in your city
Bring this course on-site
Call us toll-free 1-866-540-9677 and we will find similar courses near you.

Bring this Fundamentals of Relational Databases training class in-house at your facility.

Request More Information On Fundamentals of Relational Databases




	Select a market segment to view more courses

	Or, select a category to view more Information Technology courses

	Browse By Category Browse By Location Browse New Courses