- What things should you avoid when naming database objects?
- What characters are allowed when naming database objects?
- What is the SQL syntax to create a new database?
- Where can you find SQL error codes in MySQL Workbench?
- What are natural and surrogate primary keys?
- How do you make a single-line comment?
- How do you make a multiline comment?
- What's the difference between a clustered and a nonclustered index?
- What is deadlocking?
- Does the order of columns in an index matter?
- Tech Categories
- Best Sellers
- New Releases
- Books
- Videos
- Audiobooks
Tech Categories Popular Audiobooks
- Articles
- Newsletters
- Free Learning
You're reading from Learn SQL Database Programming
Josephine Bush has over 10 years experience as a Database Administrator. Her experience is extensive and broad-based, including in financial, business, and energy data systems using MySQL, SQL Server, Oracle, and PostgreSQL. She is a Microsoft Certified Solutions Expert: Data Management and Analytics. She holds a BS in Information Technology, an MBA in IT Management, and an MS in Data Analytics.
Read more about Josephine Bush
Unlock this book and the full library FREE for 7 days
Author (1)
Josephine Bush has over 10 years experience as a Database Administrator. Her experience is extensive and broad-based, including in financial, business, and energy data systems using MySQL, SQL Server, Oracle, and PostgreSQL. She is a Microsoft Certified Solutions Expert: Data Management and Analytics. She holds a BS in Information Technology, an MBA in IT Management, and an MS in Data Analytics.
Read more about Josephine Bush