Robot handyman with hand wrench light bulb. Fixing maintenance concept. Creative design mechanic toy character. Orange wall, light floor background. Copy space
0 student

Knowing how to code and manage relational databases and database-driven applications is a valuable skill for any career in tech. Completely updated for 2019, SQL Essential Training is designed to help users understand the most common language for database wrangling, SQL. All the lessons have been recorded in SQLiteStudio, an intuitive and easy-to-install database manager. Instructor Bill Weinman teaches all the major features of SQL: creating tables; defining relationships; manipulating strings, numbers, and dates; using triggers to automate actions; and using subselects and views. He offers a solid working knowledge of the language and shows how to retrieve and manage data efficiently. The final chapter includes a real-world example of building a simple application using SQL.

    Learning objectives

  • How databases are organized
  • Selecting rows and columns
  • Creating new tables
  • Inserting and updating data
  • Sorting and filtering
  • Accessing related tables with JOIN
  • Working with strings
  • Understanding numeric types
  • Using aggregate functions and transactions
  • Automating data with triggers
  • Creating views
  • Using CRUD functions

Course Rating

0.00 average based on 0 ratings

Star
0%
Star
0%
Star
0%
Star
0%
Star
0%
Robot handyman with hand wrench light bulb. Fixing maintenance concept. Creative design mechanic toy character. Orange wall, light floor background. Copy space
Course Preview
  • Price
    ₹20,000.00 ₹5,000.00
  • Duration 2 weeks
  • Lesson 48

More Courses You Might Like

₹4,990.00

Online Marketing Foundations

Learn how to promote your business effectively online and develop a targeted online marketing strategy that engages potential customers throughout the digital landscape. . .

Robot handyman with hand wrench light bulb. Fixing maintenance concept. Creative design mechanic toy character. Orange wall, light floor background. Copy space
₹20,000.00 ₹5,000.00

Android Studio Essential Training

Knowing how to code and manage relational databases and database-driven applications is a valuable skill for any career in tech. . .

Funny glass head ufo robot on a violet green background. Futuristic robot humanoid toy with raised hand. Copy space.
₹11,990.00

Android Development Essential Training: Your First App with Kotlin

Explore the world of Android app development. The Android Development Essential Training series. . .