Video is locked.

Unlock the full course today

Join today to access over 15,000 courses taught by industry experts or purchase this course individually.

SQL Essential Training

ID columns

From the course: SQL Essential Training

Start my 1-month free trial
  • Course details

    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.

    This course was created by Bill Weinman. We are pleased to offer this training in our library.

    Instructor

    • Click here to view Bill Weinman’s instructor page

      Bill Weinman

      • Bill Weinman is a tech advocate, entrepreneur, and expert in a programming languages such as C++ and Python.

        Bill Weinman is the author of several books and online courses on the technical aspects of the World Wide Web. He has earned a reputation for his ability to explain complex topics in clear, concise terms. Mr. Weinman built his first computer in 1973, and has been involved with technology ever since. He has run a successful consulting practice, been a computer manufacturer, and most recently headed a hosting company. An accomplished guitarist, Bill performs and records music when he's not writing about computers. You can learn more about Bill, his projects and his music at http://bw.org/.

    Skills covered in this course

  • Understanding SQL

    - An ID column is a column that holds a unique value for each row in a table. Typically ID columns are automatically populated. The method for creating an ID column is not standardized. How you create an ID column is different for every database system. What I'm showing you here is how this works in SQLite, the database system we are using here. I'm showing you this, just so you have an idea of how this works, but know that the specific syntax will be different on different systems. So here we are using the test database again, and we're creating a table and dropping the table if exists, of course, and then inserting some rows into it. Let's take a look at this line here, now this is part of the create table statement. The create table statement is all of that, including everything in between the parenthesis. Between the parenthesis, we have the column definitions for each column. And the first column is named ID…

  • Practice while you learn with exercise files

    Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.

    Download the exercise files for this course. Get started with a free trial today.

  • Download courses and learn on the go

    Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.

    Watch this course anytime, anywhere. Get started with a free trial today.

Contents