Oswald Campesato - SQL Pocket Primer

Oswald Campesato - SQL Pocket Primer - 2022.epub

3.39 MB

Oswald Campesato - SQL Pocket Primer - 2022.mobi

7.71 MB

Oswald Campesato - SQL Pocket Primer - 2022.pdf

5.68 MB

Code/README.pdf

77.16 KB

Code/code/chapter1/minimal.sql

1.28 KB

Code/code/chapter2/account_receipts.sql

538 B

Code/code/chapter2/all_data.csv

305 B

Code/code/chapter2/all5.sql

186 B

Code/code/chapter2/ar_mytools.sql

399 B

Code/code/chapter2/courses.sql

543 B

Code/code/chapter2/customers_invoice.sql

133 B

Code/code/chapter2/customers.sql

405 B

Code/code/chapter2/employees.sql

359 B

Code/code/chapter2/item_desc.sql

304 B

Code/code/chapter2/japanese1.sql

826 B

Code/code/chapter2/line_items.sql

229 B

Code/code/chapter2/merge_all_data.py

208 B

Code/code/chapter2/mytools_create_tables.sql

711 B

Code/code/chapter2/mytools_drop_tables.sql

149 B

Code/code/chapter2/people_ages.sql

733 B

Code/code/chapter2/people.sql

382 B

Code/code/chapter2/purchase_orders_data.sql

46 B

Code/code/chapter2/purchase_orders.sql

159 B

Code/code/chapter2/schedule.sql

746 B

Code/code/chapter2/stored1.sql

276 B

Code/code/chapter2/students.sql

386 B

Code/code/chapter2/trigger1.sql

240 B

Code/code/chapter2/user_merged.csv

139 B

Code/code/chapter2/user_merged.py

227 B

Code/code/chapter2/user_merged2.csv

151 B

Code/code/chapter2/user_merged2.py

283 B

Code/code/chapter2/user_merged3.csv

269 B

Code/code/chapter2/user.csv

83 B

Code/code/chapter2/user2.csv

76 B

Code/code/chapter3/curr_exchange_rate.sql

558 B

Code/code/chapter3/currencies.sql

740 B

Code/code/chapter3/customers2.sql

692 B

Code/code/chapter3/heights.sql

741 B

Code/code/chapter3/japanese1.sql

826 B

Code/code/chapter3/japanese2.sql

515 B

Code/code/chapter3/japn_join.sql

121 B

Code/code/chapter3/olympics.sql

919 B

Code/code/chapter3/OlympicsJAPN2021.csv

325 B

Code/code/chapter3/revenue.sql

450 B

Code/code/chapter3/running_totals.sql

536 B

Code/code/chapter3/sold_items.sql

1.81 KB

Code/code/chapter3/sub_totals.sql

518 B

Code/code/chapter3/weather.sql

945 B

Code/code/chapter4/all4.sql

381 B

Code/code/chapter4/case_movies.sql

360 B

Code/code/chapter4/case_weather.sql

148 B

Code/code/chapter4/ceil_floor.sql

167 B

Code/code/chapter4/create_movies.sql

193 B

Code/code/chapter4/date-fields-formats.sql

547 B

Code/code/chapter4/is_null.sql

119 B

Code/code/chapter4/linear_regression.sql

1.17 KB

Code/code/chapter4/movie_ratings.sql

193 B

Code/code/chapter4/nlp_terms.sql

850 B

Code/code/chapter4/not_null.sql

122 B

Code/code/chapter4/Null_If.sql

61 B

Code/code/chapter4/recursive.sql

126 B

Code/code/chapter4/round_values.sql

287 B

Code/code/chapter4/split_float.sql

497 B

Code/code/chapter4/weather.sql

959 B

Code/code/chapter4/weather2.sql

413 B

Code/code/chapter5/create_fun_table.py

867 B

Code/code/chapter5/fugue1.py

505 B

Code/code/chapter5/mysql_conn1.py

317 B

Code/code/chapter5/mysql_pandas.py

617 B

Code/code/chapter5/pymongo1.py

215 B

