MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

SQL Database for Beginners

Course Summary

Master SQL Database Creation and Development with Guru Martin Holzke. Use Your DB Skills to Create Mobile or Web Apps


  • +

    Course Syllabus

      • Course Introduction
    • Relational Databases
      • What are Databases?
      • What's the Role of Databases in Application Programming?
      • Tables and Relations
      • Primary and Foreign Keys and Other Constraints
      • Chapter 1 Lab
    • SQL Querying
      • What is Querying?
      • The ANSI SQL Standard
      • DML, DDL and More
      • Common Query Tools
      • Chapter 2 Lab
    • Your First Queries
      • The SELECT Statement
      • Limiting Output Columns
      • Formatting and Sorting Output
      • Column Aliases
      • Chapter 3 Lab
    • Filtering Your Results
      • The WHERE Clause
      • Creating a Filter Condition
      • Applying Multiple Filter Conditions
      • More Filter Operations
      • Chapter 4 Lab
    • Consolidating Your Data
      • Counting Records
      • Common Aggregate Functions: SUM, AVG, MIN, MAX
      • Do's and Don'ts When Consolidating
      • Union and Other Multiset Consolidations
      • Chapter 5 Lab
    • Grouping Your Data
      • The GROUP BY Clause
      • The HAVING Clause
      • Do's and Don'ts When Grouping
      • Chapter 6 Lab
    • Joining Tables
      • Table Aliases
      • Inner Joins
      • Outer Joins
      • Self Joins
      • Complex Multi Table Joins
      • Chapter 7 Lab
    • Subqueries
      • Filtering Using Subqueries
      • The EXISTS Clause
      • Subqueries as Alternative to Joins
      • Derived Tables
      • Chapter 8 Lab
    • Manipulating Your Data
      • The INSERT Statement
      • The UPDATE Statement
      • The DELETE Statement
      • Chapter 9 Lab
    • Transaction Control
      • What are Transactions
      • Initiating a Transaction
      • The COMMIT and ROLLBACK Commands
      • Chapter 10 Lab
    • Creating Database Objects and Adding Business Logic
      • Creating Tables
      • Creating and Using Views
      • Developing and Calling Stored Procedures
      • Implementing Triggers
      • Chapter 11 Lab
    • Lab Solutions
      • Lab Solutions


Course Fee:
USD 99

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management Community

Attended this course?

Back to Top

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top