Course detailsKnowing 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.
- Every database system has it's own set of functions specifically tasked for handling dates and times. These functions are not standardized. In this lesson, I'll show you the date and time related functions for SQLite, the system we are using for the exercises. Keep in mind that the specific functions and syntax for your system will be different. This first statement returns a timestamp, the current date and time in the UTC timezone. So I'm going to go ahead and execute that now. A timestamp is a very common usage, and every system has a convenient way of finding the current time and date. The time and date returned is in UTC, seven hours later than my local time here in the US Pacific summer timezone. SQLite does not have specific types for dates and times. SQLite uses strings, so it makes sense that it uses a special string to indicate the current time with the parameter now in the DATETIME function. Passing this string…
Practice while you learn with exercise filesDownload 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.
Watch this course anytime, anywhere. Get started with a free trial today.