Code/code/chapter5/read_sql_table.py

326 B

Code/code/chapter5/sql_query_excel.py

449 B

Code/code/chapter5/sql_query.py

321 B

Code/code/chapter5/sqlitereaddict1.py

553 B

Code/code/chapter5/sqlitesavedict1.py

328 B

Code/code/chapter6/account_receipts.sql

538 B

Code/code/chapter6/all6.sql

279 B

Code/code/chapter6/customers_json.sql

1.02 KB

Code/code/chapter6/double_number.sql

287 B

Code/code/chapter6/factorial.sql

603 B

Code/code/chapter6/my_stats_data.sql

1.21 KB

Code/code/chapter6/mytools.sql

77.32 KB

Code/code/chapter6/parent_child.sql

676 B

Code/code/chapter6/replace_null_values.sql

714 B

Code/code/chapter6/stored_function1.sql

507 B

Code/code/chapter6/stored1.sql

276 B

Code/code/chapter6/trigger1.sql

768 B

Code/code/chapter6/mytools-sql-files-20211120/mytools_abc.sql

2.05 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_abc2.sql

1.89 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_account.sql

2.83 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_ar_mytools.sql

2.06 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_average_val.sql

1.83 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_books.sql

2.08 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_child_tbl.sql

2.06 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_cities.sql

2 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_countries.sql

1.92 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_courses.sql

5.85 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_curr_exchange_rate.sql

2.13 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_currencies.sql

2.11 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_currency.sql

2.06 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_cust_history.sql

1.9 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_customer_json.sql

2.27 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_customers.sql

2.15 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_customers2.sql

2.34 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_emp_details.sql

2.02 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_employees.sql

1.98 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_fact_events.sql

2.09 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_fact_table.sql

2.08 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_for_fun.sql

1.86 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_friend_table.sql

2.02 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_FRIENDS.sql

1.98 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_FRIENDS2.sql

2.17 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_heights.sql

2.05 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_invoices.sql

2 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_item_desc.sql

1.95 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_japn_emps.sql

1.96 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_japn1.sql

2.21 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_japn2.sql

2.05 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_japn3.sql

2.01 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_JOIN_TBL.sql

1.8 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_json1.sql

1.95 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_line_items.sql

2.13 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_line_items2.sql

2.14 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_line3.sql

2.09 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_locations.sql

1.92 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_movie_ratings.sql

1.93 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_my_stats_data.sql

1.86 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_mytable.sql

1.98 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_new_items.sql

2.12 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_olympics.sql

2.22 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_parent_tbl.sql

1.91 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_pasta_prices.sql

1.91 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_people_ages.sql

1.89 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_people.sql

4.54 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_people2.sql

1.91 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_phone_numbers.sql

1.89 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_PIZZA.sql

1.77 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_purchase_orders.sql

1.99 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_purchase_orders2.sql

1.95 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_revenue.sql

2.02 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_routines.sql

10.11 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_sample.sql

1.82 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_schedule.sql

2.28 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_scores.sql

1.86 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_sentences.sql

1.9 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_simple_table.sql

1.97 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_sold_items.sql

2.4 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_split_float.sql

1.86 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_students.sql

2.12 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_TABLEA.sql

1.79 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_TABLEB.sql

1.79 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_temp_cust2.sql

2.1 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_temp_user.sql

1.82 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_temperatures.sql

1.9 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_user.sql

1.9 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_user2.sql

2.03 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_user3.sql

2.03 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_users_dates.sql

2.17 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_venues.sql

2.24 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_weath.sql

2.07 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_weather.sql

2.34 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_weather2.sql

2.35 KB

Code/code/chapter6/mytools-sql-files-20211120/mytools_weather3.sql

2.36 KB

Code/FIGURES/chapter5/Figure5-1.tiff

8.65 MB

Code/FIGURES/chapter5/Figure5-2.tiff

8.62 MB

Code/FIGURES/chapter6/Figure6-1.tiff

13.02 MB

Code/FIGURES/chapter6/Figure6-2.tiff

14.12 MB

资源详情

免责声明