- #Cyber monday zoom video communications how to
- #Cyber monday zoom video communications update
- #Cyber monday zoom video communications software
Learn key ideas that help you design a database architecture for scale, including replication and sharding. Understand the differences between SQLite’s, MySQL’s, and PostgreSQL’s type systems and learn about the unique affordances of each. Take what you’ve learned in SQLite and apply it in the context of full-fledged database servers, including both MySQL and PostgreSQL. Finally, learn how databases consistently handle high volumes of (almost simultaneous!) requests, by using transactions, locks, and more.Ī live lecture on scaling applications with databases. Dive deeper into indexes by learning about B-trees, the underlying data structure that often powers database indexes.
#Cyber monday zoom video communications how to
Learn how to optimize your queries using indexes, which enable quicker look-ups on columns of your choice (at the expense of some space!). And get a taste of hows can be used both to secure data, as by removing personally identifiable information, or to implement “soft deletes” via which you can remove data from a view but keep it in an underlying table.Ī live lecture on optimizing databases.
Use views to create aggregate statistics (e.g., minimum, maximum, mean) from underlying data points. Learn how to use views to simplify your queries across multiples tables and to see data from disparate tables in a single virtual table.
#Cyber monday zoom video communications update
Learn, too, how to create “triggers,” via which you can automate the execution of SQL statements upon an insertion, deletion, or update of some table.Ī live lecture on creating views of a database. Learn how to insert data manually or import data from a given CSV file how to perform updates that clean and correct your data and how to delete data while managing constraints across tables. Learn to create tables that effectively model real-world systems (a subway system, for instance!) to strategically apply constraints, via which you can ensure the integrity of data and to alter the design of your database as your system changes.Ī live lecture on writing to databases, which includes inserting, updating, and deleting data. You’ll learn about keys, both primary and foreign, via which you can reference data across tables joins and nested queries, via which you can write queries that span multiple tables and groups, via which you can aggregate data into categories.Ī live lecture on designing database schemas to better organize your data.
#Cyber monday zoom video communications software
You’ll learn about tables, via which databases can store information database engines, which are the software via which you can interact with databases and SQL, the language via which you can write queries to answer questions about tables of data in a database.Ī live lecture on relating data across tables in a database. In the meantime, the recordings of the course’s live lectures are available below! Lecture 0 QueryingĪ live lecture on querying databases. In the meantime, the recordings of the course’s live lectures are available below! Lecture 0 Securing Accountsīelow are recordings of CS50’s Introduction to Databases with SQL, a new course that will be available by October 1, 2023, at /sql and /sql. CS50’s next live classes will be in September 2023, if not sooner! CS50 Cybersecurityīelow are recordings of CS50’s Introduction to Cybersecurity, a new course that will be available by October 1, 2023, at /cybersecurity and /cybersecurity. GitHub Instagram LinkedIn ORCID Quora Reddit TikTok Telegram Twitterīelow are recordings of CS50’s most recent Zoom meetings. This is CS50 CS50’s Introduction to Computer Scienceĭavid J.
0 kommentar(er)